Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Difficulty modelling sales taxes - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Difficulty modelling sales taxes
Date
Msg-id CAKFQuwaDDOb2Ox5bkrs02VrubTDhiWaAjfEz3RCZkUAGizw40Q@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Difficulty modelling sales taxes  ("Frank Millman" <frank@chagford.com>)
List pgsql-general
Tree view
On Mon, Jan 2, 2017 at 3:33 AM, Frank Millman <frank@chagford.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.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Difficulty modelling sales taxes
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Difficulty modelling sales taxes