20 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| deal_signatures_document_id_fkey |
|
|
Restrict delete | ||
| resources_room_id_fkey |
|
|
Restrict delete | ||
| deal_payments_customer_id_fkey |
|
|
Restrict delete | ||
| deal_payments_room_id_fkey |
|
|
Restrict delete | ||
| deal_events_room_id_fkey |
|
|
Restrict delete | ||
| card_comments_room_id_fkey |
|
|
Restrict delete | ||
| finding_adjudications_room_id_fkey |
|
|
Cascade on delete | ||
| deal_downloads_payment_id_fkey |
|
|
Restrict delete | ||
| deal_downloads_room_id_fkey |
|
|
Restrict delete | ||
| action_items_room_id_fkey |
|
|
Restrict delete | ||
| bookings_room_id_fkey |
|
|
Restrict delete | ||
| deal_refunds_room_id_fkey |
|
|
Restrict delete | ||
| deal_refunds_payment_id_fkey |
|
|
Restrict delete | ||
| meeting_notes_room_id_fkey |
|
|
Restrict delete | ||
| deal_documents_room_id_fkey |
|
|
Restrict delete | ||
| concerns_room_id_fkey |
|
|
Restrict delete | ||
| deal_line_items_document_id_fkey |
|
|
Restrict delete | ||
| deal_rooms_customer_id_fkey |
|
|
Restrict delete | ||
| wp_credentials_room_id_fkey |
|
|
Restrict delete | ||
| room_documents_room_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| finding_adjudications | finding_adjudications_verdict_valid | (verdict = ANY (ARRAY['true_positive'::text, 'false_positive'::text, 'unclear'::text])) |
| room_documents | room_documents_counts_balance | ((findings_shown + findings_locked) = findings_total) |
| room_documents | room_documents_kind_valid | (document_kind = ANY (ARRAY['preview'::text, 'full'::text])) |