When true, query results will be cached in memory with TTL expiration
Maximum number of cached result sets for this query. NULL uses default size limit.
Time-to-live in minutes for cached query results. NULL uses default TTL.
SQL query that returns cache validation fingerprint data (MaxUpdatedAt, RowCount). Used for smart cache refresh to determine if cached data is stale.
Category name from the related Query Categories entity
Foreign key reference to the Query Categories entity
Full hierarchical path of the category (e.g., "/MJ/AI/Agents/")
Detailed description of what the query does and what data it returns
Optional EmbeddingThe AI Model ID used to generate the embedding vector
Optional EmbeddingThe AI Model name used to generate the embedding vector
Optional EmbeddingOptional JSON-serialized embedding vector for similarity search
Optional EntitiesEntities referenced by this query
Field metadata for this query
Unique identifier for the query record
Name of the query for display and reference
Parameter definitions for this parameterized query
Value indicating the quality of the query, higher values mean better quality
The actual SQL query text to execute, may include Nunjucks template parameters
Current status of the query in the approval workflow
Base interface for query information shared between MJCore and external systems. Contains the core metadata needed to understand and execute stored queries.