| 123456789101112131415161718192021222324252627282930313233 |
- 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 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.utcnow,comment='创建时间')
- update_time = Column(DateTime, default=datetime.utcnow,comment='更新时间')
- processing_status = Column(String(50), default='处理中',comment='任务状态')
- # 你可以添加更多的字段和关系，例如与用户模型的外键关系
- # user_id = Column(Integer, ForeignKey('users.id'))
- # user = relationship("User", back_populates="task_registrations")
|
