MiniShoppingMall

Tables (3)

Orders (주문)

  • id (주문번호) — int — Primary key — NOT NULL
  • user_id (사용자id) — int — Foreign key → User.id — NOT NULL
  • product_id (상품id) — int — Foreign key → Product.id — NOT NULL
  • quantity (수량) — int
  • total_price (총금액) — int
  • created_at (주문일) — datetime

Product (상품)

  • id (상품id) — int — Primary key — NOT NULL
  • name (상품이름) — varchar(20)
  • price (상품가격) — int
  • stock (재고) — int
  • created_at (생성일) — datetime

User (사용자)

  • id (사용자id) — int — Primary key — NOT NULL
  • email (사용자이메일) — varchar(50)
  • name (사용자이름) — varchar(5)
  • created_at (생성일) — datetime