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