2023_0321_3주차 과제
테이블 (4)
Untitled
- Key (departmentID) — char(5) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (location) — char(30)
- Field (manager) — char(10)
- Field (managesStaetDate)
- Key (employeeID) — char(10) — 외래 키 → Untitled3.Key — NOT NULL
Untitled2
- Key (projectID) — int — 기본 키 — NOT NULL
- Field (name) — char(70)
- Field (location) — char(30)
- Field (controllingDepartment) — char(30)
- Field
- Key (departmentID) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (employeeID) — char(10) — 외래 키 → Untitled3.Key — NOT NULL
Untitled3
- Key (employeeID) — char(10) — 기본 키 — NOT NULL
- Field (ssn) — char(12)
- Field (name) — char(30)
- Field (gender) — char(1)
- Field (address) — char(50)
- Field (degree) — char(50)
- Field (salsry) — int(10)
- Field (birthDate) — date
- Key (departmentID) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled4
- Key (familyID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(12)
- Field (gender) — char(1)
- Field (birthdate) — date
- Field
- Key (employeeID) — char(10) — 외래 키 → Untitled3.Key — NOT NULL