ㅅㄷㄴㅅ

Tables (19)

booking_links

  • id — BIGINT — Primary key — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • site_name — VARCHAR(100) — NOT NULL
  • url — VARCHAR(1000) — NOT NULL

community_comments

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_posts.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

community_post_images

  • id — BIGINT — Primary key — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.id — NOT NULL
  • image — VARCHAR(100) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • size — INT — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

community_posts

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • category — VARCHAR(40) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • content_format — VARCHAR(20) — NOT NULL
  • thumbnail_url — VARCHAR(1000) — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

performance_images

  • id — BIGINT — Primary key — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • image_url — VARCHAR(1000) — NOT NULL
  • sort_order — SMALLINT — NOT NULL

performance_prices

  • id — BIGINT — Primary key — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • raw_text — VARCHAR(255) — NOT NULL
  • sort_order — SMALLINT — NOT NULL

performances

  • performance_id — VARCHAR(20) — Primary key — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • genre — VARCHAR(100) — NOT NULL
  • genre_code — VARCHAR(10) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(20) — NOT NULL
  • status_code — VARCHAR(10) — NOT NULL
  • stage_id — VARCHAR(20) — NOT NULL
  • facility_name — VARCHAR(255) — NOT NULL
  • first_registered_at — DATETIME
  • kopis_updated_at — DATETIME
  • cast — TEXT — NOT NULL
  • crew — TEXT — NOT NULL
  • runtime — VARCHAR(100) — NOT NULL
  • age_rating — VARCHAR(50) — NOT NULL
  • synopsis — TEXT — NOT NULL
  • price_info — TEXT — NOT NULL
  • min_price — INT
  • max_price — INT
  • is_free — BOOLEAN — NOT NULL
  • price_parse_status — VARCHAR(20) — NOT NULL
  • schedule_info — TEXT — NOT NULL
  • openrun — BOOLEAN — NOT NULL
  • is_visit — BOOLEAN — NOT NULL
  • is_child — BOOLEAN — NOT NULL
  • is_daehakro — BOOLEAN — NOT NULL
  • is_festival — BOOLEAN — NOT NULL
  • is_musical_license — BOOLEAN — NOT NULL
  • is_musical_create — BOOLEAN — NOT NULL
  • production_company — VARCHAR(255) — NOT NULL
  • agency — VARCHAR(255) — NOT NULL
  • host — VARCHAR(255) — NOT NULL
  • organizer — VARCHAR(255) — NOT NULL
  • poster_url — VARCHAR(1000) — NOT NULL
  • venue_id — VARCHAR(20) — Foreign key → venues.venue_id
  • view_count — INT — NOT NULL
  • zzim_count — INT — NOT NULL
  • synced_at — DATETIME — NOT NULL

qna_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • question — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

recommendation_feedback

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id
  • feedback_type — VARCHAR(30) — NOT NULL
  • metadata — JSON — NOT NULL
  • created_at — DATETIME — NOT NULL

recommendation_items

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • rank — INT — NOT NULL
  • score — DOUBLE — NOT NULL
  • reason — TEXT — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

recommendation_performance_vectors

  • id — BIGINT — Primary key — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • vector_data — JSON — NOT NULL
  • source_summary — JSON — NOT NULL
  • version — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

recommendation_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • request_text — TEXT — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • prompt_version — VARCHAR(50) — NOT NULL
  • user_profile_snapshot — JSON — NOT NULL
  • candidate_snapshot — JSON — NOT NULL
  • raw_response — JSON — NOT NULL
  • parsed_response — JSON — NOT NULL
  • validation_status — VARCHAR(20) — NOT NULL
  • fallback_used — BOOLEAN — NOT NULL
  • quality_score — DOUBLE
  • created_at — DATETIME — NOT NULL

recommendation_training_candidates

  • id — BIGINT — Primary key — NOT NULL
  • source_session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • training_task — VARCHAR(50) — NOT NULL
  • input_payload — JSON — NOT NULL
  • output_payload — JSON — NOT NULL
  • chosen_output — JSON — NOT NULL
  • rejected_output — JSON — NOT NULL
  • quality_score — DOUBLE — NOT NULL
  • rejection_reasons — JSON — NOT NULL
  • approved_for_training — BOOLEAN — NOT NULL
  • reviewed_by_id — BIGINT — Foreign key → users.id
  • reviewed_at — DATETIME
  • exported_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

recommendation_user_profiles

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • vector_data — JSON — NOT NULL
  • source_summary — JSON — NOT NULL
  • last_built_at — DATETIME
  • is_stale — BOOLEAN — NOT NULL
  • version — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

search_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • keyword — VARCHAR(255) — NOT NULL
  • filter_region — VARCHAR(100) — NOT NULL
  • filter_genre — VARCHAR(100) — NOT NULL
  • filter_status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • last_login — DATETIME
  • email — VARCHAR(254) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(10) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • refresh_token — VARCHAR(512) — NOT NULL
  • refresh_token_expires_at — DATETIME
  • status — INT — NOT NULL
  • is_admin — BOOLEAN — NOT NULL
  • is_staff — BOOLEAN — NOT NULL
  • is_superuser — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users_performance_actions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

venues

  • venue_id — VARCHAR(20) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • facility_characteristic — VARCHAR(100) — NOT NULL
  • sido — VARCHAR(50) — NOT NULL
  • gugun — VARCHAR(50) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • homepage_url — VARCHAR(1000) — NOT NULL
  • has_parking_lot — BOOLEAN — NOT NULL
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • seat_scale — INT
  • synced_at — DATETIME — NOT NULL

view_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • performance_id — VARCHAR(20) — NOT NULL
  • log_type — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL