| id | Integer
|
|
Primary key
|
| vdb_id | Integer
|
|
|
| created | Date
|
|
Date this document was created
|
| last_checkin | Date
|
|
Date the last version of this document was checked in
|
| creator_id | Integer
|
db_user.id
|
ID of the owner
|
| name | String
|
|
Name of the document
|
| description | String
|
|
Description
|
| path | String
|
|
Path of this document (folder IDs separated by /)
|
| content_type | String
|
|
Mime type of this document
|
| company_id | Integer
|
db_company.id
|
|
| n_co | Integer
|
|
Number of open checkouts
|
| head_release | Integer
|
|
Current release number of this document
|
| head_revision | Integer
|
|
Current revision number of this document
|
| head_file_id | Integer
|
db_fs_file.id
|
ID corresponding to the head revision
|
| head_size | Float
|
|
Size of the latest revision
|
| sz | Float
|
|
Sum of sizes of all its revisions
|
| folder_id | Integer
|
db_folder.id
|
ID of this document's folder
|
| project_id | Integer
|
|
|
| task_id | Integer
|
|
|
| process_id | Integer
|
|
|
| message_id | Integer
|
|
|