[ERwin]ERwin에서 Logical을 Comment로 생성하는 스크립트

Database -> Pre & Post Script -> Model-Level

Code 탭 -> New 버튼클릭 -> 스크립트 입력

Oracle 

%ForEachTable() {

    COMMENT ON TABLE %TableName IS '%EntityName';

 

    %ForEachColumn() {

    COMMENT ON COLUMN %TableName.%ColName IS '%AttName';

    }

}

MySQL 

%ForEachTable() {

    ALTER TABLE %TableName COMMENT = '%EntityName';

 

    %ForEachColumn() {

    ALTER TABLE %TableName CHANGE COLUMN %ColName %ColName %AttDatatype %AttNullOption COMMENT '%AttName';

    }

}

Forward Engineer Schema Generation -> Option 탭 -> Schema -> Post-Script 선택하여 체크 

출처 : http://koreantramp.tistory.com/198