ex3
Tables (6)
CustomerInformation (Untitled)
- cId (Key) — char(14) — Primary key — NOT NULL
- cName (Field) — char(10)
- cAdress (Field2) — char(40)
- cPhone (Field3) — char(15)
Customer_service (Untitled5)
- cId (Key) — char(14) — Foreign key → CustomerInformation.cId — NOT NULL
- sCode (Key2) — char(14) — Foreign key → Service.sCode — NOT NULL
- date (Field) — integer
Family (Untitled2)
- fId (Key) — char(14) — Primary key — NOT NULL
- fName (Field) — char(10)
- fAge (Field2) — intger
- cId (Key2) — char(14) — Foreign key → CustomerInformation.cId — NOT NULL
Provider (Untitled3)
- pId (Key) — char(14) — Primary key — NOT NULL
- pAdress (Field) — char(40)
- pName (Field2) — char(10)
- pPhone (Field3) — char(15)
Provider_service (Untitled6)
- pId (Key) — char(14) — Foreign key → Provider.pId — NOT NULL
- sCode (Key2) — char(14) — Foreign key → Service.sCode — NOT NULL
Service (Untitled4)
- sCode (Key) — char(14) — Primary key — NOT NULL
- sStatus (Field)