Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
opportunity_id | varchar | 2147483647 | null |
|
|
ID of the opportunity connected to this entity. |
||||
eeo_response_id | varchar | 2147483647 | null |
|
|
ID of the EEO response connected to the opportunity. |
||||
account_id | varchar | 2147483647 | √ | null |
|
|
ID of the account the record belongs to. |
|||
disability_status_signature | varchar | 2147483647 | √ | null |
|
|
Text of the signature by the applicant. |
|||
disability_status_date | varchar | 2147483647 | √ | null |
|
|
Date of the signature by the applicant. |
|||
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. |
|||
survey_sent_at | timestamp | 29,6 | √ | null |
|
|
Timestamp of when the survey is sent to a sourced, referred, or agency-submitted candidates |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
opportunity_eeo_pkey | Primary key | Asc/Asc | opportunity_id + eeo_response_id |
opportunity_eeo_account_id_idx | Performance | Asc | account_id |
opportunity_eeo_opp_id_idx | Performance | Asc | opportunity_id |
opportunity_eeo_response_id | Performance | Asc | eeo_response_id |