기말과제_점포 운영
테이블 (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