EX0

테이블 (7)

DEPARTMENT (Untitled)

  • departmentNo (Key) — char(4) — 기본 키 — NOT NULL
  • departmentName (Field) — char(20)
  • departmentManager (Field2) — char(30)
  • departmentmanageStartDate (Field3) — date
  • employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL

DEPARTMENT_LOCATION (Untitled5)

  • departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL
  • locationNo (Field2) — char(4)
  • locationName (Field) — char(10)
  • locationNo (Key) — char(4) — 외래 키 → LOCATION.locationNo — NOT NULL

EMPLOYEE (Untitled2)

  • employeeId (Key) — char(13) — 기본 키 — NOT NULL
  • employeeName (Field) — char(30)
  • employeeBirthdate (Field2) — date
  • employeeAdress (Field3) — char(100)
  • employeeSalary (Field4) — char(10)
  • employeeGender (Field5) — char(6)
  • dapartmentId (Field6) — char(4)
  • departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL

LOCATION (Untitled6)

  • locationNo (Key) — char(4) — 기본 키 — NOT NULL
  • locationName (Field) — char(10)
  • adress (Field2) — char(100)

PROJECT (Untitled3)

  • projectNo (Key) — char(4) — 기본 키 — NOT NULL
  • projectName (Field) — char(30)
  • projectLocation (Field2) — char(4)
  • departmentNo (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentNo — NOT NULL

works-on (Untitled7)

  • worksonId (Key) — char(4) — 기본 키 — NOT NULL
  • float (Field2) — char(5)
  • employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL
  • projectNo (Key3) — char(4) — 외래 키 → PROJECT.projectNo — NOT NULL

부양가족 (Untitled4)

  • 부양가족주민번호 (Key) — char(12) — 기본 키 — NOT NULL
  • 부양가족이름 (Field) — char(20)
  • 부양가족성별 (Field2) — char(6)
  • 부양가족생년월일 (Field3) — date
  • 사원과의관계 (Field4) — char(20)
  • employeeId (Key2) — char(13) — 외래 키 → EMPLOYEE.employeeId — NOT NULL