Ověření IFC_CLASS_CHK_NAME_NAME_CZ: Name is not null or Name_CZ is not null

Cizí klíč IFC_CLASS_FK_CLASS (PARENT_ID) --> Primární klíč IFC_CLASS.IFC_CLASS_PK (ID)

Trigger IFC_CLASS_ID

BEFORE INSERT ON IFC_CLASS

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger IFC_CLASS_KDO

BEFORE INSERT OR UPDATE ON IFC_CLASS

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

index IFC_CLASS_IFCIDENT (IFCIDENT)

index IFC_CLASS_PARENT_NAME (PARENT_ID, NAME)

index IFC_CLASS_PARENT_NAME_CZ (PARENT_ID, NAME_CZ)

UNIQUE index IFC_CLASS_PK (ID)

FUNCTION-BASED NORMAL UNIQUE index IFC_CLASS_U_IFCIDENT_PARENT (SYS_NC00013$, PARENT_ID)

FUNCTION-BASED NORMAL UNIQUE index IFC_CLASS_U_PARENT_NAME (PARENT_ID, SYS_NC00016$)

FUNCTION-BASED NORMAL UNIQUE index IFC_CLASS_U_PARENT_NAME_CZ (PARENT_ID, SYS_NC00015$)

FUNCTION-BASED NORMAL UNIQUE index IFC_CLASS_U_PARENT_NVLNAME (PARENT_ID, SYS_NC00014$)