Re: Difficulty modelling sales taxes

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Frank Millman <frank(at)chagford(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Difficulty modelling sales taxes
Date: 2017-01-02 16:17:07
Message-ID: CAKFQuwaDDOb2Ox5bkrs02VrubTDhiWaAjfEz3RCZkUAGizw40Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 2, 2017 at 3:33 AM, Frank Millman <frank(at)chagford(dot)com> wrote:

>
> CONSTRAINT _prod_tax_code_2 FOREIGN KEY (category_id, tax_code)
> REFERENCES tax_codes (category_id, code));
>

​This is ​typical solution to this modelling problem. If you need to do
other stuff (introduce redundancies) to make it play nice with the ORM then
that is valid if unfortunate.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-01-02 16:20:12 Re: Difficulty modelling sales taxes
Previous Message Melvin Davidson 2017-01-02 16:02:03 Re: Difficulty modelling sales taxes