db_folder
Details of the folder object. Folder stores other folders, documents, urls and forums
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| guid | String | ||
| vdb_id | Integer | ||
| name | String | Name of this folder | |
| description | String | Description of this folder | |
| parent_id | Integer | db_folder.id | ID of this folder's parent. |
| creator_id | Integer | db_person.id | ID of the creator of this folder. |
| project_id | Integer | db_project.id | |
| task_id | Integer | db_task.id | |
| path | String | Path of this folder from its root. IDs are separated by /. | |
| root_id | Integer | db_folder.id | Root ID of this folder. |
| sz | Float | Size of this folder | |
| leaves | Integer | Number of descendant documents | |
| last_checkin | Date | Max date of last checkin in this folder (including descendants) |