Remainder from bug 15084: Note that another report should deal with adding missing constraints on the currency code in suggestions and aqbooksellers. Also note that the aqorder fields listprice and invoiceprice refer to currency. Imo these are very poor names for currency codes; you should never call something a price when you mean a currency code!
Jonathan: Can I please leave this one for you? :)
I can, but I won't now. There are bug 13323 and bug 13726 in the queue.
Just to abuse this report, to add something slightly related: AqordersItem -- what should be the primary key? And why is itemnumber no FK ?
(In reply to Marcel de Rooy from comment #3) > Just to abuse this report, to add something slightly related: > > AqordersItem -- what should be the primary key? The PK is correct, it's itemnumber > And why is itemnumber no FK ? See bug 12555