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='部门名称')
    del_flag = Column(String(10),default='0', comment='是否删除')
    task_description = Column(Text, nullable=False,comment='任务内容/描述')
    registrar = Column(String(255), nullable=False,comment='登记人')
    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")