online-shopping

Tables (4)

member (members)

  • member_id (Key) — int — Primary key — NOT NULL
  • email (이메일) — Varchar
  • name (이름) — Varchar
  • created_at (가입 일시) — Datetime

order (orders)

  • order_id — int — Primary key — NOT NULL
  • member_id — int — Primary key — NOT NULL
  • order_date — Datetime
  • total_amount — int
  • member_id (Key) — int — Foreign key → member.member_id — NOT NULL

order_item

  • order_id — int — Foreign key → order.order_id — NOT NULL
  • member_id — int — Foreign key → order.member_id — NOT NULL
  • quantity (수량) — int
  • price (단가) — int
  • product_id — int — Foreign key → product.product_id — NOT NULL

product (products)

  • product_id — int — Primary key — NOT NULL
  • name (상품명) — char
  • price (가격) — int
  • stock (재고 수량) — int