I am unable to generate Unsigned on a datatype in MySQL. How may I generate an unsigned datatype (4304976)

Question:

I am able to reverse engineer from a MySQL DBMS script a table that has a datatype that is unsigned.  E.g.,

CREATE TABLE TEST
(
x TINYINT UNSIGNED NULL
);

However, I am not able to find the unsigned selection in the column editor when picking datatypes for columns in erwin. How may I select an unsigned datatype using erwin? 

Solution:

Erwin currently does not support the unsigned on a datatype. However, what you can do to compensate is to create a domain that may be used to automatically assign the datatype as unsigned on the columns.  Then erwin will produce the unsigned on the datatypes during a Forward Engineer.

Create a new domain named similarly to the datatype you wish to generate. E.g., '_TINYINT_UNSIGNED'
For the Physical Data Type for the domain, type in 'TINYINT UNSIGNED'.

Click To See Full Image.

Create your new column in your table. For its domain, select '_TINYINT_UNSIGNED'.

Click To See Full Image.

Now when you forward engineer to your MySQL DBMS, that will produce SQL DDL similar to the following:

CREATE TABLE TEST
(
x TINYINT UNSIGNED NULL
);