poll
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| pollid | int unsigned auto_increment |
|
||
| itemid | int unsigned |
0
|
||
| journalid | int unsigned |
0
|
||
| posterid | int unsigned |
0
|
||
| whovote | enum('all','friends') |
all
|
||
| whoview | enum('all','friends','none') |
all
|
||
| name | varchar(255) | YES |
|
|
| status | char(1) | YES |
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| itemid | INDEX | |
| journalid | INDEX | |
| posterid | INDEX | |
| status | INDEX |