holog

%ForEachTable() { COMMENT ON TABLE %TableName IS '%EntityName'; %ForEachColumn() { %Switch('%ColumnComment') { %Choose(''){COMMENT ON COLUMN %TableName.%ColName IS '%AttName';} %Default {COMMENT ON COLUMN %TableName.%ColName IS '%AttName';} } } }

Erwin 상단의 Menu > Tools > Names > Model Naming Options Macro Name에 아래와 같이 추가 Relationships : FK_%Child Key Group to Index : %If(%==(%Substr(%KeyType,1,2),IN)){IX_%TableName}%If(%==(%Substr(%KeyType,1,2),IE)){IX_%TableName_01}%If(%==(%Substr(%KeyType,1,2),AK)){UIX_%TableName}%If(%==(%Substr(%KeyType,2,1),F)){FK_%TableName_0%Substr(%KeyType,3,1)}%If(%==(%KeyType,PK)){PK_%TableName_01} 결과 : ALTER TA..