P66

-- orders創(chuàng)建

create table orders(

orderId bigint comment '訂單id',

orderNo string comment '訂單編號(hào)',

shopId bigint comment '門(mén)店id',

userId bigint comment '用戶id',

orderStatus tinyint comment '訂單狀態(tài) -3：用戶拒收 -2：未付款的訂單 -1：用戶取消 0：待發(fā)貨 1：配送中 2：用戶確認(rèn)收貨',

goodsMoney double comment '商品金額',

deliverMoney double comment '運(yùn)費(fèi)',

totalMoney double comment '訂單金額（包括運(yùn)費(fèi)）',

realTotalMoney double comment '實(shí)際訂單金額（折扣后金額）',

payType tinyint comment '支付方式，0：未知；1：支付寶；2：微信；3：現(xiàn)金；4：其他',

isPay tinyint comment '是否支付 0：未支付 1：已支付',

userName string comment '收件人姓名',

userAddress string comment '收件人地址',

userPhone string comment '收件人電話',

createTime timestamp comment '下單時(shí)間',

payTime timestamp comment '支付時(shí)間',

totalPayFee int comment '總支付金額'

) row format delimited fields terminated by '\t';

-- users表創(chuàng)建

create table users(

userId int,

loginName string,

loginSecret int,

loginPwd string,

userSex tinyint,

userName string,

trueName string,

birthday date,

userPhoto string,

userQQ string,

userPhone string,

userScore int,

userTotalScore int,

userFrom tinyint,

userMoney double,

lockMoney double,

createTime timestamp,

payPwd string,

rechargeMoney double

) row format delimited fields terminated by '\t';