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 |