CREATE TABLE "assembled_kk3" (
"id_kk3" bigserial NOT NULL,
"assembled_kk3" varchar NOT NULL,
"name_general_classification" smallint NOT NULL DEFAULT '0',
"name_detailed_classification" smallint NOT NULL DEFAULT '0',
....................................
CONSTRAINT assembled_kk3_pk PRIMARY KEY ("id_kk3")
) WITH (
OIDS=FALSE
);


CREATE TABLE "name_general_classification" (
"id_name_general_classification" smallint NOT NULL,
"name" varchar NOT NULL DEFAULT 'not name',
CONSTRAINT name_general_classification_pk PRIMARY KEY ("id_name_general_classification")
) WITH (
OIDS=FALSE
);


CREATE TABLE "name_detailed_classification" (
"id_name_general_classification" smallint NOT NULL,
"id_name_detalied_classification" smallint NOT NULL,
"name" varchar NOT NULL,
CONSTRAINT name_detailed_classification_pk PRIMARY KEY ("id_name_general_classification","id_name_detalied_classification")
) WITH (
OIDS=FALSE
);[/SRC]


ALTER TABLE "assembled_kk3" ADD CONSTRAINT "assembled_kk3_fk0" FOREIGN KEY (name_general_classification) REFERENCES name_general_classification(id_name_general_classification);
ALTER TABLE "assembled_kk3" ADD CONSTRAINT "assembled_kk3_fk1" FOREIGN KEY (name_detailed_classification) REFERENCES name_detailed_classification(id_name_detalied_classification);
ALTER TABLE "name_detailed_classification" ADD CONSTRAINT "name_detailed_classification_fk0" FOREIGN KEY (id_name_general_classification) REFERENCES name_general_classification(id_name_general_classification);