A row in this table represents a score associated to a form submission. Scores associated with scorecards might also have a comment.


Column Type Size Nulls Auto Default Children Parents Comments
opportunity_form_field_score_id varchar 2147483647 null
opportunity_feedback_events.opportunity_form_field_score_id opportunities_feedback_events_opportunity_form_field_score_fkeyC

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunity_form_field_scores_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunity_form_field_scores_form_id_fkeyN

ID of the opportunity form record related to this score.

score_index int4 10 null

Numeric order of the score on the field. It will always be 0 for overall scores, but it will start at 0 for scorecards with multiple scores.

score int4 10 null

Numeric value of the score.

comment varchar 2147483647 null

Comment attached to a score in the scorecard

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

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


Constraint Name Type Sort Column(s)
opportunity_form_field_scores_pkey Primary key Asc opportunity_form_field_score_id
opp_form_field_scores_opp_form_field_id_idx Performance Asc opportunity_form_field_id
opp_form_field_scores_opp_form_id_idx Performance Asc opportunity_form_id
opp_form_field_scores_opp_id_idx Performance Asc opportunity_id
opportunity_form_field_scores_account_id_index Performance Asc account_id
opportunity_form_field_scores_contact_id_index Performance Asc contact_id