DatabaseAll Tables
All Tables
This page lists every table in the public schema with full column details.
Total: 112 tables.
Auto-generated by
node scripts/generate-db-docs.js
_migrations
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('_migrations_id_seq'::regclass) | - |
| filename | character varying(255) | No | - | - |
| executed_at | timestamp without time zone | Yes | now() | - |
abandoned_checkouts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('abandoned_checkouts_id_seq'::regclass) | - |
| customer_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_name | character varying(255) | No | - | - |
| cart_data | jsonb | No | - | - |
| total_amount | numeric | No | - | - |
| checkout_started_at | timestamp with time zone | Yes | now() | - |
| checkout_source | character varying(50) | No | 'website'::character varying | - |
| is_recovered | boolean | Yes | false | - |
| region | text | Yes | - | - |
| email_sent | boolean | Yes | - | - |
add_to_cart
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| cart_id | integer | No | nextval('add_to_cart_cart_id_seq'::regclass) | - |
| customer_id | integer | No | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| item_id | integer | No | - | - |
| variation_name | character varying(50) | Yes | - | - |
| quantity | integer | No | 1 | - |
| price | numeric | No | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
| ispreorder | boolean | Yes | false | - |
addons
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('addons_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | integer | No | - | - |
| razorpay_payment_id | text | Yes | - | - |
| razorpay_order_id | text | Yes | - | - |
| status | text | Yes | - | - |
| razorpay_raw_response | jsonb | Yes | - | - |
| addons_selected | jsonb | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
affiliate_otps
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_otps_id_seq'::regclass) | - |
| character varying(255) | No | - | - | |
| otp | character varying(6) | No | - | - |
| expires_at | timestamp without time zone | No | - | - |
| used | boolean | Yes | false | - |
| created_at | timestamp without time zone | Yes | now() | - |
affiliate_payouts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_payouts_id_seq'::regclass) | - |
| affiliate_id | integer | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| amount | numeric | No | - | - |
| status | character varying(20) | Yes | 'pending'::character varying | - |
| razorpay_payout_id | text | Yes | - | - |
| payment_reference | text | Yes | - | - |
| notes | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| paid_at | timestamp without time zone | Yes | - | - |
affiliate_portal_payouts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_portal_payouts_id_seq'::regclass) | - |
| affiliate_id | integer | No | - | - |
| amount | numeric | No | - | - |
| status | character varying(20) | Yes | 'pending'::character varying | - |
| payment_method | character varying(50) | Yes | - | - |
| payment_reference | character varying(255) | Yes | - | - |
| razorpay_payout_id | character varying(255) | Yes | - | - |
| notes | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| paid_at | timestamp without time zone | Yes | - | - |
affiliate_portal_referrals
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_portal_referrals_id_seq'::regclass) | - |
| affiliate_id | integer | No | - | - |
| referral_code | character varying(10) | No | - | - |
| referred_vendor_id | integer | Yes | - | - |
| referred_email | character varying(255) | Yes | - | - |
| referred_name | character varying(255) | Yes | - | - |
| status | character varying(30) | Yes | 'registered'::character varying | - |
| subscription_amount | numeric | Yes | 0 | - |
| discount_applied | numeric | Yes | 0 | - |
| commission_earned | numeric | Yes | 0 | - |
| registered_at | timestamp without time zone | Yes | now() | - |
| subscribed_at | timestamp without time zone | Yes | - | - |
| commission_paid_at | timestamp without time zone | Yes | - | - |
affiliate_referrals
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_referrals_id_seq'::regclass) | - |
| affiliate_id | integer | Yes | - | - |
| referrer_vendor_id | integer | Yes | - | - |
| referred_vendor_id | integer | Yes | - | - |
| referral_code | character varying(10) | Yes | - | - |
| status | character varying(20) | Yes | 'registered'::character varying | - |
| subscription_id | integer | Yes | - | - |
| subscription_amount | numeric | Yes | - | - |
| discount_applied | numeric | Yes | 0 | - |
| commission_earned | numeric | Yes | 0 | - |
| registered_at | timestamp without time zone | Yes | now() | - |
| subscribed_at | timestamp without time zone | Yes | - | - |
| commission_paid_at | timestamp without time zone | Yes | - | - |
affiliate_settings
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliate_settings_id_seq'::regclass) | - |
| referrer_reward_type | character varying(20) | Yes | 'percent'::character varying | - |
| referrer_reward_value | numeric | Yes | 0 | - |
| referred_discount_type | character varying(20) | Yes | 'percent'::character varying | - |
| referred_discount_value | numeric | Yes | 0 | - |
| is_active | boolean | Yes | true | - |
| min_payout_amount | numeric | Yes | 500 | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
affiliates
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('affiliates_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| phone | character varying(20) | Yes | - | - |
| address_line1 | character varying(255) | Yes | - | - |
| address_line2 | character varying(255) | Yes | - | - |
| country | character varying(100) | Yes | - | - |
| state | character varying(100) | Yes | - | - |
| city | character varying(100) | Yes | - | - |
| pincode | character varying(20) | Yes | - | - |
| instagram_link | character varying(255) | Yes | - | - |
| referral_code | character varying(10) | No | - | - |
| referral_link | character varying(255) | Yes | - | - |
| status | character varying(20) | Yes | 'active'::character varying | - |
| total_referrals | integer | Yes | 0 | - |
| successful_referrals | integer | Yes | 0 | - |
| total_earnings | numeric | Yes | 0 | - |
| paid_earnings | numeric | Yes | 0 | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
amazon_store_tokens
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('amazon_store_tokens_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_name | text | No | - | - |
| access_token | text | Yes | - | - |
| refresh_token | text | Yes | - | - |
| token_type | text | Yes | - | - |
| expires_in | integer | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | - | - |
| marketplace_data | jsonb | Yes | - | - |
| selling_partner_id | text | Yes | - | - |
app_credit_balances
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_credit_balances_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(100) | No | - | - |
| app_id | character varying(100) | No | - | - |
| balance | integer | No | 0 | - |
| total_purchased | integer | No | 0 | - |
| total_used | integer | No | 0 | - |
| updated_at | timestamp with time zone | Yes | now() | - |
app_credit_packs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_credit_packs_id_seq'::regclass) | - |
| app_id | character varying(100) | No | - | - |
| name | character varying(50) | No | - | - |
| price_inr | integer | No | - | - |
| credits | integer | No | - | - |
| cost_per_credit | numeric | Yes | - | - |
| badge | character varying(30) | Yes | - | - |
| position | integer | Yes | 0 | - |
| is_active | boolean | Yes | true | - |
| created_at | timestamp with time zone | Yes | now() | - |
app_credit_purchases
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_credit_purchases_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(100) | No | - | - |
| app_id | character varying(100) | No | - | - |
| pack_id | integer | Yes | - | - |
| credits | integer | No | - | - |
| amount_inr | integer | No | - | - |
| gst_inr | integer | No | 0 | - |
| total_inr | integer | No | - | - |
| razorpay_order_id | character varying(100) | Yes | - | - |
| razorpay_payment_id | character varying(100) | Yes | - | - |
| status | character varying(20) | Yes | 'created'::character varying | - |
| raw_response | jsonb | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
app_credit_usage
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_credit_usage_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(100) | No | - | - |
| app_id | character varying(100) | No | - | - |
| action | character varying(50) | No | - | - |
| credits_used | integer | No | - | - |
| metadata | jsonb | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
app_plan_views
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_plan_views_id_seq'::regclass) | - |
| app_id | character varying(100) | No | - | - |
| plan_id | integer | Yes | - | - |
| viewer_vendor_id | integer | Yes | - | - |
| viewer_store_id | character varying(255) | Yes | - | - |
| source | character varying(100) | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
app_pricing_plans
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('app_pricing_plans_id_seq'::regclass) | - |
| app_id | character varying(100) | No | - | - |
| plan_name | character varying(255) | No | - | - |
| price_inr | integer | No | 0 | - |
| billing_cycle | character varying(50) | Yes | 'monthly'::character varying | - |
| features | jsonb | Yes | '[]'::jsonb | - |
| is_active | boolean | Yes | true | - |
| position | integer | Yes | 0 | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
attributes
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| attribute_id | integer | No | nextval('attributes_attribute_id_seq1'::regclass) | - |
| attribute_name | character varying(255) | No | - | - |
| attribute_values | ARRAY | Yes | - | - |
| category | text | Yes | - | - |
| subcategory | text | Yes | - | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
blogs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('blogs_id_seq'::regclass) | - |
| title | character varying(255) | No | - | - |
| slug | character varying(255) | No | - | - |
| meta_description | text | Yes | - | - |
| content | text | No | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| tags | ARRAY | Yes | - | - |
| featured_image | text | Yes | - | - |
| published_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| views | integer | Yes | 0 | - |
| likes | integer | Yes | 0 | - |
| status | character varying(10) | Yes | 'draft'::character varying | - |
| last_updated_at | timestamp with time zone | Yes | now() | - |
brands
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| brand_id | bigint | No | nextval('brands_brand_id_seq'::regclass) | - |
| brand_name | character varying(255) | No | - | - |
| brand_slug | character varying(255) | No | - | - |
| brand_description | text | Yes | - | - |
| brand_logo_url | text | Yes | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | bigint | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| is_featured | boolean | Yes | false | - |
categories
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| category_id | integer | No | nextval('categories_category_id_seq1'::regclass) | - |
| category_name | character varying(255) | No | - | - |
| category_description | text | Yes | - | - |
| category_image_url | character varying(255) | Yes | - | - |
| category_status | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| category_type | character varying(255) | Yes | - | - |
| attribute_cat_id | ARRAY | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | text | Yes | - | - |
| cat_slug | text | Yes | - | - |
clients
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('clients_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| client_name | character varying(255) | No | - | - |
| image_url | character varying(255) | No | - | - |
| status | boolean | Yes | true | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
collection
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| collection_id | integer | No | nextval('collection_collection_id_seq'::regclass) | - |
| title | character varying(255) | No | - | - |
| description | text | Yes | - | - |
| collection_type | jsonb | Yes | - | - |
| meta_data | jsonb | Yes | - | - |
| collection_image | text | Yes | - | - |
| status | character varying(50) | Yes | - | - |
| collection_slug | text | Yes | - | - |
| sort | text | Yes | - | - |
| condition_type | text | Yes | - | - |
| store | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| products | jsonb | Yes | - | - |
| collection_shopify_id | text | Yes | - | - |
contact_inquiries
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('contact_inquiries_id_seq'::regclass) | - |
| customer_id | integer | No | - | - |
| customer_name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| phone | character varying(20) | Yes | - | - |
| subject | character varying(255) | No | - | - |
| message | text | No | - | - |
| date_submitted | timestamp without time zone | No | - | - |
| status | character varying(50) | Yes | 'Pending'::character varying | - |
| category | character varying(50) | Yes | - | - |
| attachments | jsonb | Yes | - | - |
| extra_data | jsonb | Yes | - | - |
| vendor_replies | jsonb | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
customer_addresses
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('customer_addresses_id_seq'::regclass) | - |
| customer_id | integer | Yes | - | - |
| vendor_id | integer | No | - | - |
| store | character varying(255) | No | - | - |
| first_name | character varying(255) | No | - | - |
| last_name | character varying(255) | No | - | - |
| company | character varying(255) | Yes | - | - |
| address | text | No | - | - |
| apartment | character varying(255) | Yes | - | - |
| postalcode | character varying(20) | No | - | - |
| phones_address | character varying(20) | No | - | - |
| country | character varying(100) | No | - | - |
| state | character varying(100) | No | - | - |
| city | character varying(100) | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| default_address | boolean | Yes | false | - |
| address_type | integer | Yes | 2 | - |
customers
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| customer_id | integer | No | nextval('customers_customer_id_seq'::regclass) | - |
| first_name | character varying(255) | No | - | - |
| last_name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| password | character varying(255) | No | - | - |
| phone | character varying(20) | Yes | - | - |
| address_country | character varying(100) | Yes | - | - |
| address_company | character varying(255) | Yes | - | - |
| address_line1 | text | Yes | - | - |
| address_line2 | text | Yes | - | - |
| city | character varying(100) | Yes | - | - |
| state | character varying(100) | Yes | - | - |
| pin_code | character varying(20) | Yes | - | - |
| phone_number_address | character varying(20) | Yes | - | - |
| note | text | Yes | - | - |
| collect_taxes | boolean | Yes | - | - |
| customer_media | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| countryjsonb | jsonb | Yes | - | - |
| created_on | timestamp with time zone | Yes | now() | - |
| email_subscribed | boolean | Yes | - | - |
| sms_subscribed | boolean | Yes | - | - |
| updated_on | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| tags | ARRAY | Yes | - | - |
| manage_address | jsonb | Yes | - | - |
| customer_status | text | Yes | 'pending'::text | - |
| referral_code | character varying(6) | Yes | "substring"(md5((random())::text), 1, 6) | - |
| wallet_balance | numeric | Yes | 0.0 | - |
| shopify_customer_json | jsonb | Yes | - | - |
| shopify_customer_id | text | Yes | - | - |
| cod_enable_status | boolean | Yes | true | - |
| birthday | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
delhivery_pickup_addresses
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('delhivery_pickup_addresses_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| address_jsonb | jsonb | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| vendor_id | integer | Yes | - | - |
demorequests
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('demorequests_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| phone_number | character varying(15) | Yes | - | - |
| request_details | text | No | - | - |
| status | USER-DEFINED | Yes | 'pending'::request_status | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| referral_code | character varying(10) | Yes | - | - |
developer_apps
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('developer_apps_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| app_id | character varying(100) | No | - | - |
| app_name | character varying(255) | No | - | - |
| description | text | Yes | - | - |
| icon_url | text | Yes | - | - |
| category | character varying(100) | Yes | - | - |
| status | character varying(20) | Yes | 'draft'::character varying | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
developer_bank_details
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('developer_bank_details_id_seq'::regclass) | - |
| developer_id | integer | No | - | - |
| account_holder_name | text | No | - | - |
| account_number | text | No | - | - |
| ifsc_code | text | No | - | - |
| bank_name | text | Yes | - | - |
| branch_name | text | Yes | - | - |
| upi_id | text | Yes | - | - |
| pan_number | text | Yes | - | - |
| gst_number | text | Yes | - | - |
| verification_status | text | Yes | 'pending'::text | - |
| verified_by | integer | Yes | - | - |
| verified_at | timestamp without time zone | Yes | - | - |
| rejection_reason | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
developer_earnings
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('developer_earnings_id_seq'::regclass) | - |
| developer_id | integer | No | - | - |
| theme_id | integer | No | - | - |
| purchase_id | integer | No | - | - |
| sale_amount | numeric | No | - | - |
| developer_share | numeric | No | - | - |
| platform_commission | numeric | No | - | - |
| commission_rate | numeric | No | 0.20 | - |
| status | character varying(20) | No | 'pending'::character varying | - |
| payout_id | integer | Yes | - | - |
| buyer_vendor_id | integer | Yes | - | - |
| buyer_store_slug | character varying(255) | Yes | - | - |
| created_at | timestamp with time zone | No | now() | - |
developer_payouts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('developer_payouts_id_seq'::regclass) | - |
| developer_id | integer | No | - | - |
| amount | numeric | No | - | - |
| earnings_count | integer | No | 0 | - |
| payment_method | character varying(50) | Yes | - | - |
| payment_details | jsonb | Yes | - | - |
| status | character varying(20) | No | 'requested'::character varying | - |
| transaction_id | character varying(255) | Yes | - | - |
| notes | text | Yes | - | - |
| processed_by | integer | Yes | - | - |
| requested_at | timestamp with time zone | No | now() | - |
| processed_at | timestamp with time zone | Yes | - | - |
| completed_at | timestamp with time zone | Yes | - | - |
discounts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('discounts_id_seq'::regclass) | - |
| typeof_discount | character varying(255) | Yes | - | - |
| discount_details | jsonb | Yes | - | - |
| active_dates | jsonb | Yes | - | - |
| discount_value | jsonb | Yes | - | - |
| minimum_purchase_requirements | jsonb | Yes | - | - |
| customer_eligibility | jsonb | Yes | - | - |
| maximum_discount_uses | jsonb | Yes | - | - |
| combinations | jsonb | Yes | - | - |
| customer_buys_gets | jsonb | Yes | - | - |
| shipping | jsonb | Yes | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| discount_status | text | Yes | - | - |
| discount_used | text | Yes | - | - |
draft_orders
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| draft_id | integer | No | nextval('draft_orders_draft_id_seq'::regclass) | - |
| draft_number | character varying(50) | No | - | - |
| order_id | integer | Yes | - | - |
| customer_info | jsonb | Yes | - | - |
| products | jsonb | No | - | - |
| subtotal | numeric | No | - | - |
| discount_amount | numeric | Yes | 0.00 | - |
| shipping_amount | numeric | Yes | 0.00 | - |
| tax_amount | numeric | Yes | 0.00 | - |
| status | character varying(50) | Yes | 'draft'::character varying | - |
| shipping_address | jsonb | Yes | - | - |
| billing_address | jsonb | Yes | - | - |
| notes | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| vendor_id | integer | No | - | - |
| store_name | text | No | - | - |
| total_amount | numeric | No | - | - |
| discount_data | jsonb | Yes | - | - |
| tags | ARRAY | Yes | - | - |
| invoice_path | text | Yes | - | - |
dynamic_category
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('dynamic_category_id_seq'::regclass) | - |
| name | text | No | - | - |
| link | text | Yes | - | - |
| image | text | Yes | - | - |
| status | text | Yes | 'active'::text | - |
| store_name | text | No | - | - |
| vendor_id | integer | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
features
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('features_id_seq'::regclass) | - |
| name | text | No | - | - |
| code | text | No | - | - |
| category | text | Yes | - | - |
| description | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| position | integer | Yes | 1 | - |
guest_users
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | bigint | No | nextval('guest_users_id_seq'::regclass) | - |
| character varying(255) | No | - | - | |
| is_converted | boolean | Yes | false | - |
| is_verified | boolean | Yes | false | - |
| otp | character varying(10) | Yes | - | - |
| otp_expiry | timestamp without time zone | Yes | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | bigint | No | - | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
home_sections
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('home_sections_id_seq'::regclass) | - |
| layout_type | character varying(50) | No | - | - |
| grid_no | integer | No | - | - |
| main_heading | character varying(255) | No | - | - |
| sub_heading | character varying(255) | Yes | - | - |
| description | text | Yes | - | - |
| status | boolean | Yes | true | - |
| layout_direction | character varying(50) | No | - | - |
| content | jsonb | Yes | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
inventory_items
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('inventory_items_id_seq'::regclass) | - |
| product_id | integer | No | - | - |
| variant_id | character varying(255) | Yes | - | - |
| location_id | integer | No | - | - |
| sku | character varying(255) | Yes | - | - |
| available | integer | No | 0 | - |
| committed | integer | No | 0 | - |
| on_hand | integer | No | 0 | - |
| is_tracked | boolean | Yes | true | - |
| low_stock_threshold | integer | Yes | 5 | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
inventory_locations
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| location_id | integer | No | nextval('inventory_locations_location_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_name | text | No | - | - |
| name | character varying(255) | No | - | - |
| address | text | Yes | - | - |
| city | character varying(100) | Yes | - | - |
| state | character varying(100) | Yes | - | - |
| pin_code | character varying(20) | Yes | - | - |
| is_default | boolean | Yes | false | - |
| is_active | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
inventory_movements
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| movement_id | integer | No | nextval('inventory_movements_movement_id_seq'::regclass) | - |
| inventory_item_id | integer | No | - | - |
| quantity_change | integer | No | - | - |
| available_after | integer | No | - | - |
| reason | character varying(50) | No | - | - |
| reference_type | character varying(50) | Yes | - | - |
| reference_id | character varying(255) | Yes | - | - |
| notes | text | Yes | - | - |
| created_by | character varying(255) | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
marketplace_theme_installs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('marketplace_theme_installs_id_seq'::regclass) | - |
| theme_id | integer | No | - | - |
| version_id | integer | No | - | - |
| store_slug | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| is_active | boolean | Yes | false | - |
| installed_at | timestamp with time zone | Yes | now() | - |
| activated_at | timestamp with time zone | Yes | - | - |
marketplace_theme_purchases
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('marketplace_theme_purchases_id_seq'::regclass) | - |
| theme_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_slug | character varying(255) | Yes | - | - |
| amount_inr | integer | No | - | - |
| razorpay_order_id | character varying(255) | Yes | - | - |
| razorpay_payment_id | character varying(255) | Yes | - | - |
| status | character varying(30) | Yes | 'pending'::character varying | - |
| created_at | timestamp with time zone | Yes | now() | - |
marketplace_theme_reviews
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('marketplace_theme_reviews_id_seq'::regclass) | - |
| theme_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_slug | character varying(255) | Yes | - | - |
| rating | integer | No | - | - |
| title | character varying(255) | Yes | - | - |
| body | text | Yes | - | - |
| is_published | boolean | Yes | true | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
marketplace_theme_versions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('marketplace_theme_versions_id_seq'::regclass) | - |
| theme_id | integer | No | - | - |
| version | character varying(20) | No | - | - |
| config | jsonb | No | '{}'::jsonb | - |
| section_schemas | jsonb | Yes | '{}'::jsonb | - |
| changelog | text | Yes | - | - |
| status | character varying(30) | Yes | 'pending'::character varying | - |
| review_notes | text | Yes | - | - |
| submitted_at | timestamp with time zone | Yes | now() | - |
| reviewed_at | timestamp with time zone | Yes | - | - |
| reviewed_by | integer | Yes | - | - |
| source_files | jsonb | Yes | - | - |
marketplace_themes
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('marketplace_themes_id_seq'::regclass) | - |
| theme_slug | character varying(100) | No | - | - |
| developer_id | integer | No | - | - |
| name | character varying(255) | No | - | - |
| tagline | character varying(500) | Yes | - | - |
| description | text | Yes | - | - |
| category | character varying(100) | Yes | 'general'::character varying | - |
| price_inr | integer | Yes | 0 | - |
| thumbnail_url | text | Yes | - | - |
| preview_images | jsonb | Yes | '[]'::jsonb | - |
| demo_store_slug | character varying(255) | Yes | - | - |
| status | character varying(30) | Yes | 'draft'::character varying | - |
| is_featured | boolean | Yes | false | - |
| tags | jsonb | Yes | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
| draft_config | jsonb | Yes | - | - |
| draft_files | jsonb | Yes | - | - |
| price_usd | integer | Yes | 0 | - |
| terminated_at | timestamp with time zone | Yes | - | - |
| terminated_by | integer | Yes | - | - |
| terminate_reason | text | Yes | - | - |
| terminate_until | timestamp with time zone | Yes | - | - |
| pre_terminate_status | text | Yes | - | - |
media_files
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('media_files_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| extension | text | Yes | - | - |
| alt_text | text | Yes | - | - |
| date | timestamp with time zone | No | - | - |
| type | character varying(50) | No | - | - |
| size | character varying(50) | No | - | - |
| link | character varying(255) | Yes | - | - |
| media_url | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| for_table | text | Yes | - | - |
mobile_home_sections
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('home_sections_id_seq'::regclass) | - |
| layout_type | character varying(50) | No | - | - |
| grid_no | integer | No | - | - |
| main_heading | character varying(255) | No | - | - |
| sub_heading | character varying(255) | Yes | - | - |
| description | text | Yes | - | - |
| status | boolean | Yes | true | - |
| layout_direction | character varying(50) | No | - | - |
| content | jsonb | Yes | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
orders
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| order_id | integer | No | nextval('orders_order_id_seq'::regclass) | - |
| order_date | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| current_order_status | character varying(50) | Yes | - | - |
| customer | jsonb | No | - | - |
| channel | character varying(50) | Yes | - | - |
| total_price | numeric | Yes | - | - |
| is_full_paid | boolean | Yes | - | - |
| payment_status | character varying(50) | Yes | - | - |
| is_fulfilled | boolean | Yes | - | - |
| fulfilled_status | character varying(50) | Yes | - | - |
| total_items | integer | Yes | - | - |
| delivery_method | text | Yes | - | - |
| order_note | text | Yes | - | - |
| shipping_address | jsonb | No | - | - |
| items | jsonb | No | - | - |
| order_summary | jsonb | No | - | - |
| tags | ARRAY | Yes | - | - |
| vendor_id | integer | No | - | - |
| store_name | text | No | - | - |
| on_hold | jsonb | Yes | - | - |
| split_items | jsonb | Yes | - | - |
| tracking_details | jsonb | Yes | - | - |
| fulfill_orders | jsonb | Yes | - | - |
| original_order_data | jsonb | Yes | - | - |
| reasonforedit | text | Yes | - | - |
| updated_at | timestamp with time zone | Yes | - | - |
| isarchived | boolean | Yes | false | - |
| refund_products | jsonb | Yes | - | - |
| refund_info | jsonb | Yes | - | - |
| return_items | jsonb | Yes | - | - |
| exchange_items | jsonb | Yes | - | - |
| return_summary | jsonb | Yes | - | - |
| shippingcarrier | jsonb | Yes | - | - |
| returned_date | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| cancel_orders | jsonb | Yes | - | - |
| discount_data_orders | jsonb | Yes | - | - |
| packaging_path | text | Yes | - | - |
| shopify_order_json | jsonb | Yes | - | - |
| user_type | text | Yes | - | - |
| payment_details | jsonb | Yes | - | - |
| cashfree_order_id | text | Yes | - | - |
| razorpay_details | jsonb | Yes | - | - |
| order_currency | text | Yes | 'INR'::text | - |
| carrier_response | jsonb | Yes | - | - |
| manual_order_status | text | Yes | 'Open'::text | - |
| order_date_ist | timestamp without time zone | Yes | - | - |
| stripe_payment_intent_id | text | Yes | - | - |
| stripe_checkout_session_id | text | Yes | - | - |
otps
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| character varying(255) | No | - | - | |
| otp | text | No | - | - |
| expiry_time | timestamp without time zone | No | - | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
pages
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('pages_id_seq'::regclass) | - |
| title | character varying(255) | No | - | - |
| slug | character varying(255) | No | - | - |
| meta_description | text | Yes | - | - |
| content | text | No | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| tags | ARRAY | Yes | - | - |
| featured_image | text | Yes | - | - |
| published_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| views | integer | Yes | 0 | - |
| likes | integer | Yes | 0 | - |
| status | character varying(10) | Yes | 'draft'::character varying | - |
| last_updated_at | timestamp with time zone | Yes | now() | - |
| theme_template | character varying(50) | Yes | 'default'::character varying | - |
payments_methods
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('payments_methods_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| payment_methods | jsonb | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| payment_method_status | text | Yes | - | - |
plan_features
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('plan_features_id_seq'::regclass) | - |
| plan_id | integer | Yes | - | - |
| feature_id | integer | Yes | - | - |
| included | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | now() | - |
plans
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('plans_id_seq'::regclass) | - |
| name | text | No | - | - |
| monthly_price | numeric | Yes | - | - |
| yearly_price | numeric | Yes | - | - |
| description | text | Yes | - | - |
| inherits_from | integer | Yes | - | - |
| is_active | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | now() | - |
| old_monthly_price | integer | Yes | - | - |
| old_yearly_price | integer | Yes | - | - |
| razorpay_monthly_plan_id | character varying(50) | Yes | - | - |
| razorpay_yearly_plan_id | character varying(50) | Yes | - | - |
| position | integer | Yes | 1 | - |
| gst_percent | text | Yes | - | - |
prefilled_chat_messages
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('prefilled_chat_messages_id_seq'::regclass) | - |
| session_id | integer | No | - | - |
| sender | character varying(4) | No | - | - |
| content | text | No | - | - |
| qa_id | integer | Yes | - | - |
| created_at | timestamp without time zone | No | now() | - |
prefilled_chat_monthly_charges
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('prefilled_chat_monthly_charges_id_seq'::regclass) | - |
| widget_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(255) | No | - | - |
| credits | integer | No | 5 | - |
| charge_month | character varying(7) | No | - | - |
| status | character varying(20) | No | 'charged'::character varying | - |
| created_at | timestamp with time zone | No | now() | - |
prefilled_chat_qas
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('prefilled_chat_qas_id_seq'::regclass) | - |
| widget_id | integer | No | - | - |
| question | text | No | - | - |
| answer | text | No | - | - |
| position | integer | No | 0 | - |
| created_at | timestamp with time zone | No | now() | - |
prefilled_chat_sessions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('prefilled_chat_sessions_id_seq'::regclass) | - |
| widget_id | integer | No | - | - |
| session_uid | uuid | No | gen_random_uuid() | - |
| visitor_name | character varying(100) | No | - | - |
| visitor_phone | character varying(20) | No | - | - |
| started_at | timestamp without time zone | No | now() | - |
| last_message_at | timestamp without time zone | No | now() | - |
prefilled_chat_widgets
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('prefilled_chat_widgets_id_seq'::regclass) | - |
| widget_uid | uuid | No | gen_random_uuid() | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(255) | No | - | - |
| name | character varying(255) | No | 'My Chat Widget'::character varying | - |
| welcome_msg | text | No | 'Hi! How can I help you today?'::text | - |
| bot_name | character varying(100) | No | 'Support Bot'::character varying | - |
| bot_avatar | text | Yes | - | - |
| primary_color | character varying(7) | No | '#6366f1'::character varying | - |
| font_color | character varying(7) | No | '#1f2937'::character varying | - |
| font_size | integer | No | 14 | - |
| position | character varying(10) | No | 'right'::character varying | - |
| is_active | boolean | No | true | - |
| created_at | timestamp with time zone | No | now() | - |
| updated_at | timestamp with time zone | No | now() | - |
product_inventory
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| inventory_id | integer | No | nextval('product_inventory_inventory_id_seq'::regclass) | - |
| product_id | text | Yes | - | - |
| varaint_name | character varying(50) | No | ''::character varying | - |
| unavailable_inventory | jsonb | Yes | '{"Other": 0, "Damaged": 0, "Safety stock": 0, "Quality control": 0}'::jsonb | - |
| committed_inventory | jsonb | Yes | '{"Other": 0, "Damaged": 0, "Safety stock": 0, "Quality control": 0}'::jsonb | - |
| available | integer | No | 0 | - |
| on_hand | integer | No | 0 | - |
| istracked | boolean | Yes | false | - |
| statustext | text | Yes | - | - |
| status_color | text | Yes | - | - |
| sku_inventory | text | Yes | - | - |
product_metafields
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('product_metafields_id_seq'::regclass) | - |
| name | text | No | - | - |
| validation_value | jsonb | No | - | - |
| status | boolean | Yes | true | - |
| store_name | text | No | - | - |
| vendor_id | integer | No | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
product_stock_alerts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('product_stock_alerts_id_seq'::regclass) | - |
| product_id | integer | No | - | - |
| variant_name | character varying(255) | Yes | - | - |
| customer_email | character varying(255) | No | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| is_notified | boolean | Yes | false | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| notified_at | timestamp without time zone | Yes | - | - |
products
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('products_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| slug | character varying(255) | No | - | - |
| permalink | text | No | - | - |
| date_created | timestamp with time zone | Yes | - | - |
| date_created_gmt | timestamp with time zone | Yes | - | - |
| date_modified | timestamp with time zone | Yes | - | - |
| date_modified_gmt | timestamp with time zone | Yes | - | - |
| type | character varying(50) | Yes | - | - |
| status | character varying(50) | Yes | - | - |
| featured | boolean | Yes | - | - |
| catalog_visibility | character varying(50) | Yes | - | - |
| description | text | Yes | - | - |
| short_description | text | Yes | - | - |
| sku | character varying(100) | Yes | - | - |
| price | numeric | Yes | - | - |
| regular_price | numeric | Yes | - | - |
| sale_price | numeric | Yes | - | - |
| date_on_sale_from | timestamp with time zone | Yes | - | - |
| date_on_sale_from_gmt | timestamp with time zone | Yes | - | - |
| date_on_sale_to | timestamp with time zone | Yes | - | - |
| date_on_sale_to_gmt | timestamp with time zone | Yes | - | - |
| on_sale | boolean | Yes | - | - |
| total_sales | integer | Yes | - | - |
| downloadable | boolean | Yes | - | - |
| download_limit | integer | Yes | - | - |
| download_expiry | character varying | Yes | - | - |
| tax_status | character varying(50) | Yes | - | - |
| tax_class | character varying(50) | Yes | - | - |
| stock_quantity | integer | Yes | - | - |
| stock_status | character varying(50) | Yes | - | - |
| sold_individually | boolean | Yes | false | - |
| weight | character varying(50) | Yes | - | - |
| dimensions | jsonb | Yes | - | - |
| reviews_allowed | boolean | Yes | - | - |
| average_rating | numeric | Yes | - | - |
| rating_count | integer | Yes | - | - |
| parent_id | bigint | Yes | - | - |
| purchase_note | text | Yes | - | - |
| meta_data | jsonb | Yes | - | - |
| categories | jsonb | Yes | - | - |
| attributes | jsonb | Yes | - | - |
| default_attributes | jsonb | Yes | - | - |
| images | jsonb | Yes | - | - |
| variations | jsonb | Yes | '[]'::jsonb | - |
| variation_products | jsonb | Yes | '[]'::jsonb | - |
| related_ids | ARRAY | Yes | - | - |
| upsell_ids | jsonb | Yes | - | - |
| cross_sell_ids | jsonb | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | text | Yes | - | - |
| selectedgroup | text | Yes | - | - |
| saleschannels | jsonb | Yes | '["Online"]'::jsonb | - |
| markets | jsonb | Yes | '["India"]'::jsonb | - |
| collections | jsonb | Yes | '[]'::jsonb | - |
| cost_per_item | text | Yes | ''::text | - |
| taxable | boolean | Yes | false | - |
| search_vector | tsvector | Yes | - | - |
| shopify_json | jsonb | Yes | - | - |
| brand | character varying(255) | Yes | - | - |
| product_metafields | jsonb | Yes | - | - |
| tags | jsonb | Yes | - | - |
| preorder | boolean | Yes | - | - |
| brand_name_from_excel | text | Yes | - | - |
| is_inventory_tracked | boolean | Yes | true | - |
productssku
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| product_id_sku | integer | No | nextval('productssku_product_id_sku_seq'::regclass) | - |
| sku | character varying(255) | No | - | - |
referrals
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('referrals_id_seq'::regclass) | - |
| referrer_user_id | integer | No | - | - |
| referred_user_id | integer | Yes | - | - |
| referral_code | character varying(50) | No | - | - |
| referral_date | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| status | character varying(20) | Yes | 'pending'::character varying | - |
| referral_reward | integer | Yes | 0.0 | - |
| reward_status | character varying(20) | Yes | 'pending'::character varying | - |
| vendor_id | integer | No | - | - |
| store_name | character varying(255) | No | - | - |
| reward_currency | character varying(10) | Yes | 'INR'::character varying | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
reviews
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| review_id | integer | No | nextval('reviews_review_id_seq'::regclass) | - |
| author_object | jsonb | No | - | - |
| rating_value | numeric | Yes | - | - |
| review_text | text | No | - | - |
| submitted_on | timestamp without time zone | Yes | now() | - |
| product_details | jsonb | No | - | - |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| parent_review_id | integer | Yes | - | - |
| is_reply | boolean | Yes | false | - |
| review_status | text | Yes | - | - |
| medias_object | jsonb | Yes | - | - |
| shopify_reviews | jsonb | Yes | - | - |
| order_id | bigint | Yes | - | - |
rewards_assigned
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| reward_id | integer | No | nextval('rewards_assigned_reward_id_seq'::regclass) | - |
| reward_name | character varying(255) | No | - | - |
| reward_type | character varying(50) | No | - | - |
| referrer_benefit | jsonb | No | - | - |
| referred_benefit | jsonb | No | - | - |
| status | character varying(50) | Yes | 'active'::character varying | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
search_history
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('search_history_id_seq'::regclass) | - |
| store_name | text | No | - | - |
| vendor_id | text | No | - | - |
| search_term | text | No | - | - |
| search_category | text | No | - | - |
| results_count | integer | No | 0 | - |
| searched_at | timestamp with time zone | Yes | now() | - |
| ip_address | inet | Yes | - | - |
| user_agent | text | Yes | - | - |
| search_count | integer | Yes | 0 | - |
shipping_zones_stores
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('shipping_zones_stores_id_seq'::regclass) | - |
| profile_name | character varying(255) | Yes | - | - |
| profile_items | jsonb | Yes | - | - |
| fulfillment_locations | jsonb | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
shorts
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('shorts_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_name | character varying(100) | No | - | - |
| platform | character varying(20) | No | - | - |
| title | text | No | - | - |
| video_url | text | No | - | - |
| thumbnail_url | text | Yes | - | - |
| duration_seconds | integer | Yes | - | - |
| is_active | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
signup_funnel_events
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | bigint | No | nextval('signup_funnel_events_id_seq'::regclass) | - |
| session_id | character varying(64) | No | - | - |
| event | character varying(30) | No | - | - |
| text | Yes | - | - | |
| vendor_id | integer | Yes | - | - |
| referral_code | character varying(50) | Yes | NULL::character varying | - |
| ip_address | character varying(45) | Yes | NULL::character varying | - |
| created_at | timestamp with time zone | No | now() | - |
store_banner_config
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_banner_config_id_seq'::regclass) | - |
| store_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_slug | character varying(255) | No | - | - |
| device | character varying(20) | No | - | - |
| media_type | character varying(20) | No | - | - |
| visible | boolean | Yes | false | - |
| banner_height | character varying(20) | Yes | ''::character varying | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
store_banner_items
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_banner_items_id_seq'::regclass) | - |
| store_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_slug | character varying(255) | No | - | - |
| device | character varying(20) | No | - | - |
| media_type | character varying(20) | No | - | - |
| path | text | No | - | - |
| alt | text | Yes | ''::text | - |
| link | text | Yes | ''::text | - |
| sort_order | integer | Yes | 0 | - |
| created_at | timestamp with time zone | Yes | now() | - |
store_banners
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_banners_id_seq'::regclass) | - |
| store_id | integer | No | - | - |
| vendor_id | integer | No | - | - |
| store_slug | character varying(255) | No | - | - |
| device | character varying(20) | No | - | - |
| media_type | character varying(20) | No | - | - |
| show | boolean | Yes | false | - |
| banner_height | character varying(20) | Yes | ''::character varying | - |
| items | jsonb | Yes | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
store_domains
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_domains_id_seq'::regclass) | - |
| store_id | integer | Yes | - | - |
| domain | character varying(255) | No | - | - |
| is_primary | boolean | Yes | true | - |
| created_at | timestamp without time zone | Yes | now() | - |
| vendor_id | integer | Yes | - | - |
| is_main | boolean | Yes | false | - |
| txt_token | text | Yes | - | - |
| verified | boolean | Yes | false | - |
| verified_at | timestamp with time zone | Yes | - | - |
store_menus
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_menus_id_seq'::regclass) | - |
| store_slug | text | No | - | - |
| vendor_id | integer | No | - | - |
| handle | text | No | - | - |
| title | text | No | - | - |
| items | jsonb | No | '[]'::jsonb | - |
| created_at | timestamp with time zone | No | now() | - |
| updated_at | timestamp with time zone | No | now() | - |
store_policies
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| policy_id | integer | No | nextval('store_policies_policy_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| return_refund_policy | text | Yes | ''::text | - |
| privacy_policy | text | Yes | ''::text | - |
| terms_conditions | text | Yes | ''::text | - |
| shipping_policy | text | Yes | ''::text | - |
| cookies_policy | text | Yes | ''::text | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
| about_us | text | Yes | - | - |
store_template_purchases
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_template_purchases_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_slug | text | No | - | - |
| template_id | integer | Yes | - | - |
| amount_inr | integer | No | 0 | - |
| gst_inr | integer | No | 0 | - |
| total_inr | integer | No | 0 | - |
| razorpay_order_id | character varying(100) | Yes | - | - |
| razorpay_payment_id | character varying(100) | Yes | - | - |
| raw_response | jsonb | Yes | - | - |
| status | character varying(20) | Yes | 'created'::character varying | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
store_templates
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('store_templates_id_seq'::regclass) | - |
| name | text | No | - | - |
| slug | text | Yes | - | - |
| author | text | Yes | 'Siyahfy'::text | - |
| description | text | Yes | - | - |
| thumbnail_url | text | Yes | - | - |
| preview_url | text | Yes | - | - |
| theme_config | jsonb | No | - | - |
| category | text | Yes | 'general'::text | - |
| is_free | boolean | Yes | true | - |
| price_inr | integer | Yes | 0 | - |
| is_active | boolean | Yes | true | - |
| position | integer | Yes | 0 | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
stores
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| store_id | integer | No | nextval('stores_store_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| address | character varying(255) | Yes | - | - |
| city | character varying(100) | Yes | - | - |
| state | character varying(100) | Yes | - | - |
| country | character varying(100) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| description | text | Yes | - | - |
| phone | character varying(20) | Yes | - | - |
| character varying(255) | Yes | - | - | |
| website | character varying(255) | Yes | - | - |
| logo_url | character varying(255) | Yes | - | - |
| banner_url | character varying(255) | Yes | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| added_by_admin_id | integer | Yes | - | - |
| status | integer | Yes | 0 | - |
| store_slug | text | Yes | - | - |
| api_key | jsonb | Yes | - | - |
| unitsystem | text | Yes | - | - |
| weightunit | text | Yes | - | - |
| timezone | text | Yes | - | - |
| currency | text | Yes | - | - |
| order_id_prefix | text | Yes | - | - |
| order_id_suffix | text | Yes | - | - |
| template_selected | jsonb | Yes | - | - |
| desktopbanner | jsonb | Yes | - | - |
| mobilebanner | jsonb | Yes | - | - |
| desktopvideo | jsonb | Yes | - | - |
| mobilevideo | jsonb | Yes | - | - |
| font_selected | text | Yes | '--font-red-hat-display'::text | - |
| international_handling | jsonb | Yes | '{}'::jsonb | - |
| cod_settings | jsonb | Yes | '{"is_cod_enabled": true, "min_order_amount": 500, "disabled_products": [], "disabled_categories": []}'::jsonb | - |
| taxable_charges | jsonb | Yes | - | - |
| font_family | text | Yes | - | - |
| layout_mode | text | Yes | - | - |
| isinmaintenance | boolean | Yes | false | - |
| pickup_addresses | jsonb | Yes | '[]'::jsonb | - |
| custom_fonts | jsonb | Yes | '[]'::jsonb | - |
studio_developers
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('studio_developers_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| password | character varying(255) | Yes | - | - |
| google_id | character varying(255) | Yes | - | - |
| avatar_url | text | Yes | - | - |
| email_verified | boolean | Yes | false | - |
| reset_code | character varying(10) | Yes | - | - |
| status | integer | Yes | 2 | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
subcategories
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| subcategory_id | integer | No | nextval('subcategories_subcategory_id_seq1'::regclass) | - |
| subcategory_name | character varying(255) | No | - | - |
| subcategory_description | text | Yes | - | - |
| subcategory_image_url | character varying(255) | Yes | - | - |
| parent_category_id | integer | No | - | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| isfeatured | boolean | Yes | - | - |
| subcat_status | boolean | Yes | - | - |
| nested_subcategories | jsonb | Yes | - | - |
| subcat_slug | text | Yes | - | - |
superadmin
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('superadmin_id_seq'::regclass) | - |
| first_name | character varying(255) | No | - | - |
| last_name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| phone_number | character varying(20) | Yes | - | - |
| password | character varying(255) | No | - | - |
| profile_image | text | Yes | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
supplier_purchase
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| purchase_id | integer | No | nextval('supplier_purchase_purchase_id_seq'::regclass) | - |
| supplierselected | jsonb | Yes | - | - |
| destinationselected | jsonb | Yes | - | - |
| paymentterm | character varying(255) | Yes | - | - |
| suppliercurrency | character varying(10) | Yes | - | - |
| shippingcarrier | character varying(50) | Yes | - | - |
| trackingnumber | character varying(50) | Yes | - | - |
| trackingurl | text | Yes | - | - |
| referencenumber | character varying(50) | Yes | - | - |
| note_to_supplier | text | Yes | - | - |
| tags | ARRAY | Yes | - | - |
| products | jsonb | Yes | - | - |
| status | character varying(50) | Yes | 'draft'::character varying | - |
| estimatedarrival | timestamp without time zone | Yes | - | - |
| costsummarydata | jsonb | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| store_name | text | Yes | - | - |
suppliers
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('suppliers_id_seq'::regclass) | - |
| company | character varying(255) | No | - | - |
| country_region | character varying(255) | No | - | - |
| address | text | No | - | - |
| apartment_suite | text | Yes | - | - |
| city | character varying(255) | No | - | - |
| state | character varying(255) | No | - | - |
| pin_code | character varying(10) | No | - | - |
| contact_name | character varying(255) | No | - | - |
| email_address | character varying(255) | No | - | - |
| phone_number | character varying(20) | Yes | - | - |
| vendor_id | character varying(50) | Yes | - | - |
| phonenumbercode | text | Yes | - | - |
tax_data
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| tax_id | integer | No | nextval('tax_data_tax_id_seq'::regclass) | - |
| country_name | character varying(255) | No | - | - |
| country_tax_rate | numeric | No | - | - |
| state_data | jsonb | No | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | character varying(255) | No | - | - |
theme_config_history
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('theme_config_history_id_seq'::regclass) | - |
| store_slug | text | No | - | - |
| vendor_id | integer | No | - | - |
| config | jsonb | No | - | - |
| action | text | No | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
theme_configs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('theme_configs_id_seq'::regclass) | - |
| store_slug | text | No | - | - |
| vendor_id | integer | No | - | - |
| config | jsonb | No | '{}'::jsonb | - |
| published_config | jsonb | Yes | - | - |
| status | text | Yes | 'draft'::text | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
| published_at | timestamp with time zone | Yes | - | - |
| theme_name | text | Yes | 'free_theme'::text | - |
theme_menus
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('theme_menus_id_seq'::regclass) | - |
| store_slug | text | No | - | - |
| vendor_id | integer | No | - | - |
| handle | text | No | - | - |
| title | text | No | - | - |
| items | jsonb | No | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
theme_preview_sessions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | uuid | No | gen_random_uuid() | - |
| config | jsonb | No | - | - |
| section_schemas | jsonb | Yes | '{}'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
theme_templates
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| template_id | integer | No | nextval('theme_templates_template_id_seq'::regclass) | - |
| template_name | character varying(255) | No | - | - |
| template_image | text | Yes | - | - |
| template_description | text | Yes | - | - |
| template_created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| template_updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| template_changes | text | Yes | - | - |
| template_links | jsonb | Yes | '[]'::jsonb | - |
| template_install_command | text | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| preview_url | text | Yes | - | - |
user_search_histories
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('user_search_histories_id_seq'::regclass) | - |
| user_id | integer | No | - | - |
| query | text | No | - | - |
| searched_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| store_name | text | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| search_count | integer | Yes | 1 | - |
| user_type | text | Yes | 'user'::text | - |
userroles
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('userroles_id_seq'::regclass) | - |
| name | character varying(255) | No | - | - |
| character varying(255) | No | - | - | |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | character varying(255) | Yes | - | - |
| assigned_roles | jsonb | Yes | - | - |
| usersince | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| profile_update | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| password | text | Yes | - | - |
| phoneotpenabled | boolean | Yes | false | - |
| phone | text | Yes | - | - |
vendor_affiliates
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_affiliates_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| referral_code | character varying(10) | No | - | - |
| referral_link | text | Yes | - | - |
| status | character varying(20) | Yes | 'active'::character varying | - |
| company_name | text | Yes | - | - |
| website_url | text | Yes | - | - |
| promotion_method | text | Yes | - | - |
| total_referrals | integer | Yes | 0 | - |
| successful_referrals | integer | Yes | 0 | - |
| total_earnings | numeric | Yes | 0 | - |
| paid_earnings | numeric | Yes | 0 | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
vendor_app_installs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_app_installs_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | integer | No | - | - |
| app_id | text | No | - | - |
| installed_at | timestamp without time zone | Yes | now() | - |
vendor_commission_rates
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_commission_rates_id_seq'::regclass) | - |
| affiliate_id | integer | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| commission_type | character varying(20) | Yes | 'percent'::character varying | - |
| commission_value | numeric | Yes | 10 | - |
| notes | text | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
vendor_credit_transactions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_credit_transactions_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | integer | No | - | - |
| type | character varying(50) | No | - | - |
| credits | integer | No | - | - |
| description | text | Yes | - | - |
| metadata | jsonb | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
vendor_credits
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_credits_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | integer | No | - | - |
| balance | integer | No | 0 | - |
| total_free | integer | No | 0 | - |
| total_purchased | integer | No | 0 | - |
| total_used | integer | No | 0 | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
vendor_env_variables
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_env_variables_id_seq'::regclass) | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| env_data | jsonb | No | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
vendor_global_settings
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_global_settings_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_name | character varying(255) | No | - | - |
| header_menu | jsonb | No | - | - |
| color_palette | jsonb | Yes | - | - |
| created_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| logo_path | jsonb | Yes | - | - |
| abandoncheckoutsettings | jsonb | Yes | '{}'::jsonb | - |
| color_schemes | jsonb | Yes | - | - |
vendor_logs
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_logs_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_name | text | No | - | - |
| ip_address | text | Yes | - | - |
| message | text | Yes | - | - |
| created_at | timestamp with time zone | Yes | now() | - |
vendor_refresh_tokens
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_refresh_tokens_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| token | character varying(255) | No | - | - |
| expires_at | timestamp with time zone | No | - | - |
| created_at | timestamp with time zone | No | now() | - |
vendor_subscription_payments
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_subscription_payments_id_seq'::regclass) | - |
| subscription_id | integer | No | - | - |
| razorpay_payment_id | character varying(100) | Yes | - | - |
| amount | numeric | Yes | - | - |
| currency | character varying(10) | Yes | 'INR'::character varying | - |
| status | character varying(30) | Yes | 'created'::character varying | - |
| invoice_id | character varying(100) | Yes | - | - |
| payment_date | timestamp without time zone | Yes | - | - |
| method | character varying(50) | Yes | - | - |
| error_reason | text | Yes | - | - |
| raw_response | jsonb | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
vendor_subscriptions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendor_subscriptions_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| razorpay_subscription_id | character varying(100) | No | - | - |
| razorpay_plan_id | character varying(100) | No | - | - |
| razorpay_customer_id | character varying(100) | Yes | - | - |
| plan_name | character varying(100) | Yes | - | - |
| plan_type | character varying(20) | Yes | - | - |
| status | character varying(30) | Yes | 'created'::character varying | - |
| total_count | integer | Yes | - | - |
| paid_count | integer | Yes | 0 | - |
| start_at | timestamp without time zone | Yes | - | - |
| end_at | timestamp without time zone | Yes | - | - |
| current_period_start | timestamp without time zone | Yes | - | - |
| current_period_end | timestamp without time zone | Yes | - | - |
| next_charge_at | timestamp without time zone | Yes | - | - |
| currency | character varying(10) | Yes | 'INR'::character varying | - |
| notes | jsonb | Yes | - | - |
| raw_response | jsonb | Yes | - | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
| charge_at | text | Yes | - | - |
| payment_method | text | Yes | - | - |
| remaining_count | integer | Yes | - | - |
| subscription_response | jsonb | Yes | - | - |
| store_name | text | Yes | - | - |
vendor_theme_purchases
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | bigint | No | nextval('vendor_theme_purchases_id_seq'::regclass) | - |
| vendor_id | bigint | No | - | - |
| theme_key | text | No | - | - |
| theme_title | text | Yes | - | - |
| amount_cents | bigint | No | - | - |
| currency | text | No | 'USD'::text | - |
| razorpay_order_id | text | Yes | - | - |
| razorpay_payment_id | text | Yes | - | - |
| payment_status | text | No | 'initiated'::text | - |
| raw_response | jsonb | Yes | - | - |
| purchased_at | timestamp with time zone | No | now() | - |
| updated_at | timestamp with time zone | No | now() | - |
| status | text | Yes | 'active'::text | - |
| store_name | text | Yes | - | - |
vendors_registration
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('vendors_registration_id_seq'::regclass) | - |
| name | character varying(100) | No | - | - |
| character varying(100) | No | - | - | |
| password | character varying(100) | No | - | - |
| vendor_image | character varying(255) | Yes | - | - |
| joined_date | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| phone_number | character varying(20) | Yes | - | - |
| website_url | character varying(255) | Yes | - | - |
| contact_person_name | character varying(100) | Yes | - | - |
| contact_person_email | character varying(100) | Yes | - | - |
| company_name | character varying(100) | Yes | - | - |
| company_logo_url | character varying(255) | Yes | - | - |
| business_type | character varying(50) | Yes | - | - |
| industry | character varying(50) | Yes | - | - |
| head_office_address_line1 | character varying(255) | Yes | - | - |
| head_office_address_line2 | character varying(255) | Yes | - | - |
| head_office_city | character varying(100) | Yes | - | - |
| head_office_state | character varying(100) | Yes | - | - |
| head_office_country | character varying(100) | Yes | - | - |
| head_office_zipcode | character varying(20) | Yes | - | - |
| is_multiple_shop | boolean | Yes | false | - |
| about_company | text | Yes | - | - |
| vendor_status | integer | Yes | 1 | - |
| reset_code | text | Yes | - | - |
| reset_code_expiry | text | Yes | - | - |
| verified | jsonb | Yes | - | - |
| otpverificationenabled | boolean | Yes | false | - |
| assign_roles | jsonb | Yes | - | - |
| token_notify | ARRAY | Yes | - | - |
| exchange_rate | jsonb | Yes | '{}'::jsonb | - |
| is_legacy_user | boolean | Yes | false | - |
| plan_type | text | Yes | - | - |
| referred_by_code | character varying(10) | Yes | - | - |
| is_first_subscription_done | boolean | Yes | false | - |
| two_fa_secret | text | Yes | - | - |
| two_fa_enabled | boolean | Yes | false | - |
| two_fa_backup_codes | ARRAY | Yes | - | - |
| two_fa_verified_at | timestamp with time zone | Yes | - | - |
| onboarding_data | jsonb | Yes | - | - |
| onboarding_completed | boolean | Yes | false | - |
| updated_at | timestamp without time zone | Yes | now() | - |
| signup_tracking | jsonb | Yes | - | - |
| google_id | text | Yes | - | - |
wallet_transactions
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| wallet_transaction_id | integer | No | nextval('wallet_transactions_wallet_transaction_id_seq'::regclass) | - |
| transaction_type | character varying(50) | No | - | - |
| sender_id | integer | Yes | - | - |
| receiver_id | integer | Yes | - | - |
| store_name | character varying(255) | Yes | - | - |
| vendor_id | integer | Yes | - | - |
| amount | integer | No | 0 | - |
| transaction_date | timestamp with time zone | Yes | CURRENT_TIMESTAMP | - |
| description | text | Yes | - | - |
| customer_id | integer | Yes | - | - |
whatsapp_marketing_settings
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('whatsapp_marketing_settings_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | text | No | - | - |
| enabled | boolean | Yes | false | - |
| created_at | timestamp without time zone | Yes | now() | - |
| updated_at | timestamp without time zone | Yes | now() | - |
whatsapp_template_config
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('whatsapp_template_config_id_seq'::regclass) | - |
| vendor_id | integer | No | - | - |
| store_id | character varying(100) | No | - | - |
| template_id | character varying(100) | No | - | - |
| variable_mapping | jsonb | Yes | '{}'::jsonb | - |
| enabled | boolean | Yes | true | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
whitelist_customers
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| id | integer | No | nextval('whitelist_customers_id_seq'::regclass) | - |
| store_name | text | No | - | - |
| vendor_id | integer | No | - | - |
| white_list_emails | jsonb | Yes | '[]'::jsonb | - |
| created_at | timestamp with time zone | Yes | now() | - |
| updated_at | timestamp with time zone | Yes | now() | - |
wishlist
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| wishlist_id | integer | No | nextval('wishlist_wishlist_id_seq'::regclass) | - |
| customer_id | integer | No | - | - |
| store_name | character varying(255) | No | - | - |
| vendor_id | integer | No | - | - |
| item_id | integer | No | - | - |
| variation_name | character varying(255) | Yes | - | - |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP | - |