2011256_강혜영 (20,21)

테이블 (7)

DEPARTMENT (Untitled)

  • departmentID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • phone (Field2) — char(20)
  • email (Field3) — email
  • manager (Field4) — char(10)
  • startManagerDate (Field5) — date
  • location (Field6) — char(30)
  • ssn (Key2) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL

DEPARTMENT_LOCATION (.)

  • departmentID (Key) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
  • Key (locationID) — char(3) — 외래 키 → LOCATION.locationID — NOT NULL

DEPENDENT (Untitled5)

  • dependentID — char(10) — 기본 키 — NOT NULL
  • name — char(30)
  • gender — char(1)
  • birthDater (birthDate) — date
  • relation — char(10)
  • ssn (Key) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled2)

  • ssn (Key) — char(12) — 기본 키 — NOT NULL
  • name (\) — char(30)
  • address (Field2) — char(50)
  • email (Field3) — email
  • phone (Field4) — char(12)
  • departmentID (Key2) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL

LOCATION (,)

  • locationID — char(3) — 기본 키 — NOT NULL
  • locationName (.) — char(20)
  • description — text

PROJECT (Untitled3)

  • projectID (Key) — char(20) — 기본 키 — NOT NULL
  • Field — char(30)
  • description (Field2) — integer
  • Field3

WORKSON (Untitled4)

  • ssn (Key) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projectID (Key2) — char(20) — 외래 키 → PROJECT.projectID — NOT NULL
  • hoer (Field) — float