from project_name import mysql
from sqlalchemy import Column, Integer, Enum, String, DateTime, Float, Text, \
    TIMESTAMP, func


class SpotifyTrend(mysql.ProjectNameBaseModel):
    __tablename__ = 'spotify_trend'
    track_uri = Column(String)
    track_artist = Column(String)
    track_name = Column(String)
    upc = Column(String)
    isrc = Column(String)
    country_code = Column(String)
    last_count = Column(Integer)
    trend_pct = Column(Float(precision=18, decimal_return_scale=6))
    id = Column(
        Integer, primary_key=True, autoincrement=True, nullable=False)
    genre_id = Column(Integer)
    subgenre_id = Column(Integer)