roufit
Tables (9)
Copy Of Untitled (set_template)
- Key (set_template_id) — bigint(20) — Primary key — NOT NULL
- Key (workout_template_id) — bigint(20) — Foreign key → routine.Key — NOT NULL
- Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (set_count) — bigint(20) — NOT NULL
- Field (rest_period) — datetime — NOT NULL
- Field (goal_repetition) — bigint(20)
- Field (goal_time) — bigint(20)
- Field (type) — varchar(255) — NOT NULL
- Field (additional_weight) — bigint(20)
Untitled (workout_record)
- Key (workout_record_id) — bigint(20) — Primary key — NOT NULL
- member_id (user_id) — bigint(20) — Foreign key → member.member_id — NOT NULL
- Key (workout_template_id) — bigint(20) — Foreign key → routine.Key — NOT NULL
- Field (duration) — datetime — NOT NULL
- Field (start_time) — datetime — NOT NULL
- Field (end_time) — datetime — NOT NULL
- Field (is_completed) — tinyint(1) — NOT NULL
Untitled (exercise)
- Key (exercise_id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (description) — varchar(255) — NOT NULL
- Field (equipment) — varchar(255) — NOT NULL
Untitled (category)
- Key (category_id) — bigint(20) — Primary key — NOT NULL
- Key (parant_id) — bigint(20) — Foreign key → Untitled.Key
- Field (title) — varchar(255) — NOT NULL
- Field (level) — varchar(255) — NOT NULL
- Field (category_order) — varchar(255) — NOT NULL
Untitled (base_entity)
- Field (created_date) — datetime — NOT NULL
- Field (modified_dated) — datetime — NOT NULL
- Field (created_by) — bigint(20) — NOT NULL
- Field (modified_by) — bigint(20) — NOT NULL
- Field (status) — varchar(20) — NOT NULL
Untitled (set_record)
- Key (set_record_id) — bigint(20) — Primary key — NOT NULL
- Key (workout_record_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (set_template_id) — bigint(20) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (set_count) — bigint(20) — NOT NULL
- Field (rest_period) — datetime — NOT NULL
- Field (goal_repetition) — bigint(20)
- Field (goal_time) — bigint(20)
- Field (type) — varchar(20) — NOT NULL
- Field (additional_weight) — bigint(20)
- Field (success_set) — varchar(20) — NOT NULL
- Field (is_completed) — tinyint(1) — NOT NULL
- Field (is_success) — tinyint(1) — NOT NULL
Untitled (exercise_category)
- Key (exercise_category_id) — bigint(20) — Primary key
- Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (category_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
member (users)
- member_id (user_id) — bigint(20) — Primary key — NOT NULL
- Field (device_code) — varchar(255) — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (nickname) — varchar(255) — NOT NULL
- Field (profile_image) — varchar(255)
- Field (weight) — bigint(255) — NOT NULL
- Field (height) — bigint(255) — NOT NULL
- Field (muscle_mass) — bigint(255)
- Field (role) — varchar(255) — NOT NULL
- Field
routine (workout_template)
- Key (workout_template_id) — bigint(20) — Primary key — NOT NULL
- member_id (user_id) — bigint(20) — Foreign key → member.member_id — NOT NULL
- Field (routine_name) — varchar(255) — NOT NULL
- Field (recent_perform_date) — datetime