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