Re: Mixed PKs?
Re: Mixed PKs?
- Subject: Re: Mixed PKs?
- From: Giorgio Valoti <email@hidden>
- Date: Wed, 2 Jul 2003 05:41:57 -0700
On Lunedl, giu 30, 2003, at 15:26 US/Pacific, B. Shank wrote:
I assume you're referring to compound keys. If so, see
http://developer.apple.com/documentation/WebObjects/
Enterprise_Objects/Saving/chapter_8_section_8.html#//apple_ref/doc/
uid/DontLinkBookID_460-DontLinkChapterID_8-BADJEBIB
Brent
On Monday, June 30, 2003, at 2:16PM, Ricardo Strausz wrote:
Hola!
does EOF supports multiple PKs generation?
Let me be more specific: in a one-to-many relation (say
Invoices->>Details) I want to give Details a double PK; the invoices
PK and a consecutive number.
Can EOF (in its lateest version) do this for me?
Gracias,
EOF cannot generate compound primary keys, nor a RDBMS can for that
matter. Compound PK are usually composed by two or more foreign keys,
so they cannot be automatically generated. However, an auto-generated
primary key can be used for performance reasons, but some more
constraints should be enforced.
In your specific case, the Details PK is enough to uniquely identify a
record: adding the Invoice PK brings no advantages.
HTH
--
Giorgio Valoti
-------------
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.