namespace FLSDAL.DTO.Survey;

// No primary constructor (init-only properties) so this gets an implicit parameterless
// constructor — see SurveyQuestionCoreRow for why nullable value-type columns require this
// for Dapper materialization.
public record SurveySummaryRow
{
    public int       SurveySummaryId    { get; init; }
    public int       InstrumentConfigId { get; init; }
    public int       FlsInstanceId      { get; init; }
    public int       GroupId            { get; init; }
    public int       InstQuestionId     { get; init; }
    public int       QuestionTypeId     { get; init; }
    public int       ResponseCount      { get; init; }
    public int       SkippedCount       { get; init; }
    public decimal?  AvgRating          { get; init; }
    public decimal?  MinRating          { get; init; }
    public decimal?  MaxRating          { get; init; }
    public int?      NpsPromoters       { get; init; }
    public int?      NpsPassives        { get; init; }
    public int?      NpsDetractors      { get; init; }
    public decimal?  NpsScore           { get; init; }
    public string?   OptionDistJson     { get; init; }
    public int?      FreeTextCount      { get; init; }
    public DateTime  LastUpdated        { get; init; }
}