schema.sql

CREATE TYPE feedback_type AS ENUM('rolloffs', 'waste', 'hauling', 'commerical', 'residential');

CREATE TABLE IF NOT EXISTS company_feedback (
	id serial PRIMARY KEY,
	company integer REFERENCES companies(id) NOT NULL,
	ip text NOT NULL,
	"type" feedback_type NOT NULL,
	affirmative boolean NOT NULL
);

CREATE UNIQUE INDEX limit_feedback ON company_feedback (company, ip, "type");