Database – Custom Field to Entity Map (custom_field__entity)
Updated 1 year ago
Description
This allows the mapping of custom fields to other entities, such as loans, customers, collateral, etc. For information on how to use custom fields in the API, see API - Custom Fields.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID of the entity. | ||
entity_id | int(11) | ID of the associated entity. | ||
entity_type | char(100) | Type of the associated entity. | ||
custom_field_id | int(11) | ID of associated custom field. | ||
custom_field_value | varchar(255) | Value of associated custom field. | ||
custom_field_value_setting | char(100) | |||
deleted | tinyint(1) | Whether or not the entity was deleted. | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated. |