# -*- coding: utf-8 -*-
"""
    models.entity
    ~~~~~~~~~~~~~~

    Sql_alchemy的表实体编写.

    :copyright: 云南新八达科技有限公司.
    :author: 李进才.
"""
from models.db import *


class ReagtReceiptStatus(db.Model):
    ReceiptId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    ReceiptName = db.Column(db.String(20), default='')
    ReceiptCode = db.Column(db.String(20), default='')


class ReagtReceipt(db.Model):
    ReceiptCode = db.Column(db.String(20), primary_key=True, nullable=False)
    Remark = db.Column(db.String(1000))
    ReceiptTime = db.Column(db.DateTime)
    VerifyPeople = db.Column(db.String(20))
    Status = db.Column(db.Integer)


class ReagtMaker(db.Model):
    MakerId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Name = db.Column(db.String(100), default='')
    MakerCode = db.Column(db.String(50), default='')
    Using = db.Column(db.Boolean, default=False)


class DictUser(db.Model):
    UserCode = db.Column(db.String(10), primary_key=True, nullable=False)
    RoleCode = db.Column(db.String(8), default='')
    GroupCode = db.Column(db.String(16), default='')
    UserName = db.Column(db.String(40), default='')
    PassWord = db.Column(db.String(20), default='')
    Sex = db.Column(db.String(1), default='')
    Birth = db.Column(db.Date, default='')
    Tel = db.Column(db.String(20), default='')
    Description = db.Column(db.String(100), default='')
    Photo = db.Column(db.String)
    SignImage = db.Column(db.String)
    RightCode = db.Column(db.String(10), default='')
    IsLab = db.Column(db.Boolean)


class ReagtReagent(db.Model):
    ReagentId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Name = db.Column(db.String(200), default='')
    Specification = db.Column(db.String(200), default='')
    Maker = db.Column(db.String(200), default='')
    CertificationCode = db.Column(db.String(30), default='')
    UnitPrice = db.Column(db.Numeric(11, 2))
    SellingPrice = db.Column(db.Numeric(11, 2))
    MaxValue = db.Column(db.Integer)
    MinValue = db.Column(db.Integer)
    TypeName = db.Column(db.String(50), default='')
    PinYinCode = db.Column(db.String(50), default='')
    Unit = db.Column(db.String(30), default='')
    Ratio = db.Column(db.Integer)
    SmallestUnit = db.Column(db.String(20), default='')
    Using = db.Column(db.Boolean)
    GroupName = db.Column(db.String(200), default='')
    ReportItem = db.Column(db.String(200), default='')
    ReportItemCode = db.Column(db.String(100), default='')
    ReagentMark = db.Column(db.String(100), default='')
    __mapper_args__ = {
        "order_by": 'ReagentId'
    }


class ReagtStock(db.Model):
    StockId = db.Column(db.BigInteger, autoincrement=True, primary_key=True, nullable=False)
    ReagentId = db.Column(db.Integer)
    Code = db.Column(db.String(20), default='')
    ProductionBatch = db.Column(db.String(50), default='')
    PinYinCode = db.Column(db.String(50), default='')
    Position = db.Column(db.String(100), default='')
    Number = db.Column(db.Integer)
    LastNumber = db.Column(db.Integer)
    InTime = db.Column(db.DateTime)
    Expiration = db.Column(db.Date)
    VerifyPeople = db.Column(db.String(20), default='')
    BarCode = db.Column(db.String(15), default='')
    SupplierName = db.Column(db.String(100), default='')
    Using = db.Column(db.Boolean)
    MinNumberUnit = db.Column(db.Integer)


class ReagtEntry(db.Model):
    EntryId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Position = db.Column(db.String(100), default='')
    Specification = db.Column(db.String(50), default='')
    Unit = db.Column(db.String(20), default='')
    Maker = db.Column(db.String(100), default='')
    CertificationCode = db.Column(db.String(30), default='')
    SupplierName = db.Column(db.String(100), default='')
    TypeName = db.Column(db.String(50), default='')
    Name = db.Column(db.String(100), default='')
    Number = db.Column(db.Integer)
    MaxValue = db.Column(db.Integer)
    MinValue = db.Column(db.Integer)
    UnitPrice = db.Column(db.Numeric(11, 2))
    SellingPrice = db.Column(db.Numeric(11, 2))
    PinYinCode = db.Column(db.String(50), default='')
    ProductionBatch = db.Column(db.String(50), default='')
    Using = db.Column(db.Boolean)
    Ratio = db.Column(db.Integer)
    SmallestUnit = db.Column(db.String(20), default='')


class ReagtBad(db.Model):
    BadId = db.Column(db.BigInteger, autoincrement=True, primary_key=True, nullable=False)
    VerifyTime = db.Column(db.DateTime)
    Number = db.Column(db.Integer)
    Code = db.Column(db.String(20), default='')
    VerifyPeople = db.Column(db.String(50), default='')
    Remark = db.Column(db.String(500), default='')


class ReagtCertification(db.Model):
    CertificationId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Code = db.Column(db.String(9), default='')
    Using = db.Column(db.Boolean)


class ReagtInvalid(db.Model):
    InvaId = db.Column(db.BigInteger, autoincrement=True, primary_key=True, nullable=False)
    Code = db.Column(db.String(20), default='')
    ProductionBatch = db.Column(db.String(50), default='')
    Remark = db.Column(db.String(1000), default='')
    Executor = db.Column(db.String(20), default='')


class ReagtLog(db.Model):
    LogId = db.Column(db.BigInteger, autoincrement=True, primary_key=True, nullable=False)
    OperatingPeople = db.Column(db.String(50), default='')
    OperatingTime = db.Column(db.DateTime)
    OperatingType = db.Column(db.String(20), default='')
    Remark = db.Column(db.String(500), default='')
    Code = db.Column(db.String(20), default='')
    ReagentName = db.Column(db.String(200), default='')
    BarCode = db.Column(db.String(15), default='')
    PinYinCode = db.Column(db.String(50), default='')
    ReagentNumber = db.Column(db.Integer)
    ReagentSpecification = db.Column(db.String(200), default='')
    ReagentPosition = db.Column(db.String(100), default='')
    ReagentId = db.Column(db.Integer)
    ProductionBatch = db.Column(db.String(50), default='')
    Expiration = db.Column(db.Date)
    SupplierName = db.Column(db.String(100), default='')
    OperateMinNumber = db.Column(db.Integer)
    Receiver = db.Column(db.String(20), default='')


class ReagtOperatingType(db.Model):
    OperatingTypeId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    OperatingCode = db.Column(db.String(20), default='')
    OperatingName = db.Column(db.String(20), default='')


class ReagtPosition(db.Model):
    PositionId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Position = db.Column(db.String(100), default='')
    PositionCode = db.Column(db.String(30), default='')
    Using = db.Column(db.Boolean)


class ReagtSpecification(db.Model):
    SpecificationId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    Specification = db.Column(db.String(50), default='')
    Using = db.Column(db.Boolean)


class ReagtSupplier(db.Model):
    SupplierId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    SupplierName = db.Column(db.String(100), default='')
    SupplierCode = db.Column(db.String(30), default='')
    Using = db.Column(db.Boolean)


class ReagtTypeTable(db.Model):
    TypeId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    TypeCode = db.Column(db.String(20), default='')
    TypeName = db.Column(db.String(50), default='')


class ReagtUnit(db.Model):
    UnitId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    UnitName = db.Column(db.String(20), default='')
    Using = db.Column(db.Boolean)


class ReagtApprove(db.Model):
    ApproveId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    ApproveName = db.Column(db.String(200), default='')
    Specification = db.Column(db.String(200), default='')
    Number = db.Column(db.DECIMAL)
    Maker = db.Column(db.String(100), default='')
    ApprovePeople = db.Column(db.String(20), default='')
    Verifier = db.Column(db.String(20), default='')
    ApproveStatus = db.Column(db.Integer)
    Unit = db.Column(db.String(20), default='')
    ApproveTime = db.Column(db.DateTime)
    Remark = db.Column(db.String(200), default='')
    VerifyTime = db.Column(db.DateTime)


class ReagtApproveStatus(db.Model):
    StatusId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    StatusCode = db.Column(db.String(20), default='')
    StatusName = db.Column(db.String(30), default='')


class ReagtGroup(db.Model):
    GroupId = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    GroupName = db.Column(db.String(200), default='')
    GroupCode = db.Column(db.String(100), default='')


class DictCommon(db.Model):
    ClassCode = db.Column(db.String(16), primary_key=True, nullable=False)
    ItemCode = db.Column(db.String(16), primary_key=True, nullable=False)
    ItemName = db.Column(db.String(50), default='')
    IsDefault = db.Column(db.Boolean)
    Description = db.Column(db.String(100), default='')


class DictInstrument(db.Model):
    InsCode = db.Column(db.String(20), primary_key=True, nullable=False)
    SampleCode = db.Column(db.String(8), default='')
    InsName = db.Column(db.String(100), default='')
    InsClassCode = db.Column(db.String(10), default='')
    NameShort = db.Column(db.String(50), default='')
    SN = db.Column(db.String(32), default='')
    IsDual = db.Column(db.Boolean)
    HasStoped = db.Column(db.Boolean)
    CommVersion = db.Column(db.String(10), default='')
    DecVersion = db.Column(db.String(10), default='')
    BarCode = db.Column(db.String(32), default='')
    PYM = db.Column(db.Boolean)
    DecApp = db.Column(db.String(100), default='')
    FileName = db.Column(db.String(100), default='')


class DictReport(db.Model):
    SampleCode = db.Column(db.String(8), primary_key=True, nullable=False)
    SampleName = db.Column(db.String(100), default='')
    GroupCode = db.Column(db.String(16), default='')
    SpecimenCode = db.Column(db.String(8), default='')
    IsLocal = db.Column(db.Boolean)
    ReportClass = db.Column(db.String(20), default='')
    PYM = db.Column(db.Boolean)
    UniteCode = db.Column(db.String(50), default='')
    Color = db.Column(db.DECIMAL(10), default='')
    Title = db.Column(db.String(100), default='')
    TitleEn = db.Column(db.String(500), default='')
    FileName = db.Column(db.String(100), default='')
    IsBloodRoutine = db.Column(db.Boolean)
    IsUrineRoutine = db.Column(db.Boolean)
    IsStoolRoutine = db.Column(db.Boolean)
    IsCruor = db.Column(db.Boolean)
    IsNcov = db.Column(db.Boolean)



class RptCheckresult(db.Model):
    ID = db.Column(db.Integer, autoincrement=True, primary_key=True, nullable=False)
    TestDate = db.Column(db.Date)
    SampleCode = db.Column(db.String(10))
    RptItemCode = db.Column(db.String(20))
    Result = db.Column(db.Float)
    ResultStr = db.Column(db.String(255))
    Range = db.Column(db.String(2048))
    Unit = db.Column(db.String(20))
    UnusualFlag = db.Column(db.String(10))
    Seq = db.Column(db.Integer)
    IsReview = db.Column(db.Boolean)
    InsCode = db.Column(db.String(20))
    InTime = db.Column(db.DateTime)
    OrderNo = db.Column(db.String(20))
    OrderItemNo = db.Column(db.String(20))
    RptItemName2 = db.Column(db.String(100))