db
Tables (15)
Address
- address_id — INT
- user_id — INT — Foreign key → User.user_id — NOT NULL
- recipient_name — VARCHAR(50)
- phone — VARCHAR(20)
- address — VARCHAR(255)
- is_default — BOOLEAN
Brand
- brand_id — INT
- brand_name — VARCHAR(100)
Cart
- cart_id — INT
- user_id — INT — Foreign key → User.user_id
- created_at — DATETIME
CartItem
- cart_item_id — INT
- cart_id — INT — Foreign key → Cart.cart_id
- product_id — INT — Foreign key → Product.product_id
- option_value_id — INT — Foreign key → OptionValue.option_value_id
- quantity — INT
Category
- category_id — INT
- category_name — VARCHAR(100)
- parent_id — INT — Foreign key → Category.category_id
Inquiry
- inquiry_id — INT
- user_id — INT — Foreign key → User.user_id
- title — VARCHAR(200)
- content — TEXT
- status — VARCHAR(50)
- created_at — DATETIME
OptionValue
- option_value_id — INT
- option_id — INT — Foreign key → ProductOption.option_id
- option_value_name — VARCHAR(100)
- stock_quantity — INT
- sku — VARCHAR(100)
OrderItem
- order_item_id — INT
- order_id — INT — Foreign key → Orders.order_id
- product_id — INT — Foreign key → Product.product_id
- option_value_id — INT — Foreign key → OptionValue.option_value_id
- quantity — INT
- price — INT
Orders
- order_id — INT
- user_id — INT — Foreign key → User.user_id
- address_id — INT — Foreign key → Address.address_id
- order_status — VARCHAR(50)
- total_amount — INT
- ordered_at — DATETIME
Payment
- payment_id — INT
- order_id — INT — Foreign key → Orders.order_id
- payment_method — VARCHAR(50)
- payment_status — VARCHAR(50)
- paid_amount — INT
- paid_at — DATETIME
Product
- product_id — INT
- category_id — INT — Foreign key → Category.category_id
- brand_id — INT — Foreign key → Brand.brand_id
- product_name — VARCHAR(100)
- price — INT
- description — TEXT
- main_image — VARCHAR(255)
- created_at — DATETIME
ProductOption
- option_id — INT
- product_id — INT — Foreign key → Product.product_id
- option_name — VARCHAR(100)
- extra_price — INT
Seller
- seller_id — INT
- seller_name — VARCHAR(100)
- business_number — VARCHAR(100)
- seller_phone — VARCHAR(20)
Shipping
- shipping_id — INT
- order_id — INT — Foreign key → Orders.order_id
- courier — VARCHAR(50)
- tracking_number — VARCHAR(100)
- shipping_status — VARCHAR(50)
- shipped_at — DATETIME
- delivered_at — DATETIME
User
- user_id — INT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- created_at — DATETIME