using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

[Table("SensorReadings", Schema = "dbo")]
public class SensorReading
{
    [Column("ts")]
    public DateTimeOffset Ts { get; set; }

    [Column("location")]
    [MaxLength(64)]
    public string Location { get; set; } = null!;

    [Column("temperature_c")]
    public double? TemperatureC { get; set; }

    [Column("humidity_rh")]
    public double? HumidityRh { get; set; }

    [Column("ambient_light")]
    public double? AmbientLight { get; set; }

    [Column("pressure_hpa")]
    public double? PressureHpa { get; set; }

    [Column("noise_db")]
    public double? NoiseDb { get; set; }

    [Column("etvoc_ppb")]
    public double? EtvocPpb { get; set; }

    [Column("eco2_ppm")]
    public double? Eco2Ppm { get; set; }

    [Column("discomfort_index")]
    public double? DiscomfortIndex { get; set; }

    [Column("heatstroke_index")]
    public double? HeatstrokeIndex { get; set; }

    [Column("vibration_info")]
    public byte? VibrationInfo { get; set; }

    [Column("si_value")]
    public double? SiValue { get; set; }

    [Column("pga_gal")]
    public double? PgaGal { get; set; }

    [Column("seismic_intensity")]
    public double? SeismicIntensity { get; set; }

    [Column("temperature_flag")]
    public byte? TemperatureFlag { get; set; }

    [Column("humidity_flag")]
    public byte? HumidityFlag { get; set; }

    [Column("ambient_light_flag")]
    public byte? AmbientLightFlag { get; set; }

    [Column("pressure_flag")]
    public byte? PressureFlag { get; set; }

    [Column("noise_flag")]
    public byte? NoiseFlag { get; set; }

    [Column("etvoc_flag")]
    public byte? EtvocFlag { get; set; }

    [Column("eco2_flag")]
    public byte? Eco2Flag { get; set; }

    [Column("discomfort_flag")]
    public byte? DiscomfortFlag { get; set; }

    [Column("heatstroke_flag")]
    public byte? HeatstrokeFlag { get; set; }

    [Column("si_flag")]
    public byte? SiFlag { get; set; }

    [Column("pga_flag")]
    public byte? PgaFlag { get; set; }

    [Column("seismic_intensity_flag")]
    public byte? SeismicIntensityFlag { get; set; }
}