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)