Table Definitions: Credit Cards

column	type	null	unique	references	since_version	description
pkey	pkey	false	true		1.0a100	primary key value
processor_id	string	false	false	credit_card_processors.provider_id	1.29	the unique ID of the merchant services provider that is storing the card number and expiration date
accounting	accounting	false	false	businesses.accounting	1.0a100	the accounting code for the card
group_name	string	true	false		1.29	any application-specific grouping
card_info	string	false	false		1.0a100	the masked card number
expirationMonth	short	true	false		1.82.0	the card expiration month
expirationYear	short	true	false		1.82.0	the card expiration year
provider_unique_id	string	false	false		1.29	the per-provider unique ID allowing use of this credit card for new transactions
first_name	string	false	false		1.29	the first name
last_name	string	false	false		1.29	the last name
company_name	string	true	false		1.29	the company name
email	email	true	false		1.29	the email address
phone	phone	true	false		1.29	the daytime phone number
fax	phone	true	false		1.29	the fax number
customerId	string	true	false		1.82.1	the merchant-specific unique customer ID
customer_tax_id	string	true	false		1.29	the social security number of employer identification number
street_address1	string	false	false		1.29	the first line of the street address
street_address2	string	true	false		1.29	the second line of the street address
city	string	false	false		1.69	the card holders city
state	string	true	false		1.69	the card holders state
postal_code	string	true	false		1.69	the card holders postal code
country_code	string	false	false	country_codes.code	1.69	the two-character country code
created	time	false	false		1.0a100	the time the card was added to the database
created_by	username	false	false	business_administrators.username	1.0a100	the business_administrator who added the card to the database
principal_name	string	true	false		1.29	the application-provided principal name of the person added the card to the database
use_monthly	boolean	false	false		1.0a100	if `true` the card will be used monthly
active	boolean	false	false		1.0a100	if `true` the card is currently active
deactivated_on	time	true	false		1.0a100	the time the card was deactivated
deactivate_reason	string	true	false		1.0a100	the reason the card was deactivated
description	string	true	false		1.0a100	any comment or description
encrypted_card_number	string	true	false		1.31	the card number stored encrypted
encryption_card_number_from	fkey	true	false	encryption_keys.pkey	1.31	the from that was used for card number encryption
encryption_card_number_recipient	fkey	true	false	encryption_keys.pkey	1.31	the recipient that was used for card number encryption

TABLE NAME

DESCRIPTION

COLUMNS