기말과제_점포 운영

테이블 (6)

Untitled (CATEGORY)

  • Key (date) — date — 기본 키 — NOT NULL
  • Field (discription) — longtext
  • Key (workTime) — time — 외래 키 → Untitled.Key — NOT NULL
  • Key (staffID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (storeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (STORE)

  • Key (storeID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (adress) — char(50)
  • Field (phone) — char(11)

Untitled (STAFF)

  • Key (staffID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — char(11)
  • Field (bankNum) — char(20)

Untitled (WORKTIME_STAFF)

  • Key (workTime) — time — 외래 키 → Untitled.Key — NOT NULL
  • Key (staffID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (hourlyWage) — char(10)

Untitled (WORKTIME)

  • Key (workTime) — time — 기본 키 — NOT NULL
  • Field (attendanceTime) — time
  • Field (quittingTime) — time

Untitled (STORE_STAFF)

  • Key (storeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (staffID) — char(30) — 외래 키 → Untitled.Key — NOT NULL