FavoritesDetails 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 | user | 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 | User ID objectof the creator of this folder. | |||||
| project_id | Integer | db_project.id | ||||||
| task_id | Integer | db_task.id | Favorite object ID | object_type | Integer | Favorite object type | ||
| 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) |