BE_noroon
Tables (7)
comparison_item
- id — BIGINT
- request_id — BINARY(16) — Foreign key → comparison_request.request_id — NOT NULL
- region_code — VARCHAR(10) — Foreign key → region.region_code — NOT NULL
- order_index — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_request_id
- INDEX — idx_region_code
comparison_request
- id — BIGINT
- request_id — BINARY(16) — NOT NULL
- base_region_code — VARCHAR(10) — Foreign key → region.region_code
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_created_at
recommendation_request_log
- id — BIGINT
- request_id — BINARY(16) — NOT NULL
- base_region_code — VARCHAR(10) — Foreign key → region.region_code
- housing_weight — DECIMAL(5,2)
- noise_weight — DECIMAL(5,2)
- safety_weight — DECIMAL(5,2)
- convenience_weight — DECIMAL(5,2)
- traffic_weight — DECIMAL(5,2)
- population_weight — DECIMAL(5,2)
- response_time_ms — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_base_region
- INDEX — idx_created_at
recommendation_result_cache
- id — BIGINT
- request_id — BINARY(16) — Foreign key → recommendation_request_log.request_id — NOT NULL
- region_code — VARCHAR(10) — Foreign key → region.region_code — NOT NULL
- rank_order — INT — NOT NULL
- weighted_score — DECIMAL(5,2) — NOT NULL
- reason_text — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_request_id
- INDEX — idx_region_code
region
- region_code — VARCHAR(10)
- region_name — VARCHAR(100) — NOT NULL
- sigungu_code — VARCHAR(10) — NOT NULL
- sigungu_name — VARCHAR(100)
- sido_code — VARCHAR(10)
- sido_name — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
region_mapping
- id — BIGINT
- region_code — VARCHAR(10) — Foreign key → region.region_code — NOT NULL
- admin_code — VARCHAR(10) — NOT NULL
- admin_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_admin_code
region_summary
- region_code — VARCHAR(10) — Foreign key → region.region_code
- summary_text — TEXT
- short_summary — VARCHAR(255)
- avg_housing_score — DECIMAL(5,2)
- avg_safety_score — DECIMAL(5,2)
- avg_traffic_score — DECIMAL(5,2)
- top_feature_1 — VARCHAR(50)
- top_feature_2 — VARCHAR(50)
- updated_at — DATETIME
- created_at — DATETIME