RE: designer 6.0 question
- From: "TOMPKINS, MARGARET" <MARGARET.TOMPKINS@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 15:05:01 -0600
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@xxxxxxxx
>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of jtesta@xxxxxxxxxx
Sent: Wednesday, March 17, 2004 2:50 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
