Default type maps of the UML to SQL (Generic / Oracle) transformations remap the types that are commonly used in the UML modeling domain (such as String) into types that are suitable for SQL domain (such as varchar).
UML to SQL Type Map
The default type map for these transformations is stored in the UML to SQL Type Map profile and automatically gets attached to your project at the 3rd step (the type mapping step) of the transformation wizard. If necessary it can be changed.
The Default map carries the following type conversions.
| Source Type | Result Type |
|---|---|
| String | varchar (default) varchar2 char varying character varying nvarchar nvarchar2 nchar varying national char varying national character varying longvarchar long varchar char character nchar national char national character long char |
| short | smallint |
| long | number(20) |
| Integer | integer |
| int | int |
| float | float |
| double | double precision |
| date | date |
| char | char(default) character nchar national char national character |
| byte | number(3) |
| boolean | number(1) |
If you have a situation when one type map imports another type map, you can specify another default mapping rule. Such situation appears, for example, in the Oracle type map, inheriting from the Standard type map where the Oracle mapping rule String-->varchar2 overrides the base mapping rule String-->varchar. For more information about the type mapping, see Transformation Type Mapping and Controlling Type Mapping Rule Behavior in MagicDraw User Guide.
Note
This feature is available with MagicDraw 18.0 SP1 or later.