Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer Data Modeler Functionality for PK, FK, NK, and Pseudo Key

3218969Apr 12 2016 — edited Apr 13 2016

1. How can oracle show relationships between tables & identify the true primary keys without having the additional foreign keys in other/said tables. e.g. Product Number, Workflow, Workflow Step are PK in the 'Product Workflow Map' entity but appear as FK in the other entities.

2. If we use the 'pseudo key' approach how we show the natural keys as the true primary key? e.g. The pseudo key for entity 'Work Order Workflow' is 'Work Order Workflow ID' but the natural key would be 'Planned Workflow Step Completion Date'

pastedImage_0.png

Comments

Philip Stoyanov-Oracle

1. don't create surrogate keys as real attributes - set "Create surrogate Key" for entities

2. for relationships - set "Use surrogate keys" - FK attributes won't be created

  1. run "Columns order" transformation script if you want better ordering of columns

Philip

Surogate_keys.png

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2016
Added on Apr 12 2016
1 comment
2,515 views