惠州工会表结构文档V1.0

修订记录

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

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
| id | varchar(64) | ||
| active_name | varchar(100) |||
| sunmmary| varchar(100) | | |
| sctive_titlePic| varchar(255) | | |
| join_rule_type| int(1) | ||
| merchants_id|varchar(64) | ||
| join_end_time | datetime| ||
| active_start_time | datetime| ||
| active_end_time | datetime| ||
| limit_of_number | int(10)| ||
| address |varchar(255) | ||
| state |int(255) | ||
| lat |double | ||
| lng|double| ||
| active_type | int(1)| ||
| concent |text | ||
| src |varchar(255) | ||
| create_user_id |varchar(64) | ||
| update_user_id |varchar(64) | ||
| update_time |datetime | ||
| create_time |datetime | ||
| is_del | int(1)| ||
| is_fee |int(1) | ||
| join_number | int(10)| ||

2、msw_zhgh_active_ticket

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
| id |varchar(64) | ||
| active_id |varchar(64) | ||
|ticket_name | varchar(100) | | |
| price |decimal(10,2) | | |
| stock |int(10) | ||
| buy_num |int(10) | ||
| role_limit |int(5) | ||
| ticket_start_time |datetime | ||
| ticket_end_time |datetime | ||
| create_time |datetime | ||
| is_del |int(255) | ||

3、msw_zhgh_active_user

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
| id |varchar(64) | | |
| order_no |varchar(64) | | |
| active_id |varchar(64) | | |
| ticket_id |varchar(64) | | |
| ticket_no |varchar(64) | | |
| num |int(9) | | |
| qr |varchar(255) | | |
| qr_secret_key |varchar(255) | | |
| user_id |varchar(64) | | |
| mobile |varchar(15) | | |
| bank_no |varchar(20) | | |
| user_name |varchar(50) | | |
| is_del |int(1) | | |
| create_time |datetime | | |
| update_time |datetime | | |
| check_merchants_id |varchar(64) | | |
| ticket_unit_price |decimal(10,2) | | |
| ticket_total_price |decimal(10,2) | | |
| state |int(2) | | |
| pay_type |int(2) | | |
| id_card |varchar(18) | | |
| order_out_time |datetime | | |
|is_use |int(1) | | |

4、msw_zhgh_user_active_order

| 字段 | 类型 | 含义 | 备注|
| -------- | -------- | -------- |-------- |
|id |varchar(64) | | |
|order_no |varchar(64) | | |
|active_id |varchar(64) | | |
|order_ticket_num |int(9) | | |
|user_id |varchar(64) | | |
|mobile |varchar(15) | | |
|bank_no |varchar(20) | | |
|user_name |varchar(50) | | |
|is_del |int(1) | | |
|create_time |datetime | | |
|update_time |datetime | | |
|merchants_id |varchar(64) | | |
|order_total_price |decimal(10,2) | | |
|state |int(2) | | |
|pay_type |int(2) | | |
|id_card |varchar(18) | | |
|order_out_time |datetime | | |
|is_use |int(1) | | |

惠州工会表结构文档V1.0

修订记录

目录

1、msw_zhgh_active

2、msw_zhgh_active_ticket

3、msw_zhgh_active_user

4、msw_zhgh_user_active_order