GitHub

Is it possible to create a foreign key to a composite primary key for SQLite?

CREATE TABLE Area( ArticleId TEXT NOT NULL, AreaGroupIndex INTEGER NOT NULL, "Index" INTEGER NOT NULL, PRIMARY KEY(ArticleId, AreaGroupIndex, "Index"), FOREIGN KEY(ArticleId, AreaGroupIndex) ...