class TruenasCustomerInformationModel(sa.Model): __tablename__ = 'truenas_customerinformation' id = sa.Column(sa.Integer(), primary_key=True) data = sa.Column(sa.Text()) updated_at = sa.Column(sa.DateTime()) sent_at = sa.Column(sa.DateTime(), nullable=True) form_dismissed = sa.Column(sa.Boolean())
class AlertModel(sa.Model): __tablename__ = 'system_alert' id = sa.Column(sa.Integer(), primary_key=True) node = sa.Column(sa.String(100)) source = sa.Column(sa.Text()) key = sa.Column(sa.Text()) datetime = sa.Column(sa.DateTime()) last_occurrence = sa.Column(sa.DateTime()) text = sa.Column(sa.Text()) args = sa.Column(sa.JSON(type=None)) dismissed = sa.Column(sa.Boolean()) uuid = sa.Column(sa.Text()) klass = sa.Column(sa.Text())
class DiskModel(sa.Model): __tablename__ = 'storage_disk' disk_identifier = sa.Column(sa.String(42), primary_key=True) disk_name = sa.Column(sa.String(120)) disk_subsystem = sa.Column(sa.String(10), default='') disk_number = sa.Column(sa.Integer(), default=1) disk_serial = sa.Column(sa.String(30)) disk_size = sa.Column(sa.String(20)) disk_multipath_name = sa.Column(sa.String(30)) disk_multipath_member = sa.Column(sa.String(30)) disk_description = sa.Column(sa.String(120)) disk_transfermode = sa.Column(sa.String(120), default="Auto") disk_hddstandby = sa.Column(sa.String(120), default="Always On") disk_hddstandby_force = sa.Column(sa.Boolean(), default=False) disk_advpowermgmt = sa.Column(sa.String(120), default="Disabled") disk_acousticlevel = sa.Column(sa.String(120), default="Disabled") disk_togglesmart = sa.Column(sa.Boolean(), default=True) disk_smartoptions = sa.Column(sa.String(120)) disk_expiretime = sa.Column(sa.DateTime(), nullable=True) disk_enclosure_slot = sa.Column(sa.Integer(), nullable=True) disk_passwd = sa.Column(sa.EncryptedText(), default='') disk_critical = sa.Column(sa.Integer(), nullable=True, default=None) disk_difference = sa.Column(sa.Integer(), nullable=True, default=None) disk_informational = sa.Column(sa.Integer(), nullable=True, default=None) disk_model = sa.Column(sa.String(200), nullable=True, default=None) disk_rotationrate = sa.Column(sa.Integer(), nullable=True, default=None) disk_type = sa.Column(sa.String(20), default='UNKNOWN') disk_kmip_uid = sa.Column(sa.String(255), nullable=True, default=None)
class APIKeyModel(sa.Model): __tablename__ = "account_api_key" id = sa.Column(sa.Integer(), primary_key=True) name = sa.Column(sa.String(200)) key = sa.Column(sa.Text()) created_at = sa.Column(sa.DateTime())
class AlertModel(sa.Model): __tablename__ = 'system_alert' __table_args__ = ( sa.Index('system_alert_node_f77e0d77_uniq', 'node', 'klass', 'key', unique=True), ) id = sa.Column(sa.Integer(), primary_key=True) node = sa.Column(sa.String(100)) source = sa.Column(sa.Text()) key = sa.Column(sa.Text()) datetime = sa.Column(sa.DateTime()) last_occurrence = sa.Column(sa.DateTime()) text = sa.Column(sa.Text()) args = sa.Column(sa.JSON()) dismissed = sa.Column(sa.Boolean()) uuid = sa.Column(sa.Text()) klass = sa.Column(sa.Text())
class CertificateAuthorityModel(sa.Model): __tablename__ = 'system_certificateauthority' id = sa.Column(sa.Integer(), primary_key=True) cert_type = sa.Column(sa.Integer()) cert_name = sa.Column(sa.String(120), unique=True) cert_certificate = sa.Column(sa.Text(), nullable=True) cert_privatekey = sa.Column(sa.EncryptedText(), nullable=True) cert_CSR = sa.Column(sa.Text(), nullable=True) cert_revoked_date = sa.Column(sa.DateTime(), nullable=True) cert_signedby_id = sa.Column(sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True) cert_add_to_trusted_store = sa.Column(sa.Boolean(), default=False, nullable=False)
class CertificateModel(sa.Model): __tablename__ = 'system_certificate' id = sa.Column(sa.Integer(), primary_key=True) cert_type = sa.Column(sa.Integer()) cert_name = sa.Column(sa.String(120), unique=True) cert_certificate = sa.Column(sa.Text(), nullable=True) cert_privatekey = sa.Column(sa.EncryptedText(), nullable=True) cert_CSR = sa.Column(sa.Text(), nullable=True) cert_signedby_id = sa.Column( sa.ForeignKey('system_certificateauthority.id'), index=True, nullable=True) cert_acme_uri = sa.Column(sa.String(200), nullable=True) cert_domains_authenticators = sa.Column(sa.JSON(encrypted=True), nullable=True) cert_renew_days = sa.Column(sa.Integer(), nullable=True, default=10) cert_acme_id = sa.Column(sa.ForeignKey('system_acmeregistration.id'), index=True, nullable=True) cert_revoked_date = sa.Column(sa.DateTime(), nullable=True)
class SystemGeneralModel(sa.Model): __tablename__ = 'system_settings' id = sa.Column(sa.Integer(), primary_key=True) stg_guiaddress = sa.Column(sa.JSON(type=list), default=['0.0.0.0']) stg_guiv6address = sa.Column(sa.JSON(type=list), default=['::']) stg_guiallowlist = sa.Column(sa.JSON(type=list), default=[]) stg_guiport = sa.Column(sa.Integer(), default=80) stg_guihttpsport = sa.Column(sa.Integer(), default=443) stg_guihttpsredirect = sa.Column(sa.Boolean(), default=False) stg_guihttpsprotocols = sa.Column(sa.JSON(type=list), default=['TLSv1', 'TLSv1.1', 'TLSv1.2', 'TLSv1.3']) stg_guix_frame_options = sa.Column(sa.String(120), default='SAMEORIGIN') stg_guiconsolemsg = sa.Column(sa.Boolean(), default=True) stg_language = sa.Column(sa.String(120), default='en') stg_kbdmap = sa.Column(sa.String(120), default='us') stg_birthday = sa.Column(sa.DateTime(), nullable=True) stg_timezone = sa.Column(sa.String(120), default='America/Los_Angeles') stg_wizardshown = sa.Column(sa.Boolean(), default=False) stg_pwenc_check = sa.Column(sa.String(100)) stg_guicertificate_id = sa.Column(sa.ForeignKey('system_certificate.id'), index=True, nullable=True) stg_crash_reporting = sa.Column(sa.Boolean(), nullable=True) stg_usage_collection = sa.Column(sa.Boolean(), nullable=True)