179 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| favorite_notifications_ibfk_1 |
|
|
Restrict delete | ||
| favorite_notifications_ibfk_2 |
|
|
Restrict delete | ||
| raffle_purchases_ibfk_1 |
|
|
Restrict delete | ||
| raffle_purchases_ibfk_2 |
|
|
Restrict delete | ||
| shipping_rate_tables_shop_id_fkey |
|
|
Restrict delete | ||
| size_master_shop_id_fkey |
|
|
Restrict delete | ||
| shop_coupon_uses_coupon_id_fkey |
|
|
Restrict delete | ||
| shop_coupon_uses_user_id_fkey |
|
|
Restrict delete | ||
| notification_settings_user_id_fkey |
|
|
Restrict delete | ||
| live_ratings_user_id_fkey |
|
|
Restrict delete | ||
| live_ratings_live_id_fkey |
|
|
Restrict delete | ||
| live_archives_live_id_fkey |
|
|
Restrict delete | ||
| inventory_reserves_ibfk_1 |
|
|
Restrict delete | ||
| coordinate_products_product_id_fkey |
|
|
Restrict delete | ||
| coordinate_products_coordinate_id_fkey |
|
|
Restrict delete | ||
| maintenance_logs_admin_id_fkey |
|
|
Restrict delete | ||
| live_staffs_live_id_fkey |
|
|
Restrict delete | ||
| live_staffs_staff_id_fkey |
|
|
Restrict delete | ||
| coordinate_tags_coordinate_id_fkey |
|
|
Restrict delete | ||
| inventory_logs_variant_id_fkey |
|
|
Restrict delete | ||
| product_categories_parent_id_fkey |
|
|
Null on delete | ||
| access_logs_user_id_fkey |
|
|
Null on delete | ||
| payments_ibfk_1 |
|
|
Restrict delete | ||
| live_analytics_live_id_fkey |
|
|
Restrict delete | ||
| bgm_copyrights_bgm_id_fkey |
|
|
Restrict delete | ||
| notification_targets_notification_id_fkey |
|
|
Restrict delete | ||
| notification_targets_user_id_fkey |
|
|
Restrict delete | ||
| shipping_rates_prefecture_id_fkey |
|
|
Restrict delete | ||
| shipping_rates_table_id_fkey |
|
|
Restrict delete | ||
| staff_performance_staff_id_fkey |
|
|
Restrict delete | ||
| user_follows_following_id_fkey |
|
|
Restrict delete | ||
| user_follows_follower_id_fkey |
|
|
Restrict delete | ||
| live_promotions_live_id_fkey |
|
|
Restrict delete | ||
| live_promotions_product_id_fkey |
|
|
Restrict delete | ||
| raffle_entries_ibfk_1 |
|
|
Restrict delete | ||
| raffle_entries_ibfk_2 |
|
|
Restrict delete | ||
| live_products_product_id_fkey |
|
|
Restrict delete | ||
| live_products_live_id_fkey |
|
|
Restrict delete | ||
| user_coupons_coupon_id_fkey |
|
|
Restrict delete | ||
| user_coupons_user_id_fkey |
|
|
Restrict delete | ||
| influencer_product_sales_order_id_fkey |
|
|
Restrict delete | ||
| influencer_product_sales_influencer_product_id_fkey |
|
|
Restrict delete | ||
| influencer_settlements_shop_id_fkey |
|
|
Restrict delete | ||
| shop_pages_shop_id_fkey |
|
|
Restrict delete | ||
| shop_pages_shop_setting_id_fkey |
|
|
Null on delete | ||
| coordinates_staff_id_fkey |
|
|
Restrict delete | ||
| coordinates_shop_id_fkey |
|
|
Restrict delete | ||
| admin_sessions_ibfk_1 |
|
|
Restrict delete | ||
| product_apparel_details_product_id_fkey |
|
|
Restrict delete | ||
| receipts_order_id_fkey |
|
|
Cascade on delete | ||
| product_shipping_shipping_rate_table_id_fkey |
|
|
Restrict delete | ||
| product_shipping_product_id_fkey |
|
|
Restrict delete | ||
| cart_items_user_id_fkey |
|
|
Restrict delete | ||
| cart_items_product_id_fkey |
|
|
Restrict delete | ||
| shipping_tracking_ordersId_fkey |
|
|
Null on delete | ||
| shipping_tracking_shipment_id_fkey |
|
|
Cascade on delete | ||
| return_messages_request_id_fkey |
|
|
Restrict delete | ||
| return_messages_sender_id_fkey |
|
|
Restrict delete | ||
| messages_thread_id_fkey |
|
|
Restrict delete | ||
| payment_logs_payment_id_fkey |
|
|
Restrict delete | ||
| block_history_action_by_fkey |
|
|
Restrict delete | ||
| block_history_block_id_fkey |
|
|
Restrict delete | ||
| report_actions_report_id_fkey |
|
|
Restrict delete | ||
| report_actions_admin_id_fkey |
|
|
Restrict delete | ||
| video_products_product_id_fkey |
|
|
Restrict delete | ||
| video_products_video_id_fkey |
|
|
Restrict delete | ||
| pinned_comments_live_id_fkey |
|
|
Restrict delete | ||
| pinned_comments_comment_id_fkey |
|
|
Restrict delete | ||
| pinned_comments_pinned_by_fkey |
|
|
Restrict delete | ||
| shipping_labels_order_id_fkey |
|
|
Restrict delete | ||
| product_variants_size_id_fkey |
|
|
Null on delete | ||
| product_variants_product_id_fkey |
|
|
Cascade on delete | ||
| product_variants_color_masterId_fkey |
|
|
Null on delete | ||
| product_variants_size_masterId_fkey |
|
|
Null on delete | ||
| user_devices_user_id_fkey |
|
|
Restrict delete | ||
| message_threads_shop_id_fkey |
|
|
Restrict delete | ||
| message_threads_user_id_fkey |
|
|
Restrict delete | ||
| message_threads_last_message_id_fkey |
|
|
Null on delete | ||
| shop_shipping_settings_shop_id_fkey |
|
|
Restrict delete | ||
| shop_sales_monthly_shop_id_fkey |
|
|
Restrict delete | ||
| influencer_sales_influencer_shop_id_fkey |
|
|
Restrict delete | ||
| influencer_sales_original_shop_id_fkey |
|
|
Restrict delete | ||
| influencer_products_original_product_id_fkey |
|
|
Restrict delete | ||
| influencer_products_influencer_shop_id_fkey |
|
|
Restrict delete | ||
| color_master_shop_id_fkey |
|
|
Restrict delete | ||
| live_product_sales_live_analyticsId_fkey |
|
|
Null on delete | ||
| live_product_sales_live_id_fkey |
|
|
Restrict delete | ||
| live_product_sales_product_id_fkey |
|
|
Restrict delete | ||
| social_accounts_ibfk_1 |
|
|
Restrict delete | ||
| notification_channels_notification_id_fkey |
|
|
Restrict delete | ||
| report_email_settings_shop_id_fkey |
|
|
Restrict delete | ||
| search_histories_user_id_fkey |
|
|
Restrict delete | ||
| influencer_settings_shop_id_fkey |
|
|
Restrict delete | ||
| product_images_product_id_fkey |
|
|
Cascade on delete | ||
| shop_settlements_shop_id_fkey |
|
|
Restrict delete | ||
| user_suspensions_user_id_fkey |
|
|
Restrict delete | ||
| inventory_variant_id_fkey |
|
|
Cascade on delete | ||
| mail_setting_id_fkey |
|
|
Restrict delete | ||
| staff_permissions_staff_id_fkey |
|
|
Restrict delete | ||
| reports_reporter_id_fkey |
|
|
Restrict delete | ||
| orders_ibfk_1 |
|
|
Restrict delete | ||
| orders_ibfk_2 |
|
|
Restrict delete | ||
| favorites_ibfk_1 |
|
|
Restrict delete | ||
| promotion_purchases_user_id_fkey |
|
|
Restrict delete | ||
| promotion_purchases_promotion_id_fkey |
|
|
Restrict delete | ||
| coordinate_images_coordinate_id_fkey |
|
|
Restrict delete | ||
| category_products_count_category_id_fkey |
|
|
Restrict delete | ||
| user_sessions_ibfk_1 |
|
|
Restrict delete | ||
| auction_winners_ibfk_2 |
|
|
Restrict delete | ||
| auction_winners_ibfk_1 |
|
|
Restrict delete | ||
| product_image_comments_image_id_fkey |
|
|
Restrict delete | ||
| reviews_product_variant_id_fkey |
|
|
Null on delete | ||
| reviews_product_id_fkey |
|
|
Null on delete | ||
| reviews_streamer_id_fkey |
|
|
Null on delete | ||
| reviews_user_id_fkey |
|
|
Restrict delete | ||
| shop_sales_daily_shop_id_fkey |
|
|
Restrict delete | ||
| refunds_return_requestsId_fkey |
|
|
Null on delete | ||
| refunds_order_id_fkey |
|
|
Restrict delete | ||
| auction_settings_ibfk_1 |
|
|
Restrict delete | ||
| product_other_details_product_id_fkey |
|
|
Restrict delete | ||
| live_viewers_live_id_fkey |
|
|
Restrict delete | ||
| live_viewers_user_id_fkey |
|
|
Restrict delete | ||
| auction_auto_payments_ibfk_2 |
|
|
Restrict delete | ||
| auction_auto_payments_ibfk_1 |
|
|
Restrict delete | ||
| order_items_variant_ibfk |
|
|
Restrict delete | ||
| order_items_ibfk_1 |
|
|
Restrict delete | ||
| order_items_product_ibfk |
|
|
Restrict delete | ||
| gift_transactions_ibfk_1 |
|
|
Restrict delete | ||
| gift_transactions_ibfk_2 |
|
|
Restrict delete | ||
| gift_points_ibfk_1 |
|
|
Restrict delete | ||
| products_shop_id_fkey |
|
|
Restrict delete | ||
| products_category_id_fkey |
|
|
Restrict delete | ||
| lives_shop_id_fkey |
|
|
Restrict delete | ||
| return_requests_order_id_fkey |
|
|
Restrict delete | ||
| live_comments_live_id_fkey |
|
|
Restrict delete | ||
| live_comments_user_id_fkey |
|
|
Restrict delete | ||
| shop_coupon_products_coupon_id_fkey |
|
|
Restrict delete | ||
| shop_coupon_products_product_id_fkey |
|
|
Restrict delete | ||
| comment_history_action_by_fkey |
|
|
Restrict delete | ||
| comment_history_comment_id_fkey |
|
|
Restrict delete | ||
| videos_staff_id_fkey |
|
|
Restrict delete | ||
| videos_shop_id_fkey |
|
|
Restrict delete | ||
| influencer_product_cancellations_influencer_product_id_fkey |
|
|
Restrict delete | ||
| video_views_user_id_fkey |
|
|
Restrict delete | ||
| video_views_video_id_fkey |
|
|
Restrict delete | ||
| shop_settings_shop_id_fkey |
|
|
Restrict delete | ||
| review_images_review_id_fkey |
|
|
Restrict delete | ||
| product_variant_images_variant_id_fkey |
|
|
Restrict delete | ||
| staff_accounts_shop_id_fkey |
|
|
Restrict delete | ||
| shop_coupons_shop_id_fkey |
|
|
Restrict delete | ||
| user_blocks_user_id_fkey |
|
|
Restrict delete | ||
| user_blocks_blocked_user_id_fkey |
|
|
Restrict delete | ||
| shop_content_blocks_page_id_fkey |
|
|
Restrict delete | ||
| live_rating_stats_live_id_fkey |
|
|
Restrict delete | ||
| admin_notifications_user_id_fkey |
|
|
Restrict delete | ||
| follows_ibfk_1 |
|
|
Restrict delete | ||
| follows_ibfk_2 |
|
|
Restrict delete | ||
| live_kicks_live_id_fkey |
|
|
Restrict delete | ||
| live_kicks_kicked_by_fkey |
|
|
Restrict delete | ||
| live_kicks_user_id_fkey |
|
|
Restrict delete | ||
| order_commissions_order_id_fkey |
|
|
Restrict delete | ||
| shipping_addresses_user_id_fkey |
|
|
Restrict delete | ||
| auction_bids_ibfk_2 |
|
|
Restrict delete | ||
| auction_bids_ibfk_1 |
|
|
Restrict delete | ||
| review_replies_review_id_fkey |
|
|
Restrict delete | ||
| review_replies_shop_id_fkey |
|
|
Restrict delete | ||
| shop_staffs_ibfk_2 |
|
|
Restrict delete | ||
| shop_staffs_ibfk_1 |
|
|
Restrict delete | ||
| raffle_winners_ibfk_1 |
|
|
Restrict delete | ||
| raffle_winners_ibfk_2 |
|
|
Restrict delete | ||
| transfer_logs_shop_settlement_id_fkey |
|
|
Restrict delete | ||
| product_sizes_product_id_fkey |
|
|
Cascade on delete | ||
| shipments_order_id_fkey |
|
|
Cascade on delete | ||
| report_responses_report_id_fkey |
|
|
Restrict delete | ||
| report_responses_admin_id_fkey |
|
|
Restrict delete | ||
| live_likes_live_id_fkey |
|
|
Restrict delete | ||
| live_likes_user_id_fkey |
|
|
Restrict delete | ||
| user_tutorial_status_user_id_fkey |
|
|
Restrict delete | ||
| tutorial_skip_logs_user_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|