using System; using System.Linq; using Newtonsoft.Json; using Sony.Filtr.Contracts.Abstractions; namespace Sony.Filtr.SpotifyAnalytics.Data { [PetaPoco.TableName("tblSpotifyPlaylistTrackStream")] public class SpotifyPlaylistTrackAggregatedStream : IAggregatedStreamFormat { [PetaPoco.Column("ReportDate")] [JsonProperty("report_date")] public DateTime ReportDate { get; set; } [PetaPoco.Column("ReportCountryCode")] [JsonProperty("report_country_code")] public string ReportCountryCode { get; set; } [PetaPoco.Column("Date")] [JsonProperty("date")] public DateTime Date { get; set; } [PetaPoco.Column("CountryCode")] [JsonProperty("country_code")] public string CountryCode { get; set; } [PetaPoco.Column("PlaylistUri")] [JsonProperty("playlist_uri")] public string PlaylistUri { get; set; } [PetaPoco.Column("Isrc")] [JsonProperty("isrc")] public string Isrc { get; set; } [PetaPoco.Column("DeviceTypePersonalComputer")] [JsonProperty("device_type_personal_computer")] public int DeviceTypePersonalComputer { get; set; } [PetaPoco.Column("DeviceTypeCellPhone")] [JsonProperty("device_type_cell_phone")] public int DeviceTypeCellPhone { get; set; } [PetaPoco.Column("DeviceTypeTablet")] [JsonProperty("device_type_tablet")] public int DeviceTypeTablet { get; set; } [PetaPoco.Column("DeviceTypeGamingConsole")] [JsonProperty("device_type_gaming_console")] public int DeviceTypeGamingConsole { get; set; } [PetaPoco.Column("DeviceTypeSmartTvDevice")] [JsonProperty("device_type_smart_tv_device")] public int DeviceTypeSmartTvDevice { get; set; } [PetaPoco.Column("DeviceTypeConnectedAudioDevice")] [JsonProperty("device_type_connected_audio_device")] public int DeviceTypeConnectedAudioDevice { get; set; } [PetaPoco.Column("DeviceTypeBuiltinCarApplication")] [JsonProperty("device_type_builtin_car_application")] public int DeviceTypeBuiltinCarApplication { get; set; } [PetaPoco.Column("DeviceTypeOther")] [JsonProperty("device_type_other")] public int DeviceTypeOther { get; set; } [PetaPoco.Column("DeviceOsAndroid")] [JsonProperty("device_os_android")] public int DeviceOsAndroid { get; set; } [PetaPoco.Column("DeviceOsBlackberry")] [JsonProperty("device_os_blackberry")] public int DeviceOsBlackberry { get; set; } [PetaPoco.Column("DeviceOsBrowser")] [JsonProperty("device_os_browser")] public int DeviceOsBrowser { get; set; } [PetaPoco.Column("DeviceOsIos")] [JsonProperty("device_os_ios")] public int DeviceOsIos { get; set; } [PetaPoco.Column("DeviceOsLinux")] [JsonProperty("device_os_linux")] public int DeviceOsLinux { get; set; } [PetaPoco.Column("DeviceOsMac")] [JsonProperty("device_os_mac")] public int DeviceOsMac { get; set; } [PetaPoco.Column("DeviceOsOther")] [JsonProperty("device_os_other")] public int DeviceOsOther { get; set; } [PetaPoco.Column("DeviceOsWindows")] [JsonProperty("device_os_windows")] public int DeviceOsWindows { get; set; } [PetaPoco.Column("RepeatPlay")] [JsonProperty("repeat_play")] public int RepeatPlay { get; set; } [PetaPoco.Column("ShufflePlay")] [JsonProperty("shuffle_play")] public int ShufflePlay { get; set; } [PetaPoco.Column("Streams")] [JsonProperty("streams")] public int Streams { get; set; } [PetaPoco.Column("DistributerId")] public int DistributerId { get; set; } } }