AO Logo
 
  
  
  
Schema Columns
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoサーブシステムソフトウェア ··· software components ··· aoserv client ··· tables ··· public tables ··· schema columns

TABLE NAME

schema_columns

DESCRIPTION

schema_columns stores the details about the data contained in each column.

TABLE ROWS

idtablenamesinceVersionlastVersionindextypeisNullableisUniqueisPublicdescription
633ao_server_daemon_hostspkey1.0a1000pkeyfalsetruefalsea generated unique primary key
634ao_server_daemon_hostsao_server1.0a1001fkeyfalsefalsefalsethe pkey of the ao_server
636ao_server_daemon_hostshost1.80.02hostnamefalsefalsefalsethe hostname or IP address that is allowed to connect
665ao_serversserver1.0a1000fkeyfalsetruefalsea reference to servers
678ao_servershostname1.691domain_namefalsetruefalsethe unique hostname of the server
679ao_serversdaemon_bind1.0a1002fkeytruefalsefalsethe network bind info for the AOServ Daemon
682ao_serverspool_size1.0a1003intfalsefalsefalsethe recommended connection pool size for the AOServ Master
683ao_serversdistro_hour1.0a1004intfalsefalsefalsethe hour the distribution will occur, in server time zone
684ao_serverslast_distro_time1.0a1005timetruefalsefalsethe time the last distro check was started
685ao_serversfailover_server1.0a1006fkeytruefalsefalsethe server that is currently running this server
690ao_serversdaemonDeviceId1.81.187stringfalsefalsefalsethe device name the master connects to
698ao_serversdaemon_connect_bind1.0a1198fkeytruefalsefalsethe bind to connect to
699ao_serverstime_zone1.29stringtruefalsefalsethe time zone setting for the server
700ao_serversjilter_bind1.710fkeytruefalsefalsethe bind that sendmail uses to connect to jilter
701ao_serversrestrict_outbound_email1.811booleanfalsefalsefalsecontrols if outbound email may only come from address hosted on this machine
703ao_serversdaemon_connect_address1.6912hostnametruefalsefalseprovides a specific hostname or address to use for connecting to AOServDaemon
704ao_serversfailover_batch_size1.1213intfalsefalsefalsethe batch size used for failover replications coming from this server
705ao_serversmonitoring_load_low1.3514floattruefalsefalsethe 5-minute load average that will trigger a low-level alert
706ao_serversmonitoring_load_medium1.3515floattruefalsefalsethe 5-minute load average that will trigger a medium-level alert
707ao_serversmonitoring_load_high1.3516floattruefalsefalsethe 5-minute load average that will trigger a high-level alert
708ao_serversmonitoring_load_critical1.3517floattruefalsefalsethe 5-minute load average that will trigger a critical-level alert
710ao_serversuidMin1.81.1818linux_idfalsefalsefalsethe min value for automatic uid selection in useradd
712ao_serversgidMin1.81.1819linux_idfalsefalsefalsethe min value for automatic gid selection in groupadd
713ao_serversuidMax1.81.1820linux_idfalsefalsefalsethe max value for automatic uid selection in useradd
714ao_serversgidMax1.81.1821linux_idfalsefalsefalsethe max value for automatic gid selection in groupadd
715ao_serverslastUid1.81.1822linux_idtruefalsefalsethe last value for automatic uid selection in useradd, if any
716ao_serverslastGid1.81.1823linux_idtruefalsefalsethe last value for automatic gid selection in groupadd, if any
717ao_serverssftp_umask1.81.524octal_longtruefalsefalsethe optional umask for the sftp-server
772aoserv_permissionsname1.210stringfalsetruetruethe unique name of the permission
773aoserv_permissionssort_order1.211shortfalsetruetruethe sort order for the permission
1316aoserv_protocolsversion1.0a1010stringfalsetruetruethe unique version number
1317aoserv_protocolscreated1.0a1011datefalsefalsetruethe time the version was added
1318aoserv_protocolscomments1.0a1012stringfalsefalsetrueany comments about this version
1320aoserv_protocolslastUsed1.81.183datetruefalsetruethe date this protocol was last used
127aosh_commandscommand1.0a1000stringfalsetruetruethe unique command
128aosh_commandssinceVersion1.81.181stringfalsefalsetruethe first aoserv_protocol version having this command
129aosh_commandslastVersion1.81.182stringtruefalsetruethe last aoserv_protocol version having this command
131aosh_commandstable1.81.183stringtruefalsetruethe name of the table the column is in, is a global command if the column is null
133aosh_commandsdescription1.81.184stringfalsefalsetruea short description of the command
134aosh_commandssyntax1.0a1005stringfalsefalsetruethe syntax of the command
332architecturesname1.0a1000stringfalsetruetruethe unique name of the architecture
333architecturesbits1.0a1081intfalsefalsetruethe number of bits used by the architecture
137backup_partitionspkey1.0a1000pkeyfalsetruefalsea generated primary key
138backup_partitionsao_server1.0a1001fkeyfalsefalsefalsethe pkey of the server that stores the backup data
140backup_partitionspath1.0a1002pathfalsefalsefalsethe full path to the root of the backup data
143backup_partitionsenabled1.0a1003booleanfalsefalsefalseflags the partition as currently accepting new data
145backup_reportspkey1.0a1010pkeyfalsetruefalsea generated primary key
146backup_reportsserver1.0a1011fkeyfalsefalsefalsethe pkey of the server being backed-up
147backup_reportspackage1.0a1012fkeyfalsefalsefalsethe pkey of the package the data is assigned to
148backup_reportsdate1.0a1013datefalsefalsefalsethe date the summary is for
149backup_reportsfile_count1.0a1014intfalsefalsefalsethe number of files belong to this package on this server
152backup_reportsdisk_size1.0a1015longfalsefalsefalsethe total number of bytes of disk space used
153backup_retentionsdays1.0a1000shortfalsetruetruethe number of days to keep the backup data
154backup_retentionsdisplay1.0a1001stringfalsefalsetruethe text displayed for this time increment
62bank_accountsname1.0a1000stringfalsetruefalsethe unique name of this account
63bank_accountsdisplay1.0a1001stringfalsefalsefalsethe display name of this account
64bank_accountsbank1.0a1002stringfalsefalsefalsethe bank the account is with
66bank_accountsdepositDelay1.81.183intfalsefalsefalsethe number of business days it takes for a deposit to be sent to the bank account
68bank_accountswithdrawalDelay1.81.184intfalsefalsefalsethe number of business days it takes for a withdrawal to be taken from the bank account
89bank_transaction_typesname1.81.180stringfalsetruefalsethe name of the type
90bank_transaction_typesdisplay1.0a1001stringfalsefalsefalsethe display value for the type
91bank_transaction_typesdescription1.0a1002stringfalsefalsefalsea description of the type
93bank_transaction_typesisNegative1.81.183booleanfalsefalsefalseif true the amount must be negative
71bank_transactionsid1.81.180pkeyfalsetruefalsea unique identifier for the transaction
72bank_transactionstime1.0a1001timefalsefalsefalsethe time the transaction occured
76bank_transactionsaccount1.81.182stringfalsefalsefalsethe account the transaction is for
78bank_transactionsprocessor1.293stringtruefalsefalsethe credit card processor used by this transaction
79bank_transactionsadministrator1.0a1004usernamefalsefalsefalsethe business_administrator who made this transaction
80bank_transactionstype1.0a1005stringfalsefalsefalsethe type of transaction
82bank_transactionsexpenseCategory1.81.186stringtruefalsefalsethe category in which this expense belongs
83bank_transactionsdescription1.0a1007stringfalsefalsefalsea description of the transaction
85bank_transactionscheckNo1.81.188stringtruefalsefalsethe check number (if available)
86bank_transactionsamount1.0a1009decimal_2falsefalsefalsethe amount (negative for withdrawal)
87bank_transactionsconfirmed1.0a10010booleanfalsefalsefalsethe confirmation status with bank
69banksname1.0a1000stringfalsetruefalsethe unique name of the bank
70banksdisplay1.0a1001stringfalsefalsefalsethe name that is displayed
410blackhole_email_addressesemail_address1.0a1000fkeyfalsetruefalsethe primary key of the email_address
1263brandsaccounting1.440accountingfalsetruefalse
1265brandsnameserver11.691domain_namefalsefalsefalse
1267brandsnameserver21.692domain_namefalsefalsefalse
1269brandsnameserver31.693domain_nametruefalsefalse
1271brandsnameserver41.694domain_nametruefalsefalse
1272brandssmtp_linux_server_account1.445fkeyfalsetruefalse
1273brandssmtp_host1.466hostnametruefalsefalse
1274brandssmtp_password1.447stringfalsefalsefalse
1275brandsimap_linux_server_account1.448fkeyfalsetruefalse
1276brandsimap_host1.469hostnametruefalsefalse
1277brandsimap_password1.4410stringfalsefalsefalse
1278brandssupport_email_address1.4411fkeyfalsetruefalse
1279brandssupport_email_display1.4412stringfalsetruefalse
1280brandssignup_email_address1.4413fkeyfalsetruefalse
1281brandssignup_email_display1.4414stringfalsetruefalse
1282brandsticket_encryption_from1.4415fkeyfalsefalsefalse
1283brandsticket_encryption_recipient1.4416fkeyfalsefalsefalse
1284brandssignup_encryption_from1.4417fkeyfalsefalsefalse
1285brandssignup_encryption_recipient1.4418fkeyfalsefalsefalse
1287brandssupport_toll_free1.6919phonetruefalsefalse
1289brandssupport_day_phone1.6920phonetruefalsefalse
1291brandssupport_emergency_phone11.6921phonetruefalsefalse
1293brandssupport_emergency_phone21.6922phonetruefalsefalse
1295brandssupport_fax1.6923phonetruefalsefalse
1296brandssupport_mailing_address11.4424stringtruefalsefalse
1297brandssupport_mailing_address21.4425stringtruefalsefalse
1298brandssupport_mailing_address31.4426stringtruefalsefalse
1299brandssupport_mailing_address41.4427stringtruefalsefalse
1300brandsenglish_enabled1.4428booleanfalsefalsefalse
1301brandsjapanese_enabled1.4429booleanfalsefalsefalse
1302brandsaoweb_struts_http_url_base1.4430stringfalsefalsefalse
1303brandsaoweb_struts_https_url_base1.4431stringfalsefalsefalse
1304brandsaoweb_struts_google_verify_content1.4432stringtruefalsefalse
1305brandsaoweb_struts_noindex1.4433booleanfalsefalsefalse
1306brandsaoweb_struts_google_analytics_new_tracking_code1.4434stringtruefalsefalse
1307brandsaoweb_struts_signup_admin_address1.4435stringfalsefalsefalse
1308brandsaoweb_struts_vnc_bind1.5236fkeyfalsetruefalse
1309brandsaoweb_struts_keystore_type1.5337stringfalsefalsefalse
1310brandsaoweb_struts_keystore_password1.5338stringfalsefalsefalse
29business_administratorsusername1.0a1000usernamefalsetruefalsethe unique identifier for this admin
31business_administratorspassword1.691hashed_passwordtruefalsefalsethe encrypted password for this admin
32business_administratorsname1.0a1002stringfalsefalsefalsethe name of this admin
33business_administratorstitle1.0a1003stringtruefalsefalsethe admins title within their organization
35business_administratorsbirthday1.694datetruefalsefalsethe admins birthday
36business_administratorsis_preferred1.0a1005booleanfalsefalsefalseif true, customers is preferred
37business_administratorsprivate1.0a1006booleanfalsefalsefalseindicates if the admin should not be listed in publicly available lists
38business_administratorscreated1.0a1007timefalsefalsefalsethe time the admin entry was created
39business_administratorswork_phone1.0a1008phonefalsefalsefalsethe work phone number (if different than business)
40business_administratorshome_phone1.0a1009phonetruefalsefalsethe home phone number
41business_administratorscell_phone1.0a10010phonetruefalsefalsethe cellular phone number
42business_administratorsfax1.0a10011phonetruefalsefalsethe fax number (if different than business)
43business_administratorsemail1.0a10012emailfalsefalsefalsethe email address
44business_administratorsaddress11.0a10013stringtruefalsefalsethe street address (if different than business)
45business_administratorsaddress21.0a10014stringtruefalsefalsethe street address (if different than business)
47business_administratorscity1.6915stringtruefalsefalsethe city (if different than business)
49business_administratorsstate1.6916stringtruefalsefalsethe state (if different than business)
51business_administratorscountry1.6917stringtruefalsefalsethe country (if different than business)
53business_administratorszip1.6918stringtruefalsefalsethe zip code (if different than business)
54business_administratorsdisable_log1.0a10019fkeytruefalsefalseindicates that this account is disabled
55business_administratorscan_switch_users1.0a11820booleanfalsefalsefalseallows this person to switch users to any subaccounts
56business_administratorssupport_code1.4421stringtruetruefalseused to authenticate for email-based supprt
769business_administrator_permissionspkey1.210pkeyfalsetruefalsea generated primary key
770business_administrator_permissionsusername1.211usernamefalsefalsefalsethe username of the administrator with this permission
771business_administrator_permissionspermission1.212stringfalsefalsefalsethe name of the permission that has been granted
96business_profilespkey1.0a1000pkeyfalsetruefalsea unique primary key
97business_profilesaccounting1.0a1001accountingfalsefalsefalsethe accounting code of the business
98business_profilespriority1.0a1002intfalsefalsefalsethe highest priority profile is used
99business_profilesname1.0a1003stringfalsefalsefalsethe name of the business
100business_profilesprivate1.0a1004booleanfalsefalsefalseindicates if the business should not be listed in publicly available lists
101business_profilesphone1.0a1005phonefalsefalsefalsethe phone number
102business_profilesfax1.0a1006phonetruefalsefalsethe fax number
103business_profilesaddress11.0a1007stringfalsefalsefalsethe street address of the business
104business_profilesaddress21.0a1008stringtruefalsefalsethe street address of the business
106business_profilescity1.699stringfalsefalsefalsethe city
108business_profilesstate1.6910stringtruefalsefalsethe state or providence
110business_profilescountry1.6911stringfalsefalsefalsethe two-character country code
112business_profileszip1.6912stringtruefalsefalsethe zip code
113business_profilessend_invoice1.0a10013booleanfalsefalsefalseindicates to send a monthly invoice via regular mail
114business_profilescreated1.0a10014timefalsefalsefalsethe time this entry was created
115business_profilesbilling_contact1.0a10015stringfalsefalsefalsethe name to contact for billing information
116business_profilesbilling_email1.0a10016stringfalsefalsefalsethe email address to notify for billing
117business_profilesbillingEmailFormat1.81.2017stringfalsefalsefalsethe format for billing notification emails
118business_profilestechnical_contact1.0a10018stringfalsefalsefalsethe name to contact for technical information
119business_profilestechnical_email1.0a10019stringfalsefalsefalsethe email address to notify for technical
120business_profilestechnicalEmailFormat1.81.2020stringfalsefalsefalsethe format for technical notification emails
15businessesaccounting1.0a1000accountingfalsetruefalsethe unique identifier for this business.
16businessescontract_version1.0a1001stringtruefalsefalsethe version number of the contract
17businessescreated1.0a1002timefalsefalsefalsethe time the account was created
18businessescanceled1.0a1003timetruefalsefalsethe time the account was deactivated
19businessescancel_reason1.0a1004stringtruefalsefalsethe reason the account was canceled
20businessesparent1.0a1005accountingtruefalsefalsethe parent business to this one
21businessescan_add_backup_server1.0a1026booleanfalsefalsefalsethe business may add servers to the backup system
22businessescan_add_businesses1.0a1007booleanfalsefalsefalseif <code>true</code> this business can create and be the parent of other businesses
24businessescan_see_prices1.0a1038booleanfalsefalsefalseif <code>false</code>, prices are filtered
25businessesdisable_log1.0a1009fkeytruefalsefalseindicates the business is disabled
26businessesdo_not_disable_reason1.0a10010stringtruefalsefalsea reason why we should not disable the account
27businessesauto_enable1.0a10011booleanfalsefalsefalseallows the account to be automatically reenabled on payment
28businessesbill_parent1.0a10012booleanfalsefalsefalseif <code>true</code>, the parent business will be charged for all resources used by this account
1business_serverspkey1.0a1000pkeyfalsetruefalsea generated primary key
2business_serversaccounting1.0a1001accountingfalsefalsefalsethe business
3business_serversserver1.0a1002fkeyfalsefalsefalsethe server
4business_serversis_default1.0a1003booleanfalsefalsefalseif <code>true</code>, this is the default server.
6business_serverscan_control_apache1.0a1004booleanfalsefalsefalse
7business_serverscan_control_cron1.0a1005booleanfalsefalsefalse
9business_serverscan_control_mysql1.0a1006booleanfalsefalsefalse
10business_serverscan_control_postgresql1.0a1007booleanfalsefalsefalse
11business_serverscan_control_xfs1.0a1008booleanfalsefalsefalse
12business_serverscan_control_xvfb1.0a1009booleanfalsefalsefalse
13business_serverscan_vnc_console1.5110booleanfalsefalsefalse
14business_serverscan_control_virtual_server1.6411booleanfalsefalsefalse
1011country_codescode1.690stringfalsetruetruethe two-character code for the country
1012country_codesname1.0a1001stringfalsefalsetruethe name of the country
1013country_codescharge_com_supported1.0a1002booleanfalsefalsetrueif the country is supported by Charge.Com
1014country_codescharge_com_name1.0a1003stringtruefalsetruethe Charge.Com specific name
1175credit_card_processorsprovider_id1.290stringfalsetruefalsethe unique ID of this processor
1176credit_card_processorsaccounting1.291accountingfalsefalsefalsethe accounting code of the business owning the merchant account
1177credit_card_processorsclass_name1.292stringfalsefalsefalsethe classname of the Java code that connects to the merchant services provider
1178credit_card_processorsparam11.293stringtruefalsefalsethe optional parameters for the Java code that connects to the merchant services provider
1179credit_card_processorsparam21.294stringtruefalsefalsethe optional parameters for the Java code that connects to the merchant services provider
1180credit_card_processorsparam31.295stringtruefalsefalsethe optional parameters for the Java code that connects to the merchant services provider
1181credit_card_processorsparam41.296stringtruefalsefalsethe optional parameters for the Java code that connects to the merchant services provider
1182credit_card_processorsenabled1.297booleanfalsefalsefalsethe enabled flag
1183credit_card_processorsweight1.298intfalsefalsefalsethe weight used for multi-processor weighted transaction distribution
1184credit_card_processorsdescription1.299stringtruefalsefalsean optional description of the processor
1185credit_card_processorsencryption_from1.3110fkeyfalsefalsefalsethe from that will be used for encryption
1186credit_card_processorsencryption_recipient1.3111fkeyfalsefalsefalsethe recipient that will be used for encryption
1064credit_card_transactionspkey1.290pkeyfalsetruefalsethe unique ID of this transaction
1065credit_card_transactionsprocessor_id1.291stringfalsefalsefalsethe name of the processor used for this transaction
1066credit_card_transactionsaccounting1.292accountingfalsefalsefalsethe accounting code for the source of this transaction
1067credit_card_transactionsgroup_name1.293stringtruefalsefalsethe application-provided grouping for this transaction
1068credit_card_transactionstest_mode1.294booleanfalsefalsefalseindicates this is a test transaction
1069credit_card_transactionsduplicate_window1.295intfalsefalsefalsethe number of seconds for duplicate transaction detection
1070credit_card_transactionsorder_number1.296stringtruefalsefalsethe merchant-provided order number for this transaction
1074credit_card_transactionsamount1.83.07moneyfalsefalsefalsethe amount of the transaction
1077credit_card_transactionstaxAmount1.83.08moneytruefalsefalsethe tax amount of the transaction
1078credit_card_transactionstax_exempt1.299booleanfalsefalsefalsethe taxExempt flag for this transaction
1081credit_card_transactionsshippingAmount1.83.010moneytruefalsefalsethe shipping amount for this transaction
1084credit_card_transactionsdutyAmount1.83.011moneytruefalsefalsethe duty amount for this transaction
1085credit_card_transactionsshipping_first_name1.2912stringtruefalsefalsethe shipping first name
1086credit_card_transactionsshipping_last_name1.2913stringtruefalsefalsethe shipping last name
1087credit_card_transactionsshipping_company_name1.2914stringtruefalsefalsethe shipping company name
1088credit_card_transactionsshipping_street_address11.2915stringtruefalsefalsethe shipping address line 1
1089credit_card_transactionsshipping_street_address21.2916stringtruefalsefalsethe shipping address line 2
1091credit_card_transactionsshipping_city1.6917stringtruefalsefalsethe shipping city
1093credit_card_transactionsshipping_state1.6918stringtruefalsefalsethe shipping state
1095credit_card_transactionsshipping_postal_code1.6919stringtruefalsefalsethe shipping postal code
1097credit_card_transactionsshipping_country_code1.6920stringtruefalsefalsethe shipping two-digit ISO 3166-1 alpha-2 country code
1098credit_card_transactionsemail_customer1.2921booleanfalsefalsefalsethe flag indicating the API should generate an email to the customer
1099credit_card_transactionsmerchant_email1.2922emailtruefalsefalsethe email address of the merchant
1100credit_card_transactionsinvoice_number1.2923stringtruefalsefalsethe merchant-provided invoice number
1101credit_card_transactionspurchase_order_number1.2924stringtruefalsefalsethe merchant-provided purchase order number
1102credit_card_transactionsdescription1.2925stringtruefalsefalsethe merchant-provided description of this transaction
1103credit_card_transactionscredit_card_created_by1.2926usernamefalsefalsefalsethe business administrator account that provided this credit card
1104credit_card_transactionscredit_card_principal_name1.2927stringtruefalsefalsethe application-provided principal who provided this credit card
1105credit_card_transactionscredit_card_accounting1.2928accountingfalsefalsefalsethe accounting code of the business that provided this credit card
1106credit_card_transactionscredit_card_group_name1.2929stringtruefalsefalseany application-specific grouping
1107credit_card_transactionscredit_card_provider_unique_id1.2930stringtruefalsefalsethe unique ID provided by the merchant services provider storage mechanism
1108credit_card_transactionscredit_card_masked_card_number1.2931stringfalsefalsefalsethe masked card number
1109credit_card_transactionscreditCard.expirationMonth1.82.032shorttruefalsefalsethe card expiration month
1110credit_card_transactionscreditCard.expirationYear1.82.033shorttruefalsefalsethe card expiration year
1111credit_card_transactionscredit_card_first_name1.2934stringfalsefalsefalsethe first name of the card holder
1112credit_card_transactionscredit_card_last_name1.2935stringfalsefalsefalsethe last name of the card holder
1113credit_card_transactionscredit_card_company_name1.2936stringtruefalsefalsethe company name for the credit card
1114credit_card_transactionscredit_card_email1.2937emailtruefalsefalsethe email address of the card holder
1115credit_card_transactionscredit_card_phone1.2938phonetruefalsefalsethe phone number of the card holder
1116credit_card_transactionscredit_card_fax1.2939phonetruefalsefalsethe fax number of the card holder
1117credit_card_transactionscreditCard.customerId1.82.140stringtruefalsefalsethe merchant-specific unique customer ID
1118credit_card_transactionscredit_card_customer_tax_id1.2941stringtruefalsefalsethe tax ID of the card holder
1119credit_card_transactionscredit_card_street_address11.2942stringfalsefalsefalsethe street address of the card holder (line 1)
1120credit_card_transactionscredit_card_street_address21.2943stringtruefalsefalsethe street address of the card holder (line 2)
1122credit_card_transactionscredit_card_city1.6944stringfalsefalsefalsethe city of the card holder
1124credit_card_transactionscredit_card_state1.6945stringtruefalsefalsethe state/province/prefecture of the card holder
1126credit_card_transactionscredit_card_postal_code1.6946stringtruefalsefalsethe postal code of the card holder
1128credit_card_transactionscredit_card_country_code1.6947stringfalsefalsefalsethe two-digit ISO 3166-1 alpha-2 country code of the card holder
1129credit_card_transactionscredit_card_comments1.2948stringtruefalsefalseany comments associated with the credit card
1130credit_card_transactionsauthorization_time1.2949timefalsefalsefalsethe time the authorization was attempted
1131credit_card_transactionsauthorization_username1.2950usernamefalsefalsefalsethe username of the business_administrator account that processed the transaction
1132credit_card_transactionsauthorization_principal_name1.2951stringtruefalsefalsean application-provided identity of the user who initiated the transaction
1133credit_card_transactionsauthorization_communication_result1.2952stringtruefalsefalsethe authorization communication result
1134credit_card_transactionsauthorization_provider_error_code1.2953stringtruefalsefalsethe provider-specific error code
1135credit_card_transactionsauthorization_error_code1.2954stringtruefalsefalsethe provider-neutral error code
1136credit_card_transactionsauthorization_provider_error_message1.2955stringtruefalsefalsethe provider-specific error message
1137credit_card_transactionsauthorization_provider_unique_id1.2956stringtruefalsefalsethe per-provider unique ID
1138credit_card_transactionsauthorizationResult.providerReplacementMaskedCardNumber1.82.057stringtruefalsefalsethe provider-specific replacement masked card number
1139credit_card_transactionsauthorizationResult.replacementMaskedCardNumber1.82.058stringtruefalsefalsethe replacement masked card number
1140credit_card_transactionsauthorizationResult.providerReplacementExpiration1.82.059stringtruefalsefalsethe provider-specific replacement expiration date
1141credit_card_transactionsauthorizationResult.replacementExpirationMonth1.82.060shorttruefalsefalsethe replacement card expiration month
1142credit_card_transactionsauthorizationResult.replacementExpirationYear1.82.061shorttruefalsefalsethe replacement card expiration year
1143credit_card_transactionsauthorization_provider_approval_result1.2962stringtruefalsefalsethe provider-specific approval result
1144credit_card_transactionsauthorization_approval_result1.2963stringtruefalsefalsethe provider-neutral approval result
1145credit_card_transactionsauthorization_provider_decline_reason1.2964stringtruefalsefalsethe provider-specific decline reason
1146credit_card_transactionsauthorization_decline_reason1.2965stringtruefalsefalsethe provider-neutral decline reason
1147credit_card_transactionsauthorization_provider_review_reason1.2966stringtruefalsefalsethe provider-specific review reason
1148credit_card_transactionsauthorization_review_reason1.2967stringtruefalsefalsethe provider-neutral review reason
1149credit_card_transactionsauthorization_provider_cvv_result1.2968stringtruefalsefalsethe provider-specific CVV result
1150credit_card_transactionsauthorization_cvv_result1.2969stringtruefalsefalsethe provider-neutral CVV result
1151credit_card_transactionsauthorization_provider_avs_result1.2970stringtruefalsefalsethe provider-specific AVS result
1152credit_card_transactionsauthorization_avs_result1.2971stringtruefalsefalsethe provider-neutral AVS result
1153credit_card_transactionsauthorization_approval_code1.2972stringtruefalsefalsethe approval code
1154credit_card_transactionscapture_time1.2973timetruefalsefalsethe time the capture was attempted
1155credit_card_transactionscapture_username1.2974usernametruefalsefalsethe username of the business_administrator account that processed the capture
1156credit_card_transactionscapture_principal_name1.2975stringtruefalsefalsean application-provided identity of the user who initiated the capture
1157credit_card_transactionscapture_communication_result1.2976stringtruefalsefalsethe capture communication result
1158credit_card_transactionscapture_provider_error_code1.2977stringtruefalsefalsethe provider-specific error code
1159credit_card_transactionscapture_error_code1.2978stringtruefalsefalsethe provider-neutral error code
1160credit_card_transactionscapture_provider_error_message1.2979stringtruefalsefalsethe provider-specific error message
1161credit_card_transactionscapture_provider_unique_id1.2980stringtruefalsefalsethe per-provider unique ID
1162credit_card_transactionsvoid_time1.2981timetruefalsefalsethe time the void was attempted
1163credit_card_transactionsvoid_username1.2982usernametruefalsefalsethe username of the business_administrator account that processed the void
1164credit_card_transactionsvoid_principal_name1.2983stringtruefalsefalsean application-provided identity of the user who initiated the void
1165credit_card_transactionsvoid_communication_result1.2984stringtruefalsefalsethe void communication result
1166credit_card_transactionsvoid_provider_error_code1.2985stringtruefalsefalsethe provider-specific error code
1167credit_card_transactionsvoid_error_code1.2986stringtruefalsefalsethe provider-neutral error code
1168credit_card_transactionsvoid_provider_error_message1.2987stringtruefalsefalsethe provider-specific error message
1169credit_card_transactionsvoid_provider_unique_id1.2988stringtruefalsefalsethe per-provider unique ID
1170credit_card_transactionsstatus1.2989stringfalsefalsefalsethe status of the transaction
1015credit_cardspkey1.0a1000pkeyfalsetruefalseprimary key value
1016credit_cardsprocessor_id1.291stringfalsefalsefalsethe unique ID of the merchant services provider that is storing the card number and expiration date
1017credit_cardsaccounting1.0a1002accountingfalsefalsefalsethe accounting code for the card
1018credit_cardsgroup_name1.293stringtruefalsefalseany application-specific grouping
1020credit_cardscard_info1.0a1004stringfalsefalsefalsethe masked card number
1021credit_cardsexpirationMonth1.82.05shorttruefalsefalsethe card expiration month
1022credit_cardsexpirationYear1.82.06shorttruefalsefalsethe card expiration year
1023credit_cardsprovider_unique_id1.297stringfalsefalsefalsethe per-provider unique ID allowing use of this credit card for new transactions
1027credit_cardsfirst_name1.298stringfalsefalsefalsethe first name
1028credit_cardslast_name1.299stringfalsefalsefalsethe last name
1029credit_cardscompany_name1.2910stringtruefalsefalsethe company name
1030credit_cardsemail1.2911emailtruefalsefalsethe email address
1031credit_cardsphone1.2912phonetruefalsefalsethe daytime phone number
1032credit_cardsfax1.2913phonetruefalsefalsethe fax number
1033credit_cardscustomerId1.82.114stringtruefalsefalsethe merchant-specific unique customer ID
1034credit_cardscustomer_tax_id1.2915stringtruefalsefalsethe social security number of employer identification number
1036credit_cardsstreet_address11.2916stringfalsefalsefalsethe first line of the street address
1037credit_cardsstreet_address21.2917stringtruefalsefalsethe second line of the street address
1040credit_cardscity1.6918stringfalsefalsefalsethe card holders city
1043credit_cardsstate1.6919stringtruefalsefalsethe card holders state
1046credit_cardspostal_code1.6920stringtruefalsefalsethe card holders postal code
1048credit_cardscountry_code1.6921stringfalsefalsefalsethe two-character country code
1049credit_cardscreated1.0a10022timefalsefalsefalsethe time the card was added to the database
1050credit_cardscreated_by1.0a10023usernamefalsefalsefalsethe business_administrator who added the card to the database
1051credit_cardsprincipal_name1.2924stringtruefalsefalsethe application-provided principal name of the person added the card to the database
1052credit_cardsuse_monthly1.0a10025booleanfalsefalsefalseif <code>true</code> the card will be used monthly
1053credit_cardsactive1.0a10026booleanfalsefalsefalseif <code>true</code> the card is currently active
1054credit_cardsdeactivated_on1.0a10027timetruefalsefalsethe time the card was deactivated
1055credit_cardsdeactivate_reason1.0a10028stringtruefalsefalsethe reason the card was deactivated
1057credit_cardsdescription1.0a10029stringtruefalsefalseany comment or description
1058credit_cardsencrypted_card_number1.3130stringtruefalsefalsethe card number stored encrypted
1059credit_cardsencryption_card_number_from1.3131fkeytruefalsefalsethe from that was used for card number encryption
1060credit_cardsencryption_card_number_recipient1.3132fkeytruefalsefalsethe recipient that was used for card number encryption
208CurrencycurrencyCode1.83.00stringfalsetruetruethe ISO 4217 currency code of this currency
209CurrencyfractionDigits1.83.01shortfalsefalsetruethe number of fraction digits used with this currency
210CurrencyautoEnableMinimumPayment1.83.02moneyfalsefalsetruethe minimum payment for auto-enabling accounts
1374cvs_repositoriespkey1.0a1000pkeyfalsetruefalsea generated primary key
1375cvs_repositoriespath1.0a1001pathfalsefalsefalsethe full path to the repository
1376cvs_repositorieslinux_server_account1.0a1002fkeyfalsefalsefalsethe pkey of the directory owner
1377cvs_repositorieslinux_server_group1.0a1003fkeyfalsefalsefalsethe pkey of the directory group
1378cvs_repositoriesmode1.0a1004octal_longfalsefalsefalsethe directory permissions
1379cvs_repositoriescreated1.0a1005timefalsefalsefalsethe time the repository was created
1382cvs_repositoriesdisable_log1.0a1006fkeytruefalsefalseindicates that this repository is disabled
411cyrus_imapd_bindsnet_bind1.81.100fkeyfalsetruefalsethe IP address, port, and protocol details
412cyrus_imapd_bindscyrus_imapd_server1.81.101fkeyfalsefalsefalsethe server that is listening on the address
413cyrus_imapd_bindsservername1.81.102domain_nametruefalsefalsethe servername for this bind
414cyrus_imapd_bindscertificate1.81.103fkeytruefalsefalsethe certificate used by this bind
415cyrus_imapd_bindsallow_plaintext_auth1.81.104booleantruefalsefalseallows plaintext authentication (PLAIN/LOGIN) on non-TLS links
416cyrus_imapd_serversao_server1.81.100fkeyfalsetruefalsethe pkey of the server that runs this Cyrus IMAPD instance
417cyrus_imapd_serverssieve_net_bind1.81.101fkeytruetruefalsethe port the server binds to for sieve, if enabled
418cyrus_imapd_serversservername1.81.102domain_nametruefalsefalsethe servername for this server
419cyrus_imapd_serverscertificate1.81.103fkeyfalsefalsefalsethe certificate used for this server
420cyrus_imapd_serversallow_plaintext_auth1.81.104booleanfalsefalsefalseallows plaintext authentication (PLAIN/LOGIN) on non-TLS links
421cyrus_imapd_serversdelete_duration1.81.105floattruefalsefalsethe duration after which delayed delete folders are removed
422cyrus_imapd_serversdelete_duration_unit1.81.106stringtruefalsefalsethe time unit for delete_duration, one of "d", "h", "m", "s"
423cyrus_imapd_serversexpire_duration1.81.107floatfalsefalsefalseprune the duplicate database of entries older than expire-duration
424cyrus_imapd_serversexpire_duration_unit1.81.108stringtruefalsefalsethe time unit for expire_duration, one of "d", "h", "m", "s"
425cyrus_imapd_serversexpunge_duration1.81.109floattruefalsefalsethe duration after which delayed expunge messages are removed
426cyrus_imapd_serversexpunge_duration_unit1.81.1010stringtruefalsefalsethe time unit for expunge_duration, one of "d", "h", "m", "s"
57disable_logpkey1.0a1000pkeyfalsetruefalsea generated primary key
58disable_logtime1.0a1001timefalsefalsefalsethe time the stuff was disabled
59disable_logaccounting1.0a1002accountingfalsefalsefalsethe business whose resources are being disabled
60disable_logdisabled_by1.0a1003usernamefalsefalsefalsethe person who disabled the accounts
61disable_logdisable_reason1.0a1004stringtruefalsefalsethe optional reason the accounts were disabled
1789distro_file_typestype1.0a1000stringfalsetruefalsethe unique name of the type
1790distro_file_typesdescription1.0a1001stringfalsefalsefalsea description of the type of file
1769distro_filespkey1.0a1080pkeyfalsetruefalsethe unique pkey
1770distro_filesoperating_system_version1.0a1081fkeyfalsefalsefalsethe OS version that contains the file
1772distro_filespath1.0a1082pathfalsefalsefalsethe full path to the file
1773distro_filesoptional1.0a1003booleanfalsefalsefalseif the file is optional
1774distro_filestype1.0a1004stringfalsefalsefalsethe type of file
1775distro_filesmode1.0a1005octal_longfalsefalsefalsethe mode (including file type bits)
1777distro_fileslinux_account1.81.226linux_usernamefalsefalsefalsethe owner of the file
1779distro_fileslinux_group1.80.07group_idfalsefalsefalsethe group of the file
1780distro_filessize1.0a1008longtruefalsefalsethe length of the file
1784distro_filesfile_sha256_01.809longtruefalsefalsethe first 64 bits of SHA-256 hash if is a regular file
1785distro_filesfile_sha256_11.8010longtruefalsefalsethe second 64 bits of SHA-256 hash if is a regular file
1786distro_filesfile_sha256_21.8011longtruefalsefalsethe third 64 bits of SHA-256 hash if is a regular file
1787distro_filesfile_sha256_31.8012longtruefalsefalsethe fourth 64 bits of SHA-256 hash if is a regular file
1788distro_filessymlink_target1.0a10013stringtruefalsefalsethe target if is a symbolic link
1791distro_report_typesname1.700stringfalsetruefalsethe unique name of the type
1792distro_report_typesdisplay1.701stringfalsefalsefalsea display value of the type of report
365dns_forbidden_zoneszone1.0a1000zonefalsetruetruethe zone (domain) that is forbidden
366dns_recordspkey1.0a1000pkeyfalsetruefalsea generated pkey
367dns_recordszone1.0a1001zonefalsefalsefalsethe zone as found in dns_zones
369dns_recordsdomain1.692stringfalsefalsefalsethe first column in the zone files
370dns_recordstype1.0a1003stringfalsefalsefalsethe type as found in dns_types
372dns_recordspriority1.724inttruefalsefalsethe priority for the entry
373dns_recordsweight1.725inttruefalsefalsethe relative weight for records with the same priority
374dns_recordsport1.726inttruefalsefalsethe TCP or UDP port on which the service is to be found
375dns_recordsflag1.86.07shorttruefalsefalsethe CAA flag
376dns_recordstag1.86.08stringtruefalsefalsethe CAA tag
377dns_recordsdestination1.0a1009stringfalsefalsefalsethe destination, either IP address, hostname, or other value depending on the type of record
380dns_recordsdhcpAddress1.81.1810fkeytruefalsefalsethe id of the IP address whos changes are followed
381dns_recordsttl1.0a12711inttruefalsefalsethe time to live field
392dns_tldsdomain1.690domain_namefalsetruetruethe domain
393dns_tldsdescription1.0a1001stringfalsefalsetrue
382dns_typestype1.0a1000stringfalsetruetruethe type
383dns_typesdescription1.0a1001stringfalsefalsetruethe description of the type
385dns_typeshas_priority1.722booleanfalsefalsetrueflags which types have a priority
386dns_typeshas_weight1.723booleanfalsefalsetrueflags which types have a weight
387dns_typeshas_port1.724booleanfalsefalsetrueflags which types have a port
388dns_typeshas_flag1.86.05booleanfalsefalsetrueflags which types have a flag
389dns_typeshas_tag1.86.06booleanfalsefalsetrueflags which types have a tag
390dns_typesparam_ip1.0a1007booleanfalsefalsetrueflags if the parameter is a IP or a hostname
394dns_zoneszone1.0a1000zonefalsetruefalsethe zone (domain) that is hosted
395dns_zonesfile1.0a1001stringfalsefalsefalsethe filename of the zone file
397dns_zonespackage1.80.02accountingfalsefalsefalsethe package that owns the zones
398dns_zoneshostmaster1.0a1003stringfalsefalsefalsethe email address of the person in charge of the domain
399dns_zonesserial1.0a1004longfalsefalsefalsethe ever-incrementing serial number for the file
400dns_zonesttl1.0a1275intfalsefalsefalse
401email_addressespkey1.0a1000pkeyfalsetruefalsethe primary key
402email_addressesaddress1.0a1001stringfalsefalsefalseaddress before the @
403email_addressesdomain1.0a1002fkeyfalsefalsefalsethe pkey of the email domain
404email_attachment_blockspkey1.0a1160pkeyfalsetruefalsea unique, generated primary key
405email_attachment_blockslinux_server_account1.0a1161fkeyfalsefalsefalsereference to the email inbox
406email_attachment_blocksextension1.0a1162stringfalsefalsefalsethe extension of the blocked files
407email_attachment_typesextension1.0a1160stringfalsetruetruethe unique filename extension
408email_attachment_typesdescription1.0a1161stringfalsefalsetruea brief description of the attachment type
409email_attachment_typesis_default_block1.0a1162booleanfalsefalsetrueindicates that the type will be blocked by default
427email_domainspkey1.0a1000pkeyfalsetruefalsea generated unique key
429email_domainsdomain1.691domain_namefalsefalsefalsethe domain that is hosted in the email
430email_domainsao_server1.0a1002fkeyfalsefalsefalsethe pkey of the server that is hosting the email
432email_domainspackage1.80.03accountingfalsefalsefalsethe owner of the domain
433email_forwardingpkey1.0a1000pkeyfalsetruefalsea generated, unique key
434email_forwardingemail_address1.0a1001fkeyfalsefalsefalsethe primary key of the email_address
435email_forwardingdestination1.0a1002emailfalsefalsefalsethe destination of the email
440email_list_addressespkey1.0a1000pkeyfalsetruefalse
441email_list_addressesemail_address1.0a1001fkeyfalsefalsefalsethe primary key of the email_address
442email_list_addressesemail_list1.0a1002fkeyfalsefalsefalsethe pkey of the email list
443email_listspkey1.0a1000pkeyfalsetruefalsea generated, unique primary key
444email_listspath1.0a1001pathfalsefalsefalsethe complete path to the email list
446email_listslinux_server_account1.312fkeyfalsefalsefalsethe linux_server_account that owns the list
448email_listslinux_server_group1.313fkeyfalsefalsefalsethe linux_server_group that the list belongs to please note that ownership and server are derived from this value
451email_listsdisable_log1.0a1004fkeytruefalsefalseindicates that this list is disabled
472email_pipe_addressespkey1.0a1000pkeyfalsetruefalsea generated, unique key
473email_pipe_addressesemail_address1.0a1001fkeyfalsefalsefalsethe primary key of the email_address
474email_pipe_addressesemail_pipe1.0a1002fkeyfalsefalsefalsethe primary key of the email pipe
475email_pipespkey1.0a1000pkeyfalsetruefalsea generated primary key
476email_pipesao_server1.0a1001fkeyfalsefalsefalsethe pkey of the server the program resides on
478email_pipescommand1.80.02stringfalsefalsefalsethe complete command string to the email handling program
480email_pipespackage1.80.03accountingfalsefalsefalsethe package that this program runs for
481email_pipesdisable_log1.0a1004fkeytruefalsefalseindicates that this email pipe is disabled
520email_smtp_relay_typesname1.0a1000stringfalsetruetruethe name of the type
521email_smtp_relay_typessendmail_config1.0a1001stringfalsefalsetruethe config value used for sendmail
522email_smtp_relay_typesqmail_config1.0a1002stringfalsefalsetruethe config value used for qmail
508email_smtp_relayspkey1.0a1000pkeyfalsetruefalsea generated unique key
510email_smtp_relayspackage1.80.01accountingfalsefalsefalsethe package that owns this entry
511email_smtp_relaysao_server1.0a1002fkeytruefalsefalsethe pkey of the server that the rule applies to
513email_smtp_relayshost1.693hostnamefalsefalsefalsethe hostname or IP the rule applies to
514email_smtp_relaystype1.0a1004stringfalsefalsefalsethe type of entry
515email_smtp_relayscreated1.0a1005timefalsefalsefalsethe time the entry was created
516email_smtp_relayslast_refreshed1.0a1006timefalsefalsefalsethe time the entry was last updated
517email_smtp_relaysrefresh_count1.0a1007intfalsefalsefalsethe number of times the entry has been updated
518email_smtp_relaysexpiration1.0a1008timetruefalsefalsethe expiration time of the entry, or null if non-expiring
519email_smtp_relaysdisable_log1.0a1009fkeytruefalsefalseindicates that the rule is disabled
523email_smtp_smart_host_domainspkey1.570pkeyfalsetruefalsea generated unique key
524email_smtp_smart_host_domainssmart_host1.571fkeyfalsefalsefalsethe Smart Host that is being configured
526email_smtp_smart_host_domainsdomain1.692domain_namefalsefalsefalsethe specific domain that is being configured
527email_smtp_smart_host_domainsdomain_out_burst1.573inttruefalsefalsethe domain-specific email burst limit, null means unlimited
528email_smtp_smart_host_domainsdomain_out_rate1.574floattruefalsefalsethe domain-specific email rate, null means unlimited
529email_smtp_smart_hostsnet_bind1.570fkeyfalsetruefalsea reference to the port that is being used as a Smart Host
530email_smtp_smart_hoststotal_out_burst1.571inttruefalsefalsethe aggregate email burst limit for all emails sent through this host, null means unlimited
531email_smtp_smart_hoststotal_out_rate1.572floattruefalsefalsethe sustained email rate for all emails sent through this host, null means unlimited
532email_smtp_smart_hostsdefault_domain_out_burst1.573inttruefalsefalsethe default per-domain email burst limit when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited
533email_smtp_smart_hostsdefault_domain_out_rate1.574floattruefalsefalsethe default per-domain email rate when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited
534email_sa_integration_modesname1.0a1200stringfalsetruetruethe unique name of the mode
535email_sa_integration_modesdisplay1.0a1201stringfalsefalsetruethe display value for the mode
536email_sa_integration_modessort_order1.0a1202intfalsefalsetrue
1205encryption_keyspkey1.230pkeyfalsetruefalsea generated unique id
1206encryption_keysaccounting1.231accountingfalsefalsefalsethe accounting code of the business that owns this key
1207encryption_keysid1.232stringfalsefalsefalsethe id of the recipient who may decrypt the message
95expense_categoriesname1.81.180stringfalsetruefalsea simple code used as primary key
155failover_file_logpkey1.0a1000pkeyfalsetruefalsea generated, unique id
156failover_file_logreplication1.0a1001fkeyfalsefalsefalsethe replication that was performed
157failover_file_logstart_time1.0a1002timefalsefalsefalsethe time the replication started
158failover_file_logend_time1.0a1003timefalsefalsefalsethe time the replication finished
159failover_file_logscanned1.0a1004intfalsefalsefalsethe number of files scanned
160failover_file_logupdated1.0a1005intfalsefalsefalsethe number of files updated
161failover_file_logbytes1.0a1006longfalsefalsefalsethe number of bytes transferred
162failover_file_logis_successful1.0a1007booleanfalsefalsefalsekeeps track of which passes completed successfully
168failover_file_replicationspkey1.0a1000pkeyfalsetruefalsea generated, unique id
170failover_file_replicationsserver1.311fkeyfalsefalsefalsethe pkey of the server that the files are coming from
172failover_file_replicationsbackup_partition1.312fkeyfalsefalsefalsethe pkey of the backup partition that the files are going to
174failover_file_replicationsmax_bit_rate1.613longtruefalsefalsethe maximum bit rate for files being replicated
176failover_file_replicationsuse_compression1.94booleanfalsefalsefalsewhen compression is enabled, chunk mode is used on mirroring, resulting in more CPU and disk, but less bandwidth
177failover_file_replicationsretention1.135shortfalsefalsefalsethe number of days backups will be kept
179failover_file_replicationsconnect_address1.696hostnametruefalsefalsean address or hostname that overrides regular AOServ connections for failovers
181failover_file_replicationsconnect_from1.697ip_addresstruefalsefalsean address that overrides regular AOServ connection source addresses for failovers
182failover_file_replicationsenabled1.158booleanfalsefalsefalsethe enabled flag for failovers
187failover_file_replicationsquota_gid1.80.09linux_idtruefalsefalsethe gid used on the backup_partition for quota reports, required if backup_partitions quotas are enabled, not allowed otherwise
163failover_file_schedulepkey1.0a1000pkeyfalsetruefalsea generated, unique id
164failover_file_schedulereplication1.0a1001fkeyfalsefalsefalsethe replication that will be started
165failover_file_schedulehour1.0a1002shortfalsefalsefalsethe hour of day (in server timezone)
166failover_file_scheduleminute1.313shortfalsefalsefalsethe minute (in server timezone)
167failover_file_scheduleenabled1.0a1004booleanfalsefalsefalse
198failover_mysql_replicationspkey1.280pkeyfalsetruefalsea generated, unique id
199failover_mysql_replicationsao_server1.591fkeytruefalsefalsethe ao_server the receives the replication
201failover_mysql_replicationsreplication1.592fkeytruefalsefalsethe failover server that receives the replication
202failover_mysql_replicationsmysql_server1.283fkeyfalsefalsefalsethe MySQL Server that is being replicated
203failover_mysql_replicationsmonitoring_seconds_behind_low1.564inttruefalsefalsethe seconds behind where will trigger low alert level
204failover_mysql_replicationsmonitoring_seconds_behind_medium1.565inttruefalsefalsethe seconds behind where will trigger medium alert level
205failover_mysql_replicationsmonitoring_seconds_behind_high1.566inttruefalsefalsethe seconds behind where will trigger high alert level
206failover_mysql_replicationsmonitoring_seconds_behind_critical1.567inttruefalsefalsethe seconds behind where will trigger critical alert level
207failover_mysql_replicationsmax_alert_level1.748stringfalsefalsefalsethe maximum alert level for all monitoring of this slave
188file_backup_settingspkey1.0a1000pkeyfalsetruefalsea generated primary key
190file_backup_settingsreplication1.311fkeyfalsefalsefalsethe pkey of the failover_file_replication configured
191file_backup_settingspath1.0a1002stringfalsefalsefalsethe path to control
194file_backup_settingsbackup_enabled1.313booleanfalsefalsefalsethe enabled flag for this prefix
197file_backup_settingsrequired1.624booleanfalsefalsefalseindicates that backup pass will not be considered successful if file or path is missing
952firewalld_zonespkey1.81.00pkeyfalsetruefalsea generated unique primary key
953firewalld_zonesserver1.81.01fkeyfalsefalsefalsethe pkey of the server
954firewalld_zonesname1.81.02firewalld_zone_namefalsefalsefalsethe name of the Firewalld zone
955firewalld_zonesshort1.81.03stringtruefalsefalsethe optional short name
956firewalld_zonesdescription1.81.04stringtruefalsefalsethe optional description
957firewalld_zonesfail2ban1.81.95booleanfalsefalsefalseenables Fail2ban on services in this zone
546ftp_guest_usersusername1.81.220linux_usernamefalsetruefalsethe username that is a guest user
1521httpd_bindsnet_bind1.0a1000fkeyfalsetruefalsethe IP address, port, and protocol details
1522httpd_bindshttpd_server1.0a1001fkeyfalsefalsefalsethe server that is listening on the address
2446httpd_jboss_sitestomcat_site1.0a1000pkeyfalsetruefalsethe tomcat site
2447httpd_jboss_sitesversion1.0a1001fkeyfalsefalsefalsereference to httpd_jboss_versions
2448httpd_jboss_sitesjnp_bind1.0a1002fkeyfalsefalsefalsereference to net_binds
2449httpd_jboss_siteswebserver_bind1.0a1003fkeyfalsefalsefalsereference to net_binds
2450httpd_jboss_sitesrmi_bind1.0a1004fkeyfalsefalsefalsereference to net_binds
2451httpd_jboss_siteshypersonic_bind1.0a1005fkeyfalsefalsefalsereference to net_binds
2452httpd_jboss_sitesjmx_bind1.0a1006fkeyfalsefalsefalsereference to net_binds
2453httpd_jboss_versionsversion1.0a1000pkeyfalsetruetruejboss version designator
2454httpd_jboss_versionstomcat_version1.0a1001fkeyfalsefalsetrueversion of tomcat associated with this jboss version
2455httpd_jboss_versionstemplate_dir1.0a1002stringfalsefalsetruedirectory containing the install template
2537httpd_jk_codescode1.0a1000stringfalsetruetruethe unique, two-character code
2493httpd_jk_protocolsprotocol1.0a1000stringfalsetruetruethe protocol used, as found in protocols.protocol
1523httpd_serverspkey1.0a1000pkeyfalsetruefalsea generated unique number
1524httpd_serversao_server1.0a1001fkeyfalsefalsefalsethe pkey of the server that hosts the httpd
1526httpd_serversname1.81.82stringtruefalsefalsethe name of the instance on the server, null for the default instance
1527httpd_serverscan_add_sites1.0a1003booleanfalsefalsefalseindicated that more sites may be added to the server
1530httpd_serverslinux_server_account1.0a1024fkeyfalsefalsefalsethe account to run as
1531httpd_serverslinux_server_group1.0a1025fkeyfalsefalsefalsethe group to run as
1532httpd_serversmod_php_version1.0a1026fkeytruefalsefalsethe version of mod_php to run
1533httpd_serversuse_suexec1.0a1027booleanfalsefalsefalseindicates that the suexec wrapper will be used for CGI
1534httpd_serverspackage1.0a1028fkeyfalsefalsefalsethe package that owns the server
1536httpd_serversis_shared1.0a1029booleanfalsefalsefalseindicates that any user on the server may use this httpd instance
1537httpd_serversuse_mod_perl1.0a10310booleanfalsefalsefalse
1538httpd_serverstimeout1.0a13011intfalsefalsefalsethe timeout setting in seconds
1539httpd_serversmax_concurrency1.6812intfalsefalsefalsethe maximum number of processes/threads for this server instance
1540httpd_serversmonitoring_concurrency_low1.81.1113inttruefalsefalsethe concurrency that will trigger a low-level alert
1541httpd_serversmonitoring_concurrency_medium1.81.1114inttruefalsefalsethe concurrency that will trigger a medium-level alert
1542httpd_serversmonitoring_concurrency_high1.81.1115inttruefalsefalsethe concurrency that will trigger a high-level alert
1543httpd_serversmonitoring_concurrency_critical1.81.1116inttruefalsefalsethe concurrency that will trigger a critical-level alert
1544httpd_serversmod_access_compat1.81.717booleantruefalsefalsemanually enables or disables the mod_access_compat Apache module for this server instance
1545httpd_serversmod_actions1.81.718booleantruefalsefalsemanually enables or disables the mod_actions Apache module for this server instance
1546httpd_serversmod_alias1.81.719booleantruefalsefalsemanually enables or disables the mod_alias Apache module for this server instance
1547httpd_serversmod_auth_basic1.81.720booleantruefalsefalsemanually enables or disables the mod_auth_basic Apache module for this server instance
1548httpd_serversmod_authn_core1.81.721booleantruefalsefalsemanually enables or disables the mod_authn_core Apache module for this server instance
1549httpd_serversmod_authn_file1.81.722booleantruefalsefalsemanually enables or disables the mod_authn_file Apache module for this server instance
1550httpd_serversmod_authz_core1.81.723booleantruefalsefalsemanually enables or disables the mod_authz_core Apache module for this server instance
1551httpd_serversmod_authz_groupfile1.81.724booleantruefalsefalsemanually enables or disables the mod_authz_groupfile Apache module for this server instance
1552httpd_serversmod_authz_host1.81.725booleantruefalsefalsemanually enables or disables the mod_authz_host Apache module for this server instance
1553httpd_serversmod_authz_user1.81.726booleantruefalsefalsemanually enables or disables the mod_authz_user Apache module for this server instance
1554httpd_serversmod_autoindex1.81.727booleantruefalsefalsemanually enables or disables the mod_autoindex Apache module for this server instance
1555httpd_serversmod_deflate1.81.728booleantruefalsefalsemanually enables or disables the mod_deflate Apache module for this server instance
1556httpd_serversmod_dir1.81.729booleantruefalsefalsemanually enables or disables the mod_dir Apache module for this server instance
1557httpd_serversmod_filter1.81.730booleantruefalsefalsemanually enables or disables the mod_filter Apache module for this server instance
1558httpd_serversmod_headers1.81.731booleantruefalsefalsemanually enables or disables the mod_headers Apache module for this server instance
1559httpd_serversmod_include1.81.732booleantruefalsefalsemanually enables or disables the mod_include Apache module for this server instance
1560httpd_serversmod_jk1.81.733booleantruefalsefalsemanually enables or disables the mod_jk Apache module for this server instance
1561httpd_serversmod_log_config1.81.734booleantruefalsefalsemanually enables or disables the mod_log_config Apache module for this server instance
1562httpd_serversmod_mime1.81.735booleantruefalsefalsemanually enables or disables the mod_mime Apache module for this server instance
1563httpd_serversmod_mime_magic1.81.736booleantruefalsefalsemanually enables or disables the mod_mime_magic Apache module for this server instance
1564httpd_serversmod_negotiation1.81.737booleantruefalsefalsemanually enables or disables the mod_negotiation Apache module for this server instance
1565httpd_serversmod_proxy1.81.738booleantruefalsefalsemanually enables or disables the mod_proxy Apache module for this server instance
1566httpd_serversmod_proxy_http1.81.739booleantruefalsefalsemanually enables or disables the mod_proxy_http Apache module for this server instance
1567httpd_serversmod_reqtimeout1.81.740booleantruefalsefalsemanually enables or disables the mod_reqtimeout Apache module for this server instance
1568httpd_serversmod_rewrite1.81.741booleantruefalsefalsemanually enables or disables the mod_rewrite Apache module for this server instance
1569httpd_serversmod_setenvif1.81.742booleantruefalsefalsemanually enables or disables the mod_setenvif Apache module for this server instance
1570httpd_serversmod_socache_shmcb1.81.743booleantruefalsefalsemanually enables or disables the mod_socache_shmcb Apache module for this server instance
1571httpd_serversmod_ssl1.81.744booleantruefalsefalsemanually enables or disables the mod_ssl Apache module for this server instance
1572httpd_serversmod_status1.81.745booleantruefalsefalsemanually enables or disables the mod_status Apache module for this server instance
1573httpd_serversmod_wsgi1.81.1046booleantruefalsefalsemanually enables or disables the mod_wsgi Apache module for this server instance
2503httpd_shared_tomcatspkey1.0a1000pkeyfalsetruefalsepkey for this jvm
2504httpd_shared_tomcatsname1.0a1001stringfalsefalsefalseunique name for this jvm
2505httpd_shared_tomcatsao_server1.0a1002fkeyfalsefalsefalsethe pkey of the server on which this jvm resides
2506httpd_shared_tomcatsversion1.0a1003fkeyfalsefalsefalsethe tomcat version
2507httpd_shared_tomcatslinux_server_account1.0a1004fkeyfalsefalsefalsethe account under which this tomcat runs
2508httpd_shared_tomcatslinux_server_group1.0a1005fkeyfalsefalsefalsethe group to which this tomcat is assigned
2517httpd_shared_tomcatsdisable_log1.0a1006fkeytruefalsefalseindicates that the JVM is disabled
2518httpd_shared_tomcatstomcat4_worker1.0a1007fkeytruetruefalsethe httpd_worker for Tomcat version 4
2519httpd_shared_tomcatstomcat4_shutdown_port1.0a1008fkeytruetruefalsethe port that will shut down this JVM
2520httpd_shared_tomcatstomcat4_shutdown_key1.0a1009stringtruefalsefalsethe key used to shut down the JVM
2521httpd_shared_tomcatsis_manual1.0a10010booleanfalsefalsefalsethe configuration files are manually maintained
2522httpd_shared_tomcatsmaxParameterCount1.92.011inttruefalsefalsethe maxParameterCount setting for this Tomcat
2523httpd_shared_tomcatsmax_post_size1.80.112inttruefalsefalsethe maxPostSize setting for this Tomcat
2524httpd_shared_tomcatsunpack_wars1.80.113booleanfalsefalsefalsethe unpackWARs setting for this Tomcat
2525httpd_shared_tomcatsauto_deploy1.80.114booleanfalsefalsefalsethe autoDeploy setting for this Tomcat
2526httpd_shared_tomcatsundeployOldVersions1.92.015booleanfalsefalsefalsethe undeployOldVersions setting for this Tomcat
2527httpd_shared_tomcatstomcatAuthentication1.83.216booleanfalsefalsefalsethe tomcatAuthentication setting for this Tomcat
1574httpd_site_authenticated_locationspkey1.180pkeyfalsetruefalsea generated primary key
1575httpd_site_authenticated_locationshttpd_site1.181fkeyfalsefalsefalsethe site that is being referenced
1576httpd_site_authenticated_locationspath1.182stringfalsefalsefalsethe path to protect, unique per httpd_site
1577httpd_site_authenticated_locationsis_regular_expression1.183booleanfalsefalsefalseregular expressions may be used, resulting in LocationMatch directives instead of Location
1578httpd_site_authenticated_locationsauth_name1.184stringfalsefalsefalsethe prompt given to the user during authentication
1579httpd_site_authenticated_locationsauth_group_file1.185pathfalsefalsefalsethe full path to the file containing the group list
1580httpd_site_authenticated_locationsauth_user_file1.186pathfalsefalsefalsethe full path to the file containing the user list
1581httpd_site_authenticated_locationsrequire1.187stringfalsefalsefalsethe require directive parameter(s) for Apache
1582httpd_site_authenticated_locationshandler1.81.138stringtruefalsefalsethe optional handler for this location
1510httpd_site_bind_headerspkey1.81.150pkeyfalsetruefalsea generated primary key
1511httpd_site_bind_headershttpd_site_bind1.81.151fkeyfalsefalsefalsethe site bind that is being referenced
1512httpd_site_bind_headerssort_order1.81.152shortfalsefalsefalsethe per-bind unique sort ordering
1513httpd_site_bind_headerstype1.81.153stringfalsefalsefalsethe type of header, either "Header" or "RequestHeader"
1514httpd_site_bind_headersalways1.81.154booleanfalsefalsefalsethe condition is either "onsuccess" (default, can be omitted) or "always"
1515httpd_site_bind_headersaction1.81.155stringfalsefalsefalsethe action to be performed
1516httpd_site_bind_headersheader1.81.156stringfalsefalsefalsethe header name, without any final colon
1517httpd_site_bind_headersvalue1.81.157stringtruefalsefalsethe header value, not used for all actions
1518httpd_site_bind_headersreplacement1.81.158stringtruefalsefalsethe replacement value, only used for "edit" and "edit*"
1519httpd_site_bind_headerswhen1.81.159stringtruefalsefalseoptional control over when is this header directive is applied
1520httpd_site_bind_headerscomment1.81.1510stringtruefalsefalsean optional comment describing the redirect
1590RewriteRuleid1.81.210pkeyfalsetruefalsea generated primary key
1591RewriteRulevirtualHost1.81.211fkeyfalsefalsefalsethe VirtualHost this rule is applied to
1592RewriteRulesortOrder1.81.212shortfalsefalsefalsethe per-VirtualHost unique sort ordering
1593RewriteRulepattern1.81.213stringfalsefalsefalsethe per-VirtualHost pattern matched
1594RewriteRulesubstitution1.81.214stringfalsefalsefalsethe rewrite substitution
1595RewriteRuleflags1.81.215stringtruefalsefalsethe optional flags for the rule
1596RewriteRulecomment1.81.216stringtruefalsefalsean optional comment describing the rule
1639httpd_site_bindspkey1.0a1000pkeyfalsetruefalsea generated primary key
1640httpd_site_bindshttpd_site1.0a1001fkeyfalsefalsefalsethe site that is being referenced
1641httpd_site_bindshttpd_bind1.0a1002fkeyfalsefalsefalsethe IP and port information for the binding
1642httpd_site_bindsname1.81.143stringtruefalsefalsethe name of the bind, null for the default bind
1643httpd_site_bindsaccess_log1.0a1004pathfalsefalsefalsethe file used for access logging
1644httpd_site_bindserror_log1.0a1005pathfalsefalsefalsethe file used for error logging
1645httpd_site_bindscertificate1.81.106fkeytruefalsefalsethe certificate used by this bind
1649httpd_site_bindsdisable_log1.0a1007fkeytruefalsefalseindicates that this bind is disabled
1650httpd_site_bindspredisable_config1.0a1008stringtruefalsefalsethe config file before the site was disabled
1651httpd_site_bindsis_manual1.0a1009booleanfalsefalsefalsethe config file is manually maintained
1652httpd_site_bindsredirect_to_primary_hostname1.1910booleanfalsefalsefalsetells that system to redirect any request that is not to either the IP address or the primary hostname to the primary hostname, while leaving the request path intact
1653httpd_site_bindsinclude_site_config1.81.1011stringtruefalsefalsecontrols whether this bind includes the per-site configuration file
1634httpd_site_urlspkey1.0a1000pkeyfalsetruefalsea generated primary key
1635httpd_site_urlshttpd_site_bind1.0a1001fkeyfalsefalsefalsethe site that is being referenced
1637httpd_site_urlshostname1.692domain_namefalsefalsefalsethe hostname that this site responds to
1638httpd_site_urlsis_primary1.0a1003booleanfalsefalsefalseflags if this is the primary hostname for a site. A site must have one and only one primary hostname at a time. This constraint is implemented by the application code.
1598httpd_sitesid1.81.180pkeyfalsetruefalsea generated primary key
1599httpd_sitesao_server1.0a1001fkeyfalsefalsefalsethe pkey of the server the site is hosted on
1601httpd_sitesname1.81.182stringfalsefalsefalsethe name of the site, as used in the /var/www directory.
1602httpd_siteslist_first1.0a1003booleanfalsefalsefalseif <code>true</code>, this site will be listed first in the Apache configs. This is normally used only for the "not found" site for each httpd_server.
1604httpd_sitespackage1.80.04accountingfalsefalsefalsethe package that the site is part of
1606httpd_siteslinux_account1.81.225linux_usernamefalsefalsefalsethe user the site "runs as"
1608httpd_siteslinux_group1.80.06group_idfalsefalsefalsethe primary group that can edit the site content
1609httpd_sitesserver_admin1.0a1007emailfalsefalsefalsethe email address of the server administrator. This address is provided when an error occurs. The value is most often <code>webmaster@<i>domain.com</i></code>
1619httpd_sitesdisable_log1.0a1008fkeytruefalsefalseindicates that the site is disabled
1620httpd_sitesis_manual1.0a1009booleanfalsefalsefalseconfiguration of this server is performed manually
1621httpd_sitesawstats_skip_files1.0a12910stringtruefalsefalsethe SkipFiles setting for AWStats
1622httpd_sitesphp_version1.7811fkeytruefalsefalsethe active version of PHP, if any
1623httpd_sitesenable_cgi1.8012booleanfalsefalsefalseCGI is enabled on this website
1624httpd_sitesenable_ssi1.80.113booleanfalsefalsefalseServer-side includes are enabled on this website
1625httpd_sitesenable_htaccess1.80.114booleanfalsefalsefalse.htaccess files are enabled on this website
1626httpd_sitesenable_indexes1.80.115booleanfalsefalsefalseDirectory indexes are enabled on this website
1627httpd_sitesenable_follow_symlinks1.80.116booleanfalsefalsefalseSymbolic link following is enabled on this website (required for mod_rewrite)
1628httpd_sitesenable_anonymous_ftp1.80.117booleanfalsefalsefalseEnables the anonymous FTP area for this site.
1629httpd_sitesblock_trace_track1.81.618booleanfalsefalsefalseEnables the blocking of TRACE and TRACK HTTP methods on this site.
1630httpd_sitesblock_scm1.81.619booleanfalsefalsefalseEnables the blocking of URL patterns associated with source control management systems.
1631httpd_sitesblock_core_dumps1.81.620booleanfalsefalsefalseEnables the blocking of core dumps.
1632httpd_sitesblock_editor_backups1.81.621booleanfalsefalsefalseEnables the blocking filename patterns associated with editor automatic backups.
1633httpd_static_siteshttpd_site1.0a1000fkeyfalsetruefalsethe site that contains static content
2473httpd_tomcat_contextspkey1.0a1000pkeyfalsetruefalsea generated unique key
2474httpd_tomcat_contextstomcat_site1.0a1001fkeyfalsefalsefalsethe site this context is part of
2475httpd_tomcat_contextsclass_name1.0a1002stringtruefalsefalsethe className attribute
2476httpd_tomcat_contextscookies1.0a1003booleanfalsefalsefalsethe cookies attribute
2477httpd_tomcat_contextscross_context1.0a1004booleanfalsefalsefalsethe crossContext attribute
2479httpd_tomcat_contextsdoc_base1.80.05pathfalsefalsefalsethe docBase attribute
2480httpd_tomcat_contextsoverride1.0a1006booleanfalsefalsefalsethe override attribute
2481httpd_tomcat_contextspath1.0a1007stringfalsefalsefalsethe path attribute
2482httpd_tomcat_contextsprivileged1.0a1008booleanfalsefalsefalsethe privileged attribute
2483httpd_tomcat_contextsreloadable1.0a1009booleanfalsefalsefalsethe reloadable attribute
2484httpd_tomcat_contextsuse_naming1.0a10010booleanfalsefalsefalsethe useNaming attribute
2485httpd_tomcat_contextswrapper_class1.0a10011stringtruefalsefalsethe wrapperClass attribute
2486httpd_tomcat_contextsdebug1.0a10012intfalsefalsefalsethe debug attribute
2487httpd_tomcat_contextswork_dir1.0a10013pathtruefalsefalsethe workDir attribute
2488httpd_tomcat_contextsserver_xml_configured1.81.314booleanfalsefalsefalseflag setting if the context is written into conf/server.xml
2456httpd_tomcat_data_sourcespkey1.50pkeyfalsetruefalsea generated unique key
2457httpd_tomcat_data_sourcestomcat_context1.51fkeyfalsefalsefalsethe context this data source is for
2458httpd_tomcat_data_sourcesname1.52stringfalsefalsefalsethe JNDI name
2459httpd_tomcat_data_sourcesdriver_class_name1.53stringfalsefalsefalsefully qualified Java class name of the JDBC driver to be used
2460httpd_tomcat_data_sourcesurl1.54stringfalsefalsefalseconnection URL to be passed to our JDBC driver
2461httpd_tomcat_data_sourcesusername1.55stringfalsefalsefalsedatabase username to be passed to our JDBC driver
2462httpd_tomcat_data_sourcespassword1.56stringfalsefalsefalsedatabase password to be passed to our JDBC driver
2463httpd_tomcat_data_sourcesmax_active1.57intfalsefalsefalsethe maximum number of active instances that can be allocated from this pool at the same time
2464httpd_tomcat_data_sourcesmax_idle1.58intfalsefalsefalsethe maximum number of connections that can sit idle in this pool at the same time
2465httpd_tomcat_data_sourcesmax_wait1.59intfalsefalsefalsethe maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception
2466httpd_tomcat_data_sourcesvalidation_query1.510stringtruefalsefalseSQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query MUST be an SQL SELECT statement that returns at least one row.
2467httpd_tomcat_parameterspkey1.50pkeyfalsetruefalsea generated unique key
2468httpd_tomcat_parameterstomcat_context1.51fkeyfalsefalsefalsethe context this parameter is for
2469httpd_tomcat_parametersname1.52stringfalsefalsefalsethe name of the context initialization parameter to be created
2470httpd_tomcat_parametersvalue1.53stringfalsefalsefalsethe parameter value that will be presented to the application when requested by calling ServletContext.getInitParameter()
2471httpd_tomcat_parametersoverride1.54booleanfalsefalsefalseset this to false if you do not want a <context-param> for the same parameter name, found in the web application deployment descriptor, to override the value specified here. By default, overrides are allowed.
2472httpd_tomcat_parametersdescription1.55stringtruefalsefalseoptional, human-readable description of this context initialization parameter
2489httpd_tomcat_site_jk_mountspkey1.81.60pkeyfalsetruefalsea generated primary key
2490httpd_tomcat_site_jk_mountshttpd_tomcat_site1.81.61fkeyfalsefalsefalsethe Tomcat site that is being mounted
2491httpd_tomcat_site_jk_mountspath1.81.62stringfalsefalsefalsethe per-site unique pattern matched
2492httpd_tomcat_site_jk_mountsmount1.81.63booleanfalsefalsefalsetrue for JkMount, false for JkUnMount
2530httpd_tomcat_siteshttpd_site1.0a1000fkeyfalsetruefalsethe site that this Tomcat is running in
2531httpd_tomcat_sitesversion1.0a1001fkeyfalsefalsefalsethe version of tomcat that is being ran
2533httpd_tomcat_sitesblock_webinf1.81.62booleanfalsefalsefalseBlocks access to /META-INF and /WEB-INF at the Apache level.
2528httpd_tomcat_shared_sitestomcat_site1.0a1000pkeyfalsetruefalsethe tomcat site
2529httpd_tomcat_shared_siteshttpd_shared_tomcat1.0a1001fkeyfalsefalsefalsethe shared JVM
2494httpd_tomcat_std_sitestomcat_site1.0a1000fkeyfalsetruefalsethe site that this Tomcat is running in
2495httpd_tomcat_std_sitestomcat4_shutdown_port1.0a1001fkeytruetruefalsethe port that will shut down this JVM
2496httpd_tomcat_std_sitestomcat4_shutdown_key1.0a1002stringtruefalsefalsethe key used to shut down the JVM
2497httpd_tomcat_std_sitesmaxParameterCount1.92.03inttruefalsefalsethe maxParameterCount setting for this Tomcat
2498httpd_tomcat_std_sitesmax_post_size1.80.14inttruefalsefalsethe maxPostSize setting for this Tomcat
2499httpd_tomcat_std_sitesunpack_wars1.80.15booleanfalsefalsefalsethe unpackWARs setting for this Tomcat
2500httpd_tomcat_std_sitesauto_deploy1.80.16booleanfalsefalsefalsethe autoDeploy setting for this Tomcat
2501httpd_tomcat_std_sitesundeployOldVersions1.92.07booleanfalsefalsefalsethe undeployOldVersions setting for this Tomcat
2502httpd_tomcat_std_sitestomcatAuthentication1.83.28booleanfalsefalsefalsethe tomcatAuthentication setting for this Tomcat
2534httpd_tomcat_versionsversion1.0a1000fkeyfalsetruetruea reference to the tomcat details in the <code>technology_versions</code> table
2535httpd_tomcat_versionsinstall_dir1.0a1001pathfalsefalsetruethe directory the basic install files are located in
2536httpd_tomcat_versionsrequires_mod_jk1.0a1002booleanfalsefalsetrueindicates that this version of Tomcat requires the use of mod_jk
2539httpd_workersbind1.81.180fkeyfalsetruefalsethe network binding reservation and details
2541httpd_workersname1.81.181stringfalsefalsefalsethe jk_code for the worker
2544httpd_workerstomcatSite1.81.182fkeytruefalsefalsethe site that provides this worker (Tomcat 3 only)
976ip_addressesid1.81.180pkeyfalsetruefalsea generated, unique key
978ip_addressesinetAddress1.81.181ip_addressfalsefalsefalsethe IP address
980ip_addressesdevice1.81.182fkeytruefalsefalsethe network_device that this IP address is routed through. May only be null for 0.0.0.0
982ip_addressesisAlias1.81.183booleanfalsefalsefalseindicates that the IP address is using IP aliasing on the network device
984ip_addresseshostname1.694domain_nametruefalsefalsethe reverse mapping for the hostname, null only allowed for the "0.0.0.0"" or "::" IP addresses
987ip_addressespackage1.81.185fkeyfalsefalsefalsethe package that the IP address is part of
989ip_addressescreated1.0a1006timefalsefalsefalsethe time the IP address was added
991ip_addressesisAvailable1.81.187booleanfalsefalsefalsea flag if the IP address is available
993ip_addressesisOverflow1.81.188booleanfalsefalsefalseindicates that the IP address is shared by different accounts
995ip_addressesisDhcp1.81.189booleanfalsefalsefalsethe IP address is obtained via DHCP
998ip_addressesexternalInetAddress1.81.1810ip_addresstruefalsefalsethe external IP address, if different than ip_address
999ip_addressesnetmask1.3811stringfalsefalsefalsethe netmask of the local network
2336IpAddressMonitoringid1.81.180fkeyfalsetruefalseid of ip_addresses
2337IpAddressMonitoringenabled1.81.181booleanfalsefalsefalseindicates that this IP address should be monitored
2338IpAddressMonitoringpingMonitorEnabled1.81.182booleanfalsefalsefalseif ping (ICMP ECHO) is available for monitoring, defaults to true
2339IpAddressMonitoringcheckBlacklistsOverSmtp1.81.183booleanfalsefalsefalseallows determining some types of blacklists over SMTP protocol
2340IpAddressMonitoringverifyDnsPtr1.81.184booleanfalsefalsefalseenables monitoring of reverse DNS
2341IpAddressMonitoringverifyDnsA1.81.185booleanfalsefalsefalseenables monitoring of forward DNS
2359ip_reputation_limiter_limitspkey1.660pkeyfalsetruefalsea generated, unique key
2360ip_reputation_limiter_limitslimiter1.661fkeyfalsefalsefalsethe identifier of the limiter
2361ip_reputation_limiter_limitsclass1.662stringfalsefalsefalsethe reputation class
2362ip_reputation_limiter_limitssyn_per_ip_burst1.663shortfalsefalsefalse
2363ip_reputation_limiter_limitssyn_per_ip_rate1.664shortfalsefalsefalse
2364ip_reputation_limiter_limitssyn_per_ip_unit1.665stringfalsefalsefalse
2365ip_reputation_limiter_limitssyn_per_ip_size1.666shortfalsefalsefalse
2366ip_reputation_limiter_limitssyn_burst1.667shortfalsefalsefalse
2367ip_reputation_limiter_limitssyn_rate1.668shortfalsefalsefalse
2368ip_reputation_limiter_limitssyn_unit1.669stringfalsefalsefalse
2369ip_reputation_limiter_limitspacket_per_ip_burst1.6610shortfalsefalsefalse
2370ip_reputation_limiter_limitspacket_per_ip_rate1.6611shortfalsefalsefalse
2371ip_reputation_limiter_limitspacket_per_ip_unit1.6612stringfalsefalsefalse
2372ip_reputation_limiter_limitspacket_per_ip_size1.6613shortfalsefalsefalse
2373ip_reputation_limiter_limitspacket_burst1.6614shortfalsefalsefalse
2374ip_reputation_limiter_limitspacket_rate1.6615shortfalsefalsefalse
2375ip_reputation_limiter_limitspacket_unit1.6616stringfalsefalsefalse
2380ip_reputation_limiter_setspkey1.660pkeyfalsetruefalsea generated, unique key
2381ip_reputation_limiter_setslimiter1.661fkeyfalsefalsefalsethe identifier of the limiter
2382ip_reputation_limiter_setsset1.662fkeyfalsefalsefalsethe identifier of the set
2383ip_reputation_limiter_setssort_order1.663shortfalsefalsefalsethe per-limiter ordering
2376ip_reputation_limiterspkey1.660pkeyfalsetruefalsea generated, unique key
2377ip_reputation_limitersnet_device1.661fkeyfalsefalsefalsethe identifier of the net_device that is protected
2378ip_reputation_limitersidentifier1.662stringfalsefalsefalsethe per-net_device unique identifier
2379ip_reputation_limitersdescription1.663stringtruefalsefalsean optional description of the limiter
2352ip_reputation_set_hostspkey1.650longfalsetruefalsea generated, unique key
2354ip_reputation_set_hostsset1.661fkeyfalsefalsefalsethe IP Reputation Set
2356ip_reputation_set_hostshost1.672ip_addressfalsefalsefalsethe per-set unique IPv4 address
2357ip_reputation_set_hostsgood_reputation1.653shortfalsefalsefalsethe current good reputation
2358ip_reputation_set_hostsbad_reputation1.654shortfalsefalsefalsethe current bad repuation
2384ip_reputation_set_networkspkey1.650longfalsetruefalsea generated, unique key
2386ip_reputation_set_networksset1.661fkeyfalsefalsefalsethe IP Reputation Set
2388ip_reputation_set_networksnetwork1.672ip_addressfalsefalsefalsethe per-set unique IPv4 network address, with network bits zero
2389ip_reputation_set_networkscounter1.653intfalsefalsefalsethe reputation counter
2390ip_reputation_setspkey1.650pkeyfalsetruefalsea generated, unique key
2391ip_reputation_setsaccounting1.651accountingfalsefalsefalsethe accounting code of the business
2392ip_reputation_setsidentifier1.652stringfalsetruefalsea globally unique identifier
2393ip_reputation_setsallow_subaccount_use1.653booleanfalsefalsefalseallows subaccounts to use the set
2394ip_reputation_setsmax_hosts1.654intfalsefalsefalsethe maximum number of individual hosts tracked
2395ip_reputation_setsmax_uncertain_reputation1.655shortfalsefalsefalsethe maximum reputation from uncertain sources
2396ip_reputation_setsmax_definite_reputation1.656shortfalsefalsefalsethe maximum reputation from definite sources
2397ip_reputation_setsnetwork_prefix1.657shortfalsefalsefalsethe network size, for example 24 for a /24 (class C)
2398ip_reputation_setsmax_network_reputation1.658shortfalsefalsefalsethe maximum reputation for a network
2399ip_reputation_setshost_decay_interval1.659intfalsefalsefalsethe number of seconds between each host decay
2400ip_reputation_setslast_host_decay1.6510timefalsefalsefalsethe time the hosts were last decayed
2401ip_reputation_setsnetwork_decay_interval1.6511intfalsefalsefalsethe number of seconds between each network decay
2402ip_reputation_setslast_network_decay1.6512timefalsefalsefalsethe time the networks were last decayed
2403ip_reputation_setslast_reputation_added1.6713timefalsefalsefalsethe time reputation was last added
1473languagescode1.440stringfalsetruetruethe language code
436linux_acc_addressespkey1.0a1000pkeyfalsetruefalsea unique, generated primary key
437linux_acc_addressesemail_address1.0a1001fkeyfalsefalsefalsereference to pkey of email_addresses
439linux_acc_addresseslinux_server_account1.312fkeyfalsefalsefalsereference to linux_server_accounts
766linux_account_typesname1.0a1000stringfalsetruetruethe name of the type
767linux_account_typesdescription1.0a1001stringfalsefalsetruea description of the type
768linux_account_typesis_email1.0a1002booleanfalsefalsetruecan email be associated with this account
723linux_accountsusername1.81.220linux_usernamefalsetruefalsethe unique username
726linux_accountsname1.80.11gecostruefalsefalsethe full name of the user
728linux_accountsoffice_location1.692gecostruefalsefalsethe location of the user
730linux_accountsoffice_phone1.693gecostruefalsefalsethe work phone number of the user
732linux_accountshome_phone1.694gecostruefalsefalsethe home phone number of the user
733linux_accountstype1.0a1005stringfalsefalsefalsethe type of account
734linux_accountsshell1.0a1006pathfalsefalsefalsethe users shell preference
735linux_accountscreated1.0a1007timefalsefalsefalsethe time the account was created
736linux_accountsdisable_log1.0a1008fkeytruefalsefalseindicates that this account is disabled
654linux_group_accountsid1.81.180pkeyfalsetruefalsea generated unique number
657linux_group_accountsgroup1.81.181group_idfalsefalsefalsethe linux group name
660linux_group_accountsuser1.81.222linux_usernamefalsefalsefalsethe linux account that is an alternate member
662linux_group_accountsisPrimary1.81.183booleanfalsefalsefalseflag showing that this group is the user's primary group
664linux_group_accountsoperatingSystemVersion1.81.184fkeytruefalsefalsethe version of operating system where this group and user are associated, or null for all operating system versions
651linux_group_typesname1.0a1000stringfalsetruetruethe name of the type
652linux_group_typesdescription1.0a1001stringfalsefalsetruea description of the type
638linux_groupsname1.80.00group_idfalsetruefalsethe name of the group
640linux_groupspackage1.80.01accountingfalsefalsefalsethe package of the group
641linux_groupstype1.0a1002stringfalsefalsefalsethe type of group
737linux_server_accountspkey1.0a1000pkeyfalsetruefalsethe generated primary key
739linux_server_accountsusername1.81.221linux_usernamefalsefalsefalsethe name of the user
740linux_server_accountsao_server1.0a1002fkeyfalsefalsefalsethe pkey of the server the username is on
743linux_server_accountsuid1.80.03linux_idfalsefalsefalsethe uid of the user on the machine
744linux_server_accountshome1.0a1004pathfalsefalsefalsethe home directory of the user on this machine
751linux_server_accountsautoresponder_from1.0a1005fkeytruefalsefalsethe pkey of the email address used for the autoresponder
752linux_server_accountsautoresponder_subject1.0a1006stringtruefalsefalsethe subject of autoresponder messages
753linux_server_accountsautoresponder_path1.0a1007stringtruefalsefalsethe full path of the autoresponder text file
754linux_server_accountsis_autoresponder_enabled1.0a1008booleanfalsefalsefalseflags if the autoresponder is enabled
755linux_server_accountsdisable_log1.0a1009fkeytruefalsefalseindicates the account is disabled
756linux_server_accountspredisable_password1.0a10010stringtruefalsefalsestores the password that was used before the account was disabled
758linux_server_accountscreated1.6911timefalsefalsefalsethe time this account was added
759linux_server_accountsuse_inbox1.0a10012booleanfalsefalsefalseemail for this account will be stored in the inbox, otherwise it is just deleted
760linux_server_accountstrash_email_retention1.0a10013inttruefalsefalsethe number of days before messages in the Trash folder are automatically removed.
761linux_server_accountsjunk_email_retention1.0a12014inttruefalsefalsethe number of days before messages in the Junk folder are automatically removed.
762linux_server_accountssa_integration_mode1.0a12015stringfalsefalsefalsethe integration mode for SpamAssassin
763linux_server_accountssa_required_score1.0a12416floatfalsefalsefalsethe minimum SpamAssassin score considered Junk
764linux_server_accountssa_discard_score1.4017inttruefalsefalsethe minimum SpamAssassin score that will be discarded instead of tagged or placed in the Junk folder
765linux_server_accountssudo1.80.118stringtruefalsefalsethe sudo setting or null when sudo not allowed
642linux_server_groupspkey1.0a1000pkeyfalsetruefalsea unique key
644linux_server_groupsname1.80.01group_idfalsefalsefalsethe group name
645linux_server_groupsao_server1.0a1002fkeyfalsefalsefalsethe pkey of the ao_server the group is on
648linux_server_groupsgid1.80.03linux_idfalsefalsefalsethe gid on that machine
650linux_server_groupscreated1.694timefalsefalsefalsethe time the group was added
452majordomo_listsemail_list1.0a1000fkeyfalsetruefalsethe email list that this majordomo_list represents
453majordomo_listsmajordomo_server1.0a1001fkeyfalsefalsefalsethe majordomo_server that this list is part of
454majordomo_listsname1.0a1002stringfalsefalsefalsethe list name
455majordomo_listslistname_pipe_add1.0a1003fkeyfalsetruefalsethe pipe address the list responds to. Example: test@aoindustries.com
456majordomo_listslistname_list_add1.0a1004fkeyfalsetruefalsethe list address that accesses the raw list contents. Example: test-list@aoindustries.com
457majordomo_listsowner_listname_add1.0a1005fkeyfalsetruefalsethe owner of the list. Example: owner-test@aoindustries.com
458majordomo_listslistname_owner_add1.0a1006fkeyfalsetruefalsethe owner of the list. Example: test-owner@aoindustries.com
459majordomo_listslistname_approval_add1.0a1007fkeyfalsetruefalsethe person who retrieves approval notifications. Example: test-approval@aoindustries.com
460majordomo_listslistname_request_pipe_add1.0a1008fkeyfalsetruefalsethe address that Majordomo requests may be sent to. Example: test-request@aoindustries.com
461majordomo_serversdomain1.0a1000fkeyfalsetruefalsethe pkey of the domain that is hosted
462majordomo_serverslinux_server_account1.0a1001fkeyfalsefalsefalsethe pkey of linux_server_account to run as
463majordomo_serverslinux_server_group1.0a1002fkeyfalsefalsefalsethe pkey of the linux_server_group to run as
464majordomo_serversversion1.0a1003stringfalsefalsefalsethe version of Majordomo to use
465majordomo_serversmajordomo_pipe_address1.0a1004fkeyfalsefalsefalsethe email_address to use as the majordomo
466majordomo_serversowner_majordomo_add1.0a1005fkeyfalsefalsefalsethe email_address that owns this majordomo list
467majordomo_serversmajordomo_owner_add1.0a1006fkeyfalsefalsefalsethe email_address that owns this majordomo list
470majordomo_versionsversion1.0a1000stringfalsetruetruethe version number
471majordomo_versionscreated1.0a1001timefalsefalsetruethe time the version was added
795master_hostspkey1.0a1000pkeyfalsetruefalsea generated unique primary key
796master_hostsusername1.0a1001usernamefalsefalsefalsethe unique username of the user
798master_hostshost1.80.02hostnamefalsefalsefalsethe hostname or IP address they are allowed to connect from
775master_processesid1.83.00SmallIdentifierfalsetruefalse
777master_processesconnectorId1.83.01Identifiertruefalsefalse
778master_processesauthenticated_user1.0a1002usernametruefalsefalse
779master_processeseffective_user1.0a1003usernametruefalsefalse
780master_processesdaemon_server1.0a1004fkeytruefalsefalse
781master_processeshost1.0a1005ip_addressfalsefalsefalse
782master_processesprotocol1.0a1006stringfalsefalsefalse
783master_processesaoserv_protocol1.0a1017stringtruefalsefalse
784master_processesis_secure1.0a1008booleanfalsefalsefalse
785master_processesconnect_time1.0a1009timefalsefalsefalse
786master_processesuse_count1.0a10010longfalsefalsefalse
787master_processestotal_time1.0a10011intervalfalsefalsefalse
788master_processespriority1.0a10012intfalsefalsefalse
789master_processesstate1.0a10013stringfalsefalsefalse
790master_processescommand1.0a10014stringtruefalsefalse
791master_processesstate_start_time1.0a10015timefalsefalsefalse
792master_server_statsname1.0a1000stringfalsetruefalse
793master_server_statsvalue1.0a1001stringtruefalsefalse
794master_server_statsdescription1.0a1002stringfalsefalsefalse
799master_serverspkey1.0a1000pkeyfalsetruefalsea generated unique primary key
800master_serversusername1.0a1001usernamefalsefalsefalsethe unique username of the user
801master_serversserver1.0a1002fkeyfalsefalsefalsethe pkey of the server they may control
802master_usersusername1.0a1000usernamefalsetruefalsethe unique username of the user
803master_usersis_active1.0a1001booleanfalsefalsefalsethis level of access may be disabled
804master_userscan_access_accounting1.0a1002booleanfalsefalsefalseif they can access accounting resources
805master_userscan_access_bank_accounting1.0a1003booleanfalsefalsefalseif they can access bank account info
806master_userscan_invalidate_tables1.0a1004booleanfalsefalsefalseif they can invalidate master tables
807master_userscan_access_admin_web1.0a1005booleanfalsefalsefalseif they can access administrative web pages
809master_usersis_dns_admin1.0a1006booleanfalsefalsefalseif they can access all DNS stuff
811master_usersis_router1.657booleanfalsefalsefalseif they read all router stuff
812master_usersis_cluster_admin1.738booleanfalsefalsefalseif they can control cluster resources
211monthly_chargespkey1.0a1000pkeytruetruefalsea unique, generated number for reference
212monthly_chargesaccounting1.0a1001accountingfalsefalsefalsethe account code that is charged to
214monthly_chargespackage1.80.02accountingfalsefalsefalsethe package that this is charged for
215monthly_chargestype1.0a1003stringfalsefalsefalsethe type of charge, as found in transaction types
216monthly_chargesdescription1.0a1004stringtruefalsefalsethe description that is placed in the transaction
217monthly_chargesquantity1.0a1005decimal_3falsefalsefalsethe quantity
219monthly_chargesrate1.83.06moneyfalsefalsefalsethe rate
220monthly_chargescreated1.0a1007timefalsefalsefalsethe time this entry was created
221monthly_chargescreated_by1.0a1008usernamefalsefalsefalsethe business_administrator who created the entry
222monthly_chargesactive1.0a1009booleanfalsefalsefalseflags if this entry is active
813mysql_databasespkey1.0a1000pkeyfalsetruefalsea unique, generated primary key
815mysql_databasesname1.80.01mysql_database_namefalsefalsefalsethe name of the database
817mysql_databasesmysql_server1.42fkeyfalsefalsefalsethe pkey of the server that this database is hosted on
819mysql_databasespackage1.80.03accountingfalsefalsefalsethe package that this database is part of
822mysql_databasesmax_check_table_alert_level1.744stringfalsefalsefalsethe maximum alert level created for the check table monitoring of this database
823mysql_db_userspkey1.0a1000pkeyfalsetruefalsea generated primary key
824mysql_db_usersmysql_database1.0a1001fkeyfalsefalsefalsethe pkey in mysql_databases
826mysql_db_usersmysql_server_user1.312fkeyfalsefalsefalsethe pkey in mysql_server_users
827mysql_db_usersselect_priv1.0a1003booleanfalsefalsefalsethe SELECT privilege
828mysql_db_usersinsert_priv1.0a1004booleanfalsefalsefalsethe INSERT privilege
829mysql_db_usersupdate_priv1.0a1005booleanfalsefalsefalsethe UPDATE privilege
830mysql_db_usersdelete_priv1.0a1006booleanfalsefalsefalsethe DELETE privilege
831mysql_db_userscreate_priv1.0a1007booleanfalsefalsefalsethe CREATE privilege
832mysql_db_usersdrop_priv1.0a1008booleanfalsefalsefalsethe DROP privilege
833mysql_db_usersgrant_priv1.0a1009booleanfalsefalsefalsethe GRANT privilege
834mysql_db_usersreferences_priv1.0a10010booleanfalsefalsefalsethe REFERENCES privilege
835mysql_db_usersindex_priv1.0a10011booleanfalsefalsefalsethe INDEX privilege
836mysql_db_usersalter_priv1.0a10012booleanfalsefalsefalsethe ALTER privilete
837mysql_db_userscreate_tmp_table_priv1.0a11113booleanfalsefalsefalsethe Create_tmp_table_priv
838mysql_db_userslock_tables_priv1.0a11114booleanfalsefalsefalsethe Lock_tables_priv
839mysql_db_userscreate_view_priv1.415booleanfalsefalsefalsethe Create_view_priv
840mysql_db_usersshow_view_priv1.416booleanfalsefalsefalsethe Show_view_priv
841mysql_db_userscreate_routine_priv1.417booleanfalsefalsefalsethe Create_routine_priv
842mysql_db_usersalter_routine_priv1.418booleanfalsefalsefalsethe Alter_routine_priv
843mysql_db_usersexecute_priv1.419booleanfalsefalsefalsethe Execute_priv
844mysql_db_usersevent_priv1.5420booleanfalsefalsefalsethe Event_priv
845mysql_db_userstrigger_priv1.5421booleanfalsefalsefalsethe Trigger_priv
887mysql_server_userspkey1.0a1000pkeyfalsetruefalsea generated primary key
889mysql_server_usersusername1.80.01mysql_usernamefalsefalsefalsethe username
891mysql_server_usersmysql_server1.42fkeyfalsefalsefalsethe pkey of the MySQL server
893mysql_server_usershost1.693stringfalsefalsefalsethe host this user is allowed to connect from, if this is not null, all access is restricted to these hosts, otherwise the entries in mysql_db_users and mysql_hosts are used.
894mysql_server_usersdisable_log1.0a1004fkeytruefalsefalseindicates that this account is disabled
895mysql_server_userspredisable_password1.0a1005stringtruefalsefalsethe password used before the account was disabled
896mysql_server_usersmax_questions1.46intfalsefalsefalsethe maximum number of questions to this database server, 0 means unlimited
897mysql_server_usersmax_updates1.47intfalsefalsefalsethe maximum number of updates to this database server, 0 means unlimited
898mysql_server_usersmax_connections1.0a1118intfalsefalsefalsethe maximum number of connections to this database server, 0 means unlimited
899mysql_server_usersmax_user_connections1.49intfalsefalsefalsethe maximum number of user connections to this database server, 0 means unlimited
847mysql_serversbind1.81.180fkeyfalsetruefalsethe port the server binds to
849mysql_serversname1.80.01mysql_server_namefalsefalsefalsethe name of the server
850mysql_serversao_server1.42fkeyfalsefalsefalsethe pkey of the server that this database is hosted on
851mysql_serversversion1.43fkeyfalsefalsefalsethe pkey of the MySQL version
852mysql_serversmax_connections1.44intfalsefalsefalsethe maximum number of connections for the db
857mysql_usersusername1.80.00mysql_usernamefalsetruefalsethe username of the MySQL user
858mysql_usersselect_priv1.0a1001booleanfalsefalsefalsethe SELECT privilege to all databases
859mysql_usersinsert_priv1.0a1002booleanfalsefalsefalsethe INSERT privilege to all databases
860mysql_usersupdate_priv1.0a1003booleanfalsefalsefalsethe UPDATE privilege to all databases
861mysql_usersdelete_priv1.0a1004booleanfalsefalsefalsethe DELETE privilege to all databases
862mysql_userscreate_priv1.0a1005booleanfalsefalsefalsethe CREATE privilege to all databases
863mysql_usersdrop_priv1.0a1006booleanfalsefalsefalsethe DROP privilege to all databases
864mysql_usersreload_priv1.0a1007booleanfalsefalsefalsethe RELOAD privilege to all databases
865mysql_usersshutdown_priv1.0a1008booleanfalsefalsefalsethe SHUTDOWN privilege to all databases
866mysql_usersprocess_priv1.0a1009booleanfalsefalsefalsethe PROCESS privilege to all databases
867mysql_usersfile_priv1.0a10010booleanfalsefalsefalsethe FILE privilege to all databases
868mysql_usersgrant_priv1.0a10011booleanfalsefalsefalsethe GRANT privilege to all databases
869mysql_usersreferences_priv1.0a10012booleanfalsefalsefalsethe REFERENCES privilege to all databases
870mysql_usersindex_priv1.0a10013booleanfalsefalsefalsethe INDEX privilege to all databases
871mysql_usersalter_priv1.0a10014booleanfalsefalsefalsethe ALTER privilete to all databases
872mysql_usersshow_db_priv1.0a11115booleanfalsefalsefalse
873mysql_userssuper_priv1.0a11116booleanfalsefalsefalse
874mysql_userscreate_tmp_table_priv1.0a11117booleanfalsefalsefalse
875mysql_userslock_tables_priv1.0a11118booleanfalsefalsefalse
876mysql_usersexecute_priv1.0a11119booleanfalsefalsefalse
877mysql_usersrepl_slave_priv1.0a11120booleanfalsefalsefalse
878mysql_usersrepl_client_priv1.0a11121booleanfalsefalsefalse
879mysql_userscreate_view_priv1.422booleanfalsefalsefalse
880mysql_usersshow_view_priv1.423booleanfalsefalsefalse
881mysql_userscreate_routine_priv1.424booleanfalsefalsefalse
882mysql_usersalter_routine_priv1.425booleanfalsefalsefalse
883mysql_userscreate_user_priv1.426booleanfalsefalsefalse
884mysql_usersevent_priv1.5427booleanfalsefalsefalsethe Event_priv
885mysql_userstrigger_priv1.5428booleanfalsefalsefalsethe Trigger_priv
886mysql_usersdisable_log1.0a10029fkeytruefalsefalseindicates that this account is disabled
907net_bind_firewalld_zonespkey1.81.00pkeyfalsetruefalsea generated pkey
908net_bind_firewalld_zonesnet_bind1.81.01fkeyfalsefalsefalsethe pkey of the port that is associated with the zone
909net_bind_firewalld_zonesfirewalld_zone1.81.02fkeyfalsefalsefalsethe pkey of the zone this port is associated with
911net_bindsid1.81.180pkeyfalsetruefalsea generated pkey
913net_bindspackage1.80.01accountingfalsefalsefalsethe package that owns the opened port
915net_bindsserver1.332fkeyfalsefalsefalsethe pkey of the server that this port is bound on
917net_bindsipAddress1.81.183fkeyfalsefalsefalsethe id of the IP address that is bound to
920net_bindsport1.80.04net_portfalsefalsefalsethe port that is bound
922net_bindsapp_protocol1.0a1005stringfalsefalsefalsethe application protocol (<code>protocols</code>)
928net_bindsmonitoring_enabled1.0a1046booleanfalsefalsefalseturns on monitoring of the port
929net_bindsmonitoring_parameters1.587stringtruefalsefalsethe URL-encoded name=value pairs of monitoring parameters
930net_device_idsname1.0a1000stringfalsetruetruethe unique name of the device
931net_device_idsis_loopback1.0a1001booleanfalsefalsetrueif the device is the loopback device
932net_devicespkey1.0a1000pkeyfalsetruefalsea unique, generated pkey
934net_devicesserver1.331fkeyfalsefalsefalsethe pkey of the server that contains the device
936net_devicesdeviceId1.81.182stringfalsefalsefalsethe name of the device
937net_devicesdescription1.0a1003stringfalsefalsefalsea description of the device
939net_devicesdelete_route1.0a1124stringtruefalsefalsethe default routing from the network scripts that should be removed
940net_devicesgateway1.0a1005ip_addresstruefalsefalsethe gateway IP address
942net_devicesnetwork1.0a1126ip_addresstruefalsefalsethe local network
943net_devicesbroadcast1.0a1127ip_addresstruefalsefalsethe broadcast IP
945net_devicesmac_address1.80.08mac_addresstruetruefalsethe MAC address to be used on the device
946net_devicesmax_bit_rate1.29longtruefalsefalsethe maximum bits per second for this network device
947net_devicesmonitoring_bit_rate_low1.3510longtruefalsefalsethe 5-minute average that will trigger a low-level alert
948net_devicesmonitoring_bit_rate_medium1.3511longtruefalsefalsethe 5-minute average that will trigger a medium-level alert
949net_devicesmonitoring_bit_rate_high1.3512longtruefalsefalsethe 5-minute average that will trigger a high-level alert
950net_devicesmonitoring_bit_rate_critical1.3513longtruefalsefalsethe 5-minute average that will trigger a critical-level alert
951net_devicesmonitoring_enabled1.7014booleanfalsefalsefalseindicates that this device should be monitored
1003net_tcp_redirectsnet_bind1.690fkeyfalsetruefalsethe pkey as found in net_binds
1004net_tcp_redirectscps1.0a1111intfalsefalsefalsethe maximum number of connections per second before the redirect is temporarily disabled
1005net_tcp_redirectscps_overload_sleep_time1.0a1112intfalsefalsefalsethe number of seconds the service will be disabled
1006net_tcp_redirectsdestination_host1.0a1113hostnamefalsefalsefalsethe destination IP address or hostname, please note that hostnames are only resolved once on xinetd startup
1009net_tcp_redirectsdestination_port1.80.04net_portfalsefalsefalsethe remote port to connect to
226notice_logpkey1.0a1000pkeyfalsetruefalse
227notice_logcreate_time1.0a1001timefalsefalsefalse
228notice_logaccounting1.0a1002accountingfalsefalsefalse
229notice_logbilling_contact1.0a1003stringfalsefalsefalse
230notice_logbilling_email1.0a1004emailfalsefalsefalse
232notice_lognotice_type1.0a1005stringfalsefalsefalse
234notice_logtransid1.696fkeytruefalsefalse
223NoticeLog.balanceid1.83.00pkeyfalsetruefalsea generated primary key
224NoticeLog.balancenoticeLog1.83.01fkeyfalsefalsefalsethe ID of the NoticeLog this balance is part of
225NoticeLog.balancebalance1.83.02moneyfalsefalsefalsethe balance for a single currency
235notice_typestype1.0a1000stringfalsetruetrue
236notice_typesdescription1.0a1001stringfalsefalsetrue
337operating_system_versionspkey1.0a1000pkeyfalsetruetruea generated, unique ID
338operating_system_versionsoperating_system1.0a1001stringfalsefalsetruethe name of the OS
339operating_system_versionsversion_number1.0a1002stringfalsefalsetruethe number of OS version
340operating_system_versionsversion_name1.0a1003stringfalsefalsetruethe name of this OS release
341operating_system_versionsarchitecture1.0a1084stringfalsefalsetruethe name of the architecture
343operating_system_versionsdisplay1.0a1085stringfalsetruetruethe full display name for this version
344operating_system_versionsis_aoserv_daemon_supported1.0a1086booleanfalsefalsetruecan AOServ Daemon be ran on this OS
345operating_system_versionssort_order1.37shortfalsetruetruethe default sort order
334operating_systemsname1.0a1000stringfalsetruetruethe unique name of the operating system
335operating_systemsdisplay1.0a1001stringfalsefalsetruethe display version of the name
336operating_systemsis_unix1.0a1002booleanfalsefalsetrueindicates that this is a Unix-based OS
237package_categoriesname1.0a1230stringfalsetruetruethe category name
239package_definition_limitspkey1.0a1230pkeyfalsetruefalsethe unique identifier for this limit
240package_definition_limitspackage_definition1.0a1231fkeyfalsefalsefalsethe pkey of the package definition
241package_definition_limitsresource1.0a1232stringfalsefalsefalsethe resource name
242package_definition_limitssoft_limit1.0a1233inttruefalsefalsethe number that may be used for additional charges are added, NULL means unlimited
243package_definition_limitshard_limit1.0a1234inttruefalsefalsethe maximum number that may be allocated, NULL means unlimited
245package_definition_limitsadditionalRate1.83.05moneytruefalsefalsethe monthly rate for those past the soft_limit
246package_definition_limitsadditional_transaction_type1.0a1236stringtruefalsefalse
247package_definitionspkey1.0a1230pkeyfalsetruefalsethe unique ID of the package definition
250package_definitionsaccounting1.451accountingfalsefalsefalsethe accounting code of the seller/reseller that supports this package
251package_definitionscategory1.0a1232stringfalsefalsefalsethe package category
252package_definitionsname1.0a1233stringfalsefalsefalsethe name of the package
253package_definitionsversion1.0a1234stringfalsefalsefalsethe unique version of this package
254package_definitionsdisplay1.0a1235stringfalsefalsefalsea short description for display use
255package_definitionsdescription1.0a1236stringfalsefalsefalsea description of the package definition
257package_definitionssetupFee1.83.07moneytruefalsefalsethe setup fee for this package definition
258package_definitionssetup_fee_transaction_type1.0a1238stringtruefalsefalse
260package_definitionsmonthlyRate1.83.09moneytruefalsefalsethe default monthly charge for this package
261package_definitionsmonthly_rate_transaction_type1.0a12310stringtruefalsefalse
262package_definitionsactive1.0a12311booleanfalsefalsefalseallows new accounts for this package
263package_definitionsapproved1.0a12312booleanfalsefalsefalseonce approved a definition may be used for packages, but may not be modified
264packagespkey1.0a1000pkeyfalsetruefalsea generated unique key
266packagesname1.80.01accountingfalsetruefalsethe unique name of this package entry
267packagesaccounting1.0a1002accountingfalsefalsefalsethe accounting code of the business that pays for this package
270packagespackage_definition1.0a1233fkeyfalsefalsefalsethe definition of the package
271packagescreated1.0a1004timefalsefalsefalse
272packagescreated_by1.0a1005usernamefalsefalsefalse
281packagesdisable_log1.0a1006fkeytruefalsefalseindicates that the package is disabled
282packagesemail_in_burst1.247inttruefalsefalsethe maximum burst of inbound email before limiting begins
283packagesemail_in_rate1.248floattruefalsefalsethe number of sustained inbound emails per second
284packagesemail_out_burst1.249inttruefalsefalsethe maximum burst of outbound email before limiting begins
285packagesemail_out_rate1.2410floattruefalsefalsethe number of sustained outbound emails per second
286packagesemail_relay_burst1.2411inttruefalsefalsethe maximum burst of relay email before limiting begins
287packagesemail_relay_rate1.2412floattruefalsefalsethe number of sustained relay emails per second
1171payment_typesname1.0a1000stringfalsetruetruethe name of the type
1172payment_typesdescription1.0a1001stringfalsefalsetruea description of the type of payment
1173payment_typesactive1.0a1002booleanfalsefalsetrueindicates if payment is currently accepted via this method
1174payment_typesallow_web1.0a1003booleanfalsefalsetrueindicates if payment is allowed via a web form
560physical_serversserver1.360fkeyfalsetruefalsea reference to servers
561physical_serversrack1.361fkeytruefalsefalsethe rack that houses this server
562physical_serversrack_units1.362shorttruefalsefalsethe number of rack units
563physical_serversram1.363inttruefalsefalsethe total number of megabytes of RAM in this server
564physical_serversprocessor_type1.364stringtruefalsefalsethe processor type
565physical_serversprocessor_speed1.365inttruefalsefalsethe processor speed in MHz
566physical_serversprocessor_cores1.366inttruefalsefalsethe total number of processor cores, hyperthreads are counted as different cores
567physical_serversmax_power1.367floattruefalsefalsethe number of amps this server consumes under peak load
568physical_serverssupports_hvm1.378booleantruefalsefalseindicates supports full hardware virtualization
569physical_serversups_type1.639stringfalsefalsefalsethe type of UPS powering the server
1214postgres_databasespkey1.0a1000pkeyfalsetruefalsea unique, generated primary key
1216postgres_databasesname1.80.01postgres_database_namefalsefalsefalsethe name of the database
1217postgres_databasespostgres_server1.0a1002fkeyfalsefalsefalsethe pkey of the PostgreSQL server
1218postgres_databasesdatdba1.0a1003fkeyfalsefalsefalsethe datdba for the database
1219postgres_databasesencoding1.0a1004fkeyfalsefalsefalsethe pkey of the encoding system used for the database
1220postgres_databasesis_template1.0a1005booleanfalsefalsefalseif true, this database is a template
1221postgres_databasesallow_conn1.0a1006booleanfalsefalsefalseif true, this database is accepting connections
1224postgres_databasesenable_postgis1.277booleanfalsefalsefalseindicates PostGIS is enabled on this database
1225postgres_encodingspkey1.0a1000pkeyfalsetruetruea generated unique key
1226postgres_encodingsencoding1.0a1001stringfalsefalsetruethe name of the encoding
1227postgres_encodingspostgres_version1.0a1002fkeyfalsefalsetruethe version of PostgreSQL
1247postgres_server_userspkey1.0a1000pkeyfalsetruefalsea unique, generated number
1249postgres_server_usersusername1.80.01postgres_usernamefalsefalsefalsethe username as found in postgres_users
1251postgres_server_userspostgres_server1.692fkeyfalsefalsefalsethe pkey of the PostgreSQL server
1253postgres_server_usersdisable_log1.0a1003fkeytruefalsefalseindicates that this account is disabled
1254postgres_server_userspredisable_password1.0a1004stringtruefalsefalsethe password that was on the account before it was disabled
1229postgres_serversbind1.81.180fkeyfalsetruefalsethe port the server binds to
1231postgres_serversname1.80.01postgres_server_namefalsefalsefalsethe name of the database
1232postgres_serversao_server1.0a1002fkeyfalsefalsefalsethe pkey of the server that this database is hosted on
1233postgres_serversversion1.0a1003fkeyfalsefalsefalsethe pkey of the PostgreSQL version
1234postgres_serversmax_connections1.0a1004intfalsefalsefalsethe maximum number of connections for the db
1236postgres_serverssort_mem1.0a1005intfalsefalsefalsethe amount of shared memory used for sorting
1237postgres_serversshared_buffers1.0a1006intfalsefalsefalsethe number of shared buffers
1238postgres_serversfsync1.0a1007booleanfalsefalsefalseindicates that writes are synchronous
1241postgres_usersusername1.80.00postgres_usernamefalsetruefalsethe username of the user
1242postgres_userscreatedb1.0a1001booleanfalsefalsefalseusecreatedb flag
1243postgres_userstrace1.0a1002booleanfalsefalsefalseusetrace flag
1244postgres_userssuper1.0a1003booleanfalsefalsefalseusesuper flag
1245postgres_userscatupd1.0a1004booleanfalsefalsefalseusecatupd flag
1246postgres_usersdisable_log1.0a1005fkeytruefalsefalseindicates that this account is disabled
1255postgres_versionsversion1.0a1000fkeyfalsetruetruea reference to the PostgreSQL details in the <code>technology_versions</code> table
1257postgres_versionsminor_version1.0a1211stringfalsefalsetruethe minor version for this version (used for installation at /usr/postgresql/<minor_version>
1258postgres_versionspostgis_version1.272fkeytruefalsetruea reference to the PostGIS defails in the <code>technology_versions</code> table
548private_ftp_serversnet_bind1.0a1130fkeyfalsetruefalsethe root directory
550private_ftp_serverslogfile1.0a1001pathfalsefalsefalsethe file transfers are logged to
552private_ftp_servershostname1.692domain_namefalsefalsefalsethe hostname the server reports
553private_ftp_serversemail1.0a1003emailfalsefalsefalsethe email address the server reports
555private_ftp_serverscreated1.0a1004timefalsefalsefalsethe time the server was added
557private_ftp_serverslinux_server_account1.695fkeyfalsefalsefalse
559private_ftp_serversallow_anonymous1.0a1136booleanfalsefalsefalseenabled or disabled anonymous access to the server
570processor_typestype1.360stringfalsetruetruethe unique name of the type of processor
571processor_typessort_order1.361shortfalsetruetruethe sort order of the processor, those sorted higher may be substituted for those sorted lower
900protocolsprotocol1.0a1000stringfalsetruetruethe unique name of the protocol
903protocolsport1.80.01net_portfalsefalsetruethe default port of the protocol
904protocolsname1.0a1002stringfalsefalsetruethe name of the service
905protocolsis_user_service1.0a1053booleanfalsefalsetrueindicates that a user may add and remove this service
572rackspkey1.360pkeyfalsetruefalsethe unique ID for the rack
573racksfarm1.361stringfalsefalsefalsethe server_farm housing the rack
574racksname1.362stringfalsefalsefalsethe per-farm unique name
575racksmax_power1.363floattruefalsefalsethe maximum electrical load supported by the rack
576rackstotal_rack_units1.364inttruefalsefalsethe number of rack units of physical space
1314resellersaccounting1.440accountingfalsetruefalse
1315resellersticket_auto_escalate1.441booleanfalsefalsefalse
288resourcesname1.0a1000stringfalsetruetruethe name of the specific resource
1322schema_columnsid1.81.180pkeyfalsetruetruea generated unique pkey
1324schema_columnstable1.81.181stringfalsefalsetruethe name of the table the column is in
1326schema_columnsname1.81.182stringfalsefalsetruethe name of the column
1327schema_columnssinceVersion1.81.183stringfalsefalsetruethe first aoserv_protocol version this column was in
1328schema_columnslastVersion1.81.184stringtruefalsetruethe last version containing this field
1330schema_columnsindex1.81.185shortfalsefalsetruethe index of the column
1331schema_columnstype1.0a1006stringfalsefalsetruethe type of data in the column
1333schema_columnsisNullable1.81.187booleanfalsefalsetrueif the value may be null
1335schema_columnsisUnique1.81.188booleanfalsefalsetrueif true, the value is unique across rows
1337schema_columnsisPublic1.81.189booleanfalsefalsetrueif the value is publicly accessible
1338schema_columnsdescription1.0a10010stringfalsefalsetrueany description associated with the column
1342schema_foreign_keysid1.81.180pkeyfalsetruetruea generated unique pkey
1344schema_foreign_keyscolumn1.81.181fkeyfalsefalsetruethe column that references another column
1346schema_foreign_keysforeignColumn1.81.182fkeyfalsefalsetruethe referenced column
1350schema_foreign_keyssinceVersion1.81.183stringfalsefalsetruethe first aoserv_protocol version to have this reference
1352schema_foreign_keyslastVersion1.81.184stringtruefalsetruethe last aoserv_protocol version to have this references, or null if not yet removed
1353schema_tablesid1.81.180pkeyfalsetruetruea unique ID for the table
1354schema_tablesname1.0a1001stringfalsetruetruethe unique name
1356schema_tablessinceVersion1.81.182stringfalsefalsetruethe first aoserv_protocol version to have this table
1357schema_tableslastVersion1.81.183stringtruefalsetruethe last aoserv_protocol version to have this table or null if still used
1358schema_tablesdisplay1.0a1004stringfalsefalsetruethe display name
1360schema_tablesisPublic1.81.185booleanfalsefalsetrueif the data contained in the table is accessible to everybody
1361schema_tablesdescription1.0a1006stringfalsefalsetruethe description of the table
1366schema_typesid1.81.180pkeyfalsetruetruethe unique number
1368schema_typesname1.81.181stringfalsetruetruethe unique name
1371schema_typessinceVersion1.81.182stringfalsefalsetruethe first aoserv_protocol version this type was in
1373schema_typeslastVersion1.81.183stringtruefalsetruethe last version containing this type
482sendmail_bindsnet_bind1.81.100fkeyfalsetruefalsethe IP address, port, and protocol details
483sendmail_bindssendmail_server1.81.101fkeyfalsefalsefalsethe server that is listening on the address
484sendmail_bindsservername1.81.102stringtruefalsefalsethe Name for DaemonPortOptions for this bind
486sendmail_serversid1.81.180pkeyfalsetruefalsea generated unique number
487sendmail_serversao_server1.81.101fkeyfalsefalsefalsethe pkey of the server that runs this sendmail instance
488sendmail_serversname1.81.102stringtruefalsefalsethe name of the instance on the server, null for the default instance
489sendmail_serverspackage1.81.103fkeyfalsefalsefalsethe package that owns the SSL certificate
490sendmail_servershostname1.81.104domain_nametruefalsefalsethe fully qualified hostname for Dw, Dm, and Dj
491sendmail_serversserver_certificate1.81.105fkeyfalsefalsefalsethe certificate used for this server
492sendmail_serversclient_certificate1.81.106fkeyfalsefalsefalsethe certificate used for this client
493sendmail_serversallow_plaintext_auth1.81.107booleanfalsefalsefalseallows plaintext authentication (PLAIN/LOGIN) on non-TLS links
494sendmail_serversmax_queue_children1.81.108inttruefalsefalsethe value for confMAX_QUEUE_CHILDREN
495sendmail_serversnice_queue_run1.81.109inttruefalsefalsethe value for confNICE_QUEUE_RUN
496sendmail_serversdelay_la1.81.1010inttruefalsefalsethe value for confDELAY_LA
497sendmail_serversqueue_la1.81.1011inttruefalsefalsethe value for confQUEUE_LA
498sendmail_serversrefuse_la1.81.1012inttruefalsefalsethe value for confREFUSE_LA
499sendmail_serversmax_daemon_children1.81.1013inttruefalsefalsethe value for confMAX_DAEMON_CHILDREN
500sendmail_serversbad_rcpt_throttle1.81.1014inttruefalsefalsethe value for confBAD_RCPT_THROTTLE
501sendmail_serversconnection_rate_throttle1.81.1015inttruefalsefalsethe value for confCONNECTION_RATE_THROTTLE
502sendmail_serversmax_message_size1.81.1016inttruefalsefalsethe value for confMAX_MESSAGE_SIZE
503sendmail_serversmin_free_blocks1.81.1017inttruefalsefalsethe value for confMIN_FREE_BLOCKS
505sendmail_serversclientAddrInet1.81.1818fkeytruefalsefalsethe Addr for ClientPortOptions with Family=inet
507sendmail_serversclientAddrInet61.81.1819fkeytruefalsefalsethe Addr for ClientPortOptions with Family=inet6
577server_farmsname1.0a1000stringfalsetruefalsethe unique name of the farm
578server_farmsdescription1.0a1001stringfalsefalsefalsea description of the farm
582server_farmsowner1.0a1022fkeyfalsefalsefalsethe package that owns of the farm
583server_farmsuse_restricted_smtp_port1.263booleanfalsefalsefalseoutgoing servers should use restricted source ports (affects firewall rules)
958serverspkey1.0a1000pkeyfalsetruefalsea generated, unique ID
960serversfarm1.0a1001stringfalsefalsefalsethe name of the farm the server is located in
963serversdescription1.0a1002stringfalsefalsefalsea description of the servers purpose
968serversoperating_system_version1.313fkeytruefalsefalsethe version of operating system running on the server, if known
972serverspackage1.314fkeyfalsefalsefalsethe package accountable for resources used by the server
973serversname1.315stringfalsefalsefalsethe per-package unique name of the server (no special formatting required)
974serversmonitoring_enabled1.326booleanfalsefalsefalseenables/disables monitoring
718shellspath1.0a1000pathfalsetruetruethe complete path to the executable
719shellsis_login1.0a1001booleanfalsefalsetrueindicates if the shells gives process control
720shellsis_system1.0a1002booleanfalsefalsetrueindicates that this shell is for internal use only
1383signup_request_optionspkey1.230pkeyfalsetruefalsea generate unique id
1384signup_request_optionsrequest1.231fkeyfalsefalsefalsethe id of the request this option is part of
1385signup_request_optionsname1.232stringfalsefalsefalsethe unique-per-request name of the option
1386signup_request_optionsvalue1.233stringtruefalsefalsethe value of the option
1387signup_requestspkey1.230pkeyfalsetruefalsea generate unique id
1389signup_requestsbrand1.441accountingfalsefalsefalsethe brand of the parent business for the new account
1390signup_requeststime1.232timefalsefalsefalsethe time the request was added
1391signup_requestsip_address1.233ip_addressfalsefalsefalsethe IP address of the user who signed-up
1392signup_requestspackage_definition1.234fkeyfalsefalsefalsethe pkey of the Package Definition requested
1393signup_requestsbusiness_name1.235stringfalsefalsefalsethe name of the business
1395signup_requestsbusiness_phone1.696phonefalsefalsefalsethe phone number of the business
1397signup_requestsbusiness_fax1.697phonetruefalsefalsethe fax number of the business
1398signup_requestsbusiness_address11.238stringfalsefalsefalsethe street address of the business
1399signup_requestsbusiness_address21.239stringtruefalsefalsethe street address of the business
1401signup_requestsbusiness_city1.6910stringfalsefalsefalsethe city of the business
1403signup_requestsbusiness_state1.6911stringtruefalsefalsethe state or providence of the business
1405signup_requestsbusiness_country1.6912stringfalsefalsefalsethe two-character country code of the business
1407signup_requestsbusiness_zip1.6913stringtruefalsefalsethe zip code of the business
1408signup_requestsba_name1.2314stringfalsefalsefalsethe administrator's name
1409signup_requestsba_title1.2315stringtruefalsefalsethe administrator's title
1411signup_requestsba_work_phone1.6916stringfalsefalsefalsethe administrator's work phone
1413signup_requestsba_cell_phone1.6917stringtruefalsefalsethe administrator's cell phone
1415signup_requestsba_home_phone1.6918stringtruefalsefalsethe administrator's home phone
1417signup_requestsba_fax1.6919stringtruefalsefalsethe administrator's fax number
1418signup_requestsba_email1.2320emailfalsefalsefalsethe administrator's email address
1419signup_requestsba_address11.2321stringtruefalsefalsethe street address of the administrator
1420signup_requestsba_address21.2322stringtruefalsefalsethe street address of the administrator
1422signup_requestsba_city1.6923stringtruefalsefalsethe city of the administrator
1424signup_requestsba_state1.6924stringtruefalsefalsethe state or providence of the administrator
1426signup_requestsba_country1.6925stringtruefalsefalsethe two-character country code of the administrator
1428signup_requestsba_zip1.6926stringtruefalsefalsethe zip code of the administrator
1429signup_requestsba_username1.2327usernamefalsefalsefalsethe username of the administrator
1430signup_requestsbilling_contact1.2328stringfalsefalsefalsethe name of the billing contact
1431signup_requestsbilling_email1.2329emailfalsefalsefalsethe email address of the billing contact
1432signup_requestsbilling_use_monthly1.2330booleanfalsefalsefalseif true, the credit_card will be used every month automatically
1433signup_requestsbilling_pay_one_year1.2331booleanfalsefalsefalseif true, one-year in advance will be charged to the credit_card and they will receive a credit for a free month
1434signup_requestsencrypted_data1.2332stringfalsefalsefalsethe credit card details and password are stored encrypted
1435signup_requestsencryption_from1.3133fkeyfalsefalsefalsethe from that was used for encryption
1437signup_requestsencryption_recipient1.3134fkeyfalsefalsefalsethe recipient that was used for encryption
1438signup_requestscompleted_by1.2335usernametruefalsefalsethe username of the person who completed this sign-up request
1439signup_requestscompleted_time1.2336timetruefalsefalsethe time this request was completed
537spam_email_messagespkey1.0a1000pkeyfalsetruefalsea generated unique key
538spam_email_messagesemail_relay1.0a1001fkeyfalsefalsefalsethe relay that has been denied
539spam_email_messagestime1.0a1002timefalsefalsefalsethe time the message was added
540spam_email_messagesmessage1.0a1003stringfalsefalsefalsethe message contents
1187ssl_certificate_namespkey1.81.100pkeyfalsetruefalsea generated primary key
1188ssl_certificate_namesssl_certificate1.81.101fkeyfalsefalsefalsethe pkey of the SSL certificate this name is on
1189ssl_certificate_namesis_common_name1.81.102booleanfalsefalsefalseindicates this is the Common Name (CN) or a Subject Alt Name
1190ssl_certificate_namesis_wildcard1.81.103booleanfalsefalsefalseis a *.(domain) wildcard certificate
1191ssl_certificate_namesdomain1.81.104domain_namefalsefalsefalsethe domain name
1192ssl_certificate_other_usespkey1.81.160pkeyfalsetruefalsea generated primary key
1193ssl_certificate_other_usesssl_certificate1.81.161fkeyfalsefalsefalsethe pkey of the SSL certificate this name is on
1194ssl_certificate_other_usessort_order1.81.162shortfalsefalsefalsethe per-certificate unique sort ordering
1195ssl_certificate_other_usescount1.81.163intfalsefalsefalsethe number of times this other resource uses the certificate
1196ssl_certificate_other_usesdisplay1.81.164stringfalsefalsefalsea short display value, which will often follow the count when displayed
1197ssl_certificatespkey1.81.100pkeyfalsetruefalsea generated primary key
1198ssl_certificatesao_server1.81.101fkeyfalsefalsefalsethe pkey of the server the SSL certificate is on
1199ssl_certificatespackage1.81.102fkeyfalsefalsefalsethe package that owns the SSL certificate
1200ssl_certificateskey_file1.81.103pathfalsefalsefalsethe file holding the private key
1201ssl_certificatescsr_file1.81.104pathtruefalsefalsethe file holding the CSR
1202ssl_certificatescert_file1.81.105pathfalsefalsefalsethe file holding the public key
1203ssl_certificateschain_file1.81.106pathtruefalsefalsethe file holding the CA chain
1204ssl_certificatescertbot_name1.81.107stringtruefalsefalsethe name of the certbot-managed Let's Encrypt certificate
541system_email_aliasespkey1.0a1000pkeyfalsetruefalsea generated primary key
542system_email_aliasesao_server1.0a1001fkeyfalsefalsefalsethe pkey of the server the entry is on
543system_email_aliasesaddress1.0a1002stringfalsefalsefalsethe address (username only) to match
544system_email_aliasesdestination1.0a1003stringfalsefalsefalsethe destination, as found in /etc/aliases
346technologiespkey1.40pkeyfalsetruetruethe unique identifier
347technologiesname1.0a1001stringfalsefalsetruethe name of the package
348technologiesclass1.0a1002stringfalsefalsetruethe name of the group this package belongs to
349technology_classesname1.0a1000stringfalsetruetruethe name of the class
350technology_classesdescription1.0a1001stringfalsefalsetruea description of the class
351technology_namesname1.0a1000stringfalsetruetruethe name of the package
352technology_namesimage_filename1.0a1001stringtruefalsetruethe name of the file containing the image
353technology_namesimage_width1.0a1002inttruefalsetruethe width of the image
354technology_namesimage_height1.0a1003inttruefalsetruethe height of the image
355technology_namesimage_alt1.0a1004stringtruefalsetruethe alt attribute of the image
356technology_nameshome_page_url1.0a1005urltruefalsetruethe URL of the technology home page
357technology_versionspkey1.0a1000pkeyfalsetruetruea generated unique key
358technology_versionsname1.0a1001stringfalsefalsetruethe name of the software package
359technology_versionsversion1.0a1002stringfalsefalsetruethe version number of the package in #.##.##-## format
360technology_versionsupdated1.0a1003timefalsefalsetruethe time this package was last updated
361technology_versionsowner1.0a1004usernamefalsefalsefalsethe business_administrator who is responsible for maintaining this package
362technology_versionsoperating_system_version1.0a1085fkeytruefalsetruethe version of the OS that this packages is installed
363technology_versionsdisable_time1.786timetruefalsetruethe time this version is no longer supported
364technology_versionsdisable_reason1.787stringtruefalsetruethe reason this version is no longer supported
1467ticket_action_typestype1.440stringfalsetruetrue
1468ticket_action_typesvisible_admin_only1.441booleanfalsefalsetrue
1440ticket_actionspkey1.440pkeyfalsetruefalse
1441ticket_actionsticket1.441fkeyfalsefalsefalse
1442ticket_actionsadministrator1.442usernametruefalsefalse
1443ticket_actionstime1.443timefalsefalsefalse
1444ticket_actionsaction_type1.444stringfalsefalsefalse
1446ticket_actionsold_accounting1.695accountingtruefalsefalse
1448ticket_actionsnew_accounting1.696accountingtruefalsefalse
1449ticket_actionsold_priority1.447stringtruefalsefalse
1450ticket_actionsnew_priority1.448stringtruefalsefalse
1451ticket_actionsold_type1.499stringtruefalsefalse
1452ticket_actionsnew_type1.4910stringtruefalsefalse
1453ticket_actionsold_status1.4411stringtruefalsefalse
1454ticket_actionsnew_status1.4412stringtruefalsefalse
1456ticket_actionsold_assigned_to1.80.013usernametruefalsefalse
1458ticket_actionsnew_assigned_to1.80.014usernametruefalsefalse
1459ticket_actionsold_category1.4415fkeytruefalsefalse
1460ticket_actionsnew_category1.4416fkeytruefalsefalse
1461ticket_actionsold_value1.4417stringtruefalsefalse
1462ticket_actionsnew_value1.4418stringtruefalsefalse
1463ticket_actionsfrom_address1.4419emailtruefalsefalse
1464ticket_actionssummary1.4420stringtruefalsefalse
1465ticket_actionsdetails1.4421stringtruefalsefalse
1466ticket_actionsraw_email1.4422stringtruefalsefalse
1469ticket_assignmentspkey1.440pkeyfalsetruefalse
1470ticket_assignmentsticket1.441fkeyfalsefalsefalse
1471ticket_assignmentsreseller1.442accountingfalsefalsefalse
1472ticket_assignmentsadministrator1.443usernamefalsefalsefalse
1259ticket_brand_categoriespkey1.440pkeyfalsetruefalse
1260ticket_brand_categoriesbrand1.441accountingfalsefalsefalse
1261ticket_brand_categoriescategory1.442fkeyfalsefalsefalse
1262ticket_brand_categoriesenabled1.443booleanfalsefalsefalse
1311ticket_categoriespkey1.440pkeyfalsetruefalse
1312ticket_categoriesparent1.441fkeytruefalsefalse
1313ticket_categoriesname1.442stringfalsefalsefalse
1474ticket_prioritiespriority1.0a1000stringfalsetruetrue
1475ticket_statistatus1.0a1000stringfalsetruetrue
1477ticket_statisort_order1.441shortfalsetruetrue
1507ticket_typestype1.0a1000stringfalsetruetrue
1478ticketspkey1.0a1000pkeyfalsetruefalse
1479ticketsbrand1.461accountingfalsefalsefalse
1480ticketsreseller1.442accountingfalsefalsefalse
1482ticketsaccounting1.0a1263accountingtruefalsefalse
1483ticketslanguage1.444stringfalsefalsefalse
1485ticketscreated_by1.0a1265usernametruefalsefalse
1486ticketscategory1.446fkeytruefalsefalse
1487ticketsticket_type1.0a1007stringfalsefalsefalse
1488ticketsfrom_address1.448emailtruefalsefalse
1489ticketssummary1.449stringfalsefalsefalse
1491ticketsdetails1.4410stringtruefalsefalse
1492ticketsraw_email1.4411stringtruefalsefalse
1493ticketsopen_date1.0a10012timefalsefalsefalse
1497ticketsclient_priority1.0a10013stringfalsefalsefalse
1499ticketsadmin_priority1.1014stringtruefalsefalse
1501ticketsstatus1.0a10015stringfalsefalsefalse
1502ticketsstatus_timeout1.6916timetruefalsefalse
1504ticketscontact_emails1.0a12517stringfalsefalsefalse
1505ticketscontact_phone_numbers1.0a12518stringfalsefalsefalse
1506ticketsinternal_notes1.6919stringfalsefalsefalse
721time_zonesname1.20stringfalsetruetrueThe unique name of this time zone
313transaction_typesname1.0a1230stringfalsetruetruethe name of the type
317transaction_typesis_credit1.0a1231booleanfalsefalsetrueindicates that this type of transaction represents payment or credit
294transactionstime1.0a1000timefalsefalsefalsethe time the transaction occured
296transactionstransid1.691pkeyfalsetruefalsethe unique identifier for this transaction
297transactionsaccounting1.0a1002accountingfalsefalsefalsethe identifier for the business (see businesses)
298transactionssource_accounting1.0a1003accountingfalsefalsefalsethe source of the charge to this account
299transactionsusername1.0a1004usernamefalsefalsefalsethe identifier for the admin involved in the transaction (see business_administrators)
300transactionstype1.0a1005stringfalsefalsefalsethe type of transaction
301transactionsdescription1.0a1006stringfalsefalsefalsedescription of the transaction
302transactionsquantity1.0a1007decimal_3falsefalsefalsethe number of times to charge the account
304transactionsrate1.83.08moneyfalsefalsefalsethe amount per unit of quantity
305transactionspayment_type1.0a1009stringtruefalsefalsethe type of payment made check - check, check number will be in payment_info money_order - money order visa - visa card, last four in payment_info mastercard - mastercard, last four in payment_info amex - amex card, last four in payment_info discover - discover card, last four in payment_info
306transactionspayment_info1.0a10010stringtruefalsefalsethe payment info, such as last four of credit card number of check number
308transactionsprocessor1.2911stringtruefalsefalsethe credit card processor that handled the payment
309transactionscredit_card_transaction1.2912fkeytruefalsefalsethe credit card transaction for this transaction
312transactionspayment_confirmed1.0a10013stringfalsefalsefalse'Y' if the payment is confirmed 'W' if waiting confirmation 'N' if confirmation failed
125us_statescode1.0a1000stringfalsetruetruethe two-character code for the state
126us_statesname1.0a1001stringfalsefalsetruethe name of the state
121usernamesusername1.0a1000usernamefalsetruefalsethe unique username
123usernamespackage1.80.01accountingfalsefalsefalsethe package name that this user is part of
124usernamesdisable_log1.0a1002fkeytruefalsefalseindicates that the username is disabled
584virtual_diskspkey1.360pkeyfalsetruefalsea generated unique ID
585virtual_disksvirtual_server1.361fkeyfalsefalsefalsethe virtual server this disk belongs to
586virtual_disksdevice1.362stringfalsefalsefalsethe per-virtual-server unique device, such as xvda or xvdb
593virtual_disksminimum_disk_speed1.413inttruefalsefalsethe minimum disk speed in RPM for the primary physical server
594virtual_disksminimum_disk_speed_target1.434inttruefalsefalsethe minimum disk speed in RPM for the primary physical server
597virtual_disksextents1.365intfalsefalsefalsethe total number of LVM extents for this device
598virtual_disksweight1.416shortfalsefalsefalsethe amount of primary disk I/O allocated to this virtual device on a scale of 1-1024
599virtual_disksweight_target1.437shortfalsefalsefalsethe amount of primary disk I/O allocated to this virtual device on a scale of 1-1024
604virtual_disksverify_day_of_week1.728intfalsefalsefalsethe day of the week verification will begin
605virtual_disksverify_hour_of_day1.729intfalsefalsefalsethe hour of day verification will begin
606virtual_serversserver1.360fkeyfalsetruefalsethe server that is virtualized
607virtual_serversprimary_ram1.361intfalsefalsefalsethe amount of RAM required in primary mode in megabytes
608virtual_serversprimary_ram_target1.432intfalsefalsefalsethe amount of RAM required in primary mode in megabytes
609virtual_serverssecondary_ram1.363inttruefalsefalsethe amount of RAM required in primary mode in megabytes or 0 if secondary not required
610virtual_serverssecondary_ram_target1.434inttruefalsefalsethe amount of RAM required in primary mode in megabytes or 0 if secondary not required
611virtual_serversminimum_processor_type1.415stringtruefalsefalsethe minimum processor type
614virtual_serversminimum_processor_architecture1.366stringfalsefalsefalsethe minimum processor architecture, compatible architectures may be substituted
615virtual_serversminimum_processor_speed1.417inttruefalsefalsethe minimum processor speed in MHz
616virtual_serversminimum_processor_speed_target1.438inttruefalsefalsethe minimum processor speed in MHz
619virtual_serversprocessor_cores1.419shortfalsefalsefalsethe number of processor cores
620virtual_serversprocessor_cores_target1.4310shortfalsefalsefalsethe number of processor cores
623virtual_serversprocessor_weight1.4111shortfalsefalsefalsethe processor allocation weight on a scale of 1-1024
624virtual_serversprocessor_weight_target1.4312shortfalsefalsefalsethe processor allocation weight on a scale of 1-1024
628virtual_serversprimary_physical_server_locked1.3613booleanfalsefalsefalseindicates the primary server is locked and should not be moved by automated means
630virtual_serverssecondary_physical_server_locked1.3614booleanfalsefalsefalseindicates the secondary server is locked and should not be moved by automated means
631virtual_serversrequires_hvm1.3715booleanfalsefalsefalseindicates requires full hardware virtualization
632virtual_serversvnc_password1.5116stringfalsetruefalsethe password for VNC console access or null to disable VNC access
326WhoisHistoryid1.81.190pkeyfalsetruefalsea unique, generated identifier
327WhoisHistoryregistrableDomain1.81.191domain_namefalsefalsefalsethe registrable domain that was queried
328WhoisHistorytime1.81.192timefalsefalsefalsethe time the whois query was performed
329WhoisHistoryexitStatus1.81.193inttruefalsefalsethe exit status from the whois lookup, null on exception
330WhoisHistoryoutput1.81.194stringfalsefalsefalsethe output from the whois lookup
331WhoisHistoryerror1.81.195stringfalsefalsefalsethe error from the whois lookup
318WhoisHistoryAccountid1.81.190pkeyfalsetruefalsea unique, generated identifier
319WhoisHistoryAccountwhoisHistory1.81.191fkeyfalsefalsefalsethe id of the WhoisHistory
320WhoisHistoryAccountaccount1.81.192accountingfalsefalsefalsethe id of the Account