WEBDB-2 수업시간 예제

테이블 (7)

DEPARTMENT (Untitled)

  • deptNo (Key) — CHAR(8) — 기본 키 — NOT NULL
  • dname (Field) — CHAR(32)
  • mgrStartDate (Field2) — date
  • ssn (Key2) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL

DEPARTMENT_LOCATION (Untitled7)

  • deptNo (Key) — CHAR(8) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • lno (Key2) — CHAR(8) — 외래 키 → LOCATION.lno — NOT NULL

DEPENDENT (Untitled3)

  • dssn (Key) — CHAR(30) — 기본 키 — NOT NULL
  • dname (Field) — CHAR(20)
  • gender (Field2) — CHAR(10)
  • bdate (Field3) — date
  • relation (Field4) — CHAR(50)
  • ssn (Key2) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled2)

  • ssn (Key) — CHAR(30) — 기본 키 — NOT NULL
  • fname (Field) — CHAR(30)
  • minit (Field2) — CHAR(4)
  • lname (Field3) — CHAR(30)
  • bdate (Field4) — date
  • address (Field5) — CHAR(40)
  • gender (Field6) — CHAR(10)
  • salary (Field7) — int(20)
  • deptNo (Key2) — CHAR(8) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
  • superssn (Key3) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL

LOCATION (Untitled6)

  • lno (Key) — CHAR(8) — 기본 키 — NOT NULL
  • lname (Field) — CHAR(30)
  • phone (Field2) — CHAR(20)

PROJECT (Untitled5)

  • pno (Key) — CHAR(8) — 기본 키 — NOT NULL
  • pname (Field) — CHAR(30)
  • deptNo (Key2) — CHAR(8) — 외래 키 → DEPARTMENT.deptNo — NOT NULL

WORKS-ON (Untitled4)

  • ssn (Key2) — CHAR(30) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • pno (Key) — CHAR(8) — 외래 키 → PROJECT.pno — NOT NULL
  • hour (Field) — int(3)