hbci

5290 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
order_id VARCHAR 36 null
orders.id FK_EE3BFE268D9F6D38R
client_id VARCHAR 36 null
client.id FK_EE3BFE2619EB6921R
foreignId VARCHAR 39 null
bignore BIT 1 0
account VARCHAR 30 null
bookType VARCHAR 20 null
customerName VARCHAR 255 null
balance DECIMAL 10,2 null
valuta DATE 10 null
bookDate DATE 10 null
amount DECIMAL 10,2 null
reference LONGTEXT 2147483647 null
purpose LONGTEXT 2147483647 null
liability_id VARCHAR 36 null
liability.id FK_EE3BFE261E88FF9FR
outpayment BIT 1 null
accountBooking_id VARCHAR 36 null
accountbooking.id FK_EE3BFE26238B66F6R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_EE3BFE2619EB6921 Performance Asc client_id
IDX_EE3BFE261E88FF9F Performance Asc liability_id
IDX_EE3BFE26238B66F6 Performance Asc accountBooking_id
IDX_EE3BFE268D9F6D38 Performance Asc order_id

Relationships