team_project
테이블 (3)
고객 (.,)
- customerId (기본키) — bigint — 기본 키 — NOT NULL
- customerName (Field) — varchar(20)
- email (UNIQUE) — varchar(100)
- phoneNumber (Field4) — varchar(100)
- status (Field2) — DATETIME
- createdAt (Field3) — DATETIME
- updateAt (Field5)
관리자 (,)
- adminId (기본키) — bigint — 기본 키 — NOT NULL
- phoneNumber (Field) — varchar(20)
- role (Field1) — varchar(100)
- email (Field4) — varchar(100) UNIQUE
- adminName (Field2) — varchar(20)
- password (Field3) — varchar(100) UNIQUE
- status (Field5) — varchar(20)
- createdAt (Field6)
- acceptedAt (Field7)
- updateAt (Field8) — Date
상품 (..)
- productId (기본키) — bigint — 기본 키 — NOT NULL
- adminId (기본키2) — bigint — 외래 키 → 관리자.adminId — NOT NULL
- productName (Field) — varchar(20)
- category (UNIQUE) — varchar(100)
- price (Field4) — varchar(100)
- quantity (Field2) — DATETIME
- status (Field3) — DATETIME
- createdAt (Field5)
- updateAt (Field6)