class Device(Base): __tablename__ = 'devices' id = Column(Integer, primary_key=True) name = Column(String(128), nullable=False) description = Column(String(255), nullable=False) active = Column(Integer, nullable=False, server_default=text("0")) last_accept_time = Column(DateTime) last_reject_time = Column(DateTime) last_accept_nas = Column(String(128)) last_reject_nas = Column(String(128)) last_reject_message = Column(String(255)) permanent_user_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) perc_time_used = Column(Integer) perc_data_used = Column(Integer) data_used = Column(BigInteger) data_cap = Column(BigInteger) time_used = Column(Integer) time_cap = Column(Integer) time_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'")) data_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'")) realm = Column(String(100), nullable=False, server_default=text("''")) realm_id = Column(Integer) profile = Column(String(100), nullable=False, server_default=text("''")) profile_id = Column(Integer) from_date = Column(DateTime) to_date = Column(DateTime)
class FinPayuTransaction(Base): __tablename__ = 'fin_payu_transactions' id = Column(Integer, primary_key=True) merchant_reference = Column(String(64), nullable=False) payu_reference = Column(String(64), nullable=False) transaction_type = Column( ENUM('RESERVE', 'FINALISE', 'PAYMENT', 'EFFECT_STAGING', 'CREDIT', 'RESERVE_CANCEL', 'REGISTER_LINK'), server_default=text("'PAYMENT'")) transaction_state = Column( ENUM('NEW', 'PROCESSING', 'SUCCESSFUL', 'FAILED'), server_default=text("'NEW'")) result_code = Column(Integer) result_message = Column(String(255)) display_message = Column(String(255)) merchant_user_id = Column(String(255)) email = Column(String(255)) mobile = Column(String(255)) regional_id = Column(String(255)) first_name = Column(String(255)) last_name = Column(String(255)) amount_in_cents = Column(Integer, nullable=False) currency_code = Column(String(255), server_default=text("'ZAR'")) description = Column(String(255), nullable=False) product_code = Column(String(255), nullable=False) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class MeshEntry(Base): __tablename__ = 'mesh_entries' id = Column(Integer, primary_key=True) mesh_id = Column(Integer) name = Column(String(128), nullable=False) hidden = Column(Integer, nullable=False, server_default=text("0")) isolate = Column(Integer, nullable=False, server_default=text("0")) apply_to_all = Column(Integer, nullable=False, server_default=text("0")) encryption = Column( ENUM('none', 'wep', 'psk', 'psk2', 'wpa', 'wpa2'), server_default=text("'none'")) special_key = Column( String(100), nullable=False, server_default=text("''")) auth_server = Column( String(255), nullable=False, server_default=text("''")) auth_secret = Column( String(255), nullable=False, server_default=text("''")) dynamic_vlan = Column(Integer, nullable=False, server_default=text("0")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) chk_maxassoc = Column(Integer, nullable=False, server_default=text("0")) maxassoc = Column(Integer, server_default=text("100")) macfilter = Column( ENUM('disable', 'allow', 'deny'), server_default=text("'disable'")) permanent_user_id = Column(Integer, nullable=False)
class FinPayUTransaction(Base): __tablename__ = 'fin_pay_u_transactions' id = Column(Integer, primary_key=True) user_id = Column(Integer) voucher_id = Column(Integer) top_up_id = Column(Integer) merchantReference = Column(String(64), nullable=False) payUReference = Column(String(64), nullable=False) TransactionType = Column( ENUM('RESERVE', 'FINALISE', 'PAYMENT', 'EFFECT_STAGING', 'CREDIT', 'RESERVE_CANCEL', 'REGISTER_LINK'), server_default=text("'PAYMENT'")) TransactionState = Column( ENUM('NEW', 'PROCESSING', 'SUCCESSFUL', 'FAILED', 'TIMEOUT'), server_default=text("'NEW'")) ResultCode = Column(Integer) ResultMessage = Column(String(255)) DisplayMessage = Column(String(255)) merchUserId = Column(String(255)) firstName = Column(String(255)) lastName = Column(String(255)) email = Column(String(255)) mobile = Column(String(255)) regionalId = Column(String(255)) amountInCents = Column(Integer, nullable=False) currencyCode = Column(String(255), server_default=text("'ZAR'")) description = Column(String(255), nullable=False) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class NodeIbssConnection(Base): __tablename__ = 'node_ibss_connections' id = Column(Integer, primary_key=True) node_id = Column(Integer) station_node_id = Column(Integer) vendor = Column(String(255)) mac = Column(String(17), nullable=False) tx_bytes = Column(BigInteger, nullable=False) rx_bytes = Column(BigInteger, nullable=False) tx_packets = Column(Integer, nullable=False) rx_packets = Column(Integer, nullable=False) tx_bitrate = Column(Integer, nullable=False) rx_bitrate = Column(Integer, nullable=False) tx_extra_info = Column(String(255), nullable=False) rx_extra_info = Column(String(255), nullable=False) authenticated = Column(ENUM('yes', 'no'), server_default=text("'no'")) authorized = Column(ENUM('yes', 'no'), server_default=text("'no'")) tdls_peer = Column(String(255), nullable=False) preamble = Column(ENUM('long', 'short'), server_default=text("'long'")) tx_failed = Column(Integer, nullable=False) inactive_time = Column(Integer, nullable=False) WMM_WME = Column(ENUM('yes', 'no'), server_default=text("'no'")) tx_retries = Column(Integer, nullable=False) MFP = Column(ENUM('yes', 'no'), server_default=text("'no'")) signal = Column(Integer, nullable=False) signal_avg = Column(Integer, nullable=False) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class NodeAction(Base): __tablename__ = 'node_actions' id = Column(Integer, primary_key=True) node_id = Column(Integer, nullable=False) action = Column(ENUM('execute'), server_default=text("'execute'")) command = Column(String(500), server_default=text("''")) status = Column(ENUM('awaiting', 'fetched', 'replied'), server_default=text("'awaiting'")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class Na(Base): __tablename__ = 'nas' id = Column(Integer, primary_key=True) nasname = Column(String(128), nullable=False, index=True) shortname = Column(String(32)) nasidentifier = Column(String(64), nullable=False, server_default=text("''")) type = Column(String(30), server_default=text("'other'")) ports = Column(Integer) secret = Column(String(60), nullable=False, server_default=text("'secret'")) server = Column(String(64)) community = Column(String(50)) description = Column(String(200), server_default=text("'RADIUS Client'")) connection_type = Column(ENUM('direct', 'openvpn', 'pptp', 'dynamic'), server_default=text("'direct'")) available_to_siblings = Column(Integer, nullable=False, server_default=text("1")) record_auth = Column(Integer, nullable=False, server_default=text("0")) ignore_acct = Column(Integer, nullable=False, server_default=text("0")) dynamic_attribute = Column(String(50), nullable=False, server_default=text("''")) dynamic_value = Column(String(50), nullable=False, server_default=text("''")) monitor = Column(ENUM('off', 'ping', 'heartbeat'), server_default=text("'off'")) ping_interval = Column(Integer, nullable=False, server_default=text("600")) heartbeat_dead_after = Column(Integer, nullable=False, server_default=text("600")) last_contact = Column(DateTime) session_auto_close = Column(Integer, nullable=False, server_default=text("0")) session_dead_time = Column(Integer, nullable=False, server_default=text("3600")) on_public_maps = Column(Integer, nullable=False, server_default=text("0")) lat = Column(Float(asdecimal=True)) lon = Column(Float(asdecimal=True)) photo_file_name = Column(String(128), nullable=False, server_default=text("'logo.jpg'")) user_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class User(Base): __tablename__ = 'user' uid = Column(Integer, primary_key=True) name = Column(String(64)) idcard = Column(String(18)) sex = Column(ENUM('男', '女', '保密'))
class Func(SAFRSBase, Base): __tablename__ = 'func' name = Column(CHAR(64, 'utf8_bin'), primary_key=True, server_default=text("''")) ret = Column(TINYINT(1), nullable=False, server_default=text("'0'")) dl = Column(CHAR(128, 'utf8_bin'), nullable=False, server_default=text("''")) type = Column(ENUM('function', 'aggregate'), nullable=False)
class Voucher(Base): __tablename__ = 'vouchers' id = Column(Integer, primary_key=True) name = Column(String(64), unique=True) batch = Column(String(128), nullable=False, server_default=text("''")) status = Column( ENUM('new', 'used', 'depleted', 'expired'), server_default=text("'new'")) perc_time_used = Column(Integer) perc_data_used = Column(Integer) last_accept_time = Column(DateTime) last_reject_time = Column(DateTime) last_accept_nas = Column(String(128)) last_reject_nas = Column(String(128)) last_reject_message = Column(String(255)) user_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) extra_name = Column(String(100), nullable=False, server_default=text("''")) extra_value = Column( String(100), nullable=False, server_default=text("''")) password = Column(String(30), nullable=False, server_default=text("''")) realm = Column(String(50), nullable=False, server_default=text("''")) realm_id = Column(Integer) profile = Column(String(50), nullable=False, server_default=text("''")) profile_id = Column(Integer) expire = Column(String(10), nullable=False, server_default=text("''")) time_valid = Column(String(10), nullable=False, server_default=text("''")) data_used = Column(BigInteger) data_cap = Column(BigInteger) time_used = Column(Integer) time_cap = Column(Integer)
class DynamicClient(Base): __tablename__ = 'dynamic_clients' id = Column(Integer, primary_key=True) name = Column(String(64), nullable=False, server_default=text("''")) nasidentifier = Column( String(128), nullable=False, server_default=text("''")) calledstationid = Column( String(128), nullable=False, server_default=text("''")) last_contact = Column(DateTime) last_contact_ip = Column( String(128), nullable=False, server_default=text("''")) timezone = Column(String(255), nullable=False, server_default=text("''")) monitor = Column( ENUM('off', 'heartbeat', 'socket'), server_default=text("'off'")) session_auto_close = Column( Integer, nullable=False, server_default=text("0")) session_dead_time = Column( Integer, nullable=False, server_default=text("3600")) available_to_siblings = Column( Integer, nullable=False, server_default=text("1")) active = Column(Integer, nullable=False, server_default=text("1")) on_public_maps = Column(Integer, nullable=False, server_default=text("0")) lat = Column(Float(asdecimal=True)) lon = Column(Float(asdecimal=True)) photo_file_name = Column( String(128), nullable=False, server_default=text("'logo.jpg'")) user_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class DynamicPhoto(Base): __tablename__ = 'dynamic_photos' id = Column(Integer, primary_key=True) dynamic_detail_id = Column(Integer, nullable=False) title = Column( String(128), nullable=False, index=True, server_default=text("''")) description = Column( String(250), nullable=False, server_default=text("''")) url = Column(String(250), nullable=False, server_default=text("''")) file_name = Column( String(128), nullable=False, server_default=text("'logo.jpg'")) created = Column(DateTime) modified = Column(DateTime) active = Column(Integer, nullable=False, server_default=text("1")) fit = Column( ENUM('stretch_to_fit', 'horizontal', 'vertical', 'original', 'dynamic'), server_default=text("'stretch_to_fit'")) background_color = Column( String(7), nullable=False, server_default=text("'ffffff'")) slide_duration = Column(Integer, nullable=False, server_default=text("10")) include_title = Column(Integer, nullable=False, server_default=text("1")) include_description = Column( Integer, nullable=False, server_default=text("1"))
class ProcsPriv(SAFRSBase, Base): __tablename__ = "procs_priv" Host = Column(CHAR(60, "utf8_bin"), primary_key=True, nullable=False, server_default=text("''")) Db = Column(CHAR(64, "utf8_bin"), primary_key=True, nullable=False, server_default=text("''")) User = Column(CHAR(32, "utf8_bin"), primary_key=True, nullable=False, server_default=text("''")) Routine_name = Column(CHAR(64), primary_key=True, nullable=False, server_default=text("''")) Routine_type = Column(ENUM("FUNCTION", "PROCEDURE"), primary_key=True, nullable=False) Grantor = Column(CHAR(93, "utf8_bin"), nullable=False, index=True, server_default=text("''")) Proc_priv = Column(SET, nullable=False, server_default=text("''")) Timestamp = Column( TIMESTAMP, nullable=False, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
class FinPaymentPlan(Base): __tablename__ = 'fin_payment_plans' id = Column(Integer, primary_key=True) user_id = Column(Integer) profile_id = Column(Integer) name = Column(String(255), nullable=False) description = Column(String(255), server_default=text("''")) type = Column(ENUM('voucher', 'user'), server_default=text("'user'")) currency_code = Column( ENUM('USD', 'ZAR', 'GBP', 'EUR'), server_default=text("'ZAR'")) value = Column(Numeric(15, 2)) tax = Column(Numeric(15, 2)) active = Column(Integer, nullable=False, server_default=text("0")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class PermanentUser(Base): __tablename__ = 'permanent_users' id = Column(Integer, primary_key=True) username = Column(String(255), nullable=False) password = Column(String(50), nullable=False) token = Column(String(36)) name = Column(String(50), nullable=False) surname = Column(String(50), nullable=False) address = Column(String(255), nullable=False) phone = Column(String(50), nullable=False) email = Column(String(100), nullable=False) auth_type = Column(String(128), nullable=False, server_default=text("'sql'")) active = Column(Integer, nullable=False, server_default=text("0")) last_accept_time = Column(DateTime) last_reject_time = Column(DateTime) last_accept_nas = Column(String(128)) last_reject_nas = Column(String(128)) last_reject_message = Column(String(255)) perc_time_used = Column(Integer) perc_data_used = Column(Integer) data_used = Column(BigInteger) data_cap = Column(BigInteger) time_used = Column(Integer) time_cap = Column(Integer) time_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'")) data_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'")) realm = Column(String(50), nullable=False, server_default=text("''")) realm_id = Column(Integer) profile = Column(String(50), nullable=False, server_default=text("''")) profile_id = Column(Integer) from_date = Column(DateTime) to_date = Column(DateTime) track_auth = Column(Integer, nullable=False, server_default=text("0")) track_acct = Column(Integer, nullable=False, server_default=text("1")) static_ip = Column(String(50), nullable=False, server_default=text("''")) extra_name = Column(String(100), nullable=False, server_default=text("''")) extra_value = Column(String(100), nullable=False, server_default=text("''")) country_id = Column(Integer) language_id = Column(Integer) user_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class PermanentUserNotification(Base): __tablename__ = 'permanent_user_notifications' id = Column(Integer, primary_key=True) permanent_user_id = Column(Integer) active = Column(Integer, nullable=False, server_default=text("1")) method = Column(ENUM('whatsapp', 'email', 'sms'), server_default=text("'email'")) type = Column(ENUM('daily', 'usage'), server_default=text("'daily'")) address_1 = Column(String(255)) address_2 = Column(String(255)) start = Column(Integer, server_default=text("80")) increment = Column(Integer, server_default=text("10")) last_value = Column(Integer) last_notification = Column(DateTime) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class Employee(Base): __tablename__ = 'employees' emp_no = Column(Integer, primary_key=True) birth_date = Column(Date, nullable=False) first_name = Column(String(14), nullable=False) last_name = Column(String(16), nullable=False) gender = Column(ENUM('M', 'F'), nullable=False) hire_date = Column(Date, nullable=False)
class TopUpTransaction(Base): __tablename__ = 'top_up_transactions' id = Column(Integer, primary_key=True) user_id = Column(Integer) permanent_user_id = Column(Integer) permanent_user = Column(String(255)) top_up_id = Column(Integer) type = Column(ENUM('data', 'time', 'days_to_use'), server_default=text("'data'")) action = Column(ENUM('create', 'update', 'delete'), server_default=text("'create'")) radius_attribute = Column(String(30), nullable=False, server_default=text("''")) old_value = Column(String(30)) new_value = Column(String(30)) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class FinMyGateTransaction(Base): __tablename__ = 'fin_my_gate_transactions' id = Column(Integer, primary_key=True) user_id = Column(Integer) fin_my_gate_token_id = Column(Integer) status = Column( ENUM('pending', 'success', 'fail', 'submitted'), server_default=text("'pending'")) type = Column( ENUM('credit_card', 'debit_order'), server_default=text("'credit_card'")) amount = Column(Numeric(15, 2)) my_gate_reference = Column( String(255), nullable=False, server_default=text("''")) message = Column(String(255), nullable=False, server_default=text("''")) permanent_user = Column( String(255), nullable=False, server_default=text("''")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class NodeNeighbor(Base): __tablename__ = 'node_neighbors' id = Column(Integer, primary_key=True) node_id = Column(Integer) gateway = Column(ENUM('yes', 'no'), server_default=text("'no'")) neighbor_id = Column(Integer) metric = Column(Numeric(6, 4), nullable=False) hwmode = Column(String(5), server_default=text("'11g'")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class Model(Base): __tablename__ = 'model' id = Column(Integer, primary_key=True) api_key = Column(String(100), nullable=False) filename = Column(String(100), nullable=False) filepath = Column(String(200), nullable=False) learning_percent = Column(Float) learning_log = Column(String(200)) learning_status = Column(ENUM('STOP', 'LEARNING', 'COMPLETE', 'FAILURE'), nullable=False, server_default=FetchedValue()) target = Column(ENUM('BROKEN', 'POWER'), nullable=False) createdAt = Column(DateTime, nullable=False, server_default=FetchedValue()) updatedAt = Column(DateTime, nullable=False, server_default=FetchedValue()) buildingId = Column(ForeignKey('building.id'), index=True) building = relationship('Building', primaryjoin='Model.buildingId == Building.id', backref='models')
class Func(SAFRSBase, Base): __tablename__ = "func" name = Column(CHAR(64, "utf8_bin"), primary_key=True, server_default=text("''")) ret = Column(TINYINT(1), nullable=False, server_default=text("'0'")) dl = Column(CHAR(128, "utf8_bin"), nullable=False, server_default=text("''")) type = Column(ENUM("function", "aggregate"), nullable=False)
class TemplateAttribute(Base): __tablename__ = 'template_attributes' id = Column(Integer, primary_key=True) template_id = Column(Integer) attribute = Column(String(128), nullable=False) type = Column(ENUM('Check', 'Reply'), server_default=text("'Check'")) tooltip = Column(String(200), nullable=False) unit = Column(String(100), nullable=False) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class UnknownAp(Base): __tablename__ = 'unknown_aps' id = Column(Integer, primary_key=True) mac = Column(String(255), nullable=False) vendor = Column(String(255)) last_contact_from_ip = Column(String(255)) last_contact = Column(DateTime) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) new_server = Column(String(255), nullable=False, server_default=text("''")) new_server_status = Column(ENUM('awaiting', 'fetched', 'replied'), server_default=text("'awaiting'"))
class MeshExit(Base): __tablename__ = 'mesh_exits' id = Column(Integer, primary_key=True) mesh_id = Column(Integer) name = Column(String(128), nullable=False) type = Column( ENUM('bridge', 'tagged_bridge', 'nat', 'captive_portal', 'openvpn_bridge')) auto_detect = Column(Integer, nullable=False, server_default=text("0")) vlan = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) openvpn_server_id = Column(Integer)
class SocialLoginUser(Base): __tablename__ = 'social_login_users' id = Column(Integer, primary_key=True) provider = Column( ENUM('Facebook', 'Google', 'Twitter'), server_default=text("'Facebook'")) uid = Column(String(100), nullable=False, server_default=text("''")) name = Column(String(100), nullable=False, server_default=text("''")) first_name = Column(String(100), nullable=False, server_default=text("''")) last_name = Column(String(100), nullable=False, server_default=text("''")) email = Column(String(100), nullable=False, server_default=text("''")) image = Column(String(100), nullable=False, server_default=text("''")) locale = Column(String(5), nullable=False, server_default=text("''")) timezone = Column(Integer, nullable=False, server_default=text("0")) date_of_birth = Column(Date) gender = Column(ENUM('male', 'female'), server_default=text("'male'")) last_connect_time = Column(DateTime) extra_name = Column(String(100), nullable=False, server_default=text("''")) extra_value = Column( String(100), nullable=False, server_default=text("''")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class TopUp(Base): __tablename__ = 'top_ups' id = Column(Integer, primary_key=True) user_id = Column(Integer) permanent_user_id = Column(Integer) data = Column(BigInteger) time = Column(Integer) days_to_use = Column(Integer) comment = Column(String(255), nullable=False) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) type = Column(ENUM('data', 'time', 'days_to_use'), server_default=text("'data'"))
class ApProfileExit(Base): __tablename__ = 'ap_profile_exits' id = Column(Integer, primary_key=True) ap_profile_id = Column(Integer) type = Column( ENUM('bridge', 'tagged_bridge', 'nat', 'captive_portal', 'openvpn_bridge')) vlan = Column(Integer) auto_dynamic_client = Column(Integer, nullable=False, server_default=text("0")) realm_list = Column(String(128), nullable=False, server_default=text("''")) auto_login_page = Column(Integer, nullable=False, server_default=text("0")) dynamic_detail_id = Column(Integer) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False) openvpn_server_id = Column(Integer)
class DynamicDetailSocialLogin(Base): __tablename__ = 'dynamic_detail_social_logins' id = Column(Integer, primary_key=True) dynamic_detail_id = Column(Integer, nullable=False) profile_id = Column(Integer, nullable=False) realm_id = Column(Integer, nullable=False) name = Column(String(50), nullable=False) enable = Column(Integer, nullable=False, server_default=text("0")) record_info = Column(Integer, nullable=False, server_default=text("0")) special_key = Column( String(100), nullable=False, server_default=text("''")) secret = Column(String(100), nullable=False, server_default=text("''")) type = Column(ENUM('voucher', 'user'), server_default=text("'voucher'")) extra_name = Column(String(100), nullable=False, server_default=text("''")) extra_value = Column( String(100), nullable=False, server_default=text("''")) created = Column(DateTime, nullable=False) modified = Column(DateTime, nullable=False)
class People(db.Model): __tablename__ = 'people' id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(55), nullable=False) gender = db.Column(ENUM('F', 'M'), nullable=False) mobile = db.Column(db.String(30)) phone = db.Column(db.String(125)) wechat = db.Column(db.String(125)) email = db.Column(db.String(125)) attendance = db.Column(db.Integer) first_name = db.Column(db.String(155), nullable=False) last_name = db.Column(db.String(155), nullable=False) chinese_name = db.Column(db.String(60), nullable=False) start_date = db.Column(db.Date) level_id = db.Column(db.Integer) office_id = db.Column(db.Integer, db.ForeignKey('office.id')) department_id = db.Column(db.Integer, db.ForeignKey('department.id')) title_id = db.Column(db.Integer, db.ForeignKey('title.id')) logical_company_id = db.Column(db.Integer, db.ForeignKey('logical_company.id'))