실습3
테이블 (5)
DEPENDENT (Untitled3)
- ssn (Key) — char(20) — 외래 키 → MEMBER.ssn — NOT NULL
- depSSN (Field4) — char(20)
- name (Field) — char(10)
- phone (Field2) — char(11)
- age (Field3) — int(2)
ENROLL (Untitled4)
- serCODE (Key) — char(10) — 외래 키 → SERVICE.serCODE — NOT NULL
- ssn (Key2) — char(20) — 외래 키 → MEMBER.ssn — NOT NULL
- date (Field) — char(8)
MEMBER (Untitled2)
- ssn (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- age (Field4) — int(2)
PROVIDER (Untitled5)
- proID (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- serCODE (Key2) — char(10) — 외래 키 → SERVICE.serCODE — NOT NULL
SERVICE (Untitled)
- serCODE (Key) — char(10) — 기본 키 — NOT NULL
- explantion (Field) — text