Re: [GENERAL] multiple tables as a foreign key

2011-02-21 Thread Sim Zacks
On 02/21/2011 12:40 AM, matty jones wrote: I am not sure if this is possible but is there a way that I can have multiple columns from different tables be a foreign key to a single column in another table, or do I need to write a check function and if so how could I set up a relation? CREATE

Re: [GENERAL] multiple tables as a foreign key

2011-02-20 Thread John R Pierce
On 02/20/11 2:40 PM, matty jones wrote: If I were to create three separate attributes for each of the separate titles in the seriestitle table then reference those attributes from their respective tables that would produce errors I believe, because a foreign key can't be null and not every attr

[GENERAL] multiple tables as a foreign key

2011-02-20 Thread matty jones
I am not sure if this is possible but is there a way that I can have multiple columns from different tables be a foreign key to a single column in another table, or do I need to write a check function and if so how could I set up a relation? CREATE TABLE seriestitle ( seriestitle text ); CREATE TA