2023_SLI_EX3 이소현(2023910127)
테이블 (8)
Untitled (CLIENT)
- Key (client_ssn) — integer — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — integer(20)
Untitled (DEPENDENT)
- Key (dependent_ssn) — integer — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (age) — char(100)
- Key (client_ssn) — integer — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE)
- Key (serviceID) — char(10) — 기본 키 — NOT NULL
- Field (description) — text
- Key (providerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (subjectID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SERVICE PROVIDER)
- Key (providerID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — integer(20)
Untitled (ENROLL)
- Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (serviceDate) — date
- Key (client_ssn) — integer — 외래 키 → Untitled.Key — NOT NULL
Untitled (MANAGER)
- Key (managerID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (phone) — integer(20)
- Field (address) — char(50)
Untitled (SERVICE MANAGER)
- Key (serviceID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (managerID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (SUBJECT)
- Key (subjectID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (memo) — text