Unikátní STD_BIM_USE_U_KOD (KOD)

Unikátní STD_BIM_USE_U_NAZEV (NAZEV)

Unikátní STD_BIM_USE_U_NAZEV_CZ (NAZEV_CZ)

Trigger STD_BIM_USE_ID

BEFORE INSERT ON STD_BIM_USE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger STD_BIM_USE_KDO

BEFORE INSERT OR UPDATE ON STD_BIM_USE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

UNIQUE index CS_BIM_USE_PK (ID)

UNIQUE index CS_BIM_USE_U_KOD (KOD)

UNIQUE index CS_BIM_USE_U_NAZEV (NAZEV)

UNIQUE index CS_BIM_USE_U_NAZEV_CZ (NAZEV_CZ)