example_2

Tables (4)

Activity

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

Untitled (Class)

  • Key (cID) — char(6) — Primary key — NOT NULL
  • Key (aID) — int(5) — Foreign key → Activity.Key — NOT NULL
  • Field (name)
  • Field (level)
  • Field (openTime) — char(5)
  • Field (closeTime) — char(5)
  • Field (limitedNo) — int(10)
  • Field2 (joiningNo) — int(10)

Untitled (Member)

  • Key (mID) — int(5) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (age) — int(3)

Untitled (Registration)

  • Key (Number) — int(4) — Primary key — NOT NULL
  • Key (cID) — char(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (aID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (mID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date