Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ColumnTypeReferencesComments
idInteger Primary key
guidString  
vdb_idInteger  
nameString Name of this folder
descriptionString Description of this folder
pathparent_idString Path of this folder from its root. IDs are separated by /.parentIntegerdb_folder.idID of this folder's parent.
creator_idIntegerdb_folderperson.idID of the creator of this folder's parent.root.
project_idIntegerdb_project.id 
task_idIntegerdb_foldertask.idRoot ID  
pathString Path of this folder from its root. IDs are separated by /.
creatorroot_idIntegerdb_personfolder.idRoot ID of the creator of this folder.
szFloat Size of this folder
leavesInteger Number of non foldersof descendant documents
last_checkinDate Max date of last checkin in this folder (including descendants)