Public Table: Schema Columns

id	table	name	sinceVersion	index	type	isNullable	isUnique	isPublic	description
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
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
393	dns_tlds	description	1.0a100	1	string	false	false	true
400	dns_zones	ttl	1.0a127	5	int	false	false	false
440	email_list_addresses	pkey	1.0a100	0	pkey	false	true	false
536	email_sa_integration_modes	sort_order	1.0a120	2	int	false	false	true
167	failover_file_schedule	enabled	1.0a100	4	boolean	false	false	false
1537	httpd_servers	use_mod_perl	1.0a103	10	boolean	false	false	false
2362	ip_reputation_limiter_limits	syn_per_ip_burst	1.66	3	short	false	false	false
2363	ip_reputation_limiter_limits	syn_per_ip_rate	1.66	4	short	false	false	false
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
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
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
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
235	notice_types	type	1.0a100	0	string	false	true	true
236	notice_types	description	1.0a100	1	string	false	false	true
246	package_definition_limits	additional_transaction_type	1.0a123	6	string	true	false	false
258	package_definitions	setup_fee_transaction_type	1.0a123	8	string	true	false	false
261	package_definitions	monthly_rate_transaction_type	1.0a123	10	string	true	false	false
271	packages	created	1.0a100	4	time	false	false	false
272	packages	created_by	1.0a100	5	username	false	false	false
557	private_ftp_servers	linux_server_account	1.69	5	fkey	false	false	false
1314	resellers	accounting	1.44	0	accounting	false	true	false
1315	resellers	ticket_auto_escalate	1.44	1	boolean	false	false	false
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
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
1625	httpd_sites	enable_htaccess	1.80.1	14	boolean	false	false	false	.htaccess files are enabled on this website
408	email_attachment_types	description	1.0a116	1	string	false	false	true	a brief description of the attachment type
350	technology_classes	description	1.0a100	1	string	false	false	true	a description of the class
937	net_devices	description	1.0a100	3	string	false	false	false	a description of the device
578	server_farms	description	1.0a100	1	string	false	false	false	a description of the farm
255	package_definitions	description	1.0a123	6	string	false	false	false	a description of the package definition
963	servers	description	1.0a100	2	string	false	false	false	a description of the servers purpose
83	bank_transactions	description	1.0a100	7	string	false	false	false	a description of the transaction
91	bank_transaction_types	description	1.0a100	2	string	false	false	false	a description of the type
767	linux_account_types	description	1.0a100	1	string	false	false	true	a description of the type
652	linux_group_types	description	1.0a100	1	string	false	false	true	a description of the type
1790	distro_file_types	description	1.0a100	1	string	false	false	false	a description of the type of file
1172	payment_types	description	1.0a100	1	string	false	false	true	a description of the type of payment
1792	distro_report_types	display	1.70	1	string	false	false	false	a display value of the type of report
991	ip_addresses	isAvailable	1.81.18	7	boolean	false	false	false	a flag if the IP address is available
1383	signup_request_options	pkey	1.23	0	pkey	false	true	false	a generate unique id
1387	signup_requests	pkey	1.23	0	pkey	false	true	false	a generate unique id
366	dns_records	pkey	1.0a100	0	pkey	false	true	false	a generated pkey
907	net_bind_firewalld_zones	pkey	1.81.0	0	pkey	false	true	false	a generated pkey
911	net_binds	id	1.81.18	0	pkey	false	true	false	a generated pkey
137	backup_partitions	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
145	backup_reports	pkey	1.0a101	0	pkey	false	true	false	a generated primary key
769	business_administrator_permissions	pkey	1.21	0	pkey	false	true	false	a generated primary key
1	business_servers	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1374	cvs_repositories	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
57	disable_log	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
475	email_pipes	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
188	file_backup_settings	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1574	httpd_site_authenticated_locations	pkey	1.18	0	pkey	false	true	false	a generated primary key
1510	httpd_site_bind_headers	pkey	1.81.15	0	pkey	false	true	false	a generated primary key
1590	RewriteRule	id	1.81.21	0	pkey	false	true	false	a generated primary key
1639	httpd_site_binds	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1634	httpd_site_urls	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1598	httpd_sites	id	1.81.18	0	pkey	false	true	false	a generated primary key
2489	httpd_tomcat_site_jk_mounts	pkey	1.81.6	0	pkey	false	true	false	a generated primary key
823	mysql_db_users	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
887	mysql_server_users	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
223	NoticeLog.balance	id	1.83.0	0	pkey	false	true	false	a generated primary key
1187	ssl_certificate_names	pkey	1.81.10	0	pkey	false	true	false	a generated primary key
1192	ssl_certificate_other_uses	pkey	1.81.16	0	pkey	false	true	false	a generated primary key
1197	ssl_certificates	pkey	1.81.10	0	pkey	false	true	false	a generated primary key
541	system_email_aliases	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
584	virtual_disks	pkey	1.36	0	pkey	false	true	false	a generated unique ID
1205	encryption_keys	pkey	1.23	0	pkey	false	true	false	a generated unique id
427	email_domains	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
508	email_smtp_relays	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
523	email_smtp_smart_host_domains	pkey	1.57	0	pkey	false	true	false	a generated unique key
2473	httpd_tomcat_contexts	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
2456	httpd_tomcat_data_sources	pkey	1.5	0	pkey	false	true	false	a generated unique key
2467	httpd_tomcat_parameters	pkey	1.5	0	pkey	false	true	false	a generated unique key
264	packages	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
1225	postgres_encodings	pkey	1.0a100	0	pkey	false	true	true	a generated unique key
537	spam_email_messages	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
357	technology_versions	pkey	1.0a100	0	pkey	false	true	true	a generated unique key
1523	httpd_servers	pkey	1.0a100	0	pkey	false	true	false	a generated unique number
654	linux_group_accounts	id	1.81.18	0	pkey	false	true	false	a generated unique number
486	sendmail_servers	id	1.81.18	0	pkey	false	true	false	a generated unique number
1322	schema_columns	id	1.81.18	0	pkey	false	true	true	a generated unique pkey
1342	schema_foreign_keys	id	1.81.18	0	pkey	false	true	true	a generated unique pkey
633	ao_server_daemon_hosts	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
952	firewalld_zones	pkey	1.81.0	0	pkey	false	true	false	a generated unique primary key
795	master_hosts	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
799	master_servers	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
337	operating_system_versions	pkey	1.0a100	0	pkey	false	true	true	a generated, unique ID
958	servers	pkey	1.0a100	0	pkey	false	true	false	a generated, unique ID
155	failover_file_log	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
168	failover_file_replications	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
163	failover_file_schedule	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
198	failover_mysql_replications	pkey	1.28	0	pkey	false	true	false	a generated, unique id
433	email_forwarding	pkey	1.0a100	0	pkey	false	true	false	a generated, unique key
472	email_pipe_addresses	pkey	1.0a100	0	pkey	false	true	false	a generated, unique key
976	ip_addresses	id	1.81.18	0	pkey	false	true	false	a generated, unique key
2359	ip_reputation_limiter_limits	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2380	ip_reputation_limiter_sets	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2376	ip_reputation_limiters	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2352	ip_reputation_set_hosts	pkey	1.65	0	long	false	true	false	a generated, unique key
2384	ip_reputation_set_networks	pkey	1.65	0	long	false	true	false	a generated, unique key
2390	ip_reputation_sets	pkey	1.65	0	pkey	false	true	false	a generated, unique key
443	email_lists	pkey	1.0a100	0	pkey	false	true	false	a generated, unique primary key
2392	ip_reputation_sets	identifier	1.65	2	string	false	true	false	a globally unique identifier
26	businesses	do_not_disable_reason	1.0a100	10	string	true	false	false	a reason why we should not disable the account
665	ao_servers	server	1.0a100	0	fkey	false	true	false	a reference to servers
560	physical_servers	server	1.36	0	fkey	false	true	false	a reference to servers
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
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
1255	postgres_versions	version	1.0a100	0	fkey	false	true	true	a reference to the PostgreSQL details in the <code>technology_versions</code> table
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
254	package_definitions	display	1.0a123	5	string	false	false	false	a short description for display use
133	aosh_commands	description	1.81.18	4	string	false	false	true	a short description of the command
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
95	expense_categories	name	1.81.18	0	string	false	true	false	a simple code used as primary key
1353	schema_tables	id	1.81.18	0	pkey	false	true	true	a unique ID for the table
71	bank_transactions	id	1.81.18	0	pkey	false	true	false	a unique identifier for the transaction
642	linux_server_groups	pkey	1.0a100	0	pkey	false	true	false	a unique key
96	business_profiles	pkey	1.0a100	0	pkey	false	true	false	a unique primary key
326	WhoisHistory	id	1.81.19	0	pkey	false	true	false	a unique, generated identifier
318	WhoisHistoryAccount	id	1.81.19	0	pkey	false	true	false	a unique, generated identifier
1247	postgres_server_users	pkey	1.0a100	0	pkey	false	true	false	a unique, generated number
211	monthly_charges	pkey	1.0a100	0	pkey	true	true	false	a unique, generated number for reference
932	net_devices	pkey	1.0a100	0	pkey	false	true	false	a unique, generated pkey
404	email_attachment_blocks	pkey	1.0a116	0	pkey	false	true	false	a unique, generated primary key
436	linux_acc_addresses	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
813	mysql_databases	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
1214	postgres_databases	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
402	email_addresses	address	1.0a100	1	string	false	false	false	address before the @
2339	IpAddressMonitoring	checkBlacklistsOverSmtp	1.81.18	3	boolean	false	false	false	allows determining some types of blacklists over SMTP protocol
262	package_definitions	active	1.0a123	11	boolean	false	false	false	allows new accounts for this package
415	cyrus_imapd_binds	allow_plaintext_auth	1.81.10	4	boolean	true	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
420	cyrus_imapd_servers	allow_plaintext_auth	1.81.10	4	boolean	false	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
493	sendmail_servers	allow_plaintext_auth	1.81.10	7	boolean	false	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
2393	ip_reputation_sets	allow_subaccount_use	1.65	3	boolean	false	false	false	allows subaccounts to use the set
27	businesses	auto_enable	1.0a100	11	boolean	false	false	false	allows the account to be automatically reenabled on payment
55	business_administrators	can_switch_users	1.0a118	20	boolean	false	false	false	allows this person to switch users to any subaccounts
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
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
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
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
1520	httpd_site_bind_headers	comment	1.81.15	10	string	true	false	false	an optional comment describing the redirect
1596	RewriteRule	comment	1.81.21	6	string	true	false	false	an optional comment describing the rule
2379	ip_reputation_limiters	description	1.66	3	string	true	false	false	an optional description of the limiter
1184	credit_card_processors	description	1.29	9	string	true	false	false	an optional description of the processor
1106	credit_card_transactions	credit_card_group_name	1.29	29	string	true	false	false	any application-specific grouping
1018	credit_cards	group_name	1.29	3	string	true	false	false	any application-specific grouping
1057	credit_cards	description	1.0a100	29	string	true	false	false	any comment or description
1318	aoserv_protocols	comments	1.0a101	2	string	false	false	true	any comments about this version
1129	credit_card_transactions	credit_card_comments	1.29	48	string	true	false	false	any comments associated with the credit card
1338	schema_columns	description	1.0a100	10	string	false	false	true	any description associated with the column
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.
344	operating_system_versions	is_aoserv_daemon_supported	1.0a108	6	boolean	false	false	true	can AOServ Daemon be ran on this OS
768	linux_account_types	is_email	1.0a100	2	boolean	false	false	true	can email be associated with this account
1623	httpd_sites	enable_cgi	1.80	12	boolean	false	false	false	CGI is enabled on this website
1620	httpd_sites	is_manual	1.0a100	9	boolean	false	false	false	configuration of this server is performed manually
2460	httpd_tomcat_data_sources	url	1.5	4	string	false	false	false	connection URL to be passed to our JDBC driver
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
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
2462	httpd_tomcat_data_sources	password	1.5	6	string	false	false	false	database password 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
301	transactions	description	1.0a100	6	string	false	false	false	description of the transaction
2455	httpd_jboss_versions	template_dir	1.0a100	2	string	false	false	true	directory containing the install template
1626	httpd_sites	enable_indexes	1.80.1	15	boolean	false	false	false	Directory indexes are enabled on this website
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
559	private_ftp_servers	allow_anonymous	1.0a113	6	boolean	false	false	false	enabled or disabled anonymous access to the server
957	firewalld_zones	fail2ban	1.81.9	5	boolean	false	false	false	enables Fail2ban on services in this zone
2341	IpAddressMonitoring	verifyDnsA	1.81.18	5	boolean	false	false	false	enables monitoring of forward DNS
2340	IpAddressMonitoring	verifyDnsPtr	1.81.18	4	boolean	false	false	false	enables monitoring of reverse DNS
1628	httpd_sites	enable_anonymous_ftp	1.80.1	17	boolean	false	false	false	Enables the anonymous FTP area for this site.
1632	httpd_sites	block_editor_backups	1.81.6	21	boolean	false	false	false	Enables the blocking filename patterns associated with editor automatic backups.
1631	httpd_sites	block_core_dumps	1.81.6	20	boolean	false	false	false	Enables the blocking of core dumps.
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.
974	servers	monitoring_enabled	1.32	6	boolean	false	false	false	enables/disables monitoring
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
662	linux_group_accounts	isPrimary	1.81.18	3	boolean	false	false	false	flag showing that this group is the user's primary group
754	linux_server_accounts	is_autoresponder_enabled	1.0a100	8	boolean	false	false	false	flags if the autoresponder is enabled
390	dns_types	param_ip	1.0a100	7	boolean	false	false	true	flags if the parameter is a IP or a hostname
222	monthly_charges	active	1.0a100	9	boolean	false	false	false	flags if this entry is active
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.
143	backup_partitions	enabled	1.0a100	3	boolean	false	false	false	flags the partition as currently accepting new data
388	dns_types	has_flag	1.86.0	5	boolean	false	false	true	flags which types have a flag
387	dns_types	has_port	1.72	4	boolean	false	false	true	flags which types have a port
385	dns_types	has_priority	1.72	2	boolean	false	false	true	flags which types have a priority
389	dns_types	has_tag	1.86.0	6	boolean	false	false	true	flags which types have a tag
386	dns_types	has_weight	1.72	3	boolean	false	false	true	flags which types have a weight
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
2336	IpAddressMonitoring	id	1.81.18	0	fkey	false	true	false	id of ip_addresses
24	businesses	can_see_prices	1.0a103	8	boolean	false	false	false	if <code>false</code>, prices are filtered
1053	credit_cards	active	1.0a100	26	boolean	false	false	false	if <code>true</code> the card is currently active
1052	credit_cards	use_monthly	1.0a100	25	boolean	false	false	false	if <code>true</code> the card will be used monthly
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
28	businesses	bill_parent	1.0a100	12	boolean	false	false	false	if <code>true</code>, the parent business will be charged for all resources used by this account
4	business_servers	is_default	1.0a100	3	boolean	false	false	false	if <code>true</code>, this is the default server.
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.
2338	IpAddressMonitoring	pingMonitorEnabled	1.81.18	2	boolean	false	false	false	if ping (ICMP ECHO) is available for monitoring, defaults to true
1013	country_codes	charge_com_supported	1.0a100	2	boolean	false	false	true	if the country is supported by Charge.Com
1360	schema_tables	isPublic	1.81.18	5	boolean	false	false	true	if the data contained in the table is accessible to everybody
931	net_device_ids	is_loopback	1.0a100	1	boolean	false	false	true	if the device is the loopback device
1773	distro_files	optional	1.0a100	3	boolean	false	false	false	if the file is optional
1337	schema_columns	isPublic	1.81.18	9	boolean	false	false	true	if the value is publicly accessible
1333	schema_columns	isNullable	1.81.18	7	boolean	false	false	true	if the value may be null
804	master_users	can_access_accounting	1.0a100	2	boolean	false	false	false	if they can access accounting resources
807	master_users	can_access_admin_web	1.0a100	5	boolean	false	false	false	if they can access administrative web pages
809	master_users	is_dns_admin	1.0a100	6	boolean	false	false	false	if they can access all DNS stuff
805	master_users	can_access_bank_accounting	1.0a100	3	boolean	false	false	false	if they can access bank account info
812	master_users	is_cluster_admin	1.73	8	boolean	false	false	false	if they can control cluster resources
806	master_users	can_invalidate_tables	1.0a100	4	boolean	false	false	false	if they can invalidate master tables
811	master_users	is_router	1.65	7	boolean	false	false	false	if they read all router stuff
93	bank_transaction_types	isNegative	1.81.18	3	boolean	false	false	false	if true the amount must be negative
36	business_administrators	is_preferred	1.0a100	5	boolean	false	false	false	if true, customers is preferred
1433	signup_requests	billing_pay_one_year	1.23	31	boolean	false	false	false	if true, one-year in advance will be charged to the credit_card and they will receive a credit for a free month
1432	signup_requests	billing_use_monthly	1.23	30	boolean	false	false	false	if true, the credit_card will be used every month automatically
1335	schema_columns	isUnique	1.81.18	8	boolean	false	false	true	if true, the value is unique across rows
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
1527	httpd_servers	can_add_sites	1.0a100	3	boolean	false	false	false	indicated that more sites may be added to the server
1174	payment_types	allow_web	1.0a100	3	boolean	false	false	true	indicates if payment is allowed via a web form
1173	payment_types	active	1.0a100	2	boolean	false	false	true	indicates if payment is currently accepted via this method
37	business_administrators	private	1.0a100	6	boolean	false	false	false	indicates if the admin should not be listed in publicly available lists
100	business_profiles	private	1.0a100	4	boolean	false	false	false	indicates if the business should not be listed in publicly available lists
719	shells	is_login	1.0a100	1	boolean	false	false	true	indicates if the shells gives process control
1224	postgres_databases	enable_postgis	1.27	7	boolean	false	false	false	indicates PostGIS is enabled on this database
631	virtual_servers	requires_hvm	1.37	15	boolean	false	false	false	indicates requires full hardware virtualization
568	physical_servers	supports_hvm	1.37	8	boolean	true	false	false	indicates supports full hardware virtualization
905	protocols	is_user_service	1.0a105	3	boolean	false	false	true	indicates that a user may add and remove this service
1536	httpd_servers	is_shared	1.0a102	9	boolean	false	false	false	indicates that any user on the server may use this httpd instance
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
993	ip_addresses	isOverflow	1.81.18	8	boolean	false	false	false	indicates that the IP address is shared by different accounts
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
2517	httpd_shared_tomcats	disable_log	1.0a100	6	fkey	true	false	false	indicates that the JVM is disabled
281	packages	disable_log	1.0a100	6	fkey	true	false	false	indicates that the package is disabled
519	email_smtp_relays	disable_log	1.0a100	9	fkey	true	false	false	indicates that the rule is disabled
1619	httpd_sites	disable_log	1.0a100	8	fkey	true	false	false	indicates that the site is disabled
1533	httpd_servers	use_suexec	1.0a102	7	boolean	false	false	false	indicates that the suexec wrapper will be used for CGI
409	email_attachment_types	is_default_block	1.0a116	2	boolean	false	false	true	indicates that the type will be blocked by default
124	usernames	disable_log	1.0a100	2	fkey	true	false	false	indicates that the username is disabled
54	business_administrators	disable_log	1.0a100	19	fkey	true	false	false	indicates that this account is disabled
736	linux_accounts	disable_log	1.0a100	8	fkey	true	false	false	indicates that this account is disabled
894	mysql_server_users	disable_log	1.0a100	4	fkey	true	false	false	indicates that this account is disabled
886	mysql_users	disable_log	1.0a100	29	fkey	true	false	false	indicates that this account is disabled
1253	postgres_server_users	disable_log	1.0a100	3	fkey	true	false	false	indicates that this account is disabled
1246	postgres_users	disable_log	1.0a100	5	fkey	true	false	false	indicates that this account is disabled
1649	httpd_site_binds	disable_log	1.0a100	7	fkey	true	false	false	indicates that this bind is disabled
951	net_devices	monitoring_enabled	1.70	14	boolean	false	false	false	indicates that this device should be monitored
481	email_pipes	disable_log	1.0a100	4	fkey	true	false	false	indicates that this email pipe is disabled
2337	IpAddressMonitoring	enabled	1.81.18	1	boolean	false	false	false	indicates that this IP address should be monitored
336	operating_systems	is_unix	1.0a100	2	boolean	false	false	true	indicates that this is a Unix-based OS
451	email_lists	disable_log	1.0a100	4	fkey	true	false	false	indicates that this list is disabled
1382	cvs_repositories	disable_log	1.0a100	6	fkey	true	false	false	indicates that this repository is disabled
720	shells	is_system	1.0a100	2	boolean	false	false	true	indicates that this shell is for internal use only
317	transaction_types	is_credit	1.0a123	1	boolean	false	false	true	indicates that this type of transaction represents payment or credit
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
1238	postgres_servers	fsync	1.0a100	7	boolean	false	false	false	indicates that writes are synchronous
755	linux_server_accounts	disable_log	1.0a100	9	fkey	true	false	false	indicates the account is disabled
25	businesses	disable_log	1.0a100	9	fkey	true	false	false	indicates the business is disabled
628	virtual_servers	primary_physical_server_locked	1.36	13	boolean	false	false	false	indicates the primary server is locked and should not be moved by automated means
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
1068	credit_card_transactions	test_mode	1.29	4	boolean	false	false	false	indicates this is a test transaction
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
113	business_profiles	send_invoice	1.0a100	13	boolean	false	false	false	indicates to send a monthly invoice via regular mail
1190	ssl_certificate_names	is_wildcard	1.81.10	3	boolean	false	false	false	is a *.(domain) wildcard certificate
2453	httpd_jboss_versions	version	1.0a100	0	pkey	false	true	true	jboss version designator
162	failover_file_log	is_successful	1.0a100	7	boolean	false	false	false	keeps track of which passes completed successfully
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
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
1519	httpd_site_bind_headers	when	1.81.15	9	string	true	false	false	optional control over when is this header directive is applied
2472	httpd_tomcat_parameters	description	1.5	5	string	true	false	false	optional, human-readable description of this context initialization parameter
583	server_farms	use_restricted_smtp_port	1.26	3	boolean	false	false	false	outgoing servers should use restricted source ports (affects firewall rules)
2503	httpd_shared_tomcats	pkey	1.0a100	0	pkey	false	true	false	pkey for this jvm
1015	credit_cards	pkey	1.0a100	0	pkey	false	true	false	primary key value
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
423	cyrus_imapd_servers	expire_duration	1.81.10	7	float	false	false	false	prune the duplicate database of entries older than expire-duration
2447	httpd_jboss_sites	version	1.0a100	1	fkey	false	false	false	reference to httpd_jboss_versions
439	linux_acc_addresses	linux_server_account	1.31	2	fkey	false	false	false	reference to linux_server_accounts
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
437	linux_acc_addresses	email_address	1.0a100	1	fkey	false	false	false	reference to pkey of email_addresses
405	email_attachment_blocks	linux_server_account	1.0a116	1	fkey	false	false	false	reference to the email inbox
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
1624	httpd_sites	enable_ssi	1.80.1	13	boolean	false	false	false	Server-side includes are enabled on this website
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.
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.
756	linux_server_accounts	predisable_password	1.0a100	10	string	true	false	false	stores the password that was used before the account was disabled
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)
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
950	net_devices	monitoring_bit_rate_critical	1.35	13	long	true	false	false	the 5-minute average that will trigger a critical-level alert
949	net_devices	monitoring_bit_rate_high	1.35	12	long	true	false	false	the 5-minute average that will trigger a high-level alert
947	net_devices	monitoring_bit_rate_low	1.35	10	long	true	false	false	the 5-minute average that will trigger a low-level alert
948	net_devices	monitoring_bit_rate_medium	1.35	11	long	true	false	false	the 5-minute average that will trigger a medium-level alert
708	ao_servers	monitoring_load_critical	1.35	17	float	true	false	false	the 5-minute load average that will trigger a critical-level alert
707	ao_servers	monitoring_load_high	1.35	16	float	true	false	false	the 5-minute load average that will trigger a high-level alert
705	ao_servers	monitoring_load_low	1.35	14	float	true	false	false	the 5-minute load average that will trigger a low-level alert
706	ao_servers	monitoring_load_medium	1.35	15	float	true	false	false	the 5-minute load average that will trigger a medium-level alert
212	monthly_charges	accounting	1.0a100	1	accounting	false	false	false	the account code that is charged to
76	bank_transactions	account	1.81.18	2	string	false	false	false	the account the transaction is for
1530	httpd_servers	linux_server_account	1.0a102	4	fkey	false	false	false	the account to run as
2507	httpd_shared_tomcats	linux_server_account	1.0a100	4	fkey	false	false	false	the account under which this tomcat runs
1017	credit_cards	accounting	1.0a100	2	accounting	false	false	false	the accounting code for the card
1066	credit_card_transactions	accounting	1.29	2	accounting	false	false	false	the accounting code for the source of this transaction
97	business_profiles	accounting	1.0a100	1	accounting	false	false	false	the accounting code of the business
2391	ip_reputation_sets	accounting	1.65	1	accounting	false	false	false	the accounting code of the business
1176	credit_card_processors	accounting	1.29	1	accounting	false	false	false	the accounting code of the business owning the merchant account
1206	encryption_keys	accounting	1.23	1	accounting	false	false	false	the accounting code of the business that owns this key
267	packages	accounting	1.0a100	2	accounting	false	false	false	the accounting code of the business that pays for this package
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
250	package_definitions	accounting	1.45	1	accounting	false	false	false	the accounting code of the seller/reseller that supports this package
1515	httpd_site_bind_headers	action	1.81.15	5	string	false	false	false	the action to be performed
1622	httpd_sites	php_version	1.78	11	fkey	true	false	false	the active version of PHP, if any
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
543	system_email_aliases	address	1.0a100	2	string	false	false	false	the address (username only) to match
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
1413	signup_requests	ba_cell_phone	1.69	17	string	true	false	false	the administrator's cell phone
1418	signup_requests	ba_email	1.23	20	email	false	false	false	the administrator's email address
1417	signup_requests	ba_fax	1.69	19	string	true	false	false	the administrator's fax number
1415	signup_requests	ba_home_phone	1.69	18	string	true	false	false	the administrator's home phone
1408	signup_requests	ba_name	1.23	14	string	false	false	false	the administrator's name
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
35	business_administrators	birthday	1.69	4	date	true	false	false	the admins birthday
33	business_administrators	title	1.0a100	3	string	true	false	false	the admins title within their organization
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
355	technology_names	image_alt	1.0a100	4	string	true	false	true	the alt attribute of the image
836	mysql_db_users	alter_priv	1.0a100	12	boolean	false	false	false	the ALTER privilete
871	mysql_users	alter_priv	1.0a100	14	boolean	false	false	false	the ALTER privilete to all databases
842	mysql_db_users	alter_routine_priv	1.4	18	boolean	false	false	false	the Alter_routine_priv
86	bank_transactions	amount	1.0a100	9	decimal_2	false	false	false	the amount (negative for withdrawal)
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
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
1236	postgres_servers	sort_mem	1.0a100	5	int	false	false	false	the amount of shared memory used for sorting
1074	credit_card_transactions	amount	1.83.0	7	money	false	false	false	the amount of the transaction
304	transactions	rate	1.83.0	8	money	false	false	false	the amount per unit of quantity
199	failover_mysql_replications	ao_server	1.59	1	fkey	true	false	false	the ao_server the receives the replication
922	net_binds	app_protocol	1.0a100	5	string	false	false	false	the application protocol (<code>protocols</code>)
1067	credit_card_transactions	group_name	1.29	3	string	true	false	false	the application-provided grouping for this transaction
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
1104	credit_card_transactions	credit_card_principal_name	1.29	27	string	true	false	false	the application-provided principal who provided this credit card
1153	credit_card_transactions	authorization_approval_code	1.29	72	string	true	false	false	the approval code
1133	credit_card_transactions	authorization_communication_result	1.29	52	string	true	false	false	the authorization communication result
2525	httpd_shared_tomcats	auto_deploy	1.80.1	14	boolean	false	false	false	the autoDeploy setting for this Tomcat
2500	httpd_tomcat_std_sites	auto_deploy	1.80.1	6	boolean	false	false	false	the autoDeploy setting for this Tomcat
225	NoticeLog.balance	balance	1.83.0	2	money	false	false	false	the balance for a single currency
64	bank_accounts	bank	1.0a100	2	string	false	false	false	the bank the account is with
704	ao_servers	failover_batch_size	1.12	13	int	false	false	false	the batch size used for failover replications coming from this server
700	ao_servers	jilter_bind	1.7	10	fkey	true	false	false	the bind that sendmail uses to connect to jilter
698	ao_servers	daemon_connect_bind	1.0a119	8	fkey	true	false	false	the bind to connect to
1389	signup_requests	brand	1.44	1	accounting	false	false	false	the brand of the parent business for the new account
943	net_devices	broadcast	1.0a112	7	ip_address	true	false	false	the broadcast IP
2	business_servers	accounting	1.0a100	1	accounting	false	false	false	the business
1103	credit_card_transactions	credit_card_created_by	1.29	26	username	false	false	false	the business administrator account that provided this credit card
21	businesses	can_add_backup_server	1.0a102	6	boolean	false	false	false	the business may add servers to the backup system
59	disable_log	accounting	1.0a100	2	accounting	false	false	false	the business whose resources are being disabled
1050	credit_cards	created_by	1.0a100	23	username	false	false	false	the business_administrator who added the card to the database
221	monthly_charges	created_by	1.0a100	8	username	false	false	false	the business_administrator who created the entry
361	technology_versions	owner	1.0a100	4	username	false	false	false	the business_administrator who is responsible for maintaining this package
79	bank_transactions	administrator	1.0a100	4	username	false	false	false	the business_administrator who made this transaction
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
1157	credit_card_transactions	capture_communication_result	1.29	76	string	true	false	false	the capture communication result
1109	credit_card_transactions	creditCard.expirationMonth	1.82.0	32	short	true	false	false	the card expiration month
1021	credit_cards	expirationMonth	1.82.0	5	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
1022	credit_cards	expirationYear	1.82.0	6	short	true	false	false	the card expiration year
1040	credit_cards	city	1.69	18	string	false	false	false	the card holders city
1046	credit_cards	postal_code	1.69	20	string	true	false	false	the card holders postal code
1043	credit_cards	state	1.69	19	string	true	false	false	the card holders state
1058	credit_cards	encrypted_card_number	1.31	30	string	true	false	false	the card number stored encrypted
82	bank_transactions	expenseCategory	1.81.18	6	string	true	false	false	the category in which this expense belongs
237	package_categories	name	1.0a123	0	string	false	true	true	the category name
41	business_administrators	cell_phone	1.0a100	10	phone	true	false	false	the cellular phone number
414	cyrus_imapd_binds	certificate	1.81.10	3	fkey	true	false	false	the certificate used by this bind
1645	httpd_site_binds	certificate	1.81.10	6	fkey	true	false	false	the certificate used by this bind
492	sendmail_servers	client_certificate	1.81.10	6	fkey	false	false	false	the certificate used for this client
419	cyrus_imapd_servers	certificate	1.81.10	3	fkey	false	false	false	the certificate used for this server
491	sendmail_servers	server_certificate	1.81.10	5	fkey	false	false	false	the certificate used for this server
1014	country_codes	charge_com_name	1.0a100	3	string	true	false	true	the Charge.Com specific name
85	bank_transactions	checkNo	1.81.18	8	string	true	false	false	the check number (if available)
106	business_profiles	city	1.69	9	string	false	false	false	the city
1401	signup_requests	business_city	1.69	10	string	false	false	false	the city of the business
47	business_administrators	city	1.69	15	string	true	false	false	the city (if different than business)
1422	signup_requests	ba_city	1.69	23	string	true	false	false	the city of the administrator
1122	credit_card_transactions	credit_card_city	1.69	44	string	false	false	false	the city of the card holder
2475	httpd_tomcat_contexts	class_name	1.0a100	2	string	true	false	false	the className attribute
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
1344	schema_foreign_keys	column	1.81.18	1	fkey	false	false	true	the column that references another column
1029	credit_cards	company_name	1.29	10	string	true	false	false	the company name
1113	credit_card_transactions	credit_card_company_name	1.29	36	string	true	false	false	the company name for the credit card
478	email_pipes	command	1.80.0	2	string	false	false	false	the complete command string to the email handling program
444	email_lists	path	1.0a100	1	path	false	false	false	the complete path to the email list
718	shells	path	1.0a100	0	path	false	true	true	the complete path to the executable
1543	httpd_servers	monitoring_concurrency_critical	1.81.11	16	int	true	false	false	the concurrency that will trigger a critical-level alert
1542	httpd_servers	monitoring_concurrency_high	1.81.11	15	int	true	false	false	the concurrency that will trigger a high-level alert
1540	httpd_servers	monitoring_concurrency_low	1.81.11	13	int	true	false	false	the concurrency that will trigger a low-level alert
1541	httpd_servers	monitoring_concurrency_medium	1.81.11	14	int	true	false	false	the concurrency that will trigger a medium-level alert
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"
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
522	email_smtp_relay_types	qmail_config	1.0a100	2	string	false	false	true	the config value used for qmail
521	email_smtp_relay_types	sendmail_config	1.0a100	1	string	false	false	true	the config value used for sendmail
2521	httpd_shared_tomcats	is_manual	1.0a100	10	boolean	false	false	false	the configuration files are manually maintained
87	bank_transactions	confirmed	1.0a100	10	boolean	false	false	false	the confirmation status with bank
2457	httpd_tomcat_data_sources	tomcat_context	1.5	1	fkey	false	false	false	the context this data source is for
2468	httpd_tomcat_parameters	tomcat_context	1.5	1	fkey	false	false	false	the context this parameter is for
2476	httpd_tomcat_contexts	cookies	1.0a100	3	boolean	false	false	false	the cookies attribute
51	business_administrators	country	1.69	17	string	true	false	false	the country (if different than business)
831	mysql_db_users	create_priv	1.0a100	7	boolean	false	false	false	the CREATE privilege
862	mysql_users	create_priv	1.0a100	5	boolean	false	false	false	the CREATE privilege to all databases
841	mysql_db_users	create_routine_priv	1.4	17	boolean	false	false	false	the Create_routine_priv
837	mysql_db_users	create_tmp_table_priv	1.0a111	13	boolean	false	false	false	the Create_tmp_table_priv
839	mysql_db_users	create_view_priv	1.4	15	boolean	false	false	false	the Create_view_priv
1434	signup_requests	encrypted_data	1.23	32	string	false	false	false	the credit card details and password are stored encrypted
308	transactions	processor	1.29	11	string	true	false	false	the credit card processor that handled the payment
78	bank_transactions	processor	1.29	3	string	true	false	false	the credit card processor used by this transaction
309	transactions	credit_card_transaction	1.29	12	fkey	true	false	false	the credit card transaction for this transaction
2477	httpd_tomcat_contexts	cross_context	1.0a100	4	boolean	false	false	false	the crossContext attribute
2358	ip_reputation_set_hosts	bad_reputation	1.65	4	short	false	false	false	the current bad repuation
2357	ip_reputation_set_hosts	good_reputation	1.65	3	short	false	false	false	the current good reputation
1218	postgres_databases	datdba	1.0a100	3	fkey	false	false	false	the datdba for the database
148	backup_reports	date	1.0a101	3	date	false	false	false	the date the summary is for
1320	aoserv_protocols	lastUsed	1.81.18	3	date	true	false	true	the date this protocol was last used
604	virtual_disks	verify_day_of_week	1.72	8	int	false	false	false	the day of the week verification will begin
1031	credit_cards	phone	1.29	12	phone	true	false	false	the daytime phone number
2486	httpd_tomcat_contexts	debug	1.0a100	12	int	false	false	false	the debug attribute
260	package_definitions	monthlyRate	1.83.0	9	money	true	false	false	the default monthly charge for this package
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
903	protocols	port	1.80.0	1	net_port	false	false	true	the default port of the protocol
939	net_devices	delete_route	1.0a112	4	string	true	false	false	the default routing from the network scripts that should be removed
345	operating_system_versions	sort_order	1.3	7	short	false	true	true	the default sort order
270	packages	package_definition	1.0a123	3	fkey	false	false	false	the definition of the package
830	mysql_db_users	delete_priv	1.0a100	6	boolean	false	false	false	the DELETE privilege
861	mysql_users	delete_priv	1.0a100	4	boolean	false	false	false	the DELETE privilege to all databases
1361	schema_tables	description	1.0a100	6	string	false	false	true	the description of the table
383	dns_types	description	1.0a100	1	string	false	false	true	the description of the type
216	monthly_charges	description	1.0a100	4	string	true	false	false	the description that is placed in the transaction
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
435	email_forwarding	destination	1.0a100	2	email	false	false	false	the destination of the email
544	system_email_aliases	destination	1.0a100	3	string	false	false	false	the destination, as found in /etc/aliases
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
690	ao_servers	daemonDeviceId	1.81.18	7	string	false	false	false	the device name the master connects to
1378	cvs_repositories	mode	1.0a100	4	octal_long	false	false	false	the directory permissions
2535	httpd_tomcat_versions	install_dir	1.0a100	1	path	false	false	true	the directory the basic install files are located in
1358	schema_tables	display	1.0a100	4	string	false	false	true	the display name
63	bank_accounts	display	1.0a100	1	string	false	false	false	the display name of this account
535	email_sa_integration_modes	display	1.0a120	1	string	false	false	true	the display value for the mode
90	bank_transaction_types	display	1.0a100	1	string	false	false	false	the display value for the type
335	operating_systems	display	1.0a100	1	string	false	false	true	the display version of the name
2479	httpd_tomcat_contexts	doc_base	1.80.0	5	path	false	false	false	the docBase attribute
392	dns_tlds	domain	1.69	0	domain_name	false	true	true	the domain
1191	ssl_certificate_names	domain	1.81.10	4	domain_name	false	false	false	the domain name
429	email_domains	domain	1.69	1	domain_name	false	false	false	the domain that is hosted in the email
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
832	mysql_db_users	drop_priv	1.0a100	8	boolean	false	false	false	the DROP privilege
863	mysql_users	drop_priv	1.0a100	6	boolean	false	false	false	the DROP privilege to all databases
421	cyrus_imapd_servers	delete_duration	1.81.10	5	float	true	false	false	the duration after which delayed delete folders are removed
425	cyrus_imapd_servers	expunge_duration	1.81.10	9	float	true	false	false	the duration after which delayed expunge messages are removed
1084	credit_card_transactions	dutyAmount	1.83.0	11	money	true	false	false	the duty amount for this transaction
43	business_administrators	email	1.0a100	12	email	false	false	false	the email address
1030	credit_cards	email	1.29	11	email	true	false	false	the email address
1431	signup_requests	billing_email	1.23	29	email	false	false	false	the email address of the billing contact
1114	credit_card_transactions	credit_card_email	1.29	37	email	true	false	false	the email address of the card holder
1099	credit_card_transactions	merchant_email	1.29	22	email	true	false	false	the email address of the merchant
398	dns_zones	hostmaster	1.0a100	3	string	false	false	false	the email address of the person in charge of the domain
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>
553	private_ftp_servers	email	1.0a100	3	email	false	false	false	the email address the server reports
116	business_profiles	billing_email	1.0a100	16	string	false	false	false	the email address to notify for billing
119	business_profiles	technical_email	1.0a100	19	string	false	false	false	the email address to notify for technical
452	majordomo_lists	email_list	1.0a100	0	fkey	false	true	false	the email list that this majordomo_list represents
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
465	majordomo_servers	majordomo_pipe_address	1.0a100	4	fkey	false	false	false	the email_address to use as the majordomo
1182	credit_card_processors	enabled	1.29	7	boolean	false	false	false	the enabled flag
182	failover_file_replications	enabled	1.15	8	boolean	false	false	false	the enabled flag for failovers
194	file_backup_settings	backup_enabled	1.31	3	boolean	false	false	false	the enabled flag for this prefix
31	business_administrators	password	1.69	1	hashed_password	true	false	false	the encrypted password for this admin
331	WhoisHistory	error	1.81.19	5	string	false	false	false	the error from the whois lookup
844	mysql_db_users	event_priv	1.54	20	boolean	false	false	false	the Event_priv
884	mysql_users	event_priv	1.54	27	boolean	false	false	false	the Event_priv
399	dns_zones	serial	1.0a100	4	long	false	false	false	the ever-incrementing serial number for the file
843	mysql_db_users	execute_priv	1.4	19	boolean	false	false	false	the Execute_priv
329	WhoisHistory	exitStatus	1.81.19	3	int	true	false	false	the exit status from the whois lookup, null on exception
518	email_smtp_relays	expiration	1.0a100	8	time	true	false	false	the expiration time of the entry, or null if non-expiring
406	email_attachment_blocks	extension	1.0a116	2	string	false	false	false	the extension of the blocked files
998	ip_addresses	externalInetAddress	1.81.18	10	ip_address	true	false	false	the external IP address, if different than ip_address
201	failover_mysql_replications	replication	1.59	2	fkey	true	false	false	the failover server that receives the replication
102	business_profiles	fax	1.0a100	6	phone	true	false	false	the fax number
1032	credit_cards	fax	1.29	13	phone	true	false	false	the fax number
42	business_administrators	fax	1.0a100	11	phone	true	false	false	the fax number (if different than business)
1397	signup_requests	business_fax	1.69	7	phone	true	false	false	the fax number of the business
1116	credit_card_transactions	credit_card_fax	1.29	39	phone	true	false	false	the fax number of the card holder
1203	ssl_certificates	chain_file	1.81.10	6	path	true	false	false	the file holding the CA chain
1201	ssl_certificates	csr_file	1.81.10	4	path	true	false	false	the file holding the CSR
1200	ssl_certificates	key_file	1.81.10	3	path	false	false	false	the file holding the private key
1202	ssl_certificates	cert_file	1.81.10	5	path	false	false	false	the file holding the public key
867	mysql_users	file_priv	1.0a100	10	boolean	false	false	false	the FILE privilege to all databases
550	private_ftp_servers	logfile	1.0a100	1	path	false	false	false	the file transfers are logged to
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
395	dns_zones	file	1.0a100	1	string	false	false	false	the filename of the zone 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
128	aosh_commands	sinceVersion	1.81.18	1	string	false	false	true	the first aoserv_protocol version having this command
1327	schema_columns	sinceVersion	1.81.18	3	string	false	false	true	the first aoserv_protocol version this column was in
1371	schema_types	sinceVersion	1.81.18	2	string	false	false	true	the first aoserv_protocol version this type was in
1350	schema_foreign_keys	sinceVersion	1.81.18	3	string	false	false	true	the first aoserv_protocol version to have this reference
1356	schema_tables	sinceVersion	1.81.18	2	string	false	false	true	the first aoserv_protocol version to have this table
369	dns_records	domain	1.69	2	string	false	false	false	the first column in the zone files
1036	credit_cards	street_address1	1.29	16	string	false	false	false	the first line of the street address
1027	credit_cards	first_name	1.29	8	string	false	false	false	the first name
1111	credit_card_transactions	credit_card_first_name	1.29	34	string	false	false	false	the first name of the card holder
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
117	business_profiles	billingEmailFormat	1.81.20	17	string	false	false	false	the format for billing notification emails
120	business_profiles	technicalEmailFormat	1.81.20	20	string	false	false	false	the format for technical notification emails
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
1059	credit_cards	encryption_card_number_from	1.31	31	fkey	true	false	false	the from that was used for card number encryption
1435	signup_requests	encryption_from	1.31	33	fkey	false	false	false	the from that was used for encryption
1185	credit_card_processors	encryption_from	1.31	10	fkey	false	false	false	the from that will be used for encryption
343	operating_system_versions	display	1.0a108	5	string	false	true	true	the full display name for this version
726	linux_accounts	name	1.80.1	1	gecos	true	false	false	the full name of the user
753	linux_server_accounts	autoresponder_path	1.0a100	7	string	true	false	false	the full path of the autoresponder text file
1772	distro_files	path	1.0a108	2	path	false	false	false	the full path to the file
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
1375	cvs_repositories	path	1.0a100	1	path	false	false	false	the full path to the repository
140	backup_partitions	path	1.0a100	2	path	false	false	false	the full path to the root of the backup data
490	sendmail_servers	hostname	1.81.10	4	domain_name	true	false	false	the fully qualified hostname for Dw, Dm, and Dj
940	net_devices	gateway	1.0a100	5	ip_address	true	false	false	the gateway IP address
737	linux_server_accounts	pkey	1.0a100	0	pkey	false	true	false	the generated primary key
648	linux_server_groups	gid	1.80.0	3	linux_id	false	false	false	the gid on that machine
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
833	mysql_db_users	grant_priv	1.0a100	9	boolean	false	false	false	the GRANT privilege
868	mysql_users	grant_priv	1.0a100	11	boolean	false	false	false	the GRANT privilege to all databases
644	linux_server_groups	name	1.80.0	1	group_id	false	false	false	the group name
1779	distro_files	linux_group	1.80.0	7	group_id	false	false	false	the group of the file
1531	httpd_servers	linux_server_group	1.0a102	5	fkey	false	false	false	the group to run as
2508	httpd_shared_tomcats	linux_server_group	1.0a100	5	fkey	false	false	false	the group to which this tomcat is assigned
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
354	technology_names	image_height	1.0a100	3	int	true	false	true	the height of the image
98	business_profiles	priority	1.0a100	2	int	false	false	false	the highest priority profile is used
744	linux_server_accounts	home	1.0a100	4	path	false	false	false	the home directory of the user on this machine
40	business_administrators	home_phone	1.0a100	9	phone	true	false	false	the home phone number
732	linux_accounts	home_phone	1.69	4	gecos	true	false	false	the home phone number of the user
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.
636	ao_server_daemon_hosts	host	1.80.0	2	hostname	false	false	false	the hostname or IP address that is allowed to connect
798	master_hosts	host	1.80.0	2	hostname	false	false	false	the hostname or IP address they are allowed to connect from
513	email_smtp_relays	host	1.69	3	hostname	false	false	false	the hostname or IP the rule applies to
1637	httpd_site_urls	hostname	1.69	2	domain_name	false	false	false	the hostname that this site responds to
552	private_ftp_servers	hostname	1.69	2	domain_name	false	false	false	the hostname the server reports
165	failover_file_schedule	hour	1.0a100	2	short	false	false	false	the hour of day (in server timezone)
605	virtual_disks	verify_hour_of_day	1.72	9	int	false	false	false	the hour of day verification will begin
683	ao_servers	distro_hour	1.0a100	4	int	false	false	false	the hour the distribution will occur, in server time zone
2518	httpd_shared_tomcats	tomcat4_worker	1.0a100	7	fkey	true	true	false	the httpd_worker for Tomcat version 4
320	WhoisHistoryAccount	account	1.81.19	2	accounting	false	false	false	the id of the Account
917	net_binds	ipAddress	1.81.18	3	fkey	false	false	false	the id of the IP address that is bound to
380	dns_records	dhcpAddress	1.81.18	10	fkey	true	false	false	the id of the IP address whos changes are followed
224	NoticeLog.balance	noticeLog	1.83.0	1	fkey	false	false	false	the ID of the NoticeLog this balance is part of
1207	encryption_keys	id	1.23	2	string	false	false	false	the id of the recipient who may decrypt the message
1384	signup_request_options	request	1.23	1	fkey	false	false	false	the id of the request this option is part of
319	WhoisHistoryAccount	whoisHistory	1.81.19	1	fkey	false	false	false	the id of the WhoisHistory
299	transactions	username	1.0a100	4	username	false	false	false	the identifier for the admin involved in the transaction (see business_administrators)
297	transactions	accounting	1.0a100	2	accounting	false	false	false	the identifier for the business (see businesses)
2360	ip_reputation_limiter_limits	limiter	1.66	1	fkey	false	false	false	the identifier of the limiter
2381	ip_reputation_limiter_sets	limiter	1.66	1	fkey	false	false	false	the identifier of the limiter
2377	ip_reputation_limiters	net_device	1.66	1	fkey	false	false	false	the identifier of the net_device that is protected
2382	ip_reputation_limiter_sets	set	1.66	2	fkey	false	false	false	the identifier of the set
1330	schema_columns	index	1.81.18	5	short	false	false	true	the index of the column
835	mysql_db_users	index_priv	1.0a100	11	boolean	false	false	false	the INDEX privilege
870	mysql_users	index_priv	1.0a100	13	boolean	false	false	false	the INDEX privilege to all databases
828	mysql_db_users	insert_priv	1.0a100	4	boolean	false	false	false	the INSERT privilege
859	mysql_users	insert_priv	1.0a100	2	boolean	false	false	false	the INSERT privilege to all databases
762	linux_server_accounts	sa_integration_mode	1.0a120	15	string	false	false	false	the integration mode for SpamAssassin
978	ip_addresses	inetAddress	1.81.18	1	ip_address	false	false	false	the IP address
995	ip_addresses	isDhcp	1.81.18	9	boolean	false	false	false	the IP address is obtained via DHCP
1391	signup_requests	ip_address	1.23	3	ip_address	false	false	false	the IP address of the user who signed-up
411	cyrus_imapd_binds	net_bind	1.81.10	0	fkey	false	true	false	the IP address, port, and protocol details
1521	httpd_binds	net_bind	1.0a100	0	fkey	false	true	false	the IP address, port, and protocol details
482	sendmail_binds	net_bind	1.81.10	0	fkey	false	true	false	the IP address, port, and protocol details
1641	httpd_site_binds	httpd_bind	1.0a100	2	fkey	false	false	false	the IP and port information for the binding
2354	ip_reputation_set_hosts	set	1.66	1	fkey	false	false	false	the IP Reputation Set
2386	ip_reputation_set_networks	set	1.66	1	fkey	false	false	false	the IP Reputation Set
208	Currency	currencyCode	1.83.0	0	string	false	true	true	the ISO 4217 currency code of this currency
2541	httpd_workers	name	1.81.18	1	string	false	false	false	the jk_code for the worker
2458	httpd_tomcat_data_sources	name	1.5	2	string	false	false	false	the JNDI name
2520	httpd_shared_tomcats	tomcat4_shutdown_key	1.0a100	9	string	true	false	false	the key used to shut down the JVM
2496	httpd_tomcat_std_sites	tomcat4_shutdown_key	1.0a100	2	string	true	false	false	the key used to shut down the JVM
1473	languages	code	1.44	0	string	false	true	true	the language code
129	aosh_commands	lastVersion	1.81.18	2	string	true	false	true	the last aoserv_protocol version having this command
1352	schema_foreign_keys	lastVersion	1.81.18	4	string	true	false	true	the last aoserv_protocol version to have this references, or null if not yet removed
1357	schema_tables	lastVersion	1.81.18	3	string	true	false	true	the last aoserv_protocol version to have this table or null if still used
1028	credit_cards	last_name	1.29	9	string	false	false	false	the last name
1112	credit_card_transactions	credit_card_last_name	1.29	35	string	false	false	false	the last name of the card holder
716	ao_servers	lastGid	1.81.18	23	linux_id	true	false	false	the last value for automatic gid selection in groupadd, if any
715	ao_servers	lastUid	1.81.18	22	linux_id	true	false	false	the last value for automatic uid selection in useradd, if any
1328	schema_columns	lastVersion	1.81.18	4	string	true	false	true	the last version containing this field
1373	schema_types	lastVersion	1.81.18	3	string	true	false	true	the last version containing this type
1780	distro_files	size	1.0a100	8	long	true	false	false	the length of the file
660	linux_group_accounts	user	1.81.22	2	linux_username	false	false	false	the linux account that is an alternate member
657	linux_group_accounts	group	1.81.18	1	group_id	false	false	false	the linux group name
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
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
454	majordomo_lists	name	1.0a100	2	string	false	false	false	the list name
942	net_devices	network	1.0a112	6	ip_address	true	false	false	the local network
728	linux_accounts	office_location	1.69	2	gecos	true	false	false	the location of the user
838	mysql_db_users	lock_tables_priv	1.0a111	14	boolean	false	false	false	the Lock_tables_priv
945	net_devices	mac_address	1.80.0	8	mac_address	true	true	false	the MAC address to be used on the device
453	majordomo_lists	majordomo_server	1.0a100	1	fkey	false	false	false	the majordomo_server that this list is part of
1108	credit_card_transactions	credit_card_masked_card_number	1.29	31	string	false	false	false	the masked card number
1020	credit_cards	card_info	1.0a100	4	string	false	false	false	the masked card number
714	ao_servers	gidMax	1.81.18	21	linux_id	false	false	false	the max 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
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
207	failover_mysql_replications	max_alert_level	1.74	8	string	false	false	false	the maximum alert level for all monitoring of this slave
174	failover_file_replications	max_bit_rate	1.61	3	long	true	false	false	the maximum bit rate for files being replicated
946	net_devices	max_bit_rate	1.2	9	long	true	false	false	the maximum bits per second for this network device
282	packages	email_in_burst	1.24	7	int	true	false	false	the maximum burst of inbound email before limiting begins
284	packages	email_out_burst	1.24	9	int	true	false	false	the maximum burst of outbound email before limiting begins
286	packages	email_relay_burst	1.24	11	int	true	false	false	the maximum burst of relay email before limiting begins
575	racks	max_power	1.36	3	float	true	false	false	the maximum electrical load supported by the rack
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
852	mysql_servers	max_connections	1.4	4	int	false	false	false	the maximum number of connections for the db
1234	postgres_servers	max_connections	1.0a100	4	int	false	false	false	the maximum number of connections for the db
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
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
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
2394	ip_reputation_sets	max_hosts	1.65	4	int	false	false	false	the maximum number of individual hosts tracked
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
1539	httpd_servers	max_concurrency	1.68	12	int	false	false	false	the maximum number of processes/threads for this server instance
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
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
243	package_definition_limits	hard_limit	1.0a123	4	int	true	false	false	the maximum number that may be allocated, NULL means unlimited
2398	ip_reputation_sets	max_network_reputation	1.65	8	short	false	false	false	the maximum reputation for a network
2396	ip_reputation_sets	max_definite_reputation	1.65	6	short	false	false	false	the maximum reputation from definite sources
2395	ip_reputation_sets	max_uncertain_reputation	1.65	5	short	false	false	false	the maximum reputation from uncertain sources
2522	httpd_shared_tomcats	maxParameterCount	1.92.0	11	int	true	false	false	the maxParameterCount setting for this Tomcat
2497	httpd_tomcat_std_sites	maxParameterCount	1.92.0	3	int	true	false	false	the maxParameterCount setting for this Tomcat
2523	httpd_shared_tomcats	max_post_size	1.80.1	12	int	true	false	false	the maxPostSize setting for this Tomcat
2498	httpd_tomcat_std_sites	max_post_size	1.80.1	4	int	true	false	false	the maxPostSize setting for this Tomcat
1102	credit_card_transactions	description	1.29	25	string	true	false	false	the merchant-provided description of this transaction
1100	credit_card_transactions	invoice_number	1.29	23	string	true	false	false	the merchant-provided invoice number
1070	credit_card_transactions	order_number	1.29	6	string	true	false	false	the merchant-provided order number for this transaction
1101	credit_card_transactions	purchase_order_number	1.29	24	string	true	false	false	the merchant-provided purchase order number
1117	credit_card_transactions	creditCard.customerId	1.82.1	40	string	true	false	false	the merchant-specific unique customer ID
1033	credit_cards	customerId	1.82.1	14	string	true	false	false	the merchant-specific unique customer ID
540	spam_email_messages	message	1.0a100	3	string	false	false	false	the message contents
712	ao_servers	gidMin	1.81.18	19	linux_id	false	false	false	the min value for automatic gid selection in groupadd
710	ao_servers	uidMin	1.81.18	18	linux_id	false	false	false	the min value for automatic uid selection in useradd
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
210	Currency	autoEnableMinimumPayment	1.83.0	2	money	false	false	true	the minimum payment for auto-enabling accounts
614	virtual_servers	minimum_processor_architecture	1.36	6	string	false	false	false	the minimum processor architecture, compatible architectures may be substituted
615	virtual_servers	minimum_processor_speed	1.41	7	int	true	false	false	the minimum processor speed in MHz
616	virtual_servers	minimum_processor_speed_target	1.43	8	int	true	false	false	the minimum processor speed in MHz
611	virtual_servers	minimum_processor_type	1.41	5	string	true	false	false	the minimum processor type
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
1257	postgres_versions	minor_version	1.0a121	1	string	false	false	true	the minor version for this version (used for installation at /usr/postgresql/<minor_version>
166	failover_file_schedule	minute	1.31	3	short	false	false	false	the minute (in server timezone)
1775	distro_files	mode	1.0a100	5	octal_long	false	false	false	the mode (including file type bits)
245	package_definition_limits	additionalRate	1.83.0	5	money	true	false	false	the monthly rate for those past the soft_limit
202	failover_mysql_replications	mysql_server	1.28	3	fkey	false	false	false	the MySQL Server that is being replicated
484	sendmail_binds	servername	1.81.10	2	string	true	false	false	the Name for DaemonPortOptions for this bind
341	operating_system_versions	architecture	1.0a108	4	string	false	false	true	the name of the architecture
1430	signup_requests	billing_contact	1.23	28	string	false	false	false	the name of the billing contact
1642	httpd_site_binds	name	1.81.14	3	string	true	false	false	the name of the bind, null for the default bind
99	business_profiles	name	1.0a100	3	string	false	false	false	the name of the business
1393	signup_requests	business_name	1.23	5	string	false	false	false	the name of the business
1204	ssl_certificates	certbot_name	1.81.10	7	string	true	false	false	the name of the certbot-managed Let's Encrypt certificate
349	technology_classes	name	1.0a100	0	string	false	true	true	the name of the class
1326	schema_columns	name	1.81.18	2	string	false	false	true	the name of the column
2469	httpd_tomcat_parameters	name	1.5	2	string	false	false	false	the name of the context initialization parameter to be created
1012	country_codes	name	1.0a100	1	string	false	false	true	the name of the country
815	mysql_databases	name	1.80.0	1	mysql_database_name	false	false	false	the name of the database
1216	postgres_databases	name	1.80.0	1	postgres_database_name	false	false	false	the name of the database
1231	postgres_servers	name	1.80.0	1	postgres_server_name	false	false	false	the name of the database
936	net_devices	deviceId	1.81.18	2	string	false	false	false	the name of the device
1226	postgres_encodings	encoding	1.0a100	1	string	false	false	true	the name of the encoding
960	servers	farm	1.0a100	1	string	false	false	false	the name of the farm the server is located in
352	technology_names	image_filename	1.0a100	1	string	true	false	true	the name of the file containing the image
954	firewalld_zones	name	1.81.0	2	firewalld_zone_name	false	false	false	the name of the Firewalld zone
638	linux_groups	name	1.80.0	0	group_id	false	true	false	the name of the group
348	technologies	class	1.0a100	2	string	false	false	true	the name of the group this package belongs to
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
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
338	operating_system_versions	operating_system	1.0a100	1	string	false	false	true	the name of the OS
252	package_definitions	name	1.0a123	3	string	false	false	false	the name of the package
347	technologies	name	1.0a100	1	string	false	false	true	the name of the package
351	technology_names	name	1.0a100	0	string	false	true	true	the name of the package
771	business_administrator_permissions	permission	1.21	2	string	false	false	false	the name of the permission that has been granted
1065	credit_card_transactions	processor_id	1.29	1	string	false	false	false	the name of the processor used for this transaction
849	mysql_servers	name	1.80.0	1	mysql_server_name	false	false	false	the name of the server
904	protocols	name	1.0a100	2	string	false	false	true	the name of the service
1601	httpd_sites	name	1.81.18	2	string	false	false	false	the name of the site, as used in the /var/www directory.
358	technology_versions	name	1.0a100	1	string	false	false	true	the name of the software package
288	resources	name	1.0a100	0	string	false	true	true	the name of the specific resource
126	us_states	name	1.0a100	1	string	false	false	true	the name of the state
1324	schema_columns	table	1.81.18	1	string	false	false	true	the name of the table the column is in
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
89	bank_transaction_types	name	1.81.18	0	string	false	true	false	the name of the type
520	email_smtp_relay_types	name	1.0a100	0	string	false	true	true	the name of the type
766	linux_account_types	name	1.0a100	0	string	false	true	true	the name of the type
651	linux_group_types	name	1.0a100	0	string	false	true	true	the name of the type
1171	payment_types	name	1.0a100	0	string	false	true	true	the name of the type
313	transaction_types	name	1.0a123	0	string	false	true	true	the name of the type
739	linux_server_accounts	username	1.81.22	1	linux_username	false	false	false	the name of the user
32	business_administrators	name	1.0a100	2	string	false	false	false	the name of this admin
340	operating_system_versions	version_name	1.0a100	3	string	false	false	true	the name of this OS release
70	banks	display	1.0a100	1	string	false	false	false	the name that is displayed
115	business_profiles	billing_contact	1.0a100	15	string	false	false	false	the name to contact for billing information
118	business_profiles	technical_contact	1.0a100	18	string	false	false	false	the name to contact for technical information
999	ip_addresses	netmask	1.38	11	string	false	false	false	the netmask of the local network
679	ao_servers	daemon_bind	1.0a100	2	fkey	true	false	false	the network bind info for the AOServ Daemon
2539	httpd_workers	bind	1.81.18	0	fkey	false	true	false	the network binding reservation and details
2397	ip_reputation_sets	network_prefix	1.65	7	short	false	false	false	the network size, for example 24 for a /24 (class C)
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
567	physical_servers	max_power	1.36	7	float	true	false	false	the number of amps this server consumes under peak load
333	architectures	bits	1.0a108	1	int	false	false	true	the number of bits used by the architecture
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
161	failover_file_log	bytes	1.0a100	6	long	false	false	false	the number of bytes transferred
177	failover_file_replications	retention	1.13	5	short	false	false	false	the number of days backups will be kept
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.
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.
153	backup_retentions	days	1.0a100	0	short	false	true	true	the number of days to keep the backup data
149	backup_reports	file_count	1.0a101	4	int	false	false	false	the number of files belong to this package on this server
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
209	Currency	fractionDigits	1.83.0	1	short	false	false	true	the number of fraction digits used with this currency
339	operating_system_versions	version_number	1.0a100	2	string	false	false	true	the number of OS version
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
562	physical_servers	rack_units	1.36	2	short	true	false	false	the number of rack units
576	racks	total_rack_units	1.36	4	int	true	false	false	the number of rack units of physical space
2399	ip_reputation_sets	host_decay_interval	1.65	9	int	false	false	false	the number of seconds between each host decay
2401	ip_reputation_sets	network_decay_interval	1.65	11	int	false	false	false	the number of seconds between each network decay
1069	credit_card_transactions	duplicate_window	1.29	5	int	false	false	false	the number of seconds for duplicate transaction detection
1005	net_tcp_redirects	cps_overload_sleep_time	1.0a111	2	int	false	false	false	the number of seconds the service will be disabled
1237	postgres_servers	shared_buffers	1.0a100	6	int	false	false	false	the number of shared buffers
283	packages	email_in_rate	1.24	8	float	true	false	false	the number of sustained inbound emails per second
285	packages	email_out_rate	1.24	10	float	true	false	false	the number of sustained outbound emails per second
287	packages	email_relay_rate	1.24	12	float	true	false	false	the number of sustained relay emails per second
517	email_smtp_relays	refresh_count	1.0a100	7	int	false	false	false	the number of times the entry has been updated
1195	ssl_certificate_other_uses	count	1.81.16	3	int	false	false	false	the number of times this other resource uses the certificate
302	transactions	quantity	1.0a100	7	decimal_3	false	false	false	the number of times to charge the account
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
956	firewalld_zones	description	1.81.0	4	string	true	false	false	the optional description
1595	RewriteRule	flags	1.81.21	5	string	true	false	false	the optional flags for the rule
1582	httpd_site_authenticated_locations	handler	1.81.13	8	string	true	false	false	the optional handler for this location
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
61	disable_log	disable_reason	1.0a100	4	string	true	false	false	the optional reason the accounts were disabled
955	firewalld_zones	short	1.81.0	3	string	true	false	false	the optional short name
717	ao_servers	sftp_umask	1.81.5	24	octal_long	true	false	false	the optional umask for the sftp-server
1770	distro_files	operating_system_version	1.0a108	1	fkey	false	false	false	the OS version that contains the file
330	WhoisHistory	output	1.81.19	4	string	false	false	false	the output from the whois lookup
2480	httpd_tomcat_contexts	override	1.0a100	6	boolean	false	false	false	the override attribute
432	email_domains	package	1.80.0	3	accounting	false	false	false	the owner of the domain
1777	distro_files	linux_account	1.81.22	6	linux_username	false	false	false	the owner of the file
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
972	servers	package	1.31	4	fkey	false	false	false	the package accountable for resources used by the server
251	package_definitions	category	1.0a123	2	string	false	false	false	the package category
123	usernames	package	1.80.0	1	accounting	false	false	false	the package name that this user is part of
640	linux_groups	package	1.80.0	1	accounting	false	false	false	the package of the group
582	server_farms	owner	1.0a102	2	fkey	false	false	false	the package that owns of the farm
913	net_binds	package	1.80.0	1	accounting	false	false	false	the package that owns the opened port
1534	httpd_servers	package	1.0a102	8	fkey	false	false	false	the package that owns the server
489	sendmail_servers	package	1.81.10	3	fkey	false	false	false	the package that owns the SSL certificate
1199	ssl_certificates	package	1.81.10	2	fkey	false	false	false	the package that owns the SSL certificate
397	dns_zones	package	1.80.0	2	accounting	false	false	false	the package that owns the zones
510	email_smtp_relays	package	1.80.0	1	accounting	false	false	false	the package that owns this entry
987	ip_addresses	package	1.81.18	5	fkey	false	false	false	the package that the IP address is part of
1604	httpd_sites	package	1.80.0	4	accounting	false	false	false	the package that the site is part of
819	mysql_databases	package	1.80.0	3	accounting	false	false	false	the package that this database is part of
214	monthly_charges	package	1.80.0	2	accounting	false	false	false	the package that this is charged for
480	email_pipes	package	1.80.0	3	accounting	false	false	false	the package that this program runs for
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()
20	businesses	parent	1.0a100	5	accounting	true	false	false	the parent business to this one
632	virtual_servers	vnc_password	1.51	16	string	false	true	false	the password for VNC console access or null to disable VNC access
1254	postgres_server_users	predisable_password	1.0a100	4	string	true	false	false	the password that was on the account before it was disabled
895	mysql_server_users	predisable_password	1.0a100	5	string	true	false	false	the password used before the account was disabled
2481	httpd_tomcat_contexts	path	1.0a100	7	string	false	false	false	the path attribute
191	file_backup_settings	path	1.0a100	2	string	false	false	false	the path to control
1576	httpd_site_authenticated_locations	path	1.18	2	string	false	false	false	the path to protect, unique per httpd_site
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
1512	httpd_site_bind_headers	sort_order	1.81.15	2	short	false	false	false	the per-bind unique sort ordering
1194	ssl_certificate_other_uses	sort_order	1.81.16	2	short	false	false	false	the per-certificate unique sort ordering
574	racks	name	1.36	2	string	false	false	false	the per-farm unique name
2383	ip_reputation_limiter_sets	sort_order	1.66	3	short	false	false	false	the per-limiter ordering
2378	ip_reputation_limiters	identifier	1.66	2	string	false	false	false	the per-net_device unique identifier
973	servers	name	1.31	5	string	false	false	false	the per-package unique name of the server (no special formatting required)
1137	credit_card_transactions	authorization_provider_unique_id	1.29	56	string	true	false	false	the per-provider unique ID
1161	credit_card_transactions	capture_provider_unique_id	1.29	80	string	true	false	false	the per-provider unique ID
1169	credit_card_transactions	void_provider_unique_id	1.29	88	string	true	false	false	the per-provider unique ID
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
2356	ip_reputation_set_hosts	host	1.67	2	ip_address	false	false	false	the per-set unique IPv4 address
2388	ip_reputation_set_networks	network	1.67	2	ip_address	false	false	false	the per-set unique IPv4 network address, with network bits zero
2491	httpd_tomcat_site_jk_mounts	path	1.81.6	2	string	false	false	false	the per-site unique pattern matched
586	virtual_disks	device	1.36	2	string	false	false	false	the per-virtual-server unique device, such as xvda or xvdb
1593	RewriteRule	pattern	1.81.21	3	string	false	false	false	the per-VirtualHost pattern matched
1592	RewriteRule	sortOrder	1.81.21	2	short	false	false	false	the per-VirtualHost unique sort ordering
60	disable_log	disabled_by	1.0a100	3	username	false	false	false	the person who disabled the accounts
459	majordomo_lists	listname_approval_add	1.0a100	7	fkey	false	true	false	the person who retrieves approval notifications. Example: test-approval@aoindustries.com
101	business_profiles	phone	1.0a100	5	phone	false	false	false	the phone number
1395	signup_requests	business_phone	1.69	6	phone	false	false	false	the phone number of the business
1115	credit_card_transactions	credit_card_phone	1.29	38	phone	true	false	false	the phone number of the card holder
455	majordomo_lists	listname_pipe_add	1.0a100	3	fkey	false	true	false	the pipe address the list responds to. Example: test@aoindustries.com
1003	net_tcp_redirects	net_bind	1.69	0	fkey	false	true	false	the pkey as found in net_binds
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
462	majordomo_servers	linux_server_account	1.0a100	1	fkey	false	false	false	the pkey of linux_server_account to run as
634	ao_server_daemon_hosts	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the ao_server
645	linux_server_groups	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the ao_server the group is on
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
1377	cvs_repositories	linux_server_group	1.0a100	3	fkey	false	false	false	the pkey of the directory group
1376	cvs_repositories	linux_server_account	1.0a100	2	fkey	false	false	false	the pkey of the directory owner
461	majordomo_servers	domain	1.0a100	0	fkey	false	true	false	the pkey of the domain that is hosted
751	linux_server_accounts	autoresponder_from	1.0a100	5	fkey	true	false	false	the pkey of the email address used for the autoresponder
403	email_addresses	domain	1.0a100	2	fkey	false	false	false	the pkey of the email domain
442	email_list_addresses	email_list	1.0a100	2	fkey	false	false	false	the pkey of the email list
1219	postgres_databases	encoding	1.0a100	4	fkey	false	false	false	the pkey of the encoding system used for the database
190	file_backup_settings	replication	1.31	1	fkey	false	false	false	the pkey of the failover_file_replication configured
463	majordomo_servers	linux_server_group	1.0a100	2	fkey	false	false	false	the pkey of the linux_server_group to run as
891	mysql_server_users	mysql_server	1.4	2	fkey	false	false	false	the pkey of the MySQL server
851	mysql_servers	version	1.4	3	fkey	false	false	false	the pkey of the MySQL version
240	package_definition_limits	package_definition	1.0a123	1	fkey	false	false	false	the pkey of the package definition
1392	signup_requests	package_definition	1.23	4	fkey	false	false	false	the pkey of the Package Definition requested
147	backup_reports	package	1.0a101	2	fkey	false	false	false	the pkey of the package the data is assigned to
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
1217	postgres_databases	postgres_server	1.0a100	2	fkey	false	false	false	the pkey of the PostgreSQL server
1251	postgres_server_users	postgres_server	1.69	2	fkey	false	false	false	the pkey of the PostgreSQL server
1233	postgres_servers	version	1.0a100	3	fkey	false	false	false	the pkey of the PostgreSQL version
953	firewalld_zones	server	1.81.0	1	fkey	false	false	false	the pkey of the server
146	backup_reports	server	1.0a101	1	fkey	false	false	false	the pkey of the server being backed-up
2505	httpd_shared_tomcats	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server on which this jvm resides
934	net_devices	server	1.33	1	fkey	false	false	false	the pkey of the server that contains the device
1524	httpd_servers	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server that hosts the httpd
430	email_domains	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server that is hosting the email
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
487	sendmail_servers	ao_server	1.81.10	1	fkey	false	false	false	the pkey of the server that runs this sendmail instance
138	backup_partitions	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server that stores the backup data
170	failover_file_replications	server	1.31	1	fkey	false	false	false	the pkey of the server that the files are coming from
511	email_smtp_relays	ao_server	1.0a100	2	fkey	true	false	false	the pkey of the server that the rule applies to
817	mysql_databases	mysql_server	1.4	2	fkey	false	false	false	the pkey of the server that this database is hosted on
850	mysql_servers	ao_server	1.4	2	fkey	false	false	false	the pkey of the server that this database is hosted on
1232	postgres_servers	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server that this database is hosted on
915	net_binds	server	1.33	2	fkey	false	false	false	the pkey of the server that this port is bound on
542	system_email_aliases	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the entry is on
476	email_pipes	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the program resides on
1599	httpd_sites	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the site is hosted on
1198	ssl_certificates	ao_server	1.81.10	1	fkey	false	false	false	the pkey of the server the SSL certificate is on
740	linux_server_accounts	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server the username is on
801	master_servers	server	1.0a100	2	fkey	false	false	false	the pkey of the server they may control
1188	ssl_certificate_names	ssl_certificate	1.81.10	1	fkey	false	false	false	the pkey of the SSL certificate this name is on
1193	ssl_certificate_other_uses	ssl_certificate	1.81.16	1	fkey	false	false	false	the pkey of the SSL certificate this name is on
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
920	net_binds	port	1.80.0	4	net_port	false	false	false	the port that is bound
2519	httpd_shared_tomcats	tomcat4_shutdown_port	1.0a100	8	fkey	true	true	false	the port that will shut down this JVM
2495	httpd_tomcat_std_sites	tomcat4_shutdown_port	1.0a100	1	fkey	true	true	false	the port that will shut down this JVM
847	mysql_servers	bind	1.81.18	0	fkey	false	true	false	the port the server binds to
1229	postgres_servers	bind	1.81.18	0	fkey	false	true	false	the port the server binds to
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
1126	credit_card_transactions	credit_card_postal_code	1.69	46	string	true	false	false	the postal code of the card holder
1608	httpd_sites	linux_group	1.80.0	6	group_id	false	false	false	the primary group that can edit the site content
401	email_addresses	pkey	1.0a100	0	pkey	false	true	false	the primary key
474	email_pipe_addresses	email_pipe	1.0a100	2	fkey	false	false	false	the primary key of the email pipe
410	blackhole_email_addresses	email_address	1.0a100	0	fkey	false	true	false	the primary key of the email_address
434	email_forwarding	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
441	email_list_addresses	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
473	email_pipe_addresses	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
372	dns_records	priority	1.72	4	int	true	false	false	the priority for the entry
2482	httpd_tomcat_contexts	privileged	1.0a100	8	boolean	false	false	false	the privileged attribute
866	mysql_users	process_priv	1.0a100	9	boolean	false	false	false	the PROCESS privilege to all databases
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
565	physical_servers	processor_speed	1.36	5	int	true	false	false	the processor speed in MHz
564	physical_servers	processor_type	1.36	4	string	true	false	false	the processor type
1578	httpd_site_authenticated_locations	auth_name	1.18	4	string	false	false	false	the prompt given to the user during authentication
2493	httpd_jk_protocols	protocol	1.0a100	0	string	false	true	true	the protocol used, as found in protocols.protocol
1144	credit_card_transactions	authorization_approval_result	1.29	63	string	true	false	false	the provider-neutral approval result
1152	credit_card_transactions	authorization_avs_result	1.29	71	string	true	false	false	the provider-neutral AVS result
1150	credit_card_transactions	authorization_cvv_result	1.29	69	string	true	false	false	the provider-neutral CVV result
1146	credit_card_transactions	authorization_decline_reason	1.29	65	string	true	false	false	the provider-neutral decline reason
1135	credit_card_transactions	authorization_error_code	1.29	54	string	true	false	false	the provider-neutral error code
1159	credit_card_transactions	capture_error_code	1.29	78	string	true	false	false	the provider-neutral error code
1167	credit_card_transactions	void_error_code	1.29	86	string	true	false	false	the provider-neutral error code
1148	credit_card_transactions	authorization_review_reason	1.29	67	string	true	false	false	the provider-neutral review reason
1143	credit_card_transactions	authorization_provider_approval_result	1.29	62	string	true	false	false	the provider-specific approval result
1151	credit_card_transactions	authorization_provider_avs_result	1.29	70	string	true	false	false	the provider-specific AVS result
1149	credit_card_transactions	authorization_provider_cvv_result	1.29	68	string	true	false	false	the provider-specific CVV result
1145	credit_card_transactions	authorization_provider_decline_reason	1.29	64	string	true	false	false	the provider-specific decline reason
1134	credit_card_transactions	authorization_provider_error_code	1.29	53	string	true	false	false	the provider-specific error code
1158	credit_card_transactions	capture_provider_error_code	1.29	77	string	true	false	false	the provider-specific error code
1166	credit_card_transactions	void_provider_error_code	1.29	85	string	true	false	false	the provider-specific error code
1136	credit_card_transactions	authorization_provider_error_message	1.29	55	string	true	false	false	the provider-specific error message
1160	credit_card_transactions	capture_provider_error_message	1.29	79	string	true	false	false	the provider-specific error message
1168	credit_card_transactions	void_provider_error_message	1.29	87	string	true	false	false	the provider-specific error message
1140	credit_card_transactions	authorizationResult.providerReplacementExpiration	1.82.0	59	string	true	false	false	the provider-specific replacement expiration date
1138	credit_card_transactions	authorizationResult.providerReplacementMaskedCardNumber	1.82.0	57	string	true	false	false	the provider-specific replacement masked card number
1147	credit_card_transactions	authorization_provider_review_reason	1.29	66	string	true	false	false	the provider-specific review reason
217	monthly_charges	quantity	1.0a100	5	decimal_3	false	false	false	the quantity
561	physical_servers	rack	1.36	1	fkey	true	false	false	the rack that houses this server
219	monthly_charges	rate	1.83.0	6	money	false	false	false	the rate
19	businesses	cancel_reason	1.0a100	4	string	true	false	false	the reason the account was canceled
1055	credit_cards	deactivate_reason	1.0a100	28	string	true	false	false	the reason the card was deactivated
364	technology_versions	disable_reason	1.78	7	string	true	false	true	the reason this version is no longer supported
1060	credit_cards	encryption_card_number_recipient	1.31	32	fkey	true	false	false	the recipient that was used for card number encryption
1437	signup_requests	encryption_recipient	1.31	34	fkey	false	false	false	the recipient that was used for encryption
1186	credit_card_processors	encryption_recipient	1.31	11	fkey	false	false	false	the recipient that will be used for encryption
682	ao_servers	pool_size	1.0a100	3	int	false	false	false	the recommended connection pool size for the AOServ Master
1346	schema_foreign_keys	foreignColumn	1.81.18	2	fkey	false	false	true	the referenced column
834	mysql_db_users	references_priv	1.0a100	10	boolean	false	false	false	the REFERENCES privilege
869	mysql_users	references_priv	1.0a100	12	boolean	false	false	false	the REFERENCES privilege to all databases
327	WhoisHistory	registrableDomain	1.81.19	1	domain_name	false	false	false	the registrable domain that was queried
373	dns_records	weight	1.72	5	int	true	false	false	the relative weight for records with the same priority
538	spam_email_messages	email_relay	1.0a100	1	fkey	false	false	false	the relay that has been denied
864	mysql_users	reload_priv	1.0a100	7	boolean	false	false	false	the RELOAD privilege to all databases
2483	httpd_tomcat_contexts	reloadable	1.0a100	9	boolean	false	false	false	the reloadable attribute
1009	net_tcp_redirects	destination_port	1.80.0	4	net_port	false	false	false	the remote port to connect to
1141	credit_card_transactions	authorizationResult.replacementExpirationMonth	1.82.0	60	short	true	false	false	the replacement card expiration month
1142	credit_card_transactions	authorizationResult.replacementExpirationYear	1.82.0	61	short	true	false	false	the replacement card expiration year
1139	credit_card_transactions	authorizationResult.replacementMaskedCardNumber	1.82.0	58	string	true	false	false	the replacement masked card number
1518	httpd_site_bind_headers	replacement	1.81.15	8	string	true	false	false	the replacement value, only used for "edit" and "edit*"
156	failover_file_log	replication	1.0a100	1	fkey	false	false	false	the replication that was performed
164	failover_file_schedule	replication	1.0a100	1	fkey	false	false	false	the replication that will be started
2361	ip_reputation_limiter_limits	class	1.66	2	string	false	false	false	the reputation class
2389	ip_reputation_set_networks	counter	1.65	3	int	false	false	false	the reputation counter
1581	httpd_site_authenticated_locations	require	1.18	7	string	false	false	false	the require directive parameter(s) for Apache
241	package_definition_limits	resource	1.0a123	2	string	false	false	false	the resource name
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
1594	RewriteRule	substitution	1.81.21	4	string	false	false	false	the rewrite substitution
548	private_ftp_servers	net_bind	1.0a113	0	fkey	false	true	false	the root directory
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
1037	credit_cards	street_address2	1.29	17	string	true	false	false	the second line of the street address
206	failover_mysql_replications	monitoring_seconds_behind_critical	1.56	7	int	true	false	false	the seconds behind where will trigger critical alert level
205	failover_mysql_replications	monitoring_seconds_behind_high	1.56	6	int	true	false	false	the seconds behind where will trigger high alert level
203	failover_mysql_replications	monitoring_seconds_behind_low	1.56	4	int	true	false	false	the seconds behind where will trigger low alert level
204	failover_mysql_replications	monitoring_seconds_behind_medium	1.56	5	int	true	false	false	the seconds behind where will trigger medium alert level
827	mysql_db_users	select_priv	1.0a100	3	boolean	false	false	false	the SELECT privilege
858	mysql_users	select_priv	1.0a100	1	boolean	false	false	false	the SELECT privilege to all databases
3	business_servers	server	1.0a100	2	fkey	false	false	false	the server
685	ao_servers	failover_server	1.0a100	6	fkey	true	false	false	the server that is currently running this server
412	cyrus_imapd_binds	cyrus_imapd_server	1.81.10	1	fkey	false	false	false	the server that is listening on the address
1522	httpd_binds	httpd_server	1.0a100	1	fkey	false	false	false	the server that is listening on the address
483	sendmail_binds	sendmail_server	1.81.10	1	fkey	false	false	false	the server that is listening on the address
606	virtual_servers	server	1.36	0	fkey	false	true	false	the server that is virtualized
573	racks	farm	1.36	1	string	false	false	false	the server_farm housing the rack
413	cyrus_imapd_binds	servername	1.81.10	2	domain_name	true	false	false	the servername for this bind
418	cyrus_imapd_servers	servername	1.81.10	2	domain_name	true	false	false	the servername for this server
257	package_definitions	setupFee	1.83.0	7	money	true	false	false	the setup fee for this package definition
2529	httpd_tomcat_shared_sites	httpd_shared_tomcat	1.0a100	1	fkey	false	false	false	the shared JVM
1088	credit_card_transactions	shipping_street_address1	1.29	15	string	true	false	false	the shipping address line 1
1089	credit_card_transactions	shipping_street_address2	1.29	16	string	true	false	false	the shipping address line 2
1081	credit_card_transactions	shippingAmount	1.83.0	10	money	true	false	false	the shipping amount for this transaction
1091	credit_card_transactions	shipping_city	1.69	17	string	true	false	false	the shipping city
1087	credit_card_transactions	shipping_company_name	1.29	14	string	true	false	false	the shipping company name
1085	credit_card_transactions	shipping_first_name	1.29	12	string	true	false	false	the shipping first name
1086	credit_card_transactions	shipping_last_name	1.29	13	string	true	false	false	the shipping last name
1095	credit_card_transactions	shipping_postal_code	1.69	19	string	true	false	false	the shipping postal code
1093	credit_card_transactions	shipping_state	1.69	18	string	true	false	false	the shipping state
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
840	mysql_db_users	show_view_priv	1.4	16	boolean	false	false	false	the Show_view_priv
865	mysql_users	shutdown_priv	1.0a100	8	boolean	false	false	false	the SHUTDOWN privilege to all databases
1511	httpd_site_bind_headers	httpd_site_bind	1.81.15	1	fkey	false	false	false	the site bind that is being referenced
1633	httpd_static_sites	httpd_site	1.0a100	0	fkey	false	true	false	the site that contains static content
1575	httpd_site_authenticated_locations	httpd_site	1.18	1	fkey	false	false	false	the site that is being referenced
1640	httpd_site_binds	httpd_site	1.0a100	1	fkey	false	false	false	the site that is being referenced
1635	httpd_site_urls	httpd_site_bind	1.0a100	1	fkey	false	false	false	the site that is being referenced
2544	httpd_workers	tomcatSite	1.81.18	2	fkey	true	false	false	the site that provides this worker (Tomcat 3 only)
2530	httpd_tomcat_sites	httpd_site	1.0a100	0	fkey	false	true	false	the site that this Tomcat is running in
2494	httpd_tomcat_std_sites	tomcat_site	1.0a100	0	fkey	false	true	false	the site that this Tomcat is running in
2474	httpd_tomcat_contexts	tomcat_site	1.0a100	1	fkey	false	false	false	the site this context is part of
1621	httpd_sites	awstats_skip_files	1.0a129	10	string	true	false	false	the SkipFiles setting for AWStats
524	email_smtp_smart_host_domains	smart_host	1.57	1	fkey	false	false	false	the Smart Host that is being configured
1034	credit_cards	customer_tax_id	1.29	15	string	true	false	false	the social security number of employer identification number
773	aoserv_permissions	sort_order	1.21	1	short	false	true	true	the sort order for the permission
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
298	transactions	source_accounting	1.0a100	3	accounting	false	false	false	the source of the charge to this account
526	email_smtp_smart_host_domains	domain	1.69	2	domain_name	false	false	false	the specific domain that is being configured
49	business_administrators	state	1.69	16	string	true	false	false	the state (if different than business)
108	business_profiles	state	1.69	10	string	true	false	false	the state or providence
1424	signup_requests	ba_state	1.69	24	string	true	false	false	the state or providence of the administrator
1403	signup_requests	business_state	1.69	11	string	true	false	false	the state or providence of the business
1124	credit_card_transactions	credit_card_state	1.69	45	string	true	false	false	the state/province/prefecture of the card holder
1170	credit_card_transactions	status	1.29	89	string	false	false	false	the status of the transaction
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)
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
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
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
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)
752	linux_server_accounts	autoresponder_subject	1.0a100	6	string	true	false	false	the subject of autoresponder messages
765	linux_server_accounts	sudo	1.80.1	18	string	true	false	false	the sudo setting or null when sudo not allowed
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
134	aosh_commands	syntax	1.0a100	5	string	false	false	true	the syntax of the command
1788	distro_files	symlink_target	1.0a100	13	string	true	false	false	the target if is a symbolic link
1077	credit_card_transactions	taxAmount	1.83.0	8	money	true	false	false	the tax amount of the transaction
1118	credit_card_transactions	credit_card_customer_tax_id	1.29	41	string	true	false	false	the tax ID of the card holder
1078	credit_card_transactions	tax_exempt	1.29	9	boolean	false	false	false	the taxExempt flag for this transaction
374	dns_records	port	1.72	6	int	true	false	false	the TCP or UDP port on which the service is to be found
154	backup_retentions	display	1.0a100	1	string	false	false	true	the text displayed for this time increment
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
2403	ip_reputation_sets	last_reputation_added	1.67	13	time	false	false	false	the time reputation was last added
17	businesses	created	1.0a100	2	time	false	false	false	the time the account was created
735	linux_accounts	created	1.0a100	7	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
38	business_administrators	created	1.0a100	7	time	false	false	false	the time the admin entry was created
1130	credit_card_transactions	authorization_time	1.29	49	time	false	false	false	the time the authorization was attempted
1154	credit_card_transactions	capture_time	1.29	73	time	true	false	false	the time the capture was attempted
1049	credit_cards	created	1.0a100	22	time	false	false	false	the time the card was added to the database
1054	credit_cards	deactivated_on	1.0a100	27	time	true	false	false	the time the card was deactivated
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
650	linux_server_groups	created	1.69	4	time	false	false	false	the time the group was added
2400	ip_reputation_sets	last_host_decay	1.65	10	time	false	false	false	the time the hosts were last decayed
989	ip_addresses	created	1.0a100	6	time	false	false	false	the time the IP address was added
684	ao_servers	last_distro_time	1.0a100	5	time	true	false	false	the time the last distro check was started
539	spam_email_messages	time	1.0a100	2	time	false	false	false	the time the message was added
2402	ip_reputation_sets	last_network_decay	1.65	12	time	false	false	false	the time the networks were last decayed
158	failover_file_log	end_time	1.0a100	3	time	false	false	false	the time the replication finished
157	failover_file_log	start_time	1.0a100	2	time	false	false	false	the time the replication started
1379	cvs_repositories	created	1.0a100	5	time	false	false	false	the time the repository was created
1390	signup_requests	time	1.23	2	time	false	false	false	the time the request was added
555	private_ftp_servers	created	1.0a100	4	time	false	false	false	the time the server was added
58	disable_log	time	1.0a100	1	time	false	false	false	the time the stuff was disabled
72	bank_transactions	time	1.0a100	1	time	false	false	false	the time the transaction occured
294	transactions	time	1.0a100	0	time	false	false	false	the time the transaction occured
1317	aoserv_protocols	created	1.0a101	1	date	false	false	true	the time the version was added
471	majordomo_versions	created	1.0a100	1	time	false	false	true	the time the version was added
1162	credit_card_transactions	void_time	1.29	81	time	true	false	false	the time the void was attempted
328	WhoisHistory	time	1.81.19	2	time	false	false	false	the time the whois query was performed
758	linux_server_accounts	created	1.69	11	time	false	false	false	the time this account was added
114	business_profiles	created	1.0a100	14	time	false	false	false	the time this entry was created
220	monthly_charges	created	1.0a100	7	time	false	false	false	the time this entry was created
360	technology_versions	updated	1.0a100	3	time	false	false	true	the time this package was last updated
1439	signup_requests	completed_time	1.23	36	time	true	false	false	the time this request was completed
363	technology_versions	disable_time	1.78	6	time	true	false	true	the time this version is no longer supported
381	dns_records	ttl	1.0a127	11	int	true	false	false	the time to live field
422	cyrus_imapd_servers	delete_duration_unit	1.81.10	6	string	true	false	false	the time unit for delete_duration, one of "d", "h", "m", "s"
424	cyrus_imapd_servers	expire_duration_unit	1.81.10	8	string	true	false	false	the time unit for expire_duration, one of "d", "h", "m", "s"
426	cyrus_imapd_servers	expunge_duration_unit	1.81.10	10	string	true	false	false	the time unit for expunge_duration, one of "d", "h", "m", "s"
699	ao_servers	time_zone	1.2	9	string	true	false	false	the time zone setting for the server
1538	httpd_servers	timeout	1.0a130	11	int	false	false	false	the timeout setting in seconds
2446	httpd_jboss_sites	tomcat_site	1.0a100	0	pkey	false	true	false	the tomcat site
2528	httpd_tomcat_shared_sites	tomcat_site	1.0a100	0	pkey	false	true	false	the tomcat site
2490	httpd_tomcat_site_jk_mounts	httpd_tomcat_site	1.81.6	1	fkey	false	false	false	the Tomcat site that is being mounted
2506	httpd_shared_tomcats	version	1.0a100	3	fkey	false	false	false	the tomcat version
2527	httpd_shared_tomcats	tomcatAuthentication	1.83.2	16	boolean	false	false	false	the tomcatAuthentication setting for this Tomcat
2502	httpd_tomcat_std_sites	tomcatAuthentication	1.83.2	8	boolean	false	false	false	the tomcatAuthentication setting for this Tomcat
152	backup_reports	disk_size	1.0a101	5	long	false	false	false	the total number of bytes of disk space used
597	virtual_disks	extents	1.36	5	int	false	false	false	the total number of LVM extents for this device
563	physical_servers	ram	1.36	3	int	true	false	false	the total number of megabytes of RAM in this server
566	physical_servers	processor_cores	1.36	6	int	true	false	false	the total number of processor cores, hyperthreads are counted as different cores
845	mysql_db_users	trigger_priv	1.54	21	boolean	false	false	false	the Trigger_priv
885	mysql_users	trigger_priv	1.54	28	boolean	false	false	false	the Trigger_priv
1011	country_codes	code	1.69	0	string	false	true	true	the two-character code for the country
125	us_states	code	1.0a100	0	string	false	true	true	the two-character code for the state
110	business_profiles	country	1.69	11	string	false	false	false	the two-character country code
1048	credit_cards	country_code	1.69	21	string	false	false	false	the two-character country code
1426	signup_requests	ba_country	1.69	25	string	true	false	false	the two-character country code of the administrator
1405	signup_requests	business_country	1.69	12	string	false	false	false	the two-character country code of the business
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
382	dns_types	type	1.0a100	0	string	false	true	true	the type
370	dns_records	type	1.0a100	3	string	false	false	false	the type as found in dns_types
733	linux_accounts	type	1.0a100	5	string	false	false	false	the type of account
215	monthly_charges	type	1.0a100	3	string	false	false	false	the type of charge, as found in transaction types
1331	schema_columns	type	1.0a100	6	string	false	false	true	the type of data in the column
514	email_smtp_relays	type	1.0a100	4	string	false	false	false	the type of entry
1774	distro_files	type	1.0a100	4	string	false	false	false	the type of file
641	linux_groups	type	1.0a100	2	string	false	false	false	the type of group
1513	httpd_site_bind_headers	type	1.81.15	3	string	false	false	false	the type of header, either "Header" or "RequestHeader"
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
80	bank_transactions	type	1.0a100	5	string	false	false	false	the type of transaction
300	transactions	type	1.0a100	5	string	false	false	false	the type of transaction
569	physical_servers	ups_type	1.63	9	string	false	false	false	the type of UPS powering the server
743	linux_server_accounts	uid	1.80.0	3	linux_id	false	false	false	the uid of the user on the machine
2526	httpd_shared_tomcats	undeployOldVersions	1.92.0	15	boolean	false	false	false	the undeployOldVersions setting for this Tomcat
2501	httpd_tomcat_std_sites	undeployOldVersions	1.92.0	7	boolean	false	false	false	the undeployOldVersions setting for this Tomcat
127	aosh_commands	command	1.0a100	0	string	false	true	true	the unique command
407	email_attachment_types	extension	1.0a116	0	string	false	true	true	the unique filename extension
678	ao_servers	hostname	1.69	1	domain_name	false	true	false	the unique hostname of the server
572	racks	pkey	1.36	0	pkey	false	true	false	the unique ID for the rack
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
247	package_definitions	pkey	1.0a123	0	pkey	false	true	false	the unique ID of the package definition
1175	credit_card_processors	provider_id	1.29	0	string	false	true	false	the unique ID of this processor
1064	credit_card_transactions	pkey	1.29	0	pkey	false	true	false	the unique ID of this transaction
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
346	technologies	pkey	1.4	0	pkey	false	true	true	the unique identifier
29	business_administrators	username	1.0a100	0	username	false	true	false	the unique identifier for this admin
15	businesses	accounting	1.0a100	0	accounting	false	true	false	the unique identifier for this business.
239	package_definition_limits	pkey	1.0a123	0	pkey	false	true	false	the unique identifier for this limit
296	transactions	transid	1.69	1	pkey	false	true	false	the unique identifier for this transaction
1354	schema_tables	name	1.0a100	1	string	false	true	true	the unique name
1368	schema_types	name	1.81.18	1	string	false	true	true	the unique name
332	architectures	name	1.0a100	0	string	false	true	true	the unique name of the architecture
69	banks	name	1.0a100	0	string	false	true	false	the unique name of the bank
930	net_device_ids	name	1.0a100	0	string	false	true	true	the unique name of the device
577	server_farms	name	1.0a100	0	string	false	true	false	the unique name of the farm
534	email_sa_integration_modes	name	1.0a120	0	string	false	true	true	the unique name of the mode
334	operating_systems	name	1.0a100	0	string	false	true	true	the unique name of the operating system
772	aoserv_permissions	name	1.21	0	string	false	true	true	the unique name of the permission
900	protocols	protocol	1.0a100	0	string	false	true	true	the unique name of the protocol
1789	distro_file_types	type	1.0a100	0	string	false	true	false	the unique name of the type
1791	distro_report_types	name	1.70	0	string	false	true	false	the unique name of the type
570	processor_types	type	1.36	0	string	false	true	true	the unique name of the type of processor
62	bank_accounts	name	1.0a100	0	string	false	true	false	the unique name of this account
266	packages	name	1.80.0	1	accounting	false	true	false	the unique name of this package entry
721	time_zones	name	1.2	0	string	false	true	true	The unique name of this time zone
1366	schema_types	id	1.81.18	0	pkey	false	true	true	the unique number
1769	distro_files	pkey	1.0a108	0	pkey	false	true	false	the unique pkey
723	linux_accounts	username	1.81.22	0	linux_username	false	true	false	the unique username
121	usernames	username	1.0a100	0	username	false	true	false	the unique username
796	master_hosts	username	1.0a100	1	username	false	false	false	the unique username of the user
800	master_servers	username	1.0a100	1	username	false	false	false	the unique username of the user
802	master_users	username	1.0a100	0	username	false	true	false	the unique username of the user
1316	aoserv_protocols	version	1.0a101	0	string	false	true	true	the unique version number
253	package_definitions	version	1.0a123	4	string	false	false	false	the unique version of this package
2537	httpd_jk_codes	code	1.0a100	0	string	false	true	true	the unique, two-character code
1385	signup_request_options	name	1.23	2	string	false	false	false	the unique-per-request name of the option
2524	httpd_shared_tomcats	unpack_wars	1.80.1	13	boolean	false	false	false	the unpackWARs setting for this Tomcat
2499	httpd_tomcat_std_sites	unpack_wars	1.80.1	5	boolean	false	false	false	the unpackWARs setting for this Tomcat
829	mysql_db_users	update_priv	1.0a100	5	boolean	false	false	false	the UPDATE privilege
860	mysql_users	update_priv	1.0a100	3	boolean	false	false	false	the UPDATE privilege to all databases
356	technology_names	home_page_url	1.0a100	5	url	true	false	true	the URL of the technology home page
929	net_binds	monitoring_parameters	1.58	7	string	true	false	false	the URL-encoded name=value pairs of monitoring parameters
2484	httpd_tomcat_contexts	use_naming	1.0a100	10	boolean	false	false	false	the useNaming attribute
1606	httpd_sites	linux_account	1.81.22	5	linux_username	false	false	false	the user the site "runs as"
889	mysql_server_users	username	1.80.0	1	mysql_username	false	false	false	the username
1249	postgres_server_users	username	1.80.0	1	postgres_username	false	false	false	the username as found in postgres_users
1429	signup_requests	ba_username	1.23	27	username	false	false	false	the username of the administrator
770	business_administrator_permissions	username	1.21	1	username	false	false	false	the username of the administrator with this permission
1155	credit_card_transactions	capture_username	1.29	74	username	true	false	false	the username of the business_administrator account that processed the capture
1131	credit_card_transactions	authorization_username	1.29	50	username	false	false	false	the username of the business_administrator account that processed the transaction
1163	credit_card_transactions	void_username	1.29	82	username	true	false	false	the username of the business_administrator account that processed the void
857	mysql_users	username	1.80.0	0	mysql_username	false	true	false	the username of the MySQL user
1438	signup_requests	completed_by	1.23	35	username	true	false	false	the username of the person who completed this sign-up request
1241	postgres_users	username	1.80.0	0	postgres_username	false	true	false	the username of the user
546	ftp_guest_users	username	1.81.22	0	linux_username	false	true	false	the username that is a guest user
734	linux_accounts	shell	1.0a100	6	path	false	false	false	the users shell preference
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
496	sendmail_servers	delay_la	1.81.10	10	int	true	false	false	the value for confDELAY_LA
499	sendmail_servers	max_daemon_children	1.81.10	13	int	true	false	false	the value for confMAX_DAEMON_CHILDREN
502	sendmail_servers	max_message_size	1.81.10	16	int	true	false	false	the value for confMAX_MESSAGE_SIZE
494	sendmail_servers	max_queue_children	1.81.10	8	int	true	false	false	the value for confMAX_QUEUE_CHILDREN
503	sendmail_servers	min_free_blocks	1.81.10	17	int	true	false	false	the value for confMIN_FREE_BLOCKS
495	sendmail_servers	nice_queue_run	1.81.10	9	int	true	false	false	the value for confNICE_QUEUE_RUN
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
1386	signup_request_options	value	1.23	3	string	true	false	false	the value of the option
470	majordomo_versions	version	1.0a100	0	string	false	true	true	the version number
16	businesses	contract_version	1.0a100	1	string	true	false	false	the version number of the contract
359	technology_versions	version	1.0a100	2	string	false	false	true	the version number of the package in #.##.##-## format
464	majordomo_servers	version	1.0a100	3	string	false	false	false	the version of Majordomo to use
1532	httpd_servers	mod_php_version	1.0a102	6	fkey	true	false	false	the version of mod_php to run
968	servers	operating_system_version	1.31	3	fkey	true	false	false	the version of operating system running on the server, if known
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
1227	postgres_encodings	postgres_version	1.0a100	2	fkey	false	false	true	the version of PostgreSQL
362	technology_versions	operating_system_version	1.0a108	5	fkey	true	false	true	the version of the OS that this packages is installed
2531	httpd_tomcat_sites	version	1.0a100	1	fkey	false	false	false	the version of tomcat that is being ran
585	virtual_disks	virtual_server	1.36	1	fkey	false	false	false	the virtual server this disk belongs to
1591	RewriteRule	virtualHost	1.81.21	1	fkey	false	false	false	the VirtualHost this rule is applied to
1165	credit_card_transactions	void_communication_result	1.29	84	string	true	false	false	the void communication result
1183	credit_card_processors	weight	1.29	8	int	false	false	false	the weight used for multi-processor weighted transaction distribution
353	technology_names	image_width	1.0a100	2	int	true	false	true	the width of the image
39	business_administrators	work_phone	1.0a100	8	phone	false	false	false	the work phone number (if different than business)
730	linux_accounts	office_phone	1.69	3	gecos	true	false	false	the work phone number of the user
2487	httpd_tomcat_contexts	work_dir	1.0a100	13	path	true	false	false	the workDir attribute
2485	httpd_tomcat_contexts	wrapper_class	1.0a100	11	string	true	false	false	the wrapperClass attribute
112	business_profiles	zip	1.69	12	string	true	false	false	the zip code
53	business_administrators	zip	1.69	18	string	true	false	false	the zip code (if different than business)
1428	signup_requests	ba_zip	1.69	26	string	true	false	false	the zip code of the administrator
1407	signup_requests	business_zip	1.69	13	string	true	false	false	the zip code of the business
365	dns_forbidden_zones	zone	1.0a100	0	zone	false	true	true	the zone (domain) that is forbidden
394	dns_zones	zone	1.0a100	0	zone	false	true	false	the zone (domain) that is hosted
367	dns_records	zone	1.0a100	1	zone	false	false	false	the zone as found in dns_zones
803	master_users	is_active	1.0a100	1	boolean	false	false	false	this level of access may be disabled
2492	httpd_tomcat_site_jk_mounts	mount	1.81.6	3	boolean	false	false	false	true for JkMount, false for JkUnMount
928	net_binds	monitoring_enabled	1.0a104	6	boolean	false	false	false	turns on monitoring of the port
2504	httpd_shared_tomcats	name	1.0a100	1	string	false	false	false	unique name for this jvm
1245	postgres_users	catupd	1.0a100	4	boolean	false	false	false	usecatupd flag
1242	postgres_users	createdb	1.0a100	1	boolean	false	false	false	usecreatedb flag
56	business_administrators	support_code	1.44	21	string	true	true	false	used to authenticate for email-based supprt
1244	postgres_users	super	1.0a100	3	boolean	false	false	false	usesuper flag
1243	postgres_users	trace	1.0a100	2	boolean	false	false	false	usetrace flag
2454	httpd_jboss_versions	tomcat_version	1.0a100	1	fkey	false	false	true	version of tomcat associated with this jboss version
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

TABLE NAME

DESCRIPTION

TABLE ROWS