[]电子商务网数据字典

quests16个字段)VARCHAR10NNN城市cityVARCHAR12NNN联系电话telVARCHAR40NNN联系地址addressVARCHAR100NNN邮编postVARCHAR6NNN备注attribTEXTNYN订单金额feeDECIMAL(16,2)NNN付款方式payTINYINTNNN发货标识sendoutTINYINTNNN付款标识paymentTINYINTNNN订单日期date_createdDATETIMENNN商品表说明:性别(sex):0--势1一女付款方式:以数组形式存放在conf/config.php文件中;用户资料表(user21个字段)字段意义字段名称类型长度唯一空关键编号idINTUNSIGNEDYNY用户账号unameVARCHARBINARY16NNN密码u_passVARCHARBINARY16NNN用户姓名nameVARCHAR20NNN性别sexTINYINTNNN邮箱emailVARCIIAR60NNN省份provinceVARCHAR10NNN城市cityVARCHAR12NNN联系电话telVARCHAR40NNN联系地址addressVARCHAR100NNN邮编postVARCHAR6NNN备注attribTEXTNYN证件名称paper_nameVARCHAR6NYN证件号码paper_numVARCHAR25NYN执照编号zzbhVARCHAR100NYN开户行khhhVARCHAR100NYN开户账号khzhVARCHAR100NYN注册日期regdateDATETTMENNN上次登录口期lastdateDATETIMENNN登录次数timesINTUNSIGNEDNNN账号状态actionenuin('y‘,'n‘)NYN用户资料表说明:1.存放用户的相关信息账号状态:用以确定用户是否能够使用账号