content_flag

content_flag — Global. Stores flagged content metadata. Content can be flagged as adult content, etc.

content_flag

Column name Type Null Default Description
flagid int unsigned auto_increment    
journalid int unsigned   0  
typeid tinyint unsigned   0  
itemid int unsigned YES  
catid tinyint unsigned   0  
reporterid int unsigned   0  
reporteruniq varchar(15) YES  
instime int unsigned   0  
modtime int unsigned   0  
status char(1) YES  
supportid int unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY
instime INDEX
journalid INDEX
reporterid INDEX
status INDEX