in the database (postgres) the columns are defined as numeric(10,0) with except to shelfheight:
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.