영길

테이블 (6)

DEPARTMENT (Untitled2)

  • DepartmentNumber (Key) — char(10) — 기본 키 — NOT NULL
  • Name (Field) — char(10)
  • Manager (Field2) — char(10)
  • ManageStartDate (Field3) — date
  • Ssn (Key2) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL
  • ProjectID (Key3) — char(10) — 외래 키 → PROJECT.ProjectID — NOT NULL

DEPENDANT (Untitled4)

  • Name (Field) — char(10)
  • Gender (Field2) — char(1)
  • DateofBirth (Field3) — date
  • Relation (Field4) — char(10)
  • Ssn (Key) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL

EMPLOYEE (Untitled)

  • Ssn (Key) — bigint(13) — 기본 키 — NOT NULL
  • Name (Field) — char(10)
  • Gender (Field2) — char(1)
  • Address (Field3) — text
  • Salary (Field4) — int
  • DateofBirth (Field5) — date
  • DepartmentNumber (Key2) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL

LOCATION (Untitled6)

  • DepartmentNumber (Key) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL
  • Name (Field) — char(10)
  • Address (Field2) — text

PROJECT (Untitled3)

  • ProjectID (Key) — char(10) — 기본 키 — NOT NULL
  • Name (Field) — char(30)
  • Location (Field2) — char(10)
  • Working Weeks (Field3)
  • DirectSupervisor (Field4)
  • DepartmentNumber (Key2) — char(10) — 외래 키 → DEPARTMENT.DepartmentNumber — NOT NULL

WORKON (Untitled5)

  • Ssn (Key) — bigint(13) — 외래 키 → EMPLOYEE.Ssn — NOT NULL
  • ProjectID (Key2) — char(10) — 외래 키 → PROJECT.ProjectID — NOT NULL