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
반응형