과제
테이블 (7)
Untitled (EMPLOYEE)
- Key — char(10) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field2 (gender) — char(10)
- Field3 (address) — char(10)
- Field4 (phone) — char(10)
- Field5 (salary) — INT(10)
- Field6 (depID) — char(4)
- Key (Key22) — char(10) — 외래 키 — NOT NULL
- Field (depID2) — char(10) — 외래 키 → Untitled.Field
Untitled (DEPARTMENT)
- Field (depID) — char(10) — 기본 키
- Field2 (NAME) — char(10)
- Field3 (managerID) — char(10)
- Field4 (managerStartDate) — date
- Field5 (empID) — char(10)
- Key (Key3) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field
Untitled (LOCATION)
- Key — 기본 키 — NOT NULL
- Field2 (locName) — char(10)
- Field3 (phone) — char(10)
- Field4 (email) — email
Untitled (PROJECT)
- Key (proID) — char(10) — 기본 키 — NOT NULL
- Field2 (proName) — char(30)
- Field3 (startDate) — date
- Field4 (endDate) — date
- Field5 (description) — text
- Field6 (managerDepID) — char(10)
- Field (depID) — char(10) — 외래 키 → Untitled.Field
Untitled (WORKON)
- Key — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (PROid) — char(10)
- Field (hourPerWeek) — char(10)
- Field2
- Key (proID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (depID2) — char(10) — 외래 키 → Untitled.Field
Untitled (DEPENDANT)
- Key — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (birthDate) — date
- Field (relation) — char(10)
- Field
- Key (Key2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (depID2) — char(10) — 외래 키 → Untitled.Field
Untitled2 (DEPARTMENT_LOCATION)
- Field (depID) — char(10)
- Field (locID) — char(10)
- Field (depID2) — char(10) — 외래 키 → Untitled.Field
- Key — 외래 키 → Untitled.Key — NOT NULL