health-genie

health-genie entity class

Tables (39)

ApplicationTime (application_time_tb)

  • id (application_time_id) — Long — Primary key — NOT NULL — 기본키 값
  • day — String
  • startTime (start_time) — String
  • endTime (end_time) — String

CHAT_MESSAGE_PHOTO_TB

  • chatMessagePhotoId (chat_message_photo_id) — Long — Primary key — NOT NULL
  • chatMessageId (chat_message_id) — Long — NOT NULL
  • chatMessagePhoto (chat_message_photo) — String
  • chatMessageId (chat_message_id2) — Long — Foreign key → CHAT_MESSAGE_TB.chatMessageId — NOT NULL

CHAT_MESSAGE_TB

  • chatMessageId (chat_message_id) — Long — Primary key — NOT NULL
  • chatRoomId (chat_room_id) — Long — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • messageContent (message_content) — string
  • sendAt (send_at) — timestamp
  • messageCheck (message_check) — boolean
  • chatRoomId (chat_room_id2) — Long — Foreign key → CHAT_ROOM_TB.chatRoomId — NOT NULL
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

CHAT_ROOM_TB

  • chatRoomId (chat_room_id) — Long — Primary key — NOT NULL
  • chatRoomName (chat_room_name) — String
  • createdAt (created_at) — timestamp
  • chatRoomStatus (chat_room_status) — boolean

COMMUNITY_COMMENT_TB

  • communityCommentId (community_comment_id) — Long — Primary key — NOT NULL
  • communityPostId (community_post_id) — Long — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • communityComment (community_comment) — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL
  • communityPostId (community_post_id2) — Long — Foreign key → COMMUNITY_POST_TB.communityPostId — NOT NULL

COMMUNITY_LIKED_TB

  • communityLikedId (community_liked_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • communityPostId (community_post_id) — Long — NOT NULL
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL
  • communityPostId (community_post_id2) — Long — Foreign key → COMMUNITY_POST_TB.communityPostId — NOT NULL

COMMUNITY_POST_PHOTO_TB

  • communityPostPhotoId (community_post_photo_id) — Long — Primary key — NOT NULL
  • communityPostId (community_post_id) — Long — NOT NULL
  • postPhoto (post_photo) — String
  • communityPostId (community_post_id2) — Long — Foreign key → COMMUNITY_POST_TB.communityPostId — NOT NULL

COMMUNITY_POST_TB

  • communityPostId (community_post_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • title — String
  • postContent (post_content) — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

ChatMessage (chat_maessage_tb)

  • id (chat_message_id) — Long — Primary key — NOT NULL — 기본키 값
  • messageContetn (message_content) — String
  • reading — boolean — NOT NULL
  • status — Integer
  • chattingTime (chatting_time) — Date
  • chattingRoom (room_id) — Long — Foreign key → ChattingRoom.id — NOT NULL — 외래키
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

ChattingRoom (chatting_room)

  • id (chatting_room_id) — Long — Primary key — NOT NULL — 기본키값
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

CommunityComment (community_comment_tb)

  • id (community_comment_id) — Long — Primary key — NOT NULL — 기본키 값
  • commentBody (comment_body) — Sirng
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

CommunityLiked (community_liked_tb)

  • id (community_liked_id) — Long — Primary key — NOT NULL — 기본키 값
  • post (community_post_id) — Long — Foreign key → CommunityPost.id — NOT NULL — 외래키 값
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 기본키 값

CommunityPost (community_post_tb)

  • id (community_post_id) — Long — Primary key — NOT NULL — 기본키 값
  • title — String — NOT NULL
  • body — String — NOT NULL
  • likeCount (like_count) — Long
  • pics — Blob
  • user (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

EmailAuthCode (email_auth_code)

  • id (community_post_id) — Long — Primary key — NOT NULL — 기본키 값
  • code (auth_code) — String — NOT NULL

MATCHING_TB

  • matchingId (matching_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • trainerId (trainer_id) — Long — NOT NULL
  • ptDate (pt_date) — timestamp
  • ptPlace (pt_place) — String
  • ptAccept (pt_accept) — boolean
  • ptPrice (pt_price) — int
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

MatchingTime (matching_time_tb)

  • id (matching_time_id) — Long — Primary key — NOT NULL — 기본키 값
  • day — String
  • startTime (start_time) — String
  • endTime (end_time) — String
  • trainerPtApplication (trainer_pt_application_id) — TrainerPtApplication — Foreign key → TrainerPtApplication.id — NOT NULL — 외래키 값

PT_PROCESS_TB

  • ptProcessId (pt_process_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • trainerId (trainer_id) — Long — NOT NULL
  • processTitle (process_title) — String
  • processContent (process_content) — String
  • ptProcessDate (pt_process_date) — date
  • ptProcessPhoto (pt_process_photo) — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

PT_REVIEW_TB

  • ptReviewId (pt_review_id) — Long — Primary key — NOT NULL
  • trainerId (trainer_id) — Long — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • ptReviewDate (pt_review_date) — date
  • reviewScore (review_score) — float
  • reviewContent (review_content) — String
  • stopReason (stop_reason) — boolean
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

PtProcess (Pt_process_tb)

  • id (pt_process_id) — Long — Primary key — NOT NULL — 기본키 값
  • date — String — NOT NULL
  • ptTimes (pt_times) — Long — NOT NULL
  • bodyState (body_state) — String
  • bmi — String
  • weakness — String
  • strength — String
  • ptComment (pt_comment) — String
  • ptStartDate (pt_start_date) — String
  • ptLeftTimes (pt_left_times) — String — NOT NULL
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

REFRESHTOKEN_TB

  • id (refresh_token_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • token — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

RefreshToken (refresh_token)

  • id (refresh_token_id) — Long — Primary key — NOT NULL — 기본키 값
  • token — String
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

RegisterCondition (register_condition_tb)

  • id (register_condition_id) — Long — Primary key — NOT NULL — 기본키 값
  • requirement — boolean
  • conditionAgree (condition_agree) — String
  • usingPrivacyInfoAgree (using_privacy_info_agree) — String
  • emailReceptionAgree (email_reception_agree) — String

RegisterConditionHistory (register_condition_history_tb)

  • id (register_condition_history_id) — Long — Primary key — NOT NULL — 기본키 값
  • registerCondition (register_condition) — boolean
  • privacyInfo (privacy_info) — boolean
  • emailReception (email_reception) — boolean
  • email — String
  • agreeDate (agree_date) — String
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

ScheduleTime (schedule_time_tb)

  • id (schedule_time_id) — Long — Primary key — NOT NULL — 기본키 값
  • day — String
  • startTime (start_time) — String
  • endTime (end_time) — String

TODO_TB

  • id — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • trainerId (trainer_id) — Long — NOT NULL
  • todoDate (todo_date) — String
  • todoTime (todo_time) — int
  • title — String
  • description — String
  • todoCheck (todo_check) — boolean
  • mode — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

TRAINER_INFO_TB

  • id (trainer_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • name — String
  • review_avg — float
  • memberCnt (member_cnt) — int
  • description — String
  • uniName (uniname) — String
  • careerMonth (career_month) — int
  • profilePhoto (profile_photo) — String
  • startTime (start_time) — int
  • endTime (end_time) — int
  • cost — int
  • careerHistory (career_history) — String
  • contactTime (contact_time) — int
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

TRAINER_PHOTO_TB

  • id — Long — Primary key — NOT NULL
  • trainerId (trainer_id) — Long — NOT NULL
  • fileName (filename) — String
  • id (trainer_id2) — Long — Foreign key → TRAINER_INFO_TB.id — NOT NULL

TrainerProfile (trainer_profile_tb)

  • id (trainer_profile_id) — Long — Primary key — NOT NULL — 기본키 값
  • avgStarScore (avg_star_score) — Long
  • matchingTimes (matching_times) — Long
  • name — String — NOT NULL
  • prize — String
  • description — String — NOT NULL
  • certification — String
  • pics — String
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

TrainerPtApplication (trainer_pt_application)

  • id (trainer_pt_application_id) — Long — Primary key — NOT NULL — 기본키 값
  • ptApplyDate (pt_apply_date) — String
  • ptStartDate (pt_start_date) — String
  • matchingState (Matching_state) — MatchingState
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

TrainerPtPossibleTime (trainer_pt_possible_time_tb)

  • id (trainer_pt_possible_time_id) — Long — Primary key — NOT NULL — 기본키 값
  • day — String
  • startTime (start_time) — String
  • endTime (end_time) — String
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

USER_PROFILE_TB

  • userProfileId (user_profile_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • name — String
  • height — int
  • birth — String
  • weight — int
  • muscleWeight (muscle_weight) — int
  • profilePhoto (profile_photo) — String
  • gender — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

UniVerify (uni_verify_tb)

  • id (uni_verify_id) — Long — Primary key — NOT NULL — 기본키 값
  • studentNumber (student_number) — Long
  • uniName (uni_name) — String
  • uniVerifyPic — Blob
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

User (User_tb)

  • id (user_id) — Long — Primary key — NOT NULL — 기본키 값
  • email — String — NOT NULL
  • uniName (uniname) — String
  • name — String — NOT NULL
  • password — String — NOT NULL
  • refreshTokenId (refresh_token_id) — String
  • provider — String
  • role — Role

UserPtApplication (user_pt_application_tb)

  • id (user_pt_application_id) — Long — Primary key — NOT NULL — 기본키 값
  • ptApplyDate (pt_apply_date) — String
  • ptStartDate (pt_start_date) — String
  • ptTimes (pt_times) — String
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

UserPtReview (user_pt_review_tb)

  • id (user_pt_review_id) — Long — Primary key — NOT NULL
  • matching (trainer_pt_application_id) — TrainerPtApplication — Foreign key → TrainerPtApplication.id — NOT NULL — 기본키 값
  • title — String — NOT NULL
  • startDate (start_date) — String
  • endDate (end_date) — String
  • trainerName (trainer_name) — String — NOT NULL
  • reviewContent (review_content) — String
  • pic1 — Blob
  • pic2 (Field7) — Blob
  • pic3 — Blob
  • starScore (star_score) — Integer

UserPtSchedule (user_pt_schedule_tb)

  • id (pt_schedule_id) — Long — Primary key — NOT NULL — 기본키 값
  • date — String
  • startTime (start_time) — String
  • endTime (end_time) — String
  • blankForComment (blank_for_comment) — String
  • scheduleTime (schedule_time_id) — ScheduleTime — Foreign key → ScheduleTime.id — NOT NULL — 외래키 값
  • member (user_id) — User — Foreign key → User.id — NOT NULL — 외래키 값
  • trainer (trainer_id) — User — Foreign key → User.id — NOT NULL — 외래키 값

WORKOUT_ROUTINE_GENIE_TB

  • genieRoutineId (genie_routine_id) — Long — Primary key — NOT NULL
  • level — String
  • workoutPart (workout_part) — String
  • workoutName (workout_name) — String
  • workoutSets (workout_sets) — int
  • workoutReps (workout_reps) — int
  • workoutDay (workout_day) — String

WORKOUT_ROUTINE_OWN_TB

  • ownRoutineId (own_routine_id) — Long — Primary key — NOT NULL
  • userId (user_id) — Long — NOT NULL
  • workoutPart (workout_part) — String
  • workoutName (workout_name) — String
  • workoutSets (workout_sets) — int
  • workoutReps (workout_reps) — int
  • workoutDay (workout_day) — String
  • id (user_id2) — Long — Foreign key → user.id — NOT NULL

user (USER_TB)

  • id (user_id) — Long — Primary key — NOT NULL
  • email (emial) — String
  • name — String
  • provider — String
  • role (String) — String
  • uniName (uniname) — String
  • emailVerify (email_verify) — boolean
  • profilePhoho (profile_phoho) — String