리콜

테이블 (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