3주차과제Ex3
테이블 (5)
CUSDEPENDENT (Untitled4)
- depSsn (Key) — char(13) — 기본 키 — NOT NULL
- depName (Field) — char(20)
- depphone (Field2) — char(13)
- depRlationship (Field3) — char(4)
- description (Field4) — text
- cusSsn (Key2) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL
CUSTOMER
- cusSsn (Key) — char(20) — 기본 키 — NOT NULL
- cusAddress (Field) — char(50)
- cusPhone (Field2) — char(12)
- cusName (Field3) — char(20)
SERVICE EDUCATION (Untitled3)
- sereduCode (Key) — char(20) — 기본 키 — NOT NULL
- cusSsn (Key2) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL
- SPROID (Key3) — char(20) — 외래 키 → SERVICEPROVIDER.SPROID — NOT NULL
- cusSsn (Key4) — char(20) — 외래 키 → SERVICEGROUP.cusSsn — NOT NULL
- SPROID (Key22) — char(20) — 외래 키 → SERVICEGROUP.SPROID — NOT NULL
- seredustartDate (Field) — date
SERVICEGROUP (Untitled)
- cusSsn (Key) — char(20) — 외래 키 → CUSTOMER.cusSsn — NOT NULL
- SPROID (Key2) — char(20) — 외래 키 → SERVICEPROVIDER.SPROID — NOT NULL
SERVICEPROVIDER (Untitled2)
- SPROID (Key) — char(20) — 기본 키 — NOT NULL
- sproName (Field) — char(20)
- sproAddress (Field2) — char(50)
- sproContactN (Field3) — char(12)