数据库表设计 用户帐号表:members id int primary_key auto_increased uid int primary_key password varchar(20) 用户资料表:member_data id int primary_key auto_increased uid int frogein_key_reference members.uid userName varchar(15) address varchar(50) sex int age int birthday data userLevel int looks int desc i nt 好友表:frends id int primary_key auto_increased 好友留言表:message sendUid int recvUid int content varchar(100) time date 系统广播表:broadcast uid int content varchar(100) time date 注:发送广播信息,如果用户不在线,将广播信息存储在此表中,等用户上线后在发送 在线用户表:online uid int status int uptime date ipAddr varchar(20) 注:记录用户状态。当用户上线,下线,更改状态时,此表需要更新。 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:25 , Processed in 0.179089 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.