lion

Tables (3)

order (Untitled2)

  • id (주문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
  • date (주문일자) — int

product (Untitled3)

  • id (상품id) — int — Primary key — NOT NULL
  • name (상품이름) — char
  • price (상품가격) — int
  • stock (재고) — int

user (Untitled)

  • id (회원id) — int — Primary key — NOT NULL
  • name (이름) — char
  • email (이메일) — char
  • password (비밀번호) — int
  • phone (전화번호) — int