from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Integer
from sqlalchemy import String
from bulkperformancerights.connectors import mysql


class ImageAssets(mysql.ArtRelationsBaseModel):
    __tablename__ = 'image_assets'
    # only need these columns for joins
    id = Column(Integer, primary_key=True)
    vendor_id = Column(Integer)
    path = Column(String(80))
    filename = Column(String(80))
    date_added = Column(DateTime)