202291300ERD2

Tables (8)

ACTIVITY (Untitled5)

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

CLASS (Untitled3)

  • Key — char(10) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(5)
  • Field3 — char(10)
  • Field4 — int(50)
  • Field5 — int(50)
  • Key (Key2) — char(20) — Foreign key → LEISURESPORTS.Key — NOT NULL
  • Key (Key3) — char(10) — Foreign key → REGISTER.Key — NOT NULL
  • Field6 — int(10)
  • Key (Key4) — char(10) — Foreign key → LECTURER.Key — NOT NULL

CLASS_TIME (Untitled6)

  • Key — char(10) — Foreign key → CLASS.Key — NOT NULL
  • Key (Key2) — int(10) — Foreign key → TIME.Key — NOT NULL

LECTURER (Untitled8)

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

LEISURESPORTS (Untitled)

  • Key — char(20) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — text
  • Key (Key2) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL

REGISTER (Untitled4)

  • Key — char(10) — Primary key — NOT NULL
  • Key (Key2) — char(10) — Foreign key → STUDENT.Key — NOT NULL

STUDENT (Untitled2)

  • Key — char(10) — Primary key — NOT NULL
  • Field — char(20)
  • Field2 — char(30)
  • Field3 — int(2)

TIME (Untitled7)

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