[ERwin] comment명

ERwin의 comment명 생성하기

1. Physical 들어가기

2. Database - Pre & Post Scripts - Model-Level

3. comment 생성

4. code에 아래 구문 추가 (오라클용)

%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 '%ColumnComment';}

        }

    }

}

5. 아래와 같이 생성되는지 확인하기

COMMENT ON TABLE TABLE_NAME IS ‘테이블명’;

COMMENT ON COLUMN TABLE_NAME.COLUMN_NAME IS ‘컬럼명’;