데이터베이스

테이블 (5)

Untitled (EMOLOYEE)

  • Key (ssn) — int — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (gender) — char(5)
  • Field (address) — char(30)
  • Field (salary) — int
  • Field (birthDate) — date
  • Field (department) — char(20)
  • Field (supervisor) — char(20)
  • Field (worksOn) — char(20)

Untitled (WORKS-ON)

  • Field (hours) — int
  • Key (ssn2) — int — 외래 키 → Untitled.Key — NOT NULL
  • empSSN (ProNo) — char(14) — 외래 키 → employee.empSSN — NOT NULL

Untitled (DEPENDENT)

  • Key (birthDate) — date — 기본 키 — NOT NULL
  • Field (dependentName) — char(20)
  • Field (gender) — char(5)
  • Field (relationship) — char(20)
  • Field (parent) — char(20)
  • Key (ssn) — int — 외래 키 → Untitled.Key — NOT NULL

deparment (DEPARTMENT)

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

employee (PROJECT)

  • empSSN (ProNo) — char(14) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (location) — char(10)
  • Key (controllingDepartment) — int — 외래 키 → deparment.Key — NOT NULL