paymentmethod


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
cardonfile.paymentMethodId FK_cardOnFile_paymentMethodId R
paymentview.paymentMethodId Implied Constraint R
postransaction.paymentMethodId FKh5gkxi5ao9ocxbtne20jgov27 R
postransaction_aud.paymentMethodId Implied Constraint R
active BIT 1 null
editable BIT 1 null
name VARCHAR 31 √ null
typeId INT 10 null
paymenttype.id FKeq9277omrm3qotlh0tku6rb1s R
depositAccountId INT 10 √ null
asaccount.id FK_depostAccount R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_depostAccount Performance Asc depositAccountId
FKeq9277omrm3qotlh0tku6rb1s Performance Asc typeId
UKmd45k6uwo4vuy717f69qm0kfm Must be unique Asc name

Relationships

Close relationships within degrees of separation