Measure units
Index of tables:

Table tbl_ec_measureunit -- List of measure units5.3

Field name Field description Field type Field size key required default Observation
um_code Code of unit measure VARCHAR 20 yes yes    
code_lng Language code VARCHAR 2 yes yes IT  
um_descr Unit measure escription VARCHAR 255        
um_note Note TEXT 1        

Table tbl_ec_measureunit_conversion -- conversion rules5.3

Field name Field description Field type Field size key required default Observation
umc_prodcode Product code VARCHAR 100 yes yes    
umc_code Measure unit code VARCHAR 20 yes      
umc_convratio Conversion rate DOUBLE       1  
umc_buyingmutiple Buying multiple of DOUBLE          
umc_default Flag to b shown as default in measure units combo TINYINT 2     0