project

Tables (11)

cart_items (Untitled9)

  • cart_item_id (장바구니ID) — PK — Primary key — NOT NULL
  • Field

categories (Untitled7)

  • categories_id (카테고리ID) — PK — Primary key — NOT NULL
  • Field

likes (Untitled8)

  • like_id (관심상품) — PK — Primary key — NOT NULL
  • Field

option_groups (Untitled6)

  • option_groups_id (옵션그룹ID) — PK — Primary key — NOT NULL
  • Field

order_items (Untitled11)

  • order_item_id (상세주문상품ID) — PK — Primary key — NOT NULL
  • Field

orders (Untitled10)

  • order_id (주문ID) — PK — Primary key — NOT NULL
  • Field

product_options (Untitled5)

  • option_id (옵션ID) — PK — Primary key — NOT NULL
  • Field

product_vendors (Untitled3)

  • product_vendor_id (상품판매ID) — PK — Primary key — NOT NULL
  • base_price (판매가격)
  • stock_quantity (재고량)

products (Untitled4)

  • product_id (상품ID) — PK — Primary key — NOT NULL
  • Field

users (Untitled)

  • user_id (유저ID) — PK — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • role (역할) — NOT NULL

vendors (Untitled2)

  • vendor_id (판매자ID) — PK — Primary key — NOT NULL
  • store_name (상호명) — NOT NULL