모델링예제20,21-2111150송찬혁

테이블 (7)

DEPARTMENT (Untitled)

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

DEPARTMENT_LOCATION (Untitled6)

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

DEPENDENT (Untitled3)

  • dependentID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • gender (Field2) — char(1)
  • birthDate (Field3) — date
  • relation (Field4) — char(10)
  • employeeSsn (Field5) — char(12)
  • ssn (Key2) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled2)

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

LOCATION (Untitled7)

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

PROJECT (Untitled5)

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

WORKSON (Untitled4)

  • ssn (Key) — char(12) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projectID (Key2) — char(20) — 외래 키 → PROJECT.projectID — NOT NULL
  • projectID (Field2) — char(20)
  • hour (Field3)