Table arcasys.posper_product
Define products

 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
bo_new_prices.product_id FK_new_prices_product R
bo_price_labels.product_id FK_price_labels_product R
posper_productlocation.product_id FKFD9B9FAE67A34503 C
posper_specialprice.product_id FK_special_price_product R
posper_stockdiary.product_id FK36C93A2367A34503 C
posper_ticketline.product_id FK8B6B84B667A34503 R
posper_web_info.product_id FK_web_info_product R
speps_suporderlines.product_id FK_suporderlines_products R
version int 10 0 Used for optimistic locking
reference varchar 255 0 Article number, not necessarily unique
com bit 0 0 Helper product
scale bit 0 0 Is weighable
priceBuy double 22 -
priceSell double 22 -
stockCost double 22  √  null doc only
volume double 22  √  null doc only
displayOrder int 10  √  null -
inStock bit 0 1 -
description varchar 255 -
code varchar 255  √  null EAN or UPC
tax_id varchar 255 1
posper_tax.id FKB64408F91EDEB803 R
-
category_id varchar 255
posper_category.id FK_posper_product_3 R
-
image_id varchar 255  √  null
posper_image.id FKB64408F9BEC833C3 R
-
unitType varchar 255  √  Stk -
units double 22  √  1 -
supplier_id int 10  √  1
speps_suppliers.id FK_products_suppliers R
-
modifiers int 10  √  0 Excluded modifiers mask.
accountingLevel int 10 0 Bit mask
priceBase double 22  √  null For weighable products
actMod int 10  √  0 Active modifier mask
priceSell_1 double 22  √  null -
priceSell_2 double 22  √  null -
quantity_unit varchar 10  √  null Used by Backoffice for price labels
tare_id varchar 255  √  null Link to tare for weighable
course tinyint 3  √  null -
prep_time smallint 5  √  null Preparation time
description_ext text 65535  √  null Extended description, doc and Enjoy client
flags int 10  √  0 various propertiy flags
timed_availability varchar 255  √  null
web_info_available bit 0  √  null
created_at datetime 19  √  null -
updated_at datetime 19  √  null -
repl_avail_date date 10  √  null Availability of replacement product
repl_code varchar 255  √  null Code of replacement product
repl_date date 10  √  null Replacement date
timed_availability_to datetime 19  √  null -
erp_updated_at datetime 19  √  null Used by Backoffice for ERP updates

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
supplier_id Performance Asc FK_products_suppliers
tax_id Performance Asc FKB64408F91EDEB803
category_id Performance Asc FKB64408F980287071
image_id Performance Asc FKB64408F9BEC833C3
reference Must be unique Asc index_posper_product_on_reference

Close relationships  within of separation: