cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Creating Compound PKs
Date Mon, 04 Jun 2007 06:21:05 GMT
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