| 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
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
thanks to all of you who proved i was not insane(at least on the designer 6.0 question).
I'll quit looking for something that does not exist.
joe
John Flack wrote:
|The relationship never shows up as an attribute, unless you add the
attribute yourself. It only shows up as a column when you run the
Database Design Transformer (DDT) and convert your entities to tables
and attributes to columns. There are some DDT options to control how
that happens. DDT also creates surrogate PK columns and the sequences
to generate them whenever you don't designate an attribute or set of
attributes as the PK.
|
|This part of Designer hasn't changed very much from 6 to 6i and 9i.
|
|-----Original Message-----
|From: jtesta_at_dmc-it.com [mailto:jtesta_at_dmc-it.com]
|Sent: Wednesday, March 17, 2004 3: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
|----------------------------------------------------------------
|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
|-----------------------------------------------------------------
|
iD8DBQFAWMnzR8fSap71V7YRAhMYAJ9K79Q4woXqAETLWi989F2TbrdZNACfddNp
KUe9+p8IndN8/jIImulw9t0=
=cOGu
-----END PGP SIGNATURE-----
-- 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:56:48 CST
 |
 |