회사

테이블 (7)

DEPARTMENT (Untitled)

  • Key — char(4) — 기본 키 — NOT NULL
  • departmentName (Field)
  • departManager (Field2) — char(30)
  • manageStartDate (Field3) — date
  • Field4
  • employee (Key2) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL

DEPARTMENT_LOCATION (Untitled6)

  • departmentid (Key) — char(4) — 기본 키 — NOT NULL
  • locationID (Key2) — 기본 키 — NOT NULL
  • locationID (Key3) — char(3) — 외래 키 → LOCATION.locationID — NOT NULL

DEPENDENT (Untitled5)

  • dependnetid (Key) — char(10) — 기본 키 — NOT NULL
  • dependentName (Field) — char(30)
  • ssn (Field2) — char(15)
  • gender (Field3) — char(1)
  • birthDate (Field4) — date
  • reelation (Field5) — char(10)
  • employeeid (Key2) — char(5) — NOT NULL
  • employee (Key3) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL

EMPLOYEE (Untitled2)

  • employee (Key) — char(30) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • birthdate (Field2) — date
  • phone (Field3) — char(1)
  • departmentid (Field4) — char(11)
  • Key (Key2) — char(4) — 외래 키 → DEPARTMENT.Key — NOT NULL

LOCATION (Untitled7)

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

Project (Untitled4)

  • projectid (Key) — 기본 키 — NOT NULL
  • project (Field)
  • Field2
  • Key (Key2) — char(4) — 외래 키 → DEPARTMENT.Key — NOT NULL

W0RKSON (Untitled3)

  • worksonid (Key) — char(10) — 기본 키 — NOT NULL
  • projectid (Field) — char(10)
  • employeeid (Field2) — char(5)
  • employee (Key2) — char(30) — 외래 키 → EMPLOYEE.employee — NOT NULL
  • projectid (Key3) — 외래 키 → Project.projectid — NOT NULL