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
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
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