交友网站数据库设计.pdf下载

[weixin_39821051]

˚¿Ł…˘ : 1¡¢ ˆ»§– (Users) £"ˆ· ¯¢ ƈ»§—¯ˇ¢¡£ 2¡¢ "ˆ ˇ– (Friends): ˆ…˙´…"ˆ—¯ˇ¢¡£ 3¡¢ ˘ – (Pic): ˆ· ¯ˇ·«˘ —¯ˇ¢¡£ 4¡¢ ˚˘– (Video): ˆ· ¯ˇ·«˚˘—¯ˇ¢¡£ 5¡¢ ¶ – (Dynamic): ˆ· ¯ˆ»§ ¢–˜¶ ¡£ 6¡¢ ¶ ª– (Like): ˆ· ¯ˆ»§¶ ª˙Ø¿¡£ 7¡¢ ¶ ˘´– (Comment):ˆ…˙´…¶ ˜˘´—¯ˇ¢¡£ 8¡¢ ¶¸»¶ – (Act): ˆ· ¯ ¢ …»¶ —¯ˇ¢¡£ 9¡¢ ˛…»¶ – (Join): ˆ· ¯ˆ»§˚˙ æ ˛…»¶ ¡£ ˆ»§– (Users) ¶˛ˆß —˝ ¸ˆ ˆ»§–"¯ Uid nvarchar (20) …£ ˚—ˆß Name nvarchar(80) ˙¿ Œ˙ ˘ Nick nvarchar(80) ˝ ˇæ Portrait Image ˚»œ Phone nvarchar (14) ˙¿ ˚ˇ Email nvarchar(20) ˆ´º Psw nvarchar(16) ˙¿ —– Sex nvarchar(2) ˙¿ œ¨ Birthday Int œ´ Birthmonth Int œ˜Œ Birthyear Int ˚¡ Province nvarchar(20) §—£ School nvarchar(20) ˙¿ ¤ Profession nvarchar(20) ˙¿ ¨º§˜Œ Startyear int(6) ˙¿ Height double weight double "ˆ Hobby nvarchar(30) ¨¸ Ø Introduction nvarchar(150) ˚˙ æ «¿" Open nvarchar(10) «¿"£ "ˆ¿…ߣ » " ˆ ˛˚ ˚– … Lasttime nvarchar(20) "ˆ ˇ– (Friends) ¶˛ˆß —˝ ¸ˆ ˆ»§–"¯ Uid nvarchar(20) …£ ˝… "ˆ–"¯ Fid nvarchar(20) …£ ˝… ˘ – (Pic) ¶˛ˆß —˝ ¸ˆ ˘ –"¯ Pid nvarchar (50) …£ ˘ ˆß ˘ Name nvarchar(50) ˇ·«ˆ»§–"¯ Uid nvarchar(20) ˝… ˘ ´ ¶ Path nvarchar(40) ˇ·« IP Ip nvarchar(80) ˇ·«˚–… Loadtime datetime ˚˘– (Video) ¶˛ˆß —˝ ¸ˆ ˚˘–"¯ Vid nvarchar(40) …£ ˚˘ˆß ˘ Name nvarchar(20) ˇ·«ˆ»§–"¯ Uid nvarchar(20) ˝… ˚˘´ ¶ Path nvarchar(40) ˇ·« IP Ip nvarchar(80) ˇ·«˚–… Loadtime datetime ¶ – (Dynamic) ¶˛ˆß —˝ ¸ˆ ¶ –"¯ Did nvarchar(60) …£ ˆ»§–"¯ Uid nvarchar(20) ˝… ˇ·« IP nvarchar(80) ˇ·«˚–… Loadtime datetime ¶ ª– (Like) ¶˛ˆß —˝ ¸ˆ ¶ –"¯ Did nvarchar(12) …£ ˝… ªˆ»§–"¯ Lid nvarchar(20) …£ ˝… ¶ ˘´– (Comment) ¶˛ˆß —˝ ¸ˆ ˘´–"¯ Cid nvarchar(100) …£ ¶ –"¯ Did nvarchar(60) ˝… ˘´–"¯ Uid nvarchar(20) ˝… ˘´˜¨ Content nvarchar(150) ˘´ IP Ip nvarchar(80) ˘´˚–… Time datetime ¶¸»¶ – (Act) ¶˛ˆß —˝ ¸ˆ »¶ –"¯ Aid int(4) …£ »¶ ˆß ˘ Name nvarchar(20) ¢ …˚–… Time datetime ˛…»¶ – (Join) ¶˛ˆß —˝ ¸ˆ »¶ –"¯ Aid int(4) …£ ˝… ˛…ˆ»§–"¯ Uid nvarchar(20) …£ ˝… E-R˝…£" ˚…`"ˇ˜˚—¨ˇ´£" ˆ»§£"ˆ»§–"¯£ ˚—ˆß£ Œ˙ ˘£ ˝ ˇæ£ ˚»œ£ ˚ˇ£ ˆ´º£ —–£ œ¨˘£ ˚¡ £ §—££ ¤£ ¨º§˜Œ £ £ £ "ˆ£ ¨¸ Ø£ ˚˙ æ «¿"£ " ˆ˛˚˚–…£» ˇ–£"ˆ»§–"¯£ "ˆ–"¯£» ˘ , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372098?utm_source=bbsseo