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