Unikátní STD_PROPSET_INDEX_U_NAZEV (NAZEV)

Unikátní STD_PROPSET_INDEX_U_ZNAK (ZNAK)

Trigger STD_PROPERTY_SET_INDEX_ID

BEFORE INSERT ON STD_PROPERTY_SET_INDEX

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger STD_PROPERTY_SET_INDEX_KDO

BEFORE INSERT OR UPDATE ON STD_PROPERTY_SET_INDEX

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

UNIQUE index STD_PROPERTY_SET_INDEX_PK (ID)

UNIQUE index STD_PROPSET_INDEX_U_NAZEV (NAZEV)

UNIQUE index STD_PROPSET_INDEX_U_ZNAK (ZNAK)