test

Tables (4)

category (Untitled3)

  • category_id (카테고리ID) — PK — Primary key — NOT NULL
  • parent_id (상위카테고리ID) — FK
  • name (카테고리명) — NOT NULL

product (Untitled4)

  • id (판매상품ID) — PK — Primary key — NOT NULL
  • product_id (상품ID) — FK
  • vendor_id (판매자Id) — FK
  • base_price (기본가격) — NOT NULL
  • stock_quantity (재고수량) — 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
  • user_id (사용자ID) — FK — Foreign key → users.user_id — NOT NULL
  • Field2