Table arcasys.posper_reservation
Used when erpmode=true (customer specific function:
eligible products can have a reservation assigned to the ticketline

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
version int 10 Used for optimistic locking
customer varchar 255  √  null -
chairs int 10 Number of persons
date datetime 19  √  null
done bit 0 -
description varchar 255  √  null -
reservationDate datetime 19  √  null Start of reservation
resourceType varchar 255  √  null customized
resource_id varchar 255  √  null e.g. line_id
slots int 10  √  null Number of slots
slotLength int 10  √  null Lenght of reservation slot in min
created_at datetime 19  √  null
updated_at datetime 19  √  null -

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY