지역기반

테이블 (17)

activity_outbox

  • id — BIGINT
  • idempotency_key — VARCHAR(100) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL
  • operation_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • error_message — VARCHAR(1000)
  • processed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_outbox_status_created
  • INDEX — idx_outbox_user

badge_rules

  • id — BIGINT
  • badge_id — BIGINT — 외래 키 → badges.id — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL
  • threshold — INT — NOT NULL
  • evaluation_type — VARCHAR(20) — NOT NULL
  • enabled — BOOLEAN
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_badge_rules_badge_id
  • INDEX — idx_badge_rules_activity_type(activity_type)
  • INDEX — idx_badge_rules_created_at

badges

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500) — NOT NULL
  • icon_url — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_badges_name
  • INDEX — idx_badges_created_at

comments

  • id — BIGINT
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • parent_comment_id — BIGINT — 외래 키 → comments.id
  • deleted — BOOLEAN
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by — VARCHAR(100)
  • INDEX — idx_comments_post_id
  • INDEX — idx_comments_user_id
  • INDEX — idx_comments_parent_comment_id(parent_comment_id)
  • INDEX — idx_comments_deleted
  • INDEX — idx_comments_created_at

failed_activity_events

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL
  • operation_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • failed_at — DATETIME(6) — NOT NULL
  • retry_count — INT — NOT NULL
  • error_message — VARCHAR(1000)
  • status — VARCHAR(50) — NOT NULL
  • processed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_failed_event_status
  • INDEX — idx_failed_event_user
  • INDEX — idx_failed_event_created
  • INDEX — idx_failed_event_operation_type(operation_type)

festivals

  • id — BIGINT
  • title — VARCHAR(1000) — NOT NULL
  • venue — VARCHAR(1000)
  • start_date — DATE
  • end_date — DATE
  • category — VARCHAR(100)
  • district — VARCHAR(100)
  • target_audience — VARCHAR(500)
  • fee_info — VARCHAR(1000)
  • is_free — BOOLEAN
  • performers — TEXT
  • program_info — TEXT
  • main_image_url — VARCHAR(1000)
  • theme_code — VARCHAR(100)
  • ticket_type — VARCHAR(50)
  • organizer — VARCHAR(500)
  • homepage_url — VARCHAR(1000)
  • detail_url — VARCHAR(1000)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • content — TEXT
  • data_source — VARCHAR(50) — NOT NULL
  • external_id — VARCHAR(100) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_festivals_title
  • INDEX — idx_festivals_start_date
  • INDEX — idx_festivals_end_date
  • INDEX — idx_festivals_venue
  • INDEX — idx_festivals_data_source
  • INDEX — idx_festivals_location
  • INDEX — idx_date_location

meeting_participants

  • id — BIGINT
  • meeting_id — BIGINT — 외래 키 → meetings.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • message — VARCHAR(500)
  • joined_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_meeting_participants_meeting_id
  • INDEX — idx_meeting_participants_user_id
  • INDEX — idx_meeting_participants_status
  • INDEX — idx_meeting_participants_created_at

meetings

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_time — DATETIME(6) — NOT NULL
  • end_time — DATETIME(6) — NOT NULL
  • max_members — INT — NOT NULL
  • current_members — INT
  • address — VARCHAR(200) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • status — VARCHAR(20) — NOT NULL
  • leader_id — BIGINT — 외래 키 → users.id — NOT NULL
  • deleted — BOOLEAN
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by — VARCHAR(100)
  • INDEX — idx_meetings_title
  • INDEX — idx_meetings_start_time(start_time)
  • INDEX — idx_meetings_address
  • INDEX — idx_meetings_status
  • INDEX — idx_meetings_leader_id
  • INDEX — idx_meetings_deleted

post_image

  • id — BIGINT
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by — VARCHAR(100)
  • INDEX — idx_post_image_post_id

post_likes

  • id — BIGINT
  • post_id — BIGINT — 외래 키 → posts.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_post_likes_post_id
  • INDEX — idx_post_likes_user_id
  • INDEX — idx_post_likes_created_at(created_at)

posts

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • region_code — VARCHAR(20) — 외래 키 → regions.code — NOT NULL
  • like_count — INT
  • deleted — BOOLEAN
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by — VARCHAR(100)
  • INDEX — idx_posts_user_id
  • INDEX — idx_posts_region_code(region_code)
  • INDEX — idx_posts_title
  • INDEX — idx_posts_created_at
  • INDEX — idx_posts_deleted

refresh_tokens

  • id — BIGINT
  • token_hash — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • INDEX — idx_refresh_tokens_token_hash
  • INDEX — idx_refresh_tokens_user_id
  • INDEX — idx_refresh_tokens_expires_at
  • INDEX — idx_refresh_tokens_created_at

regions

  • code — VARCHAR(20)
  • name — VARCHAR(100) — NOT NULL
  • parent_code — VARCHAR(20)
  • level — INT
  • INDEX — idx_regions_parent_code

shedlock

  • name — VARCHAR(64) — NOT NULL
  • lock_until — TIMESTAMP — NOT NULL
  • locked_at — TIMESTAMP — NOT NULL
  • locked_by — VARCHAR(255) — NOT NULL

user_activities

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL
  • points_earned — INT — NOT NULL
  • target_id — BIGINT — NOT NULL
  • resource_type — VARCHAR(50) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_user_activities_user_id
  • INDEX — idx_user_activities_activity_type(activity_type)
  • INDEX — idx_user_activities_resource_type(resource_type)
  • INDEX — idx_user_activities_created_at

user_badges

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • badge_id — BIGINT — 외래 키 → badges.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_user_badges_user_id
  • INDEX — idx_user_badges_badge_id

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_picture_url — VARCHAR(512)
  • self_intro — TEXT
  • interests — JSON
  • address — VARCHAR(255)
  • latitude — DECIMAL(9, 6)
  • longitude — DECIMAL(9, 6)
  • role — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_id — VARCHAR(100)
  • points — INT — NOT NULL
  • deleted — BOOLEAN
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100)
  • updated_at — DATETIME(6) — NOT NULL
  • updated_by — VARCHAR(100)
  • INDEX — idx_users_email
  • INDEX — idx_users_nickname
  • INDEX — idx_users_provider_id(provider_id)
  • INDEX — idx_users_deleted
  • INDEX — idx_users_points