데이터베이스

테이블 (7)

Project

  • Key (pID) — char(30) — 기본 키 — NOT NULL
  • Field (pName) — char(30)
  • Field (description) — text
  • Key (dno) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Employee)

  • Key (ssn) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Field (bdated) — date
  • Field (salary) — int(10)
  • Field (gender) — char(30)
  • Field (email) — char(30)
  • Key (dno) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (supervisorSsn) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Department)

  • Key (dno) — char(10) — 기본 키 — NOT NULL
  • Field (dname) — char(50)
  • Field (dManager) — char(10)
  • Field (dManagerStartDate) — date
  • Key (managerSsn) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Dependent)

  • Field (bdate) — char(30)
  • Field (gender) — char(10)
  • Field (relation) — char(30)
  • Field (status) — char(50)
  • Key (ssnEmployee) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (ssn) — char(30)

Untitled (Location)

  • Key (lID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)

Untitled (Dept_Location)

  • Key (dno) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (lID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Works_on)

  • Key (ssn) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pID) — char(30) — 외래 키 → Project.Key — NOT NULL
  • Field (hour) — float