diff options
Diffstat (limited to 'sql/Pg-database.sql')
-rw-r--r-- | sql/Pg-database.sql | 23 |
1 files changed, 17 insertions, 6 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 907ce363..b7d23a3d 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -241,17 +241,28 @@ CREATE TABLE ap ( terms int2 DEFAULT 0 ); -- -CREATE TABLE partstax ( - parts_id int, - chart_id int, - PRIMARY KEY (parts_id, chart_id) -); --- CREATE TABLE taxmodule ( taxmodule_id serial PRIMARY KEY, taxmodulename text NOT NULL ); -- +CREATE TABLE taxcategory ( + taxcategory_id serial PRIMARY KEY, + taxcategoryname text NOT NULL, + taxmodule_id int NOT NULL, + FOREIGN KEY taxmodule_id REFERENCES taxmodule (taxmodule_id) +); +-- +CREATE TABLE partstax ( + parts_id int, + chart_id int, + taxcategory_id int, + PRIMARY KEY (parts_id, chart_id), + FOREIGN KEY parts_id REFERENCES parts (id), + FOREIGN KEY chart_id REFERENCES chart (id), + FOREIGN KEY taxcategory_id REFERENCES taxcategory (taxcategory_id) +); +-- CREATE TABLE tax ( chart_id int PRIMARY KEY, rate numeric, |