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