ecreportitem

457 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id INT 10 null
users.id FK_4313015BA76ED395R
number INT 10 null
receiptNumber INT 10 null
date DATETIME 19 null
account VARCHAR 255 null
receiptBrutto DECIMAL 10,2 null
vat DECIMAL 10,2 null
bookingText VARCHAR 255 null
ecReport_id VARCHAR 36 null
ecreport.id FK_4313015B5FFE0628R
transactionId VARCHAR 255 null
bookingType INT 10 null
reference VARCHAR 255 null
order_id VARCHAR 36 null
orders.id FK_4313015B8D9F6D38R
signature VARCHAR 255 null
publicKeyObject_id VARCHAR 36 null
publickey.id FK_4313015B3B0ABC10R
payment_id VARCHAR 36 null
payment.id FK_4313015B4C3A3BBR
uniqNumber VARCHAR 255 null
wormSignature LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_4313015B3B0ABC10 Performance Asc publicKeyObject_id
IDX_4313015B4C3A3BB Performance Asc payment_id
IDX_4313015B5FFE0628 Performance Asc ecReport_id
IDX_4313015B8D9F6D38 Performance Asc order_id
IDX_4313015BA76ED395 Performance Asc user_id
UNIQ_4313015BC20EA752 Must be unique Asc uniqNumber

Relationships