用戶數(shù)據(jù)字典

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聯(lián)系人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企業(yè)會員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公司規(guī)模13.cqualityvarchar公司性質(zhì)14.tradevarchar公司行業(yè)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凍結(jié)金額11withdrawmoneydouble提現(xiàn)金額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); 用戶積分財富統(tǒng)計表Table Nametb_user_ statisticsTable Desc.用戶積分統(tǒng)計表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2iidINT積分財富id3tabINT區(qū)分財富或積分4typeINT類型5numsINT數(shù)量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凍結(jié)7提現(xiàn) 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狀態(tài)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,); 企業(yè)會員表Table Nametb_companyvipTable Desc.企業(yè)會員表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1idYNotINTID2titleVARCHAR名稱3moneyDOUBLE會員費用4employeesINT子賬號個數(shù)5freecountINT免費下載次數(shù)6YearINT服務年

21、7statusINT狀態(tài)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.企業(yè)會員情況表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.TableRef.Field1uidYNotINTId2ramainnumINT剩余下載次數(shù)3downloadnumINT已下載次數(shù)4statusINT狀態(tài)，是否過期5levenINT級別，名企，普企6starttimeTIMESTAMP開始時間7endtimeDATET

23、IME結(jié)束時間8employeeINT已創(chuàng)建子賬號個數(shù)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普通企業(yè)，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狀態(tài)，是否過期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(); 用戶提現(xiàn)表Table Nametb_user_ withdrawTable Desc.用戶提現(xiàn)表PreparedPageCompanyDepartmentDate1ModuleRemarkSeq.Field NamePri. KeyNullDate TypeLen.Field Desc.Oth.DefinitionRef.