1263 | brands | accounting | 1.44 | | 0 | accounting | false | true | false | |
97 | business_profiles | accounting | 1.0a100 | | 1 | accounting | false | false | false | the accounting code of the business |
15 | businesses | accounting | 1.0a100 | | 0 | accounting | false | true | false | the unique identifier for this business. |
20 | businesses | parent | 1.0a100 | | 5 | accounting | true | false | false | the parent business to this one |
2 | business_servers | accounting | 1.0a100 | | 1 | accounting | false | false | false | the business |
1176 | credit_card_processors | accounting | 1.29 | | 1 | accounting | false | false | false | the accounting code of the business owning the merchant account |
1066 | credit_card_transactions | accounting | 1.29 | | 2 | accounting | false | false | false | the accounting code for the source of this transaction |
1105 | credit_card_transactions | credit_card_accounting | 1.29 | | 28 | accounting | false | false | false | the accounting code of the business that provided this credit card |
1017 | credit_cards | accounting | 1.0a100 | | 2 | accounting | false | false | false | the accounting code for the card |
59 | disable_log | accounting | 1.0a100 | | 2 | accounting | false | false | false | the business whose resources are being disabled |
397 | dns_zones | package | 1.80.0 | | 2 | accounting | false | false | false | the package that owns the zones |
432 | email_domains | package | 1.80.0 | | 3 | accounting | false | false | false | the owner of the domain |
480 | email_pipes | package | 1.80.0 | | 3 | accounting | false | false | false | the package that this program runs for |
510 | email_smtp_relays | package | 1.80.0 | | 1 | accounting | false | false | false | the package that owns this entry |
1206 | encryption_keys | accounting | 1.23 | | 1 | accounting | false | false | false | the accounting code of the business that owns this key |
1604 | httpd_sites | package | 1.80.0 | | 4 | accounting | false | false | false | the package that the site is part of |
2391 | ip_reputation_sets | accounting | 1.65 | | 1 | accounting | false | false | false | the accounting code of the business |
640 | linux_groups | package | 1.80.0 | | 1 | accounting | false | false | false | the package of the group |
212 | monthly_charges | accounting | 1.0a100 | | 1 | accounting | false | false | false | the account code that is charged to |
214 | monthly_charges | package | 1.80.0 | | 2 | accounting | false | false | false | the package that this is charged for |
819 | mysql_databases | package | 1.80.0 | | 3 | accounting | false | false | false | the package that this database is part of |
913 | net_binds | package | 1.80.0 | | 1 | accounting | false | false | false | the package that owns the opened port |
228 | notice_log | accounting | 1.0a100 | | 2 | accounting | false | false | false | |
250 | package_definitions | accounting | 1.45 | | 1 | accounting | false | false | false | the accounting code of the seller/reseller that supports this package |
266 | packages | name | 1.80.0 | | 1 | accounting | false | true | false | the unique name of this package entry |
267 | packages | accounting | 1.0a100 | | 2 | accounting | false | false | false | the accounting code of the business that pays for this package |
1314 | resellers | accounting | 1.44 | | 0 | accounting | false | true | false | |
1389 | signup_requests | brand | 1.44 | | 1 | accounting | false | false | false | the brand of the parent business for the new account |
1446 | ticket_actions | old_accounting | 1.69 | | 5 | accounting | true | false | false | |
1448 | ticket_actions | new_accounting | 1.69 | | 6 | accounting | true | false | false | |
1471 | ticket_assignments | reseller | 1.44 | | 2 | accounting | false | false | false | |
1260 | ticket_brand_categories | brand | 1.44 | | 1 | accounting | false | false | false | |
1479 | tickets | brand | 1.46 | | 1 | accounting | false | false | false | |
1480 | tickets | reseller | 1.44 | | 2 | accounting | false | false | false | |
1482 | tickets | accounting | 1.0a126 | | 3 | accounting | true | false | false | |
297 | transactions | accounting | 1.0a100 | | 2 | accounting | false | false | false | the identifier for the business (see businesses) |
298 | transactions | source_accounting | 1.0a100 | | 3 | accounting | false | false | false | the source of the charge to this account |
123 | usernames | package | 1.80.0 | | 1 | accounting | false | false | false | the package name that this user is part of |
320 | WhoisHistoryAccount | account | 1.81.19 | | 2 | accounting | false | false | false | the id of the Account |
701 | ao_servers | restrict_outbound_email | 1.8 | | 11 | boolean | false | false | false | controls if outbound email may only come from address hosted on this machine |
143 | backup_partitions | enabled | 1.0a100 | | 3 | boolean | false | false | false | flags the partition as currently accepting new data |
93 | bank_transaction_types | isNegative | 1.81.18 | | 3 | boolean | false | false | false | if true the amount must be negative |
87 | bank_transactions | confirmed | 1.0a100 | | 10 | boolean | false | false | false | the confirmation status with bank |
1300 | brands | english_enabled | 1.44 | | 28 | boolean | false | false | false | |
1301 | brands | japanese_enabled | 1.44 | | 29 | boolean | false | false | false | |
1305 | brands | aoweb_struts_noindex | 1.44 | | 33 | boolean | false | false | false | |
36 | business_administrators | is_preferred | 1.0a100 | | 5 | boolean | false | false | false | if true, customers is preferred |
37 | business_administrators | private | 1.0a100 | | 6 | boolean | false | false | false | indicates if the admin should not be listed in publicly available lists |
55 | business_administrators | can_switch_users | 1.0a118 | | 20 | boolean | false | false | false | allows this person to switch users to any subaccounts |
100 | business_profiles | private | 1.0a100 | | 4 | boolean | false | false | false | indicates if the business should not be listed
in publicly available lists |
113 | business_profiles | send_invoice | 1.0a100 | | 13 | boolean | false | false | false | indicates to send a monthly invoice via regular mail |
21 | businesses | can_add_backup_server | 1.0a102 | | 6 | boolean | false | false | false | the business may add servers to the backup system |
22 | businesses | can_add_businesses | 1.0a100 | | 7 | boolean | false | false | false | if <code>true</code> this business can create
and be the parent of other businesses |
24 | businesses | can_see_prices | 1.0a103 | | 8 | boolean | false | false | false | if <code>false</code>, prices are filtered |
27 | businesses | auto_enable | 1.0a100 | | 11 | boolean | false | false | false | allows the account to be automatically reenabled
on payment |
28 | businesses | bill_parent | 1.0a100 | | 12 | boolean | false | false | false | if <code>true</code>, the parent business will
be charged for all resources used by this
account |
4 | business_servers | is_default | 1.0a100 | | 3 | boolean | false | false | false | if <code>true</code>, this is the default server. |
6 | business_servers | can_control_apache | 1.0a100 | | 4 | boolean | false | false | false | |
7 | business_servers | can_control_cron | 1.0a100 | | 5 | boolean | false | false | false | |
9 | business_servers | can_control_mysql | 1.0a100 | | 6 | boolean | false | false | false | |
10 | business_servers | can_control_postgresql | 1.0a100 | | 7 | boolean | false | false | false | |
11 | business_servers | can_control_xfs | 1.0a100 | | 8 | boolean | false | false | false | |
12 | business_servers | can_control_xvfb | 1.0a100 | | 9 | boolean | false | false | false | |
13 | business_servers | can_vnc_console | 1.51 | | 10 | boolean | false | false | false | |
14 | business_servers | can_control_virtual_server | 1.64 | | 11 | boolean | false | false | false | |
1013 | country_codes | charge_com_supported | 1.0a100 | | 2 | boolean | false | false | true | if the country is supported by Charge.Com |
1182 | credit_card_processors | enabled | 1.29 | | 7 | boolean | false | false | false | the enabled flag |
1068 | credit_card_transactions | test_mode | 1.29 | | 4 | boolean | false | false | false | indicates this is a test transaction |
1078 | credit_card_transactions | tax_exempt | 1.29 | | 9 | boolean | false | false | false | the taxExempt flag for this transaction |
1098 | credit_card_transactions | email_customer | 1.29 | | 21 | boolean | false | false | false | the flag indicating the API should generate an email to the customer |
1052 | credit_cards | use_monthly | 1.0a100 | | 25 | boolean | false | false | false | if <code>true</code> the card will be used monthly |
1053 | credit_cards | active | 1.0a100 | | 26 | boolean | false | false | false | if <code>true</code> the card is currently active |
415 | cyrus_imapd_binds | allow_plaintext_auth | 1.81.10 | | 4 | boolean | true | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
420 | cyrus_imapd_servers | allow_plaintext_auth | 1.81.10 | | 4 | boolean | false | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
1773 | distro_files | optional | 1.0a100 | | 3 | boolean | false | false | false | if the file is optional |
385 | dns_types | has_priority | 1.72 | | 2 | boolean | false | false | true | flags which types have a priority |
386 | dns_types | has_weight | 1.72 | | 3 | boolean | false | false | true | flags which types have a weight |
387 | dns_types | has_port | 1.72 | | 4 | boolean | false | false | true | flags which types have a port |
388 | dns_types | has_flag | 1.86.0 | | 5 | boolean | false | false | true | flags which types have a flag |
389 | dns_types | has_tag | 1.86.0 | | 6 | boolean | false | false | true | flags which types have a tag |
390 | dns_types | param_ip | 1.0a100 | | 7 | boolean | false | false | true | flags if the parameter is a IP or a hostname |
409 | email_attachment_types | is_default_block | 1.0a116 | | 2 | boolean | false | false | true | indicates that the type will be blocked by default |
162 | failover_file_log | is_successful | 1.0a100 | | 7 | boolean | false | false | false | keeps track of which passes completed successfully |
176 | failover_file_replications | use_compression | 1.9 | | 4 | boolean | false | false | false | when compression is enabled, chunk mode is used on mirroring, resulting in more CPU and disk, but less bandwidth |
182 | failover_file_replications | enabled | 1.15 | | 8 | boolean | false | false | false | the enabled flag for failovers |
167 | failover_file_schedule | enabled | 1.0a100 | | 4 | boolean | false | false | false | |
194 | file_backup_settings | backup_enabled | 1.31 | | 3 | boolean | false | false | false | the enabled flag for this prefix |
197 | file_backup_settings | required | 1.62 | | 4 | boolean | false | false | false | indicates that backup pass will not be considered successful if file or path is missing |
957 | firewalld_zones | fail2ban | 1.81.9 | | 5 | boolean | false | false | false | enables Fail2ban on services in this zone |
1527 | httpd_servers | can_add_sites | 1.0a100 | | 3 | boolean | false | false | false | indicated that more sites may be added to the server |
1533 | httpd_servers | use_suexec | 1.0a102 | | 7 | boolean | false | false | false | indicates that the suexec wrapper will be used for CGI |
1536 | httpd_servers | is_shared | 1.0a102 | | 9 | boolean | false | false | false | indicates that any user on the server may use this httpd instance |
1537 | httpd_servers | use_mod_perl | 1.0a103 | | 10 | boolean | false | false | false | |
1544 | httpd_servers | mod_access_compat | 1.81.7 | | 17 | boolean | true | false | false | manually enables or disables the mod_access_compat Apache module for this server instance |
1545 | httpd_servers | mod_actions | 1.81.7 | | 18 | boolean | true | false | false | manually enables or disables the mod_actions Apache module for this server instance |
1546 | httpd_servers | mod_alias | 1.81.7 | | 19 | boolean | true | false | false | manually enables or disables the mod_alias Apache module for this server instance |
1547 | httpd_servers | mod_auth_basic | 1.81.7 | | 20 | boolean | true | false | false | manually enables or disables the mod_auth_basic Apache module for this server instance |
1548 | httpd_servers | mod_authn_core | 1.81.7 | | 21 | boolean | true | false | false | manually enables or disables the mod_authn_core Apache module for this server instance |
1549 | httpd_servers | mod_authn_file | 1.81.7 | | 22 | boolean | true | false | false | manually enables or disables the mod_authn_file Apache module for this server instance |
1550 | httpd_servers | mod_authz_core | 1.81.7 | | 23 | boolean | true | false | false | manually enables or disables the mod_authz_core Apache module for this server instance |
1551 | httpd_servers | mod_authz_groupfile | 1.81.7 | | 24 | boolean | true | false | false | manually enables or disables the mod_authz_groupfile Apache module for this server instance |
1552 | httpd_servers | mod_authz_host | 1.81.7 | | 25 | boolean | true | false | false | manually enables or disables the mod_authz_host Apache module for this server instance |
1553 | httpd_servers | mod_authz_user | 1.81.7 | | 26 | boolean | true | false | false | manually enables or disables the mod_authz_user Apache module for this server instance |
1554 | httpd_servers | mod_autoindex | 1.81.7 | | 27 | boolean | true | false | false | manually enables or disables the mod_autoindex Apache module for this server instance |
1555 | httpd_servers | mod_deflate | 1.81.7 | | 28 | boolean | true | false | false | manually enables or disables the mod_deflate Apache module for this server instance |
1556 | httpd_servers | mod_dir | 1.81.7 | | 29 | boolean | true | false | false | manually enables or disables the mod_dir Apache module for this server instance |
1557 | httpd_servers | mod_filter | 1.81.7 | | 30 | boolean | true | false | false | manually enables or disables the mod_filter Apache module for this server instance |
1558 | httpd_servers | mod_headers | 1.81.7 | | 31 | boolean | true | false | false | manually enables or disables the mod_headers Apache module for this server instance |
1559 | httpd_servers | mod_include | 1.81.7 | | 32 | boolean | true | false | false | manually enables or disables the mod_include Apache module for this server instance |
1560 | httpd_servers | mod_jk | 1.81.7 | | 33 | boolean | true | false | false | manually enables or disables the mod_jk Apache module for this server instance |
1561 | httpd_servers | mod_log_config | 1.81.7 | | 34 | boolean | true | false | false | manually enables or disables the mod_log_config Apache module for this server instance |
1562 | httpd_servers | mod_mime | 1.81.7 | | 35 | boolean | true | false | false | manually enables or disables the mod_mime Apache module for this server instance |
1563 | httpd_servers | mod_mime_magic | 1.81.7 | | 36 | boolean | true | false | false | manually enables or disables the mod_mime_magic Apache module for this server instance |
1564 | httpd_servers | mod_negotiation | 1.81.7 | | 37 | boolean | true | false | false | manually enables or disables the mod_negotiation Apache module for this server instance |
1565 | httpd_servers | mod_proxy | 1.81.7 | | 38 | boolean | true | false | false | manually enables or disables the mod_proxy Apache module for this server instance |
1566 | httpd_servers | mod_proxy_http | 1.81.7 | | 39 | boolean | true | false | false | manually enables or disables the mod_proxy_http Apache module for this server instance |
1567 | httpd_servers | mod_reqtimeout | 1.81.7 | | 40 | boolean | true | false | false | manually enables or disables the mod_reqtimeout Apache module for this server instance |
1568 | httpd_servers | mod_rewrite | 1.81.7 | | 41 | boolean | true | false | false | manually enables or disables the mod_rewrite Apache module for this server instance |
1569 | httpd_servers | mod_setenvif | 1.81.7 | | 42 | boolean | true | false | false | manually enables or disables the mod_setenvif Apache module for this server instance |
1570 | httpd_servers | mod_socache_shmcb | 1.81.7 | | 43 | boolean | true | false | false | manually enables or disables the mod_socache_shmcb Apache module for this server instance |
1571 | httpd_servers | mod_ssl | 1.81.7 | | 44 | boolean | true | false | false | manually enables or disables the mod_ssl Apache module for this server instance |
1572 | httpd_servers | mod_status | 1.81.7 | | 45 | boolean | true | false | false | manually enables or disables the mod_status Apache module for this server instance |
1573 | httpd_servers | mod_wsgi | 1.81.10 | | 46 | boolean | true | false | false | manually enables or disables the mod_wsgi Apache module for this server instance |
2521 | httpd_shared_tomcats | is_manual | 1.0a100 | | 10 | boolean | false | false | false | the configuration files are manually maintained |
2524 | httpd_shared_tomcats | unpack_wars | 1.80.1 | | 13 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
2525 | httpd_shared_tomcats | auto_deploy | 1.80.1 | | 14 | boolean | false | false | false | the autoDeploy setting for this Tomcat |
2526 | httpd_shared_tomcats | undeployOldVersions | 1.92.0 | | 15 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |
2527 | httpd_shared_tomcats | tomcatAuthentication | 1.83.2 | | 16 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
1577 | httpd_site_authenticated_locations | is_regular_expression | 1.18 | | 3 | boolean | false | false | false | regular expressions may be used, resulting in LocationMatch directives instead of Location |
1514 | httpd_site_bind_headers | always | 1.81.15 | | 4 | boolean | false | false | false | the condition is either "onsuccess" (default, can be omitted) or "always" |
1651 | httpd_site_binds | is_manual | 1.0a100 | | 9 | boolean | false | false | false | the config file is manually maintained |
1652 | httpd_site_binds | redirect_to_primary_hostname | 1.19 | | 10 | boolean | false | false | false | tells 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 |
1638 | httpd_site_urls | is_primary | 1.0a100 | | 3 | boolean | false | false | false | flags 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. |
1602 | httpd_sites | list_first | 1.0a100 | | 3 | boolean | false | false | false | if <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. |
1620 | httpd_sites | is_manual | 1.0a100 | | 9 | boolean | false | false | false | configuration of this server is performed manually |
1623 | httpd_sites | enable_cgi | 1.80 | | 12 | boolean | false | false | false | CGI is enabled on this website |
1624 | httpd_sites | enable_ssi | 1.80.1 | | 13 | boolean | false | false | false | Server-side includes are enabled on this website |
1625 | httpd_sites | enable_htaccess | 1.80.1 | | 14 | boolean | false | false | false | .htaccess files are enabled on this website |
1626 | httpd_sites | enable_indexes | 1.80.1 | | 15 | boolean | false | false | false | Directory indexes are enabled on this website |
1627 | httpd_sites | enable_follow_symlinks | 1.80.1 | | 16 | boolean | false | false | false | Symbolic link following is enabled on this website (required for mod_rewrite) |
1628 | httpd_sites | enable_anonymous_ftp | 1.80.1 | | 17 | boolean | false | false | false | Enables the anonymous FTP area for this site. |
1629 | httpd_sites | block_trace_track | 1.81.6 | | 18 | boolean | false | false | false | Enables the blocking of TRACE and TRACK HTTP methods on this site. |
1630 | httpd_sites | block_scm | 1.81.6 | | 19 | boolean | false | false | false | Enables the blocking of URL patterns associated with source control management systems. |
1631 | httpd_sites | block_core_dumps | 1.81.6 | | 20 | boolean | false | false | false | Enables the blocking of core dumps. |
1632 | httpd_sites | block_editor_backups | 1.81.6 | | 21 | boolean | false | false | false | Enables the blocking filename patterns associated with editor automatic backups. |
2476 | httpd_tomcat_contexts | cookies | 1.0a100 | | 3 | boolean | false | false | false | the cookies attribute |
2477 | httpd_tomcat_contexts | cross_context | 1.0a100 | | 4 | boolean | false | false | false | the crossContext attribute |
2480 | httpd_tomcat_contexts | override | 1.0a100 | | 6 | boolean | false | false | false | the override attribute |
2482 | httpd_tomcat_contexts | privileged | 1.0a100 | | 8 | boolean | false | false | false | the privileged attribute |
2483 | httpd_tomcat_contexts | reloadable | 1.0a100 | | 9 | boolean | false | false | false | the reloadable attribute |
2484 | httpd_tomcat_contexts | use_naming | 1.0a100 | | 10 | boolean | false | false | false | the useNaming attribute |
2488 | httpd_tomcat_contexts | server_xml_configured | 1.81.3 | | 14 | boolean | false | false | false | flag setting if the context is written into conf/server.xml |
2471 | httpd_tomcat_parameters | override | 1.5 | | 4 | boolean | false | false | false | set 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. |
2492 | httpd_tomcat_site_jk_mounts | mount | 1.81.6 | | 3 | boolean | false | false | false | true for JkMount, false for JkUnMount |
2533 | httpd_tomcat_sites | block_webinf | 1.81.6 | | 2 | boolean | false | false | false | Blocks access to /META-INF and /WEB-INF at the Apache level. |
2499 | httpd_tomcat_std_sites | unpack_wars | 1.80.1 | | 5 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
2500 | httpd_tomcat_std_sites | auto_deploy | 1.80.1 | | 6 | boolean | false | false | false | the autoDeploy setting for this Tomcat |
2501 | httpd_tomcat_std_sites | undeployOldVersions | 1.92.0 | | 7 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |
2502 | httpd_tomcat_std_sites | tomcatAuthentication | 1.83.2 | | 8 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
2536 | httpd_tomcat_versions | requires_mod_jk | 1.0a100 | | 2 | boolean | false | false | true | indicates that this version of Tomcat requires the use of mod_jk |
982 | ip_addresses | isAlias | 1.81.18 | | 3 | boolean | false | false | false | indicates that the IP address is using IP aliasing on the network device |
991 | ip_addresses | isAvailable | 1.81.18 | | 7 | boolean | false | false | false | a flag if the IP address is available |
993 | ip_addresses | isOverflow | 1.81.18 | | 8 | boolean | false | false | false | indicates that the IP address is shared by different accounts |
995 | ip_addresses | isDhcp | 1.81.18 | | 9 | boolean | false | false | false | the IP address is obtained via DHCP |
2337 | IpAddressMonitoring | enabled | 1.81.18 | | 1 | boolean | false | false | false | indicates that this IP address should be monitored |
2338 | IpAddressMonitoring | pingMonitorEnabled | 1.81.18 | | 2 | boolean | false | false | false | if ping (ICMP ECHO) is available for monitoring, defaults to true |
2339 | IpAddressMonitoring | checkBlacklistsOverSmtp | 1.81.18 | | 3 | boolean | false | false | false | allows determining some types of blacklists over SMTP protocol |
2340 | IpAddressMonitoring | verifyDnsPtr | 1.81.18 | | 4 | boolean | false | false | false | enables monitoring of reverse DNS |
2341 | IpAddressMonitoring | verifyDnsA | 1.81.18 | | 5 | boolean | false | false | false | enables monitoring of forward DNS |
2393 | ip_reputation_sets | allow_subaccount_use | 1.65 | | 3 | boolean | false | false | false | allows subaccounts to use the set |
768 | linux_account_types | is_email | 1.0a100 | | 2 | boolean | false | false | true | can email be associated with this account |
662 | linux_group_accounts | isPrimary | 1.81.18 | | 3 | boolean | false | false | false | flag showing that this group is the user's primary group |
754 | linux_server_accounts | is_autoresponder_enabled | 1.0a100 | | 8 | boolean | false | false | false | flags if the autoresponder is enabled |
759 | linux_server_accounts | use_inbox | 1.0a100 | | 12 | boolean | false | false | false | email for this account will be stored in the inbox, otherwise it is just deleted |
784 | master_processes | is_secure | 1.0a100 | | 8 | boolean | false | false | false | |
803 | master_users | is_active | 1.0a100 | | 1 | boolean | false | false | false | this level of access may be disabled |
804 | master_users | can_access_accounting | 1.0a100 | | 2 | boolean | false | false | false | if they can access accounting resources |
805 | master_users | can_access_bank_accounting | 1.0a100 | | 3 | boolean | false | false | false | if they can access bank account info |
806 | master_users | can_invalidate_tables | 1.0a100 | | 4 | boolean | false | false | false | if they can invalidate master tables |
807 | master_users | can_access_admin_web | 1.0a100 | | 5 | boolean | false | false | false | if they can access administrative web pages |
809 | master_users | is_dns_admin | 1.0a100 | | 6 | boolean | false | false | false | if they can access all DNS stuff |
811 | master_users | is_router | 1.65 | | 7 | boolean | false | false | false | if they read all router stuff |
812 | master_users | is_cluster_admin | 1.73 | | 8 | boolean | false | false | false | if they can control cluster resources |
222 | monthly_charges | active | 1.0a100 | | 9 | boolean | false | false | false | flags if this entry is active |
827 | mysql_db_users | select_priv | 1.0a100 | | 3 | boolean | false | false | false | the SELECT privilege |
828 | mysql_db_users | insert_priv | 1.0a100 | | 4 | boolean | false | false | false | the INSERT privilege |
829 | mysql_db_users | update_priv | 1.0a100 | | 5 | boolean | false | false | false | the UPDATE privilege |
830 | mysql_db_users | delete_priv | 1.0a100 | | 6 | boolean | false | false | false | the DELETE privilege |
831 | mysql_db_users | create_priv | 1.0a100 | | 7 | boolean | false | false | false | the CREATE privilege |
832 | mysql_db_users | drop_priv | 1.0a100 | | 8 | boolean | false | false | false | the DROP privilege |
833 | mysql_db_users | grant_priv | 1.0a100 | | 9 | boolean | false | false | false | the GRANT privilege |
834 | mysql_db_users | references_priv | 1.0a100 | | 10 | boolean | false | false | false | the REFERENCES privilege |
835 | mysql_db_users | index_priv | 1.0a100 | | 11 | boolean | false | false | false | the INDEX privilege |
836 | mysql_db_users | alter_priv | 1.0a100 | | 12 | boolean | false | false | false | the ALTER privilete |
837 | mysql_db_users | create_tmp_table_priv | 1.0a111 | | 13 | boolean | false | false | false | the Create_tmp_table_priv |
838 | mysql_db_users | lock_tables_priv | 1.0a111 | | 14 | boolean | false | false | false | the Lock_tables_priv |
839 | mysql_db_users | create_view_priv | 1.4 | | 15 | boolean | false | false | false | the Create_view_priv |
840 | mysql_db_users | show_view_priv | 1.4 | | 16 | boolean | false | false | false | the Show_view_priv |
841 | mysql_db_users | create_routine_priv | 1.4 | | 17 | boolean | false | false | false | the Create_routine_priv |
842 | mysql_db_users | alter_routine_priv | 1.4 | | 18 | boolean | false | false | false | the Alter_routine_priv |
843 | mysql_db_users | execute_priv | 1.4 | | 19 | boolean | false | false | false | the Execute_priv |
844 | mysql_db_users | event_priv | 1.54 | | 20 | boolean | false | false | false | the Event_priv |
845 | mysql_db_users | trigger_priv | 1.54 | | 21 | boolean | false | false | false | the Trigger_priv |
858 | mysql_users | select_priv | 1.0a100 | | 1 | boolean | false | false | false | the SELECT privilege to all databases |
859 | mysql_users | insert_priv | 1.0a100 | | 2 | boolean | false | false | false | the INSERT privilege to all databases |
860 | mysql_users | update_priv | 1.0a100 | | 3 | boolean | false | false | false | the UPDATE privilege to all databases |
861 | mysql_users | delete_priv | 1.0a100 | | 4 | boolean | false | false | false | the DELETE privilege to all databases |
862 | mysql_users | create_priv | 1.0a100 | | 5 | boolean | false | false | false | the CREATE privilege to all databases |
863 | mysql_users | drop_priv | 1.0a100 | | 6 | boolean | false | false | false | the DROP privilege to all databases |
864 | mysql_users | reload_priv | 1.0a100 | | 7 | boolean | false | false | false | the RELOAD privilege to all databases |
865 | mysql_users | shutdown_priv | 1.0a100 | | 8 | boolean | false | false | false | the SHUTDOWN privilege to all databases |
866 | mysql_users | process_priv | 1.0a100 | | 9 | boolean | false | false | false | the PROCESS privilege to all databases |
867 | mysql_users | file_priv | 1.0a100 | | 10 | boolean | false | false | false | the FILE privilege to all databases |
868 | mysql_users | grant_priv | 1.0a100 | | 11 | boolean | false | false | false | the GRANT privilege to all databases |
869 | mysql_users | references_priv | 1.0a100 | | 12 | boolean | false | false | false | the REFERENCES privilege to all databases |
870 | mysql_users | index_priv | 1.0a100 | | 13 | boolean | false | false | false | the INDEX privilege to all databases |
871 | mysql_users | alter_priv | 1.0a100 | | 14 | boolean | false | false | false | the ALTER privilete to all databases |
872 | mysql_users | show_db_priv | 1.0a111 | | 15 | boolean | false | false | false | |
873 | mysql_users | super_priv | 1.0a111 | | 16 | boolean | false | false | false | |
874 | mysql_users | create_tmp_table_priv | 1.0a111 | | 17 | boolean | false | false | false | |
875 | mysql_users | lock_tables_priv | 1.0a111 | | 18 | boolean | false | false | false | |
876 | mysql_users | execute_priv | 1.0a111 | | 19 | boolean | false | false | false | |
877 | mysql_users | repl_slave_priv | 1.0a111 | | 20 | boolean | false | false | false | |
878 | mysql_users | repl_client_priv | 1.0a111 | | 21 | boolean | false | false | false | |
879 | mysql_users | create_view_priv | 1.4 | | 22 | boolean | false | false | false | |
880 | mysql_users | show_view_priv | 1.4 | | 23 | boolean | false | false | false | |
881 | mysql_users | create_routine_priv | 1.4 | | 24 | boolean | false | false | false | |
882 | mysql_users | alter_routine_priv | 1.4 | | 25 | boolean | false | false | false | |
883 | mysql_users | create_user_priv | 1.4 | | 26 | boolean | false | false | false | |
884 | mysql_users | event_priv | 1.54 | | 27 | boolean | false | false | false | the Event_priv |
885 | mysql_users | trigger_priv | 1.54 | | 28 | boolean | false | false | false | the Trigger_priv |
928 | net_binds | monitoring_enabled | 1.0a104 | | 6 | boolean | false | false | false | turns on monitoring of the port |
931 | net_device_ids | is_loopback | 1.0a100 | | 1 | boolean | false | false | true | if the device is the loopback device |
951 | net_devices | monitoring_enabled | 1.70 | | 14 | boolean | false | false | false | indicates that this device should be monitored |
344 | operating_system_versions | is_aoserv_daemon_supported | 1.0a108 | | 6 | boolean | false | false | true | can AOServ Daemon be ran on this OS |
336 | operating_systems | is_unix | 1.0a100 | | 2 | boolean | false | false | true | indicates that this is a Unix-based OS |
262 | package_definitions | active | 1.0a123 | | 11 | boolean | false | false | false | allows new accounts for this package |
263 | package_definitions | approved | 1.0a123 | | 12 | boolean | false | false | false | once approved a definition may be used for packages, but may not be modified |
1173 | payment_types | active | 1.0a100 | | 2 | boolean | false | false | true | indicates if payment is currently accepted via this method |
1174 | payment_types | allow_web | 1.0a100 | | 3 | boolean | false | false | true | indicates if payment is allowed via a web form |
568 | physical_servers | supports_hvm | 1.37 | | 8 | boolean | true | false | false | indicates supports full hardware virtualization |
1220 | postgres_databases | is_template | 1.0a100 | | 5 | boolean | false | false | false | if true, this database is a template |
1221 | postgres_databases | allow_conn | 1.0a100 | | 6 | boolean | false | false | false | if true, this database is accepting connections |
1224 | postgres_databases | enable_postgis | 1.27 | | 7 | boolean | false | false | false | indicates PostGIS is enabled on this database |
1238 | postgres_servers | fsync | 1.0a100 | | 7 | boolean | false | false | false | indicates that writes are synchronous |
1242 | postgres_users | createdb | 1.0a100 | | 1 | boolean | false | false | false | usecreatedb flag |
1243 | postgres_users | trace | 1.0a100 | | 2 | boolean | false | false | false | usetrace flag |
1244 | postgres_users | super | 1.0a100 | | 3 | boolean | false | false | false | usesuper flag |
1245 | postgres_users | catupd | 1.0a100 | | 4 | boolean | false | false | false | usecatupd flag |
559 | private_ftp_servers | allow_anonymous | 1.0a113 | | 6 | boolean | false | false | false | enabled or disabled anonymous access to the server |
905 | protocols | is_user_service | 1.0a105 | | 3 | boolean | false | false | true | indicates that a user may add and remove this service |
1315 | resellers | ticket_auto_escalate | 1.44 | | 1 | boolean | false | false | false | |
1333 | schema_columns | isNullable | 1.81.18 | | 7 | boolean | false | false | true | if the value may be null |
1335 | schema_columns | isUnique | 1.81.18 | | 8 | boolean | false | false | true | if true, the value is unique across rows |
1337 | schema_columns | isPublic | 1.81.18 | | 9 | boolean | false | false | true | if the value is publicly accessible |
1360 | schema_tables | isPublic | 1.81.18 | | 5 | boolean | false | false | true | if the data contained in the table is accessible to everybody |
493 | sendmail_servers | allow_plaintext_auth | 1.81.10 | | 7 | boolean | false | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
583 | server_farms | use_restricted_smtp_port | 1.26 | | 3 | boolean | false | false | false | outgoing servers should use restricted source ports (affects firewall rules) |
974 | servers | monitoring_enabled | 1.32 | | 6 | boolean | false | false | false | enables/disables monitoring |
719 | shells | is_login | 1.0a100 | | 1 | boolean | false | false | true | indicates if the shells gives process control |
720 | shells | is_system | 1.0a100 | | 2 | boolean | false | false | true | indicates that this shell is for internal use only |
1432 | signup_requests | billing_use_monthly | 1.23 | | 30 | boolean | false | false | false | if true, the credit_card will be used every month automatically |
1433 | signup_requests | billing_pay_one_year | 1.23 | | 31 | boolean | false | false | false | if true, one-year in advance will be charged to the credit_card and they will receive a credit for a free month |
1189 | ssl_certificate_names | is_common_name | 1.81.10 | | 2 | boolean | false | false | false | indicates this is the Common Name (CN) or a Subject Alt Name |
1190 | ssl_certificate_names | is_wildcard | 1.81.10 | | 3 | boolean | false | false | false | is a *.(domain) wildcard certificate |
1468 | ticket_action_types | visible_admin_only | 1.44 | | 1 | boolean | false | false | true | |
1262 | ticket_brand_categories | enabled | 1.44 | | 3 | boolean | false | false | false | |
317 | transaction_types | is_credit | 1.0a123 | | 1 | boolean | false | false | true | indicates that this type of transaction represents payment or credit |
628 | virtual_servers | primary_physical_server_locked | 1.36 | | 13 | boolean | false | false | false | indicates the primary server is locked and should not be moved by automated means |
630 | virtual_servers | secondary_physical_server_locked | 1.36 | | 14 | boolean | false | false | false | indicates the secondary server is locked and should not be moved by automated means |
631 | virtual_servers | requires_hvm | 1.37 | | 15 | boolean | false | false | false | indicates requires full hardware virtualization |
1317 | aoserv_protocols | created | 1.0a101 | | 1 | date | false | false | true | the time the version was added |
1320 | aoserv_protocols | lastUsed | 1.81.18 | | 3 | date | true | false | true | the date this protocol was last used |
148 | backup_reports | date | 1.0a101 | | 3 | date | false | false | false | the date the summary is for |
35 | business_administrators | birthday | 1.69 | | 4 | date | true | false | false | the admins birthday |
86 | bank_transactions | amount | 1.0a100 | | 9 | decimal_2 | false | false | false | the amount (negative for withdrawal) |
217 | monthly_charges | quantity | 1.0a100 | | 5 | decimal_3 | false | false | false | the quantity |
302 | transactions | quantity | 1.0a100 | | 7 | decimal_3 | false | false | false | the number of times to charge the account |
678 | ao_servers | hostname | 1.69 | | 1 | domain_name | false | true | false | the unique hostname of the server |
1265 | brands | nameserver1 | 1.69 | | 1 | domain_name | false | false | false | |
1267 | brands | nameserver2 | 1.69 | | 2 | domain_name | false | false | false | |
1269 | brands | nameserver3 | 1.69 | | 3 | domain_name | true | false | false | |
1271 | brands | nameserver4 | 1.69 | | 4 | domain_name | true | false | false | |
413 | cyrus_imapd_binds | servername | 1.81.10 | | 2 | domain_name | true | false | false | the servername for this bind |
418 | cyrus_imapd_servers | servername | 1.81.10 | | 2 | domain_name | true | false | false | the servername for this server |
392 | dns_tlds | domain | 1.69 | | 0 | domain_name | false | true | true | the domain |
429 | email_domains | domain | 1.69 | | 1 | domain_name | false | false | false | the domain that is hosted in the email |
526 | email_smtp_smart_host_domains | domain | 1.69 | | 2 | domain_name | false | false | false | the specific domain that is being configured |
1637 | httpd_site_urls | hostname | 1.69 | | 2 | domain_name | false | false | false | the hostname that this site responds to |
984 | ip_addresses | hostname | 1.69 | | 4 | domain_name | true | false | false | the reverse mapping for the hostname, null only allowed for the "0.0.0.0"" or "::" IP addresses |
552 | private_ftp_servers | hostname | 1.69 | | 2 | domain_name | false | false | false | the hostname the server reports |
490 | sendmail_servers | hostname | 1.81.10 | | 4 | domain_name | true | false | false | the fully qualified hostname for Dw, Dm, and Dj |
1191 | ssl_certificate_names | domain | 1.81.10 | | 4 | domain_name | false | false | false | the domain name |
327 | WhoisHistory | registrableDomain | 1.81.19 | | 1 | domain_name | false | false | false | the registrable domain that was queried |
43 | business_administrators | email | 1.0a100 | | 12 | email | false | false | false | the email address |
1099 | credit_card_transactions | merchant_email | 1.29 | | 22 | email | true | false | false | the email address of the merchant |
1114 | credit_card_transactions | credit_card_email | 1.29 | | 37 | email | true | false | false | the email address of the card holder |
1030 | credit_cards | email | 1.29 | | 11 | email | true | false | false | the email address |
435 | email_forwarding | destination | 1.0a100 | | 2 | email | false | false | false | the destination of the email |
1609 | httpd_sites | server_admin | 1.0a100 | | 7 | email | false | false | false | the 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> |
230 | notice_log | billing_email | 1.0a100 | | 4 | email | false | false | false | |
553 | private_ftp_servers | email | 1.0a100 | | 3 | email | false | false | false | the email address the server reports |
1418 | signup_requests | ba_email | 1.23 | | 20 | email | false | false | false | the administrator's email address |
1431 | signup_requests | billing_email | 1.23 | | 29 | email | false | false | false | the email address of the billing contact |
1463 | ticket_actions | from_address | 1.44 | | 19 | email | true | false | false | |
1488 | tickets | from_address | 1.44 | | 8 | email | true | false | false | |
954 | firewalld_zones | name | 1.81.0 | | 2 | firewalld_zone_name | false | false | false | the name of the Firewalld zone |
634 | ao_server_daemon_hosts | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the ao_server |
665 | ao_servers | server | 1.0a100 | | 0 | fkey | false | true | false | a reference to servers |
679 | ao_servers | daemon_bind | 1.0a100 | | 2 | fkey | true | false | false | the network bind info for the AOServ Daemon |
685 | ao_servers | failover_server | 1.0a100 | | 6 | fkey | true | false | false | the server that is currently running this server |
698 | ao_servers | daemon_connect_bind | 1.0a119 | | 8 | fkey | true | false | false | the bind to connect to |
700 | ao_servers | jilter_bind | 1.7 | | 10 | fkey | true | false | false | the bind that sendmail uses to connect to jilter |
138 | backup_partitions | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that stores the backup data |
146 | backup_reports | server | 1.0a101 | | 1 | fkey | false | false | false | the pkey of the server being backed-up |
147 | backup_reports | package | 1.0a101 | | 2 | fkey | false | false | false | the pkey of the package the data is assigned to |
410 | blackhole_email_addresses | email_address | 1.0a100 | | 0 | fkey | false | true | false | the primary key of the email_address |
1272 | brands | smtp_linux_server_account | 1.44 | | 5 | fkey | false | true | false | |
1275 | brands | imap_linux_server_account | 1.44 | | 8 | fkey | false | true | false | |
1278 | brands | support_email_address | 1.44 | | 11 | fkey | false | true | false | |
1280 | brands | signup_email_address | 1.44 | | 13 | fkey | false | true | false | |
1282 | brands | ticket_encryption_from | 1.44 | | 15 | fkey | false | false | false | |
1283 | brands | ticket_encryption_recipient | 1.44 | | 16 | fkey | false | false | false | |
1284 | brands | signup_encryption_from | 1.44 | | 17 | fkey | false | false | false | |
1285 | brands | signup_encryption_recipient | 1.44 | | 18 | fkey | false | false | false | |
1308 | brands | aoweb_struts_vnc_bind | 1.52 | | 36 | fkey | false | true | false | |
54 | business_administrators | disable_log | 1.0a100 | | 19 | fkey | true | false | false | indicates that this account is disabled |
25 | businesses | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates the business is disabled |
3 | business_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the server |
1185 | credit_card_processors | encryption_from | 1.31 | | 10 | fkey | false | false | false | the from that will be used for encryption |
1186 | credit_card_processors | encryption_recipient | 1.31 | | 11 | fkey | false | false | false | the recipient that will be used for encryption |
1059 | credit_cards | encryption_card_number_from | 1.31 | | 31 | fkey | true | false | false | the from that was used for card number encryption |
1060 | credit_cards | encryption_card_number_recipient | 1.31 | | 32 | fkey | true | false | false | the recipient that was used for card number encryption |
1376 | cvs_repositories | linux_server_account | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the directory owner |
1377 | cvs_repositories | linux_server_group | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the directory group |
1382 | cvs_repositories | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that this repository is disabled |
411 | cyrus_imapd_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
412 | cyrus_imapd_binds | cyrus_imapd_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
414 | cyrus_imapd_binds | certificate | 1.81.10 | | 3 | fkey | true | false | false | the certificate used by this bind |
416 | cyrus_imapd_servers | ao_server | 1.81.10 | | 0 | fkey | false | true | false | the pkey of the server that runs this Cyrus IMAPD instance |
417 | cyrus_imapd_servers | sieve_net_bind | 1.81.10 | | 1 | fkey | true | true | false | the port the server binds to for sieve, if enabled |
419 | cyrus_imapd_servers | certificate | 1.81.10 | | 3 | fkey | false | false | false | the certificate used for this server |
1770 | distro_files | operating_system_version | 1.0a108 | | 1 | fkey | false | false | false | the OS version that contains the file |
380 | dns_records | dhcpAddress | 1.81.18 | | 10 | fkey | true | false | false | the id of the IP address whos changes are followed |
403 | email_addresses | domain | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email domain |
405 | email_attachment_blocks | linux_server_account | 1.0a116 | | 1 | fkey | false | false | false | reference to the email inbox |
430 | email_domains | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that is hosting the email |
434 | email_forwarding | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
441 | email_list_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
442 | email_list_addresses | email_list | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email list |
446 | email_lists | linux_server_account | 1.31 | | 2 | fkey | false | false | false | the linux_server_account that owns the list |
448 | email_lists | linux_server_group | 1.31 | | 3 | fkey | false | false | false | the linux_server_group that the list belongs to please note that ownership and server are derived from this value |
451 | email_lists | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this list is disabled |
473 | email_pipe_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
474 | email_pipe_addresses | email_pipe | 1.0a100 | | 2 | fkey | false | false | false | the primary key of the email pipe |
476 | email_pipes | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the program resides on |
481 | email_pipes | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this email pipe is disabled |
511 | email_smtp_relays | ao_server | 1.0a100 | | 2 | fkey | true | false | false | the pkey of the server that the rule applies to |
519 | email_smtp_relays | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates that the rule is disabled |
524 | email_smtp_smart_host_domains | smart_host | 1.57 | | 1 | fkey | false | false | false | the Smart Host that is being configured |
529 | email_smtp_smart_hosts | net_bind | 1.57 | | 0 | fkey | false | true | false | a reference to the port that is being used as a Smart Host |
156 | failover_file_log | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that was performed |
170 | failover_file_replications | server | 1.31 | | 1 | fkey | false | false | false | the pkey of the server that the files are coming from |
172 | failover_file_replications | backup_partition | 1.31 | | 2 | fkey | false | false | false | the pkey of the backup partition that the files are going to |
164 | failover_file_schedule | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that will be started |
199 | failover_mysql_replications | ao_server | 1.59 | | 1 | fkey | true | false | false | the ao_server the receives the replication |
201 | failover_mysql_replications | replication | 1.59 | | 2 | fkey | true | false | false | the failover server that receives the replication |
202 | failover_mysql_replications | mysql_server | 1.28 | | 3 | fkey | false | false | false | the MySQL Server that is being replicated |
190 | file_backup_settings | replication | 1.31 | | 1 | fkey | false | false | false | the pkey of the failover_file_replication configured |
953 | firewalld_zones | server | 1.81.0 | | 1 | fkey | false | false | false | the pkey of the server |
1521 | httpd_binds | net_bind | 1.0a100 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
1522 | httpd_binds | httpd_server | 1.0a100 | | 1 | fkey | false | false | false | the server that is listening on the address |
2447 | httpd_jboss_sites | version | 1.0a100 | | 1 | fkey | false | false | false | reference to httpd_jboss_versions |
2448 | httpd_jboss_sites | jnp_bind | 1.0a100 | | 2 | fkey | false | false | false | reference to net_binds |
2449 | httpd_jboss_sites | webserver_bind | 1.0a100 | | 3 | fkey | false | false | false | reference to net_binds |
2450 | httpd_jboss_sites | rmi_bind | 1.0a100 | | 4 | fkey | false | false | false | reference to net_binds |
2451 | httpd_jboss_sites | hypersonic_bind | 1.0a100 | | 5 | fkey | false | false | false | reference to net_binds |
2452 | httpd_jboss_sites | jmx_bind | 1.0a100 | | 6 | fkey | false | false | false | reference to net_binds |
2454 | httpd_jboss_versions | tomcat_version | 1.0a100 | | 1 | fkey | false | false | true | version of tomcat associated with this jboss version |
1524 | httpd_servers | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that hosts the httpd |
1530 | httpd_servers | linux_server_account | 1.0a102 | | 4 | fkey | false | false | false | the account to run as |
1531 | httpd_servers | linux_server_group | 1.0a102 | | 5 | fkey | false | false | false | the group to run as |
1532 | httpd_servers | mod_php_version | 1.0a102 | | 6 | fkey | true | false | false | the version of mod_php to run |
1534 | httpd_servers | package | 1.0a102 | | 8 | fkey | false | false | false | the package that owns the server |
2505 | httpd_shared_tomcats | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server on which this jvm resides |
2506 | httpd_shared_tomcats | version | 1.0a100 | | 3 | fkey | false | false | false | the tomcat version |
2507 | httpd_shared_tomcats | linux_server_account | 1.0a100 | | 4 | fkey | false | false | false | the account under which this tomcat runs |
2508 | httpd_shared_tomcats | linux_server_group | 1.0a100 | | 5 | fkey | false | false | false | the group to which this tomcat is assigned |
2517 | httpd_shared_tomcats | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the JVM is disabled |
2518 | httpd_shared_tomcats | tomcat4_worker | 1.0a100 | | 7 | fkey | true | true | false | the httpd_worker for Tomcat version 4 |
2519 | httpd_shared_tomcats | tomcat4_shutdown_port | 1.0a100 | | 8 | fkey | true | true | false | the port that will shut down this JVM |
1575 | httpd_site_authenticated_locations | httpd_site | 1.18 | | 1 | fkey | false | false | false | the site that is being referenced |
1511 | httpd_site_bind_headers | httpd_site_bind | 1.81.15 | | 1 | fkey | false | false | false | the site bind that is being referenced |
1591 | RewriteRule | virtualHost | 1.81.21 | | 1 | fkey | false | false | false | the VirtualHost this rule is applied to |
1640 | httpd_site_binds | httpd_site | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
1641 | httpd_site_binds | httpd_bind | 1.0a100 | | 2 | fkey | false | false | false | the IP and port information for the binding |
1645 | httpd_site_binds | certificate | 1.81.10 | | 6 | fkey | true | false | false | the certificate used by this bind |
1649 | httpd_site_binds | disable_log | 1.0a100 | | 7 | fkey | true | false | false | indicates that this bind is disabled |
1635 | httpd_site_urls | httpd_site_bind | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
1599 | httpd_sites | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the site is hosted on |
1619 | httpd_sites | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that the site is disabled |
1622 | httpd_sites | php_version | 1.78 | | 11 | fkey | true | false | false | the active version of PHP, if any |
1633 | httpd_static_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that contains static content |
2474 | httpd_tomcat_contexts | tomcat_site | 1.0a100 | | 1 | fkey | false | false | false | the site this context is part of |
2457 | httpd_tomcat_data_sources | tomcat_context | 1.5 | | 1 | fkey | false | false | false | the context this data source is for |
2468 | httpd_tomcat_parameters | tomcat_context | 1.5 | | 1 | fkey | false | false | false | the context this parameter is for |
2490 | httpd_tomcat_site_jk_mounts | httpd_tomcat_site | 1.81.6 | | 1 | fkey | false | false | false | the Tomcat site that is being mounted |
2530 | httpd_tomcat_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
2531 | httpd_tomcat_sites | version | 1.0a100 | | 1 | fkey | false | false | false | the version of tomcat that is being ran |
2529 | httpd_tomcat_shared_sites | httpd_shared_tomcat | 1.0a100 | | 1 | fkey | false | false | false | the shared JVM |
2494 | httpd_tomcat_std_sites | tomcat_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
2495 | httpd_tomcat_std_sites | tomcat4_shutdown_port | 1.0a100 | | 1 | fkey | true | true | false | the port that will shut down this JVM |
2534 | httpd_tomcat_versions | version | 1.0a100 | | 0 | fkey | false | true | true | a reference to the tomcat details in the <code>technology_versions</code> table |
2539 | httpd_workers | bind | 1.81.18 | | 0 | fkey | false | true | false | the network binding reservation and details |
2544 | httpd_workers | tomcatSite | 1.81.18 | | 2 | fkey | true | false | false | the site that provides this worker (Tomcat 3 only) |
980 | ip_addresses | device | 1.81.18 | | 2 | fkey | true | false | false | the network_device that this IP address is routed through. May only be null for 0.0.0.0 |
987 | ip_addresses | package | 1.81.18 | | 5 | fkey | false | false | false | the package that the IP address is part of |
2336 | IpAddressMonitoring | id | 1.81.18 | | 0 | fkey | false | true | false | id of ip_addresses |
2360 | ip_reputation_limiter_limits | limiter | 1.66 | | 1 | fkey | false | false | false | the identifier of the limiter |
2381 | ip_reputation_limiter_sets | limiter | 1.66 | | 1 | fkey | false | false | false | the identifier of the limiter |
2382 | ip_reputation_limiter_sets | set | 1.66 | | 2 | fkey | false | false | false | the identifier of the set |
2377 | ip_reputation_limiters | net_device | 1.66 | | 1 | fkey | false | false | false | the identifier of the net_device that is protected |
2354 | ip_reputation_set_hosts | set | 1.66 | | 1 | fkey | false | false | false | the IP Reputation Set |
2386 | ip_reputation_set_networks | set | 1.66 | | 1 | fkey | false | false | false | the IP Reputation Set |
437 | linux_acc_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | reference to pkey of email_addresses |
439 | linux_acc_addresses | linux_server_account | 1.31 | | 2 | fkey | false | false | false | reference to linux_server_accounts |
736 | linux_accounts | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that this account is disabled |
664 | linux_group_accounts | operatingSystemVersion | 1.81.18 | | 4 | fkey | true | false | false | the version of operating system where this group and user are associated, or null for all operating system versions |
740 | linux_server_accounts | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server the username is on |
751 | linux_server_accounts | autoresponder_from | 1.0a100 | | 5 | fkey | true | false | false | the pkey of the email address used for the autoresponder |
755 | linux_server_accounts | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates the account is disabled |
645 | linux_server_groups | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the ao_server the group is on |
452 | majordomo_lists | email_list | 1.0a100 | | 0 | fkey | false | true | false | the email list that this majordomo_list represents |
453 | majordomo_lists | majordomo_server | 1.0a100 | | 1 | fkey | false | false | false | the majordomo_server that this list is part of |
455 | majordomo_lists | listname_pipe_add | 1.0a100 | | 3 | fkey | false | true | false | the pipe address the list responds to. Example: test@aoindustries.com |
456 | majordomo_lists | listname_list_add | 1.0a100 | | 4 | fkey | false | true | false | the list address that accesses the raw list contents. Example: test-list@aoindustries.com |
457 | majordomo_lists | owner_listname_add | 1.0a100 | | 5 | fkey | false | true | false | the owner of the list. Example: owner-test@aoindustries.com |
458 | majordomo_lists | listname_owner_add | 1.0a100 | | 6 | fkey | false | true | false | the owner of the list. Example: test-owner@aoindustries.com |
459 | majordomo_lists | listname_approval_add | 1.0a100 | | 7 | fkey | false | true | false | the person who retrieves approval notifications. Example: test-approval@aoindustries.com |
460 | majordomo_lists | listname_request_pipe_add | 1.0a100 | | 8 | fkey | false | true | false | the address that Majordomo requests may be sent to. Example: test-request@aoindustries.com |
461 | majordomo_servers | domain | 1.0a100 | | 0 | fkey | false | true | false | the pkey of the domain that is hosted |
462 | majordomo_servers | linux_server_account | 1.0a100 | | 1 | fkey | false | false | false | the pkey of linux_server_account to run as |
463 | majordomo_servers | linux_server_group | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the linux_server_group to run as |
465 | majordomo_servers | majordomo_pipe_address | 1.0a100 | | 4 | fkey | false | false | false | the email_address to use as the majordomo |
466 | majordomo_servers | owner_majordomo_add | 1.0a100 | | 5 | fkey | false | false | false | the email_address that owns this majordomo list |
467 | majordomo_servers | majordomo_owner_add | 1.0a100 | | 6 | fkey | false | false | false | the email_address that owns this majordomo list |
780 | master_processes | daemon_server | 1.0a100 | | 4 | fkey | true | false | false | |
801 | master_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server they may control |
817 | mysql_databases | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
824 | mysql_db_users | mysql_database | 1.0a100 | | 1 | fkey | false | false | false | the pkey in mysql_databases |
826 | mysql_db_users | mysql_server_user | 1.31 | | 2 | fkey | false | false | false | the pkey in mysql_server_users |
891 | mysql_server_users | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the MySQL server |
894 | mysql_server_users | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this account is disabled |
847 | mysql_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
850 | mysql_servers | ao_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
851 | mysql_servers | version | 1.4 | | 3 | fkey | false | false | false | the pkey of the MySQL version |
886 | mysql_users | disable_log | 1.0a100 | | 29 | fkey | true | false | false | indicates that this account is disabled |
908 | net_bind_firewalld_zones | net_bind | 1.81.0 | | 1 | fkey | false | false | false | the pkey of the port that is associated with the zone |
909 | net_bind_firewalld_zones | firewalld_zone | 1.81.0 | | 2 | fkey | false | false | false | the pkey of the zone this port is associated with |
915 | net_binds | server | 1.33 | | 2 | fkey | false | false | false | the pkey of the server that this port is bound on |
917 | net_binds | ipAddress | 1.81.18 | | 3 | fkey | false | false | false | the id of the IP address that is bound to |
934 | net_devices | server | 1.33 | | 1 | fkey | false | false | false | the pkey of the server that contains the device |
1003 | net_tcp_redirects | net_bind | 1.69 | | 0 | fkey | false | true | false | the pkey as found in net_binds |
234 | notice_log | transid | 1.69 | | 6 | fkey | true | false | false | |
224 | NoticeLog.balance | noticeLog | 1.83.0 | | 1 | fkey | false | false | false | the ID of the NoticeLog this balance is part of |
240 | package_definition_limits | package_definition | 1.0a123 | | 1 | fkey | false | false | false | the pkey of the package definition |
270 | packages | package_definition | 1.0a123 | | 3 | fkey | false | false | false | the definition of the package |
281 | packages | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the package is disabled |
560 | physical_servers | server | 1.36 | | 0 | fkey | false | true | false | a reference to servers |
561 | physical_servers | rack | 1.36 | | 1 | fkey | true | false | false | the rack that houses this server |
1217 | postgres_databases | postgres_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
1218 | postgres_databases | datdba | 1.0a100 | | 3 | fkey | false | false | false | the datdba for the database |
1219 | postgres_databases | encoding | 1.0a100 | | 4 | fkey | false | false | false | the pkey of the encoding system used for the database |
1227 | postgres_encodings | postgres_version | 1.0a100 | | 2 | fkey | false | false | true | the version of PostgreSQL |
1251 | postgres_server_users | postgres_server | 1.69 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
1253 | postgres_server_users | disable_log | 1.0a100 | | 3 | fkey | true | false | false | indicates that this account is disabled |
1229 | postgres_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
1232 | postgres_servers | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
1233 | postgres_servers | version | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the PostgreSQL version |
1246 | postgres_users | disable_log | 1.0a100 | | 5 | fkey | true | false | false | indicates that this account is disabled |
1255 | postgres_versions | version | 1.0a100 | | 0 | fkey | false | true | true | a reference to the PostgreSQL details in the <code>technology_versions</code> table |
1258 | postgres_versions | postgis_version | 1.27 | | 2 | fkey | true | false | true | a reference to the PostGIS defails in the <code>technology_versions</code> table |
548 | private_ftp_servers | net_bind | 1.0a113 | | 0 | fkey | false | true | false | the root directory |
557 | private_ftp_servers | linux_server_account | 1.69 | | 5 | fkey | false | false | false | |
1344 | schema_foreign_keys | column | 1.81.18 | | 1 | fkey | false | false | true | the column that references another column |
1346 | schema_foreign_keys | foreignColumn | 1.81.18 | | 2 | fkey | false | false | true | the referenced column |
482 | sendmail_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
483 | sendmail_binds | sendmail_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
487 | sendmail_servers | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server that runs this sendmail instance |
489 | sendmail_servers | package | 1.81.10 | | 3 | fkey | false | false | false | the package that owns the SSL certificate |
491 | sendmail_servers | server_certificate | 1.81.10 | | 5 | fkey | false | false | false | the certificate used for this server |
492 | sendmail_servers | client_certificate | 1.81.10 | | 6 | fkey | false | false | false | the certificate used for this client |
505 | sendmail_servers | clientAddrInet | 1.81.18 | | 18 | fkey | true | false | false | the Addr for ClientPortOptions with Family=inet |
507 | sendmail_servers | clientAddrInet6 | 1.81.18 | | 19 | fkey | true | false | false | the Addr for ClientPortOptions with Family=inet6 |
582 | server_farms | owner | 1.0a102 | | 2 | fkey | false | false | false | the package that owns of the farm |
968 | servers | operating_system_version | 1.31 | | 3 | fkey | true | false | false | the version of operating system running on the server, if known |
972 | servers | package | 1.31 | | 4 | fkey | false | false | false | the package accountable for resources used by the server |
1384 | signup_request_options | request | 1.23 | | 1 | fkey | false | false | false | the id of the request this option is part of |
1392 | signup_requests | package_definition | 1.23 | | 4 | fkey | false | false | false | the pkey of the Package Definition requested |
1435 | signup_requests | encryption_from | 1.31 | | 33 | fkey | false | false | false | the from that was used for encryption |
1437 | signup_requests | encryption_recipient | 1.31 | | 34 | fkey | false | false | false | the recipient that was used for encryption |
538 | spam_email_messages | email_relay | 1.0a100 | | 1 | fkey | false | false | false | the relay that has been denied |
1188 | ssl_certificate_names | ssl_certificate | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the SSL certificate this name is on |
1193 | ssl_certificate_other_uses | ssl_certificate | 1.81.16 | | 1 | fkey | false | false | false | the pkey of the SSL certificate this name is on |
1198 | ssl_certificates | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server the SSL certificate is on |
1199 | ssl_certificates | package | 1.81.10 | | 2 | fkey | false | false | false | the package that owns the SSL certificate |
542 | system_email_aliases | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the entry is on |
362 | technology_versions | operating_system_version | 1.0a108 | | 5 | fkey | true | false | true | the version of the OS that this packages is installed |
1441 | ticket_actions | ticket | 1.44 | | 1 | fkey | false | false | false | |
1459 | ticket_actions | old_category | 1.44 | | 15 | fkey | true | false | false | |
1460 | ticket_actions | new_category | 1.44 | | 16 | fkey | true | false | false | |
1470 | ticket_assignments | ticket | 1.44 | | 1 | fkey | false | false | false | |
1261 | ticket_brand_categories | category | 1.44 | | 2 | fkey | false | false | false | |
1312 | ticket_categories | parent | 1.44 | | 1 | fkey | true | false | false | |
1486 | tickets | category | 1.44 | | 6 | fkey | true | false | false | |
309 | transactions | credit_card_transaction | 1.29 | | 12 | fkey | true | false | false | the credit card transaction for this transaction |
124 | usernames | disable_log | 1.0a100 | | 2 | fkey | true | false | false | indicates that the username is disabled |
585 | virtual_disks | virtual_server | 1.36 | | 1 | fkey | false | false | false | the virtual server this disk belongs to |
606 | virtual_servers | server | 1.36 | | 0 | fkey | false | true | false | the server that is virtualized |
319 | WhoisHistoryAccount | whoisHistory | 1.81.19 | | 1 | fkey | false | false | false | the id of the WhoisHistory |
705 | ao_servers | monitoring_load_low | 1.35 | | 14 | float | true | false | false | the 5-minute load average that will trigger a low-level alert |
706 | ao_servers | monitoring_load_medium | 1.35 | | 15 | float | true | false | false | the 5-minute load average that will trigger a medium-level alert |
707 | ao_servers | monitoring_load_high | 1.35 | | 16 | float | true | false | false | the 5-minute load average that will trigger a high-level alert |
708 | ao_servers | monitoring_load_critical | 1.35 | | 17 | float | true | false | false | the 5-minute load average that will trigger a critical-level alert |
421 | cyrus_imapd_servers | delete_duration | 1.81.10 | | 5 | float | true | false | false | the duration after which delayed delete folders are removed |
423 | cyrus_imapd_servers | expire_duration | 1.81.10 | | 7 | float | false | false | false | prune the duplicate database of entries older than expire-duration |
425 | cyrus_imapd_servers | expunge_duration | 1.81.10 | | 9 | float | true | false | false | the duration after which delayed expunge messages are removed |
528 | email_smtp_smart_host_domains | domain_out_rate | 1.57 | | 4 | float | true | false | false | the domain-specific email rate, null means unlimited |
531 | email_smtp_smart_hosts | total_out_rate | 1.57 | | 2 | float | true | false | false | the sustained email rate for all emails sent through this host, null means unlimited |
533 | email_smtp_smart_hosts | default_domain_out_rate | 1.57 | | 4 | float | true | false | false | the default per-domain email rate when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited |
763 | linux_server_accounts | sa_required_score | 1.0a124 | | 16 | float | false | false | false | the minimum SpamAssassin score considered Junk |
283 | packages | email_in_rate | 1.24 | | 8 | float | true | false | false | the number of sustained inbound emails per second |
285 | packages | email_out_rate | 1.24 | | 10 | float | true | false | false | the number of sustained outbound emails per second |
287 | packages | email_relay_rate | 1.24 | | 12 | float | true | false | false | the number of sustained relay emails per second |
567 | physical_servers | max_power | 1.36 | | 7 | float | true | false | false | the number of amps this server consumes under peak load |
575 | racks | max_power | 1.36 | | 3 | float | true | false | false | the maximum electrical load supported by the rack |
726 | linux_accounts | name | 1.80.1 | | 1 | gecos | true | false | false | the full name of the user |
728 | linux_accounts | office_location | 1.69 | | 2 | gecos | true | false | false | the location of the user |
730 | linux_accounts | office_phone | 1.69 | | 3 | gecos | true | false | false | the work phone number of the user |
732 | linux_accounts | home_phone | 1.69 | | 4 | gecos | true | false | false | the home phone number of the user |
1779 | distro_files | linux_group | 1.80.0 | | 7 | group_id | false | false | false | the group of the file |
1608 | httpd_sites | linux_group | 1.80.0 | | 6 | group_id | false | false | false | the primary group that can edit the site content |
657 | linux_group_accounts | group | 1.81.18 | | 1 | group_id | false | false | false | the linux group name |
638 | linux_groups | name | 1.80.0 | | 0 | group_id | false | true | false | the name of the group |
644 | linux_server_groups | name | 1.80.0 | | 1 | group_id | false | false | false | the group name |
31 | business_administrators | password | 1.69 | | 1 | hashed_password | true | false | false | the encrypted password for this admin |
636 | ao_server_daemon_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address that is allowed to connect |
703 | ao_servers | daemon_connect_address | 1.69 | | 12 | hostname | true | false | false | provides a specific hostname or address to use for connecting to AOServDaemon |
1273 | brands | smtp_host | 1.46 | | 6 | hostname | true | false | false | |
1276 | brands | imap_host | 1.46 | | 9 | hostname | true | false | false | |
513 | email_smtp_relays | host | 1.69 | | 3 | hostname | false | false | false | the hostname or IP the rule applies to |
179 | failover_file_replications | connect_address | 1.69 | | 6 | hostname | true | false | false | an address or hostname that overrides regular AOServ connections for failovers |
798 | master_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address they are allowed to connect from |
1006 | net_tcp_redirects | destination_host | 1.0a111 | | 3 | hostname | false | false | false | the destination IP address or hostname, please note that hostnames are only resolved once on xinetd startup |
777 | master_processes | connectorId | 1.83.0 | | 1 | Identifier | true | false | false | |
682 | ao_servers | pool_size | 1.0a100 | | 3 | int | false | false | false | the recommended connection pool size for the AOServ Master |
683 | ao_servers | distro_hour | 1.0a100 | | 4 | int | false | false | false | the hour the distribution will occur, in server time zone |
704 | ao_servers | failover_batch_size | 1.12 | | 13 | int | false | false | false | the batch size used for failover replications coming from this server |
333 | architectures | bits | 1.0a108 | | 1 | int | false | false | true | the number of bits used by the architecture |
149 | backup_reports | file_count | 1.0a101 | | 4 | int | false | false | false | the number of files belong to this package on this server |
66 | bank_accounts | depositDelay | 1.81.18 | | 3 | int | false | false | false | the number of business days it takes for a deposit to be sent to the bank account |
68 | bank_accounts | withdrawalDelay | 1.81.18 | | 4 | int | false | false | false | the number of business days it takes for a withdrawal to be taken from the bank account |
98 | business_profiles | priority | 1.0a100 | | 2 | int | false | false | false | the highest priority profile is used |
1183 | credit_card_processors | weight | 1.29 | | 8 | int | false | false | false | the weight used for multi-processor weighted transaction distribution |
1069 | credit_card_transactions | duplicate_window | 1.29 | | 5 | int | false | false | false | the number of seconds for duplicate transaction detection |
372 | dns_records | priority | 1.72 | | 4 | int | true | false | false | the priority for the entry |
373 | dns_records | weight | 1.72 | | 5 | int | true | false | false | the relative weight for records with the same priority |
374 | dns_records | port | 1.72 | | 6 | int | true | false | false | the TCP or UDP port on which the service is to be found |
381 | dns_records | ttl | 1.0a127 | | 11 | int | true | false | false | the time to live field |
400 | dns_zones | ttl | 1.0a127 | | 5 | int | false | false | false | |
517 | email_smtp_relays | refresh_count | 1.0a100 | | 7 | int | false | false | false | the number of times the entry has been updated |
527 | email_smtp_smart_host_domains | domain_out_burst | 1.57 | | 3 | int | true | false | false | the domain-specific email burst limit, null means unlimited |
530 | email_smtp_smart_hosts | total_out_burst | 1.57 | | 1 | int | true | false | false | the aggregate email burst limit for all emails sent through this host, null means unlimited |
532 | email_smtp_smart_hosts | default_domain_out_burst | 1.57 | | 3 | int | true | false | false | the default per-domain email burst limit when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited |
536 | email_sa_integration_modes | sort_order | 1.0a120 | | 2 | int | false | false | true | |
159 | failover_file_log | scanned | 1.0a100 | | 4 | int | false | false | false | the number of files scanned |
160 | failover_file_log | updated | 1.0a100 | | 5 | int | false | false | false | the number of files updated |
203 | failover_mysql_replications | monitoring_seconds_behind_low | 1.56 | | 4 | int | true | false | false | the seconds behind where will trigger low alert level |
204 | failover_mysql_replications | monitoring_seconds_behind_medium | 1.56 | | 5 | int | true | false | false | the seconds behind where will trigger medium alert level |
205 | failover_mysql_replications | monitoring_seconds_behind_high | 1.56 | | 6 | int | true | false | false | the seconds behind where will trigger high alert level |
206 | failover_mysql_replications | monitoring_seconds_behind_critical | 1.56 | | 7 | int | true | false | false | the seconds behind where will trigger critical alert level |
1538 | httpd_servers | timeout | 1.0a130 | | 11 | int | false | false | false | the timeout setting in seconds |
1539 | httpd_servers | max_concurrency | 1.68 | | 12 | int | false | false | false | the maximum number of processes/threads for this server instance |
1540 | httpd_servers | monitoring_concurrency_low | 1.81.11 | | 13 | int | true | false | false | the concurrency that will trigger a low-level alert |
1541 | httpd_servers | monitoring_concurrency_medium | 1.81.11 | | 14 | int | true | false | false | the concurrency that will trigger a medium-level alert |
1542 | httpd_servers | monitoring_concurrency_high | 1.81.11 | | 15 | int | true | false | false | the concurrency that will trigger a high-level alert |
1543 | httpd_servers | monitoring_concurrency_critical | 1.81.11 | | 16 | int | true | false | false | the concurrency that will trigger a critical-level alert |
2522 | httpd_shared_tomcats | maxParameterCount | 1.92.0 | | 11 | int | true | false | false | the maxParameterCount setting for this Tomcat |
2523 | httpd_shared_tomcats | max_post_size | 1.80.1 | | 12 | int | true | false | false | the maxPostSize setting for this Tomcat |
2486 | httpd_tomcat_contexts | debug | 1.0a100 | | 12 | int | false | false | false | the debug attribute |
2463 | httpd_tomcat_data_sources | max_active | 1.5 | | 7 | int | false | false | false | the maximum number of active instances that can be allocated from this pool at the same time |
2464 | httpd_tomcat_data_sources | max_idle | 1.5 | | 8 | int | false | false | false | the maximum number of connections that can sit idle in this pool at the same time |
2465 | httpd_tomcat_data_sources | max_wait | 1.5 | | 9 | int | false | false | false | the 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 |
2497 | httpd_tomcat_std_sites | maxParameterCount | 1.92.0 | | 3 | int | true | false | false | the maxParameterCount setting for this Tomcat |
2498 | httpd_tomcat_std_sites | max_post_size | 1.80.1 | | 4 | int | true | false | false | the maxPostSize setting for this Tomcat |
2389 | ip_reputation_set_networks | counter | 1.65 | | 3 | int | false | false | false | the reputation counter |
2394 | ip_reputation_sets | max_hosts | 1.65 | | 4 | int | false | false | false | the maximum number of individual hosts tracked |
2399 | ip_reputation_sets | host_decay_interval | 1.65 | | 9 | int | false | false | false | the number of seconds between each host decay |
2401 | ip_reputation_sets | network_decay_interval | 1.65 | | 11 | int | false | false | false | the number of seconds between each network decay |
760 | linux_server_accounts | trash_email_retention | 1.0a100 | | 13 | int | true | false | false | the number of days before messages in the Trash folder are automatically removed. |
761 | linux_server_accounts | junk_email_retention | 1.0a120 | | 14 | int | true | false | false | the number of days before messages in the Junk folder are automatically removed. |
764 | linux_server_accounts | sa_discard_score | 1.40 | | 17 | int | true | false | false | the minimum SpamAssassin score that will be discarded instead of tagged or placed in the Junk folder |
788 | master_processes | priority | 1.0a100 | | 12 | int | false | false | false | |
896 | mysql_server_users | max_questions | 1.4 | | 6 | int | false | false | false | the maximum number of questions to this database server, 0 means unlimited |
897 | mysql_server_users | max_updates | 1.4 | | 7 | int | false | false | false | the maximum number of updates to this database server, 0 means unlimited |
898 | mysql_server_users | max_connections | 1.0a111 | | 8 | int | false | false | false | the maximum number of connections to this database server, 0 means unlimited |
899 | mysql_server_users | max_user_connections | 1.4 | | 9 | int | false | false | false | the maximum number of user connections to this database server, 0 means unlimited |
852 | mysql_servers | max_connections | 1.4 | | 4 | int | false | false | false | the maximum number of connections for the db |
1004 | net_tcp_redirects | cps | 1.0a111 | | 1 | int | false | false | false | the maximum number of connections per second before the redirect is temporarily disabled |
1005 | net_tcp_redirects | cps_overload_sleep_time | 1.0a111 | | 2 | int | false | false | false | the number of seconds the service will be disabled |
242 | package_definition_limits | soft_limit | 1.0a123 | | 3 | int | true | false | false | the number that may be used for additional charges are added, NULL means unlimited |
243 | package_definition_limits | hard_limit | 1.0a123 | | 4 | int | true | false | false | the maximum number that may be allocated, NULL means unlimited |
282 | packages | email_in_burst | 1.24 | | 7 | int | true | false | false | the maximum burst of inbound email before limiting begins |
284 | packages | email_out_burst | 1.24 | | 9 | int | true | false | false | the maximum burst of outbound email before limiting begins |
286 | packages | email_relay_burst | 1.24 | | 11 | int | true | false | false | the maximum burst of relay email before limiting begins |
563 | physical_servers | ram | 1.36 | | 3 | int | true | false | false | the total number of megabytes of RAM in this server |
565 | physical_servers | processor_speed | 1.36 | | 5 | int | true | false | false | the processor speed in MHz |
566 | physical_servers | processor_cores | 1.36 | | 6 | int | true | false | false | the total number of processor cores, hyperthreads are counted as different cores |
1234 | postgres_servers | max_connections | 1.0a100 | | 4 | int | false | false | false | the maximum number of connections for the db |
1236 | postgres_servers | sort_mem | 1.0a100 | | 5 | int | false | false | false | the amount of shared memory used for sorting |
1237 | postgres_servers | shared_buffers | 1.0a100 | | 6 | int | false | false | false | the number of shared buffers |
576 | racks | total_rack_units | 1.36 | | 4 | int | true | false | false | the number of rack units of physical space |
494 | sendmail_servers | max_queue_children | 1.81.10 | | 8 | int | true | false | false | the value for confMAX_QUEUE_CHILDREN |
495 | sendmail_servers | nice_queue_run | 1.81.10 | | 9 | int | true | false | false | the value for confNICE_QUEUE_RUN |
496 | sendmail_servers | delay_la | 1.81.10 | | 10 | int | true | false | false | the value for confDELAY_LA |
497 | sendmail_servers | queue_la | 1.81.10 | | 11 | int | true | false | false | the value for confQUEUE_LA |
498 | sendmail_servers | refuse_la | 1.81.10 | | 12 | int | true | false | false | the value for confREFUSE_LA |
499 | sendmail_servers | max_daemon_children | 1.81.10 | | 13 | int | true | false | false | the value for confMAX_DAEMON_CHILDREN |
500 | sendmail_servers | bad_rcpt_throttle | 1.81.10 | | 14 | int | true | false | false | the value for confBAD_RCPT_THROTTLE |
501 | sendmail_servers | connection_rate_throttle | 1.81.10 | | 15 | int | true | false | false | the value for confCONNECTION_RATE_THROTTLE |
502 | sendmail_servers | max_message_size | 1.81.10 | | 16 | int | true | false | false | the value for confMAX_MESSAGE_SIZE |
503 | sendmail_servers | min_free_blocks | 1.81.10 | | 17 | int | true | false | false | the value for confMIN_FREE_BLOCKS |
1195 | ssl_certificate_other_uses | count | 1.81.16 | | 3 | int | false | false | false | the number of times this other resource uses the certificate |
353 | technology_names | image_width | 1.0a100 | | 2 | int | true | false | true | the width of the image |
354 | technology_names | image_height | 1.0a100 | | 3 | int | true | false | true | the height of the image |
593 | virtual_disks | minimum_disk_speed | 1.41 | | 3 | int | true | false | false | the minimum disk speed in RPM for the primary physical server |
594 | virtual_disks | minimum_disk_speed_target | 1.43 | | 4 | int | true | false | false | the minimum disk speed in RPM for the primary physical server |
597 | virtual_disks | extents | 1.36 | | 5 | int | false | false | false | the total number of LVM extents for this device |
604 | virtual_disks | verify_day_of_week | 1.72 | | 8 | int | false | false | false | the day of the week verification will begin |
605 | virtual_disks | verify_hour_of_day | 1.72 | | 9 | int | false | false | false | the hour of day verification will begin |
607 | virtual_servers | primary_ram | 1.36 | | 1 | int | false | false | false | the amount of RAM required in primary mode in megabytes |
608 | virtual_servers | primary_ram_target | 1.43 | | 2 | int | false | false | false | the amount of RAM required in primary mode in megabytes |
609 | virtual_servers | secondary_ram | 1.36 | | 3 | int | true | false | false | the amount of RAM required in primary mode in megabytes or 0 if secondary not required |
610 | virtual_servers | secondary_ram_target | 1.43 | | 4 | int | true | false | false | the amount of RAM required in primary mode in megabytes or 0 if secondary not required |
615 | virtual_servers | minimum_processor_speed | 1.41 | | 7 | int | true | false | false | the minimum processor speed in MHz |
616 | virtual_servers | minimum_processor_speed_target | 1.43 | | 8 | int | true | false | false | the minimum processor speed in MHz |
329 | WhoisHistory | exitStatus | 1.81.19 | | 3 | int | true | false | false | the exit status from the whois lookup, null on exception |
787 | master_processes | total_time | 1.0a100 | | 11 | interval | false | false | false | |
181 | failover_file_replications | connect_from | 1.69 | | 7 | ip_address | true | false | false | an address that overrides regular AOServ connection source addresses for failovers |
978 | ip_addresses | inetAddress | 1.81.18 | | 1 | ip_address | false | false | false | the IP address |
998 | ip_addresses | externalInetAddress | 1.81.18 | | 10 | ip_address | true | false | false | the external IP address, if different than ip_address |
2356 | ip_reputation_set_hosts | host | 1.67 | | 2 | ip_address | false | false | false | the per-set unique IPv4 address |
2388 | ip_reputation_set_networks | network | 1.67 | | 2 | ip_address | false | false | false | the per-set unique IPv4 network address, with network bits zero |
781 | master_processes | host | 1.0a100 | | 5 | ip_address | false | false | false | |
940 | net_devices | gateway | 1.0a100 | | 5 | ip_address | true | false | false | the gateway IP address |
942 | net_devices | network | 1.0a112 | | 6 | ip_address | true | false | false | the local network |
943 | net_devices | broadcast | 1.0a112 | | 7 | ip_address | true | false | false | the broadcast IP |
1391 | signup_requests | ip_address | 1.23 | | 3 | ip_address | false | false | false | the IP address of the user who signed-up |
710 | ao_servers | uidMin | 1.81.18 | | 18 | linux_id | false | false | false | the min value for automatic uid selection in useradd |
712 | ao_servers | gidMin | 1.81.18 | | 19 | linux_id | false | false | false | the min value for automatic gid selection in groupadd |
713 | ao_servers | uidMax | 1.81.18 | | 20 | linux_id | false | false | false | the max value for automatic uid selection in useradd |
714 | ao_servers | gidMax | 1.81.18 | | 21 | linux_id | false | false | false | the max value for automatic gid selection in groupadd |
715 | ao_servers | lastUid | 1.81.18 | | 22 | linux_id | true | false | false | the last value for automatic uid selection in useradd, if any |
716 | ao_servers | lastGid | 1.81.18 | | 23 | linux_id | true | false | false | the last value for automatic gid selection in groupadd, if any |
187 | failover_file_replications | quota_gid | 1.80.0 | | 9 | linux_id | true | false | false | the gid used on the backup_partition for quota reports, required if backup_partitions quotas are enabled, not allowed otherwise |
743 | linux_server_accounts | uid | 1.80.0 | | 3 | linux_id | false | false | false | the uid of the user on the machine |
648 | linux_server_groups | gid | 1.80.0 | | 3 | linux_id | false | false | false | the gid on that machine |
1777 | distro_files | linux_account | 1.81.22 | | 6 | linux_username | false | false | false | the owner of the file |
546 | ftp_guest_users | username | 1.81.22 | | 0 | linux_username | false | true | false | the username that is a guest user |
1606 | httpd_sites | linux_account | 1.81.22 | | 5 | linux_username | false | false | false | the user the site "runs as" |
723 | linux_accounts | username | 1.81.22 | | 0 | linux_username | false | true | false | the unique username |
660 | linux_group_accounts | user | 1.81.22 | | 2 | linux_username | false | false | false | the linux account that is an alternate member |
739 | linux_server_accounts | username | 1.81.22 | | 1 | linux_username | false | false | false | the name of the user |
152 | backup_reports | disk_size | 1.0a101 | | 5 | long | false | false | false | the total number of bytes of disk space used |
1780 | distro_files | size | 1.0a100 | | 8 | long | true | false | false | the length of the file |
1784 | distro_files | file_sha256_0 | 1.80 | | 9 | long | true | false | false | the first 64 bits of SHA-256 hash if is a regular file |
1785 | distro_files | file_sha256_1 | 1.80 | | 10 | long | true | false | false | the second 64 bits of SHA-256 hash if is a regular file |
1786 | distro_files | file_sha256_2 | 1.80 | | 11 | long | true | false | false | the third 64 bits of SHA-256 hash if is a regular file |
1787 | distro_files | file_sha256_3 | 1.80 | | 12 | long | true | false | false | the fourth 64 bits of SHA-256 hash if is a regular file |
399 | dns_zones | serial | 1.0a100 | | 4 | long | false | false | false | the ever-incrementing serial number for the file |
161 | failover_file_log | bytes | 1.0a100 | | 6 | long | false | false | false | the number of bytes transferred |
174 | failover_file_replications | max_bit_rate | 1.61 | | 3 | long | true | false | false | the maximum bit rate for files being replicated |
2352 | ip_reputation_set_hosts | pkey | 1.65 | | 0 | long | false | true | false | a generated, unique key |
2384 | ip_reputation_set_networks | pkey | 1.65 | | 0 | long | false | true | false | a generated, unique key |
786 | master_processes | use_count | 1.0a100 | | 10 | long | false | false | false | |
946 | net_devices | max_bit_rate | 1.2 | | 9 | long | true | false | false | the maximum bits per second for this network device |
947 | net_devices | monitoring_bit_rate_low | 1.35 | | 10 | long | true | false | false | the 5-minute average that will trigger a low-level alert |
948 | net_devices | monitoring_bit_rate_medium | 1.35 | | 11 | long | true | false | false | the 5-minute average that will trigger a medium-level alert |
949 | net_devices | monitoring_bit_rate_high | 1.35 | | 12 | long | true | false | false | the 5-minute average that will trigger a high-level alert |
950 | net_devices | monitoring_bit_rate_critical | 1.35 | | 13 | long | true | false | false | the 5-minute average that will trigger a critical-level alert |
945 | net_devices | mac_address | 1.80.0 | | 8 | mac_address | true | true | false | the MAC address to be used on the device |
1074 | credit_card_transactions | amount | 1.83.0 | | 7 | money | false | false | false | the amount of the transaction |
1077 | credit_card_transactions | taxAmount | 1.83.0 | | 8 | money | true | false | false | the tax amount of the transaction |
1081 | credit_card_transactions | shippingAmount | 1.83.0 | | 10 | money | true | false | false | the shipping amount for this transaction |
1084 | credit_card_transactions | dutyAmount | 1.83.0 | | 11 | money | true | false | false | the duty amount for this transaction |
210 | Currency | autoEnableMinimumPayment | 1.83.0 | | 2 | money | false | false | true | the minimum payment for auto-enabling accounts |
219 | monthly_charges | rate | 1.83.0 | | 6 | money | false | false | false | the rate |
225 | NoticeLog.balance | balance | 1.83.0 | | 2 | money | false | false | false | the balance for a single currency |
245 | package_definition_limits | additionalRate | 1.83.0 | | 5 | money | true | false | false | the monthly rate for those past the soft_limit |
257 | package_definitions | setupFee | 1.83.0 | | 7 | money | true | false | false | the setup fee for this package definition |
260 | package_definitions | monthlyRate | 1.83.0 | | 9 | money | true | false | false | the default monthly charge for this package |
304 | transactions | rate | 1.83.0 | | 8 | money | false | false | false | the amount per unit of quantity |
815 | mysql_databases | name | 1.80.0 | | 1 | mysql_database_name | false | false | false | the name of the database |
849 | mysql_servers | name | 1.80.0 | | 1 | mysql_server_name | false | false | false | the name of the server |
889 | mysql_server_users | username | 1.80.0 | | 1 | mysql_username | false | false | false | the username |
857 | mysql_users | username | 1.80.0 | | 0 | mysql_username | false | true | false | the username of the MySQL user |
920 | net_binds | port | 1.80.0 | | 4 | net_port | false | false | false | the port that is bound |
1009 | net_tcp_redirects | destination_port | 1.80.0 | | 4 | net_port | false | false | false | the remote port to connect to |
903 | protocols | port | 1.80.0 | | 1 | net_port | false | false | true | the default port of the protocol |
717 | ao_servers | sftp_umask | 1.81.5 | | 24 | octal_long | true | false | false | the optional umask for the sftp-server |
1378 | cvs_repositories | mode | 1.0a100 | | 4 | octal_long | false | false | false | the directory permissions |
1775 | distro_files | mode | 1.0a100 | | 5 | octal_long | false | false | false | the mode (including file type bits) |
140 | backup_partitions | path | 1.0a100 | | 2 | path | false | false | false | the full path to the root of the backup data |
1375 | cvs_repositories | path | 1.0a100 | | 1 | path | false | false | false | the full path to the repository |
1772 | distro_files | path | 1.0a108 | | 2 | path | false | false | false | the full path to the file |
444 | email_lists | path | 1.0a100 | | 1 | path | false | false | false | the complete path to the email list |
1579 | httpd_site_authenticated_locations | auth_group_file | 1.18 | | 5 | path | false | false | false | the full path to the file containing the group list |
1580 | httpd_site_authenticated_locations | auth_user_file | 1.18 | | 6 | path | false | false | false | the full path to the file containing the user list |
1643 | httpd_site_binds | access_log | 1.0a100 | | 4 | path | false | false | false | the file used for access logging |
1644 | httpd_site_binds | error_log | 1.0a100 | | 5 | path | false | false | false | the file used for error logging |
2479 | httpd_tomcat_contexts | doc_base | 1.80.0 | | 5 | path | false | false | false | the docBase attribute |
2487 | httpd_tomcat_contexts | work_dir | 1.0a100 | | 13 | path | true | false | false | the workDir attribute |
2535 | httpd_tomcat_versions | install_dir | 1.0a100 | | 1 | path | false | false | true | the directory the basic install files are located in |
734 | linux_accounts | shell | 1.0a100 | | 6 | path | false | false | false | the users shell preference |
744 | linux_server_accounts | home | 1.0a100 | | 4 | path | false | false | false | the home directory of the user on this machine |
550 | private_ftp_servers | logfile | 1.0a100 | | 1 | path | false | false | false | the file transfers are logged to |
718 | shells | path | 1.0a100 | | 0 | path | false | true | true | the complete path to the executable |
1200 | ssl_certificates | key_file | 1.81.10 | | 3 | path | false | false | false | the file holding the private key |
1201 | ssl_certificates | csr_file | 1.81.10 | | 4 | path | true | false | false | the file holding the CSR |
1202 | ssl_certificates | cert_file | 1.81.10 | | 5 | path | false | false | false | the file holding the public key |
1203 | ssl_certificates | chain_file | 1.81.10 | | 6 | path | true | false | false | the file holding the CA chain |
1287 | brands | support_toll_free | 1.69 | | 19 | phone | true | false | false | |
1289 | brands | support_day_phone | 1.69 | | 20 | phone | true | false | false | |
1291 | brands | support_emergency_phone1 | 1.69 | | 21 | phone | true | false | false | |
1293 | brands | support_emergency_phone2 | 1.69 | | 22 | phone | true | false | false | |
1295 | brands | support_fax | 1.69 | | 23 | phone | true | false | false | |
39 | business_administrators | work_phone | 1.0a100 | | 8 | phone | false | false | false | the work phone number (if different than business) |
40 | business_administrators | home_phone | 1.0a100 | | 9 | phone | true | false | false | the home phone number |
41 | business_administrators | cell_phone | 1.0a100 | | 10 | phone | true | false | false | the cellular phone number |
42 | business_administrators | fax | 1.0a100 | | 11 | phone | true | false | false | the fax number (if different than business) |
101 | business_profiles | phone | 1.0a100 | | 5 | phone | false | false | false | the phone number |
102 | business_profiles | fax | 1.0a100 | | 6 | phone | true | false | false | the fax number |
1115 | credit_card_transactions | credit_card_phone | 1.29 | | 38 | phone | true | false | false | the phone number of the card holder |
1116 | credit_card_transactions | credit_card_fax | 1.29 | | 39 | phone | true | false | false | the fax number of the card holder |
1031 | credit_cards | phone | 1.29 | | 12 | phone | true | false | false | the daytime phone number |
1032 | credit_cards | fax | 1.29 | | 13 | phone | true | false | false | the fax number |
1395 | signup_requests | business_phone | 1.69 | | 6 | phone | false | false | false | the phone number of the business |
1397 | signup_requests | business_fax | 1.69 | | 7 | phone | true | false | false | the fax number of the business |
633 | ao_server_daemon_hosts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
137 | backup_partitions | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
145 | backup_reports | pkey | 1.0a101 | | 0 | pkey | false | true | false | a generated primary key |
71 | bank_transactions | id | 1.81.18 | | 0 | pkey | false | true | false | a unique identifier for the transaction |
769 | business_administrator_permissions | pkey | 1.21 | | 0 | pkey | false | true | false | a generated primary key |
96 | business_profiles | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique primary key |
1 | business_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1064 | credit_card_transactions | pkey | 1.29 | | 0 | pkey | false | true | false | the unique ID of this transaction |
1015 | credit_cards | pkey | 1.0a100 | | 0 | pkey | false | true | false | primary key value |
1374 | cvs_repositories | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
57 | disable_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1769 | distro_files | pkey | 1.0a108 | | 0 | pkey | false | true | false | the unique pkey |
366 | dns_records | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated pkey |
401 | email_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | the primary key |
404 | email_attachment_blocks | pkey | 1.0a116 | | 0 | pkey | false | true | false | a unique, generated primary key |
427 | email_domains | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
433 | email_forwarding | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique key |
440 | email_list_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
443 | email_lists | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique primary key |
472 | email_pipe_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique key |
475 | email_pipes | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
508 | email_smtp_relays | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
523 | email_smtp_smart_host_domains | pkey | 1.57 | | 0 | pkey | false | true | false | a generated unique key |
1205 | encryption_keys | pkey | 1.23 | | 0 | pkey | false | true | false | a generated unique id |
155 | failover_file_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
168 | failover_file_replications | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
163 | failover_file_schedule | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
198 | failover_mysql_replications | pkey | 1.28 | | 0 | pkey | false | true | false | a generated, unique id |
188 | file_backup_settings | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
952 | firewalld_zones | pkey | 1.81.0 | | 0 | pkey | false | true | false | a generated unique primary key |
2446 | httpd_jboss_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
2453 | httpd_jboss_versions | version | 1.0a100 | | 0 | pkey | false | true | true | jboss version designator |
1523 | httpd_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique number |
2503 | httpd_shared_tomcats | pkey | 1.0a100 | | 0 | pkey | false | true | false | pkey for this jvm |
1574 | httpd_site_authenticated_locations | pkey | 1.18 | | 0 | pkey | false | true | false | a generated primary key |
1510 | httpd_site_bind_headers | pkey | 1.81.15 | | 0 | pkey | false | true | false | a generated primary key |
1590 | RewriteRule | id | 1.81.21 | | 0 | pkey | false | true | false | a generated primary key |
1639 | httpd_site_binds | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1634 | httpd_site_urls | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1598 | httpd_sites | id | 1.81.18 | | 0 | pkey | false | true | false | a generated primary key |
2473 | httpd_tomcat_contexts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
2456 | httpd_tomcat_data_sources | pkey | 1.5 | | 0 | pkey | false | true | false | a generated unique key |
2467 | httpd_tomcat_parameters | pkey | 1.5 | | 0 | pkey | false | true | false | a generated unique key |
2489 | httpd_tomcat_site_jk_mounts | pkey | 1.81.6 | | 0 | pkey | false | true | false | a generated primary key |
2528 | httpd_tomcat_shared_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
976 | ip_addresses | id | 1.81.18 | | 0 | pkey | false | true | false | a generated, unique key |
2359 | ip_reputation_limiter_limits | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2380 | ip_reputation_limiter_sets | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2376 | ip_reputation_limiters | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2390 | ip_reputation_sets | pkey | 1.65 | | 0 | pkey | false | true | false | a generated, unique key |
436 | linux_acc_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
654 | linux_group_accounts | id | 1.81.18 | | 0 | pkey | false | true | false | a generated unique number |
737 | linux_server_accounts | pkey | 1.0a100 | | 0 | pkey | false | true | false | the generated primary key |
642 | linux_server_groups | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique key |
795 | master_hosts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
799 | master_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
211 | monthly_charges | pkey | 1.0a100 | | 0 | pkey | true | true | false | a unique, generated number for reference |
813 | mysql_databases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
823 | mysql_db_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
887 | mysql_server_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
907 | net_bind_firewalld_zones | pkey | 1.81.0 | | 0 | pkey | false | true | false | a generated pkey |
911 | net_binds | id | 1.81.18 | | 0 | pkey | false | true | false | a generated pkey |
932 | net_devices | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated pkey |
226 | notice_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
223 | NoticeLog.balance | id | 1.83.0 | | 0 | pkey | false | true | false | a generated primary key |
337 | operating_system_versions | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated, unique ID |
239 | package_definition_limits | pkey | 1.0a123 | | 0 | pkey | false | true | false | the unique identifier for this limit |
247 | package_definitions | pkey | 1.0a123 | | 0 | pkey | false | true | false | the unique ID of the package definition |
264 | packages | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
1214 | postgres_databases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
1225 | postgres_encodings | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated unique key |
1247 | postgres_server_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated number |
572 | racks | pkey | 1.36 | | 0 | pkey | false | true | false | the unique ID for the rack |
1322 | schema_columns | id | 1.81.18 | | 0 | pkey | false | true | true | a generated unique pkey |
1342 | schema_foreign_keys | id | 1.81.18 | | 0 | pkey | false | true | true | a generated unique pkey |
1353 | schema_tables | id | 1.81.18 | | 0 | pkey | false | true | true | a unique ID for the table |
1366 | schema_types | id | 1.81.18 | | 0 | pkey | false | true | true | the unique number |
486 | sendmail_servers | id | 1.81.18 | | 0 | pkey | false | true | false | a generated unique number |
958 | servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique ID |
1383 | signup_request_options | pkey | 1.23 | | 0 | pkey | false | true | false | a generate unique id |
1387 | signup_requests | pkey | 1.23 | | 0 | pkey | false | true | false | a generate unique id |
537 | spam_email_messages | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
1187 | ssl_certificate_names | pkey | 1.81.10 | | 0 | pkey | false | true | false | a generated primary key |
1192 | ssl_certificate_other_uses | pkey | 1.81.16 | | 0 | pkey | false | true | false | a generated primary key |
1197 | ssl_certificates | pkey | 1.81.10 | | 0 | pkey | false | true | false | a generated primary key |
541 | system_email_aliases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
346 | technologies | pkey | 1.4 | | 0 | pkey | false | true | true | the unique identifier |
357 | technology_versions | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated unique key |
1440 | ticket_actions | pkey | 1.44 | | 0 | pkey | false | true | false | |
1469 | ticket_assignments | pkey | 1.44 | | 0 | pkey | false | true | false | |
1259 | ticket_brand_categories | pkey | 1.44 | | 0 | pkey | false | true | false | |
1311 | ticket_categories | pkey | 1.44 | | 0 | pkey | false | true | false | |
1478 | tickets | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
296 | transactions | transid | 1.69 | | 1 | pkey | false | true | false | the unique identifier for this transaction |
584 | virtual_disks | pkey | 1.36 | | 0 | pkey | false | true | false | a generated unique ID |
326 | WhoisHistory | id | 1.81.19 | | 0 | pkey | false | true | false | a unique, generated identifier |
318 | WhoisHistoryAccount | id | 1.81.19 | | 0 | pkey | false | true | false | a unique, generated identifier |
1216 | postgres_databases | name | 1.80.0 | | 1 | postgres_database_name | false | false | false | the name of the database |
1231 | postgres_servers | name | 1.80.0 | | 1 | postgres_server_name | false | false | false | the name of the database |
1249 | postgres_server_users | username | 1.80.0 | | 1 | postgres_username | false | false | false | the username as found in postgres_users |
1241 | postgres_users | username | 1.80.0 | | 0 | postgres_username | false | true | false | the username of the user |
773 | aoserv_permissions | sort_order | 1.21 | | 1 | short | false | true | true | the sort order for the permission |
153 | backup_retentions | days | 1.0a100 | | 0 | short | false | true | true | the number of days to keep the backup data |
1109 | credit_card_transactions | creditCard.expirationMonth | 1.82.0 | | 32 | short | true | false | false | the card expiration month |
1110 | credit_card_transactions | creditCard.expirationYear | 1.82.0 | | 33 | short | true | false | false | the card expiration year |
1141 | credit_card_transactions | authorizationResult.replacementExpirationMonth | 1.82.0 | | 60 | short | true | false | false | the replacement card expiration month |
1142 | credit_card_transactions | authorizationResult.replacementExpirationYear | 1.82.0 | | 61 | short | true | false | false | the replacement card expiration year |
1021 | credit_cards | expirationMonth | 1.82.0 | | 5 | short | true | false | false | the card expiration month |
1022 | credit_cards | expirationYear | 1.82.0 | | 6 | short | true | false | false | the card expiration year |
209 | Currency | fractionDigits | 1.83.0 | | 1 | short | false | false | true | the number of fraction digits used with this currency |
375 | dns_records | flag | 1.86.0 | | 7 | short | true | false | false | the CAA flag |
177 | failover_file_replications | retention | 1.13 | | 5 | short | false | false | false | the number of days backups will be kept |
165 | failover_file_schedule | hour | 1.0a100 | | 2 | short | false | false | false | the hour of day (in server timezone) |
166 | failover_file_schedule | minute | 1.31 | | 3 | short | false | false | false | the minute (in server timezone) |
1512 | httpd_site_bind_headers | sort_order | 1.81.15 | | 2 | short | false | false | false | the per-bind unique sort ordering |
1592 | RewriteRule | sortOrder | 1.81.21 | | 2 | short | false | false | false | the per-VirtualHost unique sort ordering |
2362 | ip_reputation_limiter_limits | syn_per_ip_burst | 1.66 | | 3 | short | false | false | false | |
2363 | ip_reputation_limiter_limits | syn_per_ip_rate | 1.66 | | 4 | short | false | false | false | |
2365 | ip_reputation_limiter_limits | syn_per_ip_size | 1.66 | | 6 | short | false | false | false | |
2366 | ip_reputation_limiter_limits | syn_burst | 1.66 | | 7 | short | false | false | false | |
2367 | ip_reputation_limiter_limits | syn_rate | 1.66 | | 8 | short | false | false | false | |
2369 | ip_reputation_limiter_limits | packet_per_ip_burst | 1.66 | | 10 | short | false | false | false | |
2370 | ip_reputation_limiter_limits | packet_per_ip_rate | 1.66 | | 11 | short | false | false | false | |
2372 | ip_reputation_limiter_limits | packet_per_ip_size | 1.66 | | 13 | short | false | false | false | |
2373 | ip_reputation_limiter_limits | packet_burst | 1.66 | | 14 | short | false | false | false | |
2374 | ip_reputation_limiter_limits | packet_rate | 1.66 | | 15 | short | false | false | false | |
2383 | ip_reputation_limiter_sets | sort_order | 1.66 | | 3 | short | false | false | false | the per-limiter ordering |
2357 | ip_reputation_set_hosts | good_reputation | 1.65 | | 3 | short | false | false | false | the current good reputation |
2358 | ip_reputation_set_hosts | bad_reputation | 1.65 | | 4 | short | false | false | false | the current bad repuation |
2395 | ip_reputation_sets | max_uncertain_reputation | 1.65 | | 5 | short | false | false | false | the maximum reputation from uncertain sources |
2396 | ip_reputation_sets | max_definite_reputation | 1.65 | | 6 | short | false | false | false | the maximum reputation from definite sources |
2397 | ip_reputation_sets | network_prefix | 1.65 | | 7 | short | false | false | false | the network size, for example 24 for a /24 (class C) |
2398 | ip_reputation_sets | max_network_reputation | 1.65 | | 8 | short | false | false | false | the maximum reputation for a network |
345 | operating_system_versions | sort_order | 1.3 | | 7 | short | false | true | true | the default sort order |
562 | physical_servers | rack_units | 1.36 | | 2 | short | true | false | false | the number of rack units |
571 | processor_types | sort_order | 1.36 | | 1 | short | false | true | true | the sort order of the processor, those sorted higher may be substituted for those sorted lower |
1330 | schema_columns | index | 1.81.18 | | 5 | short | false | false | true | the index of the column |
1194 | ssl_certificate_other_uses | sort_order | 1.81.16 | | 2 | short | false | false | false | the per-certificate unique sort ordering |
1477 | ticket_stati | sort_order | 1.44 | | 1 | short | false | true | true | |
598 | virtual_disks | weight | 1.41 | | 6 | short | false | false | false | the amount of primary disk I/O allocated to this virtual device on a scale of 1-1024 |
599 | virtual_disks | weight_target | 1.43 | | 7 | short | false | false | false | the amount of primary disk I/O allocated to this virtual device on a scale of 1-1024 |
619 | virtual_servers | processor_cores | 1.41 | | 9 | short | false | false | false | the number of processor cores |
620 | virtual_servers | processor_cores_target | 1.43 | | 10 | short | false | false | false | the number of processor cores |
623 | virtual_servers | processor_weight | 1.41 | | 11 | short | false | false | false | the processor allocation weight on a scale of 1-1024 |
624 | virtual_servers | processor_weight_target | 1.43 | | 12 | short | false | false | false | the processor allocation weight on a scale of 1-1024 |
775 | master_processes | id | 1.83.0 | | 0 | SmallIdentifier | false | true | false | |
690 | ao_servers | daemonDeviceId | 1.81.18 | | 7 | string | false | false | false | the device name the master connects to |
699 | ao_servers | time_zone | 1.2 | | 9 | string | true | false | false | the time zone setting for the server |
772 | aoserv_permissions | name | 1.21 | | 0 | string | false | true | true | the unique name of the permission |
1316 | aoserv_protocols | version | 1.0a101 | | 0 | string | false | true | true | the unique version number |
1318 | aoserv_protocols | comments | 1.0a101 | | 2 | string | false | false | true | any comments about this version |
127 | aosh_commands | command | 1.0a100 | | 0 | string | false | true | true | the unique command |
128 | aosh_commands | sinceVersion | 1.81.18 | | 1 | string | false | false | true | the first aoserv_protocol version having this command |
129 | aosh_commands | lastVersion | 1.81.18 | | 2 | string | true | false | true | the last aoserv_protocol version having this command |
131 | aosh_commands | table | 1.81.18 | | 3 | string | true | false | true | the name of the table the column is in, is a global command if the column is null |
133 | aosh_commands | description | 1.81.18 | | 4 | string | false | false | true | a short description of the command |
134 | aosh_commands | syntax | 1.0a100 | | 5 | string | false | false | true | the syntax of the command |
332 | architectures | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the architecture |
154 | backup_retentions | display | 1.0a100 | | 1 | string | false | false | true | the text displayed for this time increment |
62 | bank_accounts | name | 1.0a100 | | 0 | string | false | true | false | the unique name of this account |
63 | bank_accounts | display | 1.0a100 | | 1 | string | false | false | false | the display name of this account |
64 | bank_accounts | bank | 1.0a100 | | 2 | string | false | false | false | the bank the account is with |
89 | bank_transaction_types | name | 1.81.18 | | 0 | string | false | true | false | the name of the type |
90 | bank_transaction_types | display | 1.0a100 | | 1 | string | false | false | false | the display value for the type |
91 | bank_transaction_types | description | 1.0a100 | | 2 | string | false | false | false | a description of the type |
76 | bank_transactions | account | 1.81.18 | | 2 | string | false | false | false | the account the transaction is for |
78 | bank_transactions | processor | 1.29 | | 3 | string | true | false | false | the credit card processor used by this transaction |
80 | bank_transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
82 | bank_transactions | expenseCategory | 1.81.18 | | 6 | string | true | false | false | the category in which this expense belongs |
83 | bank_transactions | description | 1.0a100 | | 7 | string | false | false | false | a description of the transaction |
85 | bank_transactions | checkNo | 1.81.18 | | 8 | string | true | false | false | the check number (if available) |
69 | banks | name | 1.0a100 | | 0 | string | false | true | false | the unique name of the bank |
70 | banks | display | 1.0a100 | | 1 | string | false | false | false | the name that is displayed |
1274 | brands | smtp_password | 1.44 | | 7 | string | false | false | false | |
1277 | brands | imap_password | 1.44 | | 10 | string | false | false | false | |
1279 | brands | support_email_display | 1.44 | | 12 | string | false | true | false | |
1281 | brands | signup_email_display | 1.44 | | 14 | string | false | true | false | |
1296 | brands | support_mailing_address1 | 1.44 | | 24 | string | true | false | false | |
1297 | brands | support_mailing_address2 | 1.44 | | 25 | string | true | false | false | |
1298 | brands | support_mailing_address3 | 1.44 | | 26 | string | true | false | false | |
1299 | brands | support_mailing_address4 | 1.44 | | 27 | string | true | false | false | |
1302 | brands | aoweb_struts_http_url_base | 1.44 | | 30 | string | false | false | false | |
1303 | brands | aoweb_struts_https_url_base | 1.44 | | 31 | string | false | false | false | |
1304 | brands | aoweb_struts_google_verify_content | 1.44 | | 32 | string | true | false | false | |
1306 | brands | aoweb_struts_google_analytics_new_tracking_code | 1.44 | | 34 | string | true | false | false | |
1307 | brands | aoweb_struts_signup_admin_address | 1.44 | | 35 | string | false | false | false | |
1309 | brands | aoweb_struts_keystore_type | 1.53 | | 37 | string | false | false | false | |
1310 | brands | aoweb_struts_keystore_password | 1.53 | | 38 | string | false | false | false | |
32 | business_administrators | name | 1.0a100 | | 2 | string | false | false | false | the name of this admin |
33 | business_administrators | title | 1.0a100 | | 3 | string | true | false | false | the admins title within their organization |
44 | business_administrators | address1 | 1.0a100 | | 13 | string | true | false | false | the street address (if different than business) |
45 | business_administrators | address2 | 1.0a100 | | 14 | string | true | false | false | the street address (if different than business) |
47 | business_administrators | city | 1.69 | | 15 | string | true | false | false | the city (if different than business) |
49 | business_administrators | state | 1.69 | | 16 | string | true | false | false | the state (if different than business) |
51 | business_administrators | country | 1.69 | | 17 | string | true | false | false | the country (if different than business) |
53 | business_administrators | zip | 1.69 | | 18 | string | true | false | false | the zip code (if different than business) |
56 | business_administrators | support_code | 1.44 | | 21 | string | true | true | false | used to authenticate for email-based supprt |
771 | business_administrator_permissions | permission | 1.21 | | 2 | string | false | false | false | the name of the permission that has been granted |
99 | business_profiles | name | 1.0a100 | | 3 | string | false | false | false | the name of the business |
103 | business_profiles | address1 | 1.0a100 | | 7 | string | false | false | false | the street address of the business |
104 | business_profiles | address2 | 1.0a100 | | 8 | string | true | false | false | the street address of the business |
106 | business_profiles | city | 1.69 | | 9 | string | false | false | false | the city |
108 | business_profiles | state | 1.69 | | 10 | string | true | false | false | the state or providence |
110 | business_profiles | country | 1.69 | | 11 | string | false | false | false | the two-character country code |
112 | business_profiles | zip | 1.69 | | 12 | string | true | false | false | the zip code |
115 | business_profiles | billing_contact | 1.0a100 | | 15 | string | false | false | false | the name to contact for billing information |
116 | business_profiles | billing_email | 1.0a100 | | 16 | string | false | false | false | the email address to notify for billing |
117 | business_profiles | billingEmailFormat | 1.81.20 | | 17 | string | false | false | false | the format for billing notification emails |
118 | business_profiles | technical_contact | 1.0a100 | | 18 | string | false | false | false | the name to contact for technical information |
119 | business_profiles | technical_email | 1.0a100 | | 19 | string | false | false | false | the email address to notify for technical |
120 | business_profiles | technicalEmailFormat | 1.81.20 | | 20 | string | false | false | false | the format for technical notification emails |
16 | businesses | contract_version | 1.0a100 | | 1 | string | true | false | false | the version number of the contract |
19 | businesses | cancel_reason | 1.0a100 | | 4 | string | true | false | false | the reason the account was canceled |
26 | businesses | do_not_disable_reason | 1.0a100 | | 10 | string | true | false | false | a reason why we should not disable the account |
1011 | country_codes | code | 1.69 | | 0 | string | false | true | true | the two-character code for the country |
1012 | country_codes | name | 1.0a100 | | 1 | string | false | false | true | the name of the country |
1014 | country_codes | charge_com_name | 1.0a100 | | 3 | string | true | false | true | the Charge.Com specific name |
1175 | credit_card_processors | provider_id | 1.29 | | 0 | string | false | true | false | the unique ID of this processor |
1177 | credit_card_processors | class_name | 1.29 | | 2 | string | false | false | false | the classname of the Java code that connects to the merchant services provider |
1178 | credit_card_processors | param1 | 1.29 | | 3 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1179 | credit_card_processors | param2 | 1.29 | | 4 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1180 | credit_card_processors | param3 | 1.29 | | 5 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1181 | credit_card_processors | param4 | 1.29 | | 6 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1184 | credit_card_processors | description | 1.29 | | 9 | string | true | false | false | an optional description of the processor |
1065 | credit_card_transactions | processor_id | 1.29 | | 1 | string | false | false | false | the name of the processor used for this transaction |
1067 | credit_card_transactions | group_name | 1.29 | | 3 | string | true | false | false | the application-provided grouping for this transaction |
1070 | credit_card_transactions | order_number | 1.29 | | 6 | string | true | false | false | the merchant-provided order number for this transaction |
1085 | credit_card_transactions | shipping_first_name | 1.29 | | 12 | string | true | false | false | the shipping first name |
1086 | credit_card_transactions | shipping_last_name | 1.29 | | 13 | string | true | false | false | the shipping last name |
1087 | credit_card_transactions | shipping_company_name | 1.29 | | 14 | string | true | false | false | the shipping company name |
1088 | credit_card_transactions | shipping_street_address1 | 1.29 | | 15 | string | true | false | false | the shipping address line 1 |
1089 | credit_card_transactions | shipping_street_address2 | 1.29 | | 16 | string | true | false | false | the shipping address line 2 |
1091 | credit_card_transactions | shipping_city | 1.69 | | 17 | string | true | false | false | the shipping city |
1093 | credit_card_transactions | shipping_state | 1.69 | | 18 | string | true | false | false | the shipping state |
1095 | credit_card_transactions | shipping_postal_code | 1.69 | | 19 | string | true | false | false | the shipping postal code |
1097 | credit_card_transactions | shipping_country_code | 1.69 | | 20 | string | true | false | false | the shipping two-digit ISO 3166-1 alpha-2 country code |
1100 | credit_card_transactions | invoice_number | 1.29 | | 23 | string | true | false | false | the merchant-provided invoice number |
1101 | credit_card_transactions | purchase_order_number | 1.29 | | 24 | string | true | false | false | the merchant-provided purchase order number |
1102 | credit_card_transactions | description | 1.29 | | 25 | string | true | false | false | the merchant-provided description of this transaction |
1104 | credit_card_transactions | credit_card_principal_name | 1.29 | | 27 | string | true | false | false | the application-provided principal who provided this credit card |
1106 | credit_card_transactions | credit_card_group_name | 1.29 | | 29 | string | true | false | false | any application-specific grouping |
1107 | credit_card_transactions | credit_card_provider_unique_id | 1.29 | | 30 | string | true | false | false | the unique ID provided by the merchant services provider storage mechanism |
1108 | credit_card_transactions | credit_card_masked_card_number | 1.29 | | 31 | string | false | false | false | the masked card number |
1111 | credit_card_transactions | credit_card_first_name | 1.29 | | 34 | string | false | false | false | the first name of the card holder |
1112 | credit_card_transactions | credit_card_last_name | 1.29 | | 35 | string | false | false | false | the last name of the card holder |
1113 | credit_card_transactions | credit_card_company_name | 1.29 | | 36 | string | true | false | false | the company name for the credit card |
1117 | credit_card_transactions | creditCard.customerId | 1.82.1 | | 40 | string | true | false | false | the merchant-specific unique customer ID |
1118 | credit_card_transactions | credit_card_customer_tax_id | 1.29 | | 41 | string | true | false | false | the tax ID of the card holder |
1119 | credit_card_transactions | credit_card_street_address1 | 1.29 | | 42 | string | false | false | false | the street address of the card holder (line 1) |
1120 | credit_card_transactions | credit_card_street_address2 | 1.29 | | 43 | string | true | false | false | the street address of the card holder (line 2) |
1122 | credit_card_transactions | credit_card_city | 1.69 | | 44 | string | false | false | false | the city of the card holder |
1124 | credit_card_transactions | credit_card_state | 1.69 | | 45 | string | true | false | false | the state/province/prefecture of the card holder |
1126 | credit_card_transactions | credit_card_postal_code | 1.69 | | 46 | string | true | false | false | the postal code of the card holder |
1128 | credit_card_transactions | credit_card_country_code | 1.69 | | 47 | string | false | false | false | the two-digit ISO 3166-1 alpha-2 country code of the card holder |
1129 | credit_card_transactions | credit_card_comments | 1.29 | | 48 | string | true | false | false | any comments associated with the credit card |
1132 | credit_card_transactions | authorization_principal_name | 1.29 | | 51 | string | true | false | false | an application-provided identity of the user who initiated the transaction |
1133 | credit_card_transactions | authorization_communication_result | 1.29 | | 52 | string | true | false | false | the authorization communication result |
1134 | credit_card_transactions | authorization_provider_error_code | 1.29 | | 53 | string | true | false | false | the provider-specific error code |
1135 | credit_card_transactions | authorization_error_code | 1.29 | | 54 | string | true | false | false | the provider-neutral error code |
1136 | credit_card_transactions | authorization_provider_error_message | 1.29 | | 55 | string | true | false | false | the provider-specific error message |
1137 | credit_card_transactions | authorization_provider_unique_id | 1.29 | | 56 | string | true | false | false | the per-provider unique ID |
1138 | credit_card_transactions | authorizationResult.providerReplacementMaskedCardNumber | 1.82.0 | | 57 | string | true | false | false | the provider-specific replacement masked card number |
1139 | credit_card_transactions | authorizationResult.replacementMaskedCardNumber | 1.82.0 | | 58 | string | true | false | false | the replacement masked card number |
1140 | credit_card_transactions | authorizationResult.providerReplacementExpiration | 1.82.0 | | 59 | string | true | false | false | the provider-specific replacement expiration date |
1143 | credit_card_transactions | authorization_provider_approval_result | 1.29 | | 62 | string | true | false | false | the provider-specific approval result |
1144 | credit_card_transactions | authorization_approval_result | 1.29 | | 63 | string | true | false | false | the provider-neutral approval result |
1145 | credit_card_transactions | authorization_provider_decline_reason | 1.29 | | 64 | string | true | false | false | the provider-specific decline reason |
1146 | credit_card_transactions | authorization_decline_reason | 1.29 | | 65 | string | true | false | false | the provider-neutral decline reason |
1147 | credit_card_transactions | authorization_provider_review_reason | 1.29 | | 66 | string | true | false | false | the provider-specific review reason |
1148 | credit_card_transactions | authorization_review_reason | 1.29 | | 67 | string | true | false | false | the provider-neutral review reason |
1149 | credit_card_transactions | authorization_provider_cvv_result | 1.29 | | 68 | string | true | false | false | the provider-specific CVV result |
1150 | credit_card_transactions | authorization_cvv_result | 1.29 | | 69 | string | true | false | false | the provider-neutral CVV result |
1151 | credit_card_transactions | authorization_provider_avs_result | 1.29 | | 70 | string | true | false | false | the provider-specific AVS result |
1152 | credit_card_transactions | authorization_avs_result | 1.29 | | 71 | string | true | false | false | the provider-neutral AVS result |
1153 | credit_card_transactions | authorization_approval_code | 1.29 | | 72 | string | true | false | false | the approval code |
1156 | credit_card_transactions | capture_principal_name | 1.29 | | 75 | string | true | false | false | an application-provided identity of the user who initiated the capture |
1157 | credit_card_transactions | capture_communication_result | 1.29 | | 76 | string | true | false | false | the capture communication result |
1158 | credit_card_transactions | capture_provider_error_code | 1.29 | | 77 | string | true | false | false | the provider-specific error code |
1159 | credit_card_transactions | capture_error_code | 1.29 | | 78 | string | true | false | false | the provider-neutral error code |
1160 | credit_card_transactions | capture_provider_error_message | 1.29 | | 79 | string | true | false | false | the provider-specific error message |
1161 | credit_card_transactions | capture_provider_unique_id | 1.29 | | 80 | string | true | false | false | the per-provider unique ID |
1164 | credit_card_transactions | void_principal_name | 1.29 | | 83 | string | true | false | false | an application-provided identity of the user who initiated the void |
1165 | credit_card_transactions | void_communication_result | 1.29 | | 84 | string | true | false | false | the void communication result |
1166 | credit_card_transactions | void_provider_error_code | 1.29 | | 85 | string | true | false | false | the provider-specific error code |
1167 | credit_card_transactions | void_error_code | 1.29 | | 86 | string | true | false | false | the provider-neutral error code |
1168 | credit_card_transactions | void_provider_error_message | 1.29 | | 87 | string | true | false | false | the provider-specific error message |
1169 | credit_card_transactions | void_provider_unique_id | 1.29 | | 88 | string | true | false | false | the per-provider unique ID |
1170 | credit_card_transactions | status | 1.29 | | 89 | string | false | false | false | the status of the transaction |
1016 | credit_cards | processor_id | 1.29 | | 1 | string | false | false | false | the unique ID of the merchant services provider that is storing the card number and expiration date |
1018 | credit_cards | group_name | 1.29 | | 3 | string | true | false | false | any application-specific grouping |
1020 | credit_cards | card_info | 1.0a100 | | 4 | string | false | false | false | the masked card number |
1023 | credit_cards | provider_unique_id | 1.29 | | 7 | string | false | false | false | the per-provider unique ID allowing use of this credit card for new transactions |
1027 | credit_cards | first_name | 1.29 | | 8 | string | false | false | false | the first name |
1028 | credit_cards | last_name | 1.29 | | 9 | string | false | false | false | the last name |
1029 | credit_cards | company_name | 1.29 | | 10 | string | true | false | false | the company name |
1033 | credit_cards | customerId | 1.82.1 | | 14 | string | true | false | false | the merchant-specific unique customer ID |
1034 | credit_cards | customer_tax_id | 1.29 | | 15 | string | true | false | false | the social security number of employer identification number |
1036 | credit_cards | street_address1 | 1.29 | | 16 | string | false | false | false | the first line of the street address |
1037 | credit_cards | street_address2 | 1.29 | | 17 | string | true | false | false | the second line of the street address |
1040 | credit_cards | city | 1.69 | | 18 | string | false | false | false | the card holders city |
1043 | credit_cards | state | 1.69 | | 19 | string | true | false | false | the card holders state |
1046 | credit_cards | postal_code | 1.69 | | 20 | string | true | false | false | the card holders postal code |
1048 | credit_cards | country_code | 1.69 | | 21 | string | false | false | false | the two-character country code |
1051 | credit_cards | principal_name | 1.29 | | 24 | string | true | false | false | the application-provided principal name of the person added the card to the database |
1055 | credit_cards | deactivate_reason | 1.0a100 | | 28 | string | true | false | false | the reason the card was deactivated |
1057 | credit_cards | description | 1.0a100 | | 29 | string | true | false | false | any comment or description |
1058 | credit_cards | encrypted_card_number | 1.31 | | 30 | string | true | false | false | the card number stored encrypted |
208 | Currency | currencyCode | 1.83.0 | | 0 | string | false | true | true | the ISO 4217 currency code of this currency |
422 | cyrus_imapd_servers | delete_duration_unit | 1.81.10 | | 6 | string | true | false | false | the time unit for delete_duration, one of "d", "h", "m", "s" |
424 | cyrus_imapd_servers | expire_duration_unit | 1.81.10 | | 8 | string | true | false | false | the time unit for expire_duration, one of "d", "h", "m", "s" |
426 | cyrus_imapd_servers | expunge_duration_unit | 1.81.10 | | 10 | string | true | false | false | the time unit for expunge_duration, one of "d", "h", "m", "s" |
61 | disable_log | disable_reason | 1.0a100 | | 4 | string | true | false | false | the optional reason the accounts were disabled |
1789 | distro_file_types | type | 1.0a100 | | 0 | string | false | true | false | the unique name of the type |
1790 | distro_file_types | description | 1.0a100 | | 1 | string | false | false | false | a description of the type of file |
1774 | distro_files | type | 1.0a100 | | 4 | string | false | false | false | the type of file |
1788 | distro_files | symlink_target | 1.0a100 | | 13 | string | true | false | false | the target if is a symbolic link |
1791 | distro_report_types | name | 1.70 | | 0 | string | false | true | false | the unique name of the type |
1792 | distro_report_types | display | 1.70 | | 1 | string | false | false | false | a display value of the type of report |
369 | dns_records | domain | 1.69 | | 2 | string | false | false | false | the first column in the zone files |
370 | dns_records | type | 1.0a100 | | 3 | string | false | false | false | the type as found in dns_types |
376 | dns_records | tag | 1.86.0 | | 8 | string | true | false | false | the CAA tag |
377 | dns_records | destination | 1.0a100 | | 9 | string | false | false | false | the destination, either IP address, hostname, or other value depending on the type of record |
393 | dns_tlds | description | 1.0a100 | | 1 | string | false | false | true | |
382 | dns_types | type | 1.0a100 | | 0 | string | false | true | true | the type |
383 | dns_types | description | 1.0a100 | | 1 | string | false | false | true | the description of the type |
395 | dns_zones | file | 1.0a100 | | 1 | string | false | false | false | the filename of the zone file |
398 | dns_zones | hostmaster | 1.0a100 | | 3 | string | false | false | false | the email address of the person in charge of the domain |
402 | email_addresses | address | 1.0a100 | | 1 | string | false | false | false | address before the @ |
406 | email_attachment_blocks | extension | 1.0a116 | | 2 | string | false | false | false | the extension of the blocked files |
407 | email_attachment_types | extension | 1.0a116 | | 0 | string | false | true | true | the unique filename extension |
408 | email_attachment_types | description | 1.0a116 | | 1 | string | false | false | true | a brief description of the attachment type |
478 | email_pipes | command | 1.80.0 | | 2 | string | false | false | false | the complete command string to the email handling program |
520 | email_smtp_relay_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
521 | email_smtp_relay_types | sendmail_config | 1.0a100 | | 1 | string | false | false | true | the config value used for sendmail |
522 | email_smtp_relay_types | qmail_config | 1.0a100 | | 2 | string | false | false | true | the config value used for qmail |
514 | email_smtp_relays | type | 1.0a100 | | 4 | string | false | false | false | the type of entry |
534 | email_sa_integration_modes | name | 1.0a120 | | 0 | string | false | true | true | the unique name of the mode |
535 | email_sa_integration_modes | display | 1.0a120 | | 1 | string | false | false | true | the display value for the mode |
1207 | encryption_keys | id | 1.23 | | 2 | string | false | false | false | the id of the recipient who may decrypt the message |
95 | expense_categories | name | 1.81.18 | | 0 | string | false | true | false | a simple code used as primary key |
207 | failover_mysql_replications | max_alert_level | 1.74 | | 8 | string | false | false | false | the maximum alert level for all monitoring of this slave |
191 | file_backup_settings | path | 1.0a100 | | 2 | string | false | false | false | the path to control |
955 | firewalld_zones | short | 1.81.0 | | 3 | string | true | false | false | the optional short name |
956 | firewalld_zones | description | 1.81.0 | | 4 | string | true | false | false | the optional description |
2455 | httpd_jboss_versions | template_dir | 1.0a100 | | 2 | string | false | false | true | directory containing the install template |
2537 | httpd_jk_codes | code | 1.0a100 | | 0 | string | false | true | true | the unique, two-character code |
2493 | httpd_jk_protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the protocol used, as found in protocols.protocol |
1526 | httpd_servers | name | 1.81.8 | | 2 | string | true | false | false | the name of the instance on the server, null for the default instance |
2504 | httpd_shared_tomcats | name | 1.0a100 | | 1 | string | false | false | false | unique name for this jvm |
2520 | httpd_shared_tomcats | tomcat4_shutdown_key | 1.0a100 | | 9 | string | true | false | false | the key used to shut down the JVM |
1576 | httpd_site_authenticated_locations | path | 1.18 | | 2 | string | false | false | false | the path to protect, unique per httpd_site |
1578 | httpd_site_authenticated_locations | auth_name | 1.18 | | 4 | string | false | false | false | the prompt given to the user during authentication |
1581 | httpd_site_authenticated_locations | require | 1.18 | | 7 | string | false | false | false | the require directive parameter(s) for Apache |
1582 | httpd_site_authenticated_locations | handler | 1.81.13 | | 8 | string | true | false | false | the optional handler for this location |
1513 | httpd_site_bind_headers | type | 1.81.15 | | 3 | string | false | false | false | the type of header, either "Header" or "RequestHeader" |
1515 | httpd_site_bind_headers | action | 1.81.15 | | 5 | string | false | false | false | the action to be performed |
1516 | httpd_site_bind_headers | header | 1.81.15 | | 6 | string | false | false | false | the header name, without any final colon |
1517 | httpd_site_bind_headers | value | 1.81.15 | | 7 | string | true | false | false | the header value, not used for all actions |
1518 | httpd_site_bind_headers | replacement | 1.81.15 | | 8 | string | true | false | false | the replacement value, only used for "edit" and "edit*" |
1519 | httpd_site_bind_headers | when | 1.81.15 | | 9 | string | true | false | false | optional control over when is this header directive is applied |
1520 | httpd_site_bind_headers | comment | 1.81.15 | | 10 | string | true | false | false | an optional comment describing the redirect |
1593 | RewriteRule | pattern | 1.81.21 | | 3 | string | false | false | false | the per-VirtualHost pattern matched |
1594 | RewriteRule | substitution | 1.81.21 | | 4 | string | false | false | false | the rewrite substitution |
1595 | RewriteRule | flags | 1.81.21 | | 5 | string | true | false | false | the optional flags for the rule |
1596 | RewriteRule | comment | 1.81.21 | | 6 | string | true | false | false | an optional comment describing the rule |
1642 | httpd_site_binds | name | 1.81.14 | | 3 | string | true | false | false | the name of the bind, null for the default bind |
1650 | httpd_site_binds | predisable_config | 1.0a100 | | 8 | string | true | false | false | the config file before the site was disabled |
1653 | httpd_site_binds | include_site_config | 1.81.10 | | 11 | string | true | false | false | controls whether this bind includes the per-site configuration file |
1601 | httpd_sites | name | 1.81.18 | | 2 | string | false | false | false | the name of the site, as used in the /var/www directory. |
1621 | httpd_sites | awstats_skip_files | 1.0a129 | | 10 | string | true | false | false | the SkipFiles setting for AWStats |
2475 | httpd_tomcat_contexts | class_name | 1.0a100 | | 2 | string | true | false | false | the className attribute |
2481 | httpd_tomcat_contexts | path | 1.0a100 | | 7 | string | false | false | false | the path attribute |
2485 | httpd_tomcat_contexts | wrapper_class | 1.0a100 | | 11 | string | true | false | false | the wrapperClass attribute |
2458 | httpd_tomcat_data_sources | name | 1.5 | | 2 | string | false | false | false | the JNDI name |
2459 | httpd_tomcat_data_sources | driver_class_name | 1.5 | | 3 | string | false | false | false | fully qualified Java class name of the JDBC driver to be used |
2460 | httpd_tomcat_data_sources | url | 1.5 | | 4 | string | false | false | false | connection URL to be passed to our JDBC driver |
2461 | httpd_tomcat_data_sources | username | 1.5 | | 5 | string | false | false | false | database username to be passed to our JDBC driver |
2462 | httpd_tomcat_data_sources | password | 1.5 | | 6 | string | false | false | false | database password to be passed to our JDBC driver |
2466 | httpd_tomcat_data_sources | validation_query | 1.5 | | 10 | string | true | false | false | SQL 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. |
2469 | httpd_tomcat_parameters | name | 1.5 | | 2 | string | false | false | false | the name of the context initialization parameter to be created |
2470 | httpd_tomcat_parameters | value | 1.5 | | 3 | string | false | false | false | the parameter value that will be presented to the application when requested by calling ServletContext.getInitParameter() |
2472 | httpd_tomcat_parameters | description | 1.5 | | 5 | string | true | false | false | optional, human-readable description of this context initialization parameter |
2491 | httpd_tomcat_site_jk_mounts | path | 1.81.6 | | 2 | string | false | false | false | the per-site unique pattern matched |
2496 | httpd_tomcat_std_sites | tomcat4_shutdown_key | 1.0a100 | | 2 | string | true | false | false | the key used to shut down the JVM |
2541 | httpd_workers | name | 1.81.18 | | 1 | string | false | false | false | the jk_code for the worker |
999 | ip_addresses | netmask | 1.38 | | 11 | string | false | false | false | the netmask of the local network |
2361 | ip_reputation_limiter_limits | class | 1.66 | | 2 | string | false | false | false | the reputation class |
2364 | ip_reputation_limiter_limits | syn_per_ip_unit | 1.66 | | 5 | string | false | false | false | |
2368 | ip_reputation_limiter_limits | syn_unit | 1.66 | | 9 | string | false | false | false | |
2371 | ip_reputation_limiter_limits | packet_per_ip_unit | 1.66 | | 12 | string | false | false | false | |
2375 | ip_reputation_limiter_limits | packet_unit | 1.66 | | 16 | string | false | false | false | |
2378 | ip_reputation_limiters | identifier | 1.66 | | 2 | string | false | false | false | the per-net_device unique identifier |
2379 | ip_reputation_limiters | description | 1.66 | | 3 | string | true | false | false | an optional description of the limiter |
2392 | ip_reputation_sets | identifier | 1.65 | | 2 | string | false | true | false | a globally unique identifier |
1473 | languages | code | 1.44 | | 0 | string | false | true | true | the language code |
766 | linux_account_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
767 | linux_account_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
733 | linux_accounts | type | 1.0a100 | | 5 | string | false | false | false | the type of account |
651 | linux_group_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
652 | linux_group_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
641 | linux_groups | type | 1.0a100 | | 2 | string | false | false | false | the type of group |
752 | linux_server_accounts | autoresponder_subject | 1.0a100 | | 6 | string | true | false | false | the subject of autoresponder messages |
753 | linux_server_accounts | autoresponder_path | 1.0a100 | | 7 | string | true | false | false | the full path of the autoresponder text file |
756 | linux_server_accounts | predisable_password | 1.0a100 | | 10 | string | true | false | false | stores the password that was used before the account was disabled |
762 | linux_server_accounts | sa_integration_mode | 1.0a120 | | 15 | string | false | false | false | the integration mode for SpamAssassin |
765 | linux_server_accounts | sudo | 1.80.1 | | 18 | string | true | false | false | the sudo setting or null when sudo not allowed |
454 | majordomo_lists | name | 1.0a100 | | 2 | string | false | false | false | the list name |
464 | majordomo_servers | version | 1.0a100 | | 3 | string | false | false | false | the version of Majordomo to use |
470 | majordomo_versions | version | 1.0a100 | | 0 | string | false | true | true | the version number |
782 | master_processes | protocol | 1.0a100 | | 6 | string | false | false | false | |
783 | master_processes | aoserv_protocol | 1.0a101 | | 7 | string | true | false | false | |
789 | master_processes | state | 1.0a100 | | 13 | string | false | false | false | |
790 | master_processes | command | 1.0a100 | | 14 | string | true | false | false | |
792 | master_server_stats | name | 1.0a100 | | 0 | string | false | true | false | |
793 | master_server_stats | value | 1.0a100 | | 1 | string | true | false | false | |
794 | master_server_stats | description | 1.0a100 | | 2 | string | false | false | false | |
215 | monthly_charges | type | 1.0a100 | | 3 | string | false | false | false | the type of charge, as found in transaction types |
216 | monthly_charges | description | 1.0a100 | | 4 | string | true | false | false | the description that is placed in the transaction |
822 | mysql_databases | max_check_table_alert_level | 1.74 | | 4 | string | false | false | false | the maximum alert level created for the check table monitoring of this database |
893 | mysql_server_users | host | 1.69 | | 3 | string | false | false | false | the 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. |
895 | mysql_server_users | predisable_password | 1.0a100 | | 5 | string | true | false | false | the password used before the account was disabled |
922 | net_binds | app_protocol | 1.0a100 | | 5 | string | false | false | false | the application protocol (<code>protocols</code>) |
929 | net_binds | monitoring_parameters | 1.58 | | 7 | string | true | false | false | the URL-encoded name=value pairs of monitoring parameters |
930 | net_device_ids | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the device |
936 | net_devices | deviceId | 1.81.18 | | 2 | string | false | false | false | the name of the device |
937 | net_devices | description | 1.0a100 | | 3 | string | false | false | false | a description of the device |
939 | net_devices | delete_route | 1.0a112 | | 4 | string | true | false | false | the default routing from the network scripts that should be removed |
229 | notice_log | billing_contact | 1.0a100 | | 3 | string | false | false | false | |
232 | notice_log | notice_type | 1.0a100 | | 5 | string | false | false | false | |
235 | notice_types | type | 1.0a100 | | 0 | string | false | true | true | |
236 | notice_types | description | 1.0a100 | | 1 | string | false | false | true | |
338 | operating_system_versions | operating_system | 1.0a100 | | 1 | string | false | false | true | the name of the OS |
339 | operating_system_versions | version_number | 1.0a100 | | 2 | string | false | false | true | the number of OS version |
340 | operating_system_versions | version_name | 1.0a100 | | 3 | string | false | false | true | the name of this OS release |
341 | operating_system_versions | architecture | 1.0a108 | | 4 | string | false | false | true | the name of the architecture |
343 | operating_system_versions | display | 1.0a108 | | 5 | string | false | true | true | the full display name for this version |
334 | operating_systems | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the operating system |
335 | operating_systems | display | 1.0a100 | | 1 | string | false | false | true | the display version of the name |
237 | package_categories | name | 1.0a123 | | 0 | string | false | true | true | the category name |
241 | package_definition_limits | resource | 1.0a123 | | 2 | string | false | false | false | the resource name |
246 | package_definition_limits | additional_transaction_type | 1.0a123 | | 6 | string | true | false | false | |
251 | package_definitions | category | 1.0a123 | | 2 | string | false | false | false | the package category |
252 | package_definitions | name | 1.0a123 | | 3 | string | false | false | false | the name of the package |
253 | package_definitions | version | 1.0a123 | | 4 | string | false | false | false | the unique version of this package |
254 | package_definitions | display | 1.0a123 | | 5 | string | false | false | false | a short description for display use |
255 | package_definitions | description | 1.0a123 | | 6 | string | false | false | false | a description of the package definition |
258 | package_definitions | setup_fee_transaction_type | 1.0a123 | | 8 | string | true | false | false | |
261 | package_definitions | monthly_rate_transaction_type | 1.0a123 | | 10 | string | true | false | false | |
1171 | payment_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
1172 | payment_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type of payment |
564 | physical_servers | processor_type | 1.36 | | 4 | string | true | false | false | the processor type |
569 | physical_servers | ups_type | 1.63 | | 9 | string | false | false | false | the type of UPS powering the server |
1226 | postgres_encodings | encoding | 1.0a100 | | 1 | string | false | false | true | the name of the encoding |
1254 | postgres_server_users | predisable_password | 1.0a100 | | 4 | string | true | false | false | the password that was on the account before it was disabled |
1257 | postgres_versions | minor_version | 1.0a121 | | 1 | string | false | false | true | the minor version for this version (used for installation at /usr/postgresql/<minor_version> |
570 | processor_types | type | 1.36 | | 0 | string | false | true | true | the unique name of the type of processor |
900 | protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the unique name of the protocol |
904 | protocols | name | 1.0a100 | | 2 | string | false | false | true | the name of the service |
573 | racks | farm | 1.36 | | 1 | string | false | false | false | the server_farm housing the rack |
574 | racks | name | 1.36 | | 2 | string | false | false | false | the per-farm unique name |
288 | resources | name | 1.0a100 | | 0 | string | false | true | true | the name of the specific resource |
1324 | schema_columns | table | 1.81.18 | | 1 | string | false | false | true | the name of the table the column is in |
1326 | schema_columns | name | 1.81.18 | | 2 | string | false | false | true | the name of the column |
1327 | schema_columns | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version this column was in |
1328 | schema_columns | lastVersion | 1.81.18 | | 4 | string | true | false | true | the last version containing this field |
1331 | schema_columns | type | 1.0a100 | | 6 | string | false | false | true | the type of data in the column |
1338 | schema_columns | description | 1.0a100 | | 10 | string | false | false | true | any description associated with the column |
1350 | schema_foreign_keys | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version to have this reference |
1352 | schema_foreign_keys | lastVersion | 1.81.18 | | 4 | string | true | false | true | the last aoserv_protocol version to have this references, or null if not yet removed |
1354 | schema_tables | name | 1.0a100 | | 1 | string | false | true | true | the unique name |
1356 | schema_tables | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version to have this table |
1357 | schema_tables | lastVersion | 1.81.18 | | 3 | string | true | false | true | the last aoserv_protocol version to have this table or null if still used |
1358 | schema_tables | display | 1.0a100 | | 4 | string | false | false | true | the display name |
1361 | schema_tables | description | 1.0a100 | | 6 | string | false | false | true | the description of the table |
1368 | schema_types | name | 1.81.18 | | 1 | string | false | true | true | the unique name |
1371 | schema_types | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version this type was in |
1373 | schema_types | lastVersion | 1.81.18 | | 3 | string | true | false | true | the last version containing this type |
484 | sendmail_binds | servername | 1.81.10 | | 2 | string | true | false | false | the Name for DaemonPortOptions for this bind |
488 | sendmail_servers | name | 1.81.10 | | 2 | string | true | false | false | the name of the instance on the server, null for the default instance |
577 | server_farms | name | 1.0a100 | | 0 | string | false | true | false | the unique name of the farm |
578 | server_farms | description | 1.0a100 | | 1 | string | false | false | false | a description of the farm |
960 | servers | farm | 1.0a100 | | 1 | string | false | false | false | the name of the farm the server is located in |
963 | servers | description | 1.0a100 | | 2 | string | false | false | false | a description of the servers purpose |
973 | servers | name | 1.31 | | 5 | string | false | false | false | the per-package unique name of the server (no special formatting required) |
1385 | signup_request_options | name | 1.23 | | 2 | string | false | false | false | the unique-per-request name of the option |
1386 | signup_request_options | value | 1.23 | | 3 | string | true | false | false | the value of the option |
1393 | signup_requests | business_name | 1.23 | | 5 | string | false | false | false | the name of the business |
1398 | signup_requests | business_address1 | 1.23 | | 8 | string | false | false | false | the street address of the business |
1399 | signup_requests | business_address2 | 1.23 | | 9 | string | true | false | false | the street address of the business |
1401 | signup_requests | business_city | 1.69 | | 10 | string | false | false | false | the city of the business |
1403 | signup_requests | business_state | 1.69 | | 11 | string | true | false | false | the state or providence of the business |
1405 | signup_requests | business_country | 1.69 | | 12 | string | false | false | false | the two-character country code of the business |
1407 | signup_requests | business_zip | 1.69 | | 13 | string | true | false | false | the zip code of the business |
1408 | signup_requests | ba_name | 1.23 | | 14 | string | false | false | false | the administrator's name |
1409 | signup_requests | ba_title | 1.23 | | 15 | string | true | false | false | the administrator's title |
1411 | signup_requests | ba_work_phone | 1.69 | | 16 | string | false | false | false | the administrator's work phone |
1413 | signup_requests | ba_cell_phone | 1.69 | | 17 | string | true | false | false | the administrator's cell phone |
1415 | signup_requests | ba_home_phone | 1.69 | | 18 | string | true | false | false | the administrator's home phone |
1417 | signup_requests | ba_fax | 1.69 | | 19 | string | true | false | false | the administrator's fax number |
1419 | signup_requests | ba_address1 | 1.23 | | 21 | string | true | false | false | the street address of the administrator |
1420 | signup_requests | ba_address2 | 1.23 | | 22 | string | true | false | false | the street address of the administrator |
1422 | signup_requests | ba_city | 1.69 | | 23 | string | true | false | false | the city of the administrator |
1424 | signup_requests | ba_state | 1.69 | | 24 | string | true | false | false | the state or providence of the administrator |
1426 | signup_requests | ba_country | 1.69 | | 25 | string | true | false | false | the two-character country code of the administrator |
1428 | signup_requests | ba_zip | 1.69 | | 26 | string | true | false | false | the zip code of the administrator |
1430 | signup_requests | billing_contact | 1.23 | | 28 | string | false | false | false | the name of the billing contact |
1434 | signup_requests | encrypted_data | 1.23 | | 32 | string | false | false | false | the credit card details and password are stored encrypted |
540 | spam_email_messages | message | 1.0a100 | | 3 | string | false | false | false | the message contents |
1196 | ssl_certificate_other_uses | display | 1.81.16 | | 4 | string | false | false | false | a short display value, which will often follow the count when displayed |
1204 | ssl_certificates | certbot_name | 1.81.10 | | 7 | string | true | false | false | the name of the certbot-managed Let's Encrypt certificate |
543 | system_email_aliases | address | 1.0a100 | | 2 | string | false | false | false | the address (username only) to match |
544 | system_email_aliases | destination | 1.0a100 | | 3 | string | false | false | false | the destination, as found in /etc/aliases |
347 | technologies | name | 1.0a100 | | 1 | string | false | false | true | the name of the package |
348 | technologies | class | 1.0a100 | | 2 | string | false | false | true | the name of the group this package belongs to |
349 | technology_classes | name | 1.0a100 | | 0 | string | false | true | true | the name of the class |
350 | technology_classes | description | 1.0a100 | | 1 | string | false | false | true | a description of the class |
351 | technology_names | name | 1.0a100 | | 0 | string | false | true | true | the name of the package |
352 | technology_names | image_filename | 1.0a100 | | 1 | string | true | false | true | the name of the file containing the image |
355 | technology_names | image_alt | 1.0a100 | | 4 | string | true | false | true | the alt attribute of the image |
358 | technology_versions | name | 1.0a100 | | 1 | string | false | false | true | the name of the software package |
359 | technology_versions | version | 1.0a100 | | 2 | string | false | false | true | the version number of the package in #.##.##-## format |
364 | technology_versions | disable_reason | 1.78 | | 7 | string | true | false | true | the reason this version is no longer supported |
1467 | ticket_action_types | type | 1.44 | | 0 | string | false | true | true | |
1444 | ticket_actions | action_type | 1.44 | | 4 | string | false | false | false | |
1449 | ticket_actions | old_priority | 1.44 | | 7 | string | true | false | false | |
1450 | ticket_actions | new_priority | 1.44 | | 8 | string | true | false | false | |
1451 | ticket_actions | old_type | 1.49 | | 9 | string | true | false | false | |
1452 | ticket_actions | new_type | 1.49 | | 10 | string | true | false | false | |
1453 | ticket_actions | old_status | 1.44 | | 11 | string | true | false | false | |
1454 | ticket_actions | new_status | 1.44 | | 12 | string | true | false | false | |
1461 | ticket_actions | old_value | 1.44 | | 17 | string | true | false | false | |
1462 | ticket_actions | new_value | 1.44 | | 18 | string | true | false | false | |
1464 | ticket_actions | summary | 1.44 | | 20 | string | true | false | false | |
1465 | ticket_actions | details | 1.44 | | 21 | string | true | false | false | |
1466 | ticket_actions | raw_email | 1.44 | | 22 | string | true | false | false | |
1313 | ticket_categories | name | 1.44 | | 2 | string | false | false | false | |
1474 | ticket_priorities | priority | 1.0a100 | | 0 | string | false | true | true | |
1475 | ticket_stati | status | 1.0a100 | | 0 | string | false | true | true | |
1507 | ticket_types | type | 1.0a100 | | 0 | string | false | true | true | |
1483 | tickets | language | 1.44 | | 4 | string | false | false | false | |
1487 | tickets | ticket_type | 1.0a100 | | 7 | string | false | false | false | |
1489 | tickets | summary | 1.44 | | 9 | string | false | false | false | |
1491 | tickets | details | 1.44 | | 10 | string | true | false | false | |
1492 | tickets | raw_email | 1.44 | | 11 | string | true | false | false | |
1497 | tickets | client_priority | 1.0a100 | | 13 | string | false | false | false | |
1499 | tickets | admin_priority | 1.10 | | 14 | string | true | false | false | |
1501 | tickets | status | 1.0a100 | | 15 | string | false | false | false | |
1504 | tickets | contact_emails | 1.0a125 | | 17 | string | false | false | false | |
1505 | tickets | contact_phone_numbers | 1.0a125 | | 18 | string | false | false | false | |
1506 | tickets | internal_notes | 1.69 | | 19 | string | false | false | false | |
721 | time_zones | name | 1.2 | | 0 | string | false | true | true | The unique name of this time zone |
313 | transaction_types | name | 1.0a123 | | 0 | string | false | true | true | the name of the type |
300 | transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
301 | transactions | description | 1.0a100 | | 6 | string | false | false | false | description of the transaction |
305 | transactions | payment_type | 1.0a100 | | 9 | string | true | false | false | the 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 |
306 | transactions | payment_info | 1.0a100 | | 10 | string | true | false | false | the payment info, such as last four of credit card number of check number |
308 | transactions | processor | 1.29 | | 11 | string | true | false | false | the credit card processor that handled the payment |
312 | transactions | payment_confirmed | 1.0a100 | | 13 | string | false | false | false | 'Y' if the payment is confirmed
'W' if waiting confirmation
'N' if confirmation failed |
125 | us_states | code | 1.0a100 | | 0 | string | false | true | true | the two-character code for the state |
126 | us_states | name | 1.0a100 | | 1 | string | false | false | true | the name of the state |
586 | virtual_disks | device | 1.36 | | 2 | string | false | false | false | the per-virtual-server unique device, such as xvda or xvdb |
611 | virtual_servers | minimum_processor_type | 1.41 | | 5 | string | true | false | false | the minimum processor type |
614 | virtual_servers | minimum_processor_architecture | 1.36 | | 6 | string | false | false | false | the minimum processor architecture, compatible architectures may be substituted |
632 | virtual_servers | vnc_password | 1.51 | | 16 | string | false | true | false | the password for VNC console access or null to disable VNC access |
330 | WhoisHistory | output | 1.81.19 | | 4 | string | false | false | false | the output from the whois lookup |
331 | WhoisHistory | error | 1.81.19 | | 5 | string | false | false | false | the error from the whois lookup |
684 | ao_servers | last_distro_time | 1.0a100 | | 5 | time | true | false | false | the time the last distro check was started |
72 | bank_transactions | time | 1.0a100 | | 1 | time | false | false | false | the time the transaction occured |
38 | business_administrators | created | 1.0a100 | | 7 | time | false | false | false | the time the admin entry was created |
114 | business_profiles | created | 1.0a100 | | 14 | time | false | false | false | the time this entry was created |
17 | businesses | created | 1.0a100 | | 2 | time | false | false | false | the time the account was created |
18 | businesses | canceled | 1.0a100 | | 3 | time | true | false | false | the time the account was deactivated |
1130 | credit_card_transactions | authorization_time | 1.29 | | 49 | time | false | false | false | the time the authorization was attempted |
1154 | credit_card_transactions | capture_time | 1.29 | | 73 | time | true | false | false | the time the capture was attempted |
1162 | credit_card_transactions | void_time | 1.29 | | 81 | time | true | false | false | the time the void was attempted |
1049 | credit_cards | created | 1.0a100 | | 22 | time | false | false | false | the time the card was added to the database |
1054 | credit_cards | deactivated_on | 1.0a100 | | 27 | time | true | false | false | the time the card was deactivated |
1379 | cvs_repositories | created | 1.0a100 | | 5 | time | false | false | false | the time the repository was created |
58 | disable_log | time | 1.0a100 | | 1 | time | false | false | false | the time the stuff was disabled |
515 | email_smtp_relays | created | 1.0a100 | | 5 | time | false | false | false | the time the entry was created |
516 | email_smtp_relays | last_refreshed | 1.0a100 | | 6 | time | false | false | false | the time the entry was last updated |
518 | email_smtp_relays | expiration | 1.0a100 | | 8 | time | true | false | false | the expiration time of the entry, or null if non-expiring |
157 | failover_file_log | start_time | 1.0a100 | | 2 | time | false | false | false | the time the replication started |
158 | failover_file_log | end_time | 1.0a100 | | 3 | time | false | false | false | the time the replication finished |
989 | ip_addresses | created | 1.0a100 | | 6 | time | false | false | false | the time the IP address was added |
2400 | ip_reputation_sets | last_host_decay | 1.65 | | 10 | time | false | false | false | the time the hosts were last decayed |
2402 | ip_reputation_sets | last_network_decay | 1.65 | | 12 | time | false | false | false | the time the networks were last decayed |
2403 | ip_reputation_sets | last_reputation_added | 1.67 | | 13 | time | false | false | false | the time reputation was last added |
735 | linux_accounts | created | 1.0a100 | | 7 | time | false | false | false | the time the account was created |
758 | linux_server_accounts | created | 1.69 | | 11 | time | false | false | false | the time this account was added |
650 | linux_server_groups | created | 1.69 | | 4 | time | false | false | false | the time the group was added |
471 | majordomo_versions | created | 1.0a100 | | 1 | time | false | false | true | the time the version was added |
785 | master_processes | connect_time | 1.0a100 | | 9 | time | false | false | false | |
791 | master_processes | state_start_time | 1.0a100 | | 15 | time | false | false | false | |
220 | monthly_charges | created | 1.0a100 | | 7 | time | false | false | false | the time this entry was created |
227 | notice_log | create_time | 1.0a100 | | 1 | time | false | false | false | |
271 | packages | created | 1.0a100 | | 4 | time | false | false | false | |
555 | private_ftp_servers | created | 1.0a100 | | 4 | time | false | false | false | the time the server was added |
1390 | signup_requests | time | 1.23 | | 2 | time | false | false | false | the time the request was added |
1439 | signup_requests | completed_time | 1.23 | | 36 | time | true | false | false | the time this request was completed |
539 | spam_email_messages | time | 1.0a100 | | 2 | time | false | false | false | the time the message was added |
360 | technology_versions | updated | 1.0a100 | | 3 | time | false | false | true | the time this package was last updated |
363 | technology_versions | disable_time | 1.78 | | 6 | time | true | false | true | the time this version is no longer supported |
1443 | ticket_actions | time | 1.44 | | 3 | time | false | false | false | |
1493 | tickets | open_date | 1.0a100 | | 12 | time | false | false | false | |
1502 | tickets | status_timeout | 1.69 | | 16 | time | true | false | false | |
294 | transactions | time | 1.0a100 | | 0 | time | false | false | false | the time the transaction occured |
328 | WhoisHistory | time | 1.81.19 | | 2 | time | false | false | false | the time the whois query was performed |
356 | technology_names | home_page_url | 1.0a100 | | 5 | url | true | false | true | the URL of the technology home page |
79 | bank_transactions | administrator | 1.0a100 | | 4 | username | false | false | false | the business_administrator who made this transaction |
29 | business_administrators | username | 1.0a100 | | 0 | username | false | true | false | the unique identifier for this admin |
770 | business_administrator_permissions | username | 1.21 | | 1 | username | false | false | false | the username of the administrator with this permission |
1103 | credit_card_transactions | credit_card_created_by | 1.29 | | 26 | username | false | false | false | the business administrator account that provided this credit card |
1131 | credit_card_transactions | authorization_username | 1.29 | | 50 | username | false | false | false | the username of the business_administrator account that processed the transaction |
1155 | credit_card_transactions | capture_username | 1.29 | | 74 | username | true | false | false | the username of the business_administrator account that processed the capture |
1163 | credit_card_transactions | void_username | 1.29 | | 82 | username | true | false | false | the username of the business_administrator account that processed the void |
1050 | credit_cards | created_by | 1.0a100 | | 23 | username | false | false | false | the business_administrator who added the card to the database |
60 | disable_log | disabled_by | 1.0a100 | | 3 | username | false | false | false | the person who disabled the accounts |
796 | master_hosts | username | 1.0a100 | | 1 | username | false | false | false | the unique username of the user |
778 | master_processes | authenticated_user | 1.0a100 | | 2 | username | true | false | false | |
779 | master_processes | effective_user | 1.0a100 | | 3 | username | true | false | false | |
800 | master_servers | username | 1.0a100 | | 1 | username | false | false | false | the unique username of the user |
802 | master_users | username | 1.0a100 | | 0 | username | false | true | false | the unique username of the user |
221 | monthly_charges | created_by | 1.0a100 | | 8 | username | false | false | false | the business_administrator who created the entry |
272 | packages | created_by | 1.0a100 | | 5 | username | false | false | false | |
1429 | signup_requests | ba_username | 1.23 | | 27 | username | false | false | false | the username of the administrator |
1438 | signup_requests | completed_by | 1.23 | | 35 | username | true | false | false | the username of the person who completed this sign-up request |
361 | technology_versions | owner | 1.0a100 | | 4 | username | false | false | false | the business_administrator who is responsible for maintaining this package |
1442 | ticket_actions | administrator | 1.44 | | 2 | username | true | false | false | |
1456 | ticket_actions | old_assigned_to | 1.80.0 | | 13 | username | true | false | false | |
1458 | ticket_actions | new_assigned_to | 1.80.0 | | 14 | username | true | false | false | |
1472 | ticket_assignments | administrator | 1.44 | | 3 | username | false | false | false | |
1485 | tickets | created_by | 1.0a126 | | 5 | username | true | false | false | |
299 | transactions | username | 1.0a100 | | 4 | username | false | false | false | the identifier for the admin involved in the transaction (see business_administrators) |
121 | usernames | username | 1.0a100 | | 0 | username | false | true | false | the unique username |
365 | dns_forbidden_zones | zone | 1.0a100 | | 0 | zone | false | true | true | the zone (domain) that is forbidden |
367 | dns_records | zone | 1.0a100 | | 1 | zone | false | false | false | the zone as found in dns_zones |
394 | dns_zones | zone | 1.0a100 | | 0 | zone | false | true | false | the zone (domain) that is hosted |