A row in this table represents a field on a specific form.


Column Type Size Nulls Auto Default Children Parents Comments
form_template_field_id varchar 2147483647 null
form_template_field_options.form_template_field_id form_template_field_options_field_id_fkeyN
opportunity_form_fields.form_template_field_id opportunity_form_fields_form_template_field_id_fkey

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

form_template_id varchar 2147483647 null
form_templates.form_template_id form_template_fields_form_template_id_fkeyN

ID of form template associated with this entity.

description varchar 2147483647 null

Description of the form template field.

is_required bool 1 null

TRUE if this field is required.

text varchar 2147483647 null

The title of this form template field.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

form_field_type_id varchar 2147483647 null
form_field_type_enum.form_field_type_id form_template_fields_form_field_type_id_fkeyN

ID of the form field type.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

field_id varchar 2147483647 null


Constraint Name Type Sort Column(s)
form_template_fields_pkey Primary key Asc form_template_field_id
form_template_fields_account_id_index Performance Asc account_id