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