2
Tables (4)
Activity (activity)
- Activity_id (activity_id) — VARCHAR — Primary key — NOT NULL
- Activity_code (activity_code) — VARCHAR
- Description (description) — VARCHAR
- Operation Time (operation time) — VARCHAR
Course (course)
- Couruse_id (course_id) — VARCHAR — Primary key — NOT NULL
- Activity_id (activity_id) — VARCHAR — Foreign key → Activity.Activity_id — NOT NULL
- Registration_limit (registration_limit) — INT
- Current_registration (current_registration) — INT
Member (member)
- Member_id (member_id) — VARCHAR — Primary key — NOT NULL
- Name (name) — VARCHAR
- Address (address) — VARCHAR
- Age (age) — INT
Registration (registration)
- Registration _id (registration _id) — VARCHAR — Primary key — NOT NULL
- Couruse_id (course_id) — VARCHAR — Foreign key → Course.Couruse_id — NOT NULL
- Activity_id (activity_id) — VARCHAR — Foreign key → Course.Activity_id — NOT NULL
- Member_id (member_id) — VARCHAR — Foreign key → Member.Member_id — NOT NULL
- Difficulty _level (difficulty _level) — BOOLERN