ㄹㅇㄹㅇ

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