- ERWIN AM PRO 사용시 생성하는 표준관련 뷰
CREATE OR REPLACE FORCE VIEW ERD_ADM.V_STD_TERM
(
TERMNAME
, TERMENGNAME
, DOMAINNAME
, LDATATYPE
, PDATATYPE
, COMMENTS
, SYSNAME
-------------------- 여기까지 AMPRO 기본 설정
, PARSED_TERM
, UPDOMAIN
, D_ENAME
, D_CLASS
, D_VALID
-------------------- 프로젝트에 따라 유연하게 추가
)
BEQUEATH DEFINER
AS
SELECT A.TERM AS TERMNAME
, A.ETERM AS TERMENGNAME
, A.I_NAME AS DOMAINNAME
, REPLACE (B.D_PDTYPE_LEN, 'VARCHAR2', 'VARCHAR') AS LDATATYPE
, B.D_PDTYPE_LEN AS PDATATYPE
, NULL AS COMMENTS
, NULL AS SYSNAME
, A.PARSED_TERM AS PARSED_TERM
, B.D_NAME AS UPDOMAIN
, B.D_ENAME
, B.D_CLASS
, B.D_VALID
FROM DM_STD_TERM A
-------------------- 프로젝트에 따라 유연하게 추가 ----------------------------
LEFT OUTER JOIN DM_STD_DOMAIN B ON B.I_NAME = A.I_NAME;