A row in this table represents an agency’s primary contact information.


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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

email varchar 2147483647 null

Email address associated with this entity.

name varchar 2147483647 null

Name of the agency’s contact

phone varchar 2147483647 null

Phone number of the agency’s contact

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

agency_id varchar 2147483647 null
agencies.agency_id agency_contacts_agency_id_fkeyN

ID of the agency record

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.


Constraint Name Type Sort Column(s)
agency_contacts_pkey Primary key Asc agency_contact_id
agency_contacts_account_id_index Performance Asc account_id