Number of items completed.
Tracks how many items have been successfully processed so far in the current operation. This value increments as each item is completed, providing real-time progress indication.
The ratio of completed to total gives the completion percentage:
progress = (completed / total) * 100
Modified table model based on review feedback, or null if no changes needed.
Contains the corrected table definition if the review identified issues requiring modification. If the table passes all validation checks, this field is null. When present, this model represents a complete table definition with all fields, relationships, indexes, and documentation that will replace the original model in the final schema.
Model Requirements (when not null):
Notes:
Timestamp when the event was created.
ISO 8601 formatted date-time string indicating when this event was emitted by the system. This timestamp is crucial for event ordering, performance analysis, and debugging the agent workflow execution timeline.
Format: "YYYY-MM-DDTHH:mm:ss.sssZ" (e.g., "2024-01-15T14:30:45.123Z")
A unique identifier for the event.
Function calling trial statistics for the operation.
Records the complete trial history of function calling attempts, tracking total executions, successful completions, consent requests, validation failures, and invalid JSON responses. These metrics reveal the reliability and quality of AI agent autonomous operation with tool usage.
Trial statistics are critical for identifying operations where agents struggle with tool interfaces, generate invalid outputs, or require multiple correction attempts through self-healing spiral loops. High failure rates indicate opportunities for system prompt optimization or tool interface improvements.
Name of the specific table model being reviewed.
Identifies the exact table that was reviewed within the namespace, enabling precise tracking of which tables have been validated and which modifications (if any) were applied.
Namespace of the business domain containing the reviewed table.
Identifies which business domain (schema file) this reviewed table belongs to, enabling proper organization and aggregation of review results by domain.
Strategic database design plan that guided the table creation.
Contains the original planning document that outlines the database architecture strategy for this specific table, including structure, relationships, normalization approach, and business requirement mapping. This plan serves as the blueprint for validating the implemented table model.
Planning Components:
Example:
"Database Design Strategy for 'shopping_orders':
Business Requirements:
- Track customer purchase orders with complete order information
- Support order status workflow and payment tracking
- Enable historical order analysis and reporting
Design Approach:
- Normalize order data to 3NF for data integrity
- Implement temporal fields for audit trail
- Create composite indexes for customer and date queries
- Foreign keys to shopping_customers and shopping_payments"
Comprehensive review analysis of the single table model.
Contains the AI agent's detailed evaluation of the table design, including validation of normalization compliance, relationship integrity, index optimization, and business requirement alignment. The review identifies potential issues and confirms adherence to best practices for this specific table.
Review Dimensions:
Example:
"After reviewing the table 'shopping_orders':
1. Table properly implements UUID primary key
2. Foreign key relationships correctly reference existing models
3. Composite indexes optimize for common query patterns
4. Temporal fields (created_at, updated_at, deleted_at) are present
The table follows all best practices and is ready for implementation."
Iteration number of the requirements analysis this review was performed for.
Indicates which version of the requirements analysis this schema review reflects. This step number ensures that the database review and modifications are aligned with the current requirements and helps track the evolution of database architecture as business requirements change.
The step value enables proper synchronization between database review activities and the underlying requirements, ensuring that the schema structure remains relevant to the current project scope and business objectives.
Detailed token usage metrics for the operation.
Contains comprehensive token consumption data including total usage, input token breakdown with cache hit rates, and output token categorization by generation type (reasoning, predictions). This component-level tracking enables precise cost analysis and identification of operations that benefit most from prompt caching or require optimization.
Token usage directly translates to operational costs, making this metric essential for understanding the financial implications of different operation types and guiding resource allocation decisions.
Total number of items to process.
Represents the complete count of operations, files, endpoints, or other entities that need to be processed in the current workflow step. This value is typically determined at the beginning of an operation and remains constant throughout the process.
Used together with the completed field to calculate progress percentage
and estimate time to completion.
Unique identifier for the event type.
A literal string that discriminates between different event types in the AutoBE system. This field enables TypeScript's discriminated union feature, allowing type-safe event handling through switch statements or conditional checks.
Examples: "analyzeWrite", "databaseSchema", "interfaceOperation", "testScenario"
Event fired when the Database agent reviews and validates a single table model during the database schema design process.
This event occurs when the Database agent has completed a comprehensive review of a single database table model, validating it against best practices, business requirements, and technical constraints. The review process ensures that the table maintains data integrity, follows normalization principles, and optimizes for performance while aligning with business logic.
The review includes validation of normalization compliance, relationship integrity, indexing strategies, naming conventions, and temporal field handling. Based on the review findings, the agent provides a corrected model (content) if modifications are needed, or null if the table passes all validation checks.
Author
Samchon