DROP TABLE COMM_CD_GRP PURGE;
CREATE TABLE COMM_CD_GRP (
CODE_GRP_ID VARCHAR2(20)
, CODE_GRP_ID_NM VARCHAR2(128)
, ETC1 VARCHAR2(128)
, ETC2 VARCHAR2(128)
, ETC3 VARCHAR2(128)
, APPL_STRT_DTM DATE
, APPL_END_DTM DATE
, USE_YN VARCHAR2(2)
, CRDT_USER_ID VARCHAR2(20)
, CRDT_DTM DATE
, UPDT_USER_ID VARCHAR2(20)
, UPDT_DTM DATE
, CONSTRAINT COMM_CD_PK PRIMARY KEY(CODE_GRP_ID)
);
COMMENT ON TABLE COMM_CD_GRP IS '공통 코드';
COMMENT ON COLUMN COMM_CD_GRP.CODE_GRP_ID IS '코드 ID';
COMMENT ON COLUMN COMM_CD_GRP.CODE_GRP_ID_NM IS '코드 ID 명';
COMMENT ON COLUMN COMM_CD_GRP.ETC1 IS '기타 1';
COMMENT ON COLUMN COMM_CD_GRP.ETC2 IS '기타 2';
COMMENT ON COLUMN COMM_CD_GRP.ETC3 IS '기타 3';
COMMENT ON COLUMN COMM_CD_GRP.APPL_STRT_DTM IS '적용시작일시';
COMMENT ON COLUMN COMM_CD_GRP.APPL_END_DTM IS '적용종료일시';
COMMENT ON COLUMN COMM_CD_GRP.USE_YN IS '사용 여부';
COMMENT ON COLUMN COMM_CD_GRP.CRDT_DTM IS '생성일시';
COMMENT ON COLUMN COMM_CD_GRP.CRDT_USER_ID IS '생성자 아이디';
COMMENT ON COLUMN COMM_CD_GRP.UPDT_DTM IS '수정일시';
COMMENT ON COLUMN COMM_CD_GRP.UPDT_USER_ID IS '수정자 아이디';
DROP TABLE COMM_CD_DTL PURGE;
CREATE TABLE COMM_CD_DTL (
CODE_GRP_ID VARCHAR2(20)
, CODE VARCHAR2(20)
, CODE_NM VARCHAR2(128)
, CODE_GRP_ID_NM VARCHAR2(128)
, UPPR_CODE_GRP_ID VARCHAR2(20)
, ETC1 VARCHAR2(128)
, ETC2 VARCHAR2(128)
, ETC3 VARCHAR2(128)
, ETC4 VARCHAR2(128)
, ETC5 VARCHAR2(128)
, NUM_REF1 NUMBER(10)
, NUM_REF2 NUMBER(10)
, NUM_REF3 NUMBER(10)
, SORT_NUM NUMBER(10)
, APPL_STRT_DTM DATE
, APPL_END_DTM DATE
, USE_YN VARCHAR2(2)
, CRDT_USER_ID VARCHAR2(20)
, CRDT_DTM DATE
, UPDT_USER_ID VARCHAR2(20)
, UPDT_DTM DATE
, CONSTRAINT COMM_CD_DTL_PK PRIMARY KEY(CODE_GRP_ID, CODE)
);
COMMENT ON TABLE COMM_CD_DTL IS '공통 코드 상세';
COMMENT ON COLUMN COMM_CD_DTL.CODE_GRP_ID IS '코드 ID';
COMMENT ON COLUMN COMM_CD_DTL.CODE IS '코드';
COMMENT ON COLUMN COMM_CD_DTL.CODE_NM IS '코드 명';
COMMENT ON COLUMN COMM_CD_DTL.CODE_GRP_ID_NM IS '코드 ID 명';
COMMENT ON COLUMN COMM_CD_DTL.UPPR_CODE_GRP_ID IS '상위 코드 ID';
COMMENT ON COLUMN COMM_CD_DTL.ETC1 IS '기타 1';
COMMENT ON COLUMN COMM_CD_DTL.ETC2 IS '기타 2';
COMMENT ON COLUMN COMM_CD_DTL.ETC3 IS '기타 3';
COMMENT ON COLUMN COMM_CD_DTL.ETC4 IS '기타 4';
COMMENT ON COLUMN COMM_CD_DTL.ETC5 IS '기타 5';
COMMENT ON COLUMN COMM_CD_DTL.NUM_REF1 IS '숫자 참조1';
COMMENT ON COLUMN COMM_CD_DTL.NUM_REF2 IS '숫자 참조2';
COMMENT ON COLUMN COMM_CD_DTL.NUM_REF3 IS '숫자 참조3';
COMMENT ON COLUMN COMM_CD_DTL.SORT_NUM IS '정렬 순서';
COMMENT ON COLUMN COMM_CD_DTL.APPL_STRT_DTM IS '적용시작일시';
COMMENT ON COLUMN COMM_CD_DTL.APPL_END_DTM IS '적용종료일시';
COMMENT ON COLUMN COMM_CD_DTL.USE_YN IS '사용 여부';
COMMENT ON COLUMN COMM_CD_DTL.CRDT_DTM IS '생성일시';
COMMENT ON COLUMN COMM_CD_DTL.CRDT_USER_ID IS '생성자 아이디';
COMMENT ON COLUMN COMM_CD_DTL.UPDT_DTM IS '수정일시';
COMMENT ON COLUMN COMM_CD_DTL.UPDT_USER_ID IS '수정자 아이디';