test2
Tables (22)
COMTHEMAILDSPTCHMANAGE
- MSSAGE_ID — VARCHAR2(20) — Primary key — NOT NULL
- EMAIL_CN — CLOB
- SNDR — VARCHAR2(50) — NOT NULL
- RCVER — VARCHAR2(50) — NOT NULL
- SJ — VARCHAR2(60) — NOT NULL
- SNDNG_RESULT_CODE — CHAR(1)
- DSPTCH_DT — CHAR(20) — NOT NULL
- ATCH_FILE_ID — CHAR(20)
COMTHPROGRMCHANGEDTLS
- PROGRM_FILE_NM — VARCHAR2(60) — Primary key — NOT NULL
- REQUST_NO — NUMBER(10) — Primary key — NOT NULL
- RQESTER_ID — VARCHAR2(20) — NOT NULL
- CHANGE_REQUST_CN — VARCHAR2(1000)
- REQUST_PROCESS_CN — CLOB
- OPETR_ID — VARCHAR2(20)
- PROCESS_STTUS_CODE — VARCHAR2(15) — NOT NULL
- PROCESS_DE — CHAR(20)
- RQESTDE — CHAR(20)
- REQUST_SJ — VARCHAR2(60) — NOT NULL
COMTNAUTHORGROUPINFO
- GROUP_ID — CHAR(20) — Primary key — NOT NULL
- GROUP_NM — VARCHAR2(60) — NOT NULL
- GROUP_CREAT_DE — CHAR(20) — NOT NULL
- GROUP_DC — VARCHAR2(100)
COMTNBANNER
- BANNER_ID — CHAR(20) — Primary key — NOT NULL
- BANNER_NM — VARCHAR2(60) — NOT NULL
- LINK_URL — VARCHAR2(255) — NOT NULL
- BANNER_IMAGE — VARCHAR2(60) — NOT NULL
- BANNER_DC — VARCHAR2(200)
- REFLCT_AT — CHAR(1) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- BANNER_IMAGE_FILE — VARCHAR2(60)
- SORT_ORDR — NUMBER(8)
COMTNBBSMASTER
- BBS_ID — CHAR(30) — Primary key — NOT NULL
- BBS_NM — VARCHAR2(255) — NOT NULL
- BBS_INTRCN — VARCHAR2(2400)
- BBS_TY_CODE — CHAR(6) — NOT NULL
- REPLY_POSBL_AT — CHAR(1)
- FILE_ATCH_POSBL_AT — CHAR(1) — NOT NULL
- ATCH_POSBL_FILE_NUMBER — NUMBER(2) — NOT NULL
- ATCH_POSBL_FILE_SIZE — NUMBER(8)
- USE_AT — CHAR(1) — NOT NULL
- TMPLAT_ID — CHAR(20)
- CMMNTY_ID — CHAR(20)
- FRST_REGISTER_ID — VARCHAR2(20) — NOT NULL
- FRST_REGIST_PNTTM — DATE — NOT NULL
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- BLOG_ID — CHAR(20)
- BLOG_AT — CHAR(2)
COMTNEMPLYRINFO
- EMPLYR_ID — VARCHAR2(20) — Primary key — NOT NULL
- ORGNZT_ID — CHAR(20)
- USER_NM — VARCHAR2(60) — NOT NULL
- PASSWORD — VARCHAR2(200) — NOT NULL
- EMPL_NO — VARCHAR2(20)
- IHIDNUM — VARCHAR2(200)
- SEXDSTN_CODE — CHAR(1)
- BRTHDY — CHAR(20)
- FXNUM — VARCHAR2(20)
- HOUSE_ADRES — VARCHAR2(100) — NOT NULL
- PASSWORD_HINT — VARCHAR2(100) — NOT NULL
- PASSWORD_CNSR — VARCHAR2(100) — NOT NULL
- HOUSE_END_TELNO — VARCHAR2(4) — NOT NULL
- AREA_NO — VARCHAR2(4) — NOT NULL
- DETAIL_ADRES — VARCHAR2(100)
- ZIP — VARCHAR2(6) — NOT NULL
- OFFM_TELNO — VARCHAR2(20)
- MBTLNUM — VARCHAR2(20)
- EMAIL_ADRES — VARCHAR2(50)
- OFCPS_NM — VARCHAR2(60)
- HOUSE_MIDDLE_TELNO — VARCHAR2(4) — NOT NULL
- GROUP_ID — CHAR(20)
- PSTINST_CODE — CHAR(8)
- EMPLYR_STTUS_CODE — CHAR(1) — NOT NULL
- ESNTL_ID — CHAR(20) — NOT NULL
- CRTFC_DN_VALUE — VARCHAR2(100)
- SBSCRB_DE — DATE
- LOCK_AT — CHAR(1)
- LOCK_CNT — NUMBER(3)
- LOCK_LAST_PNTTM — DATE
- CHG_PWD_LAST_PNTTM — DATE
COMTNFILE
- ATCH_FILE_ID — CHAR(20) — Primary key — NOT NULL
- CREAT_DT — DATE — NOT NULL
- USE_AT — CHAR(1)
COMTNLOGINSCRINIMAGE
- IMAGE_ID — CHAR(20) — Primary key — NOT NULL
- IMAGE_NM — VARCHAR2(20) — NOT NULL
- REFLCT_AT — CHAR(1) — NOT NULL
- IMAGE — VARCHAR2(60) — NOT NULL
- IMAGE_DC — VARCHAR2(200)
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- IMAGE_FILE — VARCHAR2(60)
COMTNMAINIMAGE
- IMAGE_ID — CHAR(20) — Primary key — NOT NULL
- IMAGE_NM — VARCHAR2(20) — NOT NULL
- IMAGE — VARCHAR2(60) — NOT NULL
- IMAGE_DC — VARCHAR2(200)
- REFLCT_AT — CHAR(1) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- IMAGE_FILE — VARCHAR2(60)
COMTNNTTSTATS
- STATS_ID — CHAR(18) — Primary key — NOT NULL
- NTCE_CO — NUMBER(10)
- AVRG_RDCNT — NUMBER(10)
- TOP_RDCNT — NUMBER(10)
- MUMM_RDCNT — NUMBER(10)
- TOP_NTCR_ID — VARCHAR2(20)
COMTNORGNZTINFO
- ORGNZT_ID — CHAR(20) — Primary key — NOT NULL
- ORGNZT_NM — VARCHAR2(20) — NOT NULL
- ORGNZT_DC — VARCHAR2(100)
COMTNPOPUPMANAGE
- POPUP_ID — VARCHAR2(20) — Primary key — NOT NULL
- POPUP_SJ_NM — VARCHAR2(1024)
- FILE_URL — VARCHAR2(1024)
- POPUP_WIDTH_LC — VARCHAR2(20)
- POPUP_WIDTH_SIZE — NUMBER
- NTCE_BGNDE — CHAR(20)
- NTCE_ENDDE — CHAR(20)
- STOPVEW_SETUP_AT — CHAR(1)
- NTCE_AT — CHAR(1)
- POPUP_VRTICL_LC — VARCHAR2(20)
- POPUP_VRTICL_SIZE — NUMBER
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTNPROGRMLIST
- PROGRM_FILE_NM — VARCHAR2(60) — Primary key — NOT NULL
- PROGRM_STRE_PATH — VARCHAR2(100) — NOT NULL
- PROGRM_KOREAN_NM — VARCHAR2(60)
- PROGRM_DC — VARCHAR2(200)
- URL — VARCHAR2(100) — NOT NULL
COMTNPROXYINFO
- PROXY_ID — CHAR(20) — Primary key — NOT NULL
- PROXY_NM — VARCHAR2(60)
- PROXY_IP — VARCHAR2(23)
- PROXY_PORT — VARCHAR2(10)
- TRGET_SVC_NM — VARCHAR2(255)
- SVC_DC — VARCHAR2(2000)
- SVC_IP — VARCHAR2(23)
- SVC_PORT — VARCHAR2(10)
- SVC_STTUS — CHAR(2)
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTNPROXYLOGINFO
- PROXY_ID — CHAR(20) — Primary key — NOT NULL
- LOG_ID — CHAR(20) — Primary key — NOT NULL
- CLNT_IP — VARCHAR2(23)
- CLNT_PORT — VARCHAR2(10)
- CONECT_TIME — DATE
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTNRECENTSRCHWRD
- RECENT_SRCHWRD_ID — CHAR(20) — Primary key — NOT NULL
- SRCHWRD_MANAGE_ID — CHAR(20) — NOT NULL
- RECENT_SRCHWRD_NM — VARCHAR2(255)
- RECENT_SRCHWRD_CO — NUMBER(20)
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTNRECENTSRCHWRDMANAGE
- SRCHWRD_MANAGE_ID — CHAR(20) — Primary key — NOT NULL
- SRCHWRD_MANAGE_NM — VARCHAR2(255)
- SRCHWRD_CONECT_URL — VARCHAR2(255)
- USER_SEARCH_AT — CHAR(1)
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTNSITELIST
- SITE_ID — CHAR(20) — Primary key — NOT NULL
- SITE_NM — VARCHAR2(100)
- SITE_URL — VARCHAR2(100)
- SITE_DC — VARCHAR2(1000)
- SITE_THEMA_CL_CODE — VARCHAR2(2)
- ACTVTY_AT — CHAR(1)
- USE_AT — CHAR(1)
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
COMTNSYSLOG
- REQUST_ID — VARCHAR2(20) — Primary key — NOT NULL
- JOB_SE_CODE — CHAR(3)
- INSTT_CODE — CHAR(7)
- OCCRRNC_DE — DATE
- RQESTER_IP — VARCHAR2(23)
- RQESTER_ID — VARCHAR2(20)
- TRGET_MENU_NM — VARCHAR2(255)
- SVC_NM — VARCHAR2(255)
- METHOD_NM — VARCHAR2(60)
- PROCESS_SE_CODE — CHAR(3)
- PROCESS_CO — NUMBER(10)
- PROCESS_TIME — VARCHAR2(14)
- RSPNS_CODE — CHAR(3)
- ERROR_SE — CHAR(1)
- ERROR_CO — NUMBER(10)
- ERROR_CODE — CHAR(3)
COMTNUNITYLINK
- UNITY_LINK_ID — CHAR(20) — Primary key — NOT NULL
- UNITY_LINK_GROUP — VARCHAR2(255)
- UNITY_LINK_NM — VARCHAR2(255)
- UNITY_LINK_URL — VARCHAR2(255)
- UNITY_LINK_DC — VARCHAR2(2500)
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
- UNITY_LINK_SE_CODE — CHAR(3)
COMTNUSERABSNCE
- EMPLYR_ID — VARCHAR2(20) — Primary key — NOT NULL
- USER_ABSNCE_AT — CHAR(1) — NOT NULL
- FRST_REGISTER_ID — VARCHAR2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2(20)
- LAST_UPDT_PNTTM — DATE
COMTSSYSLOGSUMMARY
- OCCRRNC_DE — CHAR(8) — Primary key — NOT NULL
- SVC_NM — VARCHAR2(255) — Primary key — NOT NULL
- METHOD_NM — VARCHAR2(60) — Primary key — NOT NULL
- CREAT_CO — NUMBER(10)
- UPDT_CO — NUMBER(10)
- RDCNT — NUMBER(10)
- DELETE_CO — NUMBER(10)
- OUTPT_CO — NUMBER(10)
- ERROR_CO — NUMBER(10)