AI01
AI Assistant
Ask about your data, your stock and your customers.
Schema v01 has no conversational layer: no chat thread, no chat message, no prompt library and no stored insight. The only model-shaped table is extraction_log (what a model proposed for an RFQ or a certificate field, and whether a person confirmed it), and it holds no rows.
Conversations
—
no chat-thread table in schema v01
Messages
—
no chat-message table
Saved Prompts
—
no prompt table
Insights Kept
—
no insight table; an insight is computed on the read and never stored
Tools Available
—
no tool registry
Chat History
ConversationLast messageMessagesStartedBy
No chat thread or message rows: the assistant on this board would keep a conversation per person, and schema v01 has neither table nor a person to attach one to (app_user holds name, email, role and active).
What the database does hold
chat threadsnot in schema v01
chat messagesnot in schema v01
saved promptsnot in schema v01
extraction_log rows0
Chat
the conversation itself
Nothing to show yet
No thread to draw and nowhere to write a reply.
Recent Chats
Nothing to show yet
No chat-thread table.
Saved Prompts
Nothing to show yet
No prompt table; a prompt cannot be saved.
Suggested Prompts
Show me low stock items, Analyze purchase price trend, Latest market news
Nothing to show yet
The suggestions are text the board invents. Two of them have no answer in schema v01 either: there is no low-stock threshold and no market price series.
Insights
the assistant's findings, kept
Nothing to show yet
No insight table. Every figure the product shows is derived on the read (section 3.3), so there is nothing to keep between sessions.
AI Tools
Summarize Document, Draft Email
Nothing to show yet
No tool registry, and no document store to summarize (certificate_file holds 0 rows).
Data Sources
what the assistant may read
Nothing to show yet
No data-source or connector table; the schema knows one source, the import_run file key.