Won't my primary keys get too big to handle? Is int(11) in mysql sufficient enough?
On Wed, Jul 27, 2011 at 7:02 PM, Ramsey Gurley <[email protected]>wrote: > > On Jul 27, 2011, at 5:23 PM, Chuck Hill wrote: > > > > > On 2011-07-27, at 5:21 PM, Ted Archibald wrote: > > > >> With a project I'm working on I decided to have a number of my entities > inherit from an abstract entity. Each of these entities have their own > separate table (I forget what kind of inheritance that's called...). > > > > Horizontal. > > > More info here: > > > http://wiki.objectstyle.org/confluence/display/WO/Modeling+Inheritance+with+Entity+Modeler > > > >> I noticed that EOF is only generating a single series of PKs for the > abstract parent entity and not PKs for each child entity. I read somewhere > that that's what EOF likes to do with inheritance. But considering I'd > never be dealing with the abstract entity, is there a way to make EOF give > PKs to each individual entity? > > > > There is probably a way, but it will lead to corrupt data or other > problems. EOF needs all the EOs in a hierarchy to have a unique key > regardless of entity. > > > > > > Chuck > > > You could do it in a custom EOAdaptor, but it won't function. OpenBase > plugin does this (last time I used it), and as a result, the only > inheritance that works on OpenBase is single table. > > EOF depends on keys that are unique across all the subclasses, because EOF > needs the keys to be unique to create a relationships to the parent > entities. Otherwise, what is the FK for a relationship to your parent if > both tables have overlapping PKs? > > It will sorta work with horizontal until you start making relationships. > It would be fundamentally incompatible with vertical because of the way the > pk is shared across multiple tables. > > Ramsey > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
