연습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)