PT_fitness
Tables (6)
ExerciseMemberInfo (exercise_member_info)
- id — int — Primary key — NOT NULL
- id (memer_id) — int — Foreign key → Member.id — NOT NULL
- id (exercise_type_id) — int — Foreign key → ExerciseType.id — NOT NULL
- calory — int
- exerciseCount (exerise_count) — int — 어떤운동을 몇번 했는지 횟수
- exerciseMistakeCount (exercise_mistake_count) — int — 운동 자세 틀린 횟수
- totalExerciseTime (total_exercise_time) — int — 일주일간 운동 총시간
- createAt (create_at) — date
- updateAt (update_at) — date
ExerciseType (exercise_type)
- id — int — Primary key — NOT NULL
- exerciseName (exercise_name) — varchar — NOT NULL
- bodyPart (body_part) — int — NOT NULL
ExerciseVideo (exercise_video)
- id — int — Primary key — NOT NULL
- path — varchar — NOT NULL
- title — varchar — NOT NULL
- createAt (create_at) — date — NOT NULL
Member (member)
- id — int — Primary key — NOT NULL
- email — varchar — NOT NULL
- pw — varchar — NOT NULL
- name — varchar — NOT NULL
- age — int — NOT NULL
- gender — char(2) — NOT NULL
- height — float — NOT NULL
- weight — float — NOT NULL
- createAt (create_at) — date — NOT NULL
- updateAt (update_at) — date
- deleteAt (delete_at) — date
- role — varchar — NOT NULL
Notification (notification)
- id — int — Primary key — NOT NULL
- path — varchar
- imgName (img_name) — varchar
- title — date
- context — text
- createAt (create_at) — date — NOT NULL
- deleteAt (delete_at) — date
- updateAt (update_at) — date
Popup (popup)
- id — int — Primary key — NOT NULL
- path — varchar — NOT NULL
- imgName (img_name) — varchar — NOT NULL
- context — text
- createAt (create_at) — date — NOT NULL