The logical data model-to-UML transformation generates
UML primitive types from data types for the logical data model.
The following table shows the correspondence between data
types for logical data models and UML primitive types.
Table 1. Logical data model to UML data type mappingsLogical data model data types |
UML primitive types that the transformation
generates |
BINARY (length) |
BINARY (length) |
BLOB (length) |
BLOB (length) |
BOOLEAN |
Boolean |
CHAR |
Byte |
CHAR (length) |
CHAR (length) |
CLOB (length) |
CLOB (length) |
CURRENCY |
Currency |
DATALINK (length) |
DATALINK (length) |
DATE |
Date |
DECIMAL (precision,scale) |
DECIMAL (precision,scale) |
DOUBLE |
Double |
FLOAT (precision) |
FLOAT (precision) |
INTEGER |
Integer |
INTERVAL |
Interval |
LONG |
Long |
LONG VARBINARY |
Long Varbinary |
LONG VARCHAR |
Long Varchar |
NCHAR (length) |
NCHAR (length) |
NCLOB |
Nclob |
NUMERIC (precision,scale) |
Numeric (precision,scale) |
NVARCHAR (length) |
NVARCHAR (length) |
REAL |
Real |
ROWID |
Rowid |
ROWVERSION |
Rowversion |
SERIAL |
Serial |
SHORT |
Short |
TIME |
Time |
TIMESTAMP |
Timestamp |
TINY |
Tiny |
VARBINARY (length) |
VARBINARY (length) |
VARCHAR (length) |
VARCHAR (length) |
XML |
XML |