연습3
테이블 (4)
CLIENTELE (Untitled4)
- ssn (Field) — char(14)
- name (Field2) — char(20)
- adress (Field3) — text
- phone (Field4) — char(15)
ORGANIZATION (Untitled)
- clienteleSsn (Key) — char(14) — 기본 키 — NOT NULL
- clientName (Field) — char(20)
- clientAdress (Field2) — text
- clientPhone (Field3) — char(15)
- supportFamilySsn (Field4) — char(14)
- supFamName (Field5) — char(20)
- supFamAge (Field6) — integer(2)
SERVICE (Untitled2)
- serCode (Field) — car(10)
- descripton (Field2) — text
- date (Field3) — char(6)
- clienteleSsn (Key) — char(14) — 외래 키 → ORGANIZATION.clienteleSsn — NOT NULL
SERVICE_PROVIDER (Untitled3)
- providerID (Field) — char(15)
- name (Field2) — char(20)
- adress (Field3) — text
- phone (Field4) — char(15)
- clienteleSsn (Key) — char(14) — 외래 키 → ORGANIZATION.clienteleSsn — NOT NULL