Exercise3
Tables (5)
Client (Untitled)
- PersonalNumber (Key) — char(20) — Primary key — NOT NULL
- Name (Field) — char(20)
- Adress (Field2) — char(20)
- PhoneNumber (Field3) — char(20)
- ServiceCode (Key2) — char(20) — Foreign key → Service.ServiceCode — NOT NULL
Client_Family (Untitled2)
- PersonalNumber (Key) — char(20) — Primary key — NOT NULL
- PersonalNumber (Key2) — char(20) — Foreign key → Client.PersonalNumber — NOT NULL
- Name (Field) — char(20)
- Adress (Field2) — char(20)
- PhoneNumber (Field3) — char(20)
Institution (Untitled5)
- Administration (Key) — char(20 — Primary key — NOT NULL
- PrivateCenter (Key2) — char(20) — Primary key — NOT NULL
Service (Untitled3)
- ServiceCode (Key) — char(20) — Primary key — NOT NULL
- Description (Field) — text
- Date (Field2) — date
- SupplierID (Key2) — char(20) — Foreign key → Service_Supplier.SupplierID — NOT NULL
Service_Supplier (Untitled4)
- SupplierID (Key) — char(20) — Primary key — NOT NULL
- Name (Field) — char(20)
- Adress (Field2) — char(20)
- PhoneNumber (Field3) — char(20)
- Administration (Key2) — char(20 — Foreign key → Institution.Administration — NOT NULL
- PrivateCenter (Key22) — char(20) — Foreign key → Institution.PrivateCenter — NOT NULL