todo

todo

todo

Column name Type Null Default Description
todoid int unsigned auto_increment    
journalid int unsigned   0  
posterid int unsigned   0  
ownerid int unsigned   0  
statusline varchar(40) YES  
security enum('public','private','friends')   public  
subject varchar(100) YES  
des varchar(255) YES  
priority enum('1','2','3','4','5')   3  
datecreate datetime   0000-00-00 00:00:00  
dateupdate datetime YES  
datedue datetime YES  
dateclosed datetime YES  
progress tinyint unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY
journalid INDEX
ownerid INDEX
posterid INDEX