Column | Type | References | Comments |
---|
id | Integer | Â | Primary key |
vdb_id | Integer | Â | Â |
guid | String | Â | Â |
name | String | Â | Name of the document |
description | String | Â | Description |
created | Date | Â | Date this document was created |
creator_id | Integer | db_person.id | ID of the owner |
url | String | Â | The actual URL |
kind | Integer | Â | URL or Document |
path | String | Â | Path of this document (folder IDs separated by /) |
content_type | String | Â | Mime type of this document |
last_checkin | Date | Â | Date the last version of this document was checked in |
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 |
provider | String | Â | One of celoxis|google|dropbox |
provider_data | String | Â | JSON encoded data from the provider |
folder_id | Integer | db_folder.id | ID of this document's folder |
project_id | Integer | db_project.id | Â |
task_id | Integer | db_task.id | Â |
task_update_id | Integer | db_task_update.id | Â |
process_id | Integer | db_process.id | Â |
process_update_id | Integer | db_process_update.id | Â |
message_id | Integer | db_message.id | Â |
expense_item_id | Integer | db_expense_item.id | Â |
custom_field_def_id | Integer | db_custom_field_def.id | Â |