I try to follow advices and modify my database so it is now like this: *CREATE TABLE "student" ( "idnum" TEXT NOT NULL CONSTRAINT "pk_student" PRIMARY KEY, "studentname" TEXT NOT NULL, "teachinglang" VARCHAR(2) NOT NULL, "grade" TINYINT, "classname" VARCHAR(1) NOT NULL, "formmaster" TEXT NOT NULL );
CREATE TABLE "workpiecelist" ( "id" INTEGER CONSTRAINT "pk_workpiecelist" PRIMARY KEY AUTOINCREMENT, "grade" TINYINT, "quarter" TINYINT, "workpiecenamehu" TEXT NOT NULL, "workpiecenamesr" TEXT NOT NULL ); CREATE TABLE "uniqueworkpiece" ( "student" TEXT NOT NULL REFERENCES "student" ("idnum"), "workpiece_list" INTEGER NOT NULL REFERENCES "workpiecelist" ("id"), "mark" TINYINT, "cause" TEXT NOT NULL, CONSTRAINT "pk_uniqueworkpiece" PRIMARY KEY ("student", "workpiece_list") ); CREATE INDEX "idx_uniqueworkpiece__workpiece_list" ON "uniqueworkpiece" ("workpiece_list")* What do you think, did I achieve what I want? ----- Best, Pál -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users