2023_데이터베이스 수업

테이블 (7)

ISAT (Untitled2)

  • DEPARTMENT (departmentID2) — char(5) — 외래 키 → QDEPARTMENT.DEPARTMENT — NOT NULL
  • Field (departmentID) — char(5)
  • Field (location) — int

QDEPARTMENT (DEPARTMENT)

  • DEPARTMENT (departmentID) — char(5) — 기본 키 — NOT NULL
  • name — char(30)
  • manger (location) — char(30)
  • Field (managerSSN) — char(10)
  • Field (manageStartDate) — date
  • Key (managerEm) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key — 기본 키 — NOT NULL
  • Field (employeeID) — char(10)
  • Field (ssn) — char(12)
  • Field2 (name) — char(30)
  • Field3 (gender) — char(1)
  • Field (address) — char(50)
  • Field (department) — char(50)
  • Field2 (degree) — char(50)
  • Field (salary) — int(10)
  • Field3 (birthdate) — date
  • DEPARTMENT (worksForDepartmentID) — char(5) — 외래 키 → QDEPARTMENT.DEPARTMENT — NOT NULL
  • Key (supercisorEmpID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (projectID) — int
  • Field (name) — char(70)
  • Field (description) — text

Untitled (WORKSON)

  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (worksonID) — int
  • Field (employeeID) — char(10)
  • Field (projectID) — int
  • Field (hours) — float
  • Key — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Field (ssn) — char(12)
  • Field (name) — char(30)
  • Field (gender) — char(1)
  • Field (birsthdate) — date
  • Field (relationship) — char(20)
  • Field (employeeID) — char(10)
  • Key — 외래 키 → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Field (locationID) — int
  • Field