The system calls for an associative table, a table with two foriegn
keys to two other tables, allowing for a many to many relationship.
Is there any way to make the primary key be both the columns?
CREATE TABLE Invoice_Item_Favorite(
Invoice_Item_Id INTEGER,
FavoriteId INTEGER,
FOREIGN KEY(Invoice_Item_Id) REFERENCES Invoice_Item(Invoice_Item_Id),
FOREIGN KEY(FavoriteId) REFERENCES Favorite(FavoriteId)
);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
