2024_04_ERD Exercise 3
Tables (5)
Untitled (SERVICE)
- Key (serviceCode) — char(20) — Primary key — NOT NULL
- Field (description) — text
Untitled (SERVER)
- Key (serverID) — char(30) — Primary key — NOT NULL
- Field (Name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
- Field (email) — email
Untitled (CUSTOMAR)
- Key2 (RegID) — char(13) — Primary key — NOT NULL
- Field2 (Name) — char(20) — Primary key
- Field (address) — char(30)
- Field (phone) — char(20)
- Field2 (email) — email
- Key (serviceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENPENT FAMILY)
- Key (familyRegId) — char(13) — Primary key — NOT NULL
- Field (Name) — char(30)
- Field (birth) — date
- Key2 (RegID) — char(13) — Foreign key → Untitled.Key2 — NOT NULL
- Field2 (Name2) — char(20) — Foreign key → Untitled.Field2
Untitled (SERVICE_INFORMATION)
- Key (serviceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (serverID) — char(30) — Foreign key → Untitled.Key — NOT NULL