Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
| Primary key. | ||||||
| candidate_id | int4 | 10 | √ | null |
| Id of the candidate the record belongs to. | |||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||
| created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||
| varchar | 255 | √ | null | Candidate email address. | |||||||
| name | varchar | 255 | √ | null | Candidate name address. | ||||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||
| offer_title | varchar | 255 | √ | null | Offer title. | ||||||
| referral_referrer_id | int4 | 10 | √ | null |
| Id of the referrer the record belongs to. | |||||
| status | varchar | 255 | √ | null | Application status - one of (‘claimed’, ‘in_review’, ‘process_complete’). | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |