교량개체
테이블 (5)
DEPARTMENT (Untitled2)
- deptID (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(30)
- Field2 — char(14)
- ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled5)
- ssn (Key) — char(10) — 기본 키 — NOT NULL
- dependentName (Field) — char(15)
- gender (Field2) — char(5)
- birthDate (Field3) — date
- relationship (Field4) — char(14)
- Field5
EMPLOYEE (Untitled3)
- ssn (Key) — char(14) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(50)
- phone (Field3) — char(11)
- deptID (Key2) — char(5) — 외래 키 → DEPARTMENT.deptID — NOT NULL
PROJECT (Untitled)
- projectID (Key) — char(10) — 기본 키 — NOT NULL
- projectNAME (Field) — char(30)
- description (Field2) — text
- duration (Field3) — char(30)
- deptID (Key2) — char(5) — 외래 키 → DEPARTMENT.deptID — NOT NULL
WORKSON (Untitled4)
- ssn (Key) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projectID (Key2) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL
- hour (Field) — char(3)