29 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| contacts_profile_id_fkey |
|
|
Restrict delete | ||
| profile_dimensions_tag_slug_fkey |
|
|
Restrict delete | ||
| profile_dimensions_dimension_slug_fkey |
|
|
Restrict delete | ||
| profile_dimensions_profile_id_fkey |
|
|
Restrict delete | ||
| profile_dimensions_contact_id_fkey |
|
|
Restrict delete | ||
| card_contacts_event_card_id_fkey |
|
|
Restrict delete | ||
| card_contacts_contact_id_fkey |
|
|
Restrict delete | ||
| dimension_edges_value_b_fkey |
|
|
Restrict delete | ||
| dimension_edges_value_a_fkey |
|
|
Restrict delete | ||
| contact_dimensions_dimension_slug_fkey |
|
|
Restrict delete | ||
| contact_dimensions_tag_slug_fkey |
|
|
Restrict delete | ||
| contact_dimensions_contact_id_fkey |
|
|
Restrict delete | ||
| prism_values_prism_slug_fkey |
|
|
Restrict delete | ||
| dimension_values_dimension_slug_fkey |
|
|
Restrict delete | ||
| profile_org_views_org_function_slug_fkey |
|
|
Restrict delete | ||
| profile_org_views_contact_id_fkey |
|
|
Restrict delete | ||
| profile_org_views_profile_id_fkey |
|
|
Restrict delete | ||
| profile_org_views_prism_value_slug_fkey |
|
|
Restrict delete | ||
| certifications_profile_id_fkey |
|
|
Restrict delete | ||
| commentary_event_card_id_fkey |
|
|
Restrict delete | ||
| commentary_profile_id_fkey |
|
|
Restrict delete | ||
| commentary_contact_id_fkey |
|
|
Restrict delete | ||
| event_card_templates_category_slug_fkey |
|
|
Restrict delete | ||
| signals_signal_type_slug_fkey |
|
|
Restrict delete | ||
| signals_profile_id_fkey |
|
|
Restrict delete | ||
| signals_contact_id_fkey |
|
|
Restrict delete | ||
| event_cards_profile_id_fkey |
|
|
Restrict delete | ||
| event_cards_template_slug_fkey |
|
|
Restrict delete | ||
| deals_contact_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| profile_dimensions | profile_dimensions_binding_check | (binding = ANY (ARRAY['entity'::text, 'individual'::text, 'fused'::text, 'representative'::text])) |
| profile_dimensions | profile_dimensions_confidence_check | (confidence = ANY (ARRAY['observed'::text, 'inferred'::text, 'estimated'::text])) |
| profile_dimensions | profile_dimensions_quant_score_check | ((quant_score >= (0)::double precision) AND (quant_score <= (100)::double precision)) |
| profile_dimensions | profile_dimensions_surprise_check | ((surprise >= (0)::double precision) AND (surprise <= (100)::double precision)) |
| card_contacts | card_contacts_role_check | (role = ANY (ARRAY['trigger'::text, 'target'::text, 'champion'::text, 'blocker'::text, 'affected'::text])) |
| dimension_edges | dimension_edges_strength_check | (strength = ANY (ARRAY['always'::text, 'usually'::text, 'sometimes'::text, 'rarely'::text, 'never'::text])) |
| contact_dimensions | contact_dimensions_confidence_check | (confidence = ANY (ARRAY['observed'::text, 'inferred'::text, 'estimated'::text])) |
| contact_dimensions | contact_dimensions_quant_score_check | ((quant_score >= (0)::double precision) AND (quant_score <= (100)::double precision)) |
| dimension_values | dimension_values_range_high_check | ((range_high >= (0)::double precision) AND (range_high <= (100)::double precision)) |
| dimension_values | dimension_values_range_low_check | ((range_low >= (0)::double precision) AND (range_low <= (100)::double precision)) |
| dimensions | dimensions_applies_to_check | (applies_to = ANY (ARRAY['company'::text, 'contact'::text, 'both'::text])) |
| profile_org_views | profile_org_views_binding_check | (binding = ANY (ARRAY['entity'::text, 'individual'::text, 'fused'::text, 'representative'::text])) |
| profile_org_views | profile_org_views_quant_score_check | ((quant_score >= (0)::double precision) AND (quant_score <= (100)::double precision)) |
| commentary | commentary_commentary_type_check | (commentary_type = ANY (ARRAY['surprise'::text, 'relational'::text, 'warning'::text, 'connection'::text, 'approach'::text])) |
| signals | signals_intensity_check | ((intensity >= (0)::double precision) AND (intensity <= (100)::double precision)) |
| event_cards | event_cards_confidence_check | ((confidence >= (0)::double precision) AND (confidence <= (100)::double precision)) |