create unique index XAK3DEPARTMENT on DEPARTMENT (CUSTOMER_ID, DEPARTMENT_ID);


create unique index XAK1UNIQUEITEMNONPOOL on UNIQUEITEMNONPOOL (UNIQUEITEM_ID, WEAREREMPLOYMENT_ID, WEARERINVENTORY_ID, FREEEXTRAGARMENT, ENDDATEFREEEXTRA);


create unique index XAK2UNIQUEITEM on UNIQUEITEM (UNIQUEITEM_ID, PRODUCT_ID, SIZEDEFINITION_ID, FINISHINGMETHOD_ID, STATUS_ID, BUSINESSUNIT_ID, CUSTOMEROWNED, LEASEWEEKS, SUBSTITUTEFORPRODUCT_ID, SUBSTITUTEFORSIZEDEFINITION_ID);


create unique index XAK2WEAREREMPLOYMENT on WEAREREMPLOYMENT (WEAREREMPLOYMENT_ID, DISTRIBUTIONPOINT_ID);

create unique index XAK3DISTRIBUTIONPOINT on DISTRIBUTIONPOINT (DISTRIBUTIONPOINT_ID, DEPARTMENT_ID, COSTCENTER_ID);

create unique index XAK2WEARERINVENTORY on WEARERINVENTORY (WEARERINVENTORY_ID, TEMPORARYRENTSTOPSTARTDATE, TEMPORARYRENTSTOPENDDATE, SEASON_ID);

create unique index XAK3PRODUCTGROUP on PRODUCTGROUP (PRODUCTGROUP_ID, ACTIVITY_ID);
