Exercise3(배미연)
테이블 (4)
Client (Untitled)
- ClientCode (Key) — char(13) — 기본 키 — NOT NULL
- ClientName (Field) — char(10)
- ClientAddress (Field2) — char(30)
- ClientPhone (Field3) — char(11)
Family (Untitled2)
- FamilyCode (Key) — char(13) — 기본 키 — NOT NULL
- FamilyName (Field) — char(10)
- FamilyAge (Field2) — char(3)
- FamilyRelation (Field3) — char(10)
- MemberCode (Key2) — char(13) — 외래 키 → Client.ClientCode — NOT NULL
Provider (Untitled4)
- ProviderNo (Key) — char(4) — 기본 키 — NOT NULL
- ProviderName (Field) — char(10)
- ProviderType (Field2) — char(3)
- ProviderAddress (Field3) — char(30)
- ProviderPhone (Field4) — char(11)
Service (Untitled3)
- ServiceCode (Key) — char(4) — 기본 키 — NOT NULL
- ServiceName (Field) — char(10)
- ServiceStartdate (Field2) — date
- providerNo (Key2) — char(4) — 외래 키 → Provider.ProviderNo — NOT NULL
- MemberCode (Key3) — char(13) — 외래 키 → Client.ClientCode — NOT NULL