CREATE SEQUENCE   "STORONA_SDELKI_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

CREATE TABLE  "STORONA_SDELKI" 
   (  "ID" NUMBER NOT NULL ENABLE,
     "SDELKA_ID" NUMBER NOT NULL ENABLE, 
     TEXT_FIELD VARCHAR2(50),
      CONSTRAINT "STORONA_SDELKI_PK" PRIMARY KEY ("ID") ENABLE
   ) ;
/
ALTER TABLE  "STORONA_SDELKI" ADD CONSTRAINT "TC_TYPEN4" FOREIGN KEY ("SDELKA_ID")
	  REFERENCES  "SDELKA" ("ID") ENABLE;

CREATE OR REPLACE TRIGGER  "BI_STORONA_SDELKI" 
  before insert on "STORONA_SDELKI"               
  for each row  
begin   
  if :NEW."SDELKA_ID" is null then 
    select "STORONA_SDELKI_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end;