offer_revision_fields


Description

A row in this table represents a change to a specific field capturing the value that was changed.

Columns

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

Primary key.

offer_revision_id varchar 2147483647 null
offer_revisions.offer_revision_id offer_revision_fields_offer_revision_id_fkeyN

ID of the specific offer revision this field applies to.

index int4 10 null

Numeric index of the field, in the order it appears on the offer form.

identifier varchar 2147483647 null

Identifier of the field. Is also used in offer letters as the placeholder.

label varchar 2147483647 null

Label of the field in an offer. This is the name visible in the product’s UI.

field_value_index int4 10 null

Numeric index of the field value. Is always 0 for single value fields.

field_value varchar 2147483647 null

String value of the field if filled with text.

field_value_number numeric 131089 null

Numeric value of the field if filled with a number.

field_value_date timestamp 29,6 null

Timestamp value of the field for “date” fields.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

offer_id varchar 2147483647 null
offers.offer_id offer_revision_fields_offer_id_fkeyN

ID of a specific offer.

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.

account_id varchar 2147483647 null

ID of the account the record belongs to.

previous_field_value varchar 2147483647 null
previous_field_value_number numeric 131089 null
previous_field_value_date timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
offer_revision_fields_pkey Primary key Asc offer_revision_field_id
offer_revision_fields_account_id_idx Performance Asc account_id
offer_revision_fields_offer_id_index Performance Asc offer_id

Relationships