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