shoppingmall

테이블 (6)

Product (product)

  • product_id — int — 기본 키 — NOT NULL
  • product_name — varchar(20)
  • price — int
  • stock_quantity — varchar(10)
  • cateogory (category) — varchar(10)

User (user)

  • user_id — int — 기본 키 — NOT NULL
  • user_name — varchar(20)
  • password — varchar(20)
  • email — varchar(20)
  • phone_number — varchar(20)

cart

  • cart_id — int — 기본 키
  • product_id — int
  • user_id — int — 외래 키 → User.user_id — NOT NULL

cart_item

  • cart_item_id — int — 기본 키 — NOT NULL
  • product_id — int
  • quantity — int
  • Field
  • cart_id — int — 외래 키 → cart.cart_id
  • product_id (product_id2) — int — 외래 키 → Product.product_id — NOT NULL

category

  • category_id — int — 기본 키 — NOT NULL
  • category_name — varchar(10)

상품 (Untitled)

  • product_id — int — 기본 키 — NOT NULL
  • sex — boolean
  • kids (kids_id) — int
  • Sports (Sports_id) — int