LLM BACK
Tables (6)
attachments
- attachment_id — UUID — Primary key — NOT NULL
- message_id — UUID — Foreign key → messages.message_id — NOT NULL
- name — VARCHAR(500) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- size — INTEGER — NOT NULL
- data — BYTEA — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
documents
- document_id — UUID — Primary key — NOT NULL
- name — VARCHAR(500) — NOT NULL
- user_id — UUID — Foreign key → users.user_id
- domain — VARCHAR(50) — NOT NULL
- department — VARCHAR(100)
- visibility — visibilityenum — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- size — INTEGER — NOT NULL
- data — BYTEA — NOT NULL
- status — VARCHAR(20) — NOT NULL
- job_id — VARCHAR(64)
- chunks_indexed — INTEGER
- error — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
messages
- message_id — UUID — Primary key — NOT NULL
- session_id — UUID — Foreign key → sessions.session_id — NOT NULL
- role — roleenum — NOT NULL
- domain — VARCHAR(50)
- content — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
sessions
- session_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- is_favorite — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
sources
- source_id — UUID — Primary key — NOT NULL
- message_id — UUID — Foreign key → messages.message_id — NOT NULL
- name — VARCHAR(500) — NOT NULL
- page — VARCHAR(50)
- created_at — TIMESTAMPTZ — NOT NULL
users
- user_id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — userrole — NOT NULL
- status — approvalstatus — NOT NULL
- refresh_token — VARCHAR(512)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL