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

# -*- coding: utf-8 -*-
from sqlalchemy import String, Column, Integer,DateTime,Text,BigInteger,Boolean,PrimaryKeyConstraint,Index,UniqueConstraint,CHAR,LargeBinary,TIMESTAMP
from sqlalchemy.dialects.mysql import TINYINT
from sqlalchemy.sql import func
from database import Base
from datetime import datetime

class DutyShift(Base):
    """
    值班日历
    """
    __tablename__ = 'duty_shift'
   
    shift_id = Column(Integer, primary_key=True, autoincrement=True, comment='ID')
    shift_date = Column(DateTime, nullable=False, comment="班次日期")
    start_time = Column(DateTime, nullable=False, comment="开始时间")
    end_time = Column(DateTime, nullable=False, comment="结束时间")
    leader_id = Column(Integer, nullable=False, comment="领导ID")
    primary_staff_id = Column(Integer, nullable=False, comment="主班人员ID")
    secondary_staff_id = Column(Integer, nullable=False, comment="副班人员ID")
    standby_staff_id = Column(Integer, nullable=False, comment="备班人员ID")

    duty_type = Column(String, default='', server_default='', comment="值班类型")
    shfit_status = Column(Integer, default='0', server_default='0', comment="值班状态 0 默认 1已交班")
    handover_user_id = Column(Integer, comment="交班人员ID")
    handover_time = Column(DateTime, comment="交班时间")
    dept_id = Column(Integer, nullable=False, comment="部门ID")
    area_code = Column(String, default='', server_default='', comment="行政区划代码")
    
    class Config:
        orm_mode = True


class DutyNotify(Base):
    """
    值班事项提醒
    """
    __tablename__ = 'duty_notify'
   
    id = Column(Integer, primary_key=True, autoincrement=True, comment='ID')
    shift_id = Column(Integer, default='0', server_default='0', comment="班次ID")
    notify_content = Column(String, default='', server_default='', comment="提示内容")
    notify_type = Column(Integer, default='0', server_default='0', comment="1 待办事项 2 提醒事项")
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    recorded_by = Column(Integer, default=0, server_default='0', comment='记录用户ID')

    class Config:
        orm_mode = True