회사데이터베이스

테이블 (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