修订记录

| 版本号 | 修订记录 |修订人 | 修订时间|
| -------- | -------- | -------- |-------- |
| V1.0 | 创建初始文档 | 郭越智 | 2019-07-25|

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |bigint(20) | | |
|order_no |varchar(100) | | |
|user_id |int(11) | | |
|seckill_id |bigint(20) | | |
|product_id |bigint(20) | | |
|product_sku_id |bigint(20) | | |
|product_sku_msg |text | | |
|type |int(11) | | |
|cash |decimal(10,2) | | |
|price |decimal(10,2) | | |
|score |int(11) | | |
|num |int(11) | | |
|freight |int(11) | | |
|consignee |text | | |
|express_msg |text | | |
|pay_type |int(11) | | |
|state |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |
|score_flag |int(11) | | |

3、msw_mall_product

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |bigint(20) | | |
|name |varchar(255) | | |
|union_id |int(11) | | |
|pic |varchar(255) | | |
|pics |text | | |
|category_id |int(11) | | |
|threshold |int(11) | | |
|freight |int(11) | | |
|msg |text | | |
|cost_price |decimal(10,2) | | |
|price |decimal(10,2) | | |
|score |int(11) | | |
|state |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |
|attrs |varchar(255) | | |

4、msw_mall_product_attr

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |int(11) | | |
|name |varchar(255) | | |
|state |int(11) | | |
|sort_num |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |

5、msw_mall_product_sku

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |bigint(20) | | |
|product_id |bigint(20) | | |
|cost_price |decimal(10,2) | | |
|price |decimal(10,2) | | |
|score |int(11) | | |
|all_num |int(11) | | |
|num |int(11) | | |
|sales_num |int(11) | | |
|attr_list |text | | |
|create_time |timestamp | | |
|update_time |timestamp | | |

6、msw_mall_seckill

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |bigint(20) | | |
|product_id |bigint(20) | | |
|start_time |datetime | | |
|end_time |datetime | | |
|user_num |int(11) | | |
|all_num |int(11) | | |
|num |int(11) | | |
|sales_num |int(11) | | |
|price |decimal(10,2) | | |
|score |int(11) | | |
|state |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |
|batch_id |int(11) | | |

7、msw_mall_seckill_batch

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |int(11) | | |
|name |varchar(255) | | |
|start_time |datetime | | |
|end_time |datetime | | |
|state |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |

8、msw_user_address

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |bigint(20) | | |
|user_id |int(11) | | |
|realname |varchar(100) | | |
|mobile |varchar(50) | | |
|area |varchar(255) | | |
|address |varchar(255) | | |
|default_flag |int(11) | | |
|create_time |timestamp | | |
|update_time |timestamp | | |

union_mall库表结构文档