지역기반
테이블 (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