CM_DICTIONARY 공통용어사전
create table CM_DICTIONARY
(
eng_word VARCHAR2(1000) not null,
han_word VARCHAR2(1000),
abbreviation VARCHAR2(1000),
use_yn VARCHAR2(3) default 'Y',
stnd_yn VARCHAR2(3) default 'Y',
repr_word VARCHAR2(1000),
user_defn_yn VARCHAR2(3) default 'N',
tenant_no NUMBER(20),
regi_user_id VARCHAR2(20) default 'N',
regi_date DATE default SYSDATE,
modi_user_id VARCHAR2(20),
modi_date DATE default SYSDATE,
local_regi_date DATE,
local_modi_date DATE
);
comment on table CM_DICTIONARY is '공통용어사전';
comment on column CM_DICTIONARY.eng_word is '영어단어';
comment on column CM_DICTIONARY.han_word is '한글단어';
comment on column CM_DICTIONARY.abbreviation is '약어';
comment on column CM_DICTIONARY.use_yn is '사용여부';
comment on column CM_DICTIONARY.stnd_yn is '표준여부';
comment on column CM_DICTIONARY.repr_word is '대표단어';
comment on column CM_DICTIONARY.user_defn_yn is '사용자정의여부';
comment on column CM_DICTIONARY.tenant_no is '테넌트번호';
comment on column CM_DICTIONARY.regi_user_id is '등록자ID';
comment on column CM_DICTIONARY.regi_date is '등록일자';
comment on column CM_DICTIONARY.modi_user_id is '수정자ID';
comment on column CM_DICTIONARY.modi_date is '수정일자';
comment on column CM_DICTIONARY.local_regi_date is '로컬등록일자';
comment on column CM_DICTIONARY.local_modi_date is '로컬수정일자';
alter table CM_DICTIONARY add constraint PK_CM_DICTIONARY primary key (ENG_WORD, HAN_WORD, ABBREVIATION);