"""
Asset Location Detail Model.

This Asset Location Detail model uses sqlalchemy
"""

from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy import Float

from assets.connectors import mysql


class AssetLocationDetail(mysql.DdModel):
    """Table defination for asset_location_detail table."""

    __tablename__ = 'asset_location_detail'

    asset_location_detail_id = Column(Integer, primary_key=True)
    asset_location_id = Column(Integer)
    bits_per_sample = Column(Integer)
    filename = Column(String)
    duration = Column(Float)