db_custom_field_val (Dropped in v9.1)
(v9.1) This table has been dropped in v9.1. All custom field values are now stored as part of their attached entity.
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| field_type | Integer | Indicates type of field. e.g integer, string, date etc. | |
| raw_value | String | ||
| document_id | Integer | db_document.id | Primary key of the document table in case the custom field is of file type |
| object_id | Integer | Primary key of the object that this entry represents e.g. ID of a document | |
| object_type | Integer | Type of the object that this entry represents. E.g. 9 = folder, 6 = document, 32 = url | |
| custom_field_def_id | Integer | db_custom_field_def.id |