| 序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
| 1 | id | bigint | 20 |
| 是 | 是 |
| 否 |
| auto_increment |
| 2 | addtime | timestamp |
|
|
|
|
| 否 | CURRENT_TIMESTAMP |
|
| 3 | minsumingcheng | varchar | 200 |
|
|
|
| 否 |
|
|
| 4 | minsutupian | varchar | 200 |
|
|
|
| 是 |
|
|
| 5 | fangjianleixing | varchar | 200 |
|
|
|
| 是 |
|
|
| 6 | minsuxingji | varchar | 200 |
|
|
|
| 否 |
|
|
| 7 | yiwanjiage | int | 11 |
|
|
|
| 是 |
|
|
| 8 | minsudizhi | varchar | 200 |
|
|
|
| 是 |
|
|
| 9 | minsujieshao | longtext |
|
|
|
|
| 是 |
|
|
| 10 | fangzhuzhanghao | varchar | 200 |
|
|
|
| 是 |
|
|
| 11 | lianxidianhua | varchar | 200 |
|
|
|
| 是 |
|
|
| 12 | clicktime | datetime |
|
|
|
|
| 是 |
|
|
| 13 | clicknum | int | 11 |
|
|
|
| 是 | 0 |
|