ai_candidate_decision

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
decision_id uuid 2147483647 null
ai_candidate_decision_task.decision_id fk_ai_candidate_decision_task_decision_company C
decision_batch_id uuid 2147483647 null
ai_candidate_decision_batch.decision_batch_id fk_ai_candidate_decision_batch_company C
ai_run_id uuid 2147483647 null
ai_run.ai_run_id fk_ai_candidate_decision_run_company C
ai_candidate_id uuid 2147483647 null
ai_candidate.ai_candidate_id fk_ai_candidate_decision_candidate_company R
company_id uuid 2147483647 null
ai_candidate_decision_task.company_id fk_ai_candidate_decision_task_decision_company C
ai_candidate_decision_batch.company_id fk_ai_candidate_decision_batch_company C
ai_candidate.company_id fk_ai_candidate_decision_candidate_company R
ai_run.company_id fk_ai_candidate_decision_run_company C
action varchar 20 null
created_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_ai_candidate_decision Primary key Asc decision_id
idx_ai_candidate_decision_run Performance Asc/Asc/Asc company_id + ai_run_id + created_at
uq_ai_candidate_decision_batch_candidate Must be unique Asc/Asc decision_batch_id + ai_candidate_id
uq_ai_candidate_decision_candidate Must be unique Asc/Asc company_id + ai_candidate_id
uq_ai_candidate_decision_id_company Must be unique Asc/Asc decision_id + company_id

Check Constraints

Constraint Name Constraint
ck_ai_candidate_decision_action (((action)::text = ANY ((ARRAY['ACCEPT'::character varying, 'DISCARD'::character varying])::text[])))

Relationships

Close relationships within degrees of separation