A row in this table represents a form field on an opportunity form.


Column Type Size Nulls Auto Default Children Parents Comments
opportunity_form_field_id varchar 2147483647 null
opportunity_form_field_files.opportunity_form_field_id opportunity_form_field_files_opportunity_form_field_id_fkeyC
opportunity_form_field_scores.opportunity_form_field_id opportunity_form_field_scores_opportunity_form_field_id_fkeyC
opportunity_form_field_values.opportunity_form_field_id opportunity_form_field_values_opportunity_form_field_id_fkeyC

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunity_form_fields_opportunity_form_id_fkeyN

ID of the opportunity form record related to this entity.

form_template_field_id varchar 2147483647 'UNKNOWN_FORM_FIELD'::character varying
form_template_fields.form_template_field_id opportunity_form_fields_form_template_field_id_fkey

ID the template used to generate this field

description varchar 2147483647 null

A detailed description of the field.

is_required bool 1 null

TRUE if the field is required to be filled out on the opportunity form.

text varchar 2147483647 null

A summary or title of the 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 opportunity_form_fields_form_field_type_id_fkeyN

ID that describes the type of this field.

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.

contact_id varchar 2147483647 null
contacts.contact_id opportunity_form_fields_contact_id_fkeyN


Constraint Name Type Sort Column(s)
opportunity_form_fields_pkey Primary key Asc opportunity_form_field_id
opp_form_fields_account_id_idx Performance Asc account_id
opp_form_fields_form_templ_field_id_idx Performance Asc form_template_field_id
opp_form_fields_opp_form_id_idx Performance Asc opportunity_form_id
opportunity_form_fields_contact_id_index Performance Asc contact_id