using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using PetaPoco;

namespace Sony.Filtr.Core.SpotifyCharts.Data
{
    [TableName("tblSpotifyCharts")]
    [ExplicitColumns]
    public class SpotifyChartDataRow
    {
        [Column("Market")]
        public string Market { get; set; }

        [Column("ListType")]
        public string ChartType { get; set; }

        [Column("TimeWindowType")]
        public string TimeWindow { get; set; }

        [Column("Date")]
        public DateTime ChartDate { get; set; }


        [Column("ChartPosition")]
        public int Position { get; set; }

        [Column("Country")]
        public string Country { get; set; }

        [Column("TrackUrl")]
        public string TrackUrl { get; set; }

        [Column("TrackName")]
        public string TrackName { get; set; }

        [Column("ArtistName")]
        public string ArtistName { get; set; }

        [Column("AlbumUrl")]
        public string AlbumUrl { get; set; }

        [Column("ArtworkUrl")]
        public string ArtworkUrl { get; set; }

        [Column("NumberOfStreams")]
        public int NumberOfStreams { get; set; }

        [Column("PercentMale")]
        public int PercentMale { get; set; }

        [Column("PercentAgeGroup0to17")]
        public int PercentAgeGroup0to17 { get; set; }

        [Column("PercentAgeGroup18to24")]
        public int PercentAgeGroup18to24 { get; set; }

        [Column("PercentAgeGroup25to29")]
        public int PercentAgeGroup25to29 { get; set; }

        [Column("PercentAgeGroup30to34")]
        public int PercentAgeGroup30to34 { get; set; }

        [Column("PercentAgeGroup35to44")]
        public int PercentAgeGroup35to44 { get; set; }

        [Column("PercentAgeGroup45to54")]
        public int PercentAgeGroup45to54 { get; set; }

        [Column("PercentAgeGroup55plus")]
        public int PercentAgeGroup55plus { get; set; }

        [Column("ISRC")]
        public string ISRC { get; set; }
    }

}