用户数据字典

1、前台用户表Table Nametb_userTable Desc.前台用户表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1.user_idYNotINTUID2.loginnameCHAR32登录帐号/手机号3.passwordVARCHAR64登录密码4.nicknameVARCHAR64账户昵称5.logoVARCHAR100头像地址6.utypeTINYINT帐号类型7.puid

2、INT父级用户id8.attstatusTINYINT是否启用9.logintimeDATETIME最近登录时间10.lastloginDATETIME上次登录时间11.createtimeTIMESTAMP注册时间12.emailvarchar邮箱13.qqvarcharQQ14.wechatvarchar微信15.gendervarchar性别16.cityvarchar城市17.phonevarchar电话18.levenINT充值等级19.vipINT标注会员20.LinkmanVarchar联系人SQLdrop table if exists tb_user;create table

3、 tb_user(user_id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,loginnameCHAR(32) NOT NULL,#手机号等passwordVARCHAR(64) NOT NULL DEFAULT ,nicknameVARCHAR(64) NOT NULL DEFAULT ,logo VARCHAR(100) NOT NULL DEFAULT ,utypeTINYINT NOT NULL DEFAULT 1, #1普通会员 2企业会员puidINT NOT NULL DEFAULT 0, attstatusINT NOT NULL DEFA

4、ULT 0, #0启用1禁用logintime DATETIME, lastlogin DATETIME,createtime TIMESTAMP DEFAULT now(),leven INT NOT NULL DEFAULT 0,vip INT NOT NULL DEFAULT 0, #0普通用户 1个人vip phone varchar(100) NOT NULL DEFAULT );ALTER TABLE tb_user AUTO_INCREMENT = 100001;CREATE INDEX index_tbuser_up on tb_user(utype,puid); 前台用户信息

5、表Table Nametb_user_infoTable Desc.前台用户信息表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1.user_idYNotINTUID2.emailvarchar邮箱3.qqvarcharQQ4.wechatvarchar微信5.gendervarchar性别6.cityvarchar城市7.deptvarchar部门8.rolevarchar角色9.in

6、trovarchar备注10.telephonevarchar固定电话11.caddressvarchar公司地址12.cscalevarchar公司规模13.cqualityvarchar公司性质14.tradevarchar公司行业SQLdrop table if exists tb_user_info;create table tb_user_info(user_id INT PRIMARY KEY NOT NULL, email varchar(200) NOT NULL DEFAULT COMMENT 邮箱, qq varchar(12) NOT NULL DEFAULT COMME

7、NT QQ, wechat varchar(30) NOT NULL DEFAULT COMMENT 微信, gender varchar(1) NOT NULL DEFAULT COMMENT 性别, city varchar(100) NOT NULL DEFAULT COMMENT 城市,dept varchar(100) NOT NULL DEFAULT ,role varchar(100) NOT NULL DEFAULT ,intro varchar(100) NOT NULL DEFAULT ,telephone varchar(100) NOT NULL DEFAULT ,ca

8、ddress varchar(100) NOT NULL DEFAULT ,cscale varchar(100) NOT NULL DEFAULT ,cquality varchar(100) NOT NULL DEFAULT ,trade varchar(200) NOT NULL DEFAULT ); 用户操作日志表Table Nametb_logs_ userTable Desc.用户操作日志表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.O

9、th.DefinitionRef.TableRef.Field1.idYNotINTID2.user_idINT操作uid3.optypeINT操作类型4.contentVARCHAR200描叙5.optimeTIMESTAMP操作时间SQLdrop table if exists tb_logs_user;create table tb_logs_user(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,user_idINT NOT NULL DEFAULT 0,optypeCHAR(20) NOT NULL DEFAULT ,content VARCH

10、AR(200) NOT NULL DEFAULT ,optime TIMESTAMP DEFAULT now();CREATE INDEX index_tblogsuser_u on tb_logs_user(user_id);CREATE INDEX index_tblogsuser_t on tb_logs_user(optype);用户消息通知表Table Nametb_user_messageTable Desc.用户消息通知表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate Typ

11、eLen.Field Desc.Oth.DefinitionRef.TableRef.Field1.idYNotINTID2.user_idINT操作uid3.optypeCHAR操作类型4.contentVARCHAR200描叙5.statusTINYINT6.optimeTIMESTAMP操作时间SQLdrop table if exists tb_user_message;create table tb_user_message(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,user_idINT NOT NULL DEFAULT 0,optypeC

12、HAR(20) NOT NULL DEFAULT ,content VARCHAR(200) NOT NULL DEFAULT , status TINYINT NOT NULL DEFAULT 1,optime TIMESTAMP DEFAULT now();CREATE INDEX index_tbusermessage_u on tb_user_message(user_id,optype);CREATE INDEX index_tbusermessage_s on tb_user_message(status);用户积分财富表Table Nametb_user_integralTabl

13、e Desc.用户积分财富表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2user_idINT用户id3integralINT积分4wealthDOUBLE财富5workintdouble文档所得积分6expenseintINT下载花费积分7registerintINT注册积分8signintINT签到积分9rechargeintINT充值积分10freezem

14、oneyDOUBLE冻结金额11withdrawmoneydouble提现金额SQLdrop table if exists tb_user_integral;create table tb_user_integral(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,user_idINT NOT NULL DEFAULT 0,integralINT(11) NOT NULL DEFAULT 0,wealth double(11,3) NOT NULL DEFAULT 0.000, workint double(11,3) NOT NULL DEFAULT

15、0.000,expenseint INT NOT NULL DEFAULT 0,registerint INT NOT NULL DEFAULT 0,signint INT NOT NULL DEFAULT 0,rechargeint INT NOT NULL DEFAULT 0,freezemoney double(11,3) NOT NULL DEFAULT 0.000,withdrawmoney double(11,3) NOT NULL DEFAULT 0.000);CREATE INDEX index_tbuserintegral_u on tb_user_message(user_

16、id); 用户积分财富统计表Table Nametb_user_ statisticsTable Desc.用户积分统计表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2iidINT积分财富id3tabINT区分财富或积分4typeINT类型5numsINT数量6contentVARCHAR描述7createtimeTIMESTAMP操作时间SQLdrop tab

17、le if exists tb_user_statistics;create table tb_user_statistics(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,iid INT NOT NULL DEFAULT 0,tab INT NOT NULL DEFAULT 0,#0积分 #1财富值type INT NOT NULL DEFAULT 0,#1签到，2充值，3注册，4下载5文档6冻结7提现 nums INT NOT NULL DEFAULT 0,content VARCHAR(200) NOT NULL DEFAULT ,createti

18、me TIMESTAMP DEFAULT now();CREATE INDEX index_tbuserstatistics_u on tb_user_message(iid); 个人会员表Table Nametb_personalvipTable Desc.个人会员表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2titleVARCHAR名称3moneyDOUB

19、LE会员费用4integralINT赠送积分5statusINT状态6yearINT服务年SQLdrop table if exists tb_personalvip;create table tb_personalvip(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,title VARCHAR(200) NOT NULL DEFAULT ,money DOUBLE(11,2) NOT NULL DEFAULT 0.00,integral INT NOT NULL DEFAULT 0, status INT NOT NULL DEFAULT 0, #0启

20、用 #1禁用year INT NOT NULL DEFAULT 1,); 企业会员表Table Nametb_companyvipTable Desc.企业会员表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2titleVARCHAR名称3moneyDOUBLE会员费用4employeesINT子账号个数5freecountINT免费下载次数6YearINT服务年

21、7statusINT状态SQLdrop table if exists tb_companyvip;create table tb_companyvip(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,title VARCHAR(200) NOT NULL DEFAULT ,money DOUBLE(11,2) NOT NULL DEFAULT 0.00,integral INT NOT NULL DEFAULT 0, status INT NOT NULL DEFAULT 0, #0启用 #1禁用year INT NOT NULL DEFAULT 1,)

22、; 会员情况表Table Nametb_user_vipinfoTable Desc.企业会员情况表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1uidYNotINTId2ramainnumINT剩余下载次数3downloadnumINT已下载次数4statusINT状态，是否过期5levenINT级别，名企，普企6starttimeTIMESTAMP开始时间7endtimeDATET

23、IME结束时间8employeeINT已创建子账号个数SQLdrop table if exists tb_user_vipinfo;create table tb_user_vipinfo(uid INT PRIMARY KEY NOT NULL,ramainnumINT NOT NULL DEFAULT 0,downloadnumINT NOT NULL DEFAULT 0,leven INT NOT NULL DEFAULT 0, #0普通企业，1名企 status INT NOT NULL DEFAULT 0, #0启用 #1禁用starttime TIMESTAMP NOT NULL

24、 DEFAULT now(),endtime DATETIME DEFAULT NULL,employee INT NOT NULL DEFAULT 0); 我的分享(推广)Table Nametb_user_shareTable Desc.分享表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTId2uidINT邀请人id3buidINT被邀请人id4createtim

25、eTIMESTAMP状态，是否过期SQLdrop table if exists tb_user_share;create table tb_user_share(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,uid INT NOT NULL DEFAULT 0,buid INT NOT NULL DEFAULT 0,createtime TIMESTAMP NOT NULL DEFAULT now(); 用户提现表Table Nametb_user_ withdrawTable Desc.用户提现表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.