| 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 | |
| folder_id | Integer | db_folder.id | ID of this document's folder |
| project_id | Integer | db_project.id | |
| task_id | Integer | db_task.id | |
| process_id | Integer | db_process.id | |
| message_id | Integer | db_message.id | |
| expense_item_id | Integer | db_expense_item.id |
General
Content
Integrations