using System;
using System.Linq;
using Newtonsoft.Json;
using Sony.Filtr.Contracts.Abstractions;

namespace Sony.Filtr.AppleMusic.Data.Streams
{
    [PetaPoco.TableName("tblAppleMusicSongStreamDemographics")]
    public class AppleMusicTrackDemographic : IAggregatedStreamFormat
    {
        [PetaPoco.Column("DistributerId")]
        public int DistributerId { get; set; }

        [PetaPoco.Column("Date")]
        [JsonProperty(PropertyName = "date")]
        public DateTime Date { get; set; }

        [PetaPoco.Column("CountryCode")]
        [JsonProperty(PropertyName = "country_code")]
        public string CountryCode { get; set; }

        [PetaPoco.Column("ReportVendorId")]
        [JsonProperty(PropertyName = "report_vendor_id")]
        public int ReportVendorId { get; set; }

        [PetaPoco.Column("Isrc")]
        [JsonProperty(PropertyName = "isrc")]
        public string ISRC { get; set; }

        [PetaPoco.Column("ReportDate")]
        [JsonProperty(PropertyName = "report_date")]
        public DateTime ReportDate { get; set; }


        [PetaPoco.Column("StreamsGenderFemaleAge0_17")]
        [JsonProperty(PropertyName = "streams_gender_female_age_0_17")]
        public int StreamsGenderFemaleAge0_17 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge0_17")]
        [JsonProperty(PropertyName = "streams_gender_male_age_0_17")]
        public int StreamsGenderMaleAge0_17 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge0_17")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_0_17")]
        public int StreamsGenderUnknownAge0_17 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge18_24")]
        [JsonProperty(PropertyName = "streams_gender_female_age_18_24")]
        public int StreamsGenderFemaleAge18_24 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge18_24")]
        [JsonProperty(PropertyName = "streams_gender_male_age_18_24")]
        public int StreamsGenderMaleAge18_24 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge18_24")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_18_24")]
        public int StreamsGenderUnknownAge18_24 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge25_34")]
        [JsonProperty(PropertyName = "streams_gender_female_age_25_34")]
        public int StreamsGenderFemaleAge25_34 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge25_34")]
        [JsonProperty(PropertyName = "streams_gender_male_age_25_34")]
        public int StreamsGenderMaleAge25_34 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge_25_34")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_25_34")]
        public int StreamsGenderUnknownAge_25_34 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge35_44")]
        [JsonProperty(PropertyName = "streams_gender_female_age_35_44")]
        public int StreamsGenderFemaleAge35_44 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge35_44")]
        [JsonProperty(PropertyName = "streams_gender_male_age_35_44")]
        public int StreamsGenderMaleAge35_44 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge35_44")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_35_44")]
        public int StreamsGenderUnknownAge35_44 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge45_54")]
        [JsonProperty(PropertyName = "streams_gender_female_age_45_54")]
        public int StreamsGenderFemaleAge45_54 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge45_54")]
        [JsonProperty(PropertyName = "streams_gender_male_age_45_54")]
        public int StreamsGenderMaleAge45_54 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge45_54")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_45_54")]
        public int StreamsGenderUnknownAge45_54 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge55_64")]
        [JsonProperty(PropertyName = "streams_gender_female_age_55_64")]
        public int StreamsGenderFemaleAge55_64 { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge55_64")]
        [JsonProperty(PropertyName = "streams_gender_male_age_55_64")]
        public int StreamsGenderMaleAge55_64 { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge55_64")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_55_64")]
        public int StreamsGenderUnknownAge55_64 { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAge60_plus")]
        [JsonProperty(PropertyName = "streams_gender_female_age_60_plus")]
        public int StreamsGenderFemaleAge60_plus { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAge60_plus")]
        [JsonProperty(PropertyName = "streams_gender_male_age_60_plus")]
        public int StreamsGenderMaleAge60_plus { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAge60_plus")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_60_plus")]
        public int StreamsGenderUnknownAge60_plus { get; set; }

        [PetaPoco.Column("StreamsGenderFemaleAgeUnknown")]
        [JsonProperty(PropertyName = "streams_gender_female_age_unknown")]
        public int StreamsGenderFemaleAgeUnknown { get; set; }

        [PetaPoco.Column("StreamsGenderMaleAgeUnknown")]
        [JsonProperty(PropertyName = "streams_gender_male_age_unknown")]
        public int StreamsGenderMaleAgeUnknown { get; set; }

        [PetaPoco.Column("StreamsGenderUnknownAgeUnknown")]
        [JsonProperty(PropertyName = "streams_gender_unknown_age_unknown")]
        public int StreamsGenderUnknownAgeUnknown { get; set; }
    }
}