SW 라이브러리

CREATE OR REPLACE PROCEDURE PR_RC_GEN_WKNO(P_YYYY IN VARCHAR2) IS
BEGIN
  
       INSERT INTO TB_RC_WKNO (
          COMP_CD, 
          YM, 
          AGG_WKNO, 
          BG_DT, 
          END_DT, 
          CRT_USR_ID, 
          CRT_DTM, 
          UPDT_USR_ID, 
          UPDT_DTM
          )
          SELECT
          '100'
          , MM
          , RANK() OVER(PARTITION BY MM ORDER BY WW) WKNO
          , S_DATE
          , E_DATE
          , 1
          , SYSDATE
          , 1
          , SYSDATE
          FROM (
            SELECT 
              WW
              , S_DATE
              , E_DATE
              , CASE WHEN SUBSTR(S_DATE,5,2)=SUBSTR(E_DATE,5,2) THEN SUBSTR(S_DATE,1,6) 
                     WHEN TO_NUMBER(SUBSTR(E_DATE,7,2))<4 THEN SUBSTR(S_DATE,1,6) 
                     ELSE SUBSTR(E_DATE,1,6) END MM
              FROM (
                SELECT 
                WW
                , MIN(DD) KEEP ( DENSE_RANK FIRST  ORDER BY DD ) AS S_DATE
                , MAX(DD) KEEP ( DENSE_RANK LAST  ORDER BY DD ) AS E_DATE
                FROM (
                  SELECT   TO_CHAR(TO_DATE(P_YYYY||'0101','YYYYMMDD') + LEVEL-1, 'YYYYMMDD') AS DD
                         , TO_CHAR(TO_DATE(P_YYYY||'0101','YYYYMMDD') + LEVEL-1, 'DAY') AS DAYOFWEEK
                         , TO_CHAR(TO_DATE(P_YYYY||'0101','YYYYMMDD') + LEVEL-1, 'WW') AS WW
                         , TO_CHAR(TO_DATE(P_YYYY||'0101','YYYYMMDD') + LEVEL-1, 'MM') AS MM
                     FROM DUAL
                  CONNECT BY LEVEL <= TO_DATE(P_YYYY||'1231','YYYYMMDD')-TO_DATE(P_YYYY||'0101','YYYYMMDD')+1
                ) GROUP BY WW 
              ) 
          )    
          ;
          
          COMMIT;
  
END PR_RC_GEN_WKNO;

▶ 논리명 > 물리명 생성
1.Naming Standards Templates 생성 : 논리명을 물리명으로 변환하기 위해
- Data Dictionary 탭 New Naming Standards Template ...
- Edit Naming Standards Template ... > Mapping > Export > 파일 편집
- Edit Naming Standards Template ... > Mapping > Import


2. 모델 > Naming Standards Utility
- Options: NST 선택, Source : Logical, Target:Physical
- Output: 테이블 선택후 Run Translation

3. PK 일괄변경
- Macro탭> Name Primary Constraints

▶ 도메인 생성및 반영
- Macro탭> Import Domains from Excel > 엑셀 편집 > 도메인 생성
- Macro탭> Domain Bindings Import from Excel

▶ 물리테이블 생성 스크립
1. 논리명을 물리의 Description 에 추가
Sub Main
    Dim diag As Diagram
    Dim mdl As Model
    Dim ent As Entity
    Dim attr As AttributeObj
    Set diag = DiagramManager.ActiveDiagram
    Set mdl = diag.ActiveModel
   For Each ent In mdl.Entities
           ent.Definition  = ent.EntityName
           For Each attr In ent.Attributes
                     attr.EnableOverride(5,True)
                     attr.Definition  = attr.LogicalRoleName 
           Next
   Next
End Sub

2. My SQL 컬럼의 Definition을 DB Comment에 추가
Definition으로 Comment 생성_MySql.bas 실행
Table Editor의 PostSQL 확인

3. Database > Generate Database...

Definition으로 Comment 생성_MySql.bas