Table arcasys.posper_customerdiscounts
Define customer specific pricing

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 0 Used for optimistic locking
discount double 22  √  null Percentage rate
customer_id varchar 255  √  null Set if customer specific discount
product_id varchar 255 -
customergroup_id varchar 255  √  null
posper_customergroup.id fk_customergroup_id R
Set if customer group specific discount

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
customergroup_id Performance Asc idx_customergroup_id
customer_id Performance Asc index_customerdiscount_on_customer_id
product_id + customer_id Must be unique Asc/Asc index_customerdiscount_on_product_id_and_customer_id

Close relationships  within of separation: