study3

Tables (6)

CLASS

  • classID — char(10) — Primary key — NOT NULL
  • time — time
  • registerlimit — int(2) — NOT NULL
  • memberID — char(10) — NOT NULL
  • level — int(1) — NOT NULL

LEPORTS

  • aerobics — char(10)
  • yoga — char(10)
  • swimming — char(10)
  • leportsID — char(10) — NOT NULL

LEVEL

  • level — int(1) — Primary key — NOT NULL

MEMBER

  • memberID — char(10) — Primary key — NOT NULL
  • name — char(10)
  • address — char(30)
  • age — char(10)
  • level — int(1) — NOT NULL

PART

  • leportsID — char(10) — Primary key — NOT NULL
  • description — text
  • classID — char(10) — NOT NULL

REGISTER

  • registerlimit — int(2) — Primary key — NOT NULL
  • registermember — int(2)