AIPF_20260625

Tables (12)

apikey

  • id — varchar(20) — Primary key — NOT NULL
  • apiKey — text — NOT NULL
  • apiSecret — text — NOT NULL
  • keyName — text — NOT NULL
  • permissions — text — NOT NULL
  • workspaceId — text — NOT NULL
  • updatedDate — timestamp — NOT NULL

chat_flow

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • flowData — text — NOT NULL
  • type — varchar(20) — NOT NULL
  • deployed — boolean
  • isPublic — boolean
  • apikeyid — varchar(20) — Foreign key → apikey.id
  • chatbotConfig — text
  • apiConfig — text
  • analytic — text
  • speechToText — text
  • textToSpeech — text
  • followUpPrompts — text
  • category — text
  • mcpServerConfig — text
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL
  • deletedDate — timestamp

chat_flow_version

  • id — uuid — Primary key — NOT NULL
  • chatflowId — uuid — Foreign key → chat_flow.id — NOT NULL
  • workspaceId — text — NOT NULL
  • versionNumber — integer — NOT NULL
  • flowData — text — NOT NULL
  • name — varchar(255)
  • releaseNotes — text
  • isActive — boolean — NOT NULL
  • createdBy — varchar
  • createdDate — timestamp — NOT NULL
  • deletedDate — timestamp

chat_message

  • id — uuid — Primary key — NOT NULL
  • chatflowid — uuid — Foreign key → chat_flow.id — NOT NULL
  • executionId — uuid — Foreign key → execution.id
  • role — varchar — NOT NULL
  • content — text — NOT NULL
  • chatType — varchar — NOT NULL
  • chatId — varchar — NOT NULL
  • sessionId — varchar
  • memoryType — varchar
  • sourceDocuments — text
  • usedTools — text
  • fileAnnotations — text
  • agentReasoning — text
  • reasonContent — text
  • fileUploads — text
  • artifacts — text
  • action — text
  • leadEmail — text
  • followUpPrompts — text
  • createdDate — timestamp — NOT NULL

credential

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • credentialName — varchar — NOT NULL
  • encryptedData — text — NOT NULL
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL

custom_template

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • flowData — text — NOT NULL
  • description — text
  • badge — text
  • framework — text
  • usecases — text
  • type — text
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL

document_store

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text
  • loaders — text
  • whereUsed — text
  • status — text — NOT NULL
  • vectorStoreConfig — text
  • embeddingConfig — text
  • recordManagerConfig — text
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL

document_store_file_chunk

  • id — uuid — Primary key — NOT NULL
  • storeId — uuid — Foreign key → document_store.id — NOT NULL
  • docId — uuid — NOT NULL
  • chunkNo — integer — NOT NULL
  • pageContent — text — NOT NULL
  • metadata — text
  • chunkType — varchar(10)
  • parentChunkId — uuid — Foreign key → document_store_file_chunk.id

execution

  • id — uuid — Primary key — NOT NULL
  • agentflowId — uuid — Foreign key → chat_flow.id — NOT NULL
  • sessionId — varchar — NOT NULL
  • state — varchar — NOT NULL
  • executionData — text — NOT NULL
  • action — text
  • isPublic — boolean
  • executedVersionId — uuid — Foreign key → chat_flow_version.id
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL
  • stoppedDate — timestamp
  • deletedDate — timestamp

tool

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • description — text — NOT NULL
  • color — varchar — NOT NULL
  • iconSrc — varchar
  • schema — text
  • func — text
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL

upsert_history

  • id — uuid — Primary key — NOT NULL
  • chatflowid — uuid — Foreign key → chat_flow.id — NOT NULL
  • result — varchar — NOT NULL
  • flowData — varchar — NOT NULL
  • date — timestamp — NOT NULL

variable

  • id — uuid — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • value — text
  • type — text — NOT NULL
  • workspaceId — text — NOT NULL
  • createdDate — timestamp — NOT NULL
  • updatedDate — timestamp — NOT NULL