연습3
테이블 (5)
CUSTOMER INFORMATION
- Resident Registration Number — int — 기본 키 — NOT NULL
- name
- domicile — int
- phone number
DONOR (Untitled4)
- identification number — 기본 키 — NOT NULL
- service code — 외래 키 → SERVICE.service code — NOT NULL
- domicile — int
- contact
- nominee — 외래 키 → VOCATIONAI EDUCATION.nominee — NOT NULL
FAMILY DEPENDENT
- Resident Registration Number — int — 기본 키 — NOT NULL
- Resident Registration Number (Key2) — 외래 키 → CUSTOMER INFORMATION.Resident Registration Number — NOT NULL
- name
- domicile — int
- phone number
SERVICE
- service code — 기본 키 — NOT NULL
- explanation — int
- date
- age
VOCATIONAI EDUCATION
- nominee — char(10( — 기본 키 — NOT NULL
- nominee (Field) — char(20)