Relationships

This page documents all foreign key relationships in the database. Total: 116 foreign key constraints.

Auto-generated by node scripts/generate-db-docs.js

ER Diagram

Foreign Keys

Table	Column	References Table	Foreign Column
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`add_to_cart`	`vendor_id`	`vendors_registration`	`id`
`affiliate_payouts`	`affiliate_id`	`vendor_affiliates`	`id`
`affiliate_payouts`	`vendor_id`	`vendors_registration`	`id`
`affiliate_portal_payouts`	`affiliate_id`	`affiliates`	`id`
`affiliate_portal_referrals`	`affiliate_id`	`affiliates`	`id`
`affiliate_portal_referrals`	`referred_vendor_id`	`vendors_registration`	`id`
`affiliate_referrals`	`affiliate_id`	`vendor_affiliates`	`id`
`affiliate_referrals`	`referred_vendor_id`	`vendors_registration`	`id`
`affiliate_referrals`	`referrer_vendor_id`	`vendors_registration`	`id`
`app_credit_purchases`	`pack_id`	`app_credit_packs`	`id`
`blogs`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`clients`	`vendor_id`	`vendors_registration`	`id`
`customer_addresses`	`customer_id`	`customers`	`customer_id`
`inventory_items`	`location_id`	`inventory_locations`	`location_id`
`inventory_items`	`product_id`	`products`	`id`
`inventory_movements`	`inventory_item_id`	`inventory_items`	`id`
`marketplace_theme_installs`	`theme_id`	`marketplace_themes`	`id`
`marketplace_theme_installs`	`version_id`	`marketplace_theme_versions`	`id`
`marketplace_theme_purchases`	`theme_id`	`marketplace_themes`	`id`
`marketplace_theme_reviews`	`theme_id`	`marketplace_themes`	`id`
`marketplace_theme_versions`	`theme_id`	`marketplace_themes`	`id`
`plan_features`	`feature_id`	`features`	`id`
`plan_features`	`plan_id`	`plans`	`id`
`plans`	`inherits_from`	`plans`	`id`
`prefilled_chat_messages`	`qa_id`	`prefilled_chat_qas`	`id`
`prefilled_chat_messages`	`session_id`	`prefilled_chat_sessions`	`id`
`prefilled_chat_monthly_charges`	`widget_id`	`prefilled_chat_widgets`	`id`
`prefilled_chat_qas`	`widget_id`	`prefilled_chat_widgets`	`id`
`prefilled_chat_sessions`	`widget_id`	`prefilled_chat_widgets`	`id`
`referrals`	`referred_user_id`	`customers`	`customer_id`
`referrals`	`referrer_user_id`	`customers`	`customer_id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`referrals`	`vendor_id`	`vendors_registration`	`id`
`reviews`	`parent_review_id`	`reviews`	`review_id`
`reviews`	`parent_review_id`	`reviews`	`review_id`
`shorts`	`vendor_id`	`vendors_registration`	`id`
`store_domains`	`store_id`	`stores`	`store_id`
`store_domains`	`vendor_id`	`vendors_registration`	`id`
`store_template_purchases`	`template_id`	`store_templates`	`id`
`stores`	`added_by_admin_id`	`superadmin`	`id`
`stores`	`vendor_id`	`vendors_registration`	`id`
`vendor_affiliates`	`vendor_id`	`vendors_registration`	`id`
`vendor_app_installs`	`store_id`	`stores`	`store_id`
`vendor_app_installs`	`vendor_id`	`vendors_registration`	`id`
`vendor_commission_rates`	`affiliate_id`	`vendor_affiliates`	`id`
`vendor_commission_rates`	`vendor_id`	`vendors_registration`	`id`
`vendor_credit_transactions`	`store_id`	`stores`	`store_id`
`vendor_credit_transactions`	`vendor_id`	`vendors_registration`	`id`
`vendor_credits`	`store_id`	`stores`	`store_id`
`vendor_credits`	`vendor_id`	`vendors_registration`	`id`
`vendor_refresh_tokens`	`vendor_id`	`vendors_registration`	`id`
`vendor_subscription_payments`	`subscription_id`	`vendor_subscriptions`	`id`
`vendor_subscriptions`	`vendor_id`	`vendors_registration`	`id`
`vendor_theme_purchases`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`receiver_id`	`customers`	`customer_id`
`wallet_transactions`	`sender_id`	`customers`	`customer_id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`
`wallet_transactions`	`vendor_id`	`vendors_registration`	`id`