slunch-factory-store

Tables (8)

cart_items

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → store_products.id — NOT NULL
  • quantity — INT — NOT NULL
  • user_id — BIGINT
  • session_id — VARCHAR(36)
  • last_accessed_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • order_number — VARCHAR(64) — NOT NULL
  • order_date — DATETIME — NOT NULL
  • original_amount — DECIMAL(15,2) — NOT NULL
  • final_amount — DECIMAL(15,2) — NOT NULL
  • shipping_fee — DECIMAL(15,2) — NOT NULL
  • delivery_address — JSON — NOT NULL
  • discount_info — JSON — NOT NULL
  • product_snapshots — JSON — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • payment_key — VARCHAR(200)
  • payment_method — VARCHAR(32)
  • approved_at — DATETIME
  • payment_secret — VARCHAR(200)
  • receipt_url — TEXT
  • failure_reason — TEXT
  • refunded_amount — DECIMAL(15,2) — NOT NULL
  • refund_history — JSON
  • toss_order_id — VARCHAR(64)
  • is_cart_order — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payment_events

  • id — BIGINT — Primary key — NOT NULL
  • payment_key — VARCHAR(200) — NOT NULL
  • event_type — VARCHAR(64) — NOT NULL
  • status — VARCHAR(32)
  • raw_payload — JSON
  • received_at — DATETIME — NOT NULL
  • processed_at — DATETIME

product_add_ons

  • id — BIGINT — Primary key — NOT NULL
  • main_product_id — BIGINT — Foreign key → store_products.id — NOT NULL
  • add_on_product_id — BIGINT — Foreign key → store_products.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

store_product_images

  • id — BIGINT — Primary key — NOT NULL
  • store_product_id — BIGINT — Foreign key → store_products.id — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • alt_text — VARCHAR(300)
  • image_type — VARCHAR(20) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

store_products

  • id — BIGINT — Primary key — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • tagline — VARCHAR(255)
  • description — TEXT
  • price — INT — NOT NULL
  • discount_rate — DECIMAL(5,4) — NOT NULL
  • discounted_price — INT — NOT NULL
  • categories — JSON — NOT NULL
  • is_new — BOOLEAN — NOT NULL
  • is_best — BOOLEAN — NOT NULL
  • purchase_count — INT — NOT NULL
  • stock_quantity — INT — NOT NULL
  • listed — BOOLEAN — NOT NULL
  • tracks_stock — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

transaction_ledger

  • id — BIGINT — Primary key — NOT NULL
  • source — VARCHAR(16) — NOT NULL
  • original_order_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • user_phone — VARCHAR(30)
  • user_email — VARCHAR(200) — NOT NULL
  • order_number — VARCHAR(64) — NOT NULL
  • order_date — DATETIME — NOT NULL
  • original_amount — DECIMAL(15,2) — NOT NULL
  • final_amount — DECIMAL(15,2) — NOT NULL
  • refunded_amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • payment_key — VARCHAR(200)
  • payment_method — VARCHAR(32)
  • order_snapshot — JSON — NOT NULL
  • archived_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

wishlist_items

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • store_product_id — BIGINT — Foreign key → store_products.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL