연습문제2
테이블 (5)
Untitled (AEROBICS ACTIVITY)
- Key (Code) — int — 기본 키 — NOT NULL
- Field (Description) — text
Untitled (YOGA ACTIVITY)
- Key (Code) — int — 기본 키 — NOT NULL
- Field (Description) — char(20)
Untitled (SWIMMING ACTIVITY)
- Key (Code) — int — 기본 키 — NOT NULL
- Field (Description) — text
Untitled (ACTIVITY CLASS)
- Key (ClassID) — int — 기본 키 — NOT NULL
- Field (OperatingTime) — char(10)
- Field (MaxCapacity) — char(30)
- Field (CurrentEnrollment) — char(30)
- Key (Code) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (Code2) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (ClassID2) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (Code3) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (ACTUVITY CODE)
- Key (Member) — ichar(30) — 기본 키 — NOT NULL
- Field (Name) — char(30)
- Field (Address) — char(30)
- Field (Age) — char(20)
- Field (enrolledClass) — char(30)
- Field (DefficultyLevel) — int
- Field (LevelCode) — int
- Field (LevelName) — text
- Key (ClassID) — int — 외래 키 → Untitled.Key — NOT NULL