Table arcasys.posper_payment
Payments made for a ticket. One ticket can have multiple payments.

 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
amount double 22 Payment amount.-
method varchar 255 Payment method.
ticket_id varchar 255  √  null
posper_ticket.id FK99D26E105CE17F71 C
Referrence to ticket.
comment varchar 45  √  null Payment or customer specific use, e.g. card circuit
cashregister_id varchar 255  √  null
posper_cashregister.id FK_payment_register R
Reference to cashregister
serial int 10  √  null Serial nuber for not sales related in and out payments.
name varchar 50  √  null Payment or customer specific use.
currency_code varchar 3  √  null For foreign currency only.
conversion_rate double 22  √  null For foreign currency only: current rate
card_number varchar 255  √  null Normally not used.
holder_name varchar 255  √  null Normally not used.
auth_code varchar 255  √  null Used for CC payments.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
ticket_id Performance Asc FK99D26E105CE17F71
cashregister_id Performance Asc FK_payment_register

Close relationships  within of separation: