ERWIN Logical 로 DB Comment 생성 (oracle,mysql)

- 설정

ERWin Physical 에서
DataBase > Pre & Post Script > Table-Level > New

Oracle

COMMENT ON TABLE %TableName IS '%EntityName';
%ForEachAtt() {
COMMENT ON COLUMN %TableName.%ColName IS '%AttName';
}

Mysql

ALTER TABLE %TableName COMMENT='%EntityName';
%ForEachAtt() {
ALTER TABLE %TableName CHANGE COLUMN %ColName %ColName %AttDatatype %AttNullOption COMMENT '%AttName';
}

- Script 출력
Tools -> Forward engineer/schema generation
Schema -> post-script 체크
other options comments 도 함께 체크

- example