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