civicrm_payment_token


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_id N

Payment Token ID

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_payment_token_contact_id C

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_id R
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_id N

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

Table contained 0 rows

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