Cizí klíč X_PROPERTY_SET_CLASS_FK1 (PROPERTY_SET_ID) --> Primární klíč IFC_PROPERTY_SET.IFC_PROPERTY_SET_PK (ID)

Cizí klíč X_PROPERTY_SET_CLASS_FK2 (CLASS_ID) --> Primární klíč IFC_CLASS.IFC_CLASS_PK (ID)

Unikátní X_PROPERTY_SET_CLASS_U_FK12 (PROPERTY_SET_ID, CLASS_ID)

Trigger X_PROPERTY_SET_CLASS_ID

BEFORE INSERT ON X_PROPERTY_SET_CLASS

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger X_PROPERTY_SET_CLASS_KDO

BEFORE INSERT OR UPDATE ON X_PROPERTY_SET_CLASS

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

index X_PROPERTY_SET_CLASS_CLASS_ID (CLASS_ID)

UNIQUE index X_PROPERTY_SET_CLASS_PK (ID)

index X_PROPERTY_SET_CLASS_PSET_ID (PROPERTY_SET_ID)

UNIQUE index X_PROPERTY_SET_CLASS_U_FK12 (PROPERTY_SET_ID, CLASS_ID)