Adam DeVita <adev...@...> writes: > > I wouldn't advise using an SQL keyword as a table name: "Order" > > I presume that your order collection table example is shorter than the real > one for the sake of the example?
[...] yes - and the content has nothing to do with my real tables. The example should be only a well known for experienced db-designers I assume (I'm not an experienced db-designer ;-) ). So I assume that it is not(!) a mistake not(!) to use a composite PK in my table "customer" (customernumber,customerorigin) and to refer to it from the table "order" where I had to use these fields as a composite FK? greetings Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
