liabilitypayment

79 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
payment_id VARCHAR 36 null
payment.id FK_153A78114C3A3BBR
liability_id VARCHAR 36 null
liability.id FK_153A78111E88FF9FR
timestamp DATETIME 19 null
total DECIMAL 10,2 null
paymentTransactionId VARCHAR 128 null
note VARCHAR 255 null
paymentFee DECIMAL 10,2 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_153A78111E88FF9F Performance Asc liability_id
IDX_153A78114C3A3BB Performance Asc payment_id

Relationships