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)