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