erwin index 명 설정
* Menu > Tools > Names > Model Naming Options
* Name Mapping Tab에서
ObjectType 가 Key Group to Index 인 MacroName (%KeyName)부분을 변경
* 스크립트 변경
IDX_%If(%==(%IndexType,PK)){%TableName_PK}%Else{%IF(%==(%substr(%IndexType,1,2),IF)) {%TableName_%substr(%IndexType,2)}}
적용 예)
tablename : SELF_TEST
CREATE UNIQUE INDEX IDX_SELF_TEST_PK ON SELF_TEST
(SELF_TEST_SEQ);
ALTER TABLE SELF_TEST_DVC_MNG
ADD CONSTRAINT IDX_SELF_TEST_PK PRIMARY KEY (SELF_TEST_SEQ);
%If(%==(%Substr(%KeyType,1,2),IE)){IX}%If(%==(%Substr(%KeyType,1,2),AK)){UIX}%If(%==(%KeyType,PK)){PK}_%TableName%If(%Not(%==(%KeyType,PK))){_%Substr(%KeyType,3,1)}
적용 예)
CREATE UNIQUE INDEX PK_SELF_TEST ON SELF_TEST
(SELF_TEST_SEQ);
ALTER TABLE SELF_TEST
ADD CONSTRAINT PK_SELF_TEST PRIMARY KEY (SELF_TEST_SEQ);