EX3
Tables (6)
Customer (Untitled4)
- RegID (Key) — char(13) — Primary key — NOT NULL
- Name (Field) — char(30)
- adress (Field2) — char(50)
- phone (Field3) — char(20)
Defamily (Untitled5)
- FamilyRegId (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(30)
- age (Field2) — char(20)
- Field3
- RegID (Key2) — char(13) — Foreign key → Customer.RegID — NOT NULL
Server (Untitled3)
- ServerID (Key) — char(30) — Primary key — NOT NULL
- Name (Field) — char(30)
- adress (Field2) — char(50)
- Phone (Field3) — char(11)
- Field4
Service (Untitled2)
- ServiceCode (Key) — char(20) — Primary key — NOT NULL
- Description (Field) — text
Service_Information (Untitled6)
- RegID (Key) — char(13) — Foreign key → Customer.RegID — NOT NULL
- ServiceCode (Key2) — char(20) — Foreign key → Service.ServiceCode — NOT NULL
- ServerID (Key3) — char(30) — Foreign key → Server.ServerID — NOT NULL
- ServiceDate (Field) — Date