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

database
erd

#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?


#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).


#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 https://www.visual-paradigm.com/support/documents/vpuserguide/3563/3564/85379_usingentityd.html

and

image
or here https://www.visual-paradigm.com/support/documents/vpuserguide/3563/3564/85380_usingcolumnd.html

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


#6

Thanks gemisigo.