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

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,513 views