DB 및 클래스/메소드/변수명 등을 정할때 참조하는 명명규칙
CREATE TABLE TB_NAMING_RULE
(
HAN_NM VARCHAR2(100 BYTE),
ENG_NM VARCHAR2(100 BYTE),
REPRE_ENG_NM VARCHAR2(50 BYTE),
ENG_NM_ABBR VARCHAR2(50 BYTE),
SYNON VARCHAR2(50 BYTE)
)
COMMENT ON TABLE TB_NAMING_RULE IS '네이밍룰';
COMMENT ON COLUMN TB_NAMING_RULE.HAN_NM IS '한글용어';
COMMENT ON COLUMN TB_NAMING_RULE.ENG_NM IS '영문명';
COMMENT ON COLUMN TB_NAMING_RULE.REPRE_ENG_NM IS '대표영문';
COMMENT ON COLUMN TB_NAMING_RULE.ENG_NM_ABBR IS '영문약어';
COMMENT ON COLUMN TB_NAMING_RULE.SYNON IS '동의어';
SELECT * FROM TB_NAMING_RULE
WHERE
HAN_NM LIKE '%&HAN_NM%'
AND SYNON LIKE '%&HAN_NM%'
NamingRule_insert.7z