Details of the folder object. Folder stores other folders, documents, urls and forumsFavorites
| 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. | ||||
| creatoruser_id | Integer | db_person.id | User ID of the creator of this folder.project | ||||
| object_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)Favorite object ID | |||||
| object_type | Integer | Favorite object type |