voucherreportitem

299 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id INT 10 null
users.id FK_7BED79A2A76ED395R
number INT 10 null
receiptNumber INT 10 null
date DATETIME 19 null
receiptBrutto DECIMAL 10,2 null
vat DECIMAL 10,2 null
bookingText VARCHAR 255 null
voucherReport_id VARCHAR 36 null
voucherreport.id FK_7BED79A279443B8AR
voucherNumber VARCHAR 255 null
reference VARCHAR 255 null
order_id VARCHAR 36 null
orders.id FK_7BED79A28D9F6D38R
signature VARCHAR 255 null
publicKeyObject_id VARCHAR 36 null
publickey.id FK_7BED79A23B0ABC10R
uniqNumber VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_7BED79A23B0ABC10 Performance Asc publicKeyObject_id
IDX_7BED79A279443B8A Performance Asc voucherReport_id
IDX_7BED79A28D9F6D38 Performance Asc order_id
IDX_7BED79A2A76ED395 Performance Asc user_id
UNIQ_7BED79A2C20EA752 Must be unique Asc uniqNumber

Relationships