表 84 : v9_vote_subject
| 字段 | 类型 | Null | 默认 | 额外 | 注释 |
| subjectid | mediumint(8) unsigned | PK | auto_increment | ||
| siteid | smallint(5) unsigned | YES | 0 | ||
| subject | char(255) | NO | |||
| ismultiple | tinyint(1) unsigned | NO | 0 | ||
| ischeckbox | tinyint(1) unsigned | NO | 0 | ||
| credit | smallint(5) unsigned | NO | 0 | ||
| addtime | int(10) unsigned | NO | 0 | ||
| fromdate | date | NO | 0000-00-00 | ||
| todate | date | NO | 0000-00-00 | ||
| interval | tinyint(3) unsigned | NO | 0 | ||
| enabled | tinyint(1) unsigned | NO | 1 | ||
| template | char(20) | NO | |||
| description | text | NO | |||
| listorder | smallint(5) unsigned | NO | 0 | ||
| allowguest | tinyint(1) unsigned | NO | 1 | ||
| maxval | tinyint(2) unsigned | NO | 0 | ||
| minval | tinyint(1) unsigned | NO | 1 | ||
| allowview | tinyint(1) unsigned | NO | 1 | ||
| optionnumber | tinyint(3) unsigned | NO | 0 | ||
| votenumber | mediumint(8) unsigned | NO | 0 |
| 键名 | 类型 | 字段 |
| PRIMARY | PRIMARY | subjectid |
| enabled | INDEX | enabled |
| fromdate | INDEX | fromdate |
| fromdate | INDEX | todate |
| todate | INDEX | todate |