Table arcasys.posper_ticket
Sales ticket if number>0, utility ticket if number=0

 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_payment.ticket_id FK99D26E105CE17F71 C
posper_ticketline.ticket_ticketline FK8B6B84B6EE1E6456 R
version int 10 Used for optimistic locking
visibleId int 10  √  null -
dateOpen datetime 19  √  null Creation date
dateClose datetime 19  √  null -
synched bit 0  √  null Used with ERP systems
number int 10  √  null Serial number for closed sales tickets
host varchar 30  √  null Defines the register the ticket belongs to.
parent_id varchar 255  √  null
posper_cashregister.id FKA0D585C237714FBD C
Related Cashregister, can alo be a CANELED-Register or a delivery invoice
userid varchar 255  √  null
posper_user.id FKA0D585C2E68378E8 R
-
place_id varchar 255  √  null
posper_place.id FKA0D585C261340443 R
-
customer_id varchar 255  √  null
posper_customer.id FK_ticket_cusotmer R
-
dateDelivered datetime 19  √  null Set if delivery ticket
dateDueDelivery datetime 19  √  null -
comment varchar 255  √  null -
updated_at datetime 19  √  null -
status int 10  √  0 Currently not used
guests smallint 5  √  null Informational
newsURL varchar 255  √  null
orderCode varchar 255  √  null Order code from a foreign ERP system for back reference (if erpmode=true
erp_updated_at datetime 19  √  null
signature text 65535  √  null
created_at datetime 19  √  null
turnover decimal 19,2  √  null
reference int 10  √  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
customer_id Performance Asc FK_ticket_customer
parent_id Performance Asc FKA0D585C237714FBD
place_id Performance Asc FKA0D585C261340443
userid Performance Asc FKA0D585C2E68378E8
host Performance Asc Index_7
dateClose Performance Asc Index_dateClose
host Performance Asc index_posper_ticket_on_host
dateDueDelivery Performance Asc indexDateDueDelivery

Close relationships  within of separation: