wallet


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
cardonfile.walletId FK_cardOnFile_walletId R
gatewayName VARCHAR 150 null
gatewayProfileId VARCHAR 255 null
customerId INT 10 null
customer.id FK_wallet_customerId R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_wallet_customerId Performance Asc customerId
UK_wallet_gatewayCustomer Must be unique Asc/Asc gatewayName + customerId

Relationships