Visual Paradigm support wide range of databases for user to model the data structure of their systems. Once the data model is done you can generate persistent layer source code in Hibernate and use it as the out-of-the-box data access layer for building your database applications. All the data types which covered by Hibernate are directly supported by Visual Paradigm. But what if your model involved some domain specific data type which not covered by Hibernate? In this case you can make use of the User Type property to model it. To model with non-supported column types:
- Make sure a default database had been selected for your project. You can specify the project database at Tools > DB > Database Configuration.
- Select the database which you are modeling with. Specify the database connection information if you also wish to generate database from your ER model.
- Press OK to close Database Configuration dialog.
- Right click on the column and select Open Specification from popup menu.
- Specify the custom column type in the User Type.
- Press OK to close the Column Specification.
- Right click on the blank area of the diagram and select Presentation Options > Entity Column Display Options > Show Column User Type.
- Now the column will display with the custom type you defined. When generate database the custom type will also be used.