civicrm_payment_token

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_contribution_recur.payment_token_id FK_civicrm_contribution_recur_payment_token_idN

Payment Token ID
contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_payment_token_contact_idC

FK to Contact ID for the owner of the token
payment_processor_id INT UNSIGNED 10 null
civicrm_payment_processor.id FK_civicrm_payment_token_payment_processor_idR
token VARCHAR 255 null

Externally provided token string
created_date TIMESTAMP 19 CURRENT_TIMESTAMP

Date created
created_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_payment_token_created_idN

Contact ID of token creator
expiry_date DATETIME 19 √ null

Date this token expires
email VARCHAR 255 √ null

Email at the time of token creation. Useful for fraud forensics
billing_first_name VARCHAR 255 √ null

Billing first name at the time of token creation. Useful for fraud forensics
billing_middle_name VARCHAR 255 √ null

Billing middle name at the time of token creation. Useful for fraud forensics
billing_last_name VARCHAR 255 √ null

Billing last name at the time of token creation. Useful for fraud forensics
masked_account_number VARCHAR 255 √ null

Holds the part of the card number or account details that may be retained or displayed
ip_address VARCHAR 255 √ null

IP used when creating the token. Useful for fraud forensics

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_payment_token_contact_id Performance Asc contact_id
FK_civicrm_payment_token_created_id Performance Asc created_id
FK_civicrm_payment_token_payment_processor_id Performance Asc payment_processor_id

Relationships

Close relationships within degrees of separation