opportunity_education


Description

A row in this table represents a degree or other education achievement connected to an opportunity.

Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunity_education_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

end_date_id varchar 2147483647 null
dates.date_id opportunity_education_end_date_id_fkeyN

ID of the date this entity was finished by the candidate.

start_date_id varchar 2147483647 null
dates.date_id opportunity_education_start_date_id_fkeyN

ID of the date this entity was started by the candidate.

degree varchar 2147483647 null

Type of degree of this entity, if applicable.

end_at timestamp 29,6 null

Date this entity was finished by the candidate.

field varchar 2147483647 null

Field of study.

start_at timestamp 29,6 null

Date this entity was started by the candidate.

organization varchar 2147483647 null

Educational institution of this entity.

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.

Indexes

Constraint Name Type Sort Column(s)
opportunity_education_pkey Primary key Asc opportunity_education_id
opportunity_education_account_id_idx Performance Asc account_id
opportunity_education_opp_id_idx Performance Asc opportunity_id

Relationships