todo

todo —

todo

Column nameTypeNullDefaultDescription
todoidint unsigned auto_increment
journalidint unsigned0
posteridint unsigned0
owneridint unsigned0
statuslinevarchar(40)
securityenum('public','private','friends')public
subjectvarchar(100)
desvarchar(255)
priorityenum('1','2','3','4','5')3
datecreatedatetime0000-00-00 00:00:00
dateupdatedatetimeYES
dateduedatetimeYES
datecloseddatetimeYES
progresstinyint unsigned0
Key nameTypeColumn(s)
PRIMARYPRIMARY
journalidINDEX
owneridINDEX
posteridINDEX