성균관대 사서교육원
테이블 (7)
DEPART_LOC (Untitled2)
- Key (depNO) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key (locNo) — integer — 외래 키 → LOCATION.Key — NOT NULL
DEPENDANT (Untitled5)
- Key (depNo) — integer — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field2 (birthDate) — interger
- Field2 (gender) — interger
- Key (employeeNO) — integer — 외래 키 → Untitled.Key — NOT NULL
LOCATION (Untitled)
- Key (locNo) — integer — 기본 키 — NOT NULL
- Field (locName) — char(100)
- Field (phone) — char(15)
- Field (address) — char(100)
PROJECT (Untitled3)
- Key (proNo) — interger — 기본 키 — NOT NULL
- Field (proName) — char(20)
- Field (description) — text
- Key (depNO) — integer — 외래 키 → Untitled.Key — NOT NULL
Untitled (EMPLOYEE)
- Key (employeeNO) — integer — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (email) — char(30)
- Field (address) — char(30)
- Field (phon) — char(11)
- Key (depNO) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key (suvisorNO) — integer — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (depNO) — integer — 기본 키 — NOT NULL
- Field (depNAME) — char(20)
- Field (phon) — char(20)
- Field (fax) — char(20)
- Key (employeeNO) — integer — 외래 키 → Untitled.Key — NOT NULL
- Field (startDate) — date
WORKS_ON (Untitled4)
- Key (woNo) — integer — 기본 키 — NOT NULL
- Key (employeeNO) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key (proNo) — interger — 외래 키 → PROJECT.Key — NOT NULL
- Field (hours) — Type
- Field (Yearmonth) — char(10)