Public Table: Schema Columns

id	table	name	sinceVersion	index	type	isNullable	isUnique	isPublic	description
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

TABLE NAME

DESCRIPTION

TABLE ROWS