회사
테이블 (7)
DEPARTMENT (Untitled)
- Key — char(4) — 기본 키 — NOT NULL
- departmentName (Field)
- departManager (Field2) — char(30)
- manageStartDate (Field3) — date
- Field4
- employee (Key2) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL
DEPARTMENT_LOCATION (Untitled6)
- departmentid (Key) — char(4) — 기본 키 — NOT NULL
- locationID (Key2) — 기본 키 — NOT NULL
- locationID (Key3) — char(3) — 외래 키 → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled5)
- dependnetid (Key) — char(10) — 기본 키 — NOT NULL
- dependentName (Field) — char(30)
- ssn (Field2) — char(15)
- gender (Field3) — char(1)
- birthDate (Field4) — date
- reelation (Field5) — char(10)
- employeeid (Key2) — char(5) — NOT NULL
- employee (Key3) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL
EMPLOYEE (Untitled2)
- employee (Key) — char(30) — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthdate (Field2) — date
- phone (Field3) — char(1)
- departmentid (Field4) — char(11)
- Key (Key2) — char(4) — 외래 키 → DEPARTMENT.Key — NOT NULL
LOCATION (Untitled7)
- locationID (Key) — char(3) — 기본 키 — NOT NULL
- locationName (Field) — char(20)
- description (Field2)
Project (Untitled4)
- projectid (Key) — 기본 키 — NOT NULL
- project (Field)
- Field2
- Key (Key2) — char(4) — 외래 키 → DEPARTMENT.Key — NOT NULL
W0RKSON (Untitled3)
- worksonid (Key) — char(10) — 기본 키 — NOT NULL
- projectid (Field) — char(10)
- employeeid (Field2) — char(5)
- employee (Key2) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL
- projectid (Key3) — 외래 키 → Project.projectid — NOT NULL