聊天软件数据库设计.doc
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
表结构 数据库表结构设计方案,仅供参考 User用户表( User(--用户表 " " " " " "字段 "字段类型 "字段描述 "备注 " "U_ID "Int " "主键、自增 " "U_LoginID "Varchar(20 "(登陆账号) " " " ") " " " "U_NickName "Varchar(20 "(昵称) " " " ") " " " "U_PassWord "Varchar(20 "(密码) " " " ") " " " "U_SignaTure "Varchar(150"(个性签名) "Null " " ") " " " "U_Sex "Bit "(性别) "Null " "U_Birthday "Datetime "(生日) "Null " "U_Telephone "Varchar(30 "(电话) "Null " " ") " " " "U_Name "Varchar(30 "(真实姓名) "Null " " ") " " " "U_Email "Varchar(50 "(邮箱) "Null " " ") " " " "U_Intro "Varchar(300"(简介) "Null " " ") " " " "U_HeadPortrait "Varchar(100"(头像) " " " ") " " " "U_ShengXiao "Char(2) "生肖 "Null " "U_Age "Int "年龄 "Null " "U_Constellation "Char(6) "星座 "Null " "U_BloodType "Varchar(10 "血型 "Null " " ") " " " "U_SchoolTag "Varchar(50 "毕业学校 "Null " " ") " " " "U_Vocation "Varchar(30 "(职业) "Null " " ") " " " "U_NationID "Int "(国家ID) "外键 " "U_ProvinceID "Int "(省份ID) "外键 " "U_CityID "Int "(城市ID) "外键 " "U_FriendshipPolicy"Int "好友策略ID "外键 " "ID " " " " "U_UserStateID "Int "(用户状态ID) "外键 " "U_FriendPolicyQues"Varchar(30) "好友策略问题 "Null " "tion " " " " "U_FriendPolicyAnsw"Varchar(30 "好友策略答案 "Null " "er ") " " " "U_FriendPolicyPass"Varchar(30 "好友策略密码 "Null " "word ") " " " ) UserState(--用户状态表 "字段 "字段类型 "字段描述 "备注 " "US_ID "Int "(ID) "主键 " "US _Name "Varchar(10) "(状态名字) " " " " " " " ) Friends(--好友表 "字段 "字段类型 "字段描述 "备注 " "F_ID "Int "主键ID "主键 " "F_FirendID "Int "朋友的ID "外键 " "F_UserID "Int "自己的ID "外键 " "F_Name "Varchar(30) "备注昵称 "Null " "F_FriendTypeID "Int "(好友类型) "外键 " "F_FriendGroupsID"Int "(所属分组ID) "外键 " " " " " " ) User_FriendshipPolicy(--添加好友策略 "字段 "字段类型 "字段描述 "备注 " "U_FP_ID主键 "Int "策略ID "主键 " "U_FriendshipPol"varchar "好友添加方式 " " "icy " " " " ) FriendGroups(--好友分组表 "字段 "字段类型 "字段描述 "备注 " "FG_ID "Int "(分组ID) "主键 " "FG_Name "Varchar "(分组名字) " " "FG_UserID "Int "用户ID "外键 " ) FriendType (--好友类型 "字段 "字段类型 "字段描述 "备注 " "FT_ID "Int "(类型ID) "主键 " "FT_Name "Varchar(20) "(类型名称) " " ) Messages(--聊天记录表 "字段 "字段类型 "字段描述 "备注 " "M_ID "Int "(消息ID) "主键,自增 " "M_PostMessages "Text "(消息内容)
- 粉丝: 84
- 资源: 9357
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 微软常用运行库 游戏运行库 VC++各个版本
- 微信小程序开发教程.pptx
- MyBatis动态SQL是一种强大的特性,它允许我们在SQL语句中根据条件动态地添加或删除某些部分,从而实现更加灵活和高效的数据
- 锐捷网络认证中心网络管理.pdf
- MyBatis动态SQL是一种强大的特性,它允许我们在SQL语句中根据条件动态地添加或删除某些部分,从而实现更加灵活和高效的数据
- SD8233LF是一款用于单按键触摸及接近感应开关,其用途是替代传统的机械型开关芯片IC
- 基于YOLOv5的烟雾火焰检测算法研究
- 基于STM32的联合调试侦听设备解决方案原理图PCB源文件调试工具视频(大赛作品)
- MyBatis动态SQL是一种强大的特性,它允许我们在SQL语句中根据条件动态地添加或删除某些部分,从而实现更加灵活和高效的数据
- MyBatis动态SQL是一种强大的特性,它允许我们在SQL语句中根据条件动态地添加或删除某些部分,从而实现更加灵活和高效的数据