CREATE TABLE "Products" ( "id" int PRIMARY KEY, "name" varchar(255), "price" varchar, "..." varchar(255) ); CREATE TABLE "SpecificationAttributes" ( "id" int PRIMARY KEY, "name" varchar(255) ); CREATE TABLE "SpecificationOptions" ( "id" int, "name" varchar(255), "attribute_id" int CONSTRAINT SpecificationAttributes_id REFERENCES SpecificationAttributes(id) ); CREATE TABLE "Product_Option" ( "id" int, "Option_id" int CONSTRAINT SpecificationOptions_id REFERENCES SpecificationOptions(id), "product_id" int CONSTRAINT Products_id REFERENCES Products(id), "displayOrder" int, "AllowFilter" bool, "ShowOnProductPage" bool );