1643 | httpd_site_binds | access_log | 1.0a100 | | 4 | path | false | false | false | the file used for access logging |
76 | bank_transactions | account | 1.81.18 | | 2 | string | false | false | false | the account the transaction is for |
320 | WhoisHistoryAccount | account | 1.81.19 | | 2 | accounting | false | false | false | the id of the Account |
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. |
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 |
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 |
1206 | encryption_keys | accounting | 1.23 | | 1 | accounting | false | false | false | the accounting code of the business that owns this key |
2391 | ip_reputation_sets | accounting | 1.65 | | 1 | accounting | false | false | false | the accounting code of the business |
212 | monthly_charges | accounting | 1.0a100 | | 1 | accounting | false | false | false | the account code that is charged to |
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 |
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 | |
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) |
1515 | httpd_site_bind_headers | action | 1.81.15 | | 5 | string | false | false | false | the action to be performed |
1444 | ticket_actions | action_type | 1.44 | | 4 | string | false | false | false | |
1053 | credit_cards | active | 1.0a100 | | 26 | boolean | false | false | false | if <code>true</code> the card is currently active |
222 | monthly_charges | active | 1.0a100 | | 9 | boolean | false | false | false | flags if this entry is active |
262 | package_definitions | active | 1.0a123 | | 11 | boolean | false | false | false | allows new accounts for this package |
1173 | payment_types | active | 1.0a100 | | 2 | boolean | false | false | true | indicates if payment is currently accepted via this method |
246 | package_definition_limits | additional_transaction_type | 1.0a123 | | 6 | string | true | false | false | |
245 | package_definition_limits | additionalRate | 1.83.0 | | 5 | money | true | false | false | the monthly rate for those past the soft_limit |
402 | email_addresses | address | 1.0a100 | | 1 | string | false | false | false | address before the @ |
543 | system_email_aliases | address | 1.0a100 | | 2 | string | false | false | false | the address (username only) to match |
44 | business_administrators | address1 | 1.0a100 | | 13 | string | true | false | false | the street address (if different than business) |
103 | business_profiles | address1 | 1.0a100 | | 7 | string | false | false | false | the street address of the business |
45 | business_administrators | address2 | 1.0a100 | | 14 | string | true | false | false | the street address (if different than business) |
104 | business_profiles | address2 | 1.0a100 | | 8 | string | true | false | false | the street address of the business |
1499 | tickets | admin_priority | 1.10 | | 14 | string | true | false | false | |
79 | bank_transactions | administrator | 1.0a100 | | 4 | username | false | false | false | the business_administrator who made this transaction |
1442 | ticket_actions | administrator | 1.44 | | 2 | username | true | false | false | |
1472 | ticket_assignments | administrator | 1.44 | | 3 | username | false | false | false | |
559 | private_ftp_servers | allow_anonymous | 1.0a113 | | 6 | boolean | false | false | false | enabled or disabled anonymous access to the server |
1221 | postgres_databases | allow_conn | 1.0a100 | | 6 | boolean | false | false | false | if true, this database is accepting connections |
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 |
493 | sendmail_servers | allow_plaintext_auth | 1.81.10 | | 7 | boolean | false | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
2393 | ip_reputation_sets | allow_subaccount_use | 1.65 | | 3 | boolean | false | false | false | allows subaccounts to use the set |
1174 | payment_types | allow_web | 1.0a100 | | 3 | boolean | false | false | true | indicates if payment is allowed via a web form |
836 | mysql_db_users | alter_priv | 1.0a100 | | 12 | boolean | false | false | false | the ALTER privilete |
871 | mysql_users | alter_priv | 1.0a100 | | 14 | boolean | false | false | false | the ALTER privilete to all databases |
842 | mysql_db_users | alter_routine_priv | 1.4 | | 18 | boolean | false | false | false | the Alter_routine_priv |
882 | mysql_users | alter_routine_priv | 1.4 | | 25 | boolean | false | false | false | |
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" |
86 | bank_transactions | amount | 1.0a100 | | 9 | decimal_2 | false | false | false | the amount (negative for withdrawal) |
1074 | credit_card_transactions | amount | 1.83.0 | | 7 | money | false | false | false | the amount of the transaction |
634 | ao_server_daemon_hosts | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the ao_server |
138 | backup_partitions | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that stores the backup data |
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 |
430 | email_domains | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that is hosting the email |
476 | email_pipes | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the program resides on |
511 | email_smtp_relays | ao_server | 1.0a100 | | 2 | fkey | true | false | false | the pkey of the server that the rule applies to |
199 | failover_mysql_replications | ao_server | 1.59 | | 1 | fkey | true | false | false | the ao_server the receives the replication |
1524 | httpd_servers | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that hosts the httpd |
2505 | httpd_shared_tomcats | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server on which this jvm resides |
1599 | httpd_sites | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the site is hosted on |
740 | linux_server_accounts | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server the username is on |
645 | linux_server_groups | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the ao_server the group is on |
850 | mysql_servers | ao_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
1232 | postgres_servers | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
487 | sendmail_servers | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server that runs this sendmail instance |
1198 | ssl_certificates | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server the SSL certificate is on |
542 | system_email_aliases | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the entry is on |
783 | master_processes | aoserv_protocol | 1.0a101 | | 7 | string | true | false | false | |
1306 | brands | aoweb_struts_google_analytics_new_tracking_code | 1.44 | | 34 | string | true | false | false | |
1304 | brands | aoweb_struts_google_verify_content | 1.44 | | 32 | 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 | |
1310 | brands | aoweb_struts_keystore_password | 1.53 | | 38 | string | false | false | false | |
1309 | brands | aoweb_struts_keystore_type | 1.53 | | 37 | string | false | false | false | |
1305 | brands | aoweb_struts_noindex | 1.44 | | 33 | boolean | false | false | false | |
1307 | brands | aoweb_struts_signup_admin_address | 1.44 | | 35 | string | false | false | false | |
1308 | brands | aoweb_struts_vnc_bind | 1.52 | | 36 | fkey | false | true | false | |
922 | net_binds | app_protocol | 1.0a100 | | 5 | string | false | false | false | the application protocol (<code>protocols</code>) |
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 |
341 | operating_system_versions | architecture | 1.0a108 | | 4 | string | false | false | true | the name of the architecture |
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 |
1578 | httpd_site_authenticated_locations | auth_name | 1.18 | | 4 | string | false | false | false | the prompt given to the user during authentication |
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 |
778 | master_processes | authenticated_user | 1.0a100 | | 2 | username | true | false | false | |
1153 | credit_card_transactions | authorization_approval_code | 1.29 | | 72 | string | true | false | false | the approval code |
1144 | credit_card_transactions | authorization_approval_result | 1.29 | | 63 | string | true | false | false | the provider-neutral approval result |
1152 | credit_card_transactions | authorization_avs_result | 1.29 | | 71 | string | true | false | false | the provider-neutral AVS result |
1133 | credit_card_transactions | authorization_communication_result | 1.29 | | 52 | string | true | false | false | the authorization communication result |
1150 | credit_card_transactions | authorization_cvv_result | 1.29 | | 69 | string | true | false | false | the provider-neutral CVV result |
1146 | credit_card_transactions | authorization_decline_reason | 1.29 | | 65 | string | true | false | false | the provider-neutral decline reason |
1135 | credit_card_transactions | authorization_error_code | 1.29 | | 54 | string | true | false | false | the provider-neutral error code |
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 |
1143 | credit_card_transactions | authorization_provider_approval_result | 1.29 | | 62 | string | true | false | false | the provider-specific approval result |
1151 | credit_card_transactions | authorization_provider_avs_result | 1.29 | | 70 | string | true | false | false | the provider-specific AVS result |
1149 | credit_card_transactions | authorization_provider_cvv_result | 1.29 | | 68 | string | true | false | false | the provider-specific CVV result |
1145 | credit_card_transactions | authorization_provider_decline_reason | 1.29 | | 64 | string | true | false | false | the provider-specific decline reason |
1134 | credit_card_transactions | authorization_provider_error_code | 1.29 | | 53 | string | true | false | false | the provider-specific error code |
1136 | credit_card_transactions | authorization_provider_error_message | 1.29 | | 55 | string | true | false | false | the provider-specific error message |
1147 | credit_card_transactions | authorization_provider_review_reason | 1.29 | | 66 | string | true | false | false | the provider-specific review reason |
1137 | credit_card_transactions | authorization_provider_unique_id | 1.29 | | 56 | string | true | false | false | the per-provider unique ID |
1148 | credit_card_transactions | authorization_review_reason | 1.29 | | 67 | string | true | false | false | the provider-neutral review reason |
1130 | credit_card_transactions | authorization_time | 1.29 | | 49 | time | false | false | false | the time the authorization was attempted |
1131 | credit_card_transactions | authorization_username | 1.29 | | 50 | username | false | false | false | the username of the business_administrator account that processed the transaction |
1140 | credit_card_transactions | authorizationResult.providerReplacementExpiration | 1.82.0 | | 59 | string | true | false | false | the provider-specific replacement expiration date |
1138 | credit_card_transactions | authorizationResult.providerReplacementMaskedCardNumber | 1.82.0 | | 57 | string | true | false | false | the provider-specific replacement masked card number |
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 |
1139 | credit_card_transactions | authorizationResult.replacementMaskedCardNumber | 1.82.0 | | 58 | string | true | false | false | the replacement masked card number |
2525 | httpd_shared_tomcats | auto_deploy | 1.80.1 | | 14 | boolean | false | false | false | the autoDeploy 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 |
27 | businesses | auto_enable | 1.0a100 | | 11 | boolean | false | false | false | allows the account to be automatically reenabled
on payment |
210 | Currency | autoEnableMinimumPayment | 1.83.0 | | 2 | money | false | false | true | the minimum payment for auto-enabling accounts |
751 | linux_server_accounts | autoresponder_from | 1.0a100 | | 5 | fkey | true | false | false | the pkey of the email address used for the autoresponder |
753 | linux_server_accounts | autoresponder_path | 1.0a100 | | 7 | string | true | false | false | the full path of the autoresponder text file |
752 | linux_server_accounts | autoresponder_subject | 1.0a100 | | 6 | string | true | false | false | the subject of autoresponder messages |
1621 | httpd_sites | awstats_skip_files | 1.0a129 | | 10 | string | true | false | false | the SkipFiles setting for AWStats |
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 |
1413 | signup_requests | ba_cell_phone | 1.69 | | 17 | string | true | false | false | the administrator's cell phone |
1422 | signup_requests | ba_city | 1.69 | | 23 | string | true | false | false | the city of the administrator |
1426 | signup_requests | ba_country | 1.69 | | 25 | string | true | false | false | the two-character country code of the administrator |
1418 | signup_requests | ba_email | 1.23 | | 20 | email | false | false | false | the administrator's email address |
1417 | signup_requests | ba_fax | 1.69 | | 19 | string | true | false | false | the administrator's fax number |
1415 | signup_requests | ba_home_phone | 1.69 | | 18 | string | true | false | false | the administrator's home phone |
1408 | signup_requests | ba_name | 1.23 | | 14 | string | false | false | false | the administrator's name |
1424 | signup_requests | ba_state | 1.69 | | 24 | string | true | false | false | the state or providence of the administrator |
1409 | signup_requests | ba_title | 1.23 | | 15 | string | true | false | false | the administrator's title |
1429 | signup_requests | ba_username | 1.23 | | 27 | username | false | false | false | the username of the administrator |
1411 | signup_requests | ba_work_phone | 1.69 | | 16 | string | false | false | false | the administrator's work phone |
1428 | signup_requests | ba_zip | 1.69 | | 26 | string | true | false | false | the zip code of the administrator |
194 | file_backup_settings | backup_enabled | 1.31 | | 3 | boolean | false | false | false | the enabled flag for this prefix |
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 |
500 | sendmail_servers | bad_rcpt_throttle | 1.81.10 | | 14 | int | true | false | false | the value for confBAD_RCPT_THROTTLE |
2358 | ip_reputation_set_hosts | bad_reputation | 1.65 | | 4 | short | false | false | false | the current bad repuation |
225 | NoticeLog.balance | balance | 1.83.0 | | 2 | money | false | false | false | the balance for a single currency |
64 | bank_accounts | bank | 1.0a100 | | 2 | string | false | false | false | the bank the account is with |
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 |
115 | business_profiles | billing_contact | 1.0a100 | | 15 | string | false | false | false | the name to contact for billing information |
229 | notice_log | billing_contact | 1.0a100 | | 3 | string | false | false | false | |
1430 | signup_requests | billing_contact | 1.23 | | 28 | string | false | false | false | the name of the billing contact |
116 | business_profiles | billing_email | 1.0a100 | | 16 | string | false | false | false | the email address to notify for billing |
230 | notice_log | billing_email | 1.0a100 | | 4 | email | false | false | false | |
1431 | signup_requests | billing_email | 1.23 | | 29 | email | false | false | false | the email address of the billing contact |
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 |
1432 | signup_requests | billing_use_monthly | 1.23 | | 30 | boolean | false | false | false | if true, the credit_card will be used every month automatically |
117 | business_profiles | billingEmailFormat | 1.81.20 | | 17 | string | false | false | false | the format for billing notification emails |
2539 | httpd_workers | bind | 1.81.18 | | 0 | fkey | false | true | false | the network binding reservation and details |
847 | mysql_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
1229 | postgres_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
35 | business_administrators | birthday | 1.69 | | 4 | date | true | false | false | the admins birthday |
333 | architectures | bits | 1.0a108 | | 1 | int | false | false | true | the number of bits used by the architecture |
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. |
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. |
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. |
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. |
1389 | signup_requests | brand | 1.44 | | 1 | accounting | false | false | false | the brand of the parent business for the new account |
1260 | ticket_brand_categories | brand | 1.44 | | 1 | accounting | false | false | false | |
1479 | tickets | brand | 1.46 | | 1 | accounting | false | false | false | |
943 | net_devices | broadcast | 1.0a112 | | 7 | ip_address | true | false | false | the broadcast IP |
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 |
1405 | signup_requests | business_country | 1.69 | | 12 | string | false | false | false | the two-character country code of the business |
1397 | signup_requests | business_fax | 1.69 | | 7 | phone | true | false | false | the fax number of the business |
1393 | signup_requests | business_name | 1.23 | | 5 | string | false | false | false | the name of the business |
1395 | signup_requests | business_phone | 1.69 | | 6 | phone | false | false | false | the phone number of the business |
1403 | signup_requests | business_state | 1.69 | | 11 | string | true | false | false | the state or providence of the business |
1407 | signup_requests | business_zip | 1.69 | | 13 | string | true | false | false | the zip code of the business |
161 | failover_file_log | bytes | 1.0a100 | | 6 | long | false | false | false | the number of bytes transferred |
804 | master_users | can_access_accounting | 1.0a100 | | 2 | boolean | false | false | false | if they can access accounting resources |
807 | master_users | can_access_admin_web | 1.0a100 | | 5 | boolean | false | false | false | if they can access administrative web pages |
805 | master_users | can_access_bank_accounting | 1.0a100 | | 3 | boolean | false | false | false | if they can access bank account info |
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 |
1527 | httpd_servers | can_add_sites | 1.0a100 | | 3 | boolean | false | false | false | indicated that more sites may be added to the 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 | |
14 | business_servers | can_control_virtual_server | 1.64 | | 11 | 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 | |
806 | master_users | can_invalidate_tables | 1.0a100 | | 4 | boolean | false | false | false | if they can invalidate master tables |
24 | businesses | can_see_prices | 1.0a103 | | 8 | boolean | false | false | false | if <code>false</code>, prices are filtered |
55 | business_administrators | can_switch_users | 1.0a118 | | 20 | boolean | false | false | false | allows this person to switch users to any subaccounts |
13 | business_servers | can_vnc_console | 1.51 | | 10 | boolean | false | false | false | |
19 | businesses | cancel_reason | 1.0a100 | | 4 | string | true | false | false | the reason the account was canceled |
18 | businesses | canceled | 1.0a100 | | 3 | time | true | false | false | the time the account was deactivated |
1157 | credit_card_transactions | capture_communication_result | 1.29 | | 76 | string | true | false | false | the capture communication result |
1159 | credit_card_transactions | capture_error_code | 1.29 | | 78 | string | true | false | false | the provider-neutral error 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 |
1158 | credit_card_transactions | capture_provider_error_code | 1.29 | | 77 | string | true | false | false | the provider-specific 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 |
1154 | credit_card_transactions | capture_time | 1.29 | | 73 | time | true | false | false | the time the capture was attempted |
1155 | credit_card_transactions | capture_username | 1.29 | | 74 | username | true | false | false | the username of the business_administrator account that processed the capture |
1020 | credit_cards | card_info | 1.0a100 | | 4 | string | false | false | false | the masked card number |
251 | package_definitions | category | 1.0a123 | | 2 | string | false | false | false | the package category |
1261 | ticket_brand_categories | category | 1.44 | | 2 | fkey | false | false | false | |
1486 | tickets | category | 1.44 | | 6 | fkey | true | false | false | |
1245 | postgres_users | catupd | 1.0a100 | | 4 | boolean | false | false | false | usecatupd flag |
41 | business_administrators | cell_phone | 1.0a100 | | 10 | phone | true | false | false | the cellular phone number |
1202 | ssl_certificates | cert_file | 1.81.10 | | 5 | path | false | false | false | the file holding the public key |
1204 | ssl_certificates | certbot_name | 1.81.10 | | 7 | string | true | false | false | the name of the certbot-managed Let's Encrypt certificate |
414 | cyrus_imapd_binds | certificate | 1.81.10 | | 3 | fkey | true | false | false | the certificate used by this bind |
419 | cyrus_imapd_servers | certificate | 1.81.10 | | 3 | fkey | false | false | false | the certificate used for this server |
1645 | httpd_site_binds | certificate | 1.81.10 | | 6 | fkey | true | false | false | the certificate used by this bind |
1203 | ssl_certificates | chain_file | 1.81.10 | | 6 | path | true | false | false | the file holding the CA chain |
1014 | country_codes | charge_com_name | 1.0a100 | | 3 | string | true | false | true | the Charge.Com specific name |
1013 | country_codes | charge_com_supported | 1.0a100 | | 2 | boolean | false | false | true | if the country is supported by Charge.Com |
2339 | IpAddressMonitoring | checkBlacklistsOverSmtp | 1.81.18 | | 3 | boolean | false | false | false | allows determining some types of blacklists over SMTP protocol |
85 | bank_transactions | checkNo | 1.81.18 | | 8 | string | true | false | false | the check number (if available) |
47 | business_administrators | city | 1.69 | | 15 | string | true | false | false | the city (if different than business) |
106 | business_profiles | city | 1.69 | | 9 | string | false | false | false | the city |
1040 | credit_cards | city | 1.69 | | 18 | string | false | false | false | the card holders city |
2361 | ip_reputation_limiter_limits | class | 1.66 | | 2 | string | false | false | false | the reputation class |
348 | technologies | class | 1.0a100 | | 2 | string | false | false | true | the name of the group this package belongs to |
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 |
2475 | httpd_tomcat_contexts | class_name | 1.0a100 | | 2 | string | true | false | false | the className attribute |
492 | sendmail_servers | client_certificate | 1.81.10 | | 6 | fkey | false | false | false | the certificate used for this client |
1497 | tickets | client_priority | 1.0a100 | | 13 | string | false | false | false | |
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 |
1011 | country_codes | code | 1.69 | | 0 | string | false | true | true | the two-character code for the country |
2537 | httpd_jk_codes | code | 1.0a100 | | 0 | string | false | true | true | the unique, two-character code |
1473 | languages | code | 1.44 | | 0 | string | false | true | true | the language code |
125 | us_states | code | 1.0a100 | | 0 | string | false | true | true | the two-character code for the state |
1344 | schema_foreign_keys | column | 1.81.18 | | 1 | fkey | false | false | true | the column that references another column |
127 | aosh_commands | command | 1.0a100 | | 0 | string | false | true | true | the unique command |
478 | email_pipes | command | 1.80.0 | | 2 | string | false | false | false | the complete command string to the email handling program |
790 | master_processes | command | 1.0a100 | | 14 | string | true | false | false | |
1520 | httpd_site_bind_headers | comment | 1.81.15 | | 10 | string | true | false | false | an optional comment describing the redirect |
1596 | RewriteRule | comment | 1.81.21 | | 6 | string | true | false | false | an optional comment describing the rule |
1318 | aoserv_protocols | comments | 1.0a101 | | 2 | string | false | false | true | any comments about this version |
1029 | credit_cards | company_name | 1.29 | | 10 | string | true | false | false | the company name |
1438 | signup_requests | completed_by | 1.23 | | 35 | username | true | false | false | the username of the person who completed this sign-up request |
1439 | signup_requests | completed_time | 1.23 | | 36 | time | true | false | false | the time this request was completed |
87 | bank_transactions | confirmed | 1.0a100 | | 10 | boolean | false | false | false | the confirmation status with bank |
179 | failover_file_replications | connect_address | 1.69 | | 6 | hostname | true | false | false | an address or hostname that overrides regular AOServ connections for failovers |
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 |
785 | master_processes | connect_time | 1.0a100 | | 9 | time | false | false | false | |
501 | sendmail_servers | connection_rate_throttle | 1.81.10 | | 15 | int | true | false | false | the value for confCONNECTION_RATE_THROTTLE |
777 | master_processes | connectorId | 1.83.0 | | 1 | Identifier | true | 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 | |
16 | businesses | contract_version | 1.0a100 | | 1 | string | true | false | false | the version number of the contract |
2476 | httpd_tomcat_contexts | cookies | 1.0a100 | | 3 | boolean | false | false | false | the cookies attribute |
1195 | ssl_certificate_other_uses | count | 1.81.16 | | 3 | int | false | false | false | the number of times this other resource uses the certificate |
2389 | ip_reputation_set_networks | counter | 1.65 | | 3 | int | false | false | false | the reputation counter |
51 | business_administrators | country | 1.69 | | 17 | string | true | false | false | the country (if different than business) |
110 | business_profiles | country | 1.69 | | 11 | string | false | false | false | the two-character country code |
1048 | credit_cards | country_code | 1.69 | | 21 | string | false | false | false | the two-character country code |
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 |
831 | mysql_db_users | create_priv | 1.0a100 | | 7 | boolean | false | false | false | the CREATE privilege |
862 | mysql_users | create_priv | 1.0a100 | | 5 | boolean | false | false | false | the CREATE privilege to all databases |
841 | mysql_db_users | create_routine_priv | 1.4 | | 17 | boolean | false | false | false | the Create_routine_priv |
881 | mysql_users | create_routine_priv | 1.4 | | 24 | boolean | false | false | false | |
227 | notice_log | create_time | 1.0a100 | | 1 | time | false | false | false | |
837 | mysql_db_users | create_tmp_table_priv | 1.0a111 | | 13 | boolean | false | false | false | the Create_tmp_table_priv |
874 | mysql_users | create_tmp_table_priv | 1.0a111 | | 17 | boolean | false | false | false | |
883 | mysql_users | create_user_priv | 1.4 | | 26 | boolean | false | false | false | |
839 | mysql_db_users | create_view_priv | 1.4 | | 15 | boolean | false | false | false | the Create_view_priv |
879 | mysql_users | create_view_priv | 1.4 | | 22 | boolean | false | false | false | |
1317 | aoserv_protocols | created | 1.0a101 | | 1 | date | false | false | true | the time the version was added |
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 |
1049 | credit_cards | created | 1.0a100 | | 22 | time | false | false | false | the time the card was added to the database |
1379 | cvs_repositories | created | 1.0a100 | | 5 | time | false | false | false | the time the repository was created |
515 | email_smtp_relays | created | 1.0a100 | | 5 | time | false | false | false | the time the entry was created |
989 | ip_addresses | created | 1.0a100 | | 6 | time | false | false | false | the time the IP address was 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 |
220 | monthly_charges | created | 1.0a100 | | 7 | time | false | false | false | the time this entry was created |
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 |
1050 | credit_cards | created_by | 1.0a100 | | 23 | username | false | false | false | the business_administrator who added the card to the database |
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 | |
1485 | tickets | created_by | 1.0a126 | | 5 | username | true | false | false | |
1242 | postgres_users | createdb | 1.0a100 | | 1 | boolean | false | false | false | usecreatedb flag |
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 |
1122 | credit_card_transactions | credit_card_city | 1.69 | | 44 | string | false | false | false | the city 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 |
1113 | credit_card_transactions | credit_card_company_name | 1.29 | | 36 | string | true | false | false | the company name for the credit card |
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 |
1103 | credit_card_transactions | credit_card_created_by | 1.29 | | 26 | username | false | false | false | the business administrator account that provided this credit card |
1118 | credit_card_transactions | credit_card_customer_tax_id | 1.29 | | 41 | string | true | false | false | the tax ID of the card holder |
1114 | credit_card_transactions | credit_card_email | 1.29 | | 37 | email | true | false | false | the email address 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 |
1111 | credit_card_transactions | credit_card_first_name | 1.29 | | 34 | string | false | false | false | the first name of the card holder |
1106 | credit_card_transactions | credit_card_group_name | 1.29 | | 29 | string | true | false | false | any application-specific grouping |
1112 | credit_card_transactions | credit_card_last_name | 1.29 | | 35 | string | false | false | false | the last name of the card holder |
1108 | credit_card_transactions | credit_card_masked_card_number | 1.29 | | 31 | string | false | false | false | the masked card number |
1115 | credit_card_transactions | credit_card_phone | 1.29 | | 38 | phone | true | false | false | the phone number 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 |
1104 | credit_card_transactions | credit_card_principal_name | 1.29 | | 27 | string | true | false | false | the application-provided principal who provided this credit card |
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 |
1124 | credit_card_transactions | credit_card_state | 1.69 | | 45 | string | true | false | false | the state/province/prefecture 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) |
309 | transactions | credit_card_transaction | 1.29 | | 12 | fkey | true | false | false | the credit card transaction for this transaction |
1117 | credit_card_transactions | creditCard.customerId | 1.82.1 | | 40 | string | true | false | false | the merchant-specific unique customer ID |
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 |
2477 | httpd_tomcat_contexts | cross_context | 1.0a100 | | 4 | boolean | false | false | false | the crossContext attribute |
1201 | ssl_certificates | csr_file | 1.81.10 | | 4 | path | true | false | false | the file holding the CSR |
208 | Currency | currencyCode | 1.83.0 | | 0 | string | false | true | true | the ISO 4217 currency code of this currency |
1034 | credit_cards | customer_tax_id | 1.29 | | 15 | string | true | false | false | the social security number of employer identification number |
1033 | credit_cards | customerId | 1.82.1 | | 14 | string | true | false | false | the merchant-specific unique customer ID |
412 | cyrus_imapd_binds | cyrus_imapd_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
679 | ao_servers | daemon_bind | 1.0a100 | | 2 | fkey | true | false | false | the network bind info for the AOServ Daemon |
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 |
698 | ao_servers | daemon_connect_bind | 1.0a119 | | 8 | fkey | true | false | false | the bind to connect to |
780 | master_processes | daemon_server | 1.0a100 | | 4 | fkey | true | false | false | |
690 | ao_servers | daemonDeviceId | 1.81.18 | | 7 | string | false | false | false | the device name the master connects to |
1218 | postgres_databases | datdba | 1.0a100 | | 3 | fkey | false | false | false | the datdba for the database |
148 | backup_reports | date | 1.0a101 | | 3 | date | false | false | false | the date the summary is for |
153 | backup_retentions | days | 1.0a100 | | 0 | short | false | true | true | the number of days to keep the backup data |
1055 | credit_cards | deactivate_reason | 1.0a100 | | 28 | string | true | false | false | the reason the card was deactivated |
1054 | credit_cards | deactivated_on | 1.0a100 | | 27 | time | true | false | false | the time the card was deactivated |
2486 | httpd_tomcat_contexts | debug | 1.0a100 | | 12 | int | false | false | false | the debug attribute |
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 |
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 |
496 | sendmail_servers | delay_la | 1.81.10 | | 10 | int | true | false | false | the value for confDELAY_LA |
421 | cyrus_imapd_servers | delete_duration | 1.81.10 | | 5 | float | true | false | false | the duration after which delayed delete folders are removed |
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" |
830 | mysql_db_users | delete_priv | 1.0a100 | | 6 | boolean | false | false | false | the DELETE privilege |
861 | mysql_users | delete_priv | 1.0a100 | | 4 | boolean | false | false | false | the DELETE privilege to all databases |
939 | net_devices | delete_route | 1.0a112 | | 4 | string | true | false | false | the default routing from the network scripts that should be removed |
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 |
133 | aosh_commands | description | 1.81.18 | | 4 | string | false | false | true | a short description of the command |
91 | bank_transaction_types | description | 1.0a100 | | 2 | string | false | false | false | a description of the type |
83 | bank_transactions | description | 1.0a100 | | 7 | string | false | false | false | a description of the transaction |
1184 | credit_card_processors | description | 1.29 | | 9 | string | true | false | false | an optional description of the processor |
1102 | credit_card_transactions | description | 1.29 | | 25 | string | true | false | false | the merchant-provided description of this transaction |
1057 | credit_cards | description | 1.0a100 | | 29 | string | true | false | false | any comment or description |
1790 | distro_file_types | description | 1.0a100 | | 1 | string | false | false | false | a description of the type of file |
393 | dns_tlds | description | 1.0a100 | | 1 | string | false | false | true | |
383 | dns_types | description | 1.0a100 | | 1 | string | false | false | true | the description of the type |
408 | email_attachment_types | description | 1.0a116 | | 1 | string | false | false | true | a brief description of the attachment type |
956 | firewalld_zones | description | 1.81.0 | | 4 | string | true | false | false | the optional description |
2472 | httpd_tomcat_parameters | description | 1.5 | | 5 | string | true | false | false | optional, human-readable description of this context initialization parameter |
2379 | ip_reputation_limiters | description | 1.66 | | 3 | string | true | false | false | an optional description of the limiter |
767 | linux_account_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
652 | linux_group_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
794 | master_server_stats | description | 1.0a100 | | 2 | string | false | false | false | |
216 | monthly_charges | description | 1.0a100 | | 4 | string | true | false | false | the description that is placed in the transaction |
937 | net_devices | description | 1.0a100 | | 3 | string | false | false | false | a description of the device |
236 | notice_types | description | 1.0a100 | | 1 | string | false | false | true | |
255 | package_definitions | description | 1.0a123 | | 6 | string | false | false | false | a description of the package definition |
1172 | payment_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type of payment |
1338 | schema_columns | description | 1.0a100 | | 10 | string | false | false | true | any description associated with the column |
1361 | schema_tables | description | 1.0a100 | | 6 | string | false | false | true | the description of the table |
578 | server_farms | description | 1.0a100 | | 1 | string | false | false | false | a description of the farm |
963 | servers | description | 1.0a100 | | 2 | string | false | false | false | a description of the servers purpose |
350 | technology_classes | description | 1.0a100 | | 1 | string | false | false | true | a description of the class |
301 | transactions | description | 1.0a100 | | 6 | string | false | false | false | description of the transaction |
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 |
435 | email_forwarding | destination | 1.0a100 | | 2 | email | false | false | false | the destination of the email |
544 | system_email_aliases | destination | 1.0a100 | | 3 | string | false | false | false | the destination, as found in /etc/aliases |
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 |
1009 | net_tcp_redirects | destination_port | 1.80.0 | | 4 | net_port | false | false | false | the remote port to connect to |
1465 | ticket_actions | details | 1.44 | | 21 | string | true | false | false | |
1491 | tickets | details | 1.44 | | 10 | string | true | false | false | |
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 |
586 | virtual_disks | device | 1.36 | | 2 | string | false | false | false | the per-virtual-server unique device, such as xvda or xvdb |
936 | net_devices | deviceId | 1.81.18 | | 2 | string | false | false | false | the name of the device |
380 | dns_records | dhcpAddress | 1.81.18 | | 10 | fkey | true | false | false | the id of the IP address whos changes are followed |
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 |
1382 | cvs_repositories | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that this repository is disabled |
451 | email_lists | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this list is disabled |
481 | email_pipes | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this email pipe is disabled |
519 | email_smtp_relays | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates that the rule is disabled |
2517 | httpd_shared_tomcats | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the JVM is disabled |
1649 | httpd_site_binds | disable_log | 1.0a100 | | 7 | fkey | true | false | false | indicates that this bind is disabled |
1619 | httpd_sites | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that the site is disabled |
736 | linux_accounts | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that this account is disabled |
755 | linux_server_accounts | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates the account is disabled |
894 | mysql_server_users | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this account is disabled |
886 | mysql_users | disable_log | 1.0a100 | | 29 | fkey | true | false | false | indicates that this account is disabled |
281 | packages | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the package is disabled |
1253 | postgres_server_users | disable_log | 1.0a100 | | 3 | fkey | true | false | false | indicates that this account is disabled |
1246 | postgres_users | disable_log | 1.0a100 | | 5 | fkey | true | false | false | indicates that this account is disabled |
124 | usernames | disable_log | 1.0a100 | | 2 | fkey | true | false | false | indicates that the username is disabled |
61 | disable_log | disable_reason | 1.0a100 | | 4 | string | true | false | false | the optional reason the accounts were disabled |
364 | technology_versions | disable_reason | 1.78 | | 7 | string | true | false | true | the reason this version is no longer supported |
363 | technology_versions | disable_time | 1.78 | | 6 | time | true | false | true | the time this version is no longer supported |
60 | disable_log | disabled_by | 1.0a100 | | 3 | username | false | false | false | the person who disabled the accounts |
152 | backup_reports | disk_size | 1.0a101 | | 5 | long | false | false | false | the total number of bytes of disk space used |
154 | backup_retentions | display | 1.0a100 | | 1 | string | false | false | true | the text displayed for this time increment |
63 | bank_accounts | display | 1.0a100 | | 1 | string | false | false | false | the display name of this account |
90 | bank_transaction_types | display | 1.0a100 | | 1 | string | false | false | false | the display value for the type |
70 | banks | display | 1.0a100 | | 1 | string | false | false | false | the name that is displayed |
1792 | distro_report_types | display | 1.70 | | 1 | string | false | false | false | a display value of the type of report |
535 | email_sa_integration_modes | display | 1.0a120 | | 1 | string | false | false | true | the display value for the mode |
343 | operating_system_versions | display | 1.0a108 | | 5 | string | false | true | true | the full display name for this version |
335 | operating_systems | display | 1.0a100 | | 1 | string | false | false | true | the display version of the name |
254 | package_definitions | display | 1.0a123 | | 5 | string | false | false | false | a short description for display use |
1358 | schema_tables | display | 1.0a100 | | 4 | string | false | false | true | the display name |
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 |
683 | ao_servers | distro_hour | 1.0a100 | | 4 | int | false | false | false | the hour the distribution will occur, in server time zone |
26 | businesses | do_not_disable_reason | 1.0a100 | | 10 | string | true | false | false | a reason why we should not disable the account |
2479 | httpd_tomcat_contexts | doc_base | 1.80.0 | | 5 | path | false | false | false | the docBase attribute |
369 | dns_records | domain | 1.69 | | 2 | string | false | false | false | the first column in the zone files |
392 | dns_tlds | domain | 1.69 | | 0 | domain_name | false | true | true | the domain |
403 | email_addresses | domain | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email 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 |
461 | majordomo_servers | domain | 1.0a100 | | 0 | fkey | false | true | false | the pkey of the domain that is hosted |
1191 | ssl_certificate_names | domain | 1.81.10 | | 4 | domain_name | false | false | false | the domain name |
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 |
528 | email_smtp_smart_host_domains | domain_out_rate | 1.57 | | 4 | float | true | false | false | the domain-specific email rate, null means unlimited |
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 |
832 | mysql_db_users | drop_priv | 1.0a100 | | 8 | boolean | false | false | false | the DROP privilege |
863 | mysql_users | drop_priv | 1.0a100 | | 6 | boolean | false | false | false | the DROP privilege to all databases |
1069 | credit_card_transactions | duplicate_window | 1.29 | | 5 | int | false | false | false | the number of seconds for duplicate transaction detection |
1084 | credit_card_transactions | dutyAmount | 1.83.0 | | 11 | money | true | false | false | the duty amount for this transaction |
779 | master_processes | effective_user | 1.0a100 | | 3 | username | true | false | false | |
43 | business_administrators | email | 1.0a100 | | 12 | email | false | false | false | the email address |
1030 | credit_cards | email | 1.29 | | 11 | email | true | false | false | the email address |
553 | private_ftp_servers | email | 1.0a100 | | 3 | email | false | false | false | the email address the server reports |
410 | blackhole_email_addresses | email_address | 1.0a100 | | 0 | fkey | false | true | false | the primary key of the email_address |
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 |
473 | email_pipe_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
437 | linux_acc_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | reference to pkey of email_addresses |
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 |
282 | packages | email_in_burst | 1.24 | | 7 | int | true | false | false | the maximum burst of inbound email before limiting begins |
283 | packages | email_in_rate | 1.24 | | 8 | float | true | false | false | the number of sustained inbound emails per second |
442 | email_list_addresses | email_list | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email list |
452 | majordomo_lists | email_list | 1.0a100 | | 0 | fkey | false | true | false | the email list that this majordomo_list represents |
284 | packages | email_out_burst | 1.24 | | 9 | int | true | false | false | the maximum burst of outbound email before limiting begins |
285 | packages | email_out_rate | 1.24 | | 10 | float | true | false | false | the number of sustained outbound emails per second |
474 | email_pipe_addresses | email_pipe | 1.0a100 | | 2 | fkey | false | false | false | the primary key of the email pipe |
538 | spam_email_messages | email_relay | 1.0a100 | | 1 | fkey | false | false | false | the relay that has been denied |
286 | packages | email_relay_burst | 1.24 | | 11 | int | true | false | false | the maximum burst of relay email before limiting begins |
287 | packages | email_relay_rate | 1.24 | | 12 | float | true | false | false | the number of sustained relay emails per second |
1628 | httpd_sites | enable_anonymous_ftp | 1.80.1 | | 17 | boolean | false | false | false | Enables the anonymous FTP area for this site. |
1623 | httpd_sites | enable_cgi | 1.80 | | 12 | boolean | false | false | false | CGI is 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) |
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 |
1224 | postgres_databases | enable_postgis | 1.27 | | 7 | boolean | false | false | false | indicates PostGIS is enabled on this database |
1624 | httpd_sites | enable_ssi | 1.80.1 | | 13 | boolean | false | false | false | Server-side includes are enabled on this website |
143 | backup_partitions | enabled | 1.0a100 | | 3 | boolean | false | false | false | flags the partition as currently accepting new data |
1182 | credit_card_processors | enabled | 1.29 | | 7 | boolean | false | false | false | the enabled flag |
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 | |
2337 | IpAddressMonitoring | enabled | 1.81.18 | | 1 | boolean | false | false | false | indicates that this IP address should be monitored |
1262 | ticket_brand_categories | enabled | 1.44 | | 3 | boolean | false | false | false | |
1219 | postgres_databases | encoding | 1.0a100 | | 4 | fkey | false | false | false | the pkey of the encoding system used for the database |
1226 | postgres_encodings | encoding | 1.0a100 | | 1 | string | false | false | true | the name of the encoding |
1058 | credit_cards | encrypted_card_number | 1.31 | | 30 | string | true | false | false | the card number stored encrypted |
1434 | signup_requests | encrypted_data | 1.23 | | 32 | string | false | false | false | the credit card details and password are stored encrypted |
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 |
1185 | credit_card_processors | encryption_from | 1.31 | | 10 | fkey | false | false | false | the from that will be used for encryption |
1435 | signup_requests | encryption_from | 1.31 | | 33 | fkey | false | false | false | the from that was used for encryption |
1186 | credit_card_processors | encryption_recipient | 1.31 | | 11 | fkey | false | false | false | the recipient that will be used for encryption |
1437 | signup_requests | encryption_recipient | 1.31 | | 34 | fkey | false | false | false | the recipient that was used for encryption |
158 | failover_file_log | end_time | 1.0a100 | | 3 | time | false | false | false | the time the replication finished |
1300 | brands | english_enabled | 1.44 | | 28 | boolean | false | false | false | |
331 | WhoisHistory | error | 1.81.19 | | 5 | string | false | false | false | the error from the whois lookup |
1644 | httpd_site_binds | error_log | 1.0a100 | | 5 | path | false | false | false | the file used for error logging |
844 | mysql_db_users | event_priv | 1.54 | | 20 | boolean | false | false | false | the Event_priv |
884 | mysql_users | event_priv | 1.54 | | 27 | boolean | false | false | false | the Event_priv |
843 | mysql_db_users | execute_priv | 1.4 | | 19 | boolean | false | false | false | the Execute_priv |
876 | mysql_users | execute_priv | 1.0a111 | | 19 | boolean | false | false | false | |
329 | WhoisHistory | exitStatus | 1.81.19 | | 3 | int | true | false | false | the exit status from the whois lookup, null on exception |
82 | bank_transactions | expenseCategory | 1.81.18 | | 6 | string | true | false | false | the category in which this expense belongs |
518 | email_smtp_relays | expiration | 1.0a100 | | 8 | time | true | false | false | the expiration time of the entry, or null if non-expiring |
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 |
423 | cyrus_imapd_servers | expire_duration | 1.81.10 | | 7 | float | false | false | false | prune the duplicate database of entries older than expire-duration |
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" |
425 | cyrus_imapd_servers | expunge_duration | 1.81.10 | | 9 | float | true | false | false | the duration after which delayed expunge messages are removed |
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" |
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 |
597 | virtual_disks | extents | 1.36 | | 5 | int | false | false | false | the total number of LVM extents for this device |
998 | ip_addresses | externalInetAddress | 1.81.18 | | 10 | ip_address | true | false | false | the external IP address, if different than ip_address |
957 | firewalld_zones | fail2ban | 1.81.9 | | 5 | boolean | false | false | false | enables Fail2ban on services in this 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 |
685 | ao_servers | failover_server | 1.0a100 | | 6 | fkey | true | false | false | the server that is currently running this server |
573 | racks | farm | 1.36 | | 1 | string | false | false | false | the server_farm housing the rack |
960 | servers | farm | 1.0a100 | | 1 | string | false | false | false | the name of the farm the server is located in |
42 | business_administrators | fax | 1.0a100 | | 11 | phone | true | false | false | the fax number (if different than business) |
102 | business_profiles | fax | 1.0a100 | | 6 | phone | true | false | false | the fax number |
1032 | credit_cards | fax | 1.29 | | 13 | phone | true | false | false | the fax number |
395 | dns_zones | file | 1.0a100 | | 1 | string | false | false | false | the filename of the zone file |
149 | backup_reports | file_count | 1.0a101 | | 4 | int | false | false | false | the number of files belong to this package on this server |
867 | mysql_users | file_priv | 1.0a100 | | 10 | boolean | false | false | false | the FILE privilege to all databases |
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 |
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 |
1027 | credit_cards | first_name | 1.29 | | 8 | string | false | false | false | the first name |
375 | dns_records | flag | 1.86.0 | | 7 | short | true | false | false | the CAA flag |
1595 | RewriteRule | flags | 1.81.21 | | 5 | string | true | false | false | the optional flags for the rule |
1346 | schema_foreign_keys | foreignColumn | 1.81.18 | | 2 | fkey | false | false | true | the referenced column |
209 | Currency | fractionDigits | 1.83.0 | | 1 | short | false | false | true | the number of fraction digits used with this currency |
1463 | ticket_actions | from_address | 1.44 | | 19 | email | true | false | false | |
1488 | tickets | from_address | 1.44 | | 8 | email | true | false | false | |
1238 | postgres_servers | fsync | 1.0a100 | | 7 | boolean | false | false | false | indicates that writes are synchronous |
940 | net_devices | gateway | 1.0a100 | | 5 | ip_address | true | false | false | the gateway IP address |
648 | linux_server_groups | gid | 1.80.0 | | 3 | linux_id | false | false | false | the gid on that machine |
714 | ao_servers | gidMax | 1.81.18 | | 21 | linux_id | false | false | false | the max value for automatic gid selection in groupadd |
712 | ao_servers | gidMin | 1.81.18 | | 19 | linux_id | false | false | false | the min value for automatic gid selection in groupadd |
2357 | ip_reputation_set_hosts | good_reputation | 1.65 | | 3 | short | false | false | false | the current good reputation |
833 | mysql_db_users | grant_priv | 1.0a100 | | 9 | boolean | false | false | false | the GRANT privilege |
868 | mysql_users | grant_priv | 1.0a100 | | 11 | boolean | false | false | false | the GRANT privilege to all databases |
657 | linux_group_accounts | group | 1.81.18 | | 1 | group_id | false | false | false | the linux group name |
1067 | credit_card_transactions | group_name | 1.29 | | 3 | string | true | false | false | the application-provided grouping for this transaction |
1018 | credit_cards | group_name | 1.29 | | 3 | string | true | false | false | any application-specific grouping |
1582 | httpd_site_authenticated_locations | handler | 1.81.13 | | 8 | string | true | false | false | the optional handler for this location |
243 | package_definition_limits | hard_limit | 1.0a123 | | 4 | int | true | false | false | the maximum number that may be allocated, NULL means unlimited |
388 | dns_types | has_flag | 1.86.0 | | 5 | boolean | false | false | true | flags which types have a flag |
387 | dns_types | has_port | 1.72 | | 4 | boolean | false | false | true | flags which types have a port |
385 | dns_types | has_priority | 1.72 | | 2 | boolean | false | false | true | flags which types have a priority |
389 | dns_types | has_tag | 1.86.0 | | 6 | boolean | false | false | true | flags which types have a tag |
386 | dns_types | has_weight | 1.72 | | 3 | boolean | false | false | true | flags which types have a weight |
1516 | httpd_site_bind_headers | header | 1.81.15 | | 6 | string | false | false | false | the header name, without any final colon |
744 | linux_server_accounts | home | 1.0a100 | | 4 | path | false | false | false | the home directory of the user on this machine |
356 | technology_names | home_page_url | 1.0a100 | | 5 | url | true | false | true | the URL of the technology home page |
40 | business_administrators | home_phone | 1.0a100 | | 9 | phone | true | false | false | the home phone number |
732 | linux_accounts | home_phone | 1.69 | | 4 | gecos | true | false | false | the home phone number of the user |
636 | ao_server_daemon_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address that is allowed to connect |
513 | email_smtp_relays | host | 1.69 | | 3 | hostname | false | false | false | the hostname or IP the rule applies to |
2356 | ip_reputation_set_hosts | host | 1.67 | | 2 | ip_address | false | false | false | the per-set unique IPv4 address |
798 | master_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address they are allowed to connect from |
781 | master_processes | host | 1.0a100 | | 5 | ip_address | false | false | false | |
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. |
2399 | ip_reputation_sets | host_decay_interval | 1.65 | | 9 | int | false | false | false | the number of seconds between each host decay |
398 | dns_zones | hostmaster | 1.0a100 | | 3 | string | false | false | false | the email address of the person in charge of the domain |
678 | ao_servers | hostname | 1.69 | | 1 | domain_name | false | true | false | the unique hostname of the server |
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 |
165 | failover_file_schedule | hour | 1.0a100 | | 2 | short | false | false | false | the hour of day (in server timezone) |
1641 | httpd_site_binds | httpd_bind | 1.0a100 | | 2 | fkey | false | false | false | the IP and port information for the binding |
1522 | httpd_binds | httpd_server | 1.0a100 | | 1 | fkey | false | false | false | the server that is listening on the address |
2529 | httpd_tomcat_shared_sites | httpd_shared_tomcat | 1.0a100 | | 1 | fkey | false | false | false | the shared JVM |
1575 | httpd_site_authenticated_locations | httpd_site | 1.18 | | 1 | fkey | false | false | false | the site that is being referenced |
1640 | httpd_site_binds | httpd_site | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
1633 | httpd_static_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that contains static content |
2530 | httpd_tomcat_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
1511 | httpd_site_bind_headers | httpd_site_bind | 1.81.15 | | 1 | fkey | false | false | false | the site bind that is being referenced |
1635 | httpd_site_urls | httpd_site_bind | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
2490 | httpd_tomcat_site_jk_mounts | httpd_tomcat_site | 1.81.6 | | 1 | fkey | false | false | false | the Tomcat site that is being mounted |
2451 | httpd_jboss_sites | hypersonic_bind | 1.0a100 | | 5 | fkey | false | false | false | reference to net_binds |
71 | bank_transactions | id | 1.81.18 | | 0 | pkey | false | true | false | a unique identifier for the transaction |
1207 | encryption_keys | id | 1.23 | | 2 | string | false | false | false | the id of the recipient who may decrypt the message |
1590 | RewriteRule | id | 1.81.21 | | 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 |
976 | ip_addresses | id | 1.81.18 | | 0 | pkey | false | true | false | a generated, unique key |
2336 | IpAddressMonitoring | id | 1.81.18 | | 0 | fkey | false | true | false | id of ip_addresses |
654 | linux_group_accounts | id | 1.81.18 | | 0 | pkey | false | true | false | a generated unique number |
775 | master_processes | id | 1.83.0 | | 0 | SmallIdentifier | false | true | false | |
911 | net_binds | id | 1.81.18 | | 0 | pkey | false | true | false | a generated pkey |
223 | NoticeLog.balance | id | 1.83.0 | | 0 | pkey | false | true | false | a generated primary key |
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 |
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 |
2378 | ip_reputation_limiters | identifier | 1.66 | | 2 | string | false | false | false | the per-net_device unique identifier |
2392 | ip_reputation_sets | identifier | 1.65 | | 2 | string | false | true | false | a globally unique identifier |
355 | technology_names | image_alt | 1.0a100 | | 4 | string | true | false | true | the alt attribute of the image |
352 | technology_names | image_filename | 1.0a100 | | 1 | string | true | false | true | the name of the file containing the image |
354 | technology_names | image_height | 1.0a100 | | 3 | int | true | false | true | the height of the image |
353 | technology_names | image_width | 1.0a100 | | 2 | int | true | false | true | the width of the image |
1276 | brands | imap_host | 1.46 | | 9 | hostname | true | false | false | |
1275 | brands | imap_linux_server_account | 1.44 | | 8 | fkey | false | true | false | |
1277 | brands | imap_password | 1.44 | | 10 | string | false | false | false | |
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 |
1330 | schema_columns | index | 1.81.18 | | 5 | short | false | false | true | the index of the column |
835 | mysql_db_users | index_priv | 1.0a100 | | 11 | boolean | false | false | false | the INDEX privilege |
870 | mysql_users | index_priv | 1.0a100 | | 13 | boolean | false | false | false | the INDEX privilege to all databases |
978 | ip_addresses | inetAddress | 1.81.18 | | 1 | ip_address | false | false | false | the IP address |
828 | mysql_db_users | insert_priv | 1.0a100 | | 4 | boolean | false | false | false | the INSERT privilege |
859 | mysql_users | insert_priv | 1.0a100 | | 2 | boolean | false | false | false | the INSERT privilege to all databases |
2535 | httpd_tomcat_versions | install_dir | 1.0a100 | | 1 | path | false | false | true | the directory the basic install files are located in |
1506 | tickets | internal_notes | 1.69 | | 19 | string | false | false | false | |
1100 | credit_card_transactions | invoice_number | 1.29 | | 23 | string | true | false | false | the merchant-provided invoice number |
1391 | signup_requests | ip_address | 1.23 | | 3 | ip_address | false | false | false | the IP address of the user who signed-up |
917 | net_binds | ipAddress | 1.81.18 | | 3 | fkey | false | false | false | the id of the IP address that is bound to |
803 | master_users | is_active | 1.0a100 | | 1 | boolean | false | false | false | this level of access may be disabled |
344 | operating_system_versions | is_aoserv_daemon_supported | 1.0a108 | | 6 | boolean | false | false | true | can AOServ Daemon be ran on this OS |
754 | linux_server_accounts | is_autoresponder_enabled | 1.0a100 | | 8 | boolean | false | false | false | flags if the autoresponder is enabled |
812 | master_users | is_cluster_admin | 1.73 | | 8 | boolean | false | false | false | if they can control cluster resources |
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 |
317 | transaction_types | is_credit | 1.0a123 | | 1 | boolean | false | false | true | indicates that this type of transaction represents payment or credit |
4 | business_servers | is_default | 1.0a100 | | 3 | boolean | false | false | false | if <code>true</code>, this is the default server. |
409 | email_attachment_types | is_default_block | 1.0a116 | | 2 | boolean | false | false | true | indicates that the type will be blocked by default |
809 | master_users | is_dns_admin | 1.0a100 | | 6 | boolean | false | false | false | if they can access all DNS stuff |
768 | linux_account_types | is_email | 1.0a100 | | 2 | boolean | false | false | true | can email be associated with this account |
719 | shells | is_login | 1.0a100 | | 1 | boolean | false | false | true | indicates if the shells gives process control |
931 | net_device_ids | is_loopback | 1.0a100 | | 1 | boolean | false | false | true | if the device is the loopback device |
2521 | httpd_shared_tomcats | is_manual | 1.0a100 | | 10 | boolean | false | false | false | the configuration files are manually maintained |
1651 | httpd_site_binds | is_manual | 1.0a100 | | 9 | boolean | false | false | false | the config file is manually maintained |
1620 | httpd_sites | is_manual | 1.0a100 | | 9 | boolean | false | false | false | configuration of this server is performed manually |
36 | business_administrators | is_preferred | 1.0a100 | | 5 | boolean | false | false | false | if true, customers is preferred |
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. |
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 |
811 | master_users | is_router | 1.65 | | 7 | boolean | false | false | false | if they read all router stuff |
784 | master_processes | is_secure | 1.0a100 | | 8 | boolean | false | false | false | |
1536 | httpd_servers | is_shared | 1.0a102 | | 9 | boolean | false | false | false | indicates that any user on the server may use this httpd instance |
162 | failover_file_log | is_successful | 1.0a100 | | 7 | boolean | false | false | false | keeps track of which passes completed successfully |
720 | shells | is_system | 1.0a100 | | 2 | boolean | false | false | true | indicates that this shell is for internal use only |
1220 | postgres_databases | is_template | 1.0a100 | | 5 | boolean | false | false | false | if true, this database is a template |
336 | operating_systems | is_unix | 1.0a100 | | 2 | boolean | false | false | true | indicates that this is a Unix-based OS |
905 | protocols | is_user_service | 1.0a105 | | 3 | boolean | false | false | true | indicates that a user may add and remove this service |
1190 | ssl_certificate_names | is_wildcard | 1.81.10 | | 3 | boolean | false | false | false | is a *.(domain) wildcard certificate |
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 |
995 | ip_addresses | isDhcp | 1.81.18 | | 9 | boolean | false | false | false | the IP address is obtained via DHCP |
93 | bank_transaction_types | isNegative | 1.81.18 | | 3 | boolean | false | false | false | if true the amount must be negative |
1333 | schema_columns | isNullable | 1.81.18 | | 7 | boolean | false | false | true | if the value may be null |
993 | ip_addresses | isOverflow | 1.81.18 | | 8 | boolean | false | false | false | indicates that the IP address is shared by different accounts |
662 | linux_group_accounts | isPrimary | 1.81.18 | | 3 | boolean | false | false | false | flag showing that this group is the user's primary group |
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 |
1335 | schema_columns | isUnique | 1.81.18 | | 8 | boolean | false | false | true | if true, the value is unique across rows |
1301 | brands | japanese_enabled | 1.44 | | 29 | boolean | false | false | false | |
700 | ao_servers | jilter_bind | 1.7 | | 10 | fkey | true | false | false | the bind that sendmail uses to connect to jilter |
2452 | httpd_jboss_sites | jmx_bind | 1.0a100 | | 6 | fkey | false | false | false | reference to net_binds |
2448 | httpd_jboss_sites | jnp_bind | 1.0a100 | | 2 | fkey | false | false | false | reference to net_binds |
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. |
1200 | ssl_certificates | key_file | 1.81.10 | | 3 | path | false | false | false | the file holding the private key |
1483 | tickets | language | 1.44 | | 4 | string | false | false | false | |
684 | ao_servers | last_distro_time | 1.0a100 | | 5 | time | true | false | false | the time the last distro check was started |
2400 | ip_reputation_sets | last_host_decay | 1.65 | | 10 | time | false | false | false | the time the hosts were last decayed |
1028 | credit_cards | last_name | 1.29 | | 9 | string | false | false | false | the last name |
2402 | ip_reputation_sets | last_network_decay | 1.65 | | 12 | time | false | false | false | the time the networks were last decayed |
516 | email_smtp_relays | last_refreshed | 1.0a100 | | 6 | time | false | false | false | the time the entry was last updated |
2403 | ip_reputation_sets | last_reputation_added | 1.67 | | 13 | time | false | false | false | the time reputation was last added |
716 | ao_servers | lastGid | 1.81.18 | | 23 | linux_id | true | false | false | the last value for automatic gid selection in groupadd, if any |
715 | ao_servers | lastUid | 1.81.18 | | 22 | linux_id | true | false | false | the last value for automatic uid selection in useradd, if any |
1320 | aoserv_protocols | lastUsed | 1.81.18 | | 3 | date | true | false | true | the date this protocol was last used |
129 | aosh_commands | lastVersion | 1.81.18 | | 2 | string | true | false | true | the last aoserv_protocol version having this command |
1328 | schema_columns | lastVersion | 1.81.18 | | 4 | string | true | false | true | the last version containing this field |
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 |
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 |
1373 | schema_types | lastVersion | 1.81.18 | | 3 | string | true | false | true | the last version containing this type |
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 |
1777 | distro_files | linux_account | 1.81.22 | | 6 | linux_username | false | false | false | the owner of the file |
1606 | httpd_sites | linux_account | 1.81.22 | | 5 | linux_username | false | false | false | the user the site "runs as" |
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 |
1376 | cvs_repositories | linux_server_account | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the directory owner |
405 | email_attachment_blocks | linux_server_account | 1.0a116 | | 1 | fkey | false | false | false | reference to the email inbox |
446 | email_lists | linux_server_account | 1.31 | | 2 | fkey | false | false | false | the linux_server_account that owns the list |
1530 | httpd_servers | linux_server_account | 1.0a102 | | 4 | fkey | false | false | false | the account to run as |
2507 | httpd_shared_tomcats | linux_server_account | 1.0a100 | | 4 | fkey | false | false | false | the account under which this tomcat runs |
439 | linux_acc_addresses | linux_server_account | 1.31 | | 2 | fkey | false | false | false | reference to linux_server_accounts |
462 | majordomo_servers | linux_server_account | 1.0a100 | | 1 | fkey | false | false | false | the pkey of linux_server_account to run as |
557 | private_ftp_servers | linux_server_account | 1.69 | | 5 | fkey | false | false | false | |
1377 | cvs_repositories | linux_server_group | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the directory group |
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 |
1531 | httpd_servers | linux_server_group | 1.0a102 | | 5 | fkey | false | false | false | the group to run as |
2508 | httpd_shared_tomcats | linux_server_group | 1.0a100 | | 5 | fkey | false | false | false | the group to which this tomcat is assigned |
463 | majordomo_servers | linux_server_group | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the linux_server_group to run as |
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. |
459 | majordomo_lists | listname_approval_add | 1.0a100 | | 7 | fkey | false | true | false | the person who retrieves approval notifications. Example: test-approval@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 |
458 | majordomo_lists | listname_owner_add | 1.0a100 | | 6 | fkey | false | true | false | the owner of the list. Example: test-owner@aoindustries.com |
455 | majordomo_lists | listname_pipe_add | 1.0a100 | | 3 | fkey | false | true | false | the pipe address the list responds to. Example: test@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 |
838 | mysql_db_users | lock_tables_priv | 1.0a111 | | 14 | boolean | false | false | false | the Lock_tables_priv |
875 | mysql_users | lock_tables_priv | 1.0a111 | | 18 | boolean | false | false | false | |
550 | private_ftp_servers | logfile | 1.0a100 | | 1 | path | false | false | false | the file transfers are logged to |
945 | net_devices | mac_address | 1.80.0 | | 8 | mac_address | true | true | false | the MAC address to be used on the device |
467 | majordomo_servers | majordomo_owner_add | 1.0a100 | | 6 | fkey | false | false | false | the email_address that owns this majordomo list |
465 | majordomo_servers | majordomo_pipe_address | 1.0a100 | | 4 | fkey | false | false | false | the email_address to use as the majordomo |
453 | majordomo_lists | majordomo_server | 1.0a100 | | 1 | fkey | false | false | false | the majordomo_server that this list is part of |
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 |
207 | failover_mysql_replications | max_alert_level | 1.74 | | 8 | string | false | false | false | the maximum alert level for all monitoring of this slave |
174 | failover_file_replications | max_bit_rate | 1.61 | | 3 | long | true | false | false | the maximum bit rate for files being replicated |
946 | net_devices | max_bit_rate | 1.2 | | 9 | long | true | false | false | the maximum bits per second for this network device |
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 |
1539 | httpd_servers | max_concurrency | 1.68 | | 12 | int | false | false | false | the maximum number of processes/threads for this server instance |
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 |
852 | mysql_servers | max_connections | 1.4 | | 4 | int | false | false | false | the maximum number of connections for the db |
1234 | postgres_servers | max_connections | 1.0a100 | | 4 | int | false | false | false | the maximum number of connections for the db |
499 | sendmail_servers | max_daemon_children | 1.81.10 | | 13 | int | true | false | false | the value for confMAX_DAEMON_CHILDREN |
2396 | ip_reputation_sets | max_definite_reputation | 1.65 | | 6 | short | false | false | false | the maximum reputation from definite sources |
2394 | ip_reputation_sets | max_hosts | 1.65 | | 4 | int | false | false | false | the maximum number of individual hosts tracked |
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 |
502 | sendmail_servers | max_message_size | 1.81.10 | | 16 | int | true | false | false | the value for confMAX_MESSAGE_SIZE |
2398 | ip_reputation_sets | max_network_reputation | 1.65 | | 8 | short | false | false | false | the maximum reputation for a network |
2523 | httpd_shared_tomcats | max_post_size | 1.80.1 | | 12 | int | true | false | false | the maxPostSize 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 |
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 |
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 |
494 | sendmail_servers | max_queue_children | 1.81.10 | | 8 | int | true | false | false | the value for confMAX_QUEUE_CHILDREN |
2395 | ip_reputation_sets | max_uncertain_reputation | 1.65 | | 5 | short | false | false | false | the maximum reputation from uncertain sources |
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 |
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 |
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 |
2522 | httpd_shared_tomcats | maxParameterCount | 1.92.0 | | 11 | int | true | false | false | the maxParameterCount setting for this Tomcat |
2497 | httpd_tomcat_std_sites | maxParameterCount | 1.92.0 | | 3 | int | true | false | false | the maxParameterCount setting for this Tomcat |
1099 | credit_card_transactions | merchant_email | 1.29 | | 22 | email | true | false | false | the email address of the merchant |
540 | spam_email_messages | message | 1.0a100 | | 3 | string | false | false | false | the message contents |
503 | sendmail_servers | min_free_blocks | 1.81.10 | | 17 | int | true | false | false | the value for confMIN_FREE_BLOCKS |
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 |
614 | virtual_servers | minimum_processor_architecture | 1.36 | | 6 | string | false | false | false | the minimum processor architecture, compatible architectures may be substituted |
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 |
611 | virtual_servers | minimum_processor_type | 1.41 | | 5 | string | true | false | false | the minimum processor type |
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> |
166 | failover_file_schedule | minute | 1.31 | | 3 | short | false | false | false | the minute (in server timezone) |
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 |
1532 | httpd_servers | mod_php_version | 1.0a102 | | 6 | fkey | true | false | false | the version of mod_php to run |
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 |
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) |
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 |
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 |
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 |
1543 | httpd_servers | monitoring_concurrency_critical | 1.81.11 | | 16 | int | true | false | false | the concurrency that will trigger a critical-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 |
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 |
928 | net_binds | monitoring_enabled | 1.0a104 | | 6 | boolean | false | false | false | turns on monitoring of the port |
951 | net_devices | monitoring_enabled | 1.70 | | 14 | boolean | false | false | false | indicates that this device should be monitored |
974 | servers | monitoring_enabled | 1.32 | | 6 | boolean | false | false | false | enables/disables monitoring |
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 |
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 |
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 |
929 | net_binds | monitoring_parameters | 1.58 | | 7 | string | true | false | false | the URL-encoded name=value pairs of monitoring parameters |
206 | failover_mysql_replications | monitoring_seconds_behind_critical | 1.56 | | 7 | int | true | false | false | the seconds behind where will trigger critical 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 |
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 |
261 | package_definitions | monthly_rate_transaction_type | 1.0a123 | | 10 | string | true | false | false | |
260 | package_definitions | monthlyRate | 1.83.0 | | 9 | money | true | false | false | the default monthly charge for this package |
2492 | httpd_tomcat_site_jk_mounts | mount | 1.81.6 | | 3 | boolean | false | false | false | true for JkMount, false for JkUnMount |
824 | mysql_db_users | mysql_database | 1.0a100 | | 1 | fkey | false | false | false | the pkey in mysql_databases |
202 | failover_mysql_replications | mysql_server | 1.28 | | 3 | fkey | false | false | false | the MySQL Server that is being replicated |
817 | mysql_databases | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
891 | mysql_server_users | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the MySQL server |
826 | mysql_db_users | mysql_server_user | 1.31 | | 2 | fkey | false | false | false | the pkey in mysql_server_users |
772 | aoserv_permissions | name | 1.21 | | 0 | string | false | true | true | the unique name of the permission |
332 | architectures | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the architecture |
62 | bank_accounts | name | 1.0a100 | | 0 | string | false | true | false | the unique name of this account |
89 | bank_transaction_types | name | 1.81.18 | | 0 | string | false | true | false | the name of the type |
69 | banks | name | 1.0a100 | | 0 | string | false | true | false | the unique name of the bank |
32 | business_administrators | name | 1.0a100 | | 2 | string | false | false | false | the name of this admin |
99 | business_profiles | name | 1.0a100 | | 3 | string | false | false | false | the name of the business |
1012 | country_codes | name | 1.0a100 | | 1 | string | false | false | true | the name of the country |
1791 | distro_report_types | name | 1.70 | | 0 | string | false | true | false | the unique name of the type |
520 | email_smtp_relay_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
534 | email_sa_integration_modes | name | 1.0a120 | | 0 | string | false | true | true | the unique name of the mode |
95 | expense_categories | name | 1.81.18 | | 0 | string | false | true | false | a simple code used as primary key |
954 | firewalld_zones | name | 1.81.0 | | 2 | firewalld_zone_name | false | false | false | the name of the Firewalld zone |
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 |
1642 | httpd_site_binds | name | 1.81.14 | | 3 | string | true | false | false | the name of the bind, null for the default bind |
1601 | httpd_sites | name | 1.81.18 | | 2 | string | false | false | false | the name of the site, as used in the /var/www directory. |
2458 | httpd_tomcat_data_sources | name | 1.5 | | 2 | string | false | false | false | the JNDI name |
2469 | httpd_tomcat_parameters | name | 1.5 | | 2 | string | false | false | false | the name of the context initialization parameter to be created |
2541 | httpd_workers | name | 1.81.18 | | 1 | string | false | false | false | the jk_code for the worker |
766 | linux_account_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
726 | linux_accounts | name | 1.80.1 | | 1 | gecos | true | false | false | the full name of the user |
651 | linux_group_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
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 |
454 | majordomo_lists | name | 1.0a100 | | 2 | string | false | false | false | the list name |
792 | master_server_stats | name | 1.0a100 | | 0 | string | false | true | false | |
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 |
930 | net_device_ids | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the device |
334 | operating_systems | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the operating system |
237 | package_categories | name | 1.0a123 | | 0 | string | false | true | true | the category name |
252 | package_definitions | name | 1.0a123 | | 3 | string | false | false | false | the name of the package |
266 | packages | name | 1.80.0 | | 1 | accounting | false | true | false | the unique name of this package entry |
1171 | payment_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
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 |
904 | protocols | name | 1.0a100 | | 2 | string | false | false | true | the name of the service |
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 |
1326 | schema_columns | name | 1.81.18 | | 2 | string | false | false | true | the name of the column |
1354 | schema_tables | name | 1.0a100 | | 1 | string | false | true | true | the unique name |
1368 | schema_types | name | 1.81.18 | | 1 | string | false | true | true | the unique name |
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 |
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 |
347 | technologies | name | 1.0a100 | | 1 | string | false | false | true | the name of the package |
349 | technology_classes | name | 1.0a100 | | 0 | string | false | true | true | the name of the class |
351 | technology_names | name | 1.0a100 | | 0 | string | false | true | true | the name of the package |
358 | technology_versions | name | 1.0a100 | | 1 | string | false | false | true | the name of the software package |
1313 | ticket_categories | name | 1.44 | | 2 | 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 |
126 | us_states | name | 1.0a100 | | 1 | string | false | false | true | the name of the state |
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 | |
411 | cyrus_imapd_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
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 |
1521 | httpd_binds | net_bind | 1.0a100 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
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 |
1003 | net_tcp_redirects | net_bind | 1.69 | | 0 | fkey | false | true | false | the pkey as found in net_binds |
548 | private_ftp_servers | net_bind | 1.0a113 | | 0 | fkey | false | true | false | the root directory |
482 | sendmail_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
2377 | ip_reputation_limiters | net_device | 1.66 | | 1 | fkey | false | false | false | the identifier of the net_device that is protected |
999 | ip_addresses | netmask | 1.38 | | 11 | string | false | false | false | the netmask of the local network |
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 |
942 | net_devices | network | 1.0a112 | | 6 | ip_address | true | false | false | the local network |
2401 | ip_reputation_sets | network_decay_interval | 1.65 | | 11 | int | false | false | false | the number of seconds between each network decay |
2397 | ip_reputation_sets | network_prefix | 1.65 | | 7 | short | false | false | false | the network size, for example 24 for a /24 (class C) |
1448 | ticket_actions | new_accounting | 1.69 | | 6 | accounting | true | false | false | |
1458 | ticket_actions | new_assigned_to | 1.80.0 | | 14 | username | true | false | false | |
1460 | ticket_actions | new_category | 1.44 | | 16 | fkey | true | false | false | |
1450 | ticket_actions | new_priority | 1.44 | | 8 | string | true | false | false | |
1454 | ticket_actions | new_status | 1.44 | | 12 | string | true | false | false | |
1452 | ticket_actions | new_type | 1.49 | | 10 | string | true | false | false | |
1462 | ticket_actions | new_value | 1.44 | | 18 | string | true | false | false | |
495 | sendmail_servers | nice_queue_run | 1.81.10 | | 9 | int | true | false | false | the value for confNICE_QUEUE_RUN |
232 | notice_log | notice_type | 1.0a100 | | 5 | string | false | false | false | |
224 | NoticeLog.balance | noticeLog | 1.83.0 | | 1 | fkey | false | false | false | the ID of the NoticeLog this balance is part of |
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 |
1446 | ticket_actions | old_accounting | 1.69 | | 5 | accounting | true | false | false | |
1456 | ticket_actions | old_assigned_to | 1.80.0 | | 13 | username | true | false | false | |
1459 | ticket_actions | old_category | 1.44 | | 15 | fkey | true | false | false | |
1449 | ticket_actions | old_priority | 1.44 | | 7 | string | true | false | false | |
1453 | ticket_actions | old_status | 1.44 | | 11 | string | true | false | false | |
1451 | ticket_actions | old_type | 1.49 | | 9 | string | true | false | false | |
1461 | ticket_actions | old_value | 1.44 | | 17 | string | true | false | false | |
1493 | tickets | open_date | 1.0a100 | | 12 | time | false | false | false | |
338 | operating_system_versions | operating_system | 1.0a100 | | 1 | string | false | false | true | the name of the OS |
1770 | distro_files | operating_system_version | 1.0a108 | | 1 | fkey | false | false | false | the OS version that contains the file |
968 | servers | operating_system_version | 1.31 | | 3 | fkey | true | false | false | the version of operating system running on the server, if known |
362 | technology_versions | operating_system_version | 1.0a108 | | 5 | fkey | true | false | true | the version of the OS that this packages is installed |
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 |
1773 | distro_files | optional | 1.0a100 | | 3 | boolean | false | false | false | if the file is optional |
1070 | credit_card_transactions | order_number | 1.29 | | 6 | string | true | false | false | the merchant-provided order number for this transaction |
330 | WhoisHistory | output | 1.81.19 | | 4 | string | false | false | false | the output from the whois lookup |
2480 | httpd_tomcat_contexts | override | 1.0a100 | | 6 | boolean | false | false | false | the override attribute |
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. |
582 | server_farms | owner | 1.0a102 | | 2 | fkey | false | false | false | the package that owns of the farm |
361 | technology_versions | owner | 1.0a100 | | 4 | username | false | false | false | the business_administrator who is responsible for maintaining this package |
457 | majordomo_lists | owner_listname_add | 1.0a100 | | 5 | fkey | false | true | false | the owner of the list. Example: owner-test@aoindustries.com |
466 | majordomo_servers | owner_majordomo_add | 1.0a100 | | 5 | fkey | false | false | false | the email_address that owns this majordomo list |
147 | backup_reports | package | 1.0a101 | | 2 | fkey | false | false | false | the pkey of the package the data is assigned to |
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 |
1534 | httpd_servers | package | 1.0a102 | | 8 | fkey | false | false | false | the package that owns the server |
1604 | httpd_sites | package | 1.80.0 | | 4 | accounting | false | false | false | the package that the site is part of |
987 | ip_addresses | package | 1.81.18 | | 5 | fkey | false | false | false | the package that the IP address is part of |
640 | linux_groups | package | 1.80.0 | | 1 | accounting | false | false | false | the package of the group |
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 |
489 | sendmail_servers | package | 1.81.10 | | 3 | fkey | false | false | false | the package that owns the SSL certificate |
972 | servers | package | 1.31 | | 4 | fkey | false | false | false | the package accountable for resources used by the server |
1199 | ssl_certificates | package | 1.81.10 | | 2 | fkey | false | false | false | the package that owns the SSL certificate |
123 | usernames | package | 1.80.0 | | 1 | accounting | false | false | false | the package name that this user 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 |
1392 | signup_requests | package_definition | 1.23 | | 4 | fkey | false | false | false | the pkey of the Package Definition requested |
2373 | ip_reputation_limiter_limits | packet_burst | 1.66 | | 14 | 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 | |
2371 | ip_reputation_limiter_limits | packet_per_ip_unit | 1.66 | | 12 | string | false | false | false | |
2374 | ip_reputation_limiter_limits | packet_rate | 1.66 | | 15 | short | false | false | false | |
2375 | ip_reputation_limiter_limits | packet_unit | 1.66 | | 16 | string | false | false | false | |
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 |
390 | dns_types | param_ip | 1.0a100 | | 7 | boolean | false | false | true | flags if the parameter is a IP or a hostname |
20 | businesses | parent | 1.0a100 | | 5 | accounting | true | false | false | the parent business to this one |
1312 | ticket_categories | parent | 1.44 | | 1 | fkey | true | false | false | |
31 | business_administrators | password | 1.69 | | 1 | hashed_password | true | false | false | the encrypted password for this admin |
2462 | httpd_tomcat_data_sources | password | 1.5 | | 6 | string | false | false | false | database password to be passed to our JDBC driver |
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 |
191 | file_backup_settings | path | 1.0a100 | | 2 | string | false | false | false | the path to control |
1576 | httpd_site_authenticated_locations | path | 1.18 | | 2 | string | false | false | false | the path to protect, unique per httpd_site |
2481 | httpd_tomcat_contexts | path | 1.0a100 | | 7 | string | false | false | false | the path attribute |
2491 | httpd_tomcat_site_jk_mounts | path | 1.81.6 | | 2 | string | false | false | false | the per-site unique pattern matched |
718 | shells | path | 1.0a100 | | 0 | path | false | true | true | the complete path to the executable |
1593 | RewriteRule | pattern | 1.81.21 | | 3 | string | false | false | false | the per-VirtualHost pattern matched |
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 |
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 |
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 |
771 | business_administrator_permissions | permission | 1.21 | | 2 | string | false | false | false | the name of the permission that has been granted |
101 | business_profiles | phone | 1.0a100 | | 5 | phone | false | false | false | the phone number |
1031 | credit_cards | phone | 1.29 | | 12 | phone | true | false | false | the daytime phone number |
1622 | httpd_sites | php_version | 1.78 | | 11 | fkey | true | false | false | the active version of PHP, if any |
2338 | IpAddressMonitoring | pingMonitorEnabled | 1.81.18 | | 2 | boolean | false | false | false | if ping (ICMP ECHO) is available for monitoring, defaults to true |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | |
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 |
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 | |
584 | virtual_disks | pkey | 1.36 | | 0 | pkey | false | true | false | a generated unique ID |
682 | ao_servers | pool_size | 1.0a100 | | 3 | int | false | false | false | the recommended connection pool size for the AOServ Master |
374 | dns_records | port | 1.72 | | 6 | int | true | false | false | the TCP or UDP port on which the service is to be found |
920 | net_binds | port | 1.80.0 | | 4 | net_port | false | false | false | the port that is bound |
903 | protocols | port | 1.80.0 | | 1 | net_port | false | false | true | the default port of the protocol |
1046 | credit_cards | postal_code | 1.69 | | 20 | string | true | false | false | the card holders postal code |
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 |
1217 | postgres_databases | postgres_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
1251 | postgres_server_users | postgres_server | 1.69 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
1227 | postgres_encodings | postgres_version | 1.0a100 | | 2 | fkey | false | false | true | the version of PostgreSQL |
1650 | httpd_site_binds | predisable_config | 1.0a100 | | 8 | string | true | false | false | the config file before the site was disabled |
756 | linux_server_accounts | predisable_password | 1.0a100 | | 10 | string | true | false | false | stores the password that was used before the account was disabled |
895 | mysql_server_users | predisable_password | 1.0a100 | | 5 | string | true | false | false | the password used before the account was disabled |
1254 | postgres_server_users | predisable_password | 1.0a100 | | 4 | string | true | false | false | the password that was on the account before it was disabled |
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 |
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 |
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 |
98 | business_profiles | priority | 1.0a100 | | 2 | int | false | false | false | the highest priority profile is used |
372 | dns_records | priority | 1.72 | | 4 | int | true | false | false | the priority for the entry |
788 | master_processes | priority | 1.0a100 | | 12 | int | false | false | false | |
1474 | ticket_priorities | priority | 1.0a100 | | 0 | string | false | true | true | |
37 | business_administrators | private | 1.0a100 | | 6 | boolean | false | false | false | indicates if the admin should not be listed in publicly available lists |
100 | business_profiles | private | 1.0a100 | | 4 | boolean | false | false | false | indicates if the business should not be listed
in publicly available lists |
2482 | httpd_tomcat_contexts | privileged | 1.0a100 | | 8 | boolean | false | false | false | the privileged attribute |
866 | mysql_users | process_priv | 1.0a100 | | 9 | boolean | false | false | false | the PROCESS privilege to all databases |
78 | bank_transactions | processor | 1.29 | | 3 | string | true | false | false | the credit card processor used by this transaction |
308 | transactions | processor | 1.29 | | 11 | string | true | false | false | the credit card processor that handled the payment |
566 | physical_servers | processor_cores | 1.36 | | 6 | int | true | false | false | the total number of processor cores, hyperthreads are counted as different cores |
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 |
1065 | credit_card_transactions | processor_id | 1.29 | | 1 | string | false | false | false | the name of the processor used for this 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 |
565 | physical_servers | processor_speed | 1.36 | | 5 | int | true | false | false | the processor speed in MHz |
564 | physical_servers | processor_type | 1.36 | | 4 | string | true | false | false | the processor type |
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 |
2493 | httpd_jk_protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the protocol used, as found in protocols.protocol |
782 | master_processes | protocol | 1.0a100 | | 6 | string | false | false | false | |
900 | protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the unique name of the protocol |
1175 | credit_card_processors | provider_id | 1.29 | | 0 | string | false | true | false | the unique ID of this processor |
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 |
1101 | credit_card_transactions | purchase_order_number | 1.29 | | 24 | string | true | false | false | the merchant-provided purchase order number |
522 | email_smtp_relay_types | qmail_config | 1.0a100 | | 2 | string | false | false | true | the config value used for qmail |
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 |
497 | sendmail_servers | queue_la | 1.81.10 | | 11 | int | true | false | false | the value for confQUEUE_LA |
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 |
561 | physical_servers | rack | 1.36 | | 1 | fkey | true | false | false | the rack that houses this server |
562 | physical_servers | rack_units | 1.36 | | 2 | short | true | false | false | the number of rack units |
563 | physical_servers | ram | 1.36 | | 3 | int | true | false | false | the total number of megabytes of RAM in this server |
219 | monthly_charges | rate | 1.83.0 | | 6 | money | false | false | false | the rate |
304 | transactions | rate | 1.83.0 | | 8 | money | false | false | false | the amount per unit of quantity |
1466 | ticket_actions | raw_email | 1.44 | | 22 | string | true | false | false | |
1492 | tickets | raw_email | 1.44 | | 11 | string | true | false | false | |
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 |
834 | mysql_db_users | references_priv | 1.0a100 | | 10 | boolean | false | false | false | the REFERENCES privilege |
869 | mysql_users | references_priv | 1.0a100 | | 12 | boolean | false | false | false | the REFERENCES privilege to all databases |
517 | email_smtp_relays | refresh_count | 1.0a100 | | 7 | int | false | false | false | the number of times the entry has been updated |
498 | sendmail_servers | refuse_la | 1.81.10 | | 12 | int | true | false | false | the value for confREFUSE_LA |
327 | WhoisHistory | registrableDomain | 1.81.19 | | 1 | domain_name | false | false | false | the registrable domain that was queried |
864 | mysql_users | reload_priv | 1.0a100 | | 7 | boolean | false | false | false | the RELOAD privilege to all databases |
2483 | httpd_tomcat_contexts | reloadable | 1.0a100 | | 9 | boolean | false | false | false | the reloadable attribute |
878 | mysql_users | repl_client_priv | 1.0a111 | | 21 | boolean | false | false | false | |
877 | mysql_users | repl_slave_priv | 1.0a111 | | 20 | boolean | false | false | false | |
1518 | httpd_site_bind_headers | replacement | 1.81.15 | | 8 | string | true | false | false | the replacement value, only used for "edit" and "edit*" |
156 | failover_file_log | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that was performed |
164 | failover_file_schedule | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that will be started |
201 | failover_mysql_replications | replication | 1.59 | | 2 | fkey | true | false | false | the failover server that receives the replication |
190 | file_backup_settings | replication | 1.31 | | 1 | fkey | false | false | false | the pkey of the failover_file_replication configured |
1384 | signup_request_options | request | 1.23 | | 1 | fkey | false | false | false | the id of the request this option is part of |
1581 | httpd_site_authenticated_locations | require | 1.18 | | 7 | string | false | false | false | the require directive parameter(s) for Apache |
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 |
631 | virtual_servers | requires_hvm | 1.37 | | 15 | boolean | false | false | false | indicates requires full hardware virtualization |
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 |
1471 | ticket_assignments | reseller | 1.44 | | 2 | accounting | false | false | false | |
1480 | tickets | reseller | 1.44 | | 2 | accounting | false | false | false | |
241 | package_definition_limits | resource | 1.0a123 | | 2 | string | false | false | false | the resource name |
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 |
177 | failover_file_replications | retention | 1.13 | | 5 | short | false | false | false | the number of days backups will be kept |
2450 | httpd_jboss_sites | rmi_bind | 1.0a100 | | 4 | fkey | false | false | false | reference to net_binds |
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 |
762 | linux_server_accounts | sa_integration_mode | 1.0a120 | | 15 | string | false | false | false | the integration mode for SpamAssassin |
763 | linux_server_accounts | sa_required_score | 1.0a124 | | 16 | float | false | false | false | the minimum SpamAssassin score considered Junk |
159 | failover_file_log | scanned | 1.0a100 | | 4 | int | false | false | false | the number of files scanned |
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 |
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 |
827 | mysql_db_users | select_priv | 1.0a100 | | 3 | boolean | false | false | false | the SELECT privilege |
858 | mysql_users | select_priv | 1.0a100 | | 1 | boolean | false | false | false | the SELECT privilege to all databases |
113 | business_profiles | send_invoice | 1.0a100 | | 13 | boolean | false | false | false | indicates to send a monthly invoice via regular mail |
521 | email_smtp_relay_types | sendmail_config | 1.0a100 | | 1 | string | false | false | true | the config value used for sendmail |
483 | sendmail_binds | sendmail_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
399 | dns_zones | serial | 1.0a100 | | 4 | long | false | false | false | the ever-incrementing serial number for the file |
665 | ao_servers | server | 1.0a100 | | 0 | fkey | false | true | false | a reference to servers |
146 | backup_reports | server | 1.0a101 | | 1 | fkey | false | false | false | the pkey of the server being backed-up |
3 | business_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the server |
170 | failover_file_replications | server | 1.31 | | 1 | fkey | false | false | false | the pkey of the server that the files are coming from |
953 | firewalld_zones | server | 1.81.0 | | 1 | fkey | false | false | false | the pkey of the server |
801 | master_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server they may control |
915 | net_binds | server | 1.33 | | 2 | fkey | false | false | false | the pkey of the server that this port is bound on |
934 | net_devices | server | 1.33 | | 1 | fkey | false | false | false | the pkey of the server that contains the device |
560 | physical_servers | server | 1.36 | | 0 | fkey | false | true | false | a reference to servers |
606 | virtual_servers | server | 1.36 | | 0 | fkey | false | true | false | the server that is virtualized |
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> |
491 | sendmail_servers | server_certificate | 1.81.10 | | 5 | fkey | false | false | false | the certificate used for this server |
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 |
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 |
484 | sendmail_binds | servername | 1.81.10 | | 2 | string | true | false | false | the Name for DaemonPortOptions for this bind |
2382 | ip_reputation_limiter_sets | set | 1.66 | | 2 | fkey | false | false | false | the identifier of the set |
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 |
258 | package_definitions | setup_fee_transaction_type | 1.0a123 | | 8 | string | true | false | false | |
257 | package_definitions | setupFee | 1.83.0 | | 7 | money | true | false | false | the setup fee for this package definition |
717 | ao_servers | sftp_umask | 1.81.5 | | 24 | octal_long | true | false | false | the optional umask for the sftp-server |
1237 | postgres_servers | shared_buffers | 1.0a100 | | 6 | int | false | false | false | the number of shared buffers |
734 | linux_accounts | shell | 1.0a100 | | 6 | path | false | false | false | the users shell preference |
1091 | credit_card_transactions | shipping_city | 1.69 | | 17 | string | true | false | false | the shipping city |
1087 | credit_card_transactions | shipping_company_name | 1.29 | | 14 | string | true | false | false | the shipping company name |
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 |
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 |
1095 | credit_card_transactions | shipping_postal_code | 1.69 | | 19 | string | true | false | false | the shipping postal code |
1093 | credit_card_transactions | shipping_state | 1.69 | | 18 | string | true | false | false | the shipping state |
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 |
1081 | credit_card_transactions | shippingAmount | 1.83.0 | | 10 | money | true | false | false | the shipping amount for this transaction |
955 | firewalld_zones | short | 1.81.0 | | 3 | string | true | false | false | the optional short name |
872 | mysql_users | show_db_priv | 1.0a111 | | 15 | boolean | false | false | false | |
840 | mysql_db_users | show_view_priv | 1.4 | | 16 | boolean | false | false | false | the Show_view_priv |
880 | mysql_users | show_view_priv | 1.4 | | 23 | boolean | false | false | false | |
865 | mysql_users | shutdown_priv | 1.0a100 | | 8 | boolean | false | false | false | the SHUTDOWN privilege to all databases |
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 |
1280 | brands | signup_email_address | 1.44 | | 13 | fkey | false | true | false | |
1281 | brands | signup_email_display | 1.44 | | 14 | string | false | true | 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 | |
128 | aosh_commands | sinceVersion | 1.81.18 | | 1 | string | false | false | true | the first aoserv_protocol version having this command |
1327 | schema_columns | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version this column was in |
1350 | schema_foreign_keys | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version to have this reference |
1356 | schema_tables | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version to have this table |
1371 | schema_types | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version this type was in |
1780 | distro_files | size | 1.0a100 | | 8 | long | true | false | false | the length of the file |
524 | email_smtp_smart_host_domains | smart_host | 1.57 | | 1 | fkey | false | false | false | the Smart Host that is being configured |
1273 | brands | smtp_host | 1.46 | | 6 | hostname | true | false | false | |
1272 | brands | smtp_linux_server_account | 1.44 | | 5 | fkey | false | true | false | |
1274 | brands | smtp_password | 1.44 | | 7 | string | false | false | false | |
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 |
1236 | postgres_servers | sort_mem | 1.0a100 | | 5 | int | false | false | false | the amount of shared memory used for sorting |
773 | aoserv_permissions | sort_order | 1.21 | | 1 | short | false | true | true | the sort order for the permission |
536 | email_sa_integration_modes | sort_order | 1.0a120 | | 2 | int | false | false | true | |
1512 | httpd_site_bind_headers | sort_order | 1.81.15 | | 2 | short | false | false | false | the per-bind unique sort ordering |
2383 | ip_reputation_limiter_sets | sort_order | 1.66 | | 3 | short | false | false | false | the per-limiter ordering |
345 | operating_system_versions | sort_order | 1.3 | | 7 | short | false | true | true | the default sort order |
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 |
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 | |
1592 | RewriteRule | sortOrder | 1.81.21 | | 2 | short | false | false | false | the per-VirtualHost unique sort ordering |
298 | transactions | source_accounting | 1.0a100 | | 3 | accounting | false | false | false | the source of the charge to this account |
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 |
157 | failover_file_log | start_time | 1.0a100 | | 2 | time | false | false | false | the time the replication started |
49 | business_administrators | state | 1.69 | | 16 | string | true | false | false | the state (if different than business) |
108 | business_profiles | state | 1.69 | | 10 | string | true | false | false | the state or providence |
1043 | credit_cards | state | 1.69 | | 19 | string | true | false | false | the card holders state |
789 | master_processes | state | 1.0a100 | | 13 | string | false | false | false | |
791 | master_processes | state_start_time | 1.0a100 | | 15 | time | false | false | false | |
1170 | credit_card_transactions | status | 1.29 | | 89 | string | false | false | false | the status of the transaction |
1475 | ticket_stati | status | 1.0a100 | | 0 | string | false | true | true | |
1501 | tickets | status | 1.0a100 | | 15 | string | false | false | false | |
1502 | tickets | status_timeout | 1.69 | | 16 | time | true | false | false | |
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 |
1594 | RewriteRule | substitution | 1.81.21 | | 4 | string | false | false | false | the rewrite substitution |
765 | linux_server_accounts | sudo | 1.80.1 | | 18 | string | true | false | false | the sudo setting or null when sudo not allowed |
1464 | ticket_actions | summary | 1.44 | | 20 | string | true | false | false | |
1489 | tickets | summary | 1.44 | | 9 | string | false | false | false | |
1244 | postgres_users | super | 1.0a100 | | 3 | boolean | false | false | false | usesuper flag |
873 | mysql_users | super_priv | 1.0a111 | | 16 | boolean | false | false | false | |
56 | business_administrators | support_code | 1.44 | | 21 | string | true | true | false | used to authenticate for email-based supprt |
1289 | brands | support_day_phone | 1.69 | | 20 | phone | true | false | false | |
1278 | brands | support_email_address | 1.44 | | 11 | fkey | false | true | false | |
1279 | brands | support_email_display | 1.44 | | 12 | string | false | true | 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 | |
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 | |
1287 | brands | support_toll_free | 1.69 | | 19 | phone | true | false | false | |
568 | physical_servers | supports_hvm | 1.37 | | 8 | boolean | true | false | false | indicates supports full hardware virtualization |
1788 | distro_files | symlink_target | 1.0a100 | | 13 | string | true | false | false | the target if is a symbolic link |
2366 | ip_reputation_limiter_limits | syn_burst | 1.66 | | 7 | short | false | false | false | |
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 | |
2364 | ip_reputation_limiter_limits | syn_per_ip_unit | 1.66 | | 5 | string | false | false | false | |
2367 | ip_reputation_limiter_limits | syn_rate | 1.66 | | 8 | short | false | false | false | |
2368 | ip_reputation_limiter_limits | syn_unit | 1.66 | | 9 | string | false | false | false | |
134 | aosh_commands | syntax | 1.0a100 | | 5 | string | false | false | true | the syntax of the 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 |
1324 | schema_columns | table | 1.81.18 | | 1 | string | false | false | true | the name of the table the column is in |
376 | dns_records | tag | 1.86.0 | | 8 | string | true | false | false | the CAA tag |
1078 | credit_card_transactions | tax_exempt | 1.29 | | 9 | boolean | false | false | false | the taxExempt flag for this transaction |
1077 | credit_card_transactions | taxAmount | 1.83.0 | | 8 | money | true | false | false | the tax amount of the transaction |
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 |
2455 | httpd_jboss_versions | template_dir | 1.0a100 | | 2 | string | false | false | true | directory containing the install template |
1068 | credit_card_transactions | test_mode | 1.29 | | 4 | boolean | false | false | false | indicates this is a test transaction |
1441 | ticket_actions | ticket | 1.44 | | 1 | fkey | false | false | false | |
1470 | ticket_assignments | ticket | 1.44 | | 1 | fkey | false | false | false | |
1315 | resellers | ticket_auto_escalate | 1.44 | | 1 | boolean | false | false | 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 | |
1487 | tickets | ticket_type | 1.0a100 | | 7 | string | false | false | false | |
72 | bank_transactions | time | 1.0a100 | | 1 | time | false | false | false | the time the transaction occured |
58 | disable_log | time | 1.0a100 | | 1 | time | false | false | false | the time the stuff was disabled |
1390 | signup_requests | time | 1.23 | | 2 | time | false | false | false | the time the request was added |
539 | spam_email_messages | time | 1.0a100 | | 2 | time | false | false | false | the time the message was added |
1443 | ticket_actions | time | 1.44 | | 3 | time | false | 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 |
699 | ao_servers | time_zone | 1.2 | | 9 | string | true | false | false | the time zone setting for the server |
1538 | httpd_servers | timeout | 1.0a130 | | 11 | int | false | false | false | the timeout setting in seconds |
33 | business_administrators | title | 1.0a100 | | 3 | string | true | false | false | the admins title within their organization |
2520 | httpd_shared_tomcats | tomcat4_shutdown_key | 1.0a100 | | 9 | string | true | false | false | the key used to shut down the JVM |
2496 | httpd_tomcat_std_sites | tomcat4_shutdown_key | 1.0a100 | | 2 | string | true | false | false | the key used to shut down the JVM |
2519 | httpd_shared_tomcats | tomcat4_shutdown_port | 1.0a100 | | 8 | fkey | true | true | false | the port that will shut down this JVM |
2495 | httpd_tomcat_std_sites | tomcat4_shutdown_port | 1.0a100 | | 1 | fkey | true | true | false | the port that will shut down this JVM |
2518 | httpd_shared_tomcats | tomcat4_worker | 1.0a100 | | 7 | fkey | true | true | false | the httpd_worker for Tomcat version 4 |
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 |
2446 | httpd_jboss_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
2474 | httpd_tomcat_contexts | tomcat_site | 1.0a100 | | 1 | fkey | false | false | false | the site this context is part of |
2528 | httpd_tomcat_shared_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
2494 | httpd_tomcat_std_sites | tomcat_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
2454 | httpd_jboss_versions | tomcat_version | 1.0a100 | | 1 | fkey | false | false | true | version of tomcat associated with this jboss version |
2527 | httpd_shared_tomcats | tomcatAuthentication | 1.83.2 | | 16 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
2502 | httpd_tomcat_std_sites | tomcatAuthentication | 1.83.2 | | 8 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
2544 | httpd_workers | tomcatSite | 1.81.18 | | 2 | fkey | true | false | false | the site that provides this worker (Tomcat 3 only) |
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 |
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 |
576 | racks | total_rack_units | 1.36 | | 4 | int | true | false | false | the number of rack units of physical space |
787 | master_processes | total_time | 1.0a100 | | 11 | interval | false | false | false | |
1243 | postgres_users | trace | 1.0a100 | | 2 | boolean | false | false | false | usetrace flag |
234 | notice_log | transid | 1.69 | | 6 | fkey | true | false | false | |
296 | transactions | transid | 1.69 | | 1 | pkey | false | true | false | the unique identifier for this transaction |
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. |
845 | mysql_db_users | trigger_priv | 1.54 | | 21 | boolean | false | false | false | the Trigger_priv |
885 | mysql_users | trigger_priv | 1.54 | | 28 | boolean | false | false | false | the Trigger_priv |
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 | |
80 | bank_transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
1789 | distro_file_types | type | 1.0a100 | | 0 | string | false | true | false | the unique name of the type |
1774 | distro_files | type | 1.0a100 | | 4 | string | false | false | false | the type of file |
370 | dns_records | type | 1.0a100 | | 3 | string | false | false | false | the type as found in dns_types |
382 | dns_types | type | 1.0a100 | | 0 | string | false | true | true | the type |
514 | email_smtp_relays | type | 1.0a100 | | 4 | string | false | false | false | the type of entry |
1513 | httpd_site_bind_headers | type | 1.81.15 | | 3 | string | false | false | false | the type of header, either "Header" or "RequestHeader" |
733 | linux_accounts | type | 1.0a100 | | 5 | string | false | false | false | the type of account |
641 | linux_groups | type | 1.0a100 | | 2 | string | false | false | false | the type of group |
215 | monthly_charges | type | 1.0a100 | | 3 | string | false | false | false | the type of charge, as found in transaction types |
235 | notice_types | type | 1.0a100 | | 0 | string | false | true | true | |
570 | processor_types | type | 1.36 | | 0 | string | false | true | true | the unique name of the type of processor |
1331 | schema_columns | type | 1.0a100 | | 6 | string | false | false | true | the type of data in the column |
1467 | ticket_action_types | type | 1.44 | | 0 | string | false | true | true | |
1507 | ticket_types | type | 1.0a100 | | 0 | string | false | true | true | |
300 | transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
743 | linux_server_accounts | uid | 1.80.0 | | 3 | linux_id | false | false | false | the uid of the user on the machine |
713 | ao_servers | uidMax | 1.81.18 | | 20 | linux_id | false | false | false | the max value for automatic uid selection in useradd |
710 | ao_servers | uidMin | 1.81.18 | | 18 | linux_id | false | false | false | the min value for automatic uid selection in useradd |
2526 | httpd_shared_tomcats | undeployOldVersions | 1.92.0 | | 15 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |
2501 | httpd_tomcat_std_sites | undeployOldVersions | 1.92.0 | | 7 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |
2524 | httpd_shared_tomcats | unpack_wars | 1.80.1 | | 13 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
2499 | httpd_tomcat_std_sites | unpack_wars | 1.80.1 | | 5 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
829 | mysql_db_users | update_priv | 1.0a100 | | 5 | boolean | false | false | false | the UPDATE privilege |
860 | mysql_users | update_priv | 1.0a100 | | 3 | boolean | false | false | false | the UPDATE privilege to all databases |
160 | failover_file_log | updated | 1.0a100 | | 5 | int | false | false | false | the number of files updated |
360 | technology_versions | updated | 1.0a100 | | 3 | time | false | false | true | the time this package was last updated |
569 | physical_servers | ups_type | 1.63 | | 9 | string | false | false | false | the type of UPS powering the server |
2460 | httpd_tomcat_data_sources | url | 1.5 | | 4 | string | false | false | false | connection URL to be passed to our JDBC driver |
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 |
786 | master_processes | use_count | 1.0a100 | | 10 | long | false | false | false | |
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 |
1537 | httpd_servers | use_mod_perl | 1.0a103 | | 10 | boolean | false | false | false | |
1052 | credit_cards | use_monthly | 1.0a100 | | 25 | boolean | false | false | false | if <code>true</code> the card will be used monthly |
2484 | httpd_tomcat_contexts | use_naming | 1.0a100 | | 10 | boolean | false | false | false | the useNaming attribute |
583 | server_farms | use_restricted_smtp_port | 1.26 | | 3 | boolean | false | false | false | outgoing servers should use restricted source ports (affects firewall rules) |
1533 | httpd_servers | use_suexec | 1.0a102 | | 7 | boolean | false | false | false | indicates that the suexec wrapper will be used for CGI |
660 | linux_group_accounts | user | 1.81.22 | | 2 | linux_username | false | false | false | the linux account that is an alternate member |
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 |
546 | ftp_guest_users | username | 1.81.22 | | 0 | linux_username | false | true | false | the username that is a guest user |
2461 | httpd_tomcat_data_sources | username | 1.5 | | 5 | string | false | false | false | database username to be passed to our JDBC driver |
723 | linux_accounts | username | 1.81.22 | | 0 | linux_username | false | true | false | the unique username |
739 | linux_server_accounts | username | 1.81.22 | | 1 | linux_username | false | false | false | the name of the user |
796 | master_hosts | username | 1.0a100 | | 1 | username | false | false | false | the unique username of the user |
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 |
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 |
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 |
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 |
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. |
1517 | httpd_site_bind_headers | value | 1.81.15 | | 7 | string | true | false | false | the header value, not used for all actions |
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() |
793 | master_server_stats | value | 1.0a100 | | 1 | string | true | false | false | |
1386 | signup_request_options | value | 1.23 | | 3 | string | true | false | false | the value of the option |
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 |
2341 | IpAddressMonitoring | verifyDnsA | 1.81.18 | | 5 | boolean | false | false | false | enables monitoring of forward DNS |
2340 | IpAddressMonitoring | verifyDnsPtr | 1.81.18 | | 4 | boolean | false | false | false | enables monitoring of reverse DNS |
1316 | aoserv_protocols | version | 1.0a101 | | 0 | string | false | true | true | the unique version number |
2447 | httpd_jboss_sites | version | 1.0a100 | | 1 | fkey | false | false | false | reference to httpd_jboss_versions |
2453 | httpd_jboss_versions | version | 1.0a100 | | 0 | pkey | false | true | true | jboss version designator |
2506 | httpd_shared_tomcats | version | 1.0a100 | | 3 | fkey | false | false | false | the tomcat version |
2531 | httpd_tomcat_sites | version | 1.0a100 | | 1 | fkey | false | false | false | the version of tomcat that is being ran |
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 |
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 |
851 | mysql_servers | version | 1.4 | | 3 | fkey | false | false | false | the pkey of the MySQL version |
253 | package_definitions | version | 1.0a123 | | 4 | string | false | false | false | the unique version of this package |
1233 | postgres_servers | version | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the PostgreSQL version |
1255 | postgres_versions | version | 1.0a100 | | 0 | fkey | false | true | true | a reference to the PostgreSQL details in the <code>technology_versions</code> table |
359 | technology_versions | version | 1.0a100 | | 2 | string | false | false | true | the version number of the package in #.##.##-## format |
340 | operating_system_versions | version_name | 1.0a100 | | 3 | string | false | false | true | the name of this OS release |
339 | operating_system_versions | version_number | 1.0a100 | | 2 | string | false | false | true | the number of OS version |
585 | virtual_disks | virtual_server | 1.36 | | 1 | fkey | false | false | false | the virtual server this disk belongs to |
1591 | RewriteRule | virtualHost | 1.81.21 | | 1 | fkey | false | false | false | the VirtualHost this rule is applied to |
1468 | ticket_action_types | visible_admin_only | 1.44 | | 1 | boolean | false | false | true | |
632 | virtual_servers | vnc_password | 1.51 | | 16 | string | false | true | false | the password for VNC console access or null to disable VNC access |
1165 | credit_card_transactions | void_communication_result | 1.29 | | 84 | string | true | false | false | the void communication result |
1167 | credit_card_transactions | void_error_code | 1.29 | | 86 | string | true | false | false | the provider-neutral error code |
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 |
1166 | credit_card_transactions | void_provider_error_code | 1.29 | | 85 | string | true | false | false | the provider-specific 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 |
1162 | credit_card_transactions | void_time | 1.29 | | 81 | time | true | false | false | the time the void was attempted |
1163 | credit_card_transactions | void_username | 1.29 | | 82 | username | true | false | false | the username of the business_administrator account that processed the void |
2449 | httpd_jboss_sites | webserver_bind | 1.0a100 | | 3 | fkey | false | false | false | reference to net_binds |
1183 | credit_card_processors | weight | 1.29 | | 8 | int | false | false | false | the weight used for multi-processor weighted transaction distribution |
373 | dns_records | weight | 1.72 | | 5 | int | true | false | false | the relative weight for records with the same priority |
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 |
1519 | httpd_site_bind_headers | when | 1.81.15 | | 9 | string | true | false | false | optional control over when is this header directive is applied |
319 | WhoisHistoryAccount | whoisHistory | 1.81.19 | | 1 | fkey | false | false | false | the id of the WhoisHistory |
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 |
2487 | httpd_tomcat_contexts | work_dir | 1.0a100 | | 13 | path | true | false | false | the workDir attribute |
39 | business_administrators | work_phone | 1.0a100 | | 8 | phone | false | false | false | the work phone number (if different than business) |
2485 | httpd_tomcat_contexts | wrapper_class | 1.0a100 | | 11 | string | true | false | false | the wrapperClass attribute |
53 | business_administrators | zip | 1.69 | | 18 | string | true | false | false | the zip code (if different than business) |
112 | business_profiles | zip | 1.69 | | 12 | string | true | false | false | the zip code |
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 |