Milestone 2 — Import REF CSV data into PostgreSQL

[sonht]

Milestone 2 scope:

Import all 14 data/csv_reference/REF_*.csv files into PostgreSQL.

Requirements:

• Create one staging table per CSV file.
• Store all CSV columns as TEXT.
• Preserve PL1, PL3, CPT, ICD-9-CM, price codes, STT, IDs, order fields as TEXT.
• Do not infer numbers or dates.
• Create import_audit.
• Implement:
  • POST /admin/import-csv
  • GET /admin/import-status
• Add frontend buttons:
  • Import CSV into PostgreSQL
  • Check import status
• Add pytest tests for text-safe import.

Acceptance:

• All 14 files import successfully.
• Row counts match /admin/healthcheck.
• import_audit reports success.
• "7.10", "03.01", "00123" remain unchanged as text.
• No matching engine.
• No AI API.

[sonht]

Milestone 2 hoàn thành:

• 14/14 file REF CSV import thành công vào PostgreSQL staging tables.
• Row counts khớp với /admin/healthcheck.
• import_audit báo success.
• Mã giữ dạng text: pl1_code 1.110 và 1.12 vẫn là 2 mã riêng, price_code 01.0101 giữ số 0 đầu.
• Không có matching engine, không có AI API.