Re: [sqlite] [EXTERNAL] If two orders are both the same order?

2019-05-07 Thread Hick Gunter
-users@mailinglists.sqlite.org Betreff: Re: [sqlite] [EXTERNAL] If two orders are both the same order? sqlite-users@mailinglists.sqlite.org wrote: > Your schema implies that there can be more than one TIME for any GNAME > and AN combination (otherwise the primary key would not need to > include al

Re: [sqlite] [EXTERNAL] If two orders are both the same order?

2019-05-07 Thread sqlite
sqlite-users@mailinglists.sqlite.org wrote: > Your schema implies that there can be more than one TIME for any GNAME and AN > combination (otherwise the primary key would not need to include alle three > fields). This contradicts your statement that AN and TIME are "the same > order". > (consi

Re: [sqlite] [EXTERNAL] If two orders are both the same order?

2019-05-06 Thread Hick Gunter
Your schema implies that there can be more than one TIME for any GNAME and AN combination (otherwise the primary key would not need to include alle three fields). This contradicts your statement that AN and TIME are "the same order". (consider the tuples ("T1",1,1) and ("T2",1,2); the AN field c