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