namespace GB5Shared.GOP.GBQueryExecutor.DTOs
{
    // Maps to MGBCONFIGUREDQUERY (M = Master, app-generated INT PK)
    public class GBConfiguredQueryDTO
    {
        public int     ConfiguredQueryId   { get; set; }
        public int     TenantId            { get; set; }
        public string  QueryCode           { get; set; } = string.Empty;
        public string  QueryName           { get; set; } = string.Empty;
        public string  SqlTemplate         { get; set; } = string.Empty;  // user-authored SQL (validated at save time)
        public string? ParameterJson       { get; set; }                  // JSON array of {name, type, required}
        public string? ResultMappingJson   { get; set; }
        public int     IsValidated         { get; set; }   // 1=Yes/Validated, 0=No/Not validated (flipped from ISVALIDATED column by the QB SELECTs)
        public int     IntentProfileId     { get; set; }
        public string? IntentCode          { get; set; }   // populated by list query (LEFT JOIN to intent profile)
        public int     Status              { get; set; }
    }
}