Custom Fields

Tables Covered

• api_relation_custom_fields
• api_project_custom_fields
• api_sale_custom_fields
• api_employee_custom_fields

Description

These tables expose custom field values configured in Simplicate for different entity types. Each table follows the same structure but links to a different parent entity. Custom fields are user-defined fields that allow storing additional information specific to your organization's needs.

Common Fields Structure

All custom fields tables share the same field structure:

Field Name	Type	Description
key_model_id	Integer	Identifier of the parent entity (relation, project, sale, or employee)
report_column_1	String	Value of the first custom field configured for reporting
report_column_2	String	Value of the second custom field configured for reporting
report_column_3	String	Value of the third custom field configured for reporting
report_column_4	String	Value of the fourth custom field configured for reporting
report_column_5	String	Value of the fifth custom field configured for reporting

Table-Specific Information

api_relation_custom_fields

Links to api_relations via key_model_id = relation_id

api_project_custom_fields

Links to api_projects via key_model_id = project_id

api_sale_custom_fields

Links to api_sales via key_model_id = sale_id

api_employee_custom_fields

Links to api_employees via key_model_id = employee_id

Related Tables

• api_relations - For api_relation_custom_fields via key_model_id = relation_id
• api_projects - For api_project_custom_fields via key_model_id = project_id
• api_sales - For api_sale_custom_fields via key_model_id = sale_id
• api_employees - For api_employee_custom_fields via key_model_id = employee_id