cmstest
Tables (46)
COM_ACS_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8)
- ACS_YR — CHAR(4)
- ACS_MM — CHAR(2)
- INFLU_URL_ADDR — VARCHAR2(2000)
- MENU_NO — NUMBER(8)
- ACS_URL_ADDR — VARCHAR2(2000)
- ACS_IP_ADDR — VARCHAR2(200)
- ACS_TYPE_CD — VARCHAR2(10)
- SESSION_ID — VARCHAR2(100)
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP — NOT NULL
COM_APLY_DOC
- APLY_DOC_NO — NUMBER(8) — Primary key — NOT NULL
- EML_ADDR — VARCHAR2(320) — NOT NULL
- APLCNT_NM — VARCHAR2(500) — NOT NULL
- MBL_TELNO — VARCHAR2(500) — NOT NULL
- JBPS_NM — VARCHAR2(100)
- APLCNT_ADDR — VARCHAR2(2000)
- ATCH_FILE_NO — NUMBER(8)
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_APLY_DOC_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- APLY_DOC_NO — NUMBER(8) — NOT NULL
- EML_ADDR — VARCHAR2(320) — NOT NULL
- APLCNT_NM — VARCHAR2(500) — NOT NULL
- MBL_TELNO — VARCHAR2(500) — NOT NULL
- JBPS_NM — VARCHAR2(100)
- APLCNT_ADDR — VARCHAR2(2000)
- ATCH_FILE_NO — NUMBER(8)
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
COM_ATCH_FILE
- ATCH_FILE_NO — NUMBER(8) — Primary key — NOT NULL
- ATCH_FILE_SEQ — NUMBER(10) — Primary key — NOT NULL
- ATCH_FILE_PATH — VARCHAR2(2000)
- FILE_VR_NM — VARCHAR2(500)
- FILE_ACTL_NM — VARCHAR2(500)
- FILE_SZ — NUMBER(14)
- FILE_EXPLN — VARCHAR2(2000)
- FILE_EXTN_CD — VARCHAR2(50)
- DWNLD_CNT — NUMBER(10)
- THMB_YN — CHAR(1) — NOT NULL
- THMB_VR_NM — VARCHAR2(1000)
- USE_YN — CHAR(1) — NOT NULL
- DATA_TYPE_CD — VARCHAR2(50)
- RMRK — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_ATCH_FILE_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- ATCH_FILE_NO — NUMBER(8) — NOT NULL
- ATCH_FILE_SEQ — NUMBER(10) — NOT NULL
- ATCH_FILE_PATH — VARCHAR2(2000)
- FILE_VR_NM — VARCHAR2(500)
- FILE_ACTL_NM — VARCHAR2(500)
- HSTRY_TYPE_CD — VARCHAR2(10)
- FILE_SZ — NUMBER(14)
- FILE_EXPLN — VARCHAR2(2000)
- FILE_EXTN_CD — VARCHAR2(50)
- DWNLD_CNT — NUMBER(10)
- THMB_YN — CHAR(1) — NOT NULL
- THMB_VR_NM — VARCHAR2(1000)
- USE_YN — CHAR(1) — NOT NULL
- DATA_TYPE_CD — VARCHAR2(50)
- RMRK — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_BBS
- BBS_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- BBS_NM — VARCHAR2(256) — NOT NULL
- BBS_SE_CD — VARCHAR2(10)
- BBS_TYPE_CD — VARCHAR2(10)
- BBS_EXPLN — VARCHAR2(4000)
- USE_YN — CHAR(1) — NOT NULL
- ATCH_FILE_YN — CHAR(1) — NOT NULL
- ATCH_FILE_CNT — NUMBER(10)
- USE_APRV_YN — CHAR(1) — NOT NULL
- UPEND_NTC_YN — CHAR(1) — NOT NULL
- CMNT_USE_YN — CHAR(1) — NOT NULL
- REPL_USE_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_BBS_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- BBS_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- BBS_NM — VARCHAR2(256) — NOT NULL
- BBS_SE_CD — VARCHAR2(10)
- BBS_TYPE_CD — VARCHAR2(10)
- BBS_EXPLN — VARCHAR2(4000)
- USE_YN — CHAR(1) — NOT NULL
- ATCH_FILE_YN — CHAR(1) — NOT NULL
- ATCH_FILE_CNT — NUMBER(10)
- USE_APRV_YN — CHAR(1) — NOT NULL
- UPEND_NTC_YN — CHAR(1) — NOT NULL
- CMNT_USE_YN — CHAR(1) — NOT NULL
- REPL_USE_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_BNR
- BNR_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- BNR_SE_CD — VARCHAR2(10)
- BNR_NM — VARCHAR2(300) — NOT NULL
- EXPSR_YN — CHAR(1) — NOT NULL
- EXPSR_SEQ — NUMBER(10)
- RGTR_NM — VARCHAR2(100)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- BNR_URL_ADDR — VARCHAR2(2000) — NOT NULL
- ATCH_FILE_NO — NUMBER(8) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_BNR_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- BNR_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- BNR_SE_CD — VARCHAR2(10)
- HSTRY_TYPE_CD — VARCHAR2(10)
- BNR_NM — VARCHAR2(300) — NOT NULL
- EXPSR_YN — CHAR(1) — NOT NULL
- EXPSR_SEQ — NUMBER(10)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- BNR_URL_ADDR — VARCHAR2(2000) — NOT NULL
- ATCH_FILE_NO — NUMBER(8) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_CD
- CD_NO — NUMBER(8) — Primary key — NOT NULL
- UP_GROUP_CD_NO — NUMBER(8)
- CD — VARCHAR2(10) — NOT NULL
- CD_NM — VARCHAR2(100) — NOT NULL
- CD_EXPLN — VARCHAR2(4000)
- CD_LEVEL — NUMBER(4) — NOT NULL
- SORT_SEQ — NUMBER(10) — NOT NULL
- CD_BGNG_YMD — CHAR(8)
- CD_END_YMD — CHAR(8)
- USE_YN — CHAR(1) — NOT NULL
- SPCL_PRPS_ONE_CN — VARCHAR2(2000)
- SPCL_PRPS_TWO_CN — VARCHAR2(2000)
- SPCL_PRPS_THREE_CN — VARCHAR2(2000)
- SPCL_PRPS_FOUR_CN — VARCHAR2(2000)
- SPCL_PRPS_FIVE_CN — VARCHAR2(2000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_CD_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- CD_NO — NUMBER(8) — NOT NULL
- UP_GROUP_CD_NO — NUMBER(8)
- HSTRY_TYPE_CD — VARCHAR2(10)
- CD — VARCHAR2(10)
- CD_NM — VARCHAR2(100)
- CD_EXPLN — VARCHAR2(4000)
- CD_LEVEL — NUMBER(4)
- SORT_SEQ — NUMBER(10)
- CD_BGNG_YMD — CHAR(8)
- CD_END_YMD — CHAR(8)
- USE_YN — CHAR(1) — NOT NULL
- SPCL_PRPS_ONE_CN — VARCHAR2(2000)
- SPCL_PRPS_TWO_CN — VARCHAR2(2000)
- SPCL_PRPS_THREE_CN — VARCHAR2(2000)
- SPCL_PRPS_FOUR_CN — VARCHAR2(2000)
- SPCL_PRPS_FIVE_CN — VARCHAR2(2000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_CERT_NO
- CERT_TYPE_CD — VARCHAR2(10) — Primary key — NOT NULL
- CERT_NO — VARCHAR2(500) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100) — Foreign key → COM_USER.USER_ID — NOT NULL
- CERT_DT — TIMESTAMP — NOT NULL
COM_CONTS
- CONTS_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- CONTS_CLSF_CD — VARCHAR2(10) — NOT NULL
- CONTS_NM — VARCHAR2(300) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- KOGL_TYPE_CD — VARCHAR2(10)
- CONTS_EXPLN — CLOB
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_CONTS_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- CONTS_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- CONTS_CLSF_CD — VARCHAR2(10)
- CONTS_NM — VARCHAR2(300)
- USE_YN — CHAR(1) — NOT NULL
- KOGL_TYPE_CD — VARCHAR2(10)
- CONTS_EXPLN — CLOB
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_CONTS_KYWD
- KYWD_NM — VARCHAR2(300) — Primary key — NOT NULL
- CONTS_NO — NUMBER(8) — Foreign key → COM_CONTS.CONTS_NO — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_CONTS_KYWD_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- CONTS_NO — NUMBER(8) — NOT NULL
- KYWD_NM — VARCHAR2(300) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_DEPT
- DEPT_NO — NUMBER(8) — Primary key — NOT NULL
- UP_DEPT_NO — NUMBER(8)
- DEPT_NM — VARCHAR2(200) — NOT NULL
- DEPT_ENG_NM — VARCHAR2(100)
- USE_YN — CHAR(1) — NOT NULL
- DEPT_LEVEL — NUMBER(4)
- SORT_SEQ — NUMBER(10)
- DEPT_TELNO — VARCHAR2(11)
- DEPT_FXNO — VARCHAR2(20)
- DEPT_EXPLN — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_DEPT_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- DEPT_NO — NUMBER(8) — NOT NULL
- UP_DEPT_NO — NUMBER(8)
- HSTRY_TYPE_CD — VARCHAR2(10)
- DEPT_NM — VARCHAR2(200) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- DEPT_ENG_NM — VARCHAR2(100)
- DEPT_LEVEL — NUMBER(4)
- SORT_SEQ — NUMBER(10)
- DEPT_TELNO — VARCHAR2(11)
- DEPT_FXNO — VARCHAR2(20)
- DEPT_EXPLN — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_EMP
- EMP_NO — NUMBER(8) — Primary key — NOT NULL
- DEPT_NO — NUMBER(8) — NOT NULL
- EMP_NM — VARCHAR2(100) — NOT NULL
- SURN_ENG_NM — VARCHAR2(100)
- GIVN_ENG_NM — VARCHAR2(100)
- EXPSR_YN — CHAR(1) — NOT NULL
- TELNO — VARCHAR2(11)
- EML_ADDR — VARCHAR2(320)
- JBPS_CD — VARCHAR2(10)
- STTS_CD — VARCHAR2(10)
- SORT_SEQ — NUMBER(10)
- TKCG_TASK_NM — VARCHAR2(300)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_FILE
- FILE_NO — NUMBER(8) — Primary key — NOT NULL
- FILE_NM — VARCHAR2(300)
- FILE_EXPLN — VARCHAR2(4000)
- ORGNL_FILE_NM — VARCHAR2(300)
- PHYS_FILE_NM — VARCHAR2(300)
- FILE_URL_ADDR — VARCHAR2(2000)
- FILE_EXTN_CD — VARCHAR2(10)
- USE_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_FILE_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- FILE_NO — NUMBER(8) — NOT NULL
- FILE_NM — VARCHAR2(300) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- FILE_EXPLN — VARCHAR2(4000)
- ORGNL_FILE_NM — VARCHAR2(300) — NOT NULL
- PHYS_FILE_NM — VARCHAR2(300) — NOT NULL
- FILE_URL_ADDR — VARCHAR2(2000)
- FILE_EXTN_CD — VARCHAR2(10)
- USE_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_MENU_ACS_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100)
- MENU_ACS_TYPE_CD — VARCHAR2(10)
- MENU_ACS_DT — TIMESTAMP — NOT NULL
- MENU_NO — VARCHAR2(20)
- MENU_URL_ADDR — VARCHAR2(2000)
- MENU_ACS_STTS_CD — VARCHAR2(10)
COM_POPUP
- POPUP_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- POPUP_NM — VARCHAR2(300) — NOT NULL
- EXPSR_YN — CHAR(1) — NOT NULL
- EXPSR_SEQ — NUMBER(10)
- POPUP_CN — VARCHAR2(4000)
- RGTR_NM — VARCHAR2(100)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- POPUP_URL_ADDR — VARCHAR2(2000)
- ATCH_FILE_NO — NUMBER(8) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_POPUP_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- POPUP_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- POPUP_NM — VARCHAR2(300) — NOT NULL
- EXPSR_YN — CHAR(1) — NOT NULL
- EXPSR_SEQ — NUMBER(10)
- POPUP_CN — VARCHAR2(4000)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- POPUP_URL_ADDR — VARCHAR2(2000)
- ATCH_FILE_NO — NUMBER(8) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_PRVC_ACS_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100)
- HSTRY_TYPE_CD — VARCHAR2(10)
- ACS_DT — TIMESTAMP — NOT NULL
- ACS_IP_ADDR — VARCHAR2(15)
- ACS_URL_ADDR — VARCHAR2(2000)
- ACS_TYPE_CD — VARCHAR2(10)
- ACS_RSN — VARCHAR2(4000)
- ACS_CN — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP
COM_PRVC_PRCS_PRCPL
- PRVC_PRCS_PRCPL_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- CONTS_NM — VARCHAR2(300) — NOT NULL
- CONTS_CN — VARCHAR2(4000) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- KOGL_TYPE_CD — VARCHAR2(10)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_PRVC_PRCS_PRCPL_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- PRVC_PRCS_PRCPL_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- CONTS_NM — VARCHAR2(300) — NOT NULL
- CONTS_CN — VARCHAR2(4000) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- KOGL_TYPE_CD — VARCHAR2(10)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_PST
- PST_NO — NUMBER(8) — Primary key — NOT NULL
- BBS_NO — NUMBER(8) — NOT NULL
- PST_SE_CD — VARCHAR2(10)
- PST_NM — VARCHAR2(500) — NOT NULL
- NTC_YN — CHAR(1) — NOT NULL
- DEPT_NM — VARCHAR2(200)
- PIC_NM — VARCHAR2(100)
- PIC_TELNO — VARCHAR2(20)
- KOGL_TYPE_CD — VARCHAR2(10)
- PBANC_NO — VARCHAR2(50)
- LEGIS_NOTIC_BGNG_YMD — CHAR(8)
- LEGIS_NOTIC_END_YMD — CHAR(8)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- PST_SMRY_CN — VARCHAR2(4000)
- PST_CN — CLOB
- PST_REL_URL_ADDR — VARCHAR2(2000)
- PST_INQ_CNT — NUMBER(10)
- ATCH_FILE_NO — NUMBER(8)
- SCRTY_RVW_YN — CHAR(1) — NOT NULL
- APRV_YN — CHAR(1) — NOT NULL
- AUTZR_ID — VARCHAR2(100)
- APRV_DT — TIMESTAMP
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
- RLS_YN — CHAR(1)
- WNAWD_NM — VARCHAR2(100)
- WNAWD_YR — CHAR(4)
COM_PST_DWNLD_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- PST_NO — NUMBER(8)
- ATCH_FILE_NO — NUMBER(8)
- USER_ID — VARCHAR2(100)
- DWNLD_DT — TIMESTAMP
- ACS_IP_ADDR — VARCHAR2(15)
- REG_DT — TIMESTAMP — NOT NULL
COM_PST_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- PST_NO — NUMBER(8) — NOT NULL
- BBS_NO — NUMBER(8) — NOT NULL
- PST_SE_CD — VARCHAR2(10)
- HSTRY_TYPE_CD — VARCHAR2(10)
- PST_NM — VARCHAR2(300) — NOT NULL
- NTC_YN — CHAR(1) — NOT NULL
- DEPT_NM — VARCHAR2(200)
- PIC_NM — VARCHAR2(100)
- PIC_TELNO — VARCHAR2(11)
- KOGL_TYPE_CD — VARCHAR2(10)
- PBANC_NO — VARCHAR2(50)
- LEGIS_NOTIC_BGNG_YMD — CHAR(8)
- LEGIS_NOTIC_END_YMD — CHAR(8)
- PSTG_BGNG_DT — TIMESTAMP
- PSTG_END_DT — TIMESTAMP
- PST_SMRY_CN — VARCHAR2(4000)
- PST_CN — CLOB
- PST_REL_URL_ADDR — VARCHAR2(2000)
- PST_INQ_CNT — NUMBER(10)
- ATCH_FILE_NO — NUMBER(8)
- SCRTY_RVW_YN — CHAR(1) — NOT NULL
- APRV_YN — CHAR(1) — NOT NULL
- AUTZR_ID — VARCHAR2(100)
- APRV_DT — TIMESTAMP
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
- RLS_YN — CHAR(1)
- WNAWD_NM — VARCHAR2(100)
- WNAWD_YR — CHAR(4)
COM_PST_KYWD
- KYWD_NM — VARCHAR2(300) — Primary key — NOT NULL
- PST_NO — NUMBER(8) — Foreign key → COM_PST.PST_NO — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_PST_KYWD_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- PST_NO — NUMBER(8) — NOT NULL
- KYWD_NM — VARCHAR2(300) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_RSCH
- RSCH_NO — NUMBER(19) — Primary key — NOT NULL
- RSCH_YR — CHAR(4)
- RSCH_NM — VARCHAR2(300)
- CMPTN_YN — CHAR(1)
- RSCH_INST_NM — VARCHAR2(100)
- PVSN_INST_N1_NM — VARCHAR2(100)
- PVSN_INST_N2_NM — VARCHAR2(100)
- RSCH_CLSF_NO — NUMBER(19)
- RSCH_CLSF_LEVEL — NUMBER(19)
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_RSCH_CLSF
- RSCH_CLSF_NO — NUMBER(19) — Primary key — NOT NULL
- RSCH_CLSF_NM — VARCHAR2(100)
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_SITE
- SITE_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_SE_CD — VARCHAR2(10)
- SITE_NM — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- SITE_EXPLN — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_SITE_AUTHRT
- MENU_NO — NUMBER(8) — Primary key — NOT NULL
- USER_TYPE_CD — VARCHAR2(10) — Primary key — NOT NULL
- AUTHRT_CD — VARCHAR2(10) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — Foreign key → COM_SITE.SITE_NO — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_SITE_DTL
- SITE_ARTCL_SE_CD — VARCHAR2(10) — Primary key — NOT NULL
- SITE_ARTCL_CN — VARCHAR2(500) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — Foreign key → COM_SITE.SITE_NO — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_SITE_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- SITE_SE_CD — VARCHAR2(10)
- HSTRY_TYPE_CD — VARCHAR2(10)
- SITE_NM — VARCHAR2(100) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- SITE_EXPLN — VARCHAR2(4000)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_SITE_MENU
- MENU_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- MENU_ICON_NM — VARCHAR2(100)
- MENU_NM — VARCHAR2(100)
- UP_MENU_NO — NUMBER(8)
- MENU_LEVEL — NUMBER(4)
- SORT_SEQ — NUMBER(10)
- MENU_EXPLN — VARCHAR2(4000)
- USE_YN — CHAR(1) — NOT NULL
- RLS_YN — CHAR(1)
- MENU_TYPE_CD — VARCHAR2(10)
- MENU_CN — VARCHAR2(1000)
- MENU_NPAG_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_SITE_MENU_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- MENU_NO — NUMBER(8) — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- MENU_ICON_NM — VARCHAR2(100)
- MENU_NM — VARCHAR2(100)
- UP_MENU_NO — NUMBER(8)
- MENU_LEVEL — NUMBER(4)
- SORT_SEQ — NUMBER(10)
- MENU_EXPLN — VARCHAR2(4000)
- USE_YN — CHAR(1) — NOT NULL
- RLS_YN — CHAR(1)
- MENU_TYPE_CD — VARCHAR2(10)
- MENU_CN — VARCHAR2(1000)
- MENU_NPAG_YN — CHAR(1) — NOT NULL
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_USER
- USER_ID — VARCHAR2(100) — Primary key — NOT NULL
- DEPT_NO — NUMBER(8) — NOT NULL
- PSWD — VARCHAR2(1000) — NOT NULL
- USER_TELNO — VARCHAR2(11)
- USER_MBL_TELNO — VARCHAR2(11) — NOT NULL
- USER_EML_ADDR — VARCHAR2(320)
- USER_JBPS_CD — VARCHAR2(10)
- USER_STTS_CD — VARCHAR2(10)
- USER_TYPE_CD — VARCHAR2(10) — NOT NULL
- USER_TKCG_TASK_NM — VARCHAR2(300)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
COM_USER_BKMK
- MENU_NO — NUMBER(8) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100) — Foreign key → COM_USER.USER_ID — NOT NULL
COM_USER_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100) — NOT NULL
- DEPT_NO — NUMBER(8) — NOT NULL
- HSTRY_TYPE_CD — VARCHAR2(10)
- PSWD — VARCHAR2(1000)
- USER_TELNO — VARCHAR2(11)
- USER_MBL_TELNO — VARCHAR2(11) — NOT NULL
- USER_EML_ADDR — VARCHAR2(320)
- USER_JBPS_CD — VARCHAR2(10)
- USER_STTS_CD — VARCHAR2(10)
- USER_TYPE_CD — VARCHAR2(10)
- USER_TKCG_TASK_NM — VARCHAR2(300)
- RGTR_ID — VARCHAR2(100) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
COM_USER_LGN_HSTRY
- HSTRY_NO — NUMBER(8) — Primary key — NOT NULL
- USER_ID — VARCHAR2(100)
- LGN_DT — TIMESTAMP
- LGN_IP_ADDR — VARCHAR2(15)
- LGN_TYPE_CD — VARCHAR2(10)
- LGN_STTS_CD — VARCHAR2(10)
- SESION_ID — VARCHAR2(100)
- AGT_ID — VARCHAR2(500)
- SCRTY_STTS_CD — VARCHAR2(10)
- REG_DT — TIMESTAMP — NOT NULL
- ACS_TYPE_CD — VARCHAR2(10)
com_pbrl
- PBRL_NO — NUMBER(8)
- PBRL_TTL — VARCHAR2(256)
- PBRL_CN — CLOB
- RGTR_ID — VARCHAR2(100)
- REG_DT — TIMESTAMP — NOT NULL
- CHNRG_ID — VARCHAR2(100)
- CHG_DT — TIMESTAMP
com_srwrd
- SRWRD_NO — NUMBER(8) — Primary key — NOT NULL
- SITE_NO — NUMBER(8) — NOT NULL
- SRWRD_SE_CD — VARCHAR2(10)
- SRWRD_NM — VARCHAR2(100)
- REG_DT — TIMESTAMP — NOT NULL