2023_SLI_EX3

Tables (9)

ACTIVITY (DEPENDENT)

  • ActCode (dependantID) — int(5) — Primary key — NOT NULL
  • Field (depName) — char(20)
  • Field (age) — text
  • Key (clientS) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (phone) — int(11)
  • Field (ssn) — char(13)

Untitled (SER_MANAGER)

  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (managerID) — int(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (SER_PROVIDER)

  • Key (providerID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(100)
  • Field (address) — char(100)
  • Field (phone) — int(12)
  • Field (grade) — float(3)
  • Field (description) — text

Untitled (ENROLL)

  • Key — Primary key — NOT NULL
  • Key (clientID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (grade) — char(2)
  • Field (review) — LONGTEXT
  • Field (date) — date

Untitled (SERVICE)

  • Key (serviceCode) — int(100) — Primary key — NOT NULL
  • Field (description) — text
  • Key — Foreign key → Untitled.Key — NOT NULL
  • Key (Key2) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(20)
  • Field (year) — int(4)
  • Field (month) — int(2)
  • Field (fee) — integer

Untitled (NOTE)

  • Key (noteID) — CHAR(100) — Primary key — NOT NULL
  • Key (clientID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (serviceCode) — char(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (MANAGERid) — INT(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (DESCRIPTION) — TEXT

Untitled (SUBJECT)

  • Key (subjectID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text

Untitled (MANAGER)

  • Key (managerID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — int(11)
  • Field (email) — char(100)
  • Field (description) — text

Untitled2 (CLIENT)

  • Key (clientID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (adress) — char(100)
  • Field2 (phone) — int(11)
  • Field (email) — char(100)
  • Field (ssn) — char(13)