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