社会科学研究方法 林聚任

etimeРdatetimeР8РyesР注册时间РRegIpAddrРvarcharР20РyesР注册ipРIDРintР4Р自动编号,会员编号РusernameРvarcharР4РnoР用户名РpasswordРvarcharР100РnoР密码РNamesРintР4РyesР会员级别РSexРvarcharР50РyesР名字РAddrРvarcharР50РyesР地址РPhoneРvarcharР25РyesР电话РPostРvarcharР25РyesР邮编РEmailРvarcharР25РyesР邮箱РRetimeРdatetimeР8РyesР注册时间РRegIpAddrРvarcharР20РyesР注册ipР表3.3为订单表,记录订单信息orders。Р表3.3订单信息表ordersР字段名Р数据类型Р长度Р允许空Р说明РIDРintР4РyesР自动编号,订单编号Рorder_idРintР4РyesР会员编号Рuser_idРintР4РyesР图书编号РquantityРintР4РyesР订购数量Рsubmit_timeРdatetimeР8РyesР提交订单时间РconsignmentTimeРdatetimeР8РyesР交货时间РtotalpriceРfloatР8РyesР总价РcontentРvarcharР20РyesР备注РipAddrРvarcharР20РyesР用户ipРisPayoffРintР11РyesР是否付款РisSaleРintР11РyesР是否发货Р表3.4为订单列表,记录订单列表信息allorder。Р表3.4 订单列表allorder Р字段名Р数据类型Р长度Р允许空Р说明РIDРintР4Р自动编号,卡类型编号РorderIDРintР11РyesР订单号РBookNoРintР11РyesР书号