Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('applications_id_seq'::regclass) |
|
|
|||||
| job_id | int8 | 19 | null |
|
|
||||||
| business_id | int8 | 19 | √ | null |
|
|
|||||
| render_id | int8 | 19 | √ | null |
|
|
|||||
| ats_kind | text | 2147483647 | 'other'::text |
|
|
||||||
| adapter | text | 2147483647 | 'form'::text |
|
|
||||||
| gate_score | float4 | 8,8 | √ | null |
|
|
|||||
| gate_threshold | float4 | 8,8 | √ | null |
|
|
|||||
| gate_basis | text | 2147483647 | √ | null |
|
|
|||||
| status | text | 2147483647 | 'gated'::text |
|
|
||||||
| consent | bool | 1 | false |
|
|
||||||
| user_key | text | 2147483647 | 'default'::text |
|
|
||||||
| resume_bytes | bytea | 2147483647 | √ | null |
|
|
|||||
| resume_sha256 | text | 2147483647 | √ | null |
|
|
|||||
| request_payload | jsonb | 2147483647 | √ | null |
|
|
|||||
| portal_response | jsonb | 2147483647 | √ | null |
|
|
|||||
| confirmation_id | text | 2147483647 | √ | null |
|
|
|||||
| error | text | 2147483647 | √ | null |
|
|
|||||
| forced | bool | 1 | false |
|
|
||||||
| submitted_at | timestamptz | 35,6 | √ | null |
|
|
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| applications_pkey | Primary key | Asc | id |
| idx_applications_business | Performance | Asc | business_id |
| idx_applications_job | Performance | Asc | job_id |
| idx_applications_status | Performance | Asc | status |
| uniq_submitted_per_role | Must be unique | Asc/Asc | business_id + job_id |