Decimal scale and precision in an ERD
When choosing CHAR or VARCHAR for a column, the user is allowed to specify the size as an integer value. So entering 5 into the field would display CHAR(5) or VARCHAR(5) in the diagram. However, for DECIMAL columns, there should be two values - PRECISION which represents the total length of the number and SCALE represents the decimal places. So, DECIMAL(5,2) can represent a maximum value of 999.99 for the column. The functionality for having two fields to enter such values should be added to StarUML. If the SCALE field is empty, then it wouldn't be displayed in the diagram, however if it is 0 then the zero value should be displayed. Currently the workaround is to just set DECIMAL(5,2) in the type field.