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