ERD第二个

Tables (6)

ACTIVITY

  • Key (actID) — char(10) — Primary key — NOT NULL
  • Field (actName) — char(10)
  • Field (description) — text

Untitled (CLASS)

  • Key (claID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Key (actID) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL

Untitled (VIP)

  • Key (vipID) — char(30) — Primary key — NOT NULL
  • Key (memID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (age) — int(2)
  • Field (classname) — char(30)
  • Field (registerdata) — char(30)
  • Key (claID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MEMBERSINFORMATION)

  • Key (memID) — char(30) — Primary key — NOT NULL
  • Field (classname) — char(30)
  • Field (datatime) — char(30)
  • Field (maximummembers) — int(2)

Untitled (CLASSINFORMATION)

  • Key (claID) — int(5) — Primary key — NOT NULL
  • Key (claID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (activity) — char(10)
  • Field (production) — char(10)

Untitled (CLASSLEVEL)

  • Key — Primary key — NOT NULL
  • Key (claID) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (claID2) — char(10) — Foreign key → Untitled.Key — NOT NULL