95 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| customer_communication_preference_customer_id_fkey |
|
|
Restrict delete | ||
| customer_communication_preference_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_account_transaction_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_dim_date_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_dim_entry_offer_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_customer_id_fkey |
|
|
Restrict delete | ||
| syndicate_dividend_syndicate_share_id_fkey |
|
|
Restrict delete | ||
| account_transaction_status_history_account_transaction_id_fkey |
|
|
Restrict delete | ||
| account_transaction_status_history_dim_atsid_fkey |
|
|
Restrict delete | ||
| deposit_customer_id_fkey |
|
|
Restrict delete | ||
| deposit_account_transaction_id_fkey |
|
|
Restrict delete | ||
| deposit_dim_transfer_method_id_fkey |
|
|
Restrict delete | ||
| deposit_dim_channel_id_fkey |
|
|
Restrict delete | ||
| deposit_dim_date_id_fkey |
|
|
Restrict delete | ||
| deposit_administrator_id_fkey |
|
|
Restrict delete | ||
| syndicate_sales_syndicate_session_id_fkey |
|
|
Restrict delete | ||
| syndicate_sales_dim_pricing_id_fkey |
|
|
Restrict delete | ||
| withdraw_account_transaction_id_fkey |
|
|
Restrict delete | ||
| withdraw_dim_transfer_method_id_fkey |
|
|
Restrict delete | ||
| customer_signup_dim_date_id_fkey |
|
|
Restrict delete | ||
| customer_dim_location_id_fkey |
|
|
Restrict delete | ||
| customer_dim_affiliate_id_fkey |
|
|
Restrict delete | ||
| customer_dob_dim_date_id_fkey |
|
|
Restrict delete | ||
| syndicate_session_sales_history_dim_provider_id_fkey |
|
|
Restrict delete | ||
| syndicate_session_sales_history_syndicate_session_id_fkey |
|
|
Restrict delete | ||
| customer_account_transaction_summary_dim_date_id_fkey |
|
|
Restrict delete | ||
| customer_account_transaction_summary_customer_id_fkey |
|
|
Restrict delete | ||
| customer_event_customer_id_fkey |
|
|
Restrict delete | ||
| customer_event_administrator_id_fkey |
|
|
Restrict delete | ||
| customer_event_dim_customer_event_type_id_fkey |
|
|
Restrict delete | ||
| account_transaction_reversed_account_transaction_id_fkey |
|
|
Restrict delete | ||
| deposit_status_history_account_deposit_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_dim_pricing_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_customer_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_dim_draw_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_scheduled_purchase_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_dim_cause_id_fkey |
|
|
Restrict delete | ||
| ticket_sales_recurring_purchase_id_fkey |
|
|
Restrict delete | ||
| account_transaction_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| account_transaction_customer_id_fkey |
|
|
Restrict delete | ||
| deposit_dim_transfer_method_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_recurring_purchase_type_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_ticket_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_affiliate_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_channel_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_pricing_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| wager_cancelled_dim_provider_id_fkey |
|
|
Restrict delete | ||
| migrated_ticket_sales_dim_draw_id |
|
|
Restrict delete | ||
| migrated_ticket_sales_dim_pricing_id |
|
|
Restrict delete | ||
| wager_dim_date_id_fkey |
|
|
Restrict delete | ||
| wager_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| wager_dim_recurring_purchase_type_id_fkey |
|
|
Restrict delete | ||
| wager_dim_channel_id_fkey |
|
|
Restrict delete | ||
| wager_dim_provider_id_fkey |
|
|
Restrict delete | ||
| wager_customer_id_fkey |
|
|
Restrict delete | ||
| wager_dim_pricing_id_fkey |
|
|
Restrict delete | ||
| wager_administrator_id_fkey |
|
|
Restrict delete | ||
| wager_dim_draw_id_fkey |
|
|
Restrict delete | ||
| wager_ticket_id_fkey |
|
|
Restrict delete | ||
| wager_dim_organisation_id_fkey |
|
|
Restrict delete | ||
| wager_dim_affiliate_id_fkey |
|
|
Restrict delete | ||
| syndicate_session_sales_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| syndicate_session_sales_dim_syndicate_id_fkey |
|
|
Restrict delete | ||
| ticket_status_history_ticket_id_fkey |
|
|
Restrict delete | ||
| ticket_status_history_dim_provider_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_event_scheduled_purchase_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_event_dim_spe_type_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_dim_entry_offer_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_dim_lottery_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_account_transaction_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_dim_date_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_ticket_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_customer_id_fkey |
|
|
Restrict delete | ||
| ticket_dividend_dim_division_id_fkey |
|
|
Restrict delete | ||
| recurring_purchase_status_history_recurring_purchase_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_customer_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_dim_channel_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_dim_scheduled_purchase_type_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_dim_organisation_id_fkey |
|
|
Restrict delete | ||
| scheduled_purchase_administrator_id_fkey |
|
|
Restrict delete | ||
| syndicate_share_status_history_syndicate_share_id_fkey |
|
|
Restrict delete | ||
| customer_action_dim_date_id_fkey |
|
|
Restrict delete | ||
| customer_action_dim_device_platform_id_fkey |
|
|
Restrict delete | ||
| withdraw_status_history_withdraw_id_fkey |
|
|
Restrict delete | ||
| recurring_purchase_dim_recurring_purchase_type_id_fkey |
|
|
Restrict delete | ||
| recurring_purchase_customer_id_fkey |
|
|
Restrict delete | ||
| recurring_purchase_starting_dim_draw_id_fkey |
|
|
Restrict delete | ||
| account_transaction_summary_dim_date_id_fkey |
|
|
Restrict delete | ||
| recurring_purchase_event_drpeti_fkey |
|
|
Restrict delete | ||
| recurring_purchase_event_recurring_purchase_id_fkey |
|
|
Restrict delete | ||
| admin_transfer_administrator_id_fkey |
|
|
Restrict delete | ||
| admin_transfer_dim_transfer_method_id_fkey |
|
|
Restrict delete | ||
| admin_transfer_dim_date_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|