| 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 | |