表 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 |