activity

Tables (6)

Activity

  • activity_code — char(20) — Primary key — NOT NULL
  • activity_name — char(30)
  • activity_description — varchar(100)
  • difficulty_level — char(10)

Class

  • class_code — char(20) — Primary key — NOT NULL
  • operational_time — date
  • activity_code — char(20) — Foreign key → Activity.activity_code — NOT NULL

Location

  • location_code — char(20) — Primary key — NOT NULL
  • address — char(100)

Member

  • member_code — char(20) — Primary key — NOT NULL
  • name — char(10)
  • age — int

Member_Location

  • member_code — char(20) — Foreign key → Member.member_code — NOT NULL
  • location_code — char(20) — Foreign key → Location.location_code — NOT NULL

register

  • class_code — char(20) — Foreign key → Class.class_code — NOT NULL
  • member_code — char(20) — Foreign key → Member.member_code — NOT NULL
  • register_member_quantity — int