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