1

Tables (29)

admins_profiles

  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

cart_items

  • cart_item_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
  • product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
  • quantity — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

coupons

  • coupon_id — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • discount_method — VARCHAR(20) — NOT NULL
  • discount_value — NUMERIC(12,2) — NOT NULL
  • min_order_amount — NUMERIC(12,2)
  • max_discount_amount — NUMERIC(12,2) — NOT NULL
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

deliveries

  • delivery_id — VARCHAR(36) — Primary key — NOT NULL
  • order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
  • address_id — VARCHAR(36) — Foreign key → delivery_addresses.address_id
  • tracking_number — VARCHAR(100)
  • delivery_type — VARCHAR(10) — NOT NULL
  • carrier — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • memo — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

delivery_addresses

  • address_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • address_name — VARCHAR(100) — NOT NULL
  • recipient_name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — TEXT — NOT NULL
  • address_detail — VARCHAR(255)
  • postal_code — VARCHAR(10)
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

delivery_histories

  • history_id — VARCHAR(36) — Primary key — NOT NULL
  • delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • location_type — VARCHAR(20) — NOT NULL
  • warehouse_id — VARCHAR(36) — Foreign key → warehouses.warehouse_id
  • hub_id — VARCHAR(36) — Foreign key → logistics_hubs.hub_id
  • location — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

inventory_histories

  • history_id — VARCHAR(36) — Primary key — NOT NULL
  • inventory_id — VARCHAR(36) — Foreign key → warehouse_inventory.inventory_id — NOT NULL
  • change_quantity — INTEGER — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

logistics_hubs

  • hub_id — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(100)
  • hub_type — VARCHAR(20)
  • address — TEXT
  • contact_phone — VARCHAR(20)
  • status — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

members_profiles

  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • nickname — VARCHAR(100)
  • point_balance — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

membership_categories

  • category_id — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — NUMERIC(10,2) — NOT NULL
  • description — TEXT
  • benefits — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

order_claims

  • claim_id — VARCHAR(36) — Primary key — NOT NULL
  • order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id — NOT NULL
  • claim_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • reason — TEXT — NOT NULL
  • refund_amount — NUMERIC(12,2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

order_discounts

  • order_discount_id — VARCHAR(36) — Primary key — NOT NULL
  • order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
  • order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id — NOT NULL
  • user_coupon_id — VARCHAR(36) — Foreign key → user_coupons.user_coupon_id
  • coupon_id — VARCHAR(36) — Foreign key → coupons.coupon_id
  • promotion_id — VARCHAR(36) — Foreign key → promotions.promotion_id
  • discount_type — VARCHAR(20) — NOT NULL
  • applied_amount — NUMERIC(12,2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

order_items

  • order_item_id — VARCHAR(36) — Primary key — NOT NULL
  • order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
  • store_order_id — VARCHAR(36) — Foreign key → store_orders.store_order_id — NOT NULL
  • delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id
  • product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
  • product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
  • quantity — INTEGER — NOT NULL
  • unit_price — NUMERIC(12,2) — NOT NULL
  • product_name — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

orders

  • order_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • address_id — VARCHAR(36) — Foreign key → delivery_addresses.address_id
  • membership_id — VARCHAR(36) — Foreign key → user_memberships.membership_id
  • total_price — NUMERIC(12,2) — NOT NULL
  • delivery_fee — NUMERIC(8,2) — NOT NULL
  • discount_amount — NUMERIC(12,2)
  • final_price — NUMERIC(12,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

payments

  • payment_id — VARCHAR(36) — Primary key — NOT NULL
  • order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
  • payment_method — VARCHAR(30)
  • amount — NUMERIC(12,2)
  • status — VARCHAR(20)
  • pg_transaction_id — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

product_categories

  • category_id — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • depth — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

product_options

  • product_option_id — VARCHAR(36) — Primary key — NOT NULL
  • product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
  • options_name — VARCHAR(255)
  • extra_price — NUMERIC(12,2)
  • status — VARCHAR(20)
  • display_order — INTEGER
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

products

  • product_id — VARCHAR(36) — Primary key — NOT NULL
  • store_id — VARCHAR(36) — Foreign key → stores.store_id — NOT NULL
  • category_id — VARCHAR(36) — Foreign key → product_categories.category_id
  • name — VARCHAR(500) — NOT NULL
  • price — NUMERIC(12,2) — NOT NULL
  • description — TEXT
  • is_rocket — BOOLEAN — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

promotions

  • promotion_id — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • discount_method — VARCHAR(20) — NOT NULL
  • discount_value — NUMERIC(12,2) — NOT NULL
  • target_type — VARCHAR(20)
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

review_images

  • image_id — VARCHAR(36) — Primary key — NOT NULL
  • review_id — VARCHAR(36) — Foreign key → reviews.review_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

reviews

  • review_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
  • order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id
  • title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • rating — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

sellers_profiles

  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

store_orders

  • store_order_id — VARCHAR(36) — Primary key — NOT NULL
  • order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
  • store_id — VARCHAR(36) — Foreign key → stores.store_id — NOT NULL
  • delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id
  • subtotal_price — NUMERIC(12,2) — NOT NULL
  • subtotal_delivery_fee — NUMERIC(8,2)
  • status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

stores

  • store_id — VARCHAR(36) — Primary key — NOT NULL
  • seller_id — VARCHAR(36) — Foreign key → sellers_profiles.user_id — NOT NULL
  • store_name — VARCHAR(255) — NOT NULL
  • address — TEXT
  • phone — VARCHAR(20)
  • description — TEXT
  • logo_url — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

user_coupons

  • user_coupon_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • coupon_id — VARCHAR(36) — Foreign key → coupons.coupon_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

user_memberships

  • membership_id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • category_id — VARCHAR(36) — Foreign key → membership_categories.category_id — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • auto_renewal — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

users

  • user_id — VARCHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

warehouse_inventory

  • inventory_id — VARCHAR(36) — Primary key — NOT NULL
  • warehouse_id — VARCHAR(36) — Foreign key → warehouses.warehouse_id — NOT NULL
  • product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
  • quantity — INTEGER — NOT NULL
  • reserved_quantity — INTEGER — NOT NULL
  • safety_stock — INTEGER — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)

warehouses

  • warehouse_id — VARCHAR(36) — Primary key — NOT NULL
  • warehouse_name — VARCHAR(255) — NOT NULL
  • address — TEXT — NOT NULL
  • region — VARCHAR(255) — NOT NULL
  • contact_phone — VARCHAR(20)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — VARCHAR(36)
  • updated_at — TIMESTAMP — NOT NULL
  • updated_by — VARCHAR(36)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(36)