asas
Tables (8)
chat_messages
- id — UUID — Primary key — NOT NULL
- session_id — UUID — Foreign key → 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 — Primary key — 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
policy_chunks
- id — UUID — Primary key — 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
prep_vectors
- id — UUID — Primary key — 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 — Primary key — NOT NULL
- policy_id — UUID — 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 — Primary key — NOT NULL
- user_id — INTEGER
- policy_id — UUID
- 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 — Primary key — NOT NULL
- session_id — UUID — Foreign key → 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 — Primary key — NOT NULL
- policy_id — UUID — 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