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
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

Relationships