poll

poll

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