CREATE TABLE  "NEDVIZHIMOST" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"TIP_NEDV_ID" NUMBER, 
	"REGION_ID" NUMBER, 
	"TIP_SDELKI_ID" NUMBER, 
	"KONTR_ID" NUMBER, 
	"RIELT_ID" NUMBER, 
	"DATE_PRED" DATE, 
	"AKTUALNO" VARCHAR2(10), 
	"COMMISSION" VARCHAR2(10), 
	"ADRESS" VARCHAR2(100), 
	"PRICE" VARCHAR2(10), 
	 CONSTRAINT "NEDVIZHIMOST_PK" PRIMARY KEY ("ID") ENABLE
   ) ;ALTER TABLE  "NEDVIZHIMOST" ADD CONSTRAINT "NEDVIZHIMOST_CON" FOREIGN KEY ("TIP_NEDV_ID")
	  REFERENCES  "TIP_NEDVIJ" ("ID") ON DELETE CASCADE ENABLE;ALTER TABLE  "NEDVIZHIMOST" ADD CONSTRAINT "NEDVIZHIMOST_CON2" FOREIGN KEY ("REGION_ID")
	  REFERENCES  "REGION" ("ID") ENABLE;ALTER TABLE  "NEDVIZHIMOST" ADD CONSTRAINT "NEDVIZHIMOST_CON3" FOREIGN KEY ("TIP_SDELKI_ID")
	  REFERENCES  "TIP_SDELKI" ("ID") ENABLE;ALTER TABLE  "NEDVIZHIMOST" ADD CONSTRAINT "NEDVIZHIMOST_CON4" FOREIGN KEY ("KONTR_ID")
	  REFERENCES  "СONTRACTOR" ("ID") ENABLE;ALTER TABLE  "NEDVIZHIMOST" ADD CONSTRAINT "NEDVIZHIMOST_CON5" FOREIGN KEY ("RIELT_ID")
	  REFERENCES  "REALTOR" ("ID") ENABLE;

CREATE TABLE  "PHOTO" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"NEDVIJ_ID" NUMBER, 
	"PHOTO" BLOB, 
	 CONSTRAINT "PHOTO_PK" PRIMARY KEY ("ID") ENABLE
   ) ;ALTER TABLE  "PHOTO" ADD CONSTRAINT "PHOTO_CON" FOREIGN KEY ("NEDVIJ_ID")
	  REFERENCES  "NEDVIZHIMOST" ("ID") ON DELETE CASCADE ENABLE;