Table Definitions: Sign-Up Requests

column	type	null	unique	references	referenced_by	since_version	description
pkey	pkey	false	true		signup_request_options.request	1.23	a generate unique id
brand	accounting	false	false	brands.accounting		1.44	the brand of the parent business for the new account
time	time	false	false			1.23	the time the request was added
ip_address	ip_address	false	false			1.23	the IP address of the user who signed-up
package_definition	fkey	false	false	package_definitions.pkey		1.23	the pkey of the Package Definition requested
business_name	string	false	false			1.23	the name of the business
business_phone	phone	false	false			1.69	the phone number of the business
business_fax	phone	true	false			1.69	the fax number of the business
business_address1	string	false	false			1.23	the street address of the business
business_address2	string	true	false			1.23	the street address of the business
business_city	string	false	false			1.69	the city of the business
business_state	string	true	false			1.69	the state or providence of the business
business_country	string	false	false	country_codes.code		1.69	the two-character country code of the business
business_zip	string	true	false			1.69	the zip code of the business
ba_name	string	false	false			1.23	the administrator's name
ba_title	string	true	false			1.23	the administrator's title
ba_work_phone	string	false	false			1.69	the administrator's work phone
ba_cell_phone	string	true	false			1.69	the administrator's cell phone
ba_home_phone	string	true	false			1.69	the administrator's home phone
ba_fax	string	true	false			1.69	the administrator's fax number
ba_email	email	false	false			1.23	the administrator's email address
ba_address1	string	true	false			1.23	the street address of the administrator
ba_address2	string	true	false			1.23	the street address of the administrator
ba_city	string	true	false			1.69	the city of the administrator
ba_state	string	true	false			1.69	the state or providence of the administrator
ba_country	string	true	false	country_codes.code		1.69	the two-character country code of the administrator
ba_zip	string	true	false			1.69	the zip code of the administrator
ba_username	username	false	false			1.23	the username of the administrator
billing_contact	string	false	false			1.23	the name of the billing contact
billing_email	email	false	false			1.23	the email address of the billing contact
billing_use_monthly	boolean	false	false			1.23	if true, the credit_card will be used every month automatically
billing_pay_one_year	boolean	false	false			1.23	if true, one-year in advance will be charged to the credit_card and they will receive a credit for a free month
encrypted_data	string	false	false			1.23	the credit card details and password are stored encrypted
encryption_from	fkey	false	false	encryption_keys.pkey		1.31	the from that was used for encryption
encryption_recipient	fkey	false	false	encryption_keys.pkey		1.31	the recipient that was used for encryption
completed_by	username	true	false	business_administrators.username		1.23	the username of the person who completed this sign-up request
completed_time	time	true	false			1.23	the time this request was completed

TABLE NAME

DESCRIPTION

COLUMNS