회사데이터베이스
테이블 (7)
DEPARTMENT
- dno — char(3) — 기본 키 — NOT NULL
- dname — char(30)
- phone — char(11)
- manageStartDate — date
- ssn — char(30)
- managerssn (managerSsn) — char(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPARTMENT_LOCATION
- dno — char(3) — 외래 키 → DEPARTMENT.dno — NOT NULL
- locationlD (locationID) — char(10) — 외래 키 → LOCATION.locationlD — NOT NULL
DEPENDENT
- ssn — char(30) — 기본 키 — NOT NULL
- name — char(30)
- birthDate — date
- gender — char(1)
- relation — char(10)
- status — char(50)
- ssnEmployee — char(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn — char(30) — 기본 키 — NOT NULL
- name — char(30)
- address — char(40)
- phone — char(11)
- bdate — date
- salary — int(10)
- gender — char(1)
- email — char(30)
- dno — char(3) — 외래 키 → DEPARTMENT.dno — NOT NULL
- supervisorssn — char(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
LOCATION
- locationlD (locationID) — char(10) — 기본 키 — NOT NULL
- name — char(20)
- address — char(40)
- phone — char(12)
PROJECT
- pno — char(30) — 기본 키 — NOT NULL
- pname — char(30)
- description — text
- dno — char(3) — 외래 키 → DEPARTMENT.dno — NOT NULL
WORKS_ON
- workonlD (workonID) — integer — 기본 키 — NOT NULL
- hour — float
- ssn — char(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- pno — char(30) — 외래 키 → PROJECT.pno — NOT NULL