Table arcasys.posper_stockdiary
Record a stock movement

 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 Used for optimistic locking
price double 22 Buy price net
reason int 10 Reason codes:
1=in_purchase
2=in_refund
4=in_movement
-1=out_sale
-2=out_refund
-3=out_break
-4=out_movement
units double 22 Number of units
date datetime 19 -
location_id varchar 255
posper_location.id FK36C93A23B3B86111 R
-
product_id varchar 255
posper_product.id FK36C93A2367A34503 C
-
priceSell double 22  √  null Sell price net
modifiers int 10  √  null Active modifiers
synced bit 0  √  null

Table contained 5 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 FK36C93A2367A34503
location_id Performance Asc FK36C93A23B3B86111

Close relationships  within of separation: