Feelog

Tables (24)

admin_service_adjustments_tb

  • admin_service_adjustment_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • prop_long1 — bigint
  • prop_long2 — bigint
  • prop_long3 — bigint
  • prop_long4 — bigint
  • prop_string1 — character
  • prop_string2 — character
  • prop_string3 — character
  • prop_string4 — character
  • service_type — character

admin_service_error_managements_tb

  • admin_service_error_management_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • prop_msg_string1 — character
  • prop_msg_string2 — character
  • prop_msg_string3 — character
  • prop_msg_string4 — character
  • service_error_type — character

flyway_schema_history

  • installed_rank — integer — Primary key — NOT NULL
  • version — character
  • description — character — NOT NULL
  • type — character — NOT NULL
  • script — character — NOT NULL
  • checksum — integer
  • installed_by — character — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — integer — NOT NULL
  • success — boolean — NOT NULL

sns_block_users_tb

  • sns_block_user_id — bigint — Primary key — NOT NULL
  • is_blocked_at — timestamp(6)
  • sns_blocked_user_id — bigint
  • sns_blocker_user_id — bigint

sns_notifications_tb

  • sns_notification_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • notification_content_user_id — bigint — NOT NULL
  • notification_content_user_profile_path — character — NOT NULL
  • notification_content_username — character — NOT NULL
  • notification_count — integer — NOT NULL
  • sns_notification_contents — jsonb — NOT NULL
  • notification_type — character — NOT NULL
  • username — character — NOT NULL
  • sns_follower_id — bigint
  • sns_post_id — bigint
  • sns_user_id — bigint — NOT NULL

sns_post_comment_likes_tb

  • sns_post_comment_like_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • is_liked — boolean — NOT NULL
  • is_liked_at — timestamp(6)
  • sns_post_id — bigint — NOT NULL
  • sns_post_comment_reaction_id — bigint
  • sns_user_id — bigint — NOT NULL

sns_post_comment_reactions_tb

  • sns_post_comment_reaction_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • comment_media_content — character
  • comment_media_type — character
  • comment_msg — character
  • deleted_at — timestamp(6)
  • is_source — boolean — NOT NULL
  • comment_user_id — bigint — NOT NULL
  • sns_post_id — bigint — NOT NULL
  • source_comment_id — bigint

sns_post_reports_tb

  • sns_post_report_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • post_report_reason_type — character — NOT NULL
  • post_report_status — character — NOT NULL
  • report_reason — character — NOT NULL
  • reported_user_id — bigint
  • reporter_user_id — bigint — NOT NULL
  • sns_post_id — bigint
  • sns_post_comment_reaction_id — bigint

sns_post_user_reactions_tb

  • sns_post_user_reaction_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • is_clipped — boolean — NOT NULL
  • is_clipped_at — timestamp(6)
  • is_liked — boolean — NOT NULL
  • is_liked_at — timestamp(6)
  • is_reposted — boolean — NOT NULL
  • is_reposted_at — timestamp(6)
  • is_shown — boolean — NOT NULL
  • not_shown_at — timestamp(6)
  • sns_post_id — bigint — NOT NULL
  • sns_user_id — bigint — NOT NULL

sns_posts_tb

  • sns_post_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • address — character
  • deleted_at — timestamp(6)
  • is_exposed — boolean — NOT NULL
  • is_repost — boolean
  • is_show_address — boolean
  • latitude — real
  • longitude — real
  • post_body_text — character
  • post_content_business_type — character
  • post_title — character
  • reaction_count — integer
  • sns_post_contents — jsonb — NOT NULL
  • tags — jsonb — NOT NULL
  • tgt_aud_type — character
  • repost_origin_id — bigint
  • sns_user_id — bigint
  • build_name — character
  • geom — geometry
  • h3_index — bigint

sns_scrap_boards_tb

  • sns_scrap_board_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • deleted_at — timestamp(6)
  • scrap_name — character — NOT NULL
  • target_audience — character — NOT NULL
  • sns_user_id — bigint

sns_scraps_tb

  • sns_scrap_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • sns_post_id — bigint
  • sns_scrap_board_id — bigint
  • sns_user_id — bigint
  • deleted_at — timestamp(6)

sns_tag_follows_tb

  • sns_tag_follow_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • tag_name — character
  • sns_tag_id — bigint
  • sns_user_id — bigint

sns_tag_posts_tb

  • sns_tag_post_id — bigint — Primary key — NOT NULL
  • sns_post_id — bigint
  • sns_tag_id — bigint

sns_tags_tb

  • sns_tag_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • is_exposed — boolean
  • tag_name — character — NOT NULL
  • tag_reps_batch_content — character
  • tag_reps_batch_content_type — character
  • deleted_at — timestamp(6)

sns_user_favorite_term_bookmarks_tb

  • sns_user_favorite_term_bookmark_id — bigint — Primary key — NOT NULL
  • favorite_term_content — character
  • favorite_term_content_type — character
  • favorite_term_name — character
  • sns_tag_follow_id — bigint
  • sns_user_id — bigint

sns_user_follow_statistics_tb

  • sns_user_follow_statistic_id — bigint — Primary key — NOT NULL
  • follower_num — integer
  • following_num — integer
  • sns_user_id — bigint — NOT NULL

sns_user_follows_tb

  • sns_user_follow_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • follower_id — bigint
  • following_id — bigint

sns_user_message_reactions_tb

  • sns_user_message_reaction_id — bigint — Primary key — NOT NULL
  • has_msg_reaction — boolean — NOT NULL
  • is_read — boolean — NOT NULL
  • reacted_at — timestamp(6)
  • read_at — timestamp(6)
  • msg_reaction_type — character
  • sns_user_message_id — bigint — NOT NULL

sns_user_message_room_members_tb

  • sns_user_message_room_member_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • is_blocked — boolean — NOT NULL
  • is_hidden — boolean — NOT NULL
  • msg_room_type — character — NOT NULL
  • read_at — timestamp(6)
  • sns_user_message_room_id — bigint — NOT NULL
  • source_user_id — bigint — NOT NULL
  • target_user_id — bigint

sns_user_message_rooms_tb

  • sns_user_message_room_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • msg_room_type — character — NOT NULL

sns_user_messages_tb

  • sns_user_message_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • deleted_at — timestamp(6)
  • sns_user_message_room_id — bigint — NOT NULL
  • source_user_id — bigint — NOT NULL
  • msg_text_content — character
  • msg_media_type — character
  • msg_media_content — character
  • msg_meta_info — jsonb — NOT NULL

sns_user_reports_tb

  • sns_user_report_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • report_reason — character — NOT NULL
  • user_report_reason_type — character — NOT NULL
  • user_report_status — character — NOT NULL
  • reported_user_id — bigint
  • reporter_user_id — bigint — NOT NULL

sns_users_tb

  • sns_user_id — bigint — Primary key — NOT NULL
  • created_at — timestamp(6)
  • last_updated_at — timestamp(6)
  • last_updated_by — bigint
  • birth_date — date
  • deleted_at — timestamp(6)
  • email — character
  • has_follower_notification — boolean — NOT NULL
  • hash_pw — character
  • is_private_profile — boolean — NOT NULL
  • nickname — character — NOT NULL
  • profile_path — character
  • refresh_token — character
  • sign_up_type — character
  • signup_email — character
  • sns_app_role — character
  • sns_user_gender — character
  • sns_user_state — character
  • social_id — character
  • user_description — character
  • user_link — character
  • username — character — NOT NULL