Cizí klíč BIM_SABLONA_FK_TRIDA (TRIDA_ID) --> Primární klíč BIM_TRIDA.BIM_TRIDA_PK (ID)

Unikátní BIM_SABLONA_U_NAZEV (NAZEV)

Trigger BIM_SABLONA_ID

BEFORE INSERT ON BIM_SABLONA

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger BIM_SABLONA_KDO

BEFORE INSERT OR UPDATE ON BIM_SABLONA

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

begin
  :NEW.KDO := USER;
  :NEW.KDY := SYSDATE;
end; 

UNIQUE index BIM_SABLONA_PK (ID)

index BIM_SABLONA_TRIDA (TRIDA_ID)

UNIQUE index BIM_SABLONA_U_NAZEV (NAZEV)