You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
287 lines
12 KiB
287 lines
12 KiB
# -*- 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))
|
|
|