fevertime
Tables (49)
admin
- uuid_jwt_member — binary(16) — Foreign key → jwt_member.uuid_jwt_member — NOT NULL
base_board
- uuid_base_board — binary(16) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- content — text — NOT NULL
- deleted_date — datetime(6)
- hit — bigint
- is_deleted — bit(1) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- title — varchar(255) — NOT NULL
base_document
- uuid_base_document — binary(16) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- filename — varchar(255)
- filepath — varchar(255)
- reg_date — datetime(6) — NOT NULL
- url — varchar(255)
base_image
- uuid_base_image — binary(16) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- filename — varchar(255)
- original_filepath — varchar(255)
- original_height — int
- original_url — varchar(255)
- original_width — int
- reg_date — datetime(6) — NOT NULL
- resized_filepath — varchar(255)
- resized_height — int
- resized_url — varchar(255)
- resized_width — int
base_member
- uuid_base_member — binary(16) — Primary key — NOT NULL
- deleted_date — datetime(6)
- email — varchar(255)
- identifier — varchar(255) — NOT NULL
- is_deleted — bit(1)
- password — varchar(255)
- phone_number — varchar(255)
- reg_date — datetime(6) — NOT NULL
- updated_date — datetime(6) — NOT NULL
base_social_member
- uuid_base_social_member — binary(16) — Primary key — NOT NULL
- deleted_date — datetime(6)
- email — varchar(255)
- is_deleted — bit(1) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- social_id — varchar(255)
- social_provider — enum('KAKAO','GOOGLE','LINE','FACEBOOK','NAVER','APPLE','ETC') — NOT NULL
- updated_date — datetime(6) — NOT NULL
card
- uuid_card — binary(16) — Primary key — NOT NULL
- deleted_date — datetime(6)
- history_card_type — enum('WAITING','IN_PROGRESS','MATCHING') — NOT NULL
- is_chat_opened — bit(1) — NOT NULL
- is_deleted — bit(1) — NOT NULL
- is_prepared — bit(1) — NOT NULL
- is_receiver_evaluated — bit(1) — NOT NULL
- is_receiver_liked — bit(1) — NOT NULL
- is_receiver_superliked — bit(1) — NOT NULL
- is_sender_evaluated — bit(1) — NOT NULL
- is_sender_liked — bit(1) — NOT NULL
- is_sender_superliked — bit(1) — NOT NULL
- matching_type — enum('LIKE','SUPERLIKE','LOUNGE','PARTY')
- member_receiver_uuid — binary(16) — NOT NULL
- member_sender_uuid — binary(16) — NOT NULL
- opened_date — datetime(6)
- prepared_card_type — enum('DEFAULT','ADMIN','USER')
- card_reg_date — datetime(6) — NOT NULL
- superlike_message — varchar(255)
- time_to_open — datetime(6)
- card_updated_date — datetime(6) — NOT NULL
- is_read — bit(1) — NOT NULL
- read_date — datetime(6)
certificate
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- certificate_status — enum('PENDING','APPROVED','REJECTED') — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
chat_image
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- member_uuid — binary(16) — NOT NULL
- chat_message_uuid — binary(16) — Foreign key → chat_message.uuid_chat_message
- chat_room_uuid — binary(16) — Foreign key → chat_room.uuid_chat_room — NOT NULL
chat_message
- uuid_chat_message — binary(16) — Primary key — NOT NULL
- chat_message_type — enum('TEXT','IMAGE','SYSTEM') — NOT NULL
- content — text
- member_uuid — binary(16)
- chat_message_reg_date — datetime(6) — NOT NULL
- chat_room_uuid — binary(16) — Foreign key → chat_room.uuid_chat_room — NOT NULL
chat_participate
- uuid_chat_participate — binary(16) — Primary key — NOT NULL
- chat_room_uuid — binary(16) — NOT NULL
- chat_participate_deleted_date — datetime(6)
- chat_participate_is_deleted — bit(1) — NOT NULL
- last_message_date — datetime(6) — NOT NULL
- last_read_date — datetime(6)
- chat_participate_reg_date — datetime(6) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
chat_room
- uuid_chat_room — binary(16) — Primary key — NOT NULL
- is_opened — bit(1) — NOT NULL
- last_message_date — datetime(6) — NOT NULL
- matching_type — enum('LIKE','SUPERLIKE','LOUNGE','PARTY') — NOT NULL
- chat_room_reg_date — datetime(6) — NOT NULL
comment
- uuid_comment — binary(16) — Primary key — NOT NULL
- blocked_date — datetime(6)
- content — text — NOT NULL
- comment_deleted_date — datetime(6)
- is_blocked — bit(1) — NOT NULL
- comment_is_deleted — bit(1) — NOT NULL
- comment_reg_date — datetime(6) — NOT NULL
- comment_updated_date — datetime(6) — NOT NULL
- writer_gender — enum('MALE','FEMALE') — NOT NULL
- writer_name — varchar(20) — NOT NULL
- lounge_uuid — binary(16) — Foreign key → lounge.uuid_base_board — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- comment_parent_uuid — binary(16) — Foreign key → comment.uuid_comment
complaint
- uuid_complaint — binary(16) — Primary key — NOT NULL
- check_date — datetime(6)
- complaint_type — enum('LOUNGE','PARTY','PROFILE','ADMIN','ETC') — NOT NULL
- is_checked — bit(1) — NOT NULL
- reason — varchar(255) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- unblock_date — datetime(6)
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member
contact
- uuid_contact — binary(16) — Primary key — NOT NULL
- phone_number — varchar(20) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
document
- uuid_document — binary(16) — Primary key — NOT NULL
- document_status — enum('PENDING','APPROVED','REJECTED') — NOT NULL
- document_type — enum('INCOME1','INCOME2','CAR1','CAR2','RESIDENCE1','JOB1','JOB2','JOB3','INFLUENCER1','PROPERTY1','PROPERTY2','PROPERTY3','PROPERTY4') — NOT NULL
- reg_date — datetime(6) — NOT NULL
- rejected_reason — varchar(255)
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
document_file
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- document_uuid — binary(16) — Foreign key → document.uuid_document — NOT NULL
evaluation
- uuid_evaluation — binary(16) — Primary key — NOT NULL
- evaluation_reg_date — datetime(6) — NOT NULL
- star — int — NOT NULL
- evaluation_updated_date — datetime(6) — NOT NULL
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
fever
- uuid_fever — binary(16) — Primary key — NOT NULL
- fever_type — enum('INCOME1','INCOME2','CAR1','CAR2','RESIDENCE1','JOB1','JOB2','JOB3','INFLUENCER1','PROPERTY1','PROPERTY2','PROPERTY3','PROPERTY4') — NOT NULL
- fever_reg_date — datetime(6) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
job
- uuid_job — binary(16) — Primary key — NOT NULL
- is_active — bit(1) — NOT NULL
- job_name — varchar(20) — NOT NULL
jwt_member
- uuid_jwt_member — binary(16) — Primary key — NOT NULL
- deleted_date — datetime(6)
- email — varchar(255)
- identifier — varchar(255) — NOT NULL
- is_deleted — bit(1)
- password — varchar(255)
- phone_number — varchar(255)
- reg_date — datetime(6) — NOT NULL
- updated_date — datetime(6) — NOT NULL
jwt_member_permission
- jwt_member_uuid — binary(16) — Foreign key → jwt_member.uuid_jwt_member — NOT NULL
- permission_id — bigint — Foreign key → permission.id_permission — NOT NULL
jwt_social_member
- uuid_jwt_social_member — binary(16) — Primary key — NOT NULL
- deleted_date — datetime(6)
- email — varchar(255)
- is_deleted — bit(1) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- social_id — varchar(255)
- social_provider — enum('KAKAO','GOOGLE','LINE','FACEBOOK','NAVER','APPLE','ETC') — NOT NULL
- updated_date — datetime(6) — NOT NULL
jwt_social_member_permission
- permission_id — bigint — Foreign key → permission.id_permission — NOT NULL
- jwt_social_member_uuid — binary(16) — Foreign key → jwt_social_member.uuid_jwt_social_member — NOT NULL
likes
- uuid_likes — binary(16) — Primary key — NOT NULL
- is_mutual — bit(1) — NOT NULL
- likes_reg_date — datetime(6) — NOT NULL
- likes_updated_date — datetime(6) — NOT NULL
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
lounge
- uuid_base_board — binary(16) — Foreign key → base_board.uuid_base_board — NOT NULL
- blocked_date — datetime(6)
- comment_cnt — bigint — NOT NULL
- dislike_cnt — bigint — NOT NULL
- is_blocked — bit(1) — NOT NULL
- like_cnt — bigint — NOT NULL
- lounge_category — enum('ANYTHING','QUIET') — NOT NULL
- participant_cnt — bigint — NOT NULL
- thumbnail_image_original_height — int
- thumbnail_image_original_url — varchar(255)
- thumbnail_image_original_width — int
- thumbnail_image_resized_height — int
- thumbnail_image_resized_url — varchar(255)
- thumbnail_image_resized_width — int
- writer_gender — enum('MALE','FEMALE') — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
lounge_heart
- uuid_lounge_heart — binary(16) — Primary key — NOT NULL
- approved_date — datetime(6)
- is_approved — bit(1) — NOT NULL
- is_mutual — bit(1) — NOT NULL
- is_receiver_opened — bit(1) — NOT NULL
- is_sender_opened — bit(1) — NOT NULL
- message — varchar(255)
- mutual_date — datetime(6)
- receiver_opened_date — datetime(6)
- lounge_heart_reg_date — datetime(6) — NOT NULL
- sender_opened_date — datetime(6)
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
lounge_image
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- lounge_uuid — binary(16) — Foreign key → lounge.uuid_base_board — NOT NULL
lounge_reaction
- uuid_lounge_reaction — binary(16) — Primary key — NOT NULL
- reaction_type — enum('좋아요','싫어요')
- lounge_uuid — binary(16) — Foreign key → lounge.uuid_base_board — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
member
- uuid_jwt_social_member — binary(16) — Foreign key → jwt_social_member.uuid_jwt_social_member — NOT NULL
- acitivity_address — varchar(255)
- activity_sido_code — varchar(255)
- activity_sigungu_code — varchar(255)
- age — int
- birth_date — date
- block_end_date — datetime(6)
- block_start_date — datetime(6)
- blocked_cnt — int — NOT NULL
- drinking — enum('자주','가끔','아예안마셔요')
- fever_cnt — int
- gender — enum('MALE','FEMALE')
- height — int
- introduction — varchar(255)
- is_friend_blocked — bit(1) — NOT NULL
- is_member_blocked — bit(1) — NOT NULL
- is_recommend — bit(1) — NOT NULL
- job — varchar(20)
- last_contact_synchronized_date — datetime(6)
- last_login_date — datetime(6) — NOT NULL
- last_notification_read_date — datetime(6)
- member_status — enum('PENDING','APPROVED','REJECTED') — NOT NULL
- my_body_type — enum('MALE_SLIM','MALE_NORMAL','MALE_SLIMSTRONG','MALE_MUSCLE','MALE_CHUBBY','FEMALE_SLIM','FEMALE_NORMAL','FEMALE_VOLUME','FEMALE_GLAMOUR','FEMALE_CHUBBY')
- name — varchar(10)
- nickname — varchar(10)
- payment_amount — bigint — NOT NULL
- phone_number — varchar(20)
- points — bigint — NOT NULL
- recommended_cnt — bigint — NOT NULL
- representative_image_original_height — int
- representative_image_original_url — varchar(255)
- representative_image_original_width — int
- representative_image_resized_height — int
- representative_image_resized_url — varchar(255)
- representative_image_resized_width — int
- residence_address — varchar(255)
- residence_sido_code — varchar(255)
- residence_sigungu_code — varchar(255)
- smoking — enum('흡연중','전자담배','금연중','비흡연')
- recommended_code — varchar(10)
member_preference_body_type
- uuid_member_preference_body_type — binary(16) — Primary key — NOT NULL
- body_type — enum('MALE_SLIM','MALE_NORMAL','MALE_SLIMSTRONG','MALE_MUSCLE','MALE_CHUBBY','FEMALE_SLIM','FEMALE_NORMAL','FEMALE_VOLUME','FEMALE_GLAMOUR','FEMALE_CHUBBY') — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
mok_result
- uuid_mok_result — binary(16) — Primary key — NOT NULL
- birth_date — date
- expired_at — datetime(6)
- gender — enum('MALE','FEMALE')
- name — varchar(10)
- phone_number — varchar(20)
near
- uuid_near — binary(16) — Primary key — NOT NULL
- latitude — decimal(9,6) — NOT NULL
- longitude — decimal(9,6) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- updated_date — datetime(6) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
notice
- uuid_base_board — binary(16) — Foreign key → base_board.uuid_base_board — NOT NULL
notification
- uuid_notification — binary(16) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- body — varchar(255) — NOT NULL
- deleted_date — datetime(6)
- is_deleted — bit(1) — NOT NULL
- is_read — bit(1) — NOT NULL
- read_date — datetime(6)
- reg_date — datetime(6) — NOT NULL
- title — varchar(255) — NOT NULL
- notification_type — enum('TODAY_CARD','SUPERLIKE','LIKE','EVALUATION','PARTY_LIKE','PARTY_PARTICIPATE','LOUNGE_COMMENT','LOUNGE_HEART','LIKE_MATCHING','SUPERLIKE_MATCHING','PARTY_PARTICIPATE_MATCHING','LOUNGE_HEART_MATCHING','CHATTING','ETC','ADMIN') — NOT NULL
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member
notification_setting
- uuid_notification_setting — binary(16) — Primary key — NOT NULL
- is_chatting_on — bit(1) — NOT NULL
- is_evaluation_on — bit(1) — NOT NULL
- is_like_matching_on — bit(1) — NOT NULL
- is_like_on — bit(1) — NOT NULL
- is_lounge_on — bit(1) — NOT NULL
- is_party_on — bit(1) — NOT NULL
- is_sound_on — bit(1) — NOT NULL
- is_superlike_on — bit(1) — NOT NULL
- is_today_card_on — bit(1) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
notification_token
- uuid_notification_token — binary(16) — Primary key — NOT NULL
- DTYPE — varchar(31) — NOT NULL
- device_type — enum('IOS','ANDROID','WEB','OTHERS') — NOT NULL
- fcm_token — varchar(255) — NOT NULL
- reg_date — datetime(6) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
party
- uuid_base_board — binary(16) — Foreign key → base_board.uuid_base_board — NOT NULL
- blocked_date — datetime(6)
- is_blocked — bit(1) — NOT NULL
- party_category — enum('INTRODUCTION','QUIET') — NOT NULL
- writer_gender — enum('MALE','FEMALE') — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
party_like
- uuid_party_like — binary(16) — Primary key — NOT NULL
- is_opened — bit(1) — NOT NULL
- opened_date — datetime(6)
- party_like_reg_date — datetime(6) — NOT NULL
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- party_uuid — binary(16) — Foreign key → party.uuid_base_board — NOT NULL
party_participate
- uuid_party_participate — binary(16) — Primary key — NOT NULL
- approved_date — datetime(6)
- is_approved — bit(1) — NOT NULL
- is_mutual — bit(1) — NOT NULL
- is_receiver_opened — bit(1) — NOT NULL
- is_sender_opened — bit(1) — NOT NULL
- message — varchar(255)
- mutual_date — datetime(6)
- receiver_opened_date — datetime(6)
- party_participate_reg_date — datetime(6) — NOT NULL
- sender_opened_date — datetime(6)
- member_receiver_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- member_sender_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- party_uuid — binary(16) — Foreign key → party.uuid_base_board — NOT NULL
payment
- uuid_payment — binary(16) — Primary key — NOT NULL
- idempotency_key — varchar(255)
- payment_key — varchar(255)
- payment_status — enum('PENDING','APPROVED','REJECTED','CANCELED') — NOT NULL
- reg_date — datetime(6) — NOT NULL
- updated_date — datetime(6) — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
- product_uuid — binary(16) — Foreign key → product.uuid_product — NOT NULL
permission
- id_permission — bigint — Primary key — NOT NULL
- permission_type — varchar(255) — NOT NULL
point_transaction
- uuid_point_transaction — binary(16) — Primary key — NOT NULL
- amount — bigint — NOT NULL
- description — varchar(255)
- reg_date — datetime(6) — NOT NULL
- transaction_type — enum('충전','사용','보너스') — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
popup
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- end_date — date — NOT NULL
- start_date — date — NOT NULL
product
- uuid_product — binary(16) — Primary key — NOT NULL
- additional_point — bigint — NOT NULL
- default_point — bigint — NOT NULL
- is_active — bit(1) — NOT NULL
- mark — varchar(255)
- price — bigint — NOT NULL
profile_image
- uuid_base_image — binary(16) — Foreign key → base_image.uuid_base_image — NOT NULL
- member_uuid — binary(16) — Foreign key → member.uuid_jwt_social_member — NOT NULL
refresh_token
- uuid_refresh_token — binary(16) — Primary key — NOT NULL
- expired_at — datetime(6) — NOT NULL
- member_uuid — binary(16) — NOT NULL
- refresh_token — varchar(500) — NOT NULL
sido
- sido_code — varchar(10) — Primary key — NOT NULL
- sido_name — varchar(10) — NOT NULL
sigungu
- sigungu_code — varchar(10) — Primary key — NOT NULL
- sigungu_name — varchar(10) — NOT NULL
- sido_code — varchar(10) — Foreign key → sido.sido_code — NOT NULL