AI_norron
Tables (6)
cleaned_dataset_value
- id — BIGINT
- dataset_code — VARCHAR(50) — NOT NULL
- region_code — VARCHAR(10) — NOT NULL
- metric_key — VARCHAR(50) — NOT NULL
- metric_value — DECIMAL(14,4) — NOT NULL
- aggregation_method — VARCHAR(30)
- normalization_method — VARCHAR(30)
- data_version — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_cleaned_region
- INDEX — idx_cleaned_dataset
dataset_catalog
- dataset_code — VARCHAR(50) — Primary key
- dataset_name — VARCHAR(150) — NOT NULL
- category_key — VARCHAR(30) — NOT NULL
- source_org — VARCHAR(100)
- source_type — VARCHAR(30)
- origin_unit — VARCHAR(30)
- refresh_cycle — VARCHAR(50)
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
raw_dataset_value
- id — BIGINT
- dataset_code — VARCHAR(50) — NOT NULL
- source_region_code — VARCHAR(30)
- source_region_name — VARCHAR(100)
- region_code — VARCHAR(10)
- metric_key — VARCHAR(50) — NOT NULL
- metric_value — DECIMAL(14,4)
- extra_payload — JSON
- collected_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_raw_dataset
- INDEX — idx_raw_region
- INDEX — idx_raw_metric
- INDEX — idx_raw_collected
region
- region_code — VARCHAR(10) — Primary key
- 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_feature
- id — BIGINT
- region_code — VARCHAR(10) — NOT NULL
- housing_score — DECIMAL(5,2) — NOT NULL
- noise_score — DECIMAL(5,2) — NOT NULL
- safety_score — DECIMAL(5,2) — NOT NULL
- convenience_score — DECIMAL(5,2) — NOT NULL
- traffic_score — DECIMAL(5,2) — NOT NULL
- population_score — DECIMAL(5,2) — NOT NULL
- base_score — DECIMAL(5,2) — NOT NULL
- feature_version — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_feature_region
- INDEX — idx_feature_version
region_similarity
- id — BIGINT — Primary key
- region_code — VARCHAR(10) — NOT NULL
- similar_region_code — VARCHAR(10) — NOT NULL
- rank_order — TINYINT — NOT NULL
- similarity_score — DECIMAL(5,2) — NOT NULL
- feature_version — VARCHAR(30) — NOT NULL
- model_version — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_similarity_region
- region_code (region_code2) — VARCHAR(10) — Foreign key → region.region_code