How can I add datatypes to the ERDiagram?

General Questions/Discussions
1

HI! I need set datatype text and datetime in my Entity Relationship Diagram (ERD). How can I add this type-data to select when I add a colum??

I have VP Enterprise Edition 10.0, but I don’t know how can I add this, I only have this data types adn I need others…: https://gyazo.com/e42593a78afd7f44ea6e5020395a512c

Thanks!

2

Dear antfdez,

Thank you for your inquiry. The available data type is subject to the database you selected for your project (Tools > DB > Database Configuration). In case you wish to model with the non-standard data type then you can reference to the article below about how it works.

Best regards,
Rain Wong

3

Set data types for the columns in a database model table

1.Double-click the shape for the table that has the columns that you want to set data types for.

  1. In the Database Properties window, under Categories, click Columns.

  2. Click the cell in the Data Type column that you want to change.

  3. Click the down arrow next to the current data type and choose a different data type from the list.

Customizing programming language and data types[b]

By default, there are six types of predefined (programming) languages. Each of them consists of a set of supported data types.

  1. Open the Project Options window by selecting Window > Project Options from the main menu.
  2. Choose Data Type from the list on the left hand side of the Project Options window.
  3. In the Data Type page, click the + button under Languages: to add a language.
  4. Enter its name, and press OK button to confirm.
  5. Press Add… button to add a data-type to the chosen language.
  6. Enter its name and press OK to confirm. From now on, once you have set your own language as the language for your project, you can pickup the associated data-types as attribute type, operation return type and parameter type.

Thanks !!!

4

in ER diagram each element have different representation. The datatype is an important element of database. We can get data type visible in the entity box and changes in setting on diagram level in right way