...
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 | ||||
pathparent_id | String | Path of this folder from its root. IDs are separated by /. | parentInteger | db_folder.id | ID of this folder's parent. | |
creator_id | Integer | db_folderperson.id | ID of the creator of this folder's parent.root. | |||
project_id | Integer | db_project.id | ||||
task_id | Integer | db_foldertask.idRoot ID | ||||
path | String | Path of this folder from its root. IDs are separated by /. | ||||
creatorroot_id | Integer | db_personfolder.id | Root ID of the creator of this folder. | |||
sz | Float | Size of this folder | ||||
leaves | Integer | Number of non foldersof descendant documents | ||||
last_checkin | Date | Max date of last checkin in this folder (including descendants) |