| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- from sqlalchemy import Column, Integer, String, DateTime, ForeignKey,Text
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy.orm import relationship
- from datetime import datetime
- # from database import Base
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy.orm import relationship, sessionmaker
- from sqlalchemy import func
- # from sqlalchemy import Column, Integer, String, Text, DateTime, ForeignKey
- # from sqlalchemy.orm import relationship
- Base = declarative_base()
- class TaskRegistration(Base):
- __tablename__ = 'task_registrations'
- id = Column(Integer, primary_key=True, autoincrement=True, index=True,comment='id')
- task_id = Column(String(255), index=True,comment='任务ID')
- unit_name = Column(String(255), nullable=False,comment='部门名称')
- unit_id = Column(String(255), nullable=False,comment='部门ID')
- del_flag = Column(String(10),default='0', comment='是否删除')
- task_description = Column(Text, nullable=False,comment='任务内容/描述')
- registrar = Column(String(255), nullable=False,comment='登记人')
- registrar_id = Column(String(255), nullable=False,comment='登记人ID')
- creation_time = Column(DateTime, default=datetime.now,comment='创建时间')
- update_time = Column(DateTime, default=datetime.now,comment='创建时间')
- processing_status = Column(String(50), default='处理中',comment='任务状态')
- event_code = Column(String(50), nullable=False,comment='关联事件ID')
- task_type = Column(String(1), default='0', server_default='0', comment='任务类型 0 事件处置 1 防范措施 2 险情处理 3 督办任务')
- # 你可以添加更多的字段和关系，例如与用户模型的外键关系
- # user_id = Column(Integer, ForeignKey('users.id'))
- # user = relationship("User", back_populates="task_registrations")
- class TaskUnit(Base):
- __tablename__ = 'task_unit'
- id = Column(Integer, primary_key=True, autoincrement=True, index=True,comment='id')
- unit_name = Column(String(255), nullable=False, comment='部门名称')
- unit_duty = Column(Text, nullable=False,comment='部门职责')
|
