ai_rag
Tables (8)
chat_messages
- message_id — BIGSERIAL — Primary key — NOT NULL
- session_id (session_id2) — UUID — Foreign key → chat_sessions.session_id — NOT NULL
- user (username) — TEXT — Foreign key → chat_sessions.user — NOT NULL
- session_id — UUID — NOT NULL
- role — TEXT — NOT NULL
- content — TEXT — NOT NULL
- sent_at — TIMESTAMPTZ — NOT NULL
chat_sessions
- session_id — UUID — Primary key — NOT NULL
- user (username) — TEXT — Foreign key → users.user — NOT NULL
- user_id — UUID — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ
chunks
- chunk_id — BIGSERIAL — Primary key — NOT NULL
- dataset — TEXT — NOT NULL
- version — TEXT — NOT NULL
- file_name — TEXT
- chunk_index — INT
- content — TEXT
- embedding — VECTOR
- created_at — TIMESTAMPTZ — NOT NULL
datasets
- dataset — TEXT — Primary key — NOT NULL
- version — TEXT — Primary key — NOT NULL
- chunk_id — BIGSERIAL — Foreign key → chunks.chunk_id — NOT NULL
- file_name — TEXT
- status — TEXT
- last_updated — TIMESTAMPTZ
metadata
- dataset — TEXT — Primary key — NOT NULL
- version — TEXT — Primary key — NOT NULL
- file_name — TEXT — Primary key — NOT NULL
- column_name — TEXT — Primary key — NOT NULL
- chunk_id — BIGSERIAL — Foreign key → chunks.chunk_id — NOT NULL
- data_type — TEXT
- description — TEXT
- meta_tag — TEXT
- updated_at — TIMESTAMPTZ
refresh_tokens
- token_id — UUID — Primary key — NOT NULL
- user (username) — TEXT — Foreign key → users.user — NOT NULL
- user_id — UUID — NOT NULL
- issued_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- revoked — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
token_blacklist
- jti — TEXT — Primary key — NOT NULL
- blacklisted_at — TIMESTAMPTZ — NOT NULL
- reason — TEXT
users
- user (username) — TEXT — Primary key — NOT NULL
- password_hash — TEXT — NOT NULL
- role — TEXT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- last_login_at — TIMESTAMPTZ