sl26@ukc.ac.uk wrote:
> I have defined the following foreign keys in a table:
>
> *********
> FOREIGN KEY (staff_login) REFERENCES staff (staff_login) MATCH FULL ON
> DELETE CASCADE ON UPDATE CASCADE,
>
> FOREIGN KEY (module_code) REFERENCES module (module_code) MATCH FULL
> ON DELETE CASCADE ON UPDATE CASCADE,
> *********
>
> these two fields make the primary key of the table in which they are
> in.
>
> MATCH FULL will not allow one column of a multi-column foreign key to
> be NULL unless all foreign key columns are NULL...so:
>...
MATCH FULL is not relevant because you don't have multi-column foreign
keys. You have 2 single column foreign keys.