Table arcasys.posper_tax
Tax rates. Can also be zero tax for special items like coupon sales.

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_customer.tax_id FK7232C5141EDEB803 R
posper_product.tax_id FKB64408F91EDEB803 R
posper_ticketline.tax_id FK8B6B84B61EDEB803 R
posper_ticketline_tax.taxes_id FK2C3B28A2432CFB55 R
version int 10 Used for optimistic locking
visibleId int 10  √  null -
rate double 22 Tax rate decimal 0..1
tax_name varchar 255 -

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
visibleId Must be unique Asc visibleId This unique column is also nullable

Close relationships  within of separation: