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

Organization (Untitled)

    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