SQLize | PHPize | SQLtest

CREATE TABLE product_category (category_id number primary key NOT NULL, category_name varchar2(200) ); CREATE TABLE material_characteristics (material_characteristics_id number primary key NOT NULL, price_per_gram number NOT NULL, colour varchar2(200) NOT NULL, name_of_the_material varchar2(200) NOT NULL ); CREATE TABLE materials_set (material_id number NOT NULL, material_characteristics_id number NOT NULL, CONSTRAINT materials_set_pk PRIMARY KEY (material_id), CONSTRAINT material_characteristics_materials_set_fk FOREIGN KEY (material_characteristics_id) REFERENCES material_characteristics(material_characteristics_id), number_of_grams number ); drop table materials_set;