阅读( 1 ) 我要纠错

数据表:ims_yz_consignment_settlement_record(寄售商品-结算记录表)。

字段类型默认值约束说明
idbigint unsigned-非空、自增
uniacidinteger-非空
member_idinteger-非空用户id
exchange_voucher_namestring(255)--兑换券名称
pricefloat0.00非空寄售价格
settlement_pricefloat0.00非空结算金额
service_chargefloat0.00非空平台服务费
member_exchange_voucher_idinteger-非空用户兑换券id
exchange_voucher_idinteger-非空兑换券id
exchange_voucher_snstring(255)-非空兑换券序号
order_idinteger-非空订单id
order_snstring(255)-非空订单sn
goods_idinteger-非空商品id
statusboolean0非空状态:-1=失效,0=未结算,1=已结算
created_atinteger--
updated_atinteger--
deleted_atinteger--
settlement_timeinteger--结算的时间
finish_timeinteger--完成结算的时间
×