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