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)