Table d47civi_0z3xa.civicrm_payment_token Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_contribution_recur.payment_token_id FK_civicrm_contribution_recur_payment_token_id N
Payment Token ID
contact_id int unsigned 10
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
civicrm_payment_processor.id FK_civicrm_payment_token_payment_processor_id R
token varchar 255 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 at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: