과제3(임미숙)
테이블 (5)
CLIENT (Untitled2)
- clientSsn (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char920)
- address (Field2) — char(30)
- phone (Field3) — char(15)
- policyNo (Key2) — char(10) — 외래 키 → ORGANIZATION.policyNo — NOT NULL
DEPENDENT (Untitled5)
- dependentSsn (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(20)
- age (Field2) — char(5)
- serviceId (Key2) — char(10) — 외래 키 → SERVICE.serviceId — NOT NULL
ORGANIZATION (Untitled)
- policyNo (Key) — char(10) — 기본 키 — NOT NULL
- clientSsn (Field) — char(10)
- serviceCode (Field2) — char(10)
- dependent (Field3) — char(10)
PROVIDER (Untitled4)
- providerId (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — char(15)
- serviceId (Key2) — char(10) — 외래 키 → SERVICE.serviceId — NOT NULL
SERVICE (Untitled3)
- serviceId (Key) — char(10) — 기본 키 — NOT NULL
- description (Field) — text
- servicedate (Field2) — char(15)
- provider (Field3) — char(10)
- clientSsn (Key2) — char(10) — 외래 키 → CLIENT.clientSsn — NOT NULL