festival-scope

Tables (17)

festival

  • festival_id — BIGINT — Primary key — NOT NULL
  • festival_code — VARCHAR(20) — NOT NULL
  • festival_name — VARCHAR(200) — NOT NULL
  • sido — VARCHAR(50) — NOT NULL
  • sigungu — VARCHAR(50)
  • festival_type — VARCHAR(50)
  • first_year — INT
  • venue — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

festival_analysis

  • festival_analysis_id — BIGINT — Primary key — NOT NULL
  • festival_plan_id — BIGINT — Foreign key → festival_plan.festival_plan_id — NOT NULL
  • analysis_version — VARCHAR(30) — NOT NULL
  • total_score — DECIMAL(5,2)
  • analysis_status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL

festival_analysis_accessibility

  • accessibility_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • nearest_station_name — VARCHAR(200)
  • nearest_station_distance_m — INT
  • bus_stop_count — INT
  • bus_route_count — INT
  • parking_count — INT
  • parking_capacity — INT
  • accessibility_score — DECIMAL(5,2)
  • created_at — DATETIME — NOT NULL

festival_analysis_conflict_event

  • conflict_event_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • festival_id — BIGINT — Foreign key → festival.festival_id
  • event_name — VARCHAR(200) — NOT NULL
  • sido — VARCHAR(50)
  • sigungu — VARCHAR(50)
  • event_year — INT
  • start_date — DATE
  • end_date — DATE
  • distance_km — DECIMAL(8,2)
  • overlap_days — INT
  • same_theme — BOOLEAN
  • event_basis — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_analysis_demand

  • festival_analysis_demand_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • demand_type — VARCHAR(20) — NOT NULL
  • region_code — VARCHAR(30)
  • sido — VARCHAR(50) — NOT NULL
  • sigungu — VARCHAR(50)
  • stat_year — INT — NOT NULL
  • stat_month — INT
  • visitor_count — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_analysis_item

  • festival_analysis_item_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_id — BIGINT — Foreign key → festival_analysis.festival_analysis_id — NOT NULL
  • item_type — VARCHAR(30) — NOT NULL
  • score — DECIMAL(5,2)
  • created_at — DATETIME — NOT NULL

festival_analysis_poi

  • festival_analysis_poi_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • content_id — VARCHAR(100)
  • poi_name — VARCHAR(200) — NOT NULL
  • poi_type — VARCHAR(30) — NOT NULL
  • distance_m — INT
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • linkage_type — VARCHAR(30)
  • created_at — DATETIME — NOT NULL

festival_analysis_recommendation

  • recommendation_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_id — BIGINT — Foreign key → festival_analysis.festival_analysis_id — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id
  • recommendation_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • priority — VARCHAR(20) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_analysis_similar

  • festival_analysis_similar_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • festival_id — BIGINT — Foreign key → festival.festival_id
  • festival_history_id — BIGINT — Foreign key → festival_history.festival_history_id
  • festival_name — VARCHAR(200) — NOT NULL
  • year — INT
  • visitor_count — BIGINT
  • budget — DECIMAL(15,2)
  • similarity_score — DECIMAL(5,2) — NOT NULL
  • theme_similarity — DECIMAL(5,2)
  • region_similarity — DECIMAL(5,2)
  • period_similarity — DECIMAL(5,2)
  • rank_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_analysis_trend_keyword

  • trend_keyword_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • period_type — VARCHAR(20) — NOT NULL
  • period_year — INT — NOT NULL
  • period_month — INT
  • interest_value — DECIMAL(10,2) — NOT NULL
  • created_at — DATETIME — NOT NULL

festival_analysis_weather

  • weather_id — BIGINT — Primary key — NOT NULL
  • festival_analysis_item_id — BIGINT — Foreign key → festival_analysis_item.festival_analysis_item_id — NOT NULL
  • observation_year — INT — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • avg_temp — DECIMAL(5,2)
  • max_temp — DECIMAL(5,2)
  • min_temp — DECIMAL(5,2)
  • rainfall_mm — DECIMAL(8,2)
  • rain_days — INT
  • max_wind_speed — DECIMAL(6,2)
  • heatwave_days — INT
  • coldwave_days — INT
  • created_at — DATETIME — NOT NULL

festival_history

  • festival_history_id — BIGINT — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festival.festival_id — NOT NULL
  • year — INT — NOT NULL
  • festival_name_raw — VARCHAR(200) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • budget — DECIMAL(15,2)
  • visitor_count — BIGINT
  • venue_raw — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

festival_plan

  • festival_plan_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • plan_name — VARCHAR(200)
  • festival_name — VARCHAR(200) — NOT NULL
  • sido — VARCHAR(50) — NOT NULL
  • sigungu — VARCHAR(50)
  • venue_name — VARCHAR(200)
  • start_date — DATE
  • end_date — DATE
  • duration_days — INT
  • budget — DECIMAL(15,2)
  • target_visitor_count — BIGINT
  • venue_type — VARCHAR(20)
  • operation_start_time — TIME
  • operation_end_time — TIME
  • capacity — INT
  • rain_plan_available — BOOLEAN
  • original_file_name — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

festival_plan_program

  • festival_plan_program_id — BIGINT — Primary key — NOT NULL
  • festival_plan_id — BIGINT — Foreign key → festival_plan.festival_plan_id — NOT NULL
  • program_name — VARCHAR(200) — NOT NULL
  • program_type — VARCHAR(50)
  • space_type — VARCHAR(20)
  • description — TEXT
  • created_at — DATETIME — NOT NULL

festival_plan_theme

  • festival_plan_theme_id — BIGINT — Primary key — NOT NULL
  • festival_plan_id — BIGINT — Foreign key → festival_plan.festival_plan_id — NOT NULL
  • theme_code — VARCHAR(20)
  • theme_tag — VARCHAR(100) — NOT NULL
  • confidence — DECIMAL(5,4)
  • created_at — DATETIME — NOT NULL

festival_theme

  • festival_theme_id — BIGINT — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festival.festival_id — NOT NULL
  • theme_code — VARCHAR(20) — NOT NULL
  • theme_tag — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL