form_templates


Description

A row in this table represents a form used to collect information about an opportunity. All individual fields and pre-configured values \(if any\) can be reconstructed by using form_template_fields and form_template_fields_options.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_template_id varchar 2147483647 null
account_surveys.form_template_id account_surveys_form_template_id_fkeyN
form_template_field_options.form_template_id form_template_field_options_form_template_id_fkeyN
form_template_fields.form_template_id form_template_fields_form_template_id_fkeyN
interview_panel_interviewers.form_template_id interview_panel_interviewers_form_template_id_fkeyN
interview_panel_interviews.form_template_id interview_panel_interviews_form_template_id_fkeyN
opportunity_feedback_events.form_template_id opportunities_feedback_events_form_template_id_fkeyN
opportunity_form_events.form_template_id opportunities_form_events_form_template_id_fkeyN
opportunity_forms.form_template_id opportunity_forms_form_template_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
name varchar 2147483647 √ null

The name of this form template.
current_version int4 10 √ null

current version of the template. A high number indicates more revisions.
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
creator_id varchar 2147483647 √ null
users.user_id form_templates_creator_id_fkeyN

ID of the user that created the entity in this entity.
form_type_id varchar 2147483647 √ null
form_type_enum.form_type_id form_templates_form_type_id_fkeyN

ID of the form type associated with this entity.
is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.
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.

Indexes

Constraint Name Type Sort Column(s)
form_templates_pkey Primary key Asc form_template_id
form_templates_account_id_index Performance Asc account_id
form_templates_creator_id_idx Performance Asc creator_id

Relationships

Close relationships within degrees of separation