python-fastapi-mm-zhcs-yj-api/models/online_roll_call.py

from sqlalchemy import Column, BigInteger, String, Text, DateTime, CHAR,Integer,Float
from database import Base
from datetime import datetime

class OnlineRollCallBase(Base):
    """
    在线点名表
    """
    __tablename__ = 'online_roll_call_base'

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment='ID')
    call_type = Column(Integer, default=0, server_default='0', comment='点名类型 1 一键点名全市至区县 2 一键点名全市至镇街 3 分区/县点名')
    recorded_by = Column(Integer, default=0, server_default='0', comment='记录用户ID')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    end_time = Column(DateTime, comment='结束时间')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    user_count = Column(Integer, default=0, server_default='0', comment='用户数')
    ack_count = Column(Integer, default=0, server_default='0', comment='应答数')
    unack_count = Column(Integer, default=0, server_default='0', comment='未应答数')
    remark = Column(String, default='', server_default='', comment='备注')
    update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间')

    class Config:
        orm_mode = True


class OnlineRollCallDetail(Base):
    """
    在线点名明细表
    """
    __tablename__ = 'online_roll_call_detail'

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment='ID')
    pid = Column(BigInteger, default=0, server_default='0', comment='关联主表ID')
    user_id = Column(Integer, default=0, server_default='0', comment='关联用户ID')
    dept_id = Column(Integer, default=0, server_default='0', comment='关联用户所在部门ID')
    nick_name = Column(String, default='', server_default='', comment='用户姓名')
    dept_name = Column(String, default='', server_default='', comment='部门名称')
    onduty_user = Column(String, default='', server_default='', comment='值班员（显示）')
    onduty_leader = Column(String, default='', server_default='', comment='值班领导（显示）')
    video_url = Column(String, default='', server_default='', comment='视频URL')
    call_url = Column(String, default='', server_default='', comment='电话URL')
    ack_status = Column(Integer, default=0, server_default='0', comment='应答状态 0 未应答 1 已应答')
    act_time = Column(DateTime, comment='应答时间')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    ack_type = Column(Integer, default=0, server_default='0', comment='应答方式 1 视频  2 电话')

    class Config:
        orm_mode = True