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 |