Table arcasys.posper_valuecard
Registrered value cards

 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
visibleId int 10 -
series int 10  √  null Creation series.
amount double 22  √  null Value in main currency
issue_date date 10  √  null -
opt1 varchar 255  √  null customer specific use
opt2 varchar 255  √  null customer specific use
opt3 varchar 255  √  null customer specific use
opt1..3 ares aved in posper_payment.name
consumed bit 0  √  null true invalidates the card
valid_from datetime 19  √  null -
valid_to datetime 19  √  null -
description varchar 255  √  null documentary

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
visibleId Must be unique Asc visibleId