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

Cizí klíč X_PROPERTY_SET_PROPERTY_FK2 (PROPERTY_ID) --> Primární klíč IFC_PROPERTY.IFC_PROPERTY_PK (ID)

Unikátní X_PROPERTY_SET_PROPERTY_U_FKX (PROPERTY_SET_ID, PROPERTY_ID)

Trigger X_PROPERTY_SET_PROPERTY_ID

BEFORE INSERT ON X_PROPERTY_SET_PROPERTY

BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD

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

Trigger X_PROPERTY_SET_PROPERTY_KDO

BEFORE INSERT OR UPDATE ON X_PROPERTY_SET_PROPERTY

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_PROPERTY_FK1 (PROPERTY_SET_ID)

index X_PROPERTY_SET_PROPERTY_FK2 (PROPERTY_ID)

UNIQUE index X_PROPERTY_SET_PROPERTY_PK (ID)

UNIQUE index X_PROPERTY_SET_PROPERTY_U_FKX (PROPERTY_SET_ID, PROPERTY_ID)