class BloodHistory(db.Model):
__tablename__ = u'BloodHistory'
id = db.Column(db.Integer, primary_key=True)
bloodDate = db.Column(db.Date, nullable=False)
client_id = db.Column(db.Integer,
db.ForeignKey('Client.id'),
nullable=False)
bloodType_id = db.Column(db.Integer,
db.ForeignKey('rbBloodType.id'),
nullable=False)
person_id = db.Column(db.Integer,
db.ForeignKey('Person.id'),
nullable=False)
bloodType = db.relationship("rbBloodType")
person = db.relationship('Person')
def __init__(self, blood_type, date, person, client):
self.bloodType_id = int(blood_type) if blood_type else None
self.bloodDate = date
self.person_id = int(person) if person else None
self.client = client
def __int__(self):
return self.id
def __json__(self):
return {
'id': self.id,
'blood_type': self.bloodType,
'date': self.bloodDate,
'person': self.person
}
class rbVisitType(db.Model):
__tablename__ = u'rbVisitType'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.Unicode(8), nullable=False, index=True)
name = db.Column(db.Unicode(64), nullable=False, index=True)
serviceModifier = db.Column(db.Unicode(128), nullable=False)
class rbTissueType(db.Model):
__tablename__ = u'rbTissueType'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.String(64), nullable=False)
name = db.Column(db.String(128), nullable=False)
group_id = db.Column(db.ForeignKey('rbTissueType.id'), index=True)
sexCode = db.Column("sex",
db.Integer,
nullable=False,
server_default=u"'0'")
group = db.relationship(u'rbTissueType', remote_side=[id])
@property
def sex(self):
return {0: u'Любой', 1: u'М', 2: u'Ж'}[self.sexCode]
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
'sex': self.sex,
}
class ActionType_Service(db.Model):
__tablename__ = u'ActionType_Service'
id = db.Column(db.Integer, primary_key=True)
master_id = db.Column(db.Integer, nullable=False, index=True)
idx = db.Column(db.Integer, nullable=False, server_default=u"'0'")
finance_id = db.Column(db.Integer, index=True)
service_id = db.Column(db.Integer, index=True)
class OrgStructure_ActionType(db.Model):
__tablename__ = u'OrgStructure_ActionType'
id = db.Column(db.Integer, primary_key=True)
master_id = db.Column(db.ForeignKey('OrgStructure.id'),
nullable=False,
index=True)
idx = db.Column(db.Integer, nullable=False, server_default=u"'0'")
actionType_id = db.Column(db.ForeignKey('ActionType.id'), index=True)
class ConfigVariables(db.Model):
__tablename__ = '%s_config' % TABLE_PREFIX
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.String(25), unique=True, nullable=False)
name = db.Column(db.Unicode(50), unique=True, nullable=False)
value = db.Column(db.Unicode(100))
value_type = db.Column(db.String(30))
def __unicode__(self):
return self.code
class ActionProperty_OtherLPURecord(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_OtherLPURecord'
id = db.Column(db.Integer,
db.ForeignKey('ActionProperty.id'),
primary_key=True)
index = db.Column(db.Integer,
primary_key=True,
nullable=False,
server_default=u"'0'")
value = db.Column(db.Text(collation=u'utf8_unicode_ci'), nullable=False)
class rbAnalysisStatus(db.Model):
__tablename__ = u'rbAnalysisStatus'
id = db.Column(db.Integer, primary_key=True)
statusName = db.Column(db.String(80), nullable=False, unique=True)
def __json__(self):
return {
'id': self.id,
'code': self.statusName,
'name': self.statusName
}
class ActionProperty_Person(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_Person'
id = db.Column(db.ForeignKey('ActionProperty.id'),
primary_key=True,
nullable=False)
index = db.Column(db.Integer, nullable=False, server_default=u"'0'")
value_ = db.Column('value', db.ForeignKey('Person.id'), index=True)
value = db.relationship(u'Person')
property_object = db.relationship('ActionProperty',
backref='_value_Person')
class ActionProperty_Integer_Base(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_Integer'
id = db.Column(db.Integer,
db.ForeignKey('ActionProperty.id'),
primary_key=True,
nullable=False)
index = db.Column(db.Integer,
primary_key=True,
nullable=False,
server_default=u"'0'")
value_ = db.Column('value', db.Integer, nullable=False)
class rbHospitalBedType(db.Model):
__tablename__ = u'rbHospitalBedType'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.String(8), nullable=False, index=True)
name = db.Column(db.Unicode(64), nullable=False, index=True)
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
}
class rbUnit(db.Model):
__tablename__ = u'rbUnit'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.Unicode(256), index=True)
name = db.Column(db.Unicode(256), index=True)
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
}
class ActionProperty_Time(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_Time'
id = db.Column(db.Integer,
db.ForeignKey('ActionProperty.id'),
primary_key=True,
nullable=False)
index = db.Column(db.Integer,
primary_key=True,
nullable=False,
server_default=u"'0'")
value = db.Column(db.Time, nullable=False)
property_object = db.relationship('ActionProperty', backref='_value_Time')
class Event_Persons(db.Model):
__tablename__ = u'Event_Persons'
id = db.Column(db.Integer, primary_key=True)
event_id = db.Column(db.ForeignKey('Event.id'), nullable=False, index=True)
person_id = db.Column(db.ForeignKey('Person.id'),
nullable=False,
index=True)
begDate = db.Column(db.DateTime, nullable=False)
endDate = db.Column(db.DateTime)
event = db.relationship('Event')
person = db.relationship('Person')
class ActionProperty_rbBloodComponentType(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_rbBloodComponentType'
id = db.Column(db.ForeignKey('ActionProperty.id'),
primary_key=True,
nullable=False)
index = db.Column(db.Integer, primary_key=True, nullable=False)
value_ = db.Column('value',
db.ForeignKey('rbTrfuBloodComponentType.id'),
nullable=False)
value = db.relationship('rbBloodComponentType')
property_object = db.relationship('ActionProperty',
backref='_value_rbBloodComponentType')
class rbAppointmentType(db.Model):
__tablename__ = 'rbAppointmentType'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.Unicode(32), nullable=False)
name = db.Column(db.Unicode(64), nullable=False)
def __unicode__(self):
return u'(%s) %s' % (self.code, self.name)
def __json__(self):
return {
'code': self.code,
'name': self.name,
}
class ActionProperty_Double(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_Double'
id = db.Column(db.Integer,
db.ForeignKey('ActionProperty.id'),
primary_key=True,
nullable=False)
index = db.Column(db.Integer,
primary_key=True,
nullable=False,
server_default=u"'0'")
value = db.Column(db.Float(asdecimal=True, decimal_return_scale=2),
nullable=False)
property_object = db.relationship('ActionProperty',
backref='_value_Double')
class ActionType_User(db.Model):
__tablename__ = u'ActionType_User'
__table_args__ = (db.Index(u'person_id_profile_id', u'person_id',
u'profile_id'), )
id = db.Column(db.Integer, primary_key=True)
actionType_id = db.Column(db.ForeignKey('ActionType.id'),
nullable=False,
index=True)
person_id = db.Column(db.ForeignKey('Person.id'))
profile_id = db.Column(db.ForeignKey('rbUserProfile.id'), index=True)
actionType = db.relationship(u'ActionType')
person = db.relationship(u'Person')
profile = db.relationship(u'rbUserProfile')
class rbTimeQuotingType(db.Model):
__tablename__ = u'rbTimeQuotingType'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.Integer, nullable=False, unique=True)
name = db.Column(db.Text(collation=u'utf8_unicode_ci'), nullable=False)
def __unicode__(self):
return u'(%d) %s' % (self.code, self.name)
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
}
class AddressHouse(db.Model):
__tablename__ = u'AddressHouse'
__table_args__ = (db.Index(u'KLADRCode', u'KLADRCode', u'KLADRStreetCode',
u'number', u'corpus'), )
id = db.Column(db.Integer, primary_key=True)
createDatetime = db.Column(db.DateTime,
nullable=False,
default=datetime.datetime.now)
createPerson_id = db.Column(db.Integer,
index=True,
default=safe_current_user_id)
modifyDatetime = db.Column(db.DateTime,
nullable=False,
default=datetime.datetime.now,
onupdate=datetime.datetime.now)
modifyPerson_id = db.Column(db.Integer,
index=True,
default=safe_current_user_id,
onupdate=safe_current_user_id)
deleted = db.Column(db.Integer,
nullable=False,
default=0,
server_default=u"'0'")
KLADRCode = db.Column(db.String(13), nullable=False)
KLADRStreetCode = db.Column(db.String(17), nullable=False)
number = db.Column(db.String(8), nullable=False)
corpus = db.Column(db.String(8), nullable=False)
def __init__(self, loc_code, street_code, house_number, corpus_number):
self.KLADRCode = loc_code
self.KLADRStreetCode = street_code
self.number = house_number
self.corpus = corpus_number
def __json__(self):
return {
'id': self.id,
'deleted': self.deleted,
'locality_code': self.KLADRCode,
'street_code': self.KLADRStreetCode,
'number': self.number,
'corpus': self.corpus
}
def __int__(self):
return self.id
class rbHospitalBedProfile(db.Model):
__tablename__ = u'rbHospitalBedProfile'
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.String(8), nullable=False, index=True)
name = db.Column(db.Unicode(64), nullable=False, index=True)
service_id = db.Column(db.Integer,
db.ForeignKey('rbService.id'),
index=True)
# service = db.relationship('rbService')
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
}
class ActionProperty_FDRecord(ActionProperty__ValueType):
__tablename__ = u'ActionProperty_FDRecord'
id = db.Column(db.Integer,
db.ForeignKey('ActionProperty.id'),
primary_key=True)
index = db.Column(db.Integer, nullable=False, server_default=u"'0'")
value_ = db.Column('value',
db.ForeignKey('FDRecord.id'),
nullable=False,
index=True)
value = db.relationship(u'FDRecord')
property_object = db.relationship('ActionProperty',
backref='_value_FDRecord')
def get_value(self):
return FDRecord.query.filter(
FDRecord.id == self.value).first().get_value(u'Наименование')
class Office(db.Model):
__tablename__ = 'Office'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.Unicode(32), nullable=False)
name = db.Column(db.Unicode(64), nullable=False)
orgStructure_id = db.Column(db.ForeignKey('OrgStructure.id'))
orgStructure = db.relationship('OrgStructure')
def __unicode__(self):
return self.code
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
'org_structure': self.orgStructure
}
class Street(db.Model):
__bind_key__ = 'kladr'
__tablename__ = 'STREET'
__table_args__ = (db.Index('NAME_SOCR', 'NAME', 'SOCR', 'CODE'), )
NAME = db.Column(db.Unicode(40), nullable=False)
SOCR = db.Column(db.Unicode(10), nullable=False)
CODE = db.Column(db.String(17), primary_key=True)
INDEX = db.Column(db.String(6), nullable=False)
GNINMB = db.Column(db.String(4), nullable=False)
UNO = db.Column(db.String(4), nullable=False)
OCATD = db.Column(db.String(11), nullable=False)
infis = db.Column(db.String(5), nullable=False, index=True)
class rbJobType(db.Model):
__tablename__ = u'rbJobType'
id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer, index=True)
code = db.Column(db.String(64), nullable=False)
regionalCode = db.Column(db.String(64), nullable=False)
name = db.Column(db.Unicode(128), nullable=False)
laboratory_id = db.Column(db.Integer, index=True)
isInstant = db.Column(db.Integer, nullable=False, server_default=u"'0'")
class ScheduleTicket(db.Model):
__tablename__ = 'ScheduleTicket'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
schedule_id = db.Column(db.Integer, db.ForeignKey('Schedule.id'), nullable=False)
begTime = db.Column(db.Time)
endTime = db.Column(db.Time)
attendanceType_id = db.Column(db.Integer, db.ForeignKey('rbAttendanceType.id'), nullable=False)
createDatetime = db.Column(db.DateTime, nullable=False, default=datetime.datetime.now)
createPerson_id = db.Column(db.Integer, db.ForeignKey('Person.id'), index=True, default=safe_current_user_id)
modifyDatetime = db.Column(db.DateTime, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
modifyPerson_id = db.Column(db.Integer, db.ForeignKey('Person.id'), index=True, default=safe_current_user_id, onupdate=safe_current_user_id)
deleted = db.Column(db.SmallInteger, nullable=False, server_default='0', default=0)
attendanceType = db.relationship('rbAttendanceType', lazy=False)
client_ticket = db.relationship(
'ScheduleClientTicket', lazy=False, primaryjoin=
"and_(ScheduleClientTicket.ticket_id == ScheduleTicket.id, ScheduleClientTicket.deleted == 0)",
uselist=False)
# schedule = db.relationship(
# 'Schedule', lazy=True, innerjoin=True, uselist=False,
# primaryjoin='and_('
# 'Schedule.deleted == 0, ScheduleTicket.deleted == 0, ScheduleTicket.schedule_id == Schedule.id)'
# )
@property
def client(self):
ct = self.client_ticket
return ct.client if ct else None
@property
def begDateTime(self):
return datetime.datetime.combine(self.schedule.date, self.begTime) if self.begTime is not None else None
@property
def endDateTime(self):
return datetime.datetime.combine(self.schedule.date, self.endTime) if self.endTime is not None else None
class ActionType_EventType_check(db.Model):
__tablename__ = u'ActionType_EventType_check'
id = db.Column(db.Integer, primary_key=True)
actionType_id = db.Column(db.ForeignKey('ActionType.id'),
nullable=False,
index=True)
eventType_id = db.Column(db.ForeignKey('EventType.id'),
nullable=False,
index=True)
related_actionType_id = db.Column(db.ForeignKey('ActionType.id'),
index=True)
relationType = db.Column(db.Integer)
actionType = db.relationship(
u'ActionType',
primaryjoin='ActionType_EventType_check.actionType_id == ActionType.id'
)
eventType = db.relationship(u'EventType')
related_actionType = db.relationship(
u'ActionType',
primaryjoin=
'ActionType_EventType_check.related_actionType_id == ActionType.id')
class QuotingByTime(db.Model):
__tablename__ = u'QuotingByTime'
id = db.Column(db.Integer, primary_key=True)
doctor_id = db.Column(db.Integer)
quoting_date = db.Column(db.Date, nullable=False)
QuotingTimeStart = db.Column(db.Time, nullable=False)
QuotingTimeEnd = db.Column(db.Time, nullable=False)
quotingType_id = db.Column("QuotingType", db.Integer, db.ForeignKey('rbTimeQuotingType.code'))
quotingType = db.relationship('rbTimeQuotingType', lazy='joined')
class ActionType_TissueType(db.Model):
__tablename__ = u'ActionType_TissueType'
id = db.Column(db.Integer, primary_key=True)
master_id = db.Column(db.ForeignKey('ActionType.id'),
nullable=False,
index=True)
idx = db.Column(db.Integer, nullable=False, server_default=u"'0'")
tissueType_id = db.Column(db.ForeignKey('rbTissueType.id'), index=True)
amount = db.Column(db.Integer, nullable=False, server_default=u"'0'")
unit_id = db.Column(db.ForeignKey('rbUnit.id'), index=True)
master = db.relationship(u'ActionType')
tissueType = db.relationship(u'rbTissueType')
unit = db.relationship(u'rbUnit')
class rbOperationType(db.Model):
__tablename__ = u'rbOperationType'
id = db.Column(db.Integer, primary_key=True)
cd_r = db.Column(db.Integer, nullable=False)
cd_subr = db.Column(db.Integer, nullable=False)
code = db.Column(db.String(8), nullable=False, index=True)
ktso = db.Column(db.Integer, nullable=False)
name = db.Column(db.String(64), nullable=False, index=True)
def __json__(self):
return {
'id': self.id,
'code': self.code,
'name': self.name,
}
