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