슬라이드20,21
테이블 (7)
DEPARTMENT
- Field (number) — char(10) — 기본 키
- Field (ID) — char(13) — 외래 키 → Untitled.Field
- Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT-LOCATION.Key — NOT NULL
- Field (number2) — char(10) — 외래 키 → Untitled.Field
- Field (ID2) — char(13) — 외래 키 → Untitled.Field
- Key (locationnumber2) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (name) — char(5) — NOT NULL
DEPARTMENT-LOCATION (Untitled)
- Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL
FAMILY
- Key (familynumber) — char(10) — 기본 키 — NOT NULL
- Field (ID) — char(13) — 외래 키 → Untitled.Field
- Field (number2) — char(10) — 외래 키 → Untitled.Field
- Field (ID2) — char(13) — 외래 키 → Untitled.Field
- Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(10)
- Field (gender) — char(1)
- Field (birth) — char(6)
Untitled (EMPLOYEE)
- Field (ID) — char(13) — 기본 키
- Field (number) — char(10) — 외래 키 → DEPARTMENT.Field
- Field (ID2) — char(13) — 외래 키 → DEPARTMENT.Field
- Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (name) — char(10) — NOT NULL
- Field (birth) — char(6)
- Field (adress) — text
- Field (pay) — char(20)
- Field (gender) — char(1)
- Field (ssn) — char(13)
Untitled (PROJECT)
- Field (number) — char(5) — 기본 키
- Field (number2) — char(10) — 외래 키 → DEPARTMENT.Field
- Field (ID) — char(13) — 외래 키 → DEPARTMENT.Field
- Field (ID2) — char(13) — 외래 키 → Untitled.Field
- Key (locationnumber) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Field (number22) — char(10) — 외래 키 → DEPARTMENT.Field
- Field (ID22) — char(13) — 외래 키 → DEPARTMENT.Field
- Key (locationnumber2) — char(5) — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (name) — char(5) — NOT NULL
- Field (department) — char(20)
- Field (duration) — char(30)
- Field (money) — char(30)
Untitled (LOCATION)
- Key (locationnumber) — char(5) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (adress) — text
Untitled (PROJECT-EMPLOYEE)
- Field (ID) — char(13) — 외래 키 → Untitled.Field
- Field (number) — char(10) — 외래 키 → Untitled.Field
- Field (ID2) — char(13) — 외래 키 → Untitled.Field
- Key (locationnumber) — char(5) — 외래 키 → Untitled.Key — NOT NULL