Physical data model, the fields that exist in each table, how to abstract, inherit, synchronize

How To
,
1

For example, all my tables have the same CREATED_BY, LAST_MODIFIED_DATE_TIME, LAST_MODIFIED_BY, VERSION fields. When I modify the length of the CREATED_BY field, I think any of the following methods can be used.

  1. I hope that all tables will be updated synchronously
  2. Abstract base table, all table inheritance

How can I achieve this?

image
image1135×571 37.9 KB

2

How to quickly update the same column name visual-paradigm

3

You could use Database Domains (Column Domains and Entity Domains). They do what you need (sort of).

1%20-%20domains
1%20-%20domains1443×1072 119 KB

1 Like
4

Hi gemisigo， How do I click on Database Domains? I did not find the menu.

5

Because you don’t have any yet. Open Entity/Column Specification dialog, Dropdown Domain and select Configure Domains. See screenshots:

image
or here Using Entity Domain

and

image
or here Using Column Domain

After that, it should be shown in the Model Explorer.

1 Like
6

Thanks gemisigo.