zkxw/backend/app/models/qc_param.py

from datetime import datetime

from sqlalchemy import CHAR, Column, DateTime, Integer, SmallInteger, String

from app.core.database import Base


class BizQcItemParam(Base):
    __tablename__ = "biz_qc_item_param"

    id = Column(String(64), primary_key=True, comment="主键ID")
    item_source = Column(String(16), nullable=False, comment="lab实验室 third_party第三方")
    item_id = Column(String(64), nullable=False, comment="检测项目ID")
    param_name = Column(String(200), nullable=False, comment="参数名称")
    param_code = Column(String(64), nullable=False, comment="参数编码")
    param_unit = Column(String(32), nullable=True, comment="单位")
    param_type = Column(String(16), nullable=False, default="text", comment="number/text/select")
    options = Column(String(2000), nullable=True, comment="单选选项列表，JSON数组格式")
    default_value = Column(String(500), nullable=True, comment="单选默认值")
    required_flag = Column(CHAR(1), nullable=False, default="0", comment="1必填 0非必填")
    tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
    order_num = Column(Integer, nullable=True, comment="排序号")
    remark = Column(String(512), nullable=True, comment="备注")
    create_by = Column(String(64), nullable=True, comment="创建人id")
    create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
    create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
    update_by = Column(String(64), nullable=True, comment="更新人id")
    update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
    del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")


class BizQcTaskResult(Base):
    __tablename__ = "biz_qc_task_result"

    id = Column(String(64), primary_key=True, comment="主键ID")
    task_id = Column(String(64), nullable=False, comment="质检任务ID")
    param_id = Column(String(64), nullable=True, comment="参数模板ID")
    param_name = Column(String(200), nullable=False, comment="参数名快照")
    param_code = Column(String(64), nullable=True, comment="参数编码快照")
    param_unit = Column(String(32), nullable=True, comment="单位快照")
    param_type = Column(String(16), nullable=False, default="text", comment="类型快照")
    param_value = Column(String(500), nullable=True, comment="填写值")
    tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
    remark = Column(String(512), nullable=True, comment="备注")
    create_by = Column(String(64), nullable=True, comment="创建人id")
    create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
    create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
    update_by = Column(String(64), nullable=True, comment="更新人id")
    update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
    del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")