Foreign Key in VARRAY : LUSENET : DBAzine : One Thread


I have a table Player with PK player_id. I have another table Statistics (Stores yearly records of a soccer team). This table has a multivalued attribute "captains" that should list the player_id of all the players who were made captain during that particular year. I am thinking of implementing captains as VARRAY, but how can I implement referential integrity so that each captain in VARRAY refers to player_id in Player table.

Regards, Amit

-- Amit Parikh (, February 11, 2005

Moderation questions? read the FAQ