Schema Overview

This page provides a bird’s-eye view of the Siyahfy PostgreSQL database schema. It is auto-generated by scanning the live database.

Regenerate with: node scripts/generate-db-docs.js

Statistics

Metric	Count
Total tables	112
Total FK relationships	116

Tables by Domain

Core Commerce

Table	Notes
`abandoned_checkouts`
`categories`
`customer_addresses`
`customers`
`discounts`
`draft_orders`
`dynamic_category`
`inventory_items`
`inventory_locations`
`inventory_movements`
`orders`
`product_inventory`
`product_metafields`
`product_stock_alerts`
`products`
`productssku`
`reviews`
`subcategories`
`user_search_histories`
`userroles`

Vendors & Stores

Table	Notes
`store_banner_config`
`store_banner_items`
`store_banners`
`store_domains`
`store_menus`
`store_policies`
`store_template_purchases`
`store_templates`
`stores`
`vendor_affiliates`
`vendor_app_installs`
`vendor_commission_rates`
`vendor_credit_transactions`
`vendor_credits`
`vendor_env_variables`
`vendor_global_settings`
`vendor_logs`
`vendor_refresh_tokens`
`vendor_subscription_payments`
`vendor_subscriptions`
`vendor_theme_purchases`
`vendors_registration`

Themes & Templates

Table	Notes
`theme_config_history`
`theme_configs`
`theme_menus`
`theme_preview_sessions`
`theme_templates`

Developers

Table	Notes
`app_credit_balances`
`app_credit_packs`
`app_credit_purchases`
`app_credit_usage`
`developer_apps`
`developer_bank_details`
`developer_earnings`
`developer_payouts`
`studio_developers`

Marketing

Table	Notes
`affiliate_otps`
`affiliate_payouts`
`affiliate_portal_payouts`
`affiliate_portal_referrals`
`affiliate_referrals`
`affiliate_settings`
`affiliates`
`referrals`
`whatsapp_marketing_settings`
`whatsapp_template_config`

Content

Table	Notes
`blogs`
`pages`
`shorts`

Media

Table	Notes
`media_files`

Payments

Table	Notes
`payments_methods`

Plans & Billing

Table	Notes
`plan_features`
`plans`

Other

Table	Notes
`_migrations`
`add_to_cart`
`addons`
`amazon_store_tokens`
`app_plan_views`
`app_pricing_plans`
`attributes`
`brands`
`clients`
`collection`
`contact_inquiries`
`delhivery_pickup_addresses`
`demorequests`
`features`
`guest_users`
`home_sections`
`marketplace_theme_installs`
`marketplace_theme_purchases`
`marketplace_theme_reviews`
`marketplace_theme_versions`
`marketplace_themes`
`mobile_home_sections`
`otps`
`prefilled_chat_messages`
`prefilled_chat_monthly_charges`
`prefilled_chat_qas`
`prefilled_chat_sessions`
`prefilled_chat_widgets`
`rewards_assigned`
`search_history`
`shipping_zones_stores`
`signup_funnel_events`
`superadmin`
`supplier_purchase`
`suppliers`
`tax_data`
`wallet_transactions`
`whitelist_customers`
`wishlist`

Migration System

Siyahfy uses database migrations to manage schema changes. If you see tables like knex_migrations, SequelizeMeta, or similar, these are used by the migration tooling and are not part of the application domain.