ERD 연습문제 2번
테이블 (4)
ACTIVITY (activity)
- Activity ID (activity id) — char(20) — 기본 키 — NOT NULL
- Activity_Code (activity_code) — char(30)
- Activity_Name (activity_name) — char(30)
- Description (description) — text
CLASS (class)
- Class ID (class id) — char(20) — 기본 키 — NOT NULL
- Activity ID (activity id) — char(20) — 외래 키 → ACTIVITY.Activity ID — NOT NULL
- Time_Slot (time_slot) — datetime
- Max_Capacity (max_capacity) — int(3)
- Current_Enrollments (current_enrollments) — int(3)
- Member_ID (member_id) — char(10) — 외래 키 → MEMBER.Member_ID — NOT NULL
MEMBER (member)
- Member_ID (member_id) — char(10) — 기본 키 — NOT NULL
- Registration_ID (registration_ID) — char(10) — 외래 키 → REGISTRATION.Registration_ID — NOT NULL
- Member Name (member name) — char(20)
- Address (address) — char(30)
- Age (age) — int(3)
REGISTRATION (registration)
- Registration_ID (registration_ID) — char(10) — 기본 키 — NOT NULL
- Difficulty_Level (difficulty_level) — char(10)