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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
