소복소복_ERD
테이블 (11)
attachment_files
- id — UUID — 기본 키 — NOT NULL
- file_hash — TEXT — NOT NULL
- storage_path — TEXT — NOT NULL
- original_file_name — TEXT
- content_type — VARCHAR(100)
- file_size — BIGINT
- extracted_text — TEXT
- extraction_status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
gov24_service_details
- id — BIGSERIAL — 기본 키 — NOT NULL
- service_id — VARCHAR(100) — 외래 키 → gov24_service_lists.service_id — NOT NULL
- service_name — TEXT — NOT NULL
- institution — TEXT
- support_target — TEXT
- support_content — TEXT
- application_method — TEXT
- required_documents — TEXT
- selection_criteria — TEXT
- contact — TEXT
- raw_json — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
gov24_service_lists
- id — BIGSERIAL — 기본 키 — NOT NULL
- service_id — VARCHAR(100) — NOT NULL
- service_name — TEXT — NOT NULL
- institution — TEXT
- service_field — VARCHAR(100)
- support_target — TEXT
- support_content — TEXT
- application_deadline — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
gov24_support_conditions
- id — BIGSERIAL — 기본 키 — NOT NULL
- service_id — VARCHAR(100) — 외래 키 → gov24_service_lists.service_id — NOT NULL
- ja1101_pre_founder — BOOLEAN — NOT NULL
- ja1102_operating_business — BOOLEAN — NOT NULL
- ja1103_closing_business — BOOLEAN — NOT NULL
- ja1201_restaurant_business — BOOLEAN — NOT NULL
- ja1202_manufacturing_business — BOOLEAN — NOT NULL
- ja1299_other_business — BOOLEAN — NOT NULL
- raw_json — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
normalized_policies
- id — UUID — 기본 키 — NOT NULL
- source — VARCHAR(30) — NOT NULL
- source_pk — VARCHAR(200) — NOT NULL
- canonical_key — TEXT — NOT NULL
- duplicate_group_key — TEXT — NOT NULL
- title — TEXT — NOT NULL
- summary — TEXT
- body — TEXT
- organization — TEXT
- support_type — VARCHAR(100)
- target_text — TEXT
- support_content — TEXT
- region_scope — VARCHAR(20) — NOT NULL
- sido — VARCHAR(50)
- sigungu — VARCHAR(50)
- status — VARCHAR(30)
- apply_start — TIMESTAMP
- apply_end — TIMESTAMP
- apply_url — TEXT
- industry_tags — JSON — NOT NULL
- business_status_tags — JSON — NOT NULL
- eligibility — JSON — NOT NULL
- required_documents — JSON — NOT NULL
- source_content_hash — TEXT
- normalized_hash — TEXT
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
policy_announcements
- id — BIGSERIAL — 기본 키 — NOT NULL
- pbanc_sn — VARCHAR(100) — NOT NULL
- title — TEXT — NOT NULL
- organization — TEXT
- summary — TEXT
- body — TEXT
- target_text — TEXT
- category — VARCHAR(100)
- status — VARCHAR(50)
- apply_start — TIMESTAMP
- apply_end — TIMESTAMP
- apply_url — TEXT
- content_hash — TEXT
- raw_json — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
policy_attachment_links
- id — UUID — 기본 키 — NOT NULL
- policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
- attachment_file_id — UUID — 외래 키 → attachment_files.id — NOT NULL
- source_file_id — TEXT
- original_file_name — TEXT
- display_order — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
policy_attachments
- id — BIGSERIAL — 기본 키 — NOT NULL
- announcement_id — BIGINT — 외래 키 → policy_announcements.id — NOT NULL
- file_id — VARCHAR(100)
- file_name — TEXT
- file_hash — TEXT
- file_path — TEXT
- content_type — VARCHAR(100)
- file_size — BIGINT
- created_at — TIMESTAMP — NOT NULL
policy_chunks
- id — UUID — 기본 키 — NOT NULL
- policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
- document_id — UUID — 외래 키 → policy_documents.id — NOT NULL
- chunk_index — INTEGER — NOT NULL
- chunk_text — TEXT — NOT NULL
- chunk_hash — TEXT — NOT NULL
- metadata — JSON — NOT NULL
- embedding_status — VARCHAR(30) — NOT NULL
- embedding_model — TEXT
- embedding — TEXT
- created_at — TIMESTAMP — NOT NULL
policy_documents
- id — UUID — 기본 키 — NOT NULL
- policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
- document_type — VARCHAR(30) — NOT NULL
- source_ref — TEXT
- title — TEXT
- text — TEXT — NOT NULL
- text_hash — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
policy_program_pages
- id — BIGSERIAL — 기본 키 — NOT NULL
- source_url — TEXT — NOT NULL
- program_name — TEXT — NOT NULL
- organization — TEXT
- summary — TEXT
- body — TEXT
- support_type — VARCHAR(100)
- target_text — TEXT
- content_hash — TEXT
- raw_json — JSON
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL