project1
Tables (4)
admin (관리자)
- admin_id (관리자ID) — INT — Primary key
- admin_name (관리자명) — VARCHAR(100) — NOT NULL
- email (이메일) — VARCHAR(100) — NOT NULL
- password (비밀번호) — VARCHAR(100) — NOT NULL
- phone (전화번호) — VARCHAR(20)
- address (주소) — VARCHAR(50)
brand (브랜드)
- brand_id (브랜드ID) — INT — Primary key
- name (브랜드명) — VARCHAR(100) — NOT NULL
- description (브랜드 설명) — TEXT
- admin_id (등록 관리자 ID) — INT
- admin_id (관리자ID) — INT — Foreign key → admin.admin_id
product (상품)
- product_id (상품ID) — INT — Primary key
- title (상품명) — VARCHAR(255) — NOT NULL
- description (상품 설명) — TEXT
- price (가격) — INT — NOT NULL
- stock (재고 수량) — INT
- category_id (카테고리 ID) — INT
- status (상품 상태) — VARCHAR(50)
- brand_id (브랜드 ID) — INT
- admin_id (관리자ID) — INT — Foreign key → admin.admin_id
user (사용자)
- user_id (사용자ID) — INT — Primary key
- username (사용자명) — VARCHAR(255)
- email (이메일) — VARCHAR(255)
- password (비밀번호) — VARCHAR(255)
- phone (전화번호) — VARCHAR(20)
- address (주소) — VARCHAR(50)