from dostadmin import db
from dostadmin.mixins import TimestampMixin


class Transcript(TimestampMixin, db.Model):
    __tablename__ = "transcript"

    id = db.Column(db.Integer, primary_key=True)
    recording_url = db.Column(db.String(200))
    status = db.Column(db.String(30))
    callsid = db.Column(db.String(50))
    filename = db.Column(db.String(100))
    downloaded_filepath = db.Column(db.String(200))
    file_path_wav = db.Column(db.String(200))
    size = db.Column(db.Integer)
    duration = db.Column(db.Integer)
    transcript = db.Column(db.String)
    translation = db.Column(db.String)
    translation_advanced = db.Column(db.String)