db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Spezifikum <i...@spezifikum.com>
Subject how to make two attributes unique?
Date Mon, 10 Oct 2011 08:19:39 GMT
Hi,
i have organisational units (ou) within divisions. The name within the 
division should be unique.
ou:
name=CHAR(80)
divisionID=INT CONSTRAINT OperationalUnitDivisionID_FK REFERENCES division

These two attributes should be unique in combination.
I only found many examples on how to make one attribute unique, but i 
guess this is a dumb newbie question - sorry.
As a side note: There never will be OUs nested within OUs.

Thanks
Malte

Mime
View raw message