2011256_강혜영 (20,21)
테이블 (7)
DEPARTMENT (Untitled)
- departmentID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(20)
- phone (Field2) — char(20)
- email (Field3) — email
- manager (Field4) — char(10)
- startManagerDate (Field5) — date
- location (Field6) — char(30)
- ssn (Key2) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPARTMENT_LOCATION (.)
- departmentID (Key) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
- Key (locationID) — char(3) — 외래 키 → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled5)
- dependentID — char(10) — 기본 키 — NOT NULL
- name — char(30)
- gender — char(1)
- birthDater (birthDate) — date
- relation — char(10)
- ssn (Key) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — char(12) — 기본 키 — NOT NULL
- name (\) — char(30)
- address (Field2) — char(50)
- email (Field3) — email
- phone (Field4) — char(12)
- departmentID (Key2) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
LOCATION (,)
- locationID — char(3) — 기본 키 — NOT NULL
- locationName (.) — char(20)
- description — text
PROJECT (Untitled3)
- projectID (Key) — char(20) — 기본 키 — NOT NULL
- Field — char(30)
- description (Field2) — integer
- Field3
WORKSON (Untitled4)
- ssn (Key) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projectID (Key2) — char(20) — 외래 키 → PROJECT.projectID — NOT NULL
- hoer (Field) — float