E2

Tables (7)

ACTIVITY

  • Key (activityID) — char(30) — Primary key — NOT NULL
  • Field (description) — text

Untitled (CLASS)

  • Key (classID) — char(30) — Primary key — NOT NULL
  • Key (activityID) — char(30) — Foreign key → ACTIVITY.Key — NOT NULL

Untitled (MEMBER)

  • Key (mID) — char(30) — Primary key — NOT NULL
  • Field (mname) — char(30)
  • Field (address) — char(30)
  • Field (age) — char(2)

Untitled (CLASS_LEVEL)

  • Key (level) — int — Primary key — NOT NULL
  • Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (mID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (CLASS_TIME)

  • Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (time) — char(30) — Foreign key → Untitled2.Key — NOT NULL

Untitled (INFORMATION)

  • Key (personnel) — char(30) — Primary key — NOT NULL
  • Key (classID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (mID) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (restrictionpersonnel) — char(30)
  • Field (loginpersonnel) — char(30)

Untitled2 (TIME)

  • Key (time) — char(30) — Primary key — NOT NULL
  • Field (starttime) — time
  • Field (endtime) — time