Table: Custom Field to Entity Map

Table: Custom Field to Entity Map

This allows the mapping of custom fields to other entities, such as loans, customers, collateral, etc.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
entity_idint(11)ID of the associated entity
entity_typechar(100)Type of the associated entity
custom_field_idint(11)ID of associated custom field
custom_field_valuevarchar(255)Value of associated custom field
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List