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