2025_2_database(식별)

테이블 (7)

DEPARTMENT

  • deptNO — char(5) — 기본 키 — NOT NULL
  • name — char(20)
  • Field (description) — text
  • Field (managerStartDate) — date
  • empID — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
  • projNO — char(10) — 외래 키 → PROJECT.projNO — NOT NULL

DEPARTMENTLOCATION (DEPARTMENTLOCATIONS)

  • deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL
  • locationNO — char(3) — 외래 키 → LOCATION.locationNO — NOT NULL

DEPENDENT

  • depdID — char(10) — 기본 키 — NOT NULL
  • gender — char(10)
  • birthDate — date
  • relationship — char(10)
  • name — char(10)
  • parent — char(5)
  • empID — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL

EMPLOYEE

  • empNO — char(10) — 기본 키 — NOT NULL
  • name — char(30)
  • phone — char(11)
  • birthDate — date
  • Field (department) — char(10)
  • gender — char(10)
  • address — char(35)
  • salary — char(10)
  • deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL
  • empNO (supEmpNO) — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL

LOCATION

  • locationNO — char(3) — 기본 키 — NOT NULL
  • name — char(10)
  • address — char(35)
  • Field (phone) — char(11)
  • empNO (managerempNO) — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL

PROJECT

  • projNO — int10) — 기본 키 — NOT NULL
  • name — char(15)
  • location — char(20)
  • controllingDepartment — char(20)
  • deptNO — char(5) — 외래 키 → DEPARTMENT.deptNO — NOT NULL

WORKSON

  • empNO — char(10) — 외래 키 → EMPLOYEE.empNO — NOT NULL
  • projNO — int(10) — 외래 키 → PROJECT.projNO — NOT NULL
  • hoursPerWeek (hour) — float