tools-api/model/records.py

# coding: utf-8
from sqlalchemy import BigInteger, Column, JSON, TIMESTAMP, text
from sqlalchemy.dialects.mysql import VARCHAR
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata


class Record(Base):
    __tablename__ = 'records'

    id = Column(BigInteger, primary_key=True)
    created_at = Column(TIMESTAMP, nullable=False, server_default=text("CURRENT_TIMESTAMP"), comment='Create Time | 创建日期')
    updated_at = Column(TIMESTAMP, nullable=False, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"), comment='Update Time | 修改日期')
    body = Column(JSON, comment='获取数据')
    caller = Column(VARCHAR(255), server_default=text("''"), comment='主叫号码')
    callee = Column(VARCHAR(255), server_default=text("''"), comment='被叫号码')
    record_file = Column(VARCHAR(255), server_default=text("''"), comment='录音文件')