ㄹㅇㄹㅇ
Tables (34)
artists
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
bookmarks
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- notify_enabled — BIT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
click_aggregation_checkpoints
- id — BIGINT
- pipeline_key — VARCHAR(100) — NOT NULL
- last_processed_click_log_id — BIGINT — NOT NULL
- updated_at — DATETIME — NOT NULL
exhibition_artists
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- artist_id — BIGINT — Foreign key → artists.id — NOT NULL
exhibition_click_daily_aggregates
- id — BIGINT
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- clicked_date — DATE — NOT NULL
- click_count — BIGINT — NOT NULL
exhibition_click_logs
- id — BIGINT
- clicked_date — DATE — NOT NULL
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
exhibition_genres
- id — BIGINT
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- genre_id — BIGINT — Foreign key → genres.id — NOT NULL
exhibition_record_hashtag
- exhibition_record_id — BIGINT — Foreign key → exhibition_records.id — NOT NULL
- hashtag_id — BIGINT — Foreign key → hashtags.id — NOT NULL
exhibition_records
- id — BIGINT
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- draft — BIT(1) — NOT NULL
- like_count — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- update_at — DATETIME — NOT NULL
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
exhibitions
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- location — VARCHAR(255) — NOT NULL
- poster_url — VARCHAR(500) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- price — INT — NOT NULL
- is_free — BIT(1) — NOT NULL
- exhibition_theme — VARCHAR(50) — NOT NULL
- genre — VARCHAR(50) — NOT NULL
- contact — VARCHAR(100) — NOT NULL
- website — VARCHAR(500) — NOT NULL
- viewing_time — VARCHAR(200) — NOT NULL
- personalized_poster_url — VARCHAR(200) — NOT NULL
- general_recommendations_poster_url — VARCHAR(500) — NOT NULL
- venue_id — BIGINT — Foreign key → venues.id — NOT NULL
follow
- id — BIGINT
- follower_id — BIGINT — Foreign key → users.id — NOT NULL
- following_id — BIGINT — Foreign key → users.id — NOT NULL
genres
- id — BIGINT
- genre_type — VARCHAR(50) — NOT NULL
hashtags
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
initial_exhibitions
- id — BIGINT
- name — VARCHAR(150) — NOT NULL
- poster_url — VARCHAR(500) — NOT NULL
- genre — VARCHAR(50) — NOT NULL
- exhibition_theme — VARCHAR(50) — NOT NULL
notification_images
- id — BIGINT
- notification_id — BIGINT — NOT NULL
- image_url — VARCHAR(1000) — NOT NULL
- sort_order — INT — NOT NULL
notifications
- id — BIGINT
- receiver_user_id — BIGINT — NOT NULL
- actor_user_id — BIGINT
- actor_nickname — VARCHAR(50)
- message — VARCHAR(255)
- type — VARCHAR(30) — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- title — VARCHAR(80) — NOT NULL
- body — VARCHAR(255) — NOT NULL
- is_read — BIT(1) — NOT NULL
- read_at — DATETIME
- dedup_key — VARCHAR(120)
- created_at — DATETIME — NOT NULL
record_comments
- id — BIGINT
- record_id — BIGINT — Foreign key → exhibition_records.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- parent_comment_id — BIGINT — Foreign key → record_comments.id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
record_likes
- id — BIGINT
- liked_at — DATETIME — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- record_id — BIGINT — Foreign key → exhibition_records.id — NOT NULL
record_media
- id — BIGINT
- media_type — VARCHAR(20) — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- duration_seconds — INT
- record_id — BIGINT — Foreign key → exhibition_records.id — NOT NULL
record_scraps
- id — BIGINT
- record_id — BIGINT — Foreign key → exhibition_records.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
searches
- id — BIGINT
- keyword — VARCHAR(255) — NOT NULL
- searched_at — DATETIME — NOT NULL
- exhibition_id — BIGINT — Foreign key → exhibitions.id
- user_id — BIGINT — Foreign key → users.id — NOT NULL
service_announcements
- id — BIGINT
- title — VARCHAR(120) — NOT NULL
- body — TEXT — NOT NULL
- push_enabled — BIT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
shedlock
- name — VARCHAR(64)
- lock_until — TIMESTAMP(3) — NOT NULL
- locked_at — TIMESTAMP(3) — NOT NULL
- locked_by — VARCHAR(255) — NOT NULL
ugc_reports
- id — BIGINT
- reporter_id — BIGINT — Foreign key → users.id — NOT NULL
- reported_user_id — BIGINT — Foreign key → users.id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — VARCHAR(30) — NOT NULL
- detail — VARCHAR(1000)
- status — VARCHAR(20) — NOT NULL
- action — VARCHAR(30) — NOT NULL
- admin_memo — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- due_at — DATETIME — NOT NULL
- processed_at — DATETIME
- offender_notice_read_at — DATETIME
user_blocks
- id — BIGINT
- blocker_id — BIGINT — Foreign key → users.id — NOT NULL
- blocked_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
user_genre_weights
- genre_weights_key — VARCHAR(50) — Primary key — NOT NULL
- user_genre_id — BIGINT — Foreign key → user_genres.id — NOT NULL
- weight — DOUBLE — NOT NULL
user_genres
- id — BIGINT
- user_id — BIGINT — NOT NULL
user_push_tokens
- id — BIGINT
- user_id — BIGINT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- platform — VARCHAR(20) — NOT NULL
- is_active — BIT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
user_theme_weights
- theme_weights_key — VARCHAR(50) — Primary key — NOT NULL
- user_genre_id — BIGINT — Foreign key → user_genres.id — NOT NULL
- weight — DOUBLE — NOT NULL
user_visits
- id — BIGINT
- visited_at — DATE — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- exhibition_id — BIGINT — Foreign key → exhibitions.id — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- oauth_provider — VARCHAR(50) — NOT NULL
- oauth_id — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30)
- created_at — DATETIME
- gender — VARCHAR(50)
- birth_year — INT
- introduction — VARCHAR(1000)
- profile_image_url — VARCHAR(500)
- signature — VARCHAR(20)
- role — VARCHAR(50) — NOT NULL
- moderation_strike — INT — NOT NULL
- suspended_until — DATETIME
- permanently_banned — BIT(1) — NOT NULL
venue_photos
- id — BIGINT
- venue_id — BIGINT — Foreign key → venues.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- caption — VARCHAR(200)
- sort_order — INT — NOT NULL
- is_cover — BIT(1) — NOT NULL
venues
- id — BIGINT
- name — VARCHAR(150) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- description — TEXT
- address — VARCHAR(255)
- phone — VARCHAR(50)
- email — VARCHAR(50)
- website — VARCHAR(255)
- opening_hours — VARCHAR(100)
- latitude — DECIMAL(10,6)
- longitude — DECIMAL(10,6)
- logo_image_url — VARCHAR(500)
- background_image_url — VARCHAR(500)
- parking_fee — VARCHAR(255)
webhook_delivery
- id — BIGINT
- event_type — VARCHAR(40) — NOT NULL
- target_id — BIGINT — NOT NULL
- webhook_url — VARCHAR(1000) — NOT NULL
- payload — VARCHAR(4000) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- attempt_count — INT — NOT NULL
- last_error — VARCHAR(1000)
- next_retry_at — DATETIME
- sent_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL