document_rag

Tables (3)

doc_metadata

  • id — INTEGER — Primary key — NOT NULL
  • doc_id — VARCHAR — Foreign key → documents.id — NOT NULL
  • current_version — FLOAT
  • owner_id — VARCHAR — NOT NULL
  • last_editor_id — VARCHAR
  • role — VARCHAR
  • description — VARCHAR
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • file_type — VARCHAR — NOT NULL
  • tags — VARCHAR

doc_versions

  • id — INTEGER — Primary key — NOT NULL
  • doc_id — VARCHAR — Foreign key → documents.id — NOT NULL
  • version — FLOAT — NOT NULL
  • editor_id — VARCHAR — NOT NULL
  • change_type — change_type_enum — NOT NULL
  • summary — TEXT
  • created_at — TIMESTAMP

documents

  • id — VARCHAR — Primary key — NOT NULL
  • filename — VARCHAR — NOT NULL