Table arcasys.posper_specialprice
Define prices for special sales, e.g. happy hour, seasonal, etc.

 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
product_id varchar 255
posper_product.id FK_special_price_product R
-
priceSell double 22  √  null Sell price net
priceBuy double 22  √  null buy price net
timer varchar 255  √  null timer string similar to cron expressions
date_from datetime 19  √  null -
date_to datetime 19  √  null -
replacement_id varchar 255  √  null obsolete, replaced by posper_product.repl_code
locked bit 0  √  null -

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

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

Close relationships  within of separation: