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

namespace Sony.Filtr.SpotifyAnalytics.Data
{
    [PetaPoco.TableName("tblSpotifyTrackStreamDemographics")]
    public class SpotifyTrackDemographics : 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("Isrc")]
        [JsonProperty(PropertyName = "isrc")]
        public string Isrc { get; set; }

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

        [PetaPoco.Column("ReportCountryCode")]
        [JsonProperty(PropertyName = "report_country_code")]
        public string ReportCountryCode { get; set; }
        
        [PetaPoco.Column("GenderFemaleAge_0_17")]
        [JsonProperty(PropertyName = "gender_female_age_0_17")]
        public int GenderFemaleAge0_17 { get; set; }

        [PetaPoco.Column("GenderMaleAge_0_17")]
        [JsonProperty(PropertyName = "gender_male_age_0_17")]
        public int GenderMaleAge0_17 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_0_17")]
        [JsonProperty(PropertyName = "gender_neutral_age_0_17")]
        public int GenderNeutralAge0_17 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_0_17")]
        [JsonProperty(PropertyName = "gender_unknown_age_0_17")]
        public int GenderUnknownAge0_17 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_18_22")]
        [JsonProperty(PropertyName = "gender_female_age_18_22")]
        public int GenderFemaleAge18_22 { get; set; }

        [PetaPoco.Column("GenderMaleAge_18_22")]
        [JsonProperty(PropertyName = "gender_male_age_18_22")]
        public int GenderMaleAge18_22 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_18_22")]
        [JsonProperty(PropertyName = "gender_neutral_age_18_22")]
        public int GenderNeutralAge18_22 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_18_22")]
        [JsonProperty(PropertyName = "gender_unknown_age_18_22")]
        public int GenderUnknownAge18_22 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_23_27")]
        [JsonProperty(PropertyName = "gender_female_age_23_27")]
        public int GenderFemaleAge23_27 { get; set; }

        [PetaPoco.Column("GenderMaleAge_23_27")]
        [JsonProperty(PropertyName = "gender_male_age_23_27")]
        public int GenderMaleAge23_27 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_23_27")]
        [JsonProperty(PropertyName = "gender_neutral_age_23_27")]
        public int GenderNeutralAge23_27 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_23_27")]
        [JsonProperty(PropertyName = "gender_unknown_age_23_27")]
        public int GenderUnknownAge23_27 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_28_34")]
        [JsonProperty(PropertyName = "gender_female_age_28_34")]
        public int GenderFemaleAge28_34 { get; set; }

        [PetaPoco.Column("GenderMaleAge_28_34")]
        [JsonProperty(PropertyName = "gender_male_age_28_34")]
        public int GenderMaleAge28_34 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_28_34")]
        [JsonProperty(PropertyName = "gender_neutral_age_28_34")]
        public int GenderNeutralAge28_34 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_28_34")]
        [JsonProperty(PropertyName = "gender_unknown_age_28_34")]
        public int GenderUnknownAge28_34 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_35_44")]
        [JsonProperty(PropertyName = "gender_female_age_35_44")]
        public int GenderFemaleAge35_44 { get; set; }

        [PetaPoco.Column("GenderMaleAge_35_44")]
        [JsonProperty(PropertyName = "gender_male_age_35_44")]
        public int GenderMaleAge35_44 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_35_44")]
        [JsonProperty(PropertyName = "gender_neutral_age_35_44")]
        public int GenderNeutralAge35_44 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_35_44")]
        [JsonProperty(PropertyName = "gender_unknown_age_35_44")]
        public int GenderUnknownAge35_44 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_45_59")]
        [JsonProperty(PropertyName = "gender_female_age_45_59")]
        public int GenderFemaleAge45_59 { get; set; }

        [PetaPoco.Column("GenderMaleAge_45_59")]
        [JsonProperty(PropertyName = "gender_male_age_45_59")]
        public int GenderMaleAge45_59 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_45_59")]
        [JsonProperty(PropertyName = "gender_neutral_age_45_59")]
        public int GenderNeutralAge45_59 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_45_59")]
        [JsonProperty(PropertyName = "gender_unknown_age_45_59")]
        public int GenderUnknownAge45_59 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_60_150")]
        [JsonProperty(PropertyName = "gender_female_age_60_150")]
        public int GenderFemaleAge60_150 { get; set; }

        [PetaPoco.Column("GenderMaleAge_60_150")]
        [JsonProperty(PropertyName = "gender_male_age_60_150")]
        public int GenderMaleAge60_150 { get; set; }

        [PetaPoco.Column("GenderNeutralAge_60_150")]
        [JsonProperty(PropertyName = "gender_neutral_age_60_150")]
        public int GenderNeutralAge60_150 { get; set; }

        [PetaPoco.Column("GenderUnknownAge_60_150")]
        [JsonProperty(PropertyName = "gender_unknown_age_60_150")]
        public int GenderUnknownAge60_150 { get; set; }

        [PetaPoco.Column("GenderFemaleAge_unknown")]
        [JsonProperty(PropertyName = "gender_female_age_unknown")]
        public int GenderFemaleAgeUnknown { get; set; }

        [PetaPoco.Column("GenderMaleAge_unknown")]
        [JsonProperty(PropertyName = "gender_male_age_unknown")]
        public int GenderMaleAgeUnknown { get; set; }

        [PetaPoco.Column("GenderNeutralAge_unknown")]
        [JsonProperty(PropertyName = "gender_neutral_age_unknown")]
        public int GenderNeutralAgeUnknown { get; set; }

        [PetaPoco.Column("GenderUnknownAge_unknown")]
        [JsonProperty(PropertyName = "gender_unknown_age_unknown")]
        public int GenderUnknownAgeUnknown { get; set; }


    }
}