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, }