rag
Tables (7)
answer_chunks
- answer_id — INT — Primary key — NOT NULL
- chunk_id — INT — Primary key — NOT NULL
answers
- answer_id — INT
- query_id — INT — NOT NULL
- answer_text — TEXT — NOT NULL
- generated_at — DATETIME — NOT NULL
document_chunks
- chunk_id — INT
- document_id — INT — NOT NULL
- content — TEXT — NOT NULL
- embedding — TEXT — NOT NULL
- page_range — VARCHAR(50)
- chunk_order — INT
documents
- document_id — INT
- title — VARCHAR(255) — NOT NULL
- source — TEXT
- created_at — DATETIME — NOT NULL
multimodals
- multimodal_id — INT
- query_id — INT — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- uploaded_at — DATETIME — NOT NULL
queries
- query_id — INT
- user_id — INT — NOT NULL
- query_text — TEXT — NOT NULL
- query_embedding — TEXT
- created_at — DATETIME — NOT NULL
users
- user_id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL