Re: Implementing complicated constraints

From: Agoston Bejo <gusz1_at_freemail.hu>
Date: Wed, 29 Sep 2004 10:12:32 +0200
Message-ID: <cjdr0n$vr4$1@news.caesar.elte.hu>

I would like to do this so that the structure of the tables remain the same. (Since in the real-life analogue of this example it is important that the structures reflect the real-life concepts.)

Anyway, the question is rather about the implementation of more complicated constraints on tables than this specific example (which actually led me to pose this question in the newsgroup).

"wario" <wario_spam_at_insightbb.com> wrote in message

news:962c6d85.0409280619.395fb2_at_posting.google.com...


> --Table A(AID, BID ref. B.BID, CID ref. C.CID, ATXT)

> --Table B(BID, CID ref. C.CID)
> --Table C(CID)
>
> 1. Add CID key to table A.
> 2. Create unique index on CID and ATXT.
>
> Wario
Received on Wed Sep 29 2004 - 03:12:32 CDT