소복소복_ERD

테이블 (10)

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
  • 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 — NOT NULL
  • active_policy_id — UUID
  • 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 — NOT NULL
  • created_at — TIMESTAMP WITH TIME ZONE — 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_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_chunks

  • id — UUID — 기본 키 — NOT NULL
  • policy_id — UUID — NOT NULL
  • document_id — UUID — 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

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