과제 3
테이블 (10)
Untitled (CUSTOMER INFORMATION)
- Key (ID number) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(30)
Untitled (DEPENDANT)
- Key (dependant ID number) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (age) — char(30)
- Key (ID number2) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICES ANAILABLE)
- Key (vocational education) — 기본 키 — NOT NULL
- Key (explain) — text — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE PROVIDER)
- Key (state the agent) — text — 기본 키 — NOT NULL
- Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (TIME)
- Key (p\rovide the date) — char(30) — 기본 키 — NOT NULL
Untitled (AVALABLE INFORMATION)
- Key (explain) — text — 기본 키 — NOT NULL
- Field (code) — char(30)
Untitled (SRVICE PROVIDER INFORMATON)
- Key (ID) — char(30) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone)
Untitled (CUSTOMER INFORMATON-TIME)
- Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (p\rovide the date) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CURTOMER INFORMATION-SEVICE PROVIDER)
- Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (state the agent) — text — 외래 키 → Untitled.Key — NOT NULL
Untitled (CUSTOMER INFORMATION-SERVICES ANAILABLE)
- Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (vocational education) — 외래 키 → Untitled.Key — NOT NULL