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) | |||
| security | enum('public','private','friends') | public | ||
| subject | varchar(100) | |||
| des | varchar(255) | |||
| 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 |