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