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