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