Programming/Tips
[ERwin] 인덱스명
콩이오
2019. 2. 26. 15:30
728x90
반응형
ERwin의 인덱스명 변경하기
1. Tools - Names - Model Naming Option
2. Name Mapping 의 key group to index
2. 아래 중 한 개를 택하여 넣기
%If(%==(%KeyType,PK)){U_}_%TableName
%If(%==(%Substr(%KeyType,1,2),IE)){N}U_%TableName
%If(%==(%Substr(%KeyType,1,2),IE)){N}U%If(%==(%KeyType,PK)){PK}_%TableName%If(%Not(%==(%KeyType,PK))){%Substr(%KeyName,%Len(%KeyName))}
%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)}
728x90
반응형