HOPEX Database Builder (Web) : MEGA Database Builder : Attribute and Column Types : Determining Column Datatypes from Attribute Types
   
Determining Column Datatypes from Attribute Types
 
Pivot Types
List of pivot types
Connecting a Datatype to a Pivot Type
Connecting a Datatype to a Pivot Type in UML Notation
By inheritance
By a correspondence link
By an equivalence link
By creating a compound datatype
Datatypes defined at the logical level level are not always comprehensible for the target DBMS. In this case, they need to be converted to datatypes corresponding to the target DBMS.
This conversion intervenes notably at synchronization. Datatypes of attributes defined in the logical model are translated to datatypes for the generated columns.
Conversion is assured by an equivalence link with pivot types. The pivot types are an intermediary between logical datatypes and generated datatypes.