Public Table: Schema Columns

id	table	name	sinceVersion	index	type	isNullable	isUnique	isPublic	description
662	ao_server_daemon_hosts	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
663	ao_server_daemon_hosts	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the ao_server
665	ao_server_daemon_hosts	host	1.80.0	2	hostname	false	false	false	the hostname or IP address that is allowed to connect
695	ao_servers	server	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	a reference to servers
708	ao_servers	hostname	1.69	1	domain_name	false	true	false	the unique hostname of the server
709	ao_servers	daemon_bind	1.0a100	2	fkey	true	false	false	the network bind info for the AOServ Daemon
712	ao_servers	pool_size	1.0a100	3	int	false	false	false	the recommended connection pool size for the AOServ Master
713	ao_servers	distro_hour	1.0a100	4	int	false	false	false	the hour the distribution will occur, in server time zone
714	ao_servers	last_distro_time	1.0a100	5	time	true	false	false	the time the last distro check was started
715	ao_servers	failover_server	1.0a100	6	fkey	true	false	false	the server that is currently running this server
720	ao_servers	daemonDeviceId	1.81.18	7	string	false	false	false	the device name the master connects to
728	ao_servers	daemon_connect_bind	1.0a119	8	fkey	true	false	false	the bind to connect to
729	ao_servers	time_zone	1.2	9	string	true	false	false	the time zone setting for the server
730	ao_servers	jilter_bind	1.7	10	fkey	true	false	false	the bind that sendmail uses to connect to jilter
731	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
733	ao_servers	daemon_connect_address	1.69	12	hostname	true	false	false	provides a specific hostname or address to use for connecting to AOServDaemon
734	ao_servers	failover_batch_size	1.12	13	int	false	false	false	the batch size used for failover replications coming from this server
735	ao_servers	monitoring_load_low	1.35	14	float	true	false	false	the 5-minute load average that will trigger a low-level alert
736	ao_servers	monitoring_load_medium	1.35	15	float	true	false	false	the 5-minute load average that will trigger a medium-level alert
737	ao_servers	monitoring_load_high	1.35	16	float	true	false	false	the 5-minute load average that will trigger a high-level alert
738	ao_servers	monitoring_load_critical	1.35	17	float	true	false	false	the 5-minute load average that will trigger a critical-level alert
740	ao_servers	uidMin	1.81.18	18	linux_id	false	false	false	the min value for automatic uid selection in useradd
742	ao_servers	gidMin	1.81.18	19	linux_id	false	false	false	the min value for automatic gid selection in groupadd
743	ao_servers	uidMax	1.81.18	20	linux_id	false	false	false	the max value for automatic uid selection in useradd
744	ao_servers	gidMax	1.81.18	21	linux_id	false	false	false	the max value for automatic gid selection in groupadd
745	ao_servers	lastUid	1.81.18	22	linux_id	true	false	false	the last value for automatic uid selection in useradd, if any
746	ao_servers	lastGid	1.81.18	23	linux_id	true	false	false	the last value for automatic gid selection in groupadd, if any
747	ao_servers	sftp_umask	1.81.5	24	octal_long	true	false	false	the optional umask for the sftp-server
802	aoserv_permissions	name	1.21	0	string	false	true	true	the unique name of the permission
803	aoserv_permissions	sort_order	1.21	1	short	false	true	true	the sort order for the permission
1352	aoserv_protocols	version	1.0a101	0	string	false	true	true	the unique version number
1353	aoserv_protocols	created	1.0a101	1	date	false	false	true	the time the version was added
1354	aoserv_protocols	comments	1.0a101	2	string	false	false	true	any comments about this version
1356	aoserv_protocols	lastUsed	1.81.18	3	date	true	false	true	the date this protocol was last used
129	aosh_commands	command	1.0a100	0	string	false	true	true	the unique command
131	aosh_commands	sinceVersion	1.92.2.3-SNAPSHOT	1	enum	false	false	true	the first aoserv_protocol version having this command
133	aosh_commands	lastVersion	1.92.2.3-SNAPSHOT	2	enum	true	false	true	the last aoserv_protocol version having this command
135	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
137	aosh_commands	description	1.81.18	4	string	false	false	true	a short description of the command
138	aosh_commands	syntax	1.0a100	5	string	false	false	true	the syntax of the command
337	architectures	name	1.0a100	0	string	false	true	true	the unique name of the architecture
338	architectures	bits	1.0a108	1	int	false	false	true	the number of bits used by the architecture
141	backup_partitions	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
142	backup_partitions	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server that stores the backup data
144	backup_partitions	path	1.0a100	2	path	false	false	false	the full path to the root of the backup data
147	backup_partitions	enabled	1.0a100	3	boolean	false	false	false	flags the partition as currently accepting new data
149	backup_reports	pkey	1.0a101	0	pkey	false	true	false	a generated primary key
150	backup_reports	server	1.0a101	1	fkey	false	false	false	the pkey of the server being backed-up
151	backup_reports	package	1.0a101	2	fkey	false	false	false	the pkey of the package the data is assigned to
152	backup_reports	date	1.0a101	3	date	false	false	false	the date the summary is for
153	backup_reports	file_count	1.0a101	4	int	false	false	false	the number of files belong to this package on this server
156	backup_reports	disk_size	1.0a101	5	long	false	false	false	the total number of bytes of disk space used
157	backup_retentions	days	1.0a100	0	short	false	true	true	the number of days to keep the backup data
158	backup_retentions	display	1.0a100	1	string	false	false	true	the text displayed for this time increment
62	bank_accounts	name	1.0a100	0	string	false	true	false	the unique name of this account
63	bank_accounts	display	1.0a100	1	string	false	false	false	the display name of this account
64	bank_accounts	bank	1.0a100	2	string	false	false	false	the bank the account is with
66	bank_accounts	depositDelay	1.81.18	3	int	false	false	false	the number of business days it takes for a deposit to be sent to the bank account
68	bank_accounts	withdrawalDelay	1.81.18	4	int	false	false	false	the number of business days it takes for a withdrawal to be taken from the bank account
89	bank_transaction_types	name	1.81.18	0	string	false	true	false	the name of the type
90	bank_transaction_types	display	1.0a100	1	string	false	false	false	the display value for the type
91	bank_transaction_types	description	1.0a100	2	string	false	false	false	a description of the type
93	bank_transaction_types	isNegative	1.81.18	3	boolean	false	false	false	if true the amount must be negative
71	bank_transactions	id	1.81.18	0	pkey	false	true	false	a unique identifier for the transaction
72	bank_transactions	time	1.0a100	1	time	false	false	false	the time the transaction occured
76	bank_transactions	account	1.81.18	2	string	false	false	false	the account the transaction is for
78	bank_transactions	processor	1.29	3	string	true	false	false	the credit card processor used by this transaction
79	bank_transactions	administrator	1.0a100	4	username	false	false	false	the business_administrator who made this transaction
80	bank_transactions	type	1.0a100	5	string	false	false	false	the type of transaction
82	bank_transactions	expenseCategory	1.81.18	6	string	true	false	false	the category in which this expense belongs
83	bank_transactions	description	1.0a100	7	string	false	false	false	a description of the transaction
85	bank_transactions	checkNo	1.81.18	8	string	true	false	false	the check number (if available)
86	bank_transactions	amount	1.0a100	9	decimal_2	false	false	false	the amount (negative for withdrawal)
87	bank_transactions	confirmed	1.0a100	10	boolean	false	false	false	the confirmation status with bank
69	banks	name	1.0a100	0	string	false	true	false	the unique name of the bank
70	banks	display	1.0a100	1	string	false	false	false	the name that is displayed
416	blackhole_email_addresses	email_address	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the primary key of the email_address
1299	brands	accounting	1.44	0	accounting	false	true	false
1301	brands	nameserver1	1.69	1	domain_name	false	false	false
1303	brands	nameserver2	1.69	2	domain_name	false	false	false
1305	brands	nameserver3	1.69	3	domain_name	true	false	false
1307	brands	nameserver4	1.69	4	domain_name	true	false	false
1308	brands	smtp_linux_server_account	1.44	5	fkey	false	true	false
1309	brands	smtp_host	1.46	6	hostname	true	false	false
1310	brands	smtp_password	1.44	7	string	false	false	false
1311	brands	imap_linux_server_account	1.44	8	fkey	false	true	false
1312	brands	imap_host	1.46	9	hostname	true	false	false
1313	brands	imap_password	1.44	10	string	false	false	false
1314	brands	support_email_address	1.44	11	fkey	false	true	false
1315	brands	support_email_display	1.44	12	string	false	true	false
1316	brands	signup_email_address	1.44	13	fkey	false	true	false
1317	brands	signup_email_display	1.44	14	string	false	true	false
1318	brands	ticket_encryption_from	1.44	15	fkey	false	false	false
1319	brands	ticket_encryption_recipient	1.44	16	fkey	false	false	false
1320	brands	signup_encryption_from	1.44	17	fkey	false	false	false
1321	brands	signup_encryption_recipient	1.44	18	fkey	false	false	false
1323	brands	support_toll_free	1.69	19	phone	true	false	false
1325	brands	support_day_phone	1.69	20	phone	true	false	false
1327	brands	support_emergency_phone1	1.69	21	phone	true	false	false
1329	brands	support_emergency_phone2	1.69	22	phone	true	false	false
1331	brands	support_fax	1.69	23	phone	true	false	false
1332	brands	support_mailing_address1	1.44	24	string	true	false	false
1333	brands	support_mailing_address2	1.44	25	string	true	false	false
1334	brands	support_mailing_address3	1.44	26	string	true	false	false
1335	brands	support_mailing_address4	1.44	27	string	true	false	false
1336	brands	english_enabled	1.44	28	boolean	false	false	false
1337	brands	japanese_enabled	1.44	29	boolean	false	false	false
1338	brands	aoweb_struts_http_url_base	1.44	30	string	false	false	false
1339	brands	aoweb_struts_https_url_base	1.44	31	string	false	false	false
1340	brands	aoweb_struts_google_verify_content	1.44	32	string	true	false	false
1341	brands	aoweb_struts_noindex	1.44	33	boolean	false	false	false
1342	brands	aoweb_struts_google_analytics_new_tracking_code	1.44	34	string	true	false	false
1343	brands	aoweb_struts_signup_admin_address	1.44	35	string	false	false	false
1344	brands	aoweb_struts_vnc_bind	1.52	36	fkey	false	true	false
1345	brands	aoweb_struts_keystore_type	1.53	37	string	false	false	false
1346	brands	aoweb_struts_keystore_password	1.53	38	string	false	false	false
29	business_administrators	username	1.0a100	0	username	false	true	false	the unique identifier for this admin
31	business_administrators	password	1.69	1	hashed_password	true	false	false	the encrypted password for this admin
32	business_administrators	name	1.0a100	2	string	false	false	false	the name of this admin
33	business_administrators	title	1.0a100	3	string	true	false	false	the admins title within their organization
35	business_administrators	birthday	1.69	4	date	true	false	false	the admins birthday
36	business_administrators	is_preferred	1.0a100	5	boolean	false	false	false	if true, customers is preferred
37	business_administrators	private	1.0a100	6	boolean	false	false	false	indicates if the admin should not be listed in publicly available lists
38	business_administrators	created	1.0a100	7	time	false	false	false	the time the admin entry was created
39	business_administrators	work_phone	1.0a100	8	phone	false	false	false	the work phone number (if different than business)
40	business_administrators	home_phone	1.0a100	9	phone	true	false	false	the home phone number
41	business_administrators	cell_phone	1.0a100	10	phone	true	false	false	the cellular phone number
42	business_administrators	fax	1.0a100	11	phone	true	false	false	the fax number (if different than business)
43	business_administrators	email	1.0a100	12	email	false	false	false	the email address
44	business_administrators	address1	1.0a100	13	string	true	false	false	the street address (if different than business)
45	business_administrators	address2	1.0a100	14	string	true	false	false	the street address (if different than business)
47	business_administrators	city	1.69	15	string	true	false	false	the city (if different than business)
49	business_administrators	state	1.69	16	string	true	false	false	the state (if different than business)
51	business_administrators	country	1.69	17	string	true	false	false	the country (if different than business)
53	business_administrators	zip	1.69	18	string	true	false	false	the zip code (if different than business)
54	business_administrators	disable_log	1.0a100	19	fkey	true	false	false	indicates that this account is disabled
55	business_administrators	can_switch_users	1.0a118	20	boolean	false	false	false	allows this person to switch users to any subaccounts
56	business_administrators	support_code	1.44	21	string	true	true	false	used to authenticate for email-based supprt
799	business_administrator_permissions	pkey	1.21	0	pkey	false	true	false	a generated primary key
800	business_administrator_permissions	username	1.21	1	username	false	false	false	the username of the administrator with this permission
801	business_administrator_permissions	permission	1.21	2	string	false	false	false	the name of the permission that has been granted
96	business_profiles	pkey	1.0a100	0	pkey	false	true	false	a unique primary key
97	business_profiles	accounting	1.0a100	1	accounting	false	false	false	the accounting code of the business
98	business_profiles	priority	1.0a100	2	int	false	false	false	the highest priority profile is used
99	business_profiles	name	1.0a100	3	string	false	false	false	the name of the business
100	business_profiles	private	1.0a100	4	boolean	false	false	false	indicates if the business should not be listed in publicly available lists
101	business_profiles	phone	1.0a100	5	phone	false	false	false	the phone number
102	business_profiles	fax	1.0a100	6	phone	true	false	false	the fax number
103	business_profiles	address1	1.0a100	7	string	false	false	false	the street address of the business
104	business_profiles	address2	1.0a100	8	string	true	false	false	the street address of the business
106	business_profiles	city	1.69	9	string	false	false	false	the city
108	business_profiles	state	1.69	10	string	true	false	false	the state or providence
110	business_profiles	country	1.69	11	string	false	false	false	the two-character country code
112	business_profiles	zip	1.69	12	string	true	false	false	the zip code
113	business_profiles	send_invoice	1.0a100	13	boolean	false	false	false	indicates to send a monthly invoice via regular mail
114	business_profiles	created	1.0a100	14	time	false	false	false	the time this entry was created
115	business_profiles	billing_contact	1.0a100	15	string	false	false	false	the name to contact for billing information
116	business_profiles	billing_email	1.0a100	16	string	false	false	false	the email address to notify for billing
118	business_profiles	billingEmailFormat	1.92.2.2-SNAPSHOT	17	enum	false	false	false	the format for billing notification emails
119	business_profiles	technical_contact	1.0a100	18	string	false	false	false	the name to contact for technical information
120	business_profiles	technical_email	1.0a100	19	string	false	false	false	the email address to notify for technical
122	business_profiles	technicalEmailFormat	1.92.2.2-SNAPSHOT	20	enum	false	false	false	the format for technical notification emails
15	businesses	accounting	1.0a100	0	accounting	false	true	false	the unique identifier for this business.
16	businesses	contract_version	1.0a100	1	string	true	false	false	the version number of the contract
17	businesses	created	1.0a100	2	time	false	false	false	the time the account was created
18	businesses	canceled	1.0a100	3	time	true	false	false	the time the account was deactivated
19	businesses	cancel_reason	1.0a100	4	string	true	false	false	the reason the account was canceled
20	businesses	parent	1.0a100	5	accounting	true	false	false	the parent business to this one
21	businesses	can_add_backup_server	1.0a102	6	boolean	false	false	false	the business may add servers to the backup system
22	businesses	can_add_businesses	1.0a100	7	boolean	false	false	false	if <code>true</code> this business can create and be the parent of other businesses
24	businesses	can_see_prices	1.0a103	8	boolean	false	false	false	if <code>false</code>, prices are filtered
25	businesses	disable_log	1.0a100	9	fkey	true	false	false	indicates the business is disabled
26	businesses	do_not_disable_reason	1.0a100	10	string	true	false	false	a reason why we should not disable the account
27	businesses	auto_enable	1.0a100	11	boolean	false	false	false	allows the account to be automatically reenabled on payment
28	businesses	bill_parent	1.0a100	12	boolean	false	false	false	if <code>true</code>, the parent business will be charged for all resources used by this account
1	business_servers	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
2	business_servers	accounting	1.0a100	1	accounting	false	false	false	the business
3	business_servers	server	1.0a100	2	fkey	false	false	false	the server
4	business_servers	is_default	1.0a100	3	boolean	false	false	false	if <code>true</code>, this is the default server.
6	business_servers	can_control_apache	1.0a100	4	boolean	false	false	false
7	business_servers	can_control_cron	1.0a100	5	boolean	false	false	false
9	business_servers	can_control_mysql	1.0a100	6	boolean	false	false	false
10	business_servers	can_control_postgresql	1.0a100	7	boolean	false	false	false
11	business_servers	can_control_xfs	1.0a100	8	boolean	false	false	false
12	business_servers	can_control_xvfb	1.0a100	9	boolean	false	false	false
13	business_servers	can_vnc_console	1.51	10	boolean	false	false	false
14	business_servers	can_control_virtual_server	1.64	11	boolean	false	false	false
1045	country_codes	code	1.69	0	string	false	true	true	the two-character code for the country
1046	country_codes	name	1.0a100	1	string	false	false	true	the name of the country
1047	country_codes	charge_com_supported	1.0a100	2	boolean	false	false	true	if the country is supported by Charge.Com
1048	country_codes	charge_com_name	1.0a100	3	string	true	false	true	the Charge.Com specific name
1209	credit_card_processors	provider_id	1.29	0	string	false	true	false	the unique ID of this processor
1210	credit_card_processors	accounting	1.29	1	accounting	false	false	false	the accounting code of the business owning the merchant account
1211	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
1212	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
1213	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
1214	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
1215	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
1216	credit_card_processors	enabled	1.29	7	boolean	false	false	false	the enabled flag
1217	credit_card_processors	weight	1.29	8	int	false	false	false	the weight used for multi-processor weighted transaction distribution
1218	credit_card_processors	description	1.29	9	string	true	false	false	an optional description of the processor
1219	credit_card_processors	encryption_from	1.31	10	fkey	false	false	false	the from that will be used for encryption
1220	credit_card_processors	encryption_recipient	1.31	11	fkey	false	false	false	the recipient that will be used for encryption
1098	credit_card_transactions	pkey	1.29	0	pkey	false	true	false	the unique ID of this transaction
1099	credit_card_transactions	processor_id	1.29	1	string	false	false	false	the name of the processor used for this transaction
1100	credit_card_transactions	accounting	1.29	2	accounting	false	false	false	the accounting code for the source of this transaction
1101	credit_card_transactions	group_name	1.29	3	string	true	false	false	the application-provided grouping for this transaction
1102	credit_card_transactions	test_mode	1.29	4	boolean	false	false	false	indicates this is a test transaction
1103	credit_card_transactions	duplicate_window	1.29	5	int	false	false	false	the number of seconds for duplicate transaction detection
1104	credit_card_transactions	order_number	1.29	6	string	true	false	false	the merchant-provided order number for this transaction
1108	credit_card_transactions	amount	1.83.0	7	money	false	false	false	the amount of the transaction
1111	credit_card_transactions	taxAmount	1.83.0	8	money	true	false	false	the tax amount of the transaction
1112	credit_card_transactions	tax_exempt	1.29	9	boolean	false	false	false	the taxExempt flag for this transaction
1115	credit_card_transactions	shippingAmount	1.83.0	10	money	true	false	false	the shipping amount for this transaction
1118	credit_card_transactions	dutyAmount	1.83.0	11	money	true	false	false	the duty amount for this transaction
1119	credit_card_transactions	shipping_first_name	1.29	12	string	true	false	false	the shipping first name
1120	credit_card_transactions	shipping_last_name	1.29	13	string	true	false	false	the shipping last name
1121	credit_card_transactions	shipping_company_name	1.29	14	string	true	false	false	the shipping company name
1122	credit_card_transactions	shipping_street_address1	1.29	15	string	true	false	false	the shipping address line 1
1123	credit_card_transactions	shipping_street_address2	1.29	16	string	true	false	false	the shipping address line 2
1125	credit_card_transactions	shipping_city	1.69	17	string	true	false	false	the shipping city
1127	credit_card_transactions	shipping_state	1.69	18	string	true	false	false	the shipping state
1129	credit_card_transactions	shipping_postal_code	1.69	19	string	true	false	false	the shipping postal code
1131	credit_card_transactions	shipping_country_code	1.69	20	string	true	false	false	the shipping two-digit ISO 3166-1 alpha-2 country code
1132	credit_card_transactions	email_customer	1.29	21	boolean	false	false	false	the flag indicating the API should generate an email to the customer
1133	credit_card_transactions	merchant_email	1.29	22	email	true	false	false	the email address of the merchant
1134	credit_card_transactions	invoice_number	1.29	23	string	true	false	false	the merchant-provided invoice number
1135	credit_card_transactions	purchase_order_number	1.29	24	string	true	false	false	the merchant-provided purchase order number
1136	credit_card_transactions	description	1.29	25	string	true	false	false	the merchant-provided description of this transaction
1137	credit_card_transactions	credit_card_created_by	1.29	26	username	false	false	false	the business administrator account that provided this credit card
1138	credit_card_transactions	credit_card_principal_name	1.29	27	string	true	false	false	the application-provided principal who provided this credit card
1139	credit_card_transactions	credit_card_accounting	1.29	28	accounting	false	false	false	the accounting code of the business that provided this credit card
1140	credit_card_transactions	credit_card_group_name	1.29	29	string	true	false	false	any application-specific grouping
1141	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
1142	credit_card_transactions	credit_card_masked_card_number	1.29	31	string	false	false	false	the masked card number
1143	credit_card_transactions	creditCard.expirationMonth	1.82.0	32	short	true	false	false	the card expiration month
1144	credit_card_transactions	creditCard.expirationYear	1.82.0	33	short	true	false	false	the card expiration year
1145	credit_card_transactions	credit_card_first_name	1.29	34	string	false	false	false	the first name of the card holder
1146	credit_card_transactions	credit_card_last_name	1.29	35	string	false	false	false	the last name of the card holder
1147	credit_card_transactions	credit_card_company_name	1.29	36	string	true	false	false	the company name for the credit card
1148	credit_card_transactions	credit_card_email	1.29	37	email	true	false	false	the email address of the card holder
1149	credit_card_transactions	credit_card_phone	1.29	38	phone	true	false	false	the phone number of the card holder
1150	credit_card_transactions	credit_card_fax	1.29	39	phone	true	false	false	the fax number of the card holder
1151	credit_card_transactions	creditCard.customerId	1.82.1	40	string	true	false	false	the merchant-specific unique customer ID
1152	credit_card_transactions	credit_card_customer_tax_id	1.29	41	string	true	false	false	the tax ID of the card holder
1153	credit_card_transactions	credit_card_street_address1	1.29	42	string	false	false	false	the street address of the card holder (line 1)
1154	credit_card_transactions	credit_card_street_address2	1.29	43	string	true	false	false	the street address of the card holder (line 2)
1156	credit_card_transactions	credit_card_city	1.69	44	string	false	false	false	the city of the card holder
1158	credit_card_transactions	credit_card_state	1.69	45	string	true	false	false	the state/province/prefecture of the card holder
1160	credit_card_transactions	credit_card_postal_code	1.69	46	string	true	false	false	the postal code of the card holder
1162	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
1163	credit_card_transactions	credit_card_comments	1.29	48	string	true	false	false	any comments associated with the credit card
1164	credit_card_transactions	authorization_time	1.29	49	time	false	false	false	the time the authorization was attempted
1165	credit_card_transactions	authorization_username	1.29	50	username	false	false	false	the username of the business_administrator account that processed the transaction
1166	credit_card_transactions	authorization_principal_name	1.29	51	string	true	false	false	an application-provided identity of the user who initiated the transaction
1167	credit_card_transactions	authorization_communication_result	1.29	52	string	true	false	false	the authorization communication result
1168	credit_card_transactions	authorization_provider_error_code	1.29	53	string	true	false	false	the provider-specific error code
1169	credit_card_transactions	authorization_error_code	1.29	54	string	true	false	false	the provider-neutral error code
1170	credit_card_transactions	authorization_provider_error_message	1.29	55	string	true	false	false	the provider-specific error message
1171	credit_card_transactions	authorization_provider_unique_id	1.29	56	string	true	false	false	the per-provider unique ID
1172	credit_card_transactions	authorizationResult.providerReplacementMaskedCardNumber	1.82.0	57	string	true	false	false	the provider-specific replacement masked card number
1173	credit_card_transactions	authorizationResult.replacementMaskedCardNumber	1.82.0	58	string	true	false	false	the replacement masked card number
1174	credit_card_transactions	authorizationResult.providerReplacementExpiration	1.82.0	59	string	true	false	false	the provider-specific replacement expiration date
1175	credit_card_transactions	authorizationResult.replacementExpirationMonth	1.82.0	60	short	true	false	false	the replacement card expiration month
1176	credit_card_transactions	authorizationResult.replacementExpirationYear	1.82.0	61	short	true	false	false	the replacement card expiration year
1177	credit_card_transactions	authorization_provider_approval_result	1.29	62	string	true	false	false	the provider-specific approval result
1178	credit_card_transactions	authorization_approval_result	1.29	63	string	true	false	false	the provider-neutral approval result
1179	credit_card_transactions	authorization_provider_decline_reason	1.29	64	string	true	false	false	the provider-specific decline reason
1180	credit_card_transactions	authorization_decline_reason	1.29	65	string	true	false	false	the provider-neutral decline reason
1181	credit_card_transactions	authorization_provider_review_reason	1.29	66	string	true	false	false	the provider-specific review reason
1182	credit_card_transactions	authorization_review_reason	1.29	67	string	true	false	false	the provider-neutral review reason
1183	credit_card_transactions	authorization_provider_cvv_result	1.29	68	string	true	false	false	the provider-specific CVV result
1184	credit_card_transactions	authorization_cvv_result	1.29	69	string	true	false	false	the provider-neutral CVV result
1185	credit_card_transactions	authorization_provider_avs_result	1.29	70	string	true	false	false	the provider-specific AVS result
1186	credit_card_transactions	authorization_avs_result	1.29	71	string	true	false	false	the provider-neutral AVS result
1187	credit_card_transactions	authorization_approval_code	1.29	72	string	true	false	false	the approval code
1188	credit_card_transactions	capture_time	1.29	73	time	true	false	false	the time the capture was attempted
1189	credit_card_transactions	capture_username	1.29	74	username	true	false	false	the username of the business_administrator account that processed the capture
1190	credit_card_transactions	capture_principal_name	1.29	75	string	true	false	false	an application-provided identity of the user who initiated the capture
1191	credit_card_transactions	capture_communication_result	1.29	76	string	true	false	false	the capture communication result
1192	credit_card_transactions	capture_provider_error_code	1.29	77	string	true	false	false	the provider-specific error code
1193	credit_card_transactions	capture_error_code	1.29	78	string	true	false	false	the provider-neutral error code
1194	credit_card_transactions	capture_provider_error_message	1.29	79	string	true	false	false	the provider-specific error message
1195	credit_card_transactions	capture_provider_unique_id	1.29	80	string	true	false	false	the per-provider unique ID
1196	credit_card_transactions	void_time	1.29	81	time	true	false	false	the time the void was attempted
1197	credit_card_transactions	void_username	1.29	82	username	true	false	false	the username of the business_administrator account that processed the void
1198	credit_card_transactions	void_principal_name	1.29	83	string	true	false	false	an application-provided identity of the user who initiated the void
1199	credit_card_transactions	void_communication_result	1.29	84	string	true	false	false	the void communication result
1200	credit_card_transactions	void_provider_error_code	1.29	85	string	true	false	false	the provider-specific error code
1201	credit_card_transactions	void_error_code	1.29	86	string	true	false	false	the provider-neutral error code
1202	credit_card_transactions	void_provider_error_message	1.29	87	string	true	false	false	the provider-specific error message
1203	credit_card_transactions	void_provider_unique_id	1.29	88	string	true	false	false	the per-provider unique ID
1204	credit_card_transactions	status	1.29	89	string	false	false	false	the status of the transaction
1049	credit_cards	pkey	1.0a100	0	pkey	false	true	false	primary key value
1050	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
1051	credit_cards	accounting	1.0a100	2	accounting	false	false	false	the accounting code for the card
1052	credit_cards	group_name	1.29	3	string	true	false	false	any application-specific grouping
1054	credit_cards	card_info	1.0a100	4	string	false	false	false	the masked card number
1055	credit_cards	expirationMonth	1.82.0	5	short	true	false	false	the card expiration month
1056	credit_cards	expirationYear	1.82.0	6	short	true	false	false	the card expiration year
1057	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
1061	credit_cards	first_name	1.29	8	string	false	false	false	the first name
1062	credit_cards	last_name	1.29	9	string	false	false	false	the last name
1063	credit_cards	company_name	1.29	10	string	true	false	false	the company name
1064	credit_cards	email	1.29	11	email	true	false	false	the email address
1065	credit_cards	phone	1.29	12	phone	true	false	false	the daytime phone number
1066	credit_cards	fax	1.29	13	phone	true	false	false	the fax number
1067	credit_cards	customerId	1.82.1	14	string	true	false	false	the merchant-specific unique customer ID
1068	credit_cards	customer_tax_id	1.29	15	string	true	false	false	the social security number of employer identification number
1070	credit_cards	street_address1	1.29	16	string	false	false	false	the first line of the street address
1071	credit_cards	street_address2	1.29	17	string	true	false	false	the second line of the street address
1074	credit_cards	city	1.69	18	string	false	false	false	the card holders city
1077	credit_cards	state	1.69	19	string	true	false	false	the card holders state
1080	credit_cards	postal_code	1.69	20	string	true	false	false	the card holders postal code
1082	credit_cards	country_code	1.69	21	string	false	false	false	the two-character country code
1083	credit_cards	created	1.0a100	22	time	false	false	false	the time the card was added to the database
1084	credit_cards	created_by	1.0a100	23	username	false	false	false	the business_administrator who added the card to the database
1085	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
1086	credit_cards	use_monthly	1.0a100	25	boolean	false	false	false	if <code>true</code> the card will be used monthly
1087	credit_cards	active	1.0a100	26	boolean	false	false	false	if <code>true</code> the card is currently active
1088	credit_cards	deactivated_on	1.0a100	27	time	true	false	false	the time the card was deactivated
1089	credit_cards	deactivate_reason	1.0a100	28	string	true	false	false	the reason the card was deactivated
1091	credit_cards	description	1.0a100	29	string	true	false	false	any comment or description
1092	credit_cards	encrypted_card_number	1.31	30	string	true	false	false	the card number stored encrypted
1093	credit_cards	encryption_card_number_from	1.31	31	fkey	true	false	false	the from that was used for card number encryption
1094	credit_cards	encryption_card_number_recipient	1.31	32	fkey	true	false	false	the recipient that was used for card number encryption
213	Currency	currencyCode	1.83.0	0	string	false	true	true	the ISO 4217 currency code of this currency
214	Currency	fractionDigits	1.83.0	1	short	false	false	true	the number of fraction digits used with this currency
215	Currency	autoEnableMinimumPayment	1.83.0	2	money	false	false	true	the minimum payment for auto-enabling accounts
1418	cvs_repositories	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1419	cvs_repositories	path	1.0a100	1	path	false	false	false	the full path to the repository
1420	cvs_repositories	linux_server_account	1.0a100	2	fkey	false	false	false	the pkey of the directory owner
1421	cvs_repositories	linux_server_group	1.0a100	3	fkey	false	false	false	the pkey of the directory group
1422	cvs_repositories	mode	1.0a100	4	octal_long	false	false	false	the directory permissions
1423	cvs_repositories	created	1.0a100	5	time	false	false	false	the time the repository was created
1426	cvs_repositories	disable_log	1.0a100	6	fkey	true	false	false	indicates that this repository is disabled
418	cyrus_imapd_binds	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the IP address, port, and protocol details
419	cyrus_imapd_binds	cyrus_imapd_server	1.81.10	1	fkey	false	false	false	the server that is listening on the address
420	cyrus_imapd_binds	servername	1.81.10	2	domain_name	true	false	false	the servername for this bind
421	cyrus_imapd_binds	certificate	1.81.10	3	fkey	true	false	false	the certificate used by this bind
422	cyrus_imapd_binds	allow_plaintext_auth	1.81.10	4	boolean	true	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
424	cyrus_imapd_servers	ao_server	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the pkey of the server that runs this Cyrus IMAPD instance
425	cyrus_imapd_servers	sieve_net_bind	1.81.10	1	fkey	true	true	false	the port the server binds to for sieve, if enabled
426	cyrus_imapd_servers	servername	1.81.10	2	domain_name	true	false	false	the servername for this server
427	cyrus_imapd_servers	certificate	1.81.10	3	fkey	false	false	false	the certificate used for this server
428	cyrus_imapd_servers	allow_plaintext_auth	1.81.10	4	boolean	false	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
429	cyrus_imapd_servers	delete_duration	1.81.10	5	float	true	false	false	the duration after which delayed delete folders are removed
431	cyrus_imapd_servers	delete_duration_unit	1.92.2.2-SNAPSHOT	6	enum	true	false	false	the time unit for delete_duration, one of "d", "h", "m", "s"
432	cyrus_imapd_servers	expire_duration	1.81.10	7	float	false	false	false	prune the duplicate database of entries older than expire-duration
434	cyrus_imapd_servers	expire_duration_unit	1.92.2.2-SNAPSHOT	8	enum	true	false	false	the time unit for expire_duration, one of "d", "h", "m", "s"
435	cyrus_imapd_servers	expunge_duration	1.81.10	9	float	true	false	false	the duration after which delayed expunge messages are removed
437	cyrus_imapd_servers	expunge_duration_unit	1.92.2.2-SNAPSHOT	10	enum	true	false	false	the time unit for expunge_duration, one of "d", "h", "m", "s"
57	disable_log	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
58	disable_log	time	1.0a100	1	time	false	false	false	the time the stuff was disabled
59	disable_log	accounting	1.0a100	2	accounting	false	false	false	the business whose resources are being disabled
60	disable_log	disabled_by	1.0a100	3	username	false	false	false	the person who disabled the accounts
61	disable_log	disable_reason	1.0a100	4	string	true	false	false	the optional reason the accounts were disabled
1839	distro_file_types	type	1.0a100	0	string	false	true	false	the unique name of the type
1840	distro_file_types	description	1.0a100	1	string	false	false	false	a description of the type of file
1819	distro_files	pkey	1.0a108	0	pkey	false	true	false	the unique pkey
1820	distro_files	operating_system_version	1.0a108	1	fkey	false	false	false	the OS version that contains the file
1822	distro_files	path	1.0a108	2	path	false	false	false	the full path to the file
1823	distro_files	optional	1.0a100	3	boolean	false	false	false	if the file is optional
1824	distro_files	type	1.0a100	4	string	false	false	false	the type of file
1825	distro_files	mode	1.0a100	5	octal_long	false	false	false	the mode (including file type bits)
1827	distro_files	linux_account	1.81.22	6	linux_username	false	false	false	the owner of the file
1829	distro_files	linux_group	1.80.0	7	group_id	false	false	false	the group of the file
1830	distro_files	size	1.0a100	8	long	true	false	false	the length of the file
1834	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
1835	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
1836	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
1837	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
1838	distro_files	symlink_target	1.0a100	13	string	true	false	false	the target if is a symbolic link
1841	distro_report_types	name	1.70	0	string	false	true	false	the unique name of the type
1842	distro_report_types	display	1.70	1	string	false	false	false	a display value of the type of report
370	dns_forbidden_zones	zone	1.0a100	0	zone	false	true	true	the zone (domain) that is forbidden
371	dns_records	pkey	1.0a100	0	pkey	false	true	false	a generated pkey
372	dns_records	zone	1.0a100	1	zone	false	false	false	the zone as found in dns_zones
374	dns_records	domain	1.69	2	string	false	false	false	the first column in the zone files
375	dns_records	type	1.0a100	3	string	false	false	false	the type as found in dns_types
377	dns_records	priority	1.72	4	int	true	false	false	the priority for the entry
378	dns_records	weight	1.72	5	int	true	false	false	the relative weight for records with the same priority
379	dns_records	port	1.72	6	int	true	false	false	the TCP or UDP port on which the service is to be found
380	dns_records	flag	1.86.0	7	short	true	false	false	the CAA flag
381	dns_records	tag	1.86.0	8	string	true	false	false	the CAA tag
382	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
385	dns_records	dhcpAddress	1.81.18	10	fkey	true	false	false	the id of the IP address whos changes are followed
386	dns_records	ttl	1.0a127	11	int	true	false	false	the time to live field
397	dns_tlds	domain	1.69	0	domain_name	false	true	true	the domain
398	dns_tlds	description	1.0a100	1	string	false	false	true
387	dns_types	type	1.0a100	0	string	false	true	true	the type
388	dns_types	description	1.0a100	1	string	false	false	true	the description of the type
390	dns_types	has_priority	1.72	2	boolean	false	false	true	flags which types have a priority
391	dns_types	has_weight	1.72	3	boolean	false	false	true	flags which types have a weight
392	dns_types	has_port	1.72	4	boolean	false	false	true	flags which types have a port
393	dns_types	has_flag	1.86.0	5	boolean	false	false	true	flags which types have a flag
394	dns_types	has_tag	1.86.0	6	boolean	false	false	true	flags which types have a tag
395	dns_types	param_ip	1.0a100	7	boolean	false	false	true	flags if the parameter is a IP or a hostname
399	dns_zones	zone	1.0a100	0	zone	false	true	false	the zone (domain) that is hosted
400	dns_zones	file	1.0a100	1	string	false	false	false	the filename of the zone file
402	dns_zones	package	1.80.0	2	accounting	false	false	false	the package that owns the zones
403	dns_zones	hostmaster	1.0a100	3	string	false	false	false	the email address of the person in charge of the domain
404	dns_zones	serial	1.0a100	4	long	false	false	false	the ever-incrementing serial number for the file
405	dns_zones	ttl	1.0a127	5	int	false	false	false
406	email_addresses	pkey	1.0a100	0	pkey	false	true	false	the primary key
407	email_addresses	address	1.0a100	1	string	false	false	false	address before the @
408	email_addresses	domain	1.0a100	2	fkey	false	false	false	the pkey of the email domain
409	email_attachment_blocks	pkey	1.0a116	0	pkey	false	true	false	a unique, generated primary key
410	email_attachment_blocks	linux_server_account	1.0a116	1	fkey	false	false	false	reference to the email inbox
411	email_attachment_blocks	extension	1.0a116	2	string	false	false	false	the extension of the blocked files
412	email_attachment_types	extension	1.0a116	0	string	false	true	true	the unique filename extension
413	email_attachment_types	description	1.0a116	1	string	false	false	true	a brief description of the attachment type
414	email_attachment_types	is_default_block	1.0a116	2	boolean	false	false	true	indicates that the type will be blocked by default
438	DkimKey	id	1.92.2-SNAPSHOT	0	pkey	false	true	false	The generated primary key.
439	DkimKey	domain	1.92.2-SNAPSHOT	1	fkey	false	false	false	The email domain for this key.
440	DkimKey	selector	1.92.2-SNAPSHOT	2	domain_label	false	false	false	The per-domain unique name.
441	DkimKey	created	1.92.2-SNAPSHOT	3	time	false	false	false	The time this key was added.
443	DkimKey	status	1.92.2.2-SNAPSHOT	4	enum	false	false	false	The current status, one of "new", "signing", "old", "removal". Only one may be "signing" per domain.
444	DkimKey	statusTime	1.92.2-SNAPSHOT	5	time	false	false	false	The time at last status change.
445	DkimKey	dnsRecord	1.92.2-SNAPSHOT	6	fkey	true	true	false	The DNS record associated with this key. May be <code>null</code> when DNS hosted elsewhere.
446	DkimKey	dnsConfirmed	1.92.2-SNAPSHOT	7	time	true	false	false	The time DNS TXT presence and correctness was confirmed. Required for statuses "signing" and "old".
447	email_domains	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
449	email_domains	domain	1.69	1	domain_name	false	false	false	the domain that is hosted in the email
450	email_domains	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server that is hosting the email
452	email_domains	package	1.80.0	3	accounting	false	false	false	the owner of the domain
453	email_domains	dkimDisableReason	1.92.2.1-SNAPSHOT	4	string	true	false	false	The reason DKIM is disabled on this domain or <code>null</code> when enabled.
454	email_forwarding	pkey	1.0a100	0	pkey	false	true	false	a generated, unique key
455	email_forwarding	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
456	email_forwarding	destination	1.0a100	2	email	false	false	false	the destination of the email
461	email_list_addresses	pkey	1.0a100	0	pkey	false	true	false
462	email_list_addresses	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
463	email_list_addresses	email_list	1.0a100	2	fkey	false	false	false	the pkey of the email list
464	email_lists	pkey	1.0a100	0	pkey	false	true	false	a generated, unique primary key
465	email_lists	path	1.0a100	1	path	false	false	false	the complete path to the email list
467	email_lists	linux_server_account	1.31	2	fkey	false	false	false	the linux_server_account that owns the list
469	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
472	email_lists	disable_log	1.0a100	4	fkey	true	false	false	indicates that this list is disabled
495	email_pipe_addresses	pkey	1.0a100	0	pkey	false	true	false	a generated, unique key
496	email_pipe_addresses	email_address	1.0a100	1	fkey	false	false	false	the primary key of the email_address
497	email_pipe_addresses	email_pipe	1.0a100	2	fkey	false	false	false	the primary key of the email pipe
498	email_pipes	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
499	email_pipes	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the program resides on
501	email_pipes	command	1.80.0	2	string	false	false	false	the complete command string to the email handling program
503	email_pipes	package	1.80.0	3	accounting	false	false	false	the package that this program runs for
504	email_pipes	disable_log	1.0a100	4	fkey	true	false	false	indicates that this email pipe is disabled
544	email_smtp_relay_types	name	1.0a100	0	string	false	true	true	the name of the type
545	email_smtp_relay_types	sendmail_config	1.0a100	1	string	false	false	true	the config value used for sendmail
546	email_smtp_relay_types	qmail_config	1.0a100	2	string	false	false	true	the config value used for qmail
532	email_smtp_relays	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
534	email_smtp_relays	package	1.80.0	1	accounting	false	false	false	the package that owns this entry
535	email_smtp_relays	ao_server	1.0a100	2	fkey	true	false	false	the pkey of the server that the rule applies to
537	email_smtp_relays	host	1.69	3	hostname	false	false	false	the hostname or IP the rule applies to
538	email_smtp_relays	type	1.0a100	4	string	false	false	false	the type of entry
539	email_smtp_relays	created	1.0a100	5	time	false	false	false	the time the entry was created
540	email_smtp_relays	last_refreshed	1.0a100	6	time	false	false	false	the time the entry was last updated
541	email_smtp_relays	refresh_count	1.0a100	7	int	false	false	false	the number of times the entry has been updated
542	email_smtp_relays	expiration	1.0a100	8	time	true	false	false	the expiration time of the entry, or null if non-expiring
543	email_smtp_relays	disable_log	1.0a100	9	fkey	true	false	false	indicates that the rule is disabled
547	email_smtp_smart_host_domains	pkey	1.57	0	pkey	false	true	false	a generated unique key
548	email_smtp_smart_host_domains	smart_host	1.57	1	fkey	false	false	false	the Smart Host that is being configured
550	email_smtp_smart_host_domains	domain	1.69	2	domain_name	false	false	false	the specific domain that is being configured
551	email_smtp_smart_host_domains	domain_out_burst	1.57	3	int	true	false	false	the domain-specific email burst limit, null means unlimited
552	email_smtp_smart_host_domains	domain_out_rate	1.57	4	float	true	false	false	the domain-specific email rate, null means unlimited
554	email_smtp_smart_hosts	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	a reference to the port that is being used as a Smart Host
555	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
556	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
557	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
558	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
559	email_sa_integration_modes	name	1.0a120	0	string	false	true	true	the unique name of the mode
560	email_sa_integration_modes	display	1.0a120	1	string	false	false	true	the display value for the mode
561	email_sa_integration_modes	sort_order	1.0a120	2	int	false	false	true
1239	encryption_keys	pkey	1.23	0	pkey	false	true	false	a generated unique id
1240	encryption_keys	accounting	1.23	1	accounting	false	false	false	the accounting code of the business that owns this key
1241	encryption_keys	id	1.23	2	string	false	false	false	the id of the recipient who may decrypt the message
95	expense_categories	name	1.81.18	0	string	false	true	false	a simple code used as primary key
159	failover_file_log	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
160	failover_file_log	replication	1.0a100	1	fkey	false	false	false	the replication that was performed
161	failover_file_log	start_time	1.0a100	2	time	false	false	false	the time the replication started
162	failover_file_log	end_time	1.0a100	3	time	false	false	false	the time the replication finished
163	failover_file_log	scanned	1.0a100	4	int	false	false	false	the number of files scanned
164	failover_file_log	updated	1.0a100	5	int	false	false	false	the number of files updated
165	failover_file_log	bytes	1.0a100	6	long	false	false	false	the number of bytes transferred
166	failover_file_log	is_successful	1.0a100	7	boolean	false	false	false	keeps track of which passes completed successfully
172	failover_file_replications	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
174	failover_file_replications	server	1.31	1	fkey	false	false	false	the pkey of the server that the files are coming from
176	failover_file_replications	backup_partition	1.31	2	fkey	false	false	false	the pkey of the backup partition that the files are going to
178	failover_file_replications	max_bit_rate	1.61	3	long	true	false	false	the maximum bit rate for files being replicated
180	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
181	failover_file_replications	retention	1.13	5	short	false	false	false	the number of days backups will be kept
183	failover_file_replications	connect_address	1.69	6	hostname	true	false	false	an address or hostname that overrides regular AOServ connections for failovers
185	failover_file_replications	connect_from	1.69	7	ip_address	true	false	false	an address that overrides regular AOServ connection source addresses for failovers
186	failover_file_replications	enabled	1.15	8	boolean	false	false	false	the enabled flag for failovers
191	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
167	failover_file_schedule	pkey	1.0a100	0	pkey	false	true	false	a generated, unique id
168	failover_file_schedule	replication	1.0a100	1	fkey	false	false	false	the replication that will be started
169	failover_file_schedule	hour	1.0a100	2	short	false	false	false	the hour of day (in server timezone)
170	failover_file_schedule	minute	1.31	3	short	false	false	false	the minute (in server timezone)
171	failover_file_schedule	enabled	1.0a100	4	boolean	false	false	false
202	failover_mysql_replications	pkey	1.28	0	pkey	false	true	false	a generated, unique id
203	failover_mysql_replications	ao_server	1.59	1	fkey	true	false	false	the ao_server the receives the replication
205	failover_mysql_replications	replication	1.59	2	fkey	true	false	false	the failover server that receives the replication
206	failover_mysql_replications	mysql_server	1.28	3	fkey	false	false	false	the MySQL Server that is being replicated
207	failover_mysql_replications	monitoring_seconds_behind_low	1.56	4	int	true	false	false	the seconds behind where will trigger low alert level
208	failover_mysql_replications	monitoring_seconds_behind_medium	1.56	5	int	true	false	false	the seconds behind where will trigger medium alert level
209	failover_mysql_replications	monitoring_seconds_behind_high	1.56	6	int	true	false	false	the seconds behind where will trigger high alert level
210	failover_mysql_replications	monitoring_seconds_behind_critical	1.56	7	int	true	false	false	the seconds behind where will trigger critical alert level
212	failover_mysql_replications	max_alert_level	1.92.2.2-SNAPSHOT	8	enum	false	false	false	the maximum alert level for all monitoring of this slave
192	file_backup_settings	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
194	file_backup_settings	replication	1.31	1	fkey	false	false	false	the pkey of the failover_file_replication configured
195	file_backup_settings	path	1.0a100	2	string	false	false	false	the path to control
198	file_backup_settings	backup_enabled	1.31	3	boolean	false	false	false	the enabled flag for this prefix
201	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
985	firewalld_zones	pkey	1.81.0	0	pkey	false	true	false	a generated unique primary key
986	firewalld_zones	server	1.81.0	1	fkey	false	false	false	the pkey of the server
987	firewalld_zones	name	1.81.0	2	firewalld_zone_name	false	false	false	the name of the Firewalld zone
988	firewalld_zones	short	1.81.0	3	string	true	false	false	the optional short name
989	firewalld_zones	description	1.81.0	4	string	true	false	false	the optional description
990	firewalld_zones	fail2ban	1.81.9	5	boolean	false	false	false	enables Fail2ban on services in this zone
571	ftp_guest_users	username	1.81.22	0	linux_username	false	true	false	the username that is a guest user
1567	httpd_binds	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the IP address, port, and protocol details
1568	httpd_binds	httpd_server	1.0a100	1	fkey	false	false	false	the server that is listening on the address
2502	httpd_jboss_sites	tomcat_site	1.0a100	0	pkey	false	true	false	the tomcat site
2503	httpd_jboss_sites	version	1.0a100	1	fkey	false	false	false	reference to httpd_jboss_versions
2504	httpd_jboss_sites	jnp_bind	1.0a100	2	fkey	false	false	false	reference to net_binds
2505	httpd_jboss_sites	webserver_bind	1.0a100	3	fkey	false	false	false	reference to net_binds
2506	httpd_jboss_sites	rmi_bind	1.0a100	4	fkey	false	false	false	reference to net_binds
2507	httpd_jboss_sites	hypersonic_bind	1.0a100	5	fkey	false	false	false	reference to net_binds
2508	httpd_jboss_sites	jmx_bind	1.0a100	6	fkey	false	false	false	reference to net_binds
2509	httpd_jboss_versions	version	1.0a100	0	pkey	false	true	true	jboss version designator
2510	httpd_jboss_versions	tomcat_version	1.0a100	1	fkey	false	false	true	version of tomcat associated with this jboss version
2511	httpd_jboss_versions	template_dir	1.0a100	2	string	false	false	true	directory containing the install template
2596	httpd_jk_codes	code	1.0a100	0	string	false	true	true	the unique, two-character code
2549	httpd_jk_protocols	protocol	1.0a100	0	string	false	true	true	the protocol used, as found in protocols.protocol
1569	httpd_servers	pkey	1.0a100	0	pkey	false	true	false	a generated unique number
1570	httpd_servers	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server that hosts the httpd
1572	httpd_servers	name	1.81.8	2	string	true	false	false	the name of the instance on the server, null for the default instance
1573	httpd_servers	can_add_sites	1.0a100	3	boolean	false	false	false	indicated that more sites may be added to the server
1576	httpd_servers	linux_server_account	1.0a102	4	fkey	false	false	false	the account to run as
1577	httpd_servers	linux_server_group	1.0a102	5	fkey	false	false	false	the group to run as
1578	httpd_servers	mod_php_version	1.0a102	6	fkey	true	false	false	the version of mod_php to run
1579	httpd_servers	use_suexec	1.0a102	7	boolean	false	false	false	indicates that the suexec wrapper will be used for CGI
1580	httpd_servers	package	1.0a102	8	fkey	false	false	false	the package that owns the server
1582	httpd_servers	is_shared	1.0a102	9	boolean	false	false	false	indicates that any user on the server may use this httpd instance
1583	httpd_servers	use_mod_perl	1.0a103	10	boolean	false	false	false
1584	httpd_servers	timeout	1.0a130	11	int	false	false	false	the timeout setting in seconds
1585	httpd_servers	max_concurrency	1.68	12	int	false	false	false	the maximum number of processes/threads for this server instance
1586	httpd_servers	monitoring_concurrency_low	1.81.11	13	int	true	false	false	the concurrency that will trigger a low-level alert
1587	httpd_servers	monitoring_concurrency_medium	1.81.11	14	int	true	false	false	the concurrency that will trigger a medium-level alert
1588	httpd_servers	monitoring_concurrency_high	1.81.11	15	int	true	false	false	the concurrency that will trigger a high-level alert
1589	httpd_servers	monitoring_concurrency_critical	1.81.11	16	int	true	false	false	the concurrency that will trigger a critical-level alert
1590	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
1591	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
1592	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
1593	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
1594	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
1595	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
1596	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
1597	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
1598	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
1599	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
1600	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
1601	httpd_servers	mod_brotli	1.92.1	28	boolean	true	false	false	manually enables or disables the mod_brotli Apache module for this server instance
1602	httpd_servers	mod_deflate	1.81.7	29	boolean	true	false	false	manually enables or disables the mod_deflate Apache module for this server instance
1603	httpd_servers	mod_dir	1.81.7	30	boolean	true	false	false	manually enables or disables the mod_dir Apache module for this server instance
1604	httpd_servers	mod_filter	1.81.7	31	boolean	true	false	false	manually enables or disables the mod_filter Apache module for this server instance
1605	httpd_servers	mod_headers	1.81.7	32	boolean	true	false	false	manually enables or disables the mod_headers Apache module for this server instance
1606	httpd_servers	mod_http2	1.92.1	33	boolean	true	false	false	manually enables or disables the mod_http2 Apache module for this server instance
1607	httpd_servers	mod_include	1.81.7	34	boolean	true	false	false	manually enables or disables the mod_include Apache module for this server instance
1608	httpd_servers	mod_jk	1.81.7	35	boolean	true	false	false	manually enables or disables the mod_jk Apache module for this server instance
1609	httpd_servers	mod_log_config	1.81.7	36	boolean	true	false	false	manually enables or disables the mod_log_config Apache module for this server instance
1610	httpd_servers	mod_mime	1.81.7	37	boolean	true	false	false	manually enables or disables the mod_mime Apache module for this server instance
1611	httpd_servers	mod_mime_magic	1.81.7	38	boolean	true	false	false	manually enables or disables the mod_mime_magic Apache module for this server instance
1612	httpd_servers	mod_negotiation	1.81.7	39	boolean	true	false	false	manually enables or disables the mod_negotiation Apache module for this server instance
1613	httpd_servers	mod_proxy	1.81.7	40	boolean	true	false	false	manually enables or disables the mod_proxy Apache module for this server instance
1614	httpd_servers	mod_proxy_http	1.81.7	41	boolean	true	false	false	manually enables or disables the mod_proxy_http Apache module for this server instance
1615	httpd_servers	mod_proxy_http2	1.92.1	42	boolean	true	false	false	manually enables or disables the mod_proxy_http2 Apache module for this server instance
1616	httpd_servers	mod_reqtimeout	1.81.7	43	boolean	true	false	false	manually enables or disables the mod_reqtimeout Apache module for this server instance
1617	httpd_servers	mod_rewrite	1.81.7	44	boolean	true	false	false	manually enables or disables the mod_rewrite Apache module for this server instance
1618	httpd_servers	mod_setenvif	1.81.7	45	boolean	true	false	false	manually enables or disables the mod_setenvif Apache module for this server instance
1619	httpd_servers	mod_socache_shmcb	1.81.7	46	boolean	true	false	false	manually enables or disables the mod_socache_shmcb Apache module for this server instance
1620	httpd_servers	mod_ssl	1.81.7	47	boolean	true	false	false	manually enables or disables the mod_ssl Apache module for this server instance
1621	httpd_servers	mod_status	1.81.7	48	boolean	true	false	false	manually enables or disables the mod_status Apache module for this server instance
1622	httpd_servers	mod_wsgi	1.81.10	49	boolean	true	false	false	manually enables or disables the mod_wsgi Apache module for this server instance
2560	httpd_shared_tomcats	pkey	1.0a100	0	pkey	false	true	false	pkey for this jvm
2561	httpd_shared_tomcats	name	1.0a100	1	string	false	false	false	unique name for this jvm
2562	httpd_shared_tomcats	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server on which this jvm resides
2563	httpd_shared_tomcats	version	1.0a100	3	fkey	false	false	false	the tomcat version
2564	httpd_shared_tomcats	linux_server_account	1.0a100	4	fkey	false	false	false	the account under which this tomcat runs
2565	httpd_shared_tomcats	linux_server_group	1.0a100	5	fkey	false	false	false	the group to which this tomcat is assigned
2574	httpd_shared_tomcats	disable_log	1.0a100	6	fkey	true	false	false	indicates that the JVM is disabled
2575	httpd_shared_tomcats	tomcat4_worker	1.0a100	7	fkey	true	true	false	the httpd_worker for Tomcat version 4
2576	httpd_shared_tomcats	tomcat4_shutdown_port	1.0a100	8	fkey	true	true	false	the port that will shut down this JVM
2577	httpd_shared_tomcats	tomcat4_shutdown_key	1.0a100	9	string	true	false	false	the key used to shut down the JVM
2578	httpd_shared_tomcats	is_manual	1.0a100	10	boolean	false	false	false	the configuration files are manually maintained
2579	httpd_shared_tomcats	maxParameterCount	1.92.0	11	int	true	false	false	the maxParameterCount setting for this Tomcat
2580	httpd_shared_tomcats	max_post_size	1.80.1	12	int	true	false	false	the maxPostSize setting for this Tomcat
2581	httpd_shared_tomcats	unpack_wars	1.80.1	13	boolean	false	false	false	the unpackWARs setting for this Tomcat
2582	httpd_shared_tomcats	auto_deploy	1.80.1	14	boolean	false	false	false	the autoDeploy setting for this Tomcat
2583	httpd_shared_tomcats	undeployOldVersions	1.92.0	15	boolean	false	false	false	the undeployOldVersions setting for this Tomcat
2584	httpd_shared_tomcats	tomcatAuthentication	1.83.2	16	boolean	false	false	false	the tomcatAuthentication setting for this Tomcat
1623	httpd_site_authenticated_locations	pkey	1.18	0	pkey	false	true	false	a generated primary key
1624	httpd_site_authenticated_locations	httpd_site	1.18	1	fkey	false	false	false	the site that is being referenced
1625	httpd_site_authenticated_locations	path	1.18	2	string	false	false	false	the path to protect, unique per httpd_site
1626	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
1627	httpd_site_authenticated_locations	auth_name	1.18	4	string	false	false	false	the prompt given to the user during authentication
1628	httpd_site_authenticated_locations	auth_group_file	1.18	5	path	false	false	false	the full path to the file containing the group list
1629	httpd_site_authenticated_locations	auth_user_file	1.18	6	path	false	false	false	the full path to the file containing the user list
1630	httpd_site_authenticated_locations	require	1.18	7	string	false	false	false	the require directive parameter(s) for Apache
1631	httpd_site_authenticated_locations	handler	1.81.13	8	string	true	false	false	the optional handler for this location
1554	httpd_site_bind_headers	pkey	1.81.15	0	pkey	false	true	false	a generated primary key
1555	httpd_site_bind_headers	httpd_site_bind	1.81.15	1	fkey	false	false	false	the site bind that is being referenced
1556	httpd_site_bind_headers	sort_order	1.81.15	2	short	false	false	false	the per-bind unique sort ordering
1558	httpd_site_bind_headers	type	1.92.2.2-SNAPSHOT	3	enum	false	false	false	the type of header, either "Header" or "RequestHeader"
1559	httpd_site_bind_headers	always	1.81.15	4	boolean	false	false	false	the condition is either "onsuccess" (default, can be omitted) or "always"
1560	httpd_site_bind_headers	action	1.81.15	5	string	false	false	false	the action to be performed
1561	httpd_site_bind_headers	header	1.81.15	6	string	false	false	false	the header name, without any final colon
1562	httpd_site_bind_headers	value	1.81.15	7	string	true	false	false	the header value, not used for all actions
1563	httpd_site_bind_headers	replacement	1.81.15	8	string	true	false	false	the replacement value, only used for "edit" and "edit*"
1564	httpd_site_bind_headers	when	1.81.15	9	string	true	false	false	optional control over when is this header directive is applied
1565	httpd_site_bind_headers	comment	1.81.15	10	string	true	false	false	an optional comment describing the redirect
1639	RewriteRule	id	1.81.21	0	pkey	false	true	false	a generated primary key
1640	RewriteRule	virtualHost	1.81.21	1	fkey	false	false	false	the VirtualHost this rule is applied to
1641	RewriteRule	sortOrder	1.81.21	2	short	false	false	false	the per-VirtualHost unique sort ordering
1642	RewriteRule	pattern	1.81.21	3	string	false	false	false	the per-VirtualHost pattern matched
1643	RewriteRule	substitution	1.81.21	4	string	false	false	false	the rewrite substitution
1644	RewriteRule	flags	1.81.21	5	string	true	false	false	the optional flags for the rule
1645	RewriteRule	comment	1.81.21	6	string	true	false	false	an optional comment describing the rule
1689	httpd_site_binds	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1690	httpd_site_binds	httpd_site	1.0a100	1	fkey	false	false	false	the site that is being referenced
1691	httpd_site_binds	httpd_bind	1.0a100	2	fkey	false	false	false	the IP and port information for the binding
1692	httpd_site_binds	name	1.81.14	3	string	true	false	false	the name of the bind, null for the default bind
1693	httpd_site_binds	access_log	1.0a100	4	path	false	false	false	the file used for access logging
1694	httpd_site_binds	error_log	1.0a100	5	path	false	false	false	the file used for error logging
1695	httpd_site_binds	certificate	1.81.10	6	fkey	true	false	false	the certificate used by this bind
1699	httpd_site_binds	disable_log	1.0a100	7	fkey	true	false	false	indicates that this bind is disabled
1700	httpd_site_binds	predisable_config	1.0a100	8	string	true	false	false	the config file before the site was disabled
1701	httpd_site_binds	is_manual	1.0a100	9	boolean	false	false	false	the config file is manually maintained
1702	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
1703	httpd_site_binds	include_site_config	1.81.10	11	string	true	false	false	controls whether this bind includes the per-site configuration file
1684	httpd_site_urls	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
1685	httpd_site_urls	httpd_site_bind	1.0a100	1	fkey	false	false	false	the site that is being referenced
1687	httpd_site_urls	hostname	1.69	2	domain_name	false	false	false	the hostname that this site responds to
1688	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.
1647	httpd_sites	id	1.81.18	0	pkey	false	true	false	a generated primary key
1648	httpd_sites	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the site is hosted on
1650	httpd_sites	name	1.81.18	2	string	false	false	false	the name of the site, as used in the /var/www directory.
1651	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.
1653	httpd_sites	package	1.80.0	4	accounting	false	false	false	the package that the site is part of
1655	httpd_sites	linux_account	1.81.22	5	linux_username	false	false	false	the user the site "runs as"
1657	httpd_sites	linux_group	1.80.0	6	group_id	false	false	false	the primary group that can edit the site content
1658	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>
1668	httpd_sites	disable_log	1.0a100	8	fkey	true	false	false	indicates that the site is disabled
1669	httpd_sites	is_manual	1.0a100	9	boolean	false	false	false	configuration of this server is performed manually
1670	httpd_sites	awstats_skip_files	1.0a129	10	string	true	false	false	the SkipFiles setting for AWStats
1671	httpd_sites	php_version	1.78	11	fkey	true	false	false	the active version of PHP, if any
1672	httpd_sites	enable_cgi	1.80	12	boolean	false	false	false	CGI is enabled on this website
1673	httpd_sites	enable_ssi	1.80.1	13	boolean	false	false	false	Server-side includes are enabled on this website
1674	httpd_sites	enable_htaccess	1.80.1	14	boolean	false	false	false	.htaccess files are enabled on this website
1675	httpd_sites	enable_indexes	1.80.1	15	boolean	false	false	false	Directory indexes are enabled on this website
1676	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)
1677	httpd_sites	enable_anonymous_ftp	1.80.1	17	boolean	false	false	false	Enables the anonymous FTP area for this site.
1678	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.
1679	httpd_sites	block_scm	1.81.6	19	boolean	false	false	false	Enables the blocking of URL patterns associated with source control management systems.
1680	httpd_sites	block_core_dumps	1.81.6	20	boolean	false	false	false	Enables the blocking of core dumps.
1681	httpd_sites	block_editor_backups	1.81.6	21	boolean	false	false	false	Enables the blocking filename patterns associated with editor automatic backups.
1683	httpd_static_sites	httpd_site	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the site that contains static content
2529	httpd_tomcat_contexts	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
2530	httpd_tomcat_contexts	tomcat_site	1.0a100	1	fkey	false	false	false	the site this context is part of
2531	httpd_tomcat_contexts	class_name	1.0a100	2	string	true	false	false	the className attribute
2532	httpd_tomcat_contexts	cookies	1.0a100	3	boolean	false	false	false	the cookies attribute
2533	httpd_tomcat_contexts	cross_context	1.0a100	4	boolean	false	false	false	the crossContext attribute
2535	httpd_tomcat_contexts	doc_base	1.80.0	5	path	false	false	false	the docBase attribute
2536	httpd_tomcat_contexts	override	1.0a100	6	boolean	false	false	false	the override attribute
2537	httpd_tomcat_contexts	path	1.0a100	7	string	false	false	false	the path attribute
2538	httpd_tomcat_contexts	privileged	1.0a100	8	boolean	false	false	false	the privileged attribute
2539	httpd_tomcat_contexts	reloadable	1.0a100	9	boolean	false	false	false	the reloadable attribute
2540	httpd_tomcat_contexts	use_naming	1.0a100	10	boolean	false	false	false	the useNaming attribute
2541	httpd_tomcat_contexts	wrapper_class	1.0a100	11	string	true	false	false	the wrapperClass attribute
2542	httpd_tomcat_contexts	debug	1.0a100	12	int	false	false	false	the debug attribute
2543	httpd_tomcat_contexts	work_dir	1.0a100	13	path	true	false	false	the workDir attribute
2544	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
2512	httpd_tomcat_data_sources	pkey	1.5	0	pkey	false	true	false	a generated unique key
2513	httpd_tomcat_data_sources	tomcat_context	1.5	1	fkey	false	false	false	the context this data source is for
2514	httpd_tomcat_data_sources	name	1.5	2	string	false	false	false	the JNDI name
2515	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
2516	httpd_tomcat_data_sources	url	1.5	4	string	false	false	false	connection URL to be passed to our JDBC driver
2517	httpd_tomcat_data_sources	username	1.5	5	string	false	false	false	database username to be passed to our JDBC driver
2518	httpd_tomcat_data_sources	password	1.5	6	string	false	false	false	database password to be passed to our JDBC driver
2519	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
2520	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
2521	httpd_tomcat_data_sources	max_wait	1.5	9	int	false	false	false	the maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception
2522	httpd_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.
2523	httpd_tomcat_parameters	pkey	1.5	0	pkey	false	true	false	a generated unique key
2524	httpd_tomcat_parameters	tomcat_context	1.5	1	fkey	false	false	false	the context this parameter is for
2525	httpd_tomcat_parameters	name	1.5	2	string	false	false	false	the name of the context initialization parameter to be created
2526	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()
2527	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.
2528	httpd_tomcat_parameters	description	1.5	5	string	true	false	false	optional, human-readable description of this context initialization parameter
2545	httpd_tomcat_site_jk_mounts	pkey	1.81.6	0	pkey	false	true	false	a generated primary key
2546	httpd_tomcat_site_jk_mounts	httpd_tomcat_site	1.81.6	1	fkey	false	false	false	the Tomcat site that is being mounted
2547	httpd_tomcat_site_jk_mounts	path	1.81.6	2	string	false	false	false	the per-site unique pattern matched
2548	httpd_tomcat_site_jk_mounts	mount	1.81.6	3	boolean	false	false	false	true for JkMount, false for JkUnMount
2588	httpd_tomcat_sites	httpd_site	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the site that this Tomcat is running in
2589	httpd_tomcat_sites	version	1.0a100	1	fkey	false	false	false	the version of tomcat that is being ran
2591	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.
2585	httpd_tomcat_shared_sites	tomcat_site	1.0a100	0	pkey	false	true	false	the tomcat site
2586	httpd_tomcat_shared_sites	httpd_shared_tomcat	1.0a100	1	fkey	false	false	false	the shared JVM
2551	httpd_tomcat_std_sites	tomcat_site	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the site that this Tomcat is running in
2552	httpd_tomcat_std_sites	tomcat4_shutdown_port	1.0a100	1	fkey	true	true	false	the port that will shut down this JVM
2553	httpd_tomcat_std_sites	tomcat4_shutdown_key	1.0a100	2	string	true	false	false	the key used to shut down the JVM
2554	httpd_tomcat_std_sites	maxParameterCount	1.92.0	3	int	true	false	false	the maxParameterCount setting for this Tomcat
2555	httpd_tomcat_std_sites	max_post_size	1.80.1	4	int	true	false	false	the maxPostSize setting for this Tomcat
2556	httpd_tomcat_std_sites	unpack_wars	1.80.1	5	boolean	false	false	false	the unpackWARs setting for this Tomcat
2557	httpd_tomcat_std_sites	auto_deploy	1.80.1	6	boolean	false	false	false	the autoDeploy setting for this Tomcat
2558	httpd_tomcat_std_sites	undeployOldVersions	1.92.0	7	boolean	false	false	false	the undeployOldVersions setting for this Tomcat
2559	httpd_tomcat_std_sites	tomcatAuthentication	1.83.2	8	boolean	false	false	false	the tomcatAuthentication setting for this Tomcat
2593	httpd_tomcat_versions	version	1.92.2.4-SNAPSHOT	0	pkey	false	true	true	a reference to the tomcat details in the <code>technology_versions</code> table
2594	httpd_tomcat_versions	install_dir	1.0a100	1	path	false	false	true	the directory the basic install files are located in
2595	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
2599	httpd_workers	bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the network binding reservation and details
2601	httpd_workers	name	1.81.18	1	string	false	false	false	the jk_code for the worker
2604	httpd_workers	tomcatSite	1.81.18	2	fkey	true	false	false	the site that provides this worker (Tomcat 3 only)
1009	ip_addresses	id	1.81.18	0	pkey	false	true	false	a generated, unique key
1011	ip_addresses	inetAddress	1.81.18	1	ip_address	false	false	false	the IP address
1013	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
1015	ip_addresses	isAlias	1.81.18	3	boolean	false	false	false	indicates that the IP address is using IP aliasing on the network device
1017	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
1020	ip_addresses	package	1.81.18	5	fkey	false	false	false	the package that the IP address is part of
1022	ip_addresses	created	1.0a100	6	time	false	false	false	the time the IP address was added
1024	ip_addresses	isAvailable	1.81.18	7	boolean	false	false	false	a flag if the IP address is available
1026	ip_addresses	isOverflow	1.81.18	8	boolean	false	false	false	indicates that the IP address is shared by different accounts
1028	ip_addresses	isDhcp	1.81.18	9	boolean	false	false	false	the IP address is obtained via DHCP
1031	ip_addresses	externalInetAddress	1.81.18	10	ip_address	true	false	false	the external IP address, if different than ip_address
1032	ip_addresses	netmask	1.38	11	string	false	false	false	the netmask of the local network
2387	IpAddressMonitoring	id	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	id of ip_addresses
2388	IpAddressMonitoring	enabled	1.81.18	1	boolean	false	false	false	indicates that this IP address should be monitored
2389	IpAddressMonitoring	pingMonitorEnabled	1.81.18	2	boolean	false	false	false	if ping (ICMP ECHO) is available for monitoring, defaults to true
2390	IpAddressMonitoring	checkBlacklistsOverSmtp	1.81.18	3	boolean	false	false	false	allows determining some types of blacklists over SMTP protocol
2391	IpAddressMonitoring	verifyDnsPtr	1.81.18	4	boolean	false	false	false	enables monitoring of reverse DNS
2392	IpAddressMonitoring	verifyDnsA	1.81.18	5	boolean	false	false	false	enables monitoring of forward DNS
2410	ip_reputation_limiter_limits	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2411	ip_reputation_limiter_limits	limiter	1.66	1	fkey	false	false	false	the identifier of the limiter
2413	ip_reputation_limiter_limits	class	1.92.2.2-SNAPSHOT	2	enum	false	false	false	the reputation class
2414	ip_reputation_limiter_limits	syn_per_ip_burst	1.66	3	short	false	false	false
2415	ip_reputation_limiter_limits	syn_per_ip_rate	1.66	4	short	false	false	false
2417	ip_reputation_limiter_limits	syn_per_ip_unit	1.92.2.2-SNAPSHOT	5	enum	false	false	false
2418	ip_reputation_limiter_limits	syn_per_ip_size	1.66	6	short	false	false	false
2419	ip_reputation_limiter_limits	syn_burst	1.66	7	short	false	false	false
2420	ip_reputation_limiter_limits	syn_rate	1.66	8	short	false	false	false
2422	ip_reputation_limiter_limits	syn_unit	1.92.2.2-SNAPSHOT	9	enum	false	false	false
2423	ip_reputation_limiter_limits	packet_per_ip_burst	1.66	10	short	false	false	false
2424	ip_reputation_limiter_limits	packet_per_ip_rate	1.66	11	short	false	false	false
2426	ip_reputation_limiter_limits	packet_per_ip_unit	1.92.2.2-SNAPSHOT	12	enum	false	false	false
2427	ip_reputation_limiter_limits	packet_per_ip_size	1.66	13	short	false	false	false
2428	ip_reputation_limiter_limits	packet_burst	1.66	14	short	false	false	false
2429	ip_reputation_limiter_limits	packet_rate	1.66	15	short	false	false	false
2431	ip_reputation_limiter_limits	packet_unit	1.92.2.2-SNAPSHOT	16	enum	false	false	false
2436	ip_reputation_limiter_sets	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2437	ip_reputation_limiter_sets	limiter	1.66	1	fkey	false	false	false	the identifier of the limiter
2438	ip_reputation_limiter_sets	set	1.66	2	fkey	false	false	false	the identifier of the set
2439	ip_reputation_limiter_sets	sort_order	1.66	3	short	false	false	false	the per-limiter ordering
2432	ip_reputation_limiters	pkey	1.66	0	pkey	false	true	false	a generated, unique key
2433	ip_reputation_limiters	net_device	1.66	1	fkey	false	false	false	the identifier of the net_device that is protected
2434	ip_reputation_limiters	identifier	1.66	2	string	false	false	false	the per-net_device unique identifier
2435	ip_reputation_limiters	description	1.66	3	string	true	false	false	an optional description of the limiter
2403	ip_reputation_set_hosts	pkey	1.65	0	long	false	true	false	a generated, unique key
2405	ip_reputation_set_hosts	set	1.66	1	fkey	false	false	false	the IP Reputation Set
2407	ip_reputation_set_hosts	host	1.67	2	ip_address	false	false	false	the per-set unique IPv4 address
2408	ip_reputation_set_hosts	good_reputation	1.65	3	short	false	false	false	the current good reputation
2409	ip_reputation_set_hosts	bad_reputation	1.65	4	short	false	false	false	the current bad repuation
2440	ip_reputation_set_networks	pkey	1.65	0	long	false	true	false	a generated, unique key
2442	ip_reputation_set_networks	set	1.66	1	fkey	false	false	false	the IP Reputation Set
2444	ip_reputation_set_networks	network	1.67	2	ip_address	false	false	false	the per-set unique IPv4 network address, with network bits zero
2445	ip_reputation_set_networks	counter	1.65	3	int	false	false	false	the reputation counter
2446	ip_reputation_sets	pkey	1.65	0	pkey	false	true	false	a generated, unique key
2447	ip_reputation_sets	accounting	1.65	1	accounting	false	false	false	the accounting code of the business
2448	ip_reputation_sets	identifier	1.65	2	string	false	true	false	a globally unique identifier
2449	ip_reputation_sets	allow_subaccount_use	1.65	3	boolean	false	false	false	allows subaccounts to use the set
2450	ip_reputation_sets	max_hosts	1.65	4	int	false	false	false	the maximum number of individual hosts tracked
2451	ip_reputation_sets	max_uncertain_reputation	1.65	5	short	false	false	false	the maximum reputation from uncertain sources
2452	ip_reputation_sets	max_definite_reputation	1.65	6	short	false	false	false	the maximum reputation from definite sources
2453	ip_reputation_sets	network_prefix	1.65	7	short	false	false	false	the network size, for example 24 for a /24 (class C)
2454	ip_reputation_sets	max_network_reputation	1.65	8	short	false	false	false	the maximum reputation for a network
2455	ip_reputation_sets	host_decay_interval	1.65	9	int	false	false	false	the number of seconds between each host decay
2456	ip_reputation_sets	last_host_decay	1.65	10	time	false	false	false	the time the hosts were last decayed
2457	ip_reputation_sets	network_decay_interval	1.65	11	int	false	false	false	the number of seconds between each network decay
2458	ip_reputation_sets	last_network_decay	1.65	12	time	false	false	false	the time the networks were last decayed
2459	ip_reputation_sets	last_reputation_added	1.67	13	time	false	false	false	the time reputation was last added
1517	languages	code	1.44	0	string	false	true	true	the language code
457	linux_acc_addresses	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
458	linux_acc_addresses	email_address	1.0a100	1	fkey	false	false	false	reference to pkey of email_addresses
460	linux_acc_addresses	linux_server_account	1.31	2	fkey	false	false	false	reference to linux_server_accounts
796	linux_account_types	name	1.0a100	0	string	false	true	true	the name of the type
797	linux_account_types	description	1.0a100	1	string	false	false	true	a description of the type
798	linux_account_types	is_email	1.0a100	2	boolean	false	false	true	can email be associated with this account
753	linux_accounts	username	1.81.22	0	linux_username	false	true	false	the unique username
756	linux_accounts	name	1.80.1	1	gecos	true	false	false	the full name of the user
758	linux_accounts	office_location	1.69	2	gecos	true	false	false	the location of the user
760	linux_accounts	office_phone	1.69	3	gecos	true	false	false	the work phone number of the user
762	linux_accounts	home_phone	1.69	4	gecos	true	false	false	the home phone number of the user
763	linux_accounts	type	1.0a100	5	string	false	false	false	the type of account
764	linux_accounts	shell	1.0a100	6	path	false	false	false	the users shell preference
765	linux_accounts	created	1.0a100	7	time	false	false	false	the time the account was created
766	linux_accounts	disable_log	1.0a100	8	fkey	true	false	false	indicates that this account is disabled
683	linux_group_accounts	id	1.81.18	0	pkey	false	true	false	a generated unique number
686	linux_group_accounts	group	1.81.18	1	group_id	false	false	false	the linux group name
689	linux_group_accounts	user	1.81.22	2	linux_username	false	false	false	the linux account that is an alternate member
691	linux_group_accounts	isPrimary	1.81.18	3	boolean	false	false	false	flag showing that this group is the user's primary group
693	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
680	linux_group_types	name	1.0a100	0	string	false	true	true	the name of the type
681	linux_group_types	description	1.0a100	1	string	false	false	true	a description of the type
667	linux_groups	name	1.80.0	0	group_id	false	true	false	the name of the group
669	linux_groups	package	1.80.0	1	accounting	false	false	false	the package of the group
670	linux_groups	type	1.0a100	2	string	false	false	false	the type of group
767	linux_server_accounts	pkey	1.0a100	0	pkey	false	true	false	the generated primary key
769	linux_server_accounts	username	1.81.22	1	linux_username	false	false	false	the name of the user
770	linux_server_accounts	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server the username is on
773	linux_server_accounts	uid	1.80.0	3	linux_id	false	false	false	the uid of the user on the machine
774	linux_server_accounts	home	1.0a100	4	path	false	false	false	the home directory of the user on this machine
781	linux_server_accounts	autoresponder_from	1.0a100	5	fkey	true	false	false	the pkey of the email address used for the autoresponder
782	linux_server_accounts	autoresponder_subject	1.0a100	6	string	true	false	false	the subject of autoresponder messages
783	linux_server_accounts	autoresponder_path	1.0a100	7	string	true	false	false	the full path of the autoresponder text file
784	linux_server_accounts	is_autoresponder_enabled	1.0a100	8	boolean	false	false	false	flags if the autoresponder is enabled
785	linux_server_accounts	disable_log	1.0a100	9	fkey	true	false	false	indicates the account is disabled
786	linux_server_accounts	predisable_password	1.0a100	10	string	true	false	false	stores the password that was used before the account was disabled
788	linux_server_accounts	created	1.69	11	time	false	false	false	the time this account was added
789	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
790	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.
791	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.
792	linux_server_accounts	sa_integration_mode	1.0a120	15	string	false	false	false	the integration mode for SpamAssassin
793	linux_server_accounts	sa_required_score	1.0a124	16	float	false	false	false	the minimum SpamAssassin score considered Junk
794	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
795	linux_server_accounts	sudo	1.80.1	18	string	true	false	false	the sudo setting or null when sudo not allowed
671	linux_server_groups	pkey	1.0a100	0	pkey	false	true	false	a unique key
673	linux_server_groups	name	1.80.0	1	group_id	false	false	false	the group name
674	linux_server_groups	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the ao_server the group is on
677	linux_server_groups	gid	1.80.0	3	linux_id	false	false	false	the gid on that machine
679	linux_server_groups	created	1.69	4	time	false	false	false	the time the group was added
474	majordomo_lists	email_list	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the email list that this majordomo_list represents
475	majordomo_lists	majordomo_server	1.0a100	1	fkey	false	false	false	the majordomo_server that this list is part of
476	majordomo_lists	name	1.0a100	2	string	false	false	false	the list name
477	majordomo_lists	listname_pipe_add	1.0a100	3	fkey	false	true	false	the pipe address the list responds to. Example: test@aoindustries.com
478	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
479	majordomo_lists	owner_listname_add	1.0a100	5	fkey	false	true	false	the owner of the list. Example: owner-test@aoindustries.com
480	majordomo_lists	listname_owner_add	1.0a100	6	fkey	false	true	false	the owner of the list. Example: test-owner@aoindustries.com
481	majordomo_lists	listname_approval_add	1.0a100	7	fkey	false	true	false	the person who retrieves approval notifications. Example: test-approval@aoindustries.com
482	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
484	majordomo_servers	domain	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the pkey of the domain that is hosted
485	majordomo_servers	linux_server_account	1.0a100	1	fkey	false	false	false	the pkey of linux_server_account to run as
486	majordomo_servers	linux_server_group	1.0a100	2	fkey	false	false	false	the pkey of the linux_server_group to run as
487	majordomo_servers	version	1.0a100	3	string	false	false	false	the version of Majordomo to use
488	majordomo_servers	majordomo_pipe_address	1.0a100	4	fkey	false	false	false	the email_address to use as the majordomo
489	majordomo_servers	owner_majordomo_add	1.0a100	5	fkey	false	false	false	the email_address that owns this majordomo list
490	majordomo_servers	majordomo_owner_add	1.0a100	6	fkey	false	false	false	the email_address that owns this majordomo list
493	majordomo_versions	version	1.0a100	0	string	false	true	true	the version number
494	majordomo_versions	created	1.0a100	1	time	false	false	true	the time the version was added
825	master_hosts	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
826	master_hosts	username	1.0a100	1	username	false	false	false	the unique username of the user
828	master_hosts	host	1.80.0	2	hostname	false	false	false	the hostname or IP address they are allowed to connect from
805	master_processes	id	1.83.0	0	SmallIdentifier	false	true	false
807	master_processes	connectorId	1.83.0	1	Identifier	true	false	false
808	master_processes	authenticated_user	1.0a100	2	username	true	false	false
809	master_processes	effective_user	1.0a100	3	username	true	false	false
810	master_processes	daemon_server	1.0a100	4	fkey	true	false	false
811	master_processes	host	1.0a100	5	ip_address	false	false	false
812	master_processes	protocol	1.0a100	6	string	false	false	false
813	master_processes	aoserv_protocol	1.0a101	7	string	true	false	false
814	master_processes	is_secure	1.0a100	8	boolean	false	false	false
815	master_processes	connect_time	1.0a100	9	time	false	false	false
816	master_processes	use_count	1.0a100	10	long	false	false	false
817	master_processes	total_time	1.0a100	11	interval	false	false	false
818	master_processes	priority	1.0a100	12	int	false	false	false
819	master_processes	state	1.0a100	13	string	false	false	false
820	master_processes	command	1.0a100	14	string	true	false	false
821	master_processes	state_start_time	1.0a100	15	time	false	false	false
822	master_server_stats	name	1.0a100	0	string	false	true	false
823	master_server_stats	value	1.0a100	1	string	true	false	false
824	master_server_stats	description	1.0a100	2	string	false	false	false
829	master_servers	pkey	1.0a100	0	pkey	false	true	false	a generated unique primary key
830	master_servers	username	1.0a100	1	username	false	false	false	the unique username of the user
831	master_servers	server	1.0a100	2	fkey	false	false	false	the pkey of the server they may control
832	master_users	username	1.0a100	0	username	false	true	false	the unique username of the user
833	master_users	is_active	1.0a100	1	boolean	false	false	false	this level of access may be disabled
834	master_users	can_access_accounting	1.0a100	2	boolean	false	false	false	if they can access accounting resources
835	master_users	can_access_bank_accounting	1.0a100	3	boolean	false	false	false	if they can access bank account info
836	master_users	can_invalidate_tables	1.0a100	4	boolean	false	false	false	if they can invalidate master tables
837	master_users	can_access_admin_web	1.0a100	5	boolean	false	false	false	if they can access administrative web pages
839	master_users	is_dns_admin	1.0a100	6	boolean	false	false	false	if they can access all DNS stuff
841	master_users	is_router	1.65	7	boolean	false	false	false	if they read all router stuff
842	master_users	is_cluster_admin	1.73	8	boolean	false	false	false	if they can control cluster resources
216	monthly_charges	pkey	1.0a100	0	pkey	true	true	false	a unique, generated number for reference
217	monthly_charges	accounting	1.0a100	1	accounting	false	false	false	the account code that is charged to
219	monthly_charges	package	1.80.0	2	accounting	false	false	false	the package that this is charged for
220	monthly_charges	type	1.0a100	3	string	false	false	false	the type of charge, as found in transaction types
221	monthly_charges	description	1.0a100	4	string	true	false	false	the description that is placed in the transaction
222	monthly_charges	quantity	1.0a100	5	decimal_3	false	false	false	the quantity
224	monthly_charges	rate	1.83.0	6	money	false	false	false	the rate
225	monthly_charges	created	1.0a100	7	time	false	false	false	the time this entry was created
226	monthly_charges	created_by	1.0a100	8	username	false	false	false	the business_administrator who created the entry
227	monthly_charges	active	1.0a100	9	boolean	false	false	false	flags if this entry is active
843	mysql_databases	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
845	mysql_databases	name	1.80.0	1	mysql_database_name	false	false	false	the name of the database
847	mysql_databases	mysql_server	1.4	2	fkey	false	false	false	the pkey of the server that this database is hosted on
849	mysql_databases	package	1.80.0	3	accounting	false	false	false	the package that this database is part of
853	mysql_databases	max_check_table_alert_level	1.92.2.2-SNAPSHOT	4	enum	false	false	false	the maximum alert level created for the check table monitoring of this database
854	mysql_db_users	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
855	mysql_db_users	mysql_database	1.0a100	1	fkey	false	false	false	the pkey in mysql_databases
857	mysql_db_users	mysql_server_user	1.31	2	fkey	false	false	false	the pkey in mysql_server_users
858	mysql_db_users	select_priv	1.0a100	3	boolean	false	false	false	the SELECT privilege
859	mysql_db_users	insert_priv	1.0a100	4	boolean	false	false	false	the INSERT privilege
860	mysql_db_users	update_priv	1.0a100	5	boolean	false	false	false	the UPDATE privilege
861	mysql_db_users	delete_priv	1.0a100	6	boolean	false	false	false	the DELETE privilege
862	mysql_db_users	create_priv	1.0a100	7	boolean	false	false	false	the CREATE privilege
863	mysql_db_users	drop_priv	1.0a100	8	boolean	false	false	false	the DROP privilege
864	mysql_db_users	grant_priv	1.0a100	9	boolean	false	false	false	the GRANT privilege
865	mysql_db_users	references_priv	1.0a100	10	boolean	false	false	false	the REFERENCES privilege
866	mysql_db_users	index_priv	1.0a100	11	boolean	false	false	false	the INDEX privilege
867	mysql_db_users	alter_priv	1.0a100	12	boolean	false	false	false	the ALTER privilete
868	mysql_db_users	create_tmp_table_priv	1.0a111	13	boolean	false	false	false	the Create_tmp_table_priv
869	mysql_db_users	lock_tables_priv	1.0a111	14	boolean	false	false	false	the Lock_tables_priv
870	mysql_db_users	create_view_priv	1.4	15	boolean	false	false	false	the Create_view_priv
871	mysql_db_users	show_view_priv	1.4	16	boolean	false	false	false	the Show_view_priv
872	mysql_db_users	create_routine_priv	1.4	17	boolean	false	false	false	the Create_routine_priv
873	mysql_db_users	alter_routine_priv	1.4	18	boolean	false	false	false	the Alter_routine_priv
874	mysql_db_users	execute_priv	1.4	19	boolean	false	false	false	the Execute_priv
875	mysql_db_users	event_priv	1.54	20	boolean	false	false	false	the Event_priv
876	mysql_db_users	trigger_priv	1.54	21	boolean	false	false	false	the Trigger_priv
919	mysql_server_users	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
921	mysql_server_users	username	1.80.0	1	mysql_username	false	false	false	the username
923	mysql_server_users	mysql_server	1.4	2	fkey	false	false	false	the pkey of the MySQL server
925	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.
926	mysql_server_users	disable_log	1.0a100	4	fkey	true	false	false	indicates that this account is disabled
927	mysql_server_users	predisable_password	1.0a100	5	string	true	false	false	the password used before the account was disabled
928	mysql_server_users	max_questions	1.4	6	int	false	false	false	the maximum number of questions to this database server, 0 means unlimited
929	mysql_server_users	max_updates	1.4	7	int	false	false	false	the maximum number of updates to this database server, 0 means unlimited
930	mysql_server_users	max_connections	1.0a111	8	int	false	false	false	the maximum number of connections to this database server, 0 means unlimited
931	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
879	mysql_servers	bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the port the server binds to
881	mysql_servers	name	1.80.0	1	mysql_server_name	false	false	false	the name of the server
882	mysql_servers	ao_server	1.4	2	fkey	false	false	false	the pkey of the server that this database is hosted on
883	mysql_servers	version	1.4	3	fkey	false	false	false	the pkey of the MySQL version
884	mysql_servers	max_connections	1.4	4	int	false	false	false	the maximum number of connections for the db
889	mysql_users	username	1.80.0	0	mysql_username	false	true	false	the username of the MySQL user
890	mysql_users	select_priv	1.0a100	1	boolean	false	false	false	the SELECT privilege to all databases
891	mysql_users	insert_priv	1.0a100	2	boolean	false	false	false	the INSERT privilege to all databases
892	mysql_users	update_priv	1.0a100	3	boolean	false	false	false	the UPDATE privilege to all databases
893	mysql_users	delete_priv	1.0a100	4	boolean	false	false	false	the DELETE privilege to all databases
894	mysql_users	create_priv	1.0a100	5	boolean	false	false	false	the CREATE privilege to all databases
895	mysql_users	drop_priv	1.0a100	6	boolean	false	false	false	the DROP privilege to all databases
896	mysql_users	reload_priv	1.0a100	7	boolean	false	false	false	the RELOAD privilege to all databases
897	mysql_users	shutdown_priv	1.0a100	8	boolean	false	false	false	the SHUTDOWN privilege to all databases
898	mysql_users	process_priv	1.0a100	9	boolean	false	false	false	the PROCESS privilege to all databases
899	mysql_users	file_priv	1.0a100	10	boolean	false	false	false	the FILE privilege to all databases
900	mysql_users	grant_priv	1.0a100	11	boolean	false	false	false	the GRANT privilege to all databases
901	mysql_users	references_priv	1.0a100	12	boolean	false	false	false	the REFERENCES privilege to all databases
902	mysql_users	index_priv	1.0a100	13	boolean	false	false	false	the INDEX privilege to all databases
903	mysql_users	alter_priv	1.0a100	14	boolean	false	false	false	the ALTER privilete to all databases
904	mysql_users	show_db_priv	1.0a111	15	boolean	false	false	false
905	mysql_users	super_priv	1.0a111	16	boolean	false	false	false
906	mysql_users	create_tmp_table_priv	1.0a111	17	boolean	false	false	false
907	mysql_users	lock_tables_priv	1.0a111	18	boolean	false	false	false
908	mysql_users	execute_priv	1.0a111	19	boolean	false	false	false
909	mysql_users	repl_slave_priv	1.0a111	20	boolean	false	false	false
910	mysql_users	repl_client_priv	1.0a111	21	boolean	false	false	false
911	mysql_users	create_view_priv	1.4	22	boolean	false	false	false
912	mysql_users	show_view_priv	1.4	23	boolean	false	false	false
913	mysql_users	create_routine_priv	1.4	24	boolean	false	false	false
914	mysql_users	alter_routine_priv	1.4	25	boolean	false	false	false
915	mysql_users	create_user_priv	1.4	26	boolean	false	false	false
916	mysql_users	event_priv	1.54	27	boolean	false	false	false	the Event_priv
917	mysql_users	trigger_priv	1.54	28	boolean	false	false	false	the Trigger_priv
918	mysql_users	disable_log	1.0a100	29	fkey	true	false	false	indicates that this account is disabled
940	net_bind_firewalld_zones	pkey	1.81.0	0	pkey	false	true	false	a generated pkey
941	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
942	net_bind_firewalld_zones	firewalld_zone	1.81.0	2	fkey	false	false	false	the pkey of the zone this port is associated with
944	net_binds	id	1.81.18	0	pkey	false	true	false	a generated pkey
946	net_binds	package	1.80.0	1	accounting	false	false	false	the package that owns the opened port
948	net_binds	server	1.33	2	fkey	false	false	false	the pkey of the server that this port is bound on
950	net_binds	ipAddress	1.81.18	3	fkey	false	false	false	the id of the IP address that is bound to
953	net_binds	port	1.80.0	4	net_port	false	false	false	the port that is bound
955	net_binds	app_protocol	1.0a100	5	string	false	false	false	the application protocol (<code>protocols</code>)
961	net_binds	monitoring_enabled	1.0a104	6	boolean	false	false	false	turns on monitoring of the port
962	net_binds	monitoring_parameters	1.58	7	string	true	false	false	the URL-encoded name=value pairs of monitoring parameters
963	net_device_ids	name	1.0a100	0	string	false	true	true	the unique name of the device
964	net_device_ids	is_loopback	1.0a100	1	boolean	false	false	true	if the device is the loopback device
965	net_devices	pkey	1.0a100	0	pkey	false	true	false	a unique, generated pkey
967	net_devices	server	1.33	1	fkey	false	false	false	the pkey of the server that contains the device
969	net_devices	deviceId	1.81.18	2	string	false	false	false	the name of the device
970	net_devices	description	1.0a100	3	string	false	false	false	a description of the device
972	net_devices	delete_route	1.0a112	4	string	true	false	false	the default routing from the network scripts that should be removed
973	net_devices	gateway	1.0a100	5	ip_address	true	false	false	the gateway IP address
975	net_devices	network	1.0a112	6	ip_address	true	false	false	the local network
976	net_devices	broadcast	1.0a112	7	ip_address	true	false	false	the broadcast IP
978	net_devices	mac_address	1.80.0	8	mac_address	true	true	false	the MAC address to be used on the device
979	net_devices	max_bit_rate	1.2	9	long	true	false	false	the maximum bits per second for this network device
980	net_devices	monitoring_bit_rate_low	1.35	10	long	true	false	false	the 5-minute average that will trigger a low-level alert
981	net_devices	monitoring_bit_rate_medium	1.35	11	long	true	false	false	the 5-minute average that will trigger a medium-level alert
982	net_devices	monitoring_bit_rate_high	1.35	12	long	true	false	false	the 5-minute average that will trigger a high-level alert
983	net_devices	monitoring_bit_rate_critical	1.35	13	long	true	false	false	the 5-minute average that will trigger a critical-level alert
984	net_devices	monitoring_enabled	1.70	14	boolean	false	false	false	indicates that this device should be monitored
1037	net_tcp_redirects	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the pkey as found in net_binds
1038	net_tcp_redirects	cps	1.0a111	1	int	false	false	false	the maximum number of connections per second before the redirect is temporarily disabled
1039	net_tcp_redirects	cps_overload_sleep_time	1.0a111	2	int	false	false	false	the number of seconds the service will be disabled
1040	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
1043	net_tcp_redirects	destination_port	1.80.0	4	net_port	false	false	false	the remote port to connect to
231	notice_log	pkey	1.0a100	0	pkey	false	true	false
232	notice_log	create_time	1.0a100	1	time	false	false	false
233	notice_log	accounting	1.0a100	2	accounting	false	false	false
234	notice_log	billing_contact	1.0a100	3	string	false	false	false
235	notice_log	billing_email	1.0a100	4	email	false	false	false
237	notice_log	notice_type	1.0a100	5	string	false	false	false
239	notice_log	transid	1.69	6	fkey	true	false	false
228	NoticeLog.balance	id	1.83.0	0	pkey	false	true	false	a generated primary key
229	NoticeLog.balance	noticeLog	1.83.0	1	fkey	false	false	false	the ID of the NoticeLog this balance is part of
230	NoticeLog.balance	balance	1.83.0	2	money	false	false	false	the balance for a single currency
240	notice_types	type	1.0a100	0	string	false	true	true
241	notice_types	description	1.0a100	1	string	false	false	true
342	operating_system_versions	pkey	1.0a100	0	pkey	false	true	true	a generated, unique ID
343	operating_system_versions	operating_system	1.0a100	1	string	false	false	true	the name of the OS
344	operating_system_versions	version_number	1.0a100	2	string	false	false	true	the number of OS version
345	operating_system_versions	version_name	1.0a100	3	string	false	false	true	the name of this OS release
346	operating_system_versions	architecture	1.0a108	4	string	false	false	true	the name of the architecture
348	operating_system_versions	display	1.0a108	5	string	false	true	true	the full display name for this version
349	operating_system_versions	is_aoserv_daemon_supported	1.0a108	6	boolean	false	false	true	can AOServ Daemon be ran on this OS
350	operating_system_versions	sort_order	1.3	7	short	false	true	true	the default sort order
339	operating_systems	name	1.0a100	0	string	false	true	true	the unique name of the operating system
340	operating_systems	display	1.0a100	1	string	false	false	true	the display version of the name
341	operating_systems	is_unix	1.0a100	2	boolean	false	false	true	indicates that this is a Unix-based OS
242	package_categories	name	1.0a123	0	string	false	true	true	the category name
244	package_definition_limits	pkey	1.0a123	0	pkey	false	true	false	the unique identifier for this limit
245	package_definition_limits	package_definition	1.0a123	1	fkey	false	false	false	the pkey of the package definition
246	package_definition_limits	resource	1.0a123	2	string	false	false	false	the resource name
247	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
248	package_definition_limits	hard_limit	1.0a123	4	int	true	false	false	the maximum number that may be allocated, NULL means unlimited
250	package_definition_limits	additionalRate	1.83.0	5	money	true	false	false	the monthly rate for those past the soft_limit
251	package_definition_limits	additional_transaction_type	1.0a123	6	string	true	false	false
252	package_definitions	pkey	1.0a123	0	pkey	false	true	false	the unique ID of the package definition
255	package_definitions	accounting	1.45	1	accounting	false	false	false	the accounting code of the seller/reseller that supports this package
256	package_definitions	category	1.0a123	2	string	false	false	false	the package category
257	package_definitions	name	1.0a123	3	string	false	false	false	the name of the package
258	package_definitions	version	1.0a123	4	string	false	false	false	the unique version of this package
259	package_definitions	display	1.0a123	5	string	false	false	false	a short description for display use
260	package_definitions	description	1.0a123	6	string	false	false	false	a description of the package definition
262	package_definitions	setupFee	1.83.0	7	money	true	false	false	the setup fee for this package definition
263	package_definitions	setup_fee_transaction_type	1.0a123	8	string	true	false	false
265	package_definitions	monthlyRate	1.83.0	9	money	true	false	false	the default monthly charge for this package
266	package_definitions	monthly_rate_transaction_type	1.0a123	10	string	true	false	false
267	package_definitions	active	1.0a123	11	boolean	false	false	false	allows new accounts for this package
268	package_definitions	approved	1.0a123	12	boolean	false	false	false	once approved a definition may be used for packages, but may not be modified
269	packages	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
271	packages	name	1.80.0	1	accounting	false	true	false	the unique name of this package entry
272	packages	accounting	1.0a100	2	accounting	false	false	false	the accounting code of the business that pays for this package
275	packages	package_definition	1.0a123	3	fkey	false	false	false	the definition of the package
276	packages	created	1.0a100	4	time	false	false	false
277	packages	created_by	1.0a100	5	username	false	false	false
286	packages	disable_log	1.0a100	6	fkey	true	false	false	indicates that the package is disabled
287	packages	email_in_burst	1.24	7	int	true	false	false	the maximum burst of inbound email before limiting begins
288	packages	email_in_rate	1.24	8	float	true	false	false	the number of sustained inbound emails per second
289	packages	email_out_burst	1.24	9	int	true	false	false	the maximum burst of outbound email before limiting begins
290	packages	email_out_rate	1.24	10	float	true	false	false	the number of sustained outbound emails per second
291	packages	email_relay_burst	1.24	11	int	true	false	false	the maximum burst of relay email before limiting begins
292	packages	email_relay_rate	1.24	12	float	true	false	false	the number of sustained relay emails per second
1205	payment_types	name	1.0a100	0	string	false	true	true	the name of the type
1206	payment_types	description	1.0a100	1	string	false	false	true	a description of the type of payment
1207	payment_types	active	1.0a100	2	boolean	false	false	true	indicates if payment is currently accepted via this method
1208	payment_types	allow_web	1.0a100	3	boolean	false	false	true	indicates if payment is allowed via a web form
587	physical_servers	server	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	a reference to servers
588	physical_servers	rack	1.36	1	fkey	true	false	false	the rack that houses this server
589	physical_servers	rack_units	1.36	2	short	true	false	false	the number of rack units
590	physical_servers	ram	1.36	3	int	true	false	false	the total number of megabytes of RAM in this server
591	physical_servers	processor_type	1.36	4	string	true	false	false	the processor type
592	physical_servers	processor_speed	1.36	5	int	true	false	false	the processor speed in MHz
593	physical_servers	processor_cores	1.36	6	int	true	false	false	the total number of processor cores, hyperthreads are counted as different cores
594	physical_servers	max_power	1.36	7	float	true	false	false	the number of amps this server consumes under peak load
595	physical_servers	supports_hvm	1.37	8	boolean	true	false	false	indicates supports full hardware virtualization
597	physical_servers	ups_type	1.92.2.2-SNAPSHOT	9	enum	false	false	false	the type of UPS powering the server
1248	postgres_databases	pkey	1.0a100	0	pkey	false	true	false	a unique, generated primary key
1250	postgres_databases	name	1.80.0	1	postgres_database_name	false	false	false	the name of the database
1251	postgres_databases	postgres_server	1.0a100	2	fkey	false	false	false	the pkey of the PostgreSQL server
1252	postgres_databases	datdba	1.0a100	3	fkey	false	false	false	the datdba for the database
1253	postgres_databases	encoding	1.0a100	4	fkey	false	false	false	the pkey of the encoding system used for the database
1254	postgres_databases	is_template	1.0a100	5	boolean	false	false	false	if true, this database is a template
1255	postgres_databases	allow_conn	1.0a100	6	boolean	false	false	false	if true, this database is accepting connections
1258	postgres_databases	enable_postgis	1.27	7	boolean	false	false	false	indicates PostGIS is enabled on this database
1259	postgres_encodings	pkey	1.0a100	0	pkey	false	true	true	a generated unique key
1260	postgres_encodings	encoding	1.0a100	1	string	false	false	true	the name of the encoding
1261	postgres_encodings	postgres_version	1.0a100	2	fkey	false	false	true	the version of PostgreSQL
1282	postgres_server_users	pkey	1.0a100	0	pkey	false	true	false	a unique, generated number
1284	postgres_server_users	username	1.80.0	1	postgres_username	false	false	false	the username as found in postgres_users
1286	postgres_server_users	postgres_server	1.69	2	fkey	false	false	false	the pkey of the PostgreSQL server
1288	postgres_server_users	disable_log	1.0a100	3	fkey	true	false	false	indicates that this account is disabled
1289	postgres_server_users	predisable_password	1.0a100	4	string	true	false	false	the password that was on the account before it was disabled
1264	postgres_servers	bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the port the server binds to
1266	postgres_servers	name	1.80.0	1	postgres_server_name	false	false	false	the name of the database
1267	postgres_servers	ao_server	1.0a100	2	fkey	false	false	false	the pkey of the server that this database is hosted on
1268	postgres_servers	version	1.0a100	3	fkey	false	false	false	the pkey of the PostgreSQL version
1269	postgres_servers	max_connections	1.0a100	4	int	false	false	false	the maximum number of connections for the db
1271	postgres_servers	sort_mem	1.0a100	5	int	false	false	false	the amount of shared memory used for sorting
1272	postgres_servers	shared_buffers	1.0a100	6	int	false	false	false	the number of shared buffers
1273	postgres_servers	fsync	1.0a100	7	boolean	false	false	false	indicates that writes are synchronous
1276	postgres_users	username	1.80.0	0	postgres_username	false	true	false	the username of the user
1277	postgres_users	createdb	1.0a100	1	boolean	false	false	false	usecreatedb flag
1278	postgres_users	trace	1.0a100	2	boolean	false	false	false	usetrace flag
1279	postgres_users	super	1.0a100	3	boolean	false	false	false	usesuper flag
1280	postgres_users	catupd	1.0a100	4	boolean	false	false	false	usecatupd flag
1281	postgres_users	disable_log	1.0a100	5	fkey	true	false	false	indicates that this account is disabled
1291	postgres_versions	version	1.92.2.4-SNAPSHOT	0	pkey	false	true	true	a reference to the PostgreSQL details in the <code>technology_versions</code> table
1293	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>
1294	postgres_versions	postgis_version	1.27	2	fkey	true	false	true	a reference to the PostGIS defails in the <code>technology_versions</code> table
574	private_ftp_servers	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the pkey of the net_bind that the FTP server is on
576	private_ftp_servers	logfile	1.0a100	1	path	false	false	false	the file transfers are logged to
578	private_ftp_servers	hostname	1.69	2	domain_name	false	false	false	the hostname the server reports
579	private_ftp_servers	email	1.0a100	3	email	false	false	false	the email address the server reports
581	private_ftp_servers	created	1.0a100	4	time	false	false	false	the time the server was added
583	private_ftp_servers	linux_server_account	1.69	5	fkey	false	false	false
585	private_ftp_servers	allow_anonymous	1.0a113	6	boolean	false	false	false	enabled or disabled anonymous access to the server
598	processor_types	type	1.36	0	string	false	true	true	the unique name of the type of processor
599	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
932	protocols	protocol	1.0a100	0	string	false	true	true	the unique name of the protocol
935	protocols	port	1.80.0	1	net_port	false	false	true	the default port of the protocol
936	protocols	name	1.0a100	2	string	false	false	true	the name of the service
937	protocols	is_user_service	1.0a105	3	boolean	false	false	true	indicates that a user may add and remove this service
939	protocols	isUniquePerHost	1.92.2-SNAPSHOT	4	boolean	false	false	true	indicates that the app_protocol is used at most one per host
600	racks	pkey	1.36	0	pkey	false	true	false	the unique ID for the rack
601	racks	farm	1.36	1	string	false	false	false	the server_farm housing the rack
602	racks	name	1.36	2	string	false	false	false	the per-farm unique name
603	racks	max_power	1.36	3	float	true	false	false	the maximum electrical load supported by the rack
604	racks	total_rack_units	1.36	4	int	true	false	false	the number of rack units of physical space
1350	resellers	accounting	1.44	0	accounting	false	true	false
1351	resellers	ticket_auto_escalate	1.44	1	boolean	false	false	false
293	resources	name	1.0a100	0	string	false	true	true	the name of the specific resource
1358	schema_columns	id	1.81.18	0	pkey	false	true	true	a generated unique pkey
1360	schema_columns	table	1.81.18	1	string	false	false	true	the name of the table the column is in
1362	schema_columns	name	1.81.18	2	string	false	false	true	the name of the column
1364	schema_columns	sinceVersion	1.92.2.3-SNAPSHOT	3	enum	false	false	true	the first aoserv_protocol version this column was in
1366	schema_columns	lastVersion	1.92.2.3-SNAPSHOT	4	enum	true	false	true	the last version containing this field
1368	schema_columns	index	1.81.18	5	short	false	false	true	the index of the column
1369	schema_columns	type	1.0a100	6	string	false	false	true	the type of data in the column
1371	schema_columns	isNullable	1.81.18	7	boolean	false	false	true	if the value may be null
1373	schema_columns	isUnique	1.81.18	8	boolean	false	false	true	if true, the value is unique across rows
1375	schema_columns	isPublic	1.81.18	9	boolean	false	false	true	if the value is publicly accessible
1376	schema_columns	description	1.0a100	10	string	false	false	true	any description associated with the column
1380	schema_foreign_keys	id	1.81.18	0	pkey	false	true	true	a generated unique pkey
1382	schema_foreign_keys	column	1.81.18	1	fkey	false	false	true	the column that references another column
1384	schema_foreign_keys	foreignColumn	1.81.18	2	fkey	false	false	true	the referenced column
1389	schema_foreign_keys	sinceVersion	1.92.2.3-SNAPSHOT	3	enum	false	false	true	the first aoserv_protocol version to have this reference
1392	schema_foreign_keys	lastVersion	1.92.2.3-SNAPSHOT	4	enum	true	false	true	the last aoserv_protocol version to have this references, or null if not yet removed
1393	schema_tables	id	1.81.18	0	pkey	false	true	true	a unique ID for the table
1394	schema_tables	name	1.0a100	1	string	false	true	true	the unique name
1397	schema_tables	sinceVersion	1.92.2.3-SNAPSHOT	2	enum	false	false	true	the first aoserv_protocol version to have this table
1399	schema_tables	lastVersion	1.92.2.3-SNAPSHOT	3	enum	true	false	true	the last aoserv_protocol version to have this table or null if still used
1400	schema_tables	display	1.0a100	4	string	false	false	true	the display name
1402	schema_tables	isPublic	1.81.18	5	boolean	false	false	true	if the data contained in the table is accessible to everybody
1403	schema_tables	description	1.0a100	6	string	false	false	true	the description of the table
1408	schema_types	id	1.81.18	0	pkey	false	true	true	the unique number
1410	schema_types	name	1.81.18	1	string	false	true	true	the unique name
1414	schema_types	sinceVersion	1.92.2.3-SNAPSHOT	2	enum	false	false	true	the first aoserv_protocol version this type was in
1417	schema_types	lastVersion	1.92.2.3-SNAPSHOT	3	enum	true	false	true	the last version containing this type
506	sendmail_binds	net_bind	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the IP address, port, and protocol details
507	sendmail_binds	sendmail_server	1.81.10	1	fkey	false	false	false	the server that is listening on the address
508	sendmail_binds	servername	1.81.10	2	string	true	false	false	the Name for DaemonPortOptions for this bind
510	sendmail_servers	id	1.81.18	0	pkey	false	true	false	a generated unique number
511	sendmail_servers	ao_server	1.81.10	1	fkey	false	false	false	the pkey of the server that runs this sendmail instance
512	sendmail_servers	name	1.81.10	2	string	true	false	false	the name of the instance on the server, null for the default instance
513	sendmail_servers	package	1.81.10	3	fkey	false	false	false	the package that owns the SSL certificate
514	sendmail_servers	hostname	1.81.10	4	domain_name	true	false	false	the fully qualified hostname for Dw, Dm, and Dj
515	sendmail_servers	server_certificate	1.81.10	5	fkey	false	false	false	the certificate used for this server
516	sendmail_servers	client_certificate	1.81.10	6	fkey	false	false	false	the certificate used for this client
517	sendmail_servers	allow_plaintext_auth	1.81.10	7	boolean	false	false	false	allows plaintext authentication (PLAIN/LOGIN) on non-TLS links
518	sendmail_servers	max_queue_children	1.81.10	8	int	true	false	false	the value for confMAX_QUEUE_CHILDREN
519	sendmail_servers	nice_queue_run	1.81.10	9	int	true	false	false	the value for confNICE_QUEUE_RUN
520	sendmail_servers	delay_la	1.81.10	10	int	true	false	false	the value for confDELAY_LA
521	sendmail_servers	queue_la	1.81.10	11	int	true	false	false	the value for confQUEUE_LA
522	sendmail_servers	refuse_la	1.81.10	12	int	true	false	false	the value for confREFUSE_LA
523	sendmail_servers	max_daemon_children	1.81.10	13	int	true	false	false	the value for confMAX_DAEMON_CHILDREN
524	sendmail_servers	bad_rcpt_throttle	1.81.10	14	int	true	false	false	the value for confBAD_RCPT_THROTTLE
525	sendmail_servers	connection_rate_throttle	1.81.10	15	int	true	false	false	the value for confCONNECTION_RATE_THROTTLE
526	sendmail_servers	max_message_size	1.81.10	16	int	true	false	false	the value for confMAX_MESSAGE_SIZE
527	sendmail_servers	min_free_blocks	1.81.10	17	int	true	false	false	the value for confMIN_FREE_BLOCKS
529	sendmail_servers	clientAddrInet	1.81.18	18	fkey	true	false	false	the Addr for ClientPortOptions with Family=inet
531	sendmail_servers	clientAddrInet6	1.81.18	19	fkey	true	false	false	the Addr for ClientPortOptions with Family=inet6
605	server_farms	name	1.0a100	0	string	false	true	false	the unique name of the farm
606	server_farms	description	1.0a100	1	string	false	false	false	a description of the farm
610	server_farms	owner	1.0a102	2	fkey	false	false	false	the package that owns of the farm
611	server_farms	use_restricted_smtp_port	1.26	3	boolean	false	false	false	outgoing servers should use restricted source ports (affects firewall rules)
991	servers	pkey	1.0a100	0	pkey	false	true	false	a generated, unique ID
993	servers	farm	1.0a100	1	string	false	false	false	the name of the farm the server is located in
996	servers	description	1.0a100	2	string	false	false	false	a description of the servers purpose
1001	servers	operating_system_version	1.31	3	fkey	true	false	false	the version of operating system running on the server, if known
1005	servers	package	1.31	4	fkey	false	false	false	the package accountable for resources used by the server
1006	servers	name	1.31	5	string	false	false	false	the per-package unique name of the server (no special formatting required)
1007	servers	monitoring_enabled	1.32	6	boolean	false	false	false	enables/disables monitoring
748	shells	path	1.0a100	0	path	false	true	true	the complete path to the executable
749	shells	is_login	1.0a100	1	boolean	false	false	true	indicates if the shells gives process control
750	shells	is_system	1.0a100	2	boolean	false	false	true	indicates that this shell is for internal use only
1427	signup_request_options	pkey	1.23	0	pkey	false	true	false	a generate unique id
1428	signup_request_options	request	1.23	1	fkey	false	false	false	the id of the request this option is part of
1429	signup_request_options	name	1.23	2	string	false	false	false	the unique-per-request name of the option
1430	signup_request_options	value	1.23	3	string	true	false	false	the value of the option
1431	signup_requests	pkey	1.23	0	pkey	false	true	false	a generate unique id
1433	signup_requests	brand	1.44	1	accounting	false	false	false	the brand of the parent business for the new account
1434	signup_requests	time	1.23	2	time	false	false	false	the time the request was added
1435	signup_requests	ip_address	1.23	3	ip_address	false	false	false	the IP address of the user who signed-up
1436	signup_requests	package_definition	1.23	4	fkey	false	false	false	the pkey of the Package Definition requested
1437	signup_requests	business_name	1.23	5	string	false	false	false	the name of the business
1439	signup_requests	business_phone	1.69	6	phone	false	false	false	the phone number of the business
1441	signup_requests	business_fax	1.69	7	phone	true	false	false	the fax number of the business
1442	signup_requests	business_address1	1.23	8	string	false	false	false	the street address of the business
1443	signup_requests	business_address2	1.23	9	string	true	false	false	the street address of the business
1445	signup_requests	business_city	1.69	10	string	false	false	false	the city of the business
1447	signup_requests	business_state	1.69	11	string	true	false	false	the state or providence of the business
1449	signup_requests	business_country	1.69	12	string	false	false	false	the two-character country code of the business
1451	signup_requests	business_zip	1.69	13	string	true	false	false	the zip code of the business
1452	signup_requests	ba_name	1.23	14	string	false	false	false	the administrator's name
1453	signup_requests	ba_title	1.23	15	string	true	false	false	the administrator's title
1455	signup_requests	ba_work_phone	1.69	16	string	false	false	false	the administrator's work phone
1457	signup_requests	ba_cell_phone	1.69	17	string	true	false	false	the administrator's cell phone
1459	signup_requests	ba_home_phone	1.69	18	string	true	false	false	the administrator's home phone
1461	signup_requests	ba_fax	1.69	19	string	true	false	false	the administrator's fax number
1462	signup_requests	ba_email	1.23	20	email	false	false	false	the administrator's email address
1463	signup_requests	ba_address1	1.23	21	string	true	false	false	the street address of the administrator
1464	signup_requests	ba_address2	1.23	22	string	true	false	false	the street address of the administrator
1466	signup_requests	ba_city	1.69	23	string	true	false	false	the city of the administrator
1468	signup_requests	ba_state	1.69	24	string	true	false	false	the state or providence of the administrator
1470	signup_requests	ba_country	1.69	25	string	true	false	false	the two-character country code of the administrator
1472	signup_requests	ba_zip	1.69	26	string	true	false	false	the zip code of the administrator
1473	signup_requests	ba_username	1.23	27	username	false	false	false	the username of the administrator
1474	signup_requests	billing_contact	1.23	28	string	false	false	false	the name of the billing contact
1475	signup_requests	billing_email	1.23	29	email	false	false	false	the email address of the billing contact
1476	signup_requests	billing_use_monthly	1.23	30	boolean	false	false	false	if true, the credit_card will be used every month automatically
1477	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
1478	signup_requests	encrypted_data	1.23	32	string	false	false	false	the credit card details and password are stored encrypted
1479	signup_requests	encryption_from	1.31	33	fkey	false	false	false	the from that was used for encryption
1481	signup_requests	encryption_recipient	1.31	34	fkey	false	false	false	the recipient that was used for encryption
1482	signup_requests	completed_by	1.23	35	username	true	false	false	the username of the person who completed this sign-up request
1483	signup_requests	completed_time	1.23	36	time	true	false	false	the time this request was completed
562	spam_email_messages	pkey	1.0a100	0	pkey	false	true	false	a generated unique key
563	spam_email_messages	email_relay	1.0a100	1	fkey	false	false	false	the relay that has been denied
564	spam_email_messages	time	1.0a100	2	time	false	false	false	the time the message was added
565	spam_email_messages	message	1.0a100	3	string	false	false	false	the message contents
1221	ssl_certificate_names	pkey	1.81.10	0	pkey	false	true	false	a generated primary key
1222	ssl_certificate_names	ssl_certificate	1.81.10	1	fkey	false	false	false	the pkey of the SSL certificate this name is on
1223	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
1224	ssl_certificate_names	is_wildcard	1.81.10	3	boolean	false	false	false	is a *.(domain) wildcard certificate
1225	ssl_certificate_names	domain	1.81.10	4	domain_name	false	false	false	the domain name
1226	ssl_certificate_other_uses	pkey	1.81.16	0	pkey	false	true	false	a generated primary key
1227	ssl_certificate_other_uses	ssl_certificate	1.81.16	1	fkey	false	false	false	the pkey of the SSL certificate this name is on
1228	ssl_certificate_other_uses	sort_order	1.81.16	2	short	false	false	false	the per-certificate unique sort ordering
1229	ssl_certificate_other_uses	count	1.81.16	3	int	false	false	false	the number of times this other resource uses the certificate
1230	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
1231	ssl_certificates	pkey	1.81.10	0	pkey	false	true	false	a generated primary key
1232	ssl_certificates	ao_server	1.81.10	1	fkey	false	false	false	the pkey of the server the SSL certificate is on
1233	ssl_certificates	package	1.81.10	2	fkey	false	false	false	the package that owns the SSL certificate
1234	ssl_certificates	key_file	1.81.10	3	path	false	false	false	the file holding the private key
1235	ssl_certificates	csr_file	1.81.10	4	path	true	false	false	the file holding the CSR
1236	ssl_certificates	cert_file	1.81.10	5	path	false	false	false	the file holding the public key
1237	ssl_certificates	chain_file	1.81.10	6	path	true	false	false	the file holding the CA chain
1238	ssl_certificates	certbot_name	1.81.10	7	string	true	false	false	the name of the certbot-managed Let's Encrypt certificate
566	system_email_aliases	pkey	1.0a100	0	pkey	false	true	false	a generated primary key
567	system_email_aliases	ao_server	1.0a100	1	fkey	false	false	false	the pkey of the server the entry is on
568	system_email_aliases	address	1.0a100	2	string	false	false	false	the address (username only) to match
569	system_email_aliases	destination	1.0a100	3	string	false	false	false	the destination, as found in /etc/aliases
351	technologies	pkey	1.4	0	pkey	false	true	true	the unique identifier
352	technologies	name	1.0a100	1	string	false	false	true	the name of the package
353	technologies	class	1.0a100	2	string	false	false	true	the name of the group this package belongs to
354	technology_classes	name	1.0a100	0	string	false	true	true	the name of the class
355	technology_classes	description	1.0a100	1	string	false	false	true	a description of the class
356	technology_names	name	1.0a100	0	string	false	true	true	the name of the package
357	technology_names	image_filename	1.0a100	1	string	true	false	true	the name of the file containing the image
358	technology_names	image_width	1.0a100	2	int	true	false	true	the width of the image
359	technology_names	image_height	1.0a100	3	int	true	false	true	the height of the image
360	technology_names	image_alt	1.0a100	4	string	true	false	true	the alt attribute of the image
361	technology_names	home_page_url	1.0a100	5	url	true	false	true	the URL of the technology home page
362	technology_versions	pkey	1.0a100	0	pkey	false	true	true	a generated unique key
363	technology_versions	name	1.0a100	1	string	false	false	true	the name of the software package
364	technology_versions	version	1.0a100	2	string	false	false	true	the version number of the package in #.##.##-## format
365	technology_versions	updated	1.0a100	3	time	false	false	true	the time this package was last updated
366	technology_versions	owner	1.0a100	4	username	false	false	false	the business_administrator who is responsible for maintaining this package
367	technology_versions	operating_system_version	1.0a108	5	fkey	true	false	true	the version of the OS that this packages is installed
368	technology_versions	disable_time	1.78	6	time	true	false	true	the time this version is no longer supported
369	technology_versions	disable_reason	1.78	7	string	true	false	true	the reason this version is no longer supported
1511	ticket_action_types	type	1.44	0	string	false	true	true
1512	ticket_action_types	visible_admin_only	1.44	1	boolean	false	false	true
1484	ticket_actions	pkey	1.44	0	pkey	false	true	false
1485	ticket_actions	ticket	1.44	1	fkey	false	false	false
1486	ticket_actions	administrator	1.44	2	username	true	false	false
1487	ticket_actions	time	1.44	3	time	false	false	false
1488	ticket_actions	action_type	1.44	4	string	false	false	false
1490	ticket_actions	old_accounting	1.69	5	accounting	true	false	false
1492	ticket_actions	new_accounting	1.69	6	accounting	true	false	false
1493	ticket_actions	old_priority	1.44	7	string	true	false	false
1494	ticket_actions	new_priority	1.44	8	string	true	false	false
1495	ticket_actions	old_type	1.49	9	string	true	false	false
1496	ticket_actions	new_type	1.49	10	string	true	false	false
1497	ticket_actions	old_status	1.44	11	string	true	false	false
1498	ticket_actions	new_status	1.44	12	string	true	false	false
1500	ticket_actions	old_assigned_to	1.80.0	13	username	true	false	false
1502	ticket_actions	new_assigned_to	1.80.0	14	username	true	false	false
1503	ticket_actions	old_category	1.44	15	fkey	true	false	false
1504	ticket_actions	new_category	1.44	16	fkey	true	false	false
1505	ticket_actions	old_value	1.44	17	string	true	false	false
1506	ticket_actions	new_value	1.44	18	string	true	false	false
1507	ticket_actions	from_address	1.44	19	email	true	false	false
1508	ticket_actions	summary	1.44	20	string	true	false	false
1509	ticket_actions	details	1.44	21	string	true	false	false
1510	ticket_actions	raw_email	1.44	22	string	true	false	false
1513	ticket_assignments	pkey	1.44	0	pkey	false	true	false
1514	ticket_assignments	ticket	1.44	1	fkey	false	false	false
1515	ticket_assignments	reseller	1.44	2	accounting	false	false	false
1516	ticket_assignments	administrator	1.44	3	username	false	false	false
1295	ticket_brand_categories	pkey	1.44	0	pkey	false	true	false
1296	ticket_brand_categories	brand	1.44	1	accounting	false	false	false
1297	ticket_brand_categories	category	1.44	2	fkey	false	false	false
1298	ticket_brand_categories	enabled	1.44	3	boolean	false	false	false
1347	ticket_categories	pkey	1.44	0	pkey	false	true	false
1348	ticket_categories	parent	1.44	1	fkey	true	false	false
1349	ticket_categories	name	1.44	2	string	false	false	false
1518	ticket_priorities	priority	1.0a100	0	string	false	true	true
1519	ticket_stati	status	1.0a100	0	string	false	true	true
1521	ticket_stati	sort_order	1.44	1	short	false	true	true
1551	ticket_types	type	1.0a100	0	string	false	true	true
1522	tickets	pkey	1.0a100	0	pkey	false	true	false
1523	tickets	brand	1.46	1	accounting	false	false	false
1524	tickets	reseller	1.44	2	accounting	false	false	false
1526	tickets	accounting	1.0a126	3	accounting	true	false	false
1527	tickets	language	1.44	4	string	false	false	false
1529	tickets	created_by	1.0a126	5	username	true	false	false
1530	tickets	category	1.44	6	fkey	true	false	false
1531	tickets	ticket_type	1.0a100	7	string	false	false	false
1532	tickets	from_address	1.44	8	email	true	false	false
1533	tickets	summary	1.44	9	string	false	false	false
1535	tickets	details	1.44	10	string	true	false	false
1536	tickets	raw_email	1.44	11	string	true	false	false
1537	tickets	open_date	1.0a100	12	time	false	false	false
1541	tickets	client_priority	1.0a100	13	string	false	false	false
1543	tickets	admin_priority	1.10	14	string	true	false	false
1545	tickets	status	1.0a100	15	string	false	false	false
1546	tickets	status_timeout	1.69	16	time	true	false	false
1548	tickets	contact_emails	1.0a125	17	string	false	false	false
1549	tickets	contact_phone_numbers	1.0a125	18	string	false	false	false
1550	tickets	internal_notes	1.69	19	string	false	false	false
751	time_zones	name	1.2	0	string	false	true	true	The unique name of this time zone
318	transaction_types	name	1.0a123	0	string	false	true	true	the name of the type
322	transaction_types	is_credit	1.0a123	1	boolean	false	false	true	indicates that this type of transaction represents payment or credit
299	transactions	time	1.0a100	0	time	false	false	false	the time the transaction occured
301	transactions	transid	1.69	1	pkey	false	true	false	the unique identifier for this transaction
302	transactions	accounting	1.0a100	2	accounting	false	false	false	the identifier for the business (see businesses)
303	transactions	source_accounting	1.0a100	3	accounting	false	false	false	the source of the charge to this account
304	transactions	username	1.0a100	4	username	false	false	false	the identifier for the admin involved in the transaction (see business_administrators)
305	transactions	type	1.0a100	5	string	false	false	false	the type of transaction
306	transactions	description	1.0a100	6	string	false	false	false	description of the transaction
307	transactions	quantity	1.0a100	7	decimal_3	false	false	false	the number of times to charge the account
309	transactions	rate	1.83.0	8	money	false	false	false	the amount per unit of quantity
310	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
311	transactions	payment_info	1.0a100	10	string	true	false	false	the payment info, such as last four of credit card number of check number
313	transactions	processor	1.29	11	string	true	false	false	the credit card processor that handled the payment
314	transactions	credit_card_transaction	1.29	12	fkey	true	false	false	the credit card transaction for this transaction
317	transactions	payment_confirmed	1.0a100	13	string	false	false	false	'Y' if the payment is confirmed 'W' if waiting confirmation 'N' if confirmation failed
127	us_states	code	1.0a100	0	string	false	true	true	the two-character code for the state
128	us_states	name	1.0a100	1	string	false	false	true	the name of the state
123	usernames	username	1.0a100	0	username	false	true	false	the unique username
125	usernames	package	1.80.0	1	accounting	false	false	false	the package name that this user is part of
126	usernames	disable_log	1.0a100	2	fkey	true	false	false	indicates that the username is disabled
612	virtual_disks	pkey	1.36	0	pkey	false	true	false	a generated unique ID
613	virtual_disks	virtual_server	1.36	1	fkey	false	false	false	the virtual server this disk belongs to
614	virtual_disks	device	1.36	2	string	false	false	false	the per-virtual-server unique device, such as xvda or xvdb
621	virtual_disks	minimum_disk_speed	1.41	3	int	true	false	false	the minimum disk speed in RPM for the primary physical server
622	virtual_disks	minimum_disk_speed_target	1.43	4	int	true	false	false	the minimum disk speed in RPM for the primary physical server
625	virtual_disks	extents	1.36	5	int	false	false	false	the total number of LVM extents for this device
626	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
627	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
632	virtual_disks	verify_day_of_week	1.72	8	int	false	false	false	the day of the week verification will begin
633	virtual_disks	verify_hour_of_day	1.72	9	int	false	false	false	the hour of day verification will begin
635	virtual_servers	server	1.92.2.4-SNAPSHOT	0	pkey	false	true	false	the server that is virtualized
636	virtual_servers	primary_ram	1.36	1	int	false	false	false	the amount of RAM required in primary mode in megabytes
637	virtual_servers	primary_ram_target	1.43	2	int	false	false	false	the amount of RAM required in primary mode in megabytes
638	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
639	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
640	virtual_servers	minimum_processor_type	1.41	5	string	true	false	false	the minimum processor type
643	virtual_servers	minimum_processor_architecture	1.36	6	string	false	false	false	the minimum processor architecture, compatible architectures may be substituted
644	virtual_servers	minimum_processor_speed	1.41	7	int	true	false	false	the minimum processor speed in MHz
645	virtual_servers	minimum_processor_speed_target	1.43	8	int	true	false	false	the minimum processor speed in MHz
648	virtual_servers	processor_cores	1.41	9	short	false	false	false	the number of processor cores
649	virtual_servers	processor_cores_target	1.43	10	short	false	false	false	the number of processor cores
652	virtual_servers	processor_weight	1.41	11	short	false	false	false	the processor allocation weight on a scale of 1-1024
653	virtual_servers	processor_weight_target	1.43	12	short	false	false	false	the processor allocation weight on a scale of 1-1024
657	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
659	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
660	virtual_servers	requires_hvm	1.37	15	boolean	false	false	false	indicates requires full hardware virtualization
661	virtual_servers	vnc_password	1.51	16	string	false	true	false	the password for VNC console access or null to disable VNC access
331	WhoisHistory	id	1.81.19	0	pkey	false	true	false	a unique, generated identifier
332	WhoisHistory	registrableDomain	1.81.19	1	domain_name	false	false	false	the registrable domain that was queried
333	WhoisHistory	time	1.81.19	2	time	false	false	false	the time the whois query was performed
334	WhoisHistory	exitStatus	1.81.19	3	int	true	false	false	the exit status from the whois lookup, null on exception
335	WhoisHistory	output	1.81.19	4	string	false	false	false	the output from the whois lookup
336	WhoisHistory	error	1.81.19	5	string	false	false	false	the error from the whois lookup
323	WhoisHistoryAccount	id	1.81.19	0	pkey	false	true	false	a unique, generated identifier
324	WhoisHistoryAccount	whoisHistory	1.81.19	1	fkey	false	false	false	the id of the WhoisHistory
325	WhoisHistoryAccount	account	1.81.19	2	accounting	false	false	false	the id of the Account

TABLE NAME

DESCRIPTION

TABLE ROWS