ktng-v2

Tables (8)

checklist_items

  • checklist_id — SERIAL
  • batch_id — INTEGER — NOT NULL
  • country_id — INTEGER — NOT NULL
  • checklist_data — JSONB — NOT NULL
  • created_at — TIMESTAMP
  • is_latest — BOOLEAN — 최신

countries

  • 국가ID (country_id) — SERIAL
  • 국가명 (country_name) — VARCHAR(100) — NOT NULL
  • 국가코드 (country_code) — VARCHAR(10)
  • 지역 (region) — VARCHAR(50)
  • 별칭 (aliases) — JSONB — 국가명
  • 생성일시 (created_at) — TIMESTAMP
  • 수정일시 (updated_at) — TIMESTAMP

regulation_batches

  • batch_id — SERIAL
  • country_id — INTEGER — NOT NULL
  • batch_name — VARCHAR(100)
  • batch_type — batch_type_enum — NOT NULL
  • source_files — JSONB — 이
  • items_created — INTEGER
  • items_updated — INTEGER
  • items_unchanged — INTEGER
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • note — TEXT

regulation_categories

  • category_id — SERIAL
  • category_name — VARCHAR(100) — NOT NULL
  • display_order — INTEGER — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

regulation_templates

  • template_id — VARCHAR(50)
  • country_id — INTEGER — NOT NULL
  • category_id — INTEGER — NOT NULL
  • sub_category — VARCHAR(100) — NOT NULL
  • detail_type — VARCHAR(50)
  • display_order — INTEGER — NOT NULL — 화면
  • is_required — BOOLEAN — 필수
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

regulations_current

  • regulation_id — SERIAL
  • template_id — VARCHAR(50) — NOT NULL
  • country_id — INTEGER — NOT NULL
  • category_id — INTEGER — NOT NULL
  • sub_category — VARCHAR(100) — NOT NULL
  • detail_type — VARCHAR(50)
  • content — TEXT — 규제
  • detail_content — TEXT — 규제
  • source — JSONB — 출처
  • version — INTEGER — 현재
  • effective_date — DATE — 이
  • needs_review — BOOLEAN — 사용자
  • last_batch_id — INTEGER
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • created_at — TIMESTAMP

regulations_history

  • history_id — SERIAL
  • regulation_id — INTEGER — NOT NULL
  • batch_id — INTEGER
  • template_id — VARCHAR(50) — NOT NULL
  • category_id — INTEGER — NOT NULL
  • sub_category — VARCHAR(100) — NOT NULL
  • detail_type — VARCHAR(50)
  • content — TEXT
  • detail_content — TEXT
  • source — JSONB
  • version — INTEGER — NOT NULL
  • effective_date — DATE
  • end_date — DATE
  • change_type — change_type_enum — NOT NULL — 변경
  • update_reason — update_reason_enum — AUTO_DATE:
  • changed_fields — JSONB — 변경된
  • changed_at — TIMESTAMP
  • changed_by — VARCHAR(100)

source_documents

  • document_id — SERIAL
  • country_id — INTEGER
  • document_type — VARCHAR(50) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • regulation_reference_date — DATE
  • uploaded_at — TIMESTAMP
  • uploaded_by — VARCHAR(100)