nomalization
Tables (6)
ai_feedback_raw
- feedback_id — BIGINT
- ts — TIMESTAMP
- user_id — TEXT
- user_name — TEXT
- user_email — TEXT
- session_id — TEXT
- model_name — TEXT
- model_version — TEXT
- prompt_text — TEXT
- response_text — TEXT
- rating — SMALLINT
- comment — TEXT — EX
- tokens_in — INT
- tokens_out — INT
- latency_ms — INT
- source_doc_id — TEXT
- source_doc_title — TEXT
- tags_csv — TEXT
documents
- doc_id — TEXT
- title — TEXT
interactions
- feedback_id — BIGINT
- prompt_id — BIGINT — NOT NULL
- model_id — INT — NOT NULL
- response_text — TEXT — NOT NULL
- rating — SMALLINT
- comment — TEXT — EX
- tokens_in — INT
- tokens_out — INT
- latency_ms — INT
- doc_id — TEXT
- created_at — TIMESTAMP
- tags — TEXT
models
- model_id — SERIAL
- model_name — TEXT — NOT NULL
- model_version — TEXT
prompts
- prompt_id — BIGSERIAL
- src_feedback_id — BIGINT
- user_id — TEXT
- session_id — TEXT
- prompt_text — TEXT — NOT NULL
- created_at — TIMESTAMP
users
- user_id — TEXT
- user_name — TEXT
- user_email — TEXT