productstatistics

10912 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_C1EF9CB24584665AR
client_id VARCHAR 36 null
client.id FK_C1EF9CB219EB6921R
salesLastMonth DECIMAL 10,3 null
salesCustomPeriod DECIMAL 10,3 null
minPurchasePrice DECIMAL 10,4 null
salesLastYear DECIMAL 10,3 null
salesNextMonthLastYear DECIMAL 10,3 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_C1EF9CB219EB6921 Performance Asc client_id
IDX_C1EF9CB24584665A Performance Asc product_id

Relationships