소복소복_ERD

테이블 (21)

attachment_files

  • id — UUID — 기본 키 — NOT NULL
  • file_hash — VARCHAR(255) — 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

chat_messages

  • id — UUID — 기본 키 — NOT NULL
  • session_id — UUID — 외래 키 → chat_sessions.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • policy_id — UUID — 외래 키 → normalized_policies.id
  • response_mode — VARCHAR(30)
  • candidates — JSON
  • sources — JSON
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL

chat_sessions

  • id — UUID — 기본 키 — NOT NULL
  • user_id — INTEGER — 외래 키 → users.id — NOT NULL
  • active_policy_id — UUID — 외래 키 → normalized_policies.id
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

favorites

  • id — INTEGER — 기본 키 — NOT NULL
  • user_id — INTEGER — 외래 키 → users.id — NOT NULL
  • policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL

gov24_service_details

  • service_id — VARCHAR(50) — 기본 키 — NOT NULL
  • required_docs_by_official — TEXT
  • required_docs — TEXT
  • contact — TEXT
  • laws — TEXT
  • identity_required_docs — TEXT
  • service_name — VARCHAR(500) — NOT NULL
  • service_purpose — TEXT
  • selection_criteria — TEXT
  • organization_name — VARCHAR(300)
  • modified_date — VARCHAR(30)
  • application_deadline — TEXT
  • application_method — TEXT
  • online_application_url — VARCHAR(1000)
  • local_laws — TEXT
  • reception_institution_name — TEXT
  • support_content — TEXT
  • support_target — TEXT
  • support_type — VARCHAR(500)
  • administrative_rules — TEXT
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

gov24_service_lists

  • service_id — VARCHAR(50) — 기본 키 — NOT NULL
  • registration_datetime — VARCHAR(30)
  • department_name — VARCHAR(300)
  • user_type — VARCHAR(500)
  • detail_url — VARCHAR(1000)
  • service_name — VARCHAR(500) — NOT NULL
  • service_purpose_summary — TEXT
  • service_field — VARCHAR(200)
  • selection_criteria — TEXT
  • organization_name — VARCHAR(300)
  • organization_type — VARCHAR(100)
  • organization_code — VARCHAR(50)
  • modified_datetime — VARCHAR(30)
  • application_deadline — TEXT
  • application_method — TEXT
  • contact_phone — TEXT
  • reception_institution — TEXT
  • view_count — INTEGER
  • support_content — TEXT
  • support_target — TEXT
  • support_type — VARCHAR(500)
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

gov24_support_conditions

  • service_id — VARCHAR(50) — 기본 키 — NOT NULL
  • service_name — VARCHAR(500) — NOT NULL
  • ja0101_male — VARCHAR(30)
  • ja0102_female — VARCHAR(30)
  • ja0110_age_start — VARCHAR(30)
  • ja0111_age_end — VARCHAR(30)
  • ja0201_income_0_50 — VARCHAR(30)
  • ja0202_income_51_75 — VARCHAR(30)
  • ja0203_income_76_100 — VARCHAR(30)
  • ja0204_income_101_200 — VARCHAR(30)
  • ja0205_income_over_200 — VARCHAR(30)
  • ja0301_pre_parent_infertility — VARCHAR(30)
  • ja0302_pregnant — VARCHAR(30)
  • ja0303_childbirth_adoption — VARCHAR(30)
  • ja0313_farmer — VARCHAR(30)
  • ja0314_fisher — VARCHAR(30)
  • ja0315_livestock_farmer — VARCHAR(30)
  • ja0316_forester — VARCHAR(30)
  • ja0326_worker — VARCHAR(30)
  • ja0327_job_seeker — VARCHAR(30)
  • ja0328_disabled — VARCHAR(30)
  • ja0329_veteran — VARCHAR(30)
  • ja0330_disease_patient — VARCHAR(30)
  • ja0401_multicultural_family — VARCHAR(30)
  • ja0402_north_korean_defector — VARCHAR(30)
  • ja0403_single_parent_grandparent_family — VARCHAR(30)
  • ja0404_single_person_household — VARCHAR(30)
  • ja0411_multi_child_family — VARCHAR(30)
  • ja1101_pre_founder — VARCHAR(30)
  • ja1102_operating_business — VARCHAR(30)
  • ja1103_closing_business — VARCHAR(30)
  • ja1201_restaurant_business — VARCHAR(30)
  • ja1202_manufacturing_business — VARCHAR(30)
  • ja1299_other_business — VARCHAR(30)
  • ja2101_small_medium_business — VARCHAR(30)
  • ja2102_social_welfare_facility — VARCHAR(30)
  • ja2103_institution_group — VARCHAR(30)
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — 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)
  • matched_sidos — JSON — NOT NULL
  • region_confidence — FLOAT
  • status — VARCHAR(30)
  • apply_start — TIMESTAMP
  • apply_end — TIMESTAMP
  • apply_url — TEXT
  • application_methods — JSON — NOT NULL
  • contact_points — JSON — NOT NULL
  • employee_limit_value — INTEGER
  • employee_limit_operator — VARCHAR(10)
  • sales_limit_amount_krw — BIGINT
  • sales_limit_operator — VARCHAR(10)
  • business_age_limit_value — INTEGER
  • business_age_limit_operator — VARCHAR(10)
  • required_document_count — INTEGER — NOT NULL
  • has_required_documents — BOOLEAN — NOT NULL
  • 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

  • pbanc_sn — INTEGER — 기본 키 — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • target — VARCHAR(200)
  • category — VARCHAR(200)
  • organization — VARCHAR(300)
  • apply_start — VARCHAR(50)
  • apply_end — VARCHAR(50)
  • status — VARCHAR(100)
  • detail_url — VARCHAR(500) — NOT NULL
  • content_html — TEXT
  • content_text — TEXT
  • raw_list_json — JSON
  • raw_detail_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — 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

  • file_id — VARCHAR(100) — 기본 키 — NOT NULL
  • pbanc_sn — INTEGER — 외래 키 → policy_announcements.pbanc_sn — NOT NULL
  • file_name — VARCHAR(500) — NOT NULL
  • file_size — INTEGER
  • saved_path — VARCHAR(1000)
  • file_hash — VARCHAR(64)
  • raw_file_json — JSON
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • downloaded_at — TIMESTAMP WITH TIME ZONE — 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 — VARCHAR(255) — NOT NULL
  • metadata — JSON — NOT NULL
  • embedding_status — VARCHAR(30) — NOT NULL
  • embedding_model — TEXT
  • embedding_openai — VECTOR
  • embedding_ollama — VECTOR
  • embedding_openai_model — VARCHAR(100)
  • embedding_ollama_model — VARCHAR(100)
  • 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 — INTEGER — 기본 키 — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • source_url — VARCHAR(1000) — NOT NULL
  • category — VARCHAR(300)
  • program_name — VARCHAR(500) — NOT NULL
  • content_html — TEXT
  • content_text — TEXT
  • sections_json — JSON
  • raw_breadcrumbs_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

prep_vectors

  • id — UUID — 기본 키 — NOT NULL
  • document_name — VARCHAR(255) — NOT NULL
  • guide_text — TEXT
  • embedding_openai — VECTOR
  • embedding_ollama — VECTOR
  • embedding_openai_model — VARCHAR(100)
  • embedding_ollama_model — VARCHAR(100)
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

rec_vectors

  • id — UUID — 기본 키 — NOT NULL
  • policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
  • vector_type — VARCHAR(50) — NOT NULL
  • source_text — TEXT — NOT NULL
  • source_hash — VARCHAR(64) — NOT NULL
  • embedding_provider — VARCHAR(30) — NOT NULL
  • embedding_model — VARCHAR(100) — NOT NULL
  • embedding_dim — INTEGER — NOT NULL
  • embedding_status — VARCHAR(30) — NOT NULL
  • embedding_error — TEXT
  • metadata — JSON — NOT NULL
  • embedding_openai — VECTOR
  • embedding_ollama — VECTOR
  • embedding_openai_model — VARCHAR(100)
  • embedding_ollama_model — VARCHAR(100)
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

review_sessions

  • id — UUID — 기본 키 — NOT NULL
  • user_id — INTEGER — 외래 키 → users.id
  • policy_id — UUID — 외래 키 → normalized_policies.id
  • review_status — VARCHAR(20) — NOT NULL
  • model_mode — VARCHAR(10) — NOT NULL
  • requirement_status — VARCHAR(24) — NOT NULL
  • requirement_matches — JSON
  • summary — TEXT
  • error_code — VARCHAR(40)
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

review_uploads

  • id — UUID — 기본 키 — NOT NULL
  • session_id — UUID — 외래 키 → review_sessions.id — NOT NULL
  • original_file_name — TEXT
  • storage_path — TEXT — NOT NULL
  • content_type — VARCHAR(100)
  • file_size — BIGINT
  • extracted_text — TEXT
  • extraction_status — VARCHAR(30) — NOT NULL
  • diagnosis — JSON
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

review_vectors

  • id — UUID — 기본 키 — NOT NULL
  • policy_id — UUID — 외래 키 → normalized_policies.id — NOT NULL
  • document_name — VARCHAR(255) — NOT NULL
  • document_type — VARCHAR(30) — NOT NULL
  • source_text — TEXT
  • embedding_openai — VECTOR
  • embedding_ollama — VECTOR
  • embedding_openai_model — VARCHAR(100)
  • embedding_ollama_model — VARCHAR(100)
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

user_profiles

  • id — INTEGER — 기본 키 — NOT NULL
  • user_id — INTEGER — 외래 키 → users.id — NOT NULL
  • owner_name — VARCHAR(50)
  • store_name — VARCHAR(200)
  • ai_model_mode — VARCHAR(10) — NOT NULL
  • chat_model_mode — VARCHAR(10) — NOT NULL
  • recommend_model_mode — VARCHAR(10) — NOT NULL
  • policy_summary_model_mode — VARCHAR(10) — NOT NULL
  • calendar_coach_model_mode — VARCHAR(10) — NOT NULL
  • document_review_model_mode — VARCHAR(10) — NOT NULL
  • region_sido — VARCHAR(50)
  • region_sigungu — VARCHAR(50)
  • industry_tags — TEXT
  • business_status_tags — TEXT
  • need_tags — TEXT
  • employees_min — INTEGER
  • employees_max — INTEGER
  • annual_sales_min — BIGINT
  • annual_sales_max — BIGINT
  • business_age_min — INTEGER
  • business_age_max — INTEGER
  • industry_label — VARCHAR(50)
  • business_status_label — VARCHAR(50)
  • annual_sales_label — VARCHAR(50)
  • employees_label — VARCHAR(50)
  • business_age_label — VARCHAR(50)
  • onboarded_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL

users

  • id — INTEGER — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • hashed_password — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • google_access_token — VARCHAR(255)
  • google_refresh_token — VARCHAR(255)
  • google_token_expires_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL