2022913002ERD3

Tables (8)

CLIENT (Untitled2)

  • Key — int(9) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(20)

DPENDENT (Untitled3)

  • Key — int(9) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(20)
  • Key (Key2) — int(9) — Foreign key → CLIENT.Key — NOT NULL

ENROLL (Untitled6)

  • Key — integer — Primary key — NOT NULL
  • Field — char(2)
  • Field2 — LONGTEXT
  • Field3 — date
  • Key (Key2) — int(9) — Foreign key → CLIENT.Key — NOT NULL
  • Key (Key3) — char(10) — Foreign key → SERVICE.Key — NOT NULL

MANAGER (Untitled)

  • Key — int(10) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(20)
  • Field5 — text

NOTE (Untitled9)

  • Key — integer — Primary key — NOT NULL
  • Field — text
  • Key (Key2) — char(10) — Foreign key → SERVICE.Key — NOT NULL

SERVICE (Untitled5)

  • Key — char(10) — Primary key — NOT NULL
  • Field — text
  • Field2 — date
  • Key (Key2) — int(10) — Foreign key → SUBJECT.Key — NOT NULL
  • Key (Key3) — int(100) — Foreign key → SERVICEPROVIDER.Key — NOT NULL
  • Key (Key4) — int(10) — Foreign key → MANAGER.Key — NOT NULL

SERVICEPROVIDER (Untitled8)

  • Key — int(100) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — LONGTEXT
  • Field5 — char(4)

SUBJECT (Untitled7)

  • Key — int(10) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — LONGTEXT