ex2

Tables (5)

Untitled (CLASS)

  • Key (classID) — int — Primary key — NOT NULL
  • Field (runningTime) — time
  • Field (activitycode) — char(30)
  • Field2 (DifficultyLevel) — int
  • Key (execiseID) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (EXECISE)

  • Key (execiseID) — int — Primary key — NOT NULL
  • Field (execiseinfo) — text

Untitled (Customer)

  • Key (CustomerID) — int — Primary key — NOT NULL
  • Field (customerName) — char(20)
  • Field (customerAddress) — char(30)
  • Field (customerAge) — int

Untitled (Classinformation)

  • Key (classID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (Current registered information) — text
  • Field (Registration limit) — int

Untitled (Customer-class Link)

  • Key (classID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (CustomerID) — int — Foreign key → Untitled.Key — NOT NULL