Unikátní XML_IFC_FILE_U_DIR_FNAME (DIR, FNAME)

Trigger XML_IFC_FILE_ID

BEFORE INSERT ON XML_IFC_FILE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

begin
  :NEW.ID := coalesce(:NEW.ID,nextid);
end; 

Trigger XML_IFC_FILE_KDO

BEFORE INSERT OR UPDATE ON XML_IFC_FILE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

begin
  :NEW.KDO := NVL(:NEW.KDO,USER);
  :NEW.KDY := SYSDATE;
end; 

UNIQUE index XML_IFC_FILE_PK (ID)

UNIQUE index XML_IFC_FILE_U_DIR_FNAME (DIR, FNAME)