中文名 | 属性名 | 属性 | 主键 | 外键 | 可为空 |
订单编号 | Order ID | Varchar (16) | Y |
| NO |
商品编号 | Product ID | Varchar (16) |
| Goods.ProductID | NO |
品牌 | Product Brand | Varchar (16) |
|
| NO |
单价 | Product Unit Price | Int (16) |
|
| NO |
数量 | Product Count | Int (16) |
|
| NO |
实付款 | Product Price | Int (16) |
|
| NO |
订单类型(0为环保回收订单, 1为手机数码,2为家电乐器, 3为礼品回收,4为大件回收, 5为商品回收表) | Order Type | Int (2) |
|
| NO |
订单时间 | Order Time | Date |
|
| NO |
订单状态 | Order State | Int (2) |
|
| NO |
用户编号 | User ID | Varchar (32) |
| User.UserID | NO |