Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Syncing of foreign key attribute data types in logical model

Vesa PurhoAug 26 2019 — edited Sep 4 2019

Hi,

I have a relationship between two entities. The primary key of entity A is a foreign key in Entity B. The primary key was originally a NUMERIC with precision 7 and scale 0. Then I changed the precision of the attribute in entity A to be 10. Is there a way to sync / refresh the change to the foreign keys in related tables?They still show with precision 7. When I engineer the model to a relational model, the precisions are there correctly both 10.

Logical model:

pastedImage_0.png

Relational model after engineering from logical model:

pastedImage_1.png
This post has been answered by Philip Stoyanov-Oracle on Sep 2 2019
Jump to Answer
Comments
Post Details
Added on Aug 26 2019
7 comments
2,353 views