class res_users(Base): """Клиенты""" __tablename__ = 'res_users' id = Column(Integer, primary_key=True) active = Column(Boolean) login = Column(String(64)) password = Column(String) company_id = Column(Integer, FKey('res_company.id'), index=True) partner_id = Column(Integer, FKey('res_partner.id'), index=True) create_uid = Column(Integer, FKey('res_users.id'), index=True) create_date = Column(DateTime) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) menu_id = Column(Integer) login_date = Column(Date) signature = Column(Text) action_id = Column(Integer) alias_id = Column(Integer, nullable=False) share = Column(Boolean) password_crypt = Column(String) display_groups_suggestions = Column(Boolean) default_section_id = Column(Integer) facsimile = Column(Binary) display_employees_suggestions = Column(Boolean) google_calendar_token_validity = Column(DateTime) google_calendar_rtoken = Column(String) google_calendar_last_sync_date = Column(DateTime) google_calendar_token = Column(String) google_calendar_cal_id = Column(String) karma = Column(Integer)
class RbLaboratoryTest(Base): __tablename__ = 'rbLaboratory_Test' id = Column(Integer, primary_key=True) master_id = Column(Integer, FKey('rbLaboratory_Test.id'), index=True) test_id = Column(Integer, FKey('rbTest.id'), index=True) book = Column(String(64), index=True) code = Column(String(64), index=True)
class RbHospitalBedProfileService(Base): __tablename__ = 'rbHospitalBedProfile_Service' id = Column(Integer, primary_key=True) rbHospitalBedProfile_id = Column(Integer, FKey('rbHospitalBedProfile.id'), index=True) rbService_id = Column(Integer, FKey('rbService.id'), index=True)
class crm_case_section(Base): """Отделы продаж""" __tablename__ = 'crm_case_section' id = Column(Integer, primary_key=True) create_uid = Column(Integer, FKey('res_users.id'), index=True) create_date = Column(DateTime) write_date = Column(DateTime) working_hours = Column(Numeric) alias_id = Column(Integer, nullable=False) code = Column(String(8)) active = Column(Boolean) change_responsible = Column(Boolean) user_id = Column(Integer, FKey('res_company.id'), index=True) # Team Leader name = Column(String(64)) note = Column(Text) parent_id = Column(Integer, FKey('crm_case_section.id'), index=True) complete_name = Column(String(256)) reply_to = Column(String(64)) resource_calendar_id = Column(Integer) color = Column(Integer) message_last_post = Column(DateTime) use_leads = Column(Boolean) use_opportunities = Column(Boolean) use_quotations = Column(Boolean) invoiced_target = Column(Integer) invoiced_forecast = Column(Integer) default_stage_id = Column(Integer, FKey('crm_case_stage.id'), index=True) track_act = Column(Boolean)
class sale_order_line(Base): """Позиция заказа продаж""" __tablename__ = 'sale_order_line' id = Column(Integer, primary_key=True) address_allotment_id = Column(Integer) client_product_name = Column(String) company_id = Column(Integer, FKey('res_company.id'), index=True) company = relationship('res_company', foreign_keys='sale_order_line.company_id') contract_production_time = Column(Integer) contract_shipment_date = Column(Date) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) delay = Column(Float) discount = Column(Numeric) invoiced = Column(Boolean) name = Column(Text) order_id = Column(Integer, FKey('sale_order.id'), index=True) order = relationship('sale_order', foreign_keys='sale_order_line.order_id') order_partner_id = Column(Integer) price_unit = Column(Numeric) product_id = Column(Integer) product_packaging = Column(Integer) product_uom = Column(Integer) product_uom_qty = Column(Numeric) product_uos = Column(Integer) product_uos_qty = Column(Numeric) requisition_required = Column(Boolean) route_id = Column(Integer) salesman_id = Column(Integer) sequence = Column(Integer) state = Column(String) th_weight = Column(Numeric)
class sale_order(Base): """Заказ продаж""" __tablename__ = 'sale_order' id = Column(Integer, primary_key=True) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) amount_tax = Column(Numeric) amount_total = Column(Numeric) amount_untaxed = Column(Numeric) campaign_id = Column(Integer) # New in 10 client_order_ref = Column(String) # close_order_date = Column(Date) # cm_recured_date = Column(Date) company_id = Column(Integer, FKey('res_company.id'), index=True) company = relationship('res_company', foreign_keys='sale_order.company_id') # contract_production_time = Column(Integer) # contract_shipment_date = Column(Date) # date_confirm = Column(Date) confirmation_date = Column(Date) date_order = Column(DateTime, nullable=False) entity_for_proc = Column(Integer, FKey('sintez_legal_entity.id'), index=True) legal_entity = relationship('sintez_legal_entity', foreign_keys='sale_order.entity_for_proc') fiscal_position_id = Column(Integer) incoterm = Column(Integer) invoice_status = Column(String) matching_scheme_date = Column(Date) medium_id = Column(Integer) # New in 10 message_last_post = Column(DateTime) name = Column(String, index=True, nullable=False) note = Column(Text) opportunity_id = Column(Integer) # New in 10 # order_policy = Column(String) # order_procurement_confirmed = Column(Boolean) origin = Column(String) partner_id = Column(Integer, nullable=False) partner_invoice_id = Column(Integer, nullable=False) partner_shipping_id = Column(Integer, nullable=False) payment_term_id = Column(Integer) picking_policy = Column(String, nullable=False) # prepayments_date = Column(Date) pricelist_id = Column(Integer, nullable=False) procurement_group_id = Column(Integer) project_id = Column(Integer) required_shipment_date = Column(Date) shipment_date = Column(Date) shipped = Column(Boolean) so_lines = relationship("sale_order_line") source_id = Column(Integer) state = Column(String) team_id = Column(Integer) user_id = Column(Integer, FKey('res_users.id'), index=True) user = relationship('res_users', foreign_keys='sale_order.user_id') validity_date = Column(Date) warehouse_id = Column(Integer, nullable=False)
class RbJobType(Base): __tablename__ = 'rbJobType' id = Column(Integer, primary_key=True) group_id = Column(Integer, FKey('rbJobType.id'), index=True) code = Column(String(64), index=True) regionalCode = Column(String(64), index=True) name = Column(String(128), index=True) laboratory_id = Column(Integer, FKey('rbLaboratory.id'), index=True) isInstant = Column(SmallInteger, default='0')
class sarrz_legal_entity(Base): """Компания для выставления счетов""" __tablename__ = 'sarrz_legal_entity' id = Column(Integer, primary_key=True) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) name = Column(String)
class RbPlanningHospitalActivitis(Base): __tablename__ = 'rbPlanningHospitalActivitis' id = Column(Integer, primary_key=True) year = Column(Integer, default='0') month = Column(Integer, default='0') orgStructure_id = Column(Integer, FKey('OrgStructure.id'), index=True) profile_id = Column(Integer, FKey('rbHospitalBedProfile.id'), index=True) plan = Column(Integer, default='0') bedDays = Column(Integer, default='0')
class product_template(Base): """Шаблон продука""" __tablename__ = 'product_template' id = Column(Integer, primary_key=True) active = Column(Boolean) categ_id = Column(Integer, nullable=False) color = Column(Integer) company_id = Column(Integer, FKey('res_company.id'), index=True) company = relationship('res_company', foreign_keys='product_template.company_id') copy_needed = Column(Boolean) copy_of_id = Column(Integer) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) description = Column(Text) description_purchase = Column(Text) description_sale = Column(Text) hr_expense_ok = Column(Boolean) image = Column(Binary) image_medium = Column(Binary) image_small = Column(Binary) list_price = Column(Numeric) loc_case = Column(String) loc_rack = Column(String) loc_row = Column(String) mes_type = Column(String) message_last_post = Column(String) name = Column(String, nullable=False) produce_delay = Column(Float) product_manager = Column(Integer) purchase_ok = Column(Boolean) purchase_requisition = Column(Boolean) rental = Column(Boolean) sale_delay = Column(Float) sale_ok = Column(Boolean) state = Column(String) track_all = Column(Boolean) track_incoming = Column(Boolean) track_outgoing = Column(Boolean) track_production = Column(Boolean) type = Column(String) uom_id = Column(Integer) uom_po_id = Column(Integer) uos_coeff = Column(Numeric) uos_id = Column(Integer) volume = Column(Float) warranty = Column(Float) weight = Column(Numeric) weight_net = Column(Numeric)
class product_product(Base): """Шаблон продука""" __tablename__ = 'product_product' id = Column(Integer, primary_key=True) active = Column(Boolean) barcode = Column(String) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) default_code = Column(String) message_last_post = Column(DateTime) product_tmpl_id = Column(Integer) volume = Column(Float) weight = Column(Numeric)
class product_template(Base): """Шаблон продука""" __tablename__ = 'product_template' id = Column(Integer, primary_key=True) id_ = Column(Integer, index=True) active = Column(Boolean) can_be_expensed = Column(Boolean) # New categ_id = Column(Integer, nullable=False) color = Column(Integer) company_id = Column(Integer, FKey('res_company.id'), index=True) company = relationship('res_company', foreign_keys='product_template.company_id') create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) default_code = Column(String) # New description = Column(Text) description_picking = Column(Text) description_purchase = Column(Text) description_sale = Column(Text) expense_policy = Column(String) # New invoice_policy = Column(String) # New list_price = Column(Numeric) location_id = Column(Integer) message_last_post = Column(String) name = Column(String, nullable=False) produce_delay = Column(Float) purchase_line_warn = Column(String) # New purchase_line_warn_msg = Column(Text) # New purchase_method = Column(String) purchase_ok = Column(Boolean) purchase_requisition = Column(String) rental = Column(Boolean) sale_delay = Column(Float) sale_line_warn = Column(String) # New sale_line_warn_msg = Column(Text) # New sale_ok = Column(Boolean) sequence = Column(Integer) # New track_service = Column(String) # New tracking = Column(String) # New type = Column(String) uom_id = Column(Integer) uom_po_id = Column(Integer) volume = Column(Float) warehouse_id = Column(Integer) # New warranty = Column(Float) weight = Column(Numeric)
class sale_order_line(Base): """Позиция заказа продаж""" __tablename__ = 'sale_order_line' id = Column(Integer, primary_key=True) # address_allotment_id = Column(Integer) # client_product_name = Column(String) company_id = Column(Integer, FKey('res_company.id'), index=True) company = relationship('res_company', foreign_keys='sale_order_line.company_id') # contract_production_time = Column(Integer) # contract_shipment_date = Column(Date) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) # delay = Column(Float) currency_id = Column(Integer) # New in 10 customer_lead = Column(Float, nullable=False) # New in 10 discount = Column(Numeric) # invoiced = Column(Boolean) invoice_status = Column(String) # New in 10 layout_category_id = Column(Integer) # New in 10 layout_category_sequence = Column(Integer) # New in 10 name = Column(Text, nullable=False) order_id = Column(Integer, FKey('sale_order.id'), index=True) order = relationship('sale_order', foreign_keys='sale_order_line.order_id') order_partner_id = Column(Integer) price_reduce = Column(Numeric) price_reduce_taxexcl = Column(Numeric) price_reduce_taxinc = Column(Numeric) price_subtotal = Column(Numeric) price_tax = Column(Numeric) price_total = Column(Numeric) price_unit = Column(Numeric, nullable=False) product_id = Column(Integer, nullable=False) product_packaging = Column(Integer) product_uom = Column(Integer) product_uom_qty = Column(Numeric) # product_uos = Column(Integer) # product_uos_qty = Column(Numeric) # requisition_required = Column(Boolean) qty_delivered = Column(Numeric) qty_invoiced = Column(Numeric) qty_to_invoice = Column(Numeric) route_id = Column(Integer) salesman_id = Column(Integer) sequence = Column(Integer) state = Column(String)
class RbPayRefuseType(Base): __tablename__ = 'rbPayRefuseType' id = Column(Integer, primary_key=True) code = Column(String(8), index=True) name = Column(String(128), index=True) finance_id = Column(Integer, FKey('rbFinance.id'), index=True) rerun = Column(SmallInteger)
class RbNomenclature(Base): __tablename__ = 'rbNomenclature' id = Column(Integer, primary_key=True) group_id = Column(Integer, FKey('rbNomenclature.id'), index=True) code = Column(String(64), index=True) regionalCode = Column(String(64), index=True) name = Column(String(128), index=True)
class RbActionSheduleItem(Base): __tablename__ = 'rbActionShedule_Item' id = Column(Integer, primary_key=True) master_id = Column(Integer, FKey('rbActionShedule.id'), index=True) idx = Column(Integer) offset = Column(SmallInteger) time = Column(Time)
class crm_stage(Base): """Стадия предложения""" __tablename__ = 'crm_stage' id = Column(Integer, primary_key=True) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) fold = Column(Boolean) legend_priority = Column(Text) name = Column(String, nullable=False) on_change = Column(Boolean) probability = Column(Float) requirements = Column(Text) sequence = Column(Integer) team_id = Column(Integer)
class RbTissueType(Base): __tablename__ = 'rbTissueType' id = Column(Integer, primary_key=True) code = Column(String(64), index=True) name = Column(String(128)) group_id = Column(Integer, FKey('rbTissueType.id'), index=True) sex = Column(SmallInteger, default='0')
class RbThesaurus(Base): __tablename__ = 'rbThesaurus' id = Column(Integer, primary_key=True) code = Column(String(30), index=True) name = Column(String(255)) group_id = Column(Integer, FKey('rbThesaurus.id'), index=True) template = Column(String(255))
class RbTempInvalidRegime(Base): __tablename__ = 'rbTempInvalidRegime' id = Column(Integer, primary_key=True) code = Column(String(8), index=True) name = Column(String(64), index=True) type = Column(SmallInteger, default='0') doctype_id = Column(Integer, FKey('rbTempInvalidDocument.id'), index=True)
class RbServiceProfile(Base): __tablename__ = 'rbService_Profile' id = Column(Integer, primary_key=True) idx = Column(Integer, default='0') master_id = Column(Integer, FKey('rbService.id'), index=True) speciality_id = Column(Integer, FKey('rbSpeciality.id'), index=True) sex = Column(SmallInteger) age = Column(String(9)) age_bu = Column(SmallInteger) age_bc = Column(SmallInteger) age_eu = Column(SmallInteger) age_ec = Column(SmallInteger) mkbRegExp = Column(String(64)) medicalAidProfile_id = Column(Integer, FKey('rbMedicalAidProfile.id'), index=True)
class crm_case_stage(Base): """Статусы Предложений""" __tablename__ = 'crm_case_stage' id = Column(Integer, primary_key=True) create_date = Column(DateTime) create_uid = Column(Integer, FKey('res_users.id'), index=True) write_date = Column(DateTime) write_uid = Column(Integer, FKey('res_users.id'), index=True) case_default = Column(Boolean) requirements = Column(Text) name = Column(String, nullable=False) probability = Column(Float) sequence = Column(Integer) on_change = Column(Boolean) fold = Column(Boolean) state = Column(String) type = Column(String, nullable=False)
class RbAPTableField(Base): __tablename__ = 'rbAPTableField' id = Column(Integer, primary_key=True) idx = Column(Integer) master_id = Column(Integer, FKey('rbAPTable.id'), index=True) name = Column(String(256)) fieldName = Column(String(256)) referenceTable = Column(String(256))
class RbBlankActions(Base): __tablename__ = 'rbBlankActions' id = Column(Integer, primary_key=True) code = Column(String(16), index=True) name = Column(String(64), index=True) doctype_id = Column(Integer, FKey('ActionType.id'), index=True) checkingSerial = Column(SmallInteger) checkingNumber = Column(SmallInteger) checkingAmount = Column(SmallInteger)
class RbBlankTempInvalids(Base): __tablename__ = 'rbBlankTempInvalids' id = Column(Integer, primary_key=True) code = Column(String(16), index=True) name = Column(String(64), index=True) doctype_id = Column(Integer, FKey('rbTempInvalidDocument.id'), index=True) checkingSerial = Column(SmallInteger) checkingNumber = Column(SmallInteger) checkingAmount = Column(SmallInteger)
class RbTestTubeType(Base): __tablename__ = 'rbTestTubeType' id = Column(Integer, primary_key=True) code = Column(String(64), index=True) name = Column(String(128), index=True) volume = Column(Float) unit_id = Column(Integer, FKey('rbUnit.id'), index=True) covCol = Column(String(64)) image = Column(Binary) color = Column(String(8))
class RbResult(Base): __tablename__ = 'rbResult' id = Column(Integer, primary_key=True) code = Column(String(8), index=True) name = Column(String(64), index=True) eventPurpose_id = Column(Integer, FKey('rbEventTypePurpose.id'), index=True) continued = Column(SmallInteger) regionalCode = Column(String(8))
class res_country_state(Base): """Страны""" __tablename__ = 'res_country_state' id = Column(Integer, primary_key=True) code = Column(String(3)) country_id = Column(Integer, FKey('res_country.id'), index=True) create_date = Column(DateTime) create_uid = Column(Integer) write_date = Column(DateTime) write_uid = Column(Integer) name = Column(String)
class RbDocumentType(Base): __tablename__ = 'rbDocumentType' id = Column(Integer, primary_key=True) code = Column(String(8), index=True) name = Column(String(64), index=True) regionalCode = Column(String(16)) group_id = Column(Integer, FKey('rbDocumentTypeGroup.id'), index=True) serial_format = Column(Integer) number_format = Column(Integer) federalCode = Column(String(8)) socCode = Column(String(8), index=True) TFOMSCode = Column(Integer)
class RbOperationType(Base): __tablename__ = 'rbOperationType' id = Column(Integer, primary_key=True) cd_r = Column(Integer) cd_subr = Column(Integer) code = Column(String(10), index=True) ktso = Column(Integer) name = Column(String(100), index=True) operationClass_id = Column(Integer, FKey('rbOperationClass.id'), index=True) TFOMSCode = Column(String(20))