2 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| assignment_events_assignment_id_fkey |
|
|
Cascade on delete | ||
| deliverables_assignment_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| assignments | assignments_kind_check | (kind = ANY (ARRAY['coding'::text, 'case_study'::text, 'design_doc'::text, 'data'::text, 'other'::text])) |
| assignments | assignments_status_check | (status = ANY (ARRAY['received'::text, 'in_progress'::text, 'review'::text, 'submitted'::text])) |