opportunity_form_field_values


Description

A row in this table represents an input into a form added by a user or a candidate \(applications\).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
opportunity_form_field_value_id varchar 2147483647 null

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

value_index int4 10 null

Numeric index of the field value in the order the field appears in the form. Is always 0 for single value fields

value_currency numeric 131089 null

The numeric amount of currency for currency fields.

value_string varchar 2147483647 null

String value of the field if filled with text.

value_date timestamp 29,6 null

Timestamp value of the field for date fields.

value_number numeric 131089 null

Numeric value of the field if filled with a number, also contains the amount of currency for currency fields.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunity_form_field_values_form_id_fkeyN

ID of the opportunity form record related to this entity.

currency_code varchar 2147483647 null

3-letter currency code for currency fields.

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.

opportunity_form_field_id varchar 2147483647 null
opportunity_form_fields.opportunity_form_field_id opportunity_form_field_values_opportunity_form_field_id_fkeyC

ID of the field used in the opportunity form.

contact_id varchar 2147483647 null
contacts.contact_id opportunity_form_field_values_contact_id_fkeyN

Indexes

Constraint Name Type Sort Column(s)
opportunity_form_field_values_pkey Primary key Asc opportunity_form_field_value_id
opp_form_field_values_opp_form_field_id_idx Performance Asc opportunity_form_field_id
opportunity_form_field_values_account_id_index Performance Asc account_id
opportunity_form_field_values_contact_id_index Performance Asc contact_id
opportunity_form_field_values_opportunity_form_id_index Performance Asc opportunity_form_id

Relationships