cashreportitem

5293 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.cashReportItem_id FK_3E0BC42E67049442R
number INT 10 null
receiptNumber INT 10 null
date DATETIME 19 null
receiptBrutto DECIMAL 10,2 null
outcomeBrutto DECIMAL 10,2 null
vat DECIMAL 10,2 null
bookingText VARCHAR 255 null
cashReport_id VARCHAR 36 null
cashreport.id FK_AA0D882856092CER
account VARCHAR 255 null
user_id INT 10 null
users.id FK_AA0D882A76ED395R
bookingType INT 10 null
receiptFile VARCHAR 255 null
reference VARCHAR 255 null
order_id VARCHAR 36 null
orders.id FK_AA0D8828D9F6D38R
signature VARCHAR 255 null
publicKeyObject_id VARCHAR 36 null
publickey.id FK_AA0D8823B0ABC10R
uniqNumber VARCHAR 255 null
wormSignature LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_AA0D8823B0ABC10 Performance Asc publicKeyObject_id
IDX_AA0D882856092CE Performance Asc cashReport_id
IDX_AA0D8828D9F6D38 Performance Asc order_id
IDX_AA0D882A76ED395 Performance Asc user_id
UNIQ_AA0D882C20EA752 Must be unique Asc uniqNumber

Relationships