2025-10-12-ex2

Tables (4)

ACTIVITY (Untitled)

  • actCode (Key) — char(5) — Primary key — NOT NULL
  • actName (Field) — varchar(30)
  • description (Field2) — text

CLASS (Untitled2)

  • classNo (Key) — int — Primary key — NOT NULL
  • actCode (Key3) — char(5) — Foreign key → ACTIVITY.actCode — NOT NULL
  • schedule (Field) — varchar(50)
  • limitCount (Field2) — int
  • currentCount (Field3) — int

MEMBER (Untitled3)

  • memID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • address (Field2) — varchar(100)
  • age (Field3) — int

REGISTRATION (Untitled4)

  • memID (Key) — char(10) — Foreign key → MEMBER.memID — NOT NULL
  • classNo (Key2) — int — Foreign key → CLASS.classNo — NOT NULL
  • actCode (Key3) — char(5) — Foreign key → CLASS.actCode — NOT NULL
  • level (Field) — varchar(10)
  • regDate (Field2) — date