DROP TABLE IF EXISTS tax_rule;

-- DROP SEQUENCE IF EXISTS tax_rule_tax_rule_id_seq;
-- CREATE SEQUENCE tax_rule_tax_rule_id_seq;


CREATE TABLE tax_rule (
  "tax_rule_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
  "tax_type_id" int check ("tax_type_id" > 0) NOT NULL,
  "tax_rate_id" int check ("tax_rate_id" > 0) NOT NULL,
  "based" varchar(10) NOT NULL,
  "priority" int NOT NULL DEFAULT 1
  -- PRIMARY KEY("tax_rule_id")
);

CREATE INDEX "tax_rule" ON tax_rule ("tax_type_id","tax_rate_id");
SELECT setval('tax_rule_tax_rule_id_seq', 2, true); -- last inserted id by sample data