Unikátní STD_PRJ_PHASE_U_KOD (KOD)

Unikátní STD_PRJ_PHASE_U_NAZEV (NAZEV)

Unikátní STD_PRJ_PHASE_U_NAZEV_CZ (NAZEV_CZ)

Trigger STD_PRJ_PHASE_ID

BEFORE INSERT ON STD_PRJ_PHASE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger STD_PRJ_PHASE_KDO

BEFORE INSERT OR UPDATE ON STD_PRJ_PHASE

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

UNIQUE index CS_PRJ_PHASE_PK (ID)

UNIQUE index CS_PRJ_PHASE_U_KOD (KOD)

UNIQUE index CS_PRJ_PHASE_U_NAZEV (NAZEV)

UNIQUE index CS_PRJ_PHASE_U_NAZEV_CZ (NAZEV_CZ)