folders
Purpose: Stores data pertaining to personal folders.
Note: System folders are build automatically from the modules table.
Joins: users tables.
| Field | Type | Purpose |
|---|---|---|
| id | int(4) | Primary Key – auto increment. |
| ownerID | int(10) unsigned | ID of the user who's folder it is. |
| name | text | Title of the folder as displayed in the user interface. |
| created | datetime | Datetime record of when the folder was created |
| color | enum('yellow','red','green','blue','gray') | Colour preference for the folder |
| deleted | datetime | Datetime when deleted. Active folders have this field as NULL |
, multiple selections available,