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