| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: designer 6.0 question
Joe,
You won't get that on an entity relationship diagram (ERD) in Designer. However, when you transform the entity to get a table definition, then you will get the foreign key column in the child table. Make sure that you have the primary unique identifier identified on the parent entity (has the # symbol on the ERD). In the table definition, it will become the primary key. Please tell me that all your components of that UID are mandatory. Transform the parent entity before transforming the child entity or transform them together. The server model diagram can be used to verify that the table definitions are correct. Think of the sever model as the more physical representation of the logical ERD. It will have the picture that you are looking for. Good Luck! Maggie
Respectfully,
> Maggie Tompkins - CAD SQA
> Corporate Applications Division
> Technology Services Organization - Kansas City
> Defense Finance and Accounting Service
> 816-926-1117 (DSN 465); Margaret.Tompkins_at_dfas.mil
>
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jtesta_at_dmc-it.com
Sent: Wednesday, March 17, 2004 2:50 PM
To: oracle-l_at_freelists.org
Subject: designer 6.0 question
Yea, I know its old but its what i'm currently having to use.
that being said, anyone on the list remember using designer 6.0. I've used ERWIN off/on for years and remember Erwin doing the following:
when creating a relationship between 2 entities and the uniq ID is already defined, the PK from the parent would migrate as an attribute to the child and show up in the child entity as an attribute. I can't seem to get designer to do that.
although if i get all the way thru and generate DDL, the column is in the create table statement for the child.
Anyone know what the heck I'm talking about?
thanks, joe
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 17 2004 - 15:04:15 CST
 |
 |