리콜
테이블 (4)
faq
- faq_id — VARCHAR(30) — 기본 키 — NOT NULL
- manufacturer — VARCHAR(20) — NOT NULL
- category — VARCHAR(50)
- question — VARCHAR(500) — NOT NULL
- answer — TEXT
- source_url — VARCHAR(500) — NOT NULL
- collected_at — DATE — NOT NULL
model_mapping
- source_type — VARCHAR(3) — 기본 키 — NOT NULL
- alias_name — VARCHAR(100) — 기본 키 — NOT NULL
- model_key — VARCHAR(30) — NOT NULL
- manufacturer_std — VARCHAR(20) — NOT NULL
- model_std — VARCHAR(50) — NOT NULL
- generation_name — VARCHAR(30)
- alias_normalized — VARCHAR(100) — NOT NULL
- match_status — VARCHAR(10) — NOT NULL
- review_note — VARCHAR(500)
new_registration
- registration_year — INT — NOT NULL
- registration_month — INT — NOT NULL
- model_code — VARCHAR(100) — 외래 키 → model_mapping.alias_name — NOT NULL
- model_key — VARCHAR(30) — 외래 키 → model_mapping.model_key — NOT NULL
- region_code — VARCHAR(20)
- region_name — VARCHAR(30)
- fuel_code — VARCHAR(20)
- fuel_name — VARCHAR(30)
- new_registration_count — INT — NOT NULL
- source_url — VARCHAR(500) — NOT NULL
- loaded_at — DATE — NOT NULL
recall
- recall_id — VARCHAR(30) — 기본 키 — NOT NULL
- manufacturer — VARCHAR(50) — NOT NULL
- model_original — VARCHAR(100) — 외래 키 → model_mapping.alias_name — NOT NULL
- model_key — VARCHAR(30) — 외래 키 → model_mapping.model_key — NOT NULL
- production_from — DATE
- production_to — DATE
- recall_start_date — DATE — NOT NULL
- recall_count — INT
- recall_reason — TEXT — NOT NULL
- recall_category — VARCHAR(30) — NOT NULL
- source_url — VARCHAR(500) — NOT NULL
- loaded_at — DATE — NOT NULL