Table arcasys.posper_ticketline
Sales lines per ticket

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 255
posper_ticketline_tax.TicketLine_id FK2C3B28A2B8D3CB91 R
version int 10 Used for optimistic locking
amount double 22 Number of items sold
priceSell double 22 Sell price net at time of sales
taxRate double 22 Decimal tax rate 0..1 at time of sales
description varchar 255 Product description
ticket_ticketline varchar 255  √  null
posper_ticket.id FK8B6B84B6EE1E6456 R
Reference to posper_ticket
product_id varchar 255  √  null
posper_product.id FK8B6B84B667A34503 R
-
tax_id varchar 255
posper_tax.id FK8B6B84B61EDEB803 R
-
line_index int 10  √  null Line order number used by Hibernate
modifiers int unsigned 10  √  0 Active modifiers
discountReason_id varchar 255  √  null -
orderPrinted float 12  √  0 Print flag
comment varchar 255  √  null -
course tinyint 3  √  null -
status tinyint 3  √  null Used with Enjoy only
user_id varchar 255  √  null -
created_at datetime 19  √  null -
updated_at datetime 19  √  null -
parent_id varchar 255  √  null -
seat int 10  √  null Documentary
reserved bit 1  √  null
protect bit 1  √  null
priceOrig double 22  √  null
inactiveVoucher bit 1  √  null
comProduct bit 1  √  null
coupon bit 1  √  null

Table contained 2 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
tax_id Performance Asc FK8B6B84B61EDEB803
product_id Performance Asc FK8B6B84B667A34503
ticket_ticketline Performance Asc FK8B6B84B6EE1E6456
parent_id Performance Asc idx_parent_id

Close relationships  within of separation: