Exe3
Tables (5)
CLIENT (Untitled2)
- name (Key) — char(15) — Primary key — NOT NULL
- ssn (Field) — char(15)
- age (Field2) — char(3)
- address (Field3) — char(50)
- phone (Field4) — char(10)
DEPENDENT (Untitled5)
- ssn (Key) — char(15) — Primary key — NOT NULL
- name (Field) — char(15)
- age (Field2) — char(3)
- name (Key2) — char(15) — Foreign key → CLIENT.name — NOT NULL
ENROLL (Untitled3)
- serviceID (Key) — integer — Foreign key → SERVICE.serviceID — NOT NULL
- name (Key2) — char(15) — Foreign key → CLIENT.name — NOT NULL
ORGANIZATION (Untitled4)
- orgcode (Key) — integer — Primary key — NOT NULL
- name (Field) — char(15)
SERVICE (Untitled)
- serviceID (Key) — integer — Primary key — NOT NULL
- date (Field) — char(14)
- description (Field2) — text
- orgcode (Key2) — integer — Foreign key → ORGANIZATION.orgcode — NOT NULL