Mall
Tables (6)
Delivery (배송)
- delivery_id (배송ID) — bigint — Primary key — NOT NULL
- order_id (주문ID) — bigint — Foreign key → Order.order_id — NOT NULL
- receiver_name (수령인) — varchar(50)
- address (배송지주소) — varchar(255)
- tracking_num (송장번호) — varchar(50)
- status (배송상태) — varchar(20)
Order (주문)
- order_id (주문ID) — bigint — Primary key — NOT NULL
- user_id (회원ID) — bigint — Foreign key → User.user_id — NOT NULL
- order_date (주문일시) — datetime
- total_amount (총결제금액) — int
- status (주문상태) — varchar(20)
Order_Item (주문상품)
- order_item_id (주문상품ID) — bigint — Primary key — NOT NULL
- order_id (주문ID) — bigint — Foreign key → Order.order_id — NOT NULL
- product_id (상품ID) — bigint — Foreign key → Product.product_id — NOT NULL
- quantity (구매수량) — int
Payment (결제)
- payment_id (결제ID) — bigint — Primary key — NOT NULL
- order_id (주문ID) — bigint — Foreign key → Order.order_id — NOT NULL
- payment_method (결제수단) — varchar(20)
- amount (결제금액) — int
- status (결제상태) — varchar(20)
- transaction_at (결제일시) — datetime
Product (상품)
- product_id (상품ID) — bigint — Primary key — NOT NULL
- category (카테고리) — varchar(50)
- name (상품명) — varchar(100)
- price (가격) — int
- stock_quantity (재고수량) — int
- is_sold_out (품절 여부) — boolean
User (회원)
- user_id (회원ID) — bigint — Primary key — NOT NULL
- login_id (로그인ID) — varchar(50)
- password (비밀번호) — varchar(255)
- name (이름) — varchar(50)
- phone (전화번호) — varchar(20)
- created_at (가입일시) — datetime