Re: Cross-table constraint

2009-11-10 Thread Johan De Meersman
I think triggers are your only option, here. On 11/9/09, Sebastiaan van Erk wrote: > Hi, > > I have the following model: > > Domain (*)<-(1) Account (*)<-(1) User > > That is, each user belongs to exactly 1 account, an account can have > multiple users; each account belongs to a single domain, an

Cross-table constraint

2009-11-09 Thread Sebastiaan van Erk
Hi, I have the following model: Domain (*)<-(1) Account (*)<-(1) User That is, each user belongs to exactly 1 account, an account can have multiple users; each account belongs to a single domain, and a domain can have multiple accounts. A user has an email address, which must be unique acro