ERD Exercise3
Tables (8)
Untitled (CUSTOMER)
- Key (customerID) — char(10) — Primary key — NOT NULL
- Field (customerName) — char(10)
- Field (phone) — char(12)
- Field (adress) — char(30)
- Field (resistrationNum) — char(13)
Untitled (CUSTOMER_FAMILLY)
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (resistrationNum) — char(13)
- Field (name) — char(10)
- Field (phone) — char(12)
- Field (adress) — char(30)
- Field (FamilltRelation) — char(6)
Untitled (LOCAL_COMMUNITY)
- Key (communityID) — char(10) — Primary key — NOT NULL
- Field (Name) — char(20)
- Field (adress) — char(30)
- Field (phone) — char(12)
- Field (description) — text
Untitled (MAIN_SERVICE)
- Key (serviceCord) — char(10) — Primary key — NOT NULL
- Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
- Key (serverID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (SERVER)
- Key (serverID) — char(10) — Primary key — NOT NULL
- Field (serverName) — char(10)
- Field (adress) — char(30)
- Field (phone) — char(12)
Untitled (SERVICE)
- Key (serviceCord) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (serviceDay) — date
- Field (description) — text
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (customerID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRIVATE_SERVICE)
- Key (serviceCord) — char(10) — Primary key — NOT NULL
- Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
- Field (adress) — char(30)
- Field (phone) — char(12)
- Field (seviceName) — char(20)
Untitled (SERVICE_2)
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (customerID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCord) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (communityID) — char(10) — Foreign key → Untitled.Key — NOT NULL