Re: [GENERAL] foreign keys constraints, depending on each other

2001-06-12 Thread Mario Weilguni
Am Montag, 11. Juni 2001 10:25 schrieb Marc SCHAEFER: > I would remove the father and mother references, and add a >    is_married > relation; as a table, with a UNIQUE(father_id), UNIQUE(mother_id) > constraint (a person can be only married once). Is not true, at least not in some arabic countr

Re: [GENERAL] foreign keys constraints, depending on each other

2001-06-10 Thread Stephan Szabo
On Sun, 10 Jun 2001 [EMAIL PROTECTED] wrote: > > > > I was just creating this little database for demonstrating the use of > > > foreign keys constraints. > > > > > > I was about the create 3 tables, namely mother, father and child. Mother has > > > a foreign key pointing at father ( id ), and