sql btcamp #2

Tables (6)

CLASS (Untitled2)

  • classID (Key) — Primary key — NOT NULL
  • activityCode (Key2) — Foreign key → LEPORTS ACTIVITY.activityCode — NOT NULL
  • classTimeInfo (Field)
  • maxMember (Field2)
  • currentMember (Field3)

CLASS_LEVEL (Untitled5)

  • levelID (Key3) — Foreign key → LEVEL.levelID — NOT NULL
  • classID (Key) — Foreign key → CLASS.classID — NOT NULL
  • activityCode (Key2) — Foreign key → CLASS.activityCode — NOT NULL

LEPORTS ACTIVITY (Untitled)

  • activityCode (Key) — Primary key — NOT NULL
  • activityInfo (Field)

LEVEL (Untitled4)

  • levelID (Key) — Primary key — NOT NULL
  • levelInfo (Field2)

LEVEL_MEMBER (Untitled6)

  • memberID (Key2) — Foreign key → Member.memberID — NOT NULL
  • levelID (Key) — Foreign key → LEVEL.levelID — NOT NULL

Member (Untitled3)

  • memberID (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • address (Field3)