Table arcasys.posper_productlocation
Links products to warehouses

 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
stockMaximum double 22  √  null Used by Backoffice to calculate an order proposal
stockSecurity double 22  √  null Used by Backoffice for stock warning
location_id varchar 255 100
posper_location.id FKFD9B9FAEB3B86111 R
-
product_id varchar 255
posper_product.id FKFD9B9FAE67A34503 C
-

Table contained 3 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 FKFD9B9FAE67A34503
location_id Performance Asc FKFD9B9FAEB3B86111
location_id + product_id Must be unique Asc/Asc Index_4
product_id + location_id Must be unique Asc/Asc index_posper_productlocation_on_product_id_and_location_id

Close relationships  within of separation: