test

Tables (3)

category (Untitled3)

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

users (Untitled)

  • id (사용자ID) — PK — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • role (역할) — NOT NULL

vendor (Untitled5)

  • vendor_id (판매자ID) — PK — Primary key — NOT NULL
  • id (사용자ID) — PK — Foreign key → users.id — NOT NULL
  • store_name (상호명) — NOT NULL