2023 데이터베이스론

테이블 (5)

DEPARTMENT

  • Key (deptNo) — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field (depManger) — char(30)
  • Field (mangerStartDate) — date
  • Field (depLocations) — char(20)
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJET)

  • Key (proNo) — int — 기본 키 — NOT NULL
  • Field (proName) — char(30)
  • Field (controllingDepartment) — char(20)
  • Field (condepLocation) — char(20)
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ManagerdepID) — int — 외래 키 → DEPARTMENT.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key (empSSN) — char(14) — 기본 키 — NOT NULL
  • Field (empName) — char(20)
  • Field (empgender) — char(20)
  • Field (empAddress) — char(30)
  • Field (empSalary) — char(20)
  • Field (empBirthDate) — date
  • Field (empDepartment) — char(20)
  • Field (empSupervisor) — char(20)
  • Field (worksOn) — int
  • Field (project) — char(30)
  • Field (hours) — int
  • Key (deptNo) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (supervisesSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (dependentNo) — int — 기본 키 — NOT NULL
  • Field (dependentName) — char(30)
  • Field (dependentGender) — char(10)
  • Field (dependentDirthDate) — date
  • Field (dependentRelationship) — char(20)
  • Field (Parent) — char(20)
  • Field (employeessn) — int
  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKSON)

  • Key (empSSN) — char(14) — 외래 키 → Untitled.Key — NOT NULL
  • Key (proNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (hoursperWeek) — float