cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Armstrong" <siber...@gmail.com>
Subject Re: Creating Compound PKs
Date Mon, 04 Jun 2007 06:25:13 GMT
Yes, sorry misplaced that bit of important information.

ImapServer
account
id
password
serverip

Tx
John-



On 6/3/07, Andrus Adamchik <andrus@objectstyle.org> wrote:
> Hi John,
>
> A question - is "serverid" a foreign key to another table by any chance?
>
> Andrus
>
>
> On Jun 4, 2007, at 9:09 AM, John Armstrong wrote:
>
> > Does Cayenne allow for the creation of a compound PK? I searched the
> > archives and google more generally and could only find hints at this.
> > The docs did not clarify either (although it was also hinted at. .I
> > think, its a bit late :) ).
> >
> > My table looks like this:
> >
> > id
> > name
> > serverid
> > status
> > enabled
> >
> > I need to create a compound PK on name/serverid that will maintain
> > uniqueness across these segments.
> >
> > My fallback is to create a validation that checks these before commit
> > but my normal route in a non-ORM context is to let the DB enforce it
> > and catch it there.
> >
> > Thanks!
> > John-
> >
>
>

Mime
View raw message