영길
테이블 (6)
DEPARTMENT (Untitled2)
- DepartmentNumber (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(10)
- Manager (Field2) — char(10)
- ManageStartDate (Field3) — date
- Ssn (Key2) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL
- ProjectID (Key3) — char(10) — 외래 키 → PROJECT.ProjectID — NOT NULL
DEPENDANT (Untitled4)
- Name (Field) — char(10)
- Gender (Field2) — char(1)
- DateofBirth (Field3) — date
- Relation (Field4) — char(10)
- Ssn (Key) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL
EMPLOYEE (Untitled)
- Ssn (Key) — bigint(13) — 기본 키 — NOT NULL
- Name (Field) — char(10)
- Gender (Field2) — char(1)
- Address (Field3) — text
- Salary (Field4) — int
- DateofBirth (Field5) — date
- DepartmentNumber (Key2) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL
LOCATION (Untitled6)
- DepartmentNumber (Key) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL
- Name (Field) — char(10)
- Address (Field2) — text
PROJECT (Untitled3)
- ProjectID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(30)
- Location (Field2) — char(10)
- Working Weeks (Field3)
- DirectSupervisor (Field4)
- DepartmentNumber (Key2) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL
WORKON (Untitled5)
- Ssn (Key) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL
- ProjectID (Key2) — char(10) — 외래 키 → PROJECT.ProjectID — NOT NULL