ERD EXCERCISE 3
Tables (7)
Untitled (고객)
- Key (clientID) — INTEGER — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
Untitled (service)
- Key (serid) — integer — Primary key — NOT NULL
- Field (description) — text
- Key (proviID) — integer — Foreign key → Untitled2.Key — NOT NULL
- Key (subjID) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (managerID) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (depenID) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (age) — char(10)
- Key (clientID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (client-service)
- Key (clieID) — integer — Primary key — NOT NULL
- Field (grade) — char(20)
- Key (clientID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Key (serid) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date
Untitled (정책)
- Key (subjID) — integer — Primary key — NOT NULL
- Field
Untitled (manager)
- Key (managerID) — integer — Primary key — NOT NULL
Untitled2 (제공자)
- Key (proviID) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field