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)