Consistent ShelfHeight, ShelfDepth, ShelfWidth in m_product and i_product

Description

in the database (postgres) the columns are defined as numeric(10,0) with except to shelfheight:
i_product
shelfwidth numeric(10,0),
shelfheight numeric(10,0),
shelfdepth numeric(10,0),
m_product
shelfwidth numeric(10,0),
shelfheight numeric,
shelfdepth numeric(10,0),


in the ad-column-definition the columns refer (Reference) to Interger and shelfheight to Amount.

So the user see in the product window the value of shelfwidth like 0.00, but you cannot insert 1.50 (means 1meter 50cm). It is stripped to 1.00 since it is referenced to integer.
It confused, because at shelfheight you can insert the value 1.555 - due to the definition as amount.


I think the definition should be consistent over the 3 attributes. What do you think?

By tha way. What is the best unit for these attributs? It is a length, metric on non-metric. So it is a length-amount. If so, the target definition for the attributes is numeric in the db and amount as reference in the column-definition. This would be equivalent to the product-attributes Volume and Weight.

Also consistent is numeric(10,0) and Interger. But in my opinion it is the second best solution.

Environment

postgres-db

Status

Assignee

Carlos Ruiz

Reporter

eugen hanussek

Labels

None

Tested By

None

Components

Priority

Minor
Configure