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