| 序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
| 1 | id | bigint | 20 |
| 是 | 是 |
| 否 |
| auto_increment |
| 2 | addtime | timestamp |
|
|
|
|
| 否 | CURRENT_TIMESTAMP |
|
| 3 | yuyuebianhao | varchar | 200 |
|
|
|
| 是 |
|
|
| 4 | minsumingcheng | varchar | 200 |
|
|
|
| 是 |
|
|
| 5 | minsutupian | varchar | 200 |
|
|
|
| 是 |
|
|
| 6 | fangjianleixing | varchar | 200 |
|
|
|
| 是 |
|
|
| 7 | minsudizhi | varchar | 200 |
|
|
|
| 是 |
|
|
| 8 | fangzhuzhanghao | varchar | 200 |
|
|
|
| 是 |
|
|
| 9 | yiwanjiage | int | 11 |
|
|
|
| 是 |
|
|
| 10 | ruzhuriqi | date |
|
|
|
|
| 是 |
|
|
| 11 | ruzhutianshu | int | 11 |
|
|
|
| 是 |
|
|
| 12 | zongjine | int | 11 |
|
|
|
| 是 |
|
|
| 13 | yuyueshijian | datetime |
|
|
|
|
| 是 |
|
|
| 14 | beizhu | varchar | 200 |
|
|
|
| 是 |
|
|
| 15 | yonghuzhanghao | varchar | 200 |
|
|
|
| 是 |
|
|
| 16 | yonghuxingming | varchar | 200 |
|
|
|
| 是 |
|
|
| 17 | shoujihaoma | varchar | 200 |
|
|
|
| 是 |
|
|
| 18 | sfsh | varchar | 200 |
|
|
|
| 是 | 否 |
|
| 19 | shhf | longtext |
|
|
|
|
| 是 |
|
|
| 20 | ispay | varchar | 200 |
|
|
|
| 是 | 未支付 |
|
| 21 | userid | bigint | 20 |
|
|
|
| 是 |
|
|