ex_3

Tables (5)

CLIENT (Untitled2)

  • ClientId (Key) — char(10) — Primary key — NOT NULL
  • ClientName (Field) — char(6)
  • ClientAddress (Field2) — char(10)
  • ClientPhoneNumber (Field3) — char(12)
  • ServiceCode (Key2) — char(10) — Foreign key → SERVICE.ServiceCode — NOT NULL
  • OrganizationNme (Key3) — char(8) — Foreign key → ORGANIZATION.OrganizationNme — NOT NULL
  • SONumber (Key4) — char(10) — Foreign key → SERVICE_OFFERER.SONumber — NOT NULL

CLIENT_FAMILY (Untitled4)

  • CFId (Key) — char(10) — Primary key — NOT NULL
  • CFName (Field) — char(6)
  • CFAge (Field2) — char(2)

ORGANIZATION (Untitled3)

  • OrganizationNme (Key) — char(8) — Primary key — NOT NULL
  • Field
  • ClientId (Key2) — char(10) — Foreign key → CLIENT.ClientId — NOT NULL
  • ServiceCode (Key3) — char(10) — Foreign key → SERVICE.ServiceCode — NOT NULL

SERVICE (Untitled)

  • ServiceCode (Key) — char(10) — Primary key — NOT NULL
  • ServiceDescript (Field) — text
  • ServiceDate (Field2) — date
  • ClientId (Key2) — char(10) — Foreign key → CLIENT.ClientId — NOT NULL
  • OrganizationNme (Key3) — char(8) — Foreign key → ORGANIZATION.OrganizationNme — NOT NULL
  • SONumber (Key4) — char(10) — Foreign key → SERVICE_OFFERER.SONumber — NOT NULL
  • CFId (Key5) — char(10) — Foreign key → CLIENT_FAMILY.CFId — NOT NULL

SERVICE_OFFERER (Untitled5)

  • SONumber (Key) — char(10) — Primary key — NOT NULL
  • SOName (Field) — char(6)
  • SOAddress (Field2) — char(10)
  • SOPhoneNumber (Field3) — char(12)
  • OrganizationNme (Key2) — char(8) — Foreign key → ORGANIZATION.OrganizationNme — NOT NULL