contact_organization_summary


Description

A row in this table represents a summary of the organizations extracted from the candidate’s resume.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id varchar 2147483647 null
contacts.contact_id contact_organization_summary_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.

account_id varchar 2147483647 null

ID of the account the record belongs to.

organization_summary varchar 2147483647 null

List of organizations that the contact has worked for

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)
contact_organization_summary_pkey Primary key Asc contact_id
contact_organization_summary_account_id_index Performance Asc account_id

Relationships