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