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)