Ověření BIM_ACCESS_CHK_PRISTUP: Pristup in ('R','E')

Cizí klíč BIM_ACCESS_FK_MODUL (ID) --> Primární klíč BIM_MODUL.BIM_MODUL_PK (ID)

Cizí klíč BIM_ACCESS_FK_USER (LOGIN) --> Primární klíč BIM_USER.BIM_USER_PK (LOGIN)

Trigger BIM_ACCESS_ID

BEFORE INSERT ON BIM_ACCESS

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

index BIM_ACCESS_ID (ID)

UNIQUE index BIM_ACCESS_PK (LOGIN, ID)