소복소복_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