LEPORTS

Tables (4)

Untitled (Activity)

  • Key (Activity_Code) — char(10) — Primary key — NOT NULL
  • Field (Activity_Name) — char(10)
  • Field (Activity_Description) — text

Untitled (Class)

  • Key (Class_ID) — char(10) — Primary key — NOT NULL
  • Field (Activity_Code) — char(10)
  • Field (Schedule) — char(15)
  • Field (Max_Enrollment) — int(10)
  • Field (FieldCurrent_Enrollment) — int(10)
  • Key (Activity_Code2) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Member)

  • Key (Member_ID) — char(10) — Primary key — NOT NULL
  • Field (Name) — char(15)
  • Field (Address) — char(30)
  • Field (Age) — int(2)

Untitled (Registration)

  • Key (Registration_ID) — char(10) — Primary key — NOT NULL
  • Field (Member_ID) — char(10)
  • Field (Class_ID) — char(10)
  • Field (Difficulty_Level) — char(3)
  • Key (Class_ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (Member_ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL