11

Tables (7)

Untitled (SPORTS ACT)

  • Key (actCode) — char(10 — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (descriptione) — test

Untitled (CLASS)

  • Key (classID) — interger — Primary key — NOT NULL
  • Field (className) — char(30)
  • Field (year) — integer(2)
  • Field (month) — integer(2)
  • Field (level) — char(2)
  • Field (descriptione)
  • Field (price)
  • Field (capacity)
  • Key (actCode) — char(10 — Foreign key → Untitled.Key — NOT NULL
  • Key (lecturerID) — Foreign key → Untitled.Key — NOT NULL

Untitled (CLASS_TIME)

  • Key (classID) — interger — Foreign key → Untitled.Key — NOT NULL
  • Key (timeID2) — Foreign key → Untitled.Key — NOT NULL

Untitled (TIME)

  • Key (timeID) — Primary key — NOT NULL

Untitled (LECTURER)

  • Key (lecturerID) — Primary key — NOT NULL
  • Field (name)
  • Field (address)
  • Field (phone)
  • Field (descriptione)

Untitled (MEMBER)

  • Key (memID) — Primary key — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (address)
  • Field (email)

Untitled (NEROLE)

  • Key (memID) — Foreign key → Untitled.Key — NOT NULL
  • Key (classID) — interger — Foreign key → Untitled.Key — NOT NULL