Code - jhleem/egov

CREATE TABLE COMTNPROGRMLIST ( PROGRM_FILE_NM VARCHAR(60) NOT NULL, PROGRM_STRE_PATH VARCHAR(100) NOT NULL, PROGRM_KOREAN_NM VARCHAR(60) NULL, PROGRM_DC VARCHAR(200) NULL, URL VARCHAR(100) NOT NULL, PRIMARY KEY (PROGRM_FILE_NM) ) ; CREATE UNIQUE INDEX COMTNPROGRMLIST_PK ON COMTNPROGRMLIST ( PROGRM_FILE_NM ) ; CREATE TABLE COMTHPROGRMCHANGEDTLS ( PROGRM_FILE_NM VARCHAR(60) NOT NULL, REQUST_NO NUMERIC(10) NOT NULL, RQESTER_ID VARCHAR(20) NOT NULL, CHANGE_REQUST_CN VARCHAR(1000) NULL, REQUST_PROCESS_CN MEDIUMTEXT NULL, OPETR_ID VARCHAR(20) NULL, PROCESS_STTUS_CODE VARCHAR(15) NOT NULL, PROCESS_DE CHAR(20) NULL, RQESTDE CHAR(20) NULL, REQUST_SJ VARCHAR(60) NOT NULL, PRIMARY KEY (PROGRM_FILE_NM,REQUST_NO), FOREIGN KEY COMTHPROGRMCHANGEDTLS_FK1 (PROGRM_FILE_NM) REFERENCES COMTNPROGRMLIST(PROGRM_FILE_NM) ON DELETE CASCADE ) ; CREATE UNIQUE INDEX COMTHPROGRMCHANGEDTLS_PK ON COMTHPROGRMCHANGEDTLS ( PROGRM_FILE_NM, REQUST_NO ) ; CREATE INDEX COMTHPROGRMCHANGEDTLS_i01 ON COMTHPROGRMCHANGEDTLS ( PROGRM_FILE_NM ) ; CREATE TABLE COMTNPOPUPMANAGE ( POPUP_ID VARCHAR(20) NOT NULL, POPUP_SJ_NM VARCHAR(1024) NULL, FILE_URL VARCHAR(1024) NULL, POPUP_WIDTH_LC VARCHAR(20) NULL, POPUP_WIDTH_SIZE NUMERIC NULL, NTCE_BGNDE CHAR(20) NULL, NTCE_ENDDE CHAR(20) NULL, STOPVEW_SETUP_AT CHAR(1) NULL, NTCE_AT CHAR(1) NULL, POPUP_VRTICL_LC VARCHAR(20) NULL, POPUP_VRTICL_SIZE NUMERIC NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (POPUP_ID) ) ; CREATE UNIQUE INDEX COMTNPOPUPMANAGE_PK ON COMTNPOPUPMANAGE ( POPUP_ID ) ; CREATE TABLE COMTNBANNER ( BANNER_ID CHAR(20) NOT NULL, BANNER_NM VARCHAR(60) NOT NULL, LINK_URL VARCHAR(255) NOT NULL, BANNER_IMAGE VARCHAR(60) NOT NULL, BANNER_DC VARCHAR(200) NULL, REFLCT_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, BANNER_IMAGE_FILE VARCHAR(60) NULL, SORT_ORDR NUMERIC(8) NULL, PRIMARY KEY (BANNER_ID) ) ; CREATE UNIQUE INDEX COMTNBANNER_PK ON COMTNBANNER ( BANNER_ID ) ; CREATE TABLE COMTNLOGINSCRINIMAGE ( IMAGE_ID CHAR(20) NOT NULL, IMAGE_NM VARCHAR(20) NOT NULL, REFLCT_AT CHAR(1) NOT NULL, IMAGE VARCHAR(60) NOT NULL, IMAGE_DC VARCHAR(200) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, IMAGE_FILE VARCHAR(60) NULL, PRIMARY KEY (IMAGE_ID) ) ; CREATE UNIQUE INDEX COMTNLOGINSCRINIMAGE_PK ON COMTNLOGINSCRINIMAGE ( IMAGE_ID ) ; CREATE TABLE COMTNORGNZTINFO ( ORGNZT_ID CHAR(20) NOT NULL, ORGNZT_NM VARCHAR(20) NOT NULL, ORGNZT_DC VARCHAR(100) NULL, PRIMARY KEY (ORGNZT_ID) ) ; CREATE UNIQUE INDEX COMTNORGNZTINFO_PK ON COMTNORGNZTINFO ( ORGNZT_ID ) ; CREATE TABLE COMTNAUTHORGROUPINFO ( GROUP_ID CHAR(20) NOT NULL, GROUP_NM VARCHAR(60) NOT NULL, GROUP_CREAT_DE CHAR(20) NOT NULL, GROUP_DC VARCHAR(100) NULL, PRIMARY KEY (GROUP_ID) ) ; CREATE UNIQUE INDEX COMTNAUTHORGROUPINFO_PK ON COMTNAUTHORGROUPINFO ( GROUP_ID ) ; CREATE TABLE COMTNEMPLYRINFO ( EMPLYR_ID VARCHAR(20) NOT NULL, ORGNZT_ID CHAR(20) NULL, USER_NM VARCHAR(60) NOT NULL, PASSWORD VARCHAR(200) NOT NULL, EMPL_NO VARCHAR(20) NULL, IHIDNUM VARCHAR(200) NULL, SEXDSTN_CODE CHAR(1) NULL, BRTHDY CHAR(20) NULL, FXNUM VARCHAR(20) NULL, HOUSE_ADRES VARCHAR(100) NOT NULL, PASSWORD_HINT VARCHAR(100) NOT NULL, PASSWORD_CNSR VARCHAR(100) NOT NULL, HOUSE_END_TELNO VARCHAR(4) NOT NULL, AREA_NO VARCHAR(4) NOT NULL, DETAIL_ADRES VARCHAR(100) NULL, ZIP VARCHAR(6) NOT NULL, OFFM_TELNO VARCHAR(20) NULL, MBTLNUM VARCHAR(20) NULL, EMAIL_ADRES VARCHAR(50) NULL, OFCPS_NM VARCHAR(60) NULL, HOUSE_MIDDLE_TELNO VARCHAR(4) NOT NULL, GROUP_ID CHAR(20) NULL, PSTINST_CODE CHAR(8) NULL, EMPLYR_STTUS_CODE CHAR(1) NOT NULL, ESNTL_ID CHAR(20) NOT NULL, CRTFC_DN_VALUE VARCHAR(100) NULL, SBSCRB_DE DATETIME NULL, LOCK_AT CHAR(1) NULL, LOCK_CNT NUMERIC(3) NULL, LOCK_LAST_PNTTM DATETIME NULL, CHG_PWD_LAST_PNTTM DATETIME NULL, PRIMARY KEY (EMPLYR_ID), FOREIGN KEY COMTNEMPLYRINFO_FK2 (ORGNZT_ID) REFERENCES COMTNORGNZTINFO(ORGNZT_ID) ON DELETE SET NULL, FOREIGN KEY COMTNEMPLYRINFO_FK1 (GROUP_ID) REFERENCES COMTNAUTHORGROUPINFO(GROUP_ID) ON DELETE SET NULL ) ; CREATE UNIQUE INDEX COMTNEMPLYRINFO_PK ON COMTNEMPLYRINFO ( EMPLYR_ID ) ; CREATE INDEX COMTNEMPLYRINFO_i01 ON COMTNEMPLYRINFO ( ORGNZT_ID ) ; CREATE INDEX COMTNEMPLYRINFO_i02 ON COMTNEMPLYRINFO ( GROUP_ID ) ; CREATE TABLE COMTNFILE ( ATCH_FILE_ID CHAR(20) NOT NULL, CREAT_DT DATETIME NOT NULL, USE_AT CHAR(1) NULL, PRIMARY KEY (ATCH_FILE_ID) ) ; CREATE UNIQUE INDEX COMTNFILE_PK ON COMTNFILE ( ATCH_FILE_ID ) ; CREATE TABLE COMTHEMAILDSPTCHMANAGE ( MSSAGE_ID VARCHAR(20) NOT NULL, EMAIL_CN MEDIUMTEXT NULL, SNDR VARCHAR(50) NOT NULL, RCVER VARCHAR(50) NOT NULL, SJ VARCHAR(60) NOT NULL, SNDNG_RESULT_CODE CHAR(1) NULL, DSPTCH_DT CHAR(20) NOT NULL, ATCH_FILE_ID CHAR(20) NULL, PRIMARY KEY (MSSAGE_ID), FOREIGN KEY COMTHEMAILDSPTCHMANAGE_FK1 (ATCH_FILE_ID) REFERENCES COMTNFILE(ATCH_FILE_ID) ) ; CREATE UNIQUE INDEX COMTHEMAILDSPTCHMANAGE_PK ON COMTHEMAILDSPTCHMANAGE ( MSSAGE_ID ) ; CREATE INDEX COMTHEMAILDSPTCHMANAGE_i01 ON COMTHEMAILDSPTCHMANAGE ( SNDR ) ; CREATE INDEX COMTHEMAILDSPTCHMANAGE_i02 ON COMTHEMAILDSPTCHMANAGE ( ATCH_FILE_ID ) ; CREATE TABLE COMTNNTTSTATS ( STATS_ID CHAR(18) NOT NULL, NTCE_CO NUMERIC(10) NULL, AVRG_RDCNT NUMERIC(10) NULL, TOP_RDCNT NUMERIC(10) NULL, MUMM_RDCNT NUMERIC(10) NULL, TOP_NTCR_ID VARCHAR(20) NULL, PRIMARY KEY (STATS_ID) ) ; CREATE UNIQUE INDEX COMTNNTTSTATS_PK ON COMTNNTTSTATS ( STATS_ID ) ; CREATE TABLE COMTNSITELIST ( SITE_ID CHAR(20) NOT NULL, SITE_NM VARCHAR(100) NULL, SITE_URL VARCHAR(100) NULL, SITE_DC VARCHAR(1000) NULL, SITE_THEMA_CL_CODE VARCHAR(2) NULL, ACTVTY_AT CHAR(1) NULL, USE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (SITE_ID) ) ; CREATE UNIQUE INDEX COMTNSITELIST_PK ON COMTNSITELIST ( SITE_ID ) ; CREATE TABLE COMTNRECENTSRCHWRDMANAGE ( SRCHWRD_MANAGE_ID CHAR(20) NOT NULL, SRCHWRD_MANAGE_NM VARCHAR(255) NULL, SRCHWRD_CONECT_URL VARCHAR(255) NULL, USER_SEARCH_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SRCHWRD_MANAGE_ID) ) ; CREATE UNIQUE INDEX COMTNRECENTSRCHWRDMANAGE_PK ON COMTNRECENTSRCHWRDMANAGE ( SRCHWRD_MANAGE_ID ) ; CREATE TABLE COMTNRECENTSRCHWRD ( SRCHWRD_MANAGE_ID CHAR(20) NOT NULL, RECENT_SRCHWRD_ID CHAR(20) NOT NULL, RECENT_SRCHWRD_NM VARCHAR(255) NULL, RECENT_SRCHWRD_CO NUMERIC(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (RECENT_SRCHWRD_ID), FOREIGN KEY COMTNRECENTSRCHWRD_FK1 (SRCHWRD_MANAGE_ID) REFERENCES COMTNRECENTSRCHWRDMANAGE(SRCHWRD_MANAGE_ID) ) ; CREATE UNIQUE INDEX COMTNRECENTSRCHWRD_PK ON COMTNRECENTSRCHWRD ( RECENT_SRCHWRD_ID ) ; CREATE TABLE COMTNPROXYINFO ( PROXY_ID CHAR(20) NOT NULL, PROXY_NM VARCHAR(60) NULL, PROXY_IP VARCHAR(23) NULL, PROXY_PORT VARCHAR(10) NULL, TRGET_SVC_NM VARCHAR(255) NULL, SVC_DC VARCHAR(2000) NULL, SVC_IP VARCHAR(23) NULL, SVC_PORT VARCHAR(10) NULL, SVC_STTUS CHAR(2) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (PROXY_ID) ) ; CREATE UNIQUE INDEX COMTNPROXYINFO_PK ON COMTNPROXYINFO ( PROXY_ID ) ; CREATE TABLE COMTNPROXYLOGINFO ( PROXY_ID CHAR(20) NOT NULL, CLNT_IP VARCHAR(23) NULL, CLNT_PORT VARCHAR(10) NULL, CONECT_TIME DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (PROXY_ID,LOG_ID), FOREIGN KEY COMTNPROXYLOGINFO_FK1 (PROXY_ID) REFERENCES COMTNPROXYINFO(PROXY_ID) ) ; CREATE UNIQUE INDEX COMTNPROXYLOGINFO_PK ON COMTNPROXYLOGINFO ( PROXY_ID, LOG_ID ) ; CREATE TABLE COMTNMAINIMAGE ( IMAGE_ID CHAR(20) NOT NULL, IMAGE_NM VARCHAR(20) NOT NULL, IMAGE VARCHAR(60) NOT NULL, IMAGE_DC VARCHAR(200) NULL, REFLCT_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, IMAGE_FILE VARCHAR(60) NULL, PRIMARY KEY (IMAGE_ID) ) ; CREATE UNIQUE INDEX COMTNMAINIMAGE_PK ON COMTNMAINIMAGE ( IMAGE_ID ) ; CREATE TABLE COMTNUNITYLINK ( UNITY_LINK_ID CHAR(20) NOT NULL, UNITY_LINK_GROUP VARCHAR(255) NULL, UNITY_LINK_NM VARCHAR(255) NULL, UNITY_LINK_URL VARCHAR(255) NULL, UNITY_LINK_DC VARCHAR(2500) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, UNITY_LINK_SE_CODE CHAR(3) NULL, PRIMARY KEY (UNITY_LINK_ID) ) ; CREATE UNIQUE INDEX COMTNUNITYLINK_PK ON COMTNUNITYLINK ( UNITY_LINK_ID ) ; CREATE TABLE COMTNUSERABSNCE ( EMPLYR_ID VARCHAR(20) NOT NULL, USER_ABSNCE_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTNUSERABSNCE_PK ON COMTNUSERABSNCE ( EMPLYR_ID ) ; CREATE TABLE COMTSSYSLOGSUMMARY ( OCCRRNC_DE CHAR(8) NOT NULL, SVC_NM VARCHAR(255) NOT NULL, METHOD_NM VARCHAR(60) NOT NULL, CREAT_CO NUMERIC(10) NULL, UPDT_CO NUMERIC(10) NULL, RDCNT NUMERIC(10) NULL, DELETE_CO NUMERIC(10) NULL, OUTPT_CO NUMERIC(10) NULL, ERROR_CO NUMERIC(10) NULL, PRIMARY KEY (OCCRRNC_DE,SVC_NM,METHOD_NM) ) ; CREATE UNIQUE INDEX COMTSSYSLOGSUMMARY_PK ON COMTSSYSLOGSUMMARY ( OCCRRNC_DE, SVC_NM, METHOD_NM ) ; CREATE TABLE COMTNSYSLOG ( REQUST_ID VARCHAR(20) NOT NULL, JOB_SE_CODE CHAR(3) NULL, INSTT_CODE CHAR(7) NULL, OCCRRNC_DE DATETIME NULL, RQESTER_IP VARCHAR(23) NULL, RQESTER_ID VARCHAR(20) NULL, TRGET_MENU_NM VARCHAR(255) NULL, SVC_NM VARCHAR(255) NULL, METHOD_NM VARCHAR(60) NULL, PROCESS_SE_CODE CHAR(3) NULL, PROCESS_CO NUMERIC(10) NULL, PROCESS_TIME VARCHAR(14) NULL, RSPNS_CODE CHAR(3) NULL, ERROR_SE CHAR(1) NULL, ERROR_CO NUMERIC(10) NULL, ERROR_CODE CHAR(3) NULL, PRIMARY KEY (REQUST_ID) ) ; CREATE UNIQUE INDEX COMTNSYSLOG_PK ON COMTNSYSLOG ( REQUST_ID ) ; CREATE TABLE COMTNBBSMASTER ( BBS_ID CHAR(20) NOT NULL, BBS_NM VARCHAR(255) NOT NULL, BBS_INTRCN VARCHAR(2400) NULL, BBS_TY_CODE CHAR(6) NOT NULL, REPLY_POSBL_AT CHAR(1) NULL, FILE_ATCH_POSBL_AT CHAR(1) NOT NULL, ATCH_POSBL_FILE_NUMBER NUMERIC(2) NOT NULL, ATCH_POSBL_FILE_SIZE NUMERIC(8) NULL, USE_AT CHAR(1) NOT NULL, TMPLAT_ID CHAR(20) NULL, CMMNTY_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, BLOG_ID CHAR(20) NULL, BLOG_AT CHAR(2) NULL, PRIMARY KEY (BBS_ID) ) ; CREATE UNIQUE INDEX COMTNBBSMASTER_PK ON COMTNBBSMASTER ( BBS_ID ) ; CREATE TABLE COMTNBBS ( NTT_ID NUMERIC(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, NTT_NO NUMERIC(20) NULL, NTT_SJ VARCHAR(2000) NULL, NTT_CN MEDIUMTEXT NULL, ANSWER_AT CHAR(1) NULL, PARNTSCTT_NO NUMERIC(10) NULL, ANSWER_LC NUMERIC(8) NULL, SORT_ORDR NUMERIC(8) NULL, RDCNT NUMERIC(10) NULL, USE_AT CHAR(1) NOT NULL, NTCE_BGNDE CHAR(20) NULL, NTCE_ENDDE CHAR(20) NULL, NTCR_ID VARCHAR(20) NULL, NTCR_NM VARCHAR(20) NULL, PASSWORD VARCHAR(200) NULL, ATCH_FILE_ID CHAR(20) NULL, NOTICE_AT CHAR(1) NULL, SJ_BOLD_AT CHAR(1) NULL, SECRET_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, BLOG_ID CHAR(20) NULL, PRIMARY KEY (NTT_ID,BBS_ID), FOREIGN KEY COMTNBBS_FK1 (BBS_ID) REFERENCES COMTNBBSMASTER(BBS_ID) ) ; CREATE UNIQUE INDEX COMTNBBS_PK ON COMTNBBS ( NTT_ID, BBS_ID ) ; CREATE INDEX COMTNBBS_i01 ON COMTNBBS ( BBS_ID ) ; CREATE TABLE COMTNCOMMENT ( NTT_ID NUMERIC(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, ANSWER_NO NUMERIC(20) NOT NULL, WRTER_ID VARCHAR(20) NULL, WRTER_NM VARCHAR(20) NULL, ANSWER VARCHAR(200) NULL, USE_AT CHAR(1) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PASSWORD VARCHAR(200) NULL, PRIMARY KEY (NTT_ID,BBS_ID,ANSWER_NO), FOREIGN KEY COMTNCOMMENT_FK1 (NTT_ID,BBS_ID) REFERENCES COMTNBBS(NTT_ID,BBS_ID) ) ; CREATE UNIQUE INDEX COMTNCOMMENT_PK ON COMTNCOMMENT ( NTT_ID, BBS_ID, ANSWER_NO ) ; CREATE INDEX COMTNCOMMENT_i01 ON COMTNCOMMENT ( NTT_ID, BBS_ID ) ; CREATE TABLE COMTNRECOMENDSITEINFO ( RECOMEND_SITE_ID CHAR(20) NOT NULL, RECOMEND_SITE_NM VARCHAR(100) NULL, RECOMEND_SITE_URL VARCHAR(255) NULL, RECOMEND_SITE_DC VARCHAR(1000) NULL, RECOMEND_RESN_CN VARCHAR(1000) NULL, RECOMEND_CONFM_AT CHAR(1) NULL, CONFM_DE CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (RECOMEND_SITE_ID) ) ; CREATE UNIQUE INDEX COMTNRECOMENDSITEINFO_PK ON COMTNRECOMENDSITEINFO ( RECOMEND_SITE_ID ) ; CREATE TABLE COMTNINTNETSVC ( INTNET_SVC_ID CHAR(20) NOT NULL, INTNET_SVC_NM VARCHAR(20) NOT NULL, INTNET_SVC_DC VARCHAR(200) NULL, REFLCT_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (INTNET_SVC_ID) ) ; CREATE UNIQUE INDEX COMTNINTNETSVC_PK ON COMTNINTNETSVC ( INTNET_SVC_ID ) ; CREATE TABLE COMTNCLUB ( CLB_ID CHAR(20) NOT NULL, CMMNTY_ID CHAR(20) NOT NULL, CLB_NM VARCHAR(255) NOT NULL, CLB_INTRCN VARCHAR(2400) NULL, USE_AT CHAR(1) NOT NULL, REGIST_SE_CODE CHAR(6) NULL, TMPLAT_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CLB_ID,CMMNTY_ID) ) ; CREATE UNIQUE INDEX COMTNCLUB_PK ON COMTNCLUB ( CLB_ID, CMMNTY_ID ) ; CREATE TABLE COMTNCLUBUSER ( CLB_ID CHAR(20) NOT NULL, CMMNTY_ID CHAR(20) NOT NULL, OPRTR_AT CHAR(1) NOT NULL, SBSCRB_DE DATETIME NULL, SECSN_DE CHAR(20) NULL, USE_AT CHAR(1) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, EMPLYR_ID VARCHAR(20) NOT NULL, PRIMARY KEY (CLB_ID,CMMNTY_ID,EMPLYR_ID), FOREIGN KEY COMTNCLUBUSER_FK1 (CLB_ID,CMMNTY_ID) REFERENCES COMTNCLUB(CLB_ID,CMMNTY_ID) ) ; CREATE UNIQUE INDEX COMTNCLUBUSER_PK ON COMTNCLUBUSER ( CLB_ID, CMMNTY_ID, EMPLYR_ID ) ; CREATE INDEX COMTNCLUBUSER_i01 ON COMTNCLUBUSER ( CLB_ID, CMMNTY_ID ) ; CREATE TABLE COMTNBACKUPOPERT ( BACKUP_OPERT_ID VARCHAR(20) NOT NULL, BACKUP_OPERT_NM VARCHAR(60) NULL, BACKUP_ORGINL_DRCTRY VARCHAR(255) NULL, BACKUP_STRE_DRCTRY VARCHAR(255) NULL, CMPRS_SE VARCHAR(2) NULL, EXECUT_CYCLE VARCHAR(2) NULL, EXECUT_SCHDUL_DE CHAR(20) NULL, EXECUT_SCHDUL_HOUR CHAR(2) NULL, EXECUT_SCHDUL_MNT CHAR(2) NULL, EXECUT_SCHDUL_SECND CHAR(2) NULL, USE_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (BACKUP_OPERT_ID) ) ; CREATE UNIQUE INDEX COMTNBACKUPOPERT_PK ON COMTNBACKUPOPERT ( BACKUP_OPERT_ID ) ; CREATE TABLE COMTNBACKUPSCHDULDFK ( BACKUP_OPERT_ID VARCHAR(20) NOT NULL, EXECUT_SCHDUL_DFK_SE CHAR(1) NOT NULL, PRIMARY KEY (BACKUP_OPERT_ID,EXECUT_SCHDUL_DFK_SE), FOREIGN KEY COMTNBACKUPSCHDULDFK_FK1 (BACKUP_OPERT_ID) REFERENCES COMTNBACKUPOPERT(BACKUP_OPERT_ID) ) ; CREATE UNIQUE INDEX COMTNBACKUPSCHDULDFK_PK ON COMTNBACKUPSCHDULDFK ( BACKUP_OPERT_ID, EXECUT_SCHDUL_DFK_SE ) ; CREATE TABLE COMTNCMMNTY ( CMMNTY_ID CHAR(20) NOT NULL, CMMNTY_NM VARCHAR(255) NOT NULL, CMMNTY_INTRCN VARCHAR(2400) NULL, USE_AT CHAR(1) NOT NULL, REGIST_SE_CODE CHAR(6) NULL, TMPLAT_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CMMNTY_ID) ) ; CREATE UNIQUE INDEX COMTNCMMNTY_PK ON COMTNCMMNTY ( CMMNTY_ID ) ; CREATE TABLE COMTNCMMNTYUSER ( CMMNTY_ID CHAR(20) NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, MNGR_AT CHAR(1) NOT NULL, MBER_STTUS VARCHAR(15) NULL, SBSCRB_DE DATETIME NULL, SECSN_DE CHAR(20) NULL, USE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CMMNTY_ID,EMPLYR_ID), FOREIGN KEY COMTNCMMNTYUSER_FK1 (CMMNTY_ID) REFERENCES COMTNCMMNTY(CMMNTY_ID) ) ; CREATE UNIQUE INDEX COMTNCMMNTYUSER_PK ON COMTNCMMNTYUSER ( CMMNTY_ID, EMPLYR_ID ) ; CREATE INDEX COMTNCMMNTYUSER_i01 ON COMTNCMMNTYUSER ( CMMNTY_ID ) ; CREATE TABLE COMTNFILEDETAIL ( ATCH_FILE_ID CHAR(20) NOT NULL, FILE_SN NUMERIC(10) NOT NULL, FILE_STRE_COURS VARCHAR(2000) NOT NULL, STRE_FILE_NM VARCHAR(255) NOT NULL, ORIGNL_FILE_NM VARCHAR(255) NULL, FILE_EXTSN VARCHAR(20) NOT NULL, FILE_CN MEDIUMTEXT NULL, FILE_SIZE NUMERIC(8) NULL, PRIMARY KEY (ATCH_FILE_ID,FILE_SN), FOREIGN KEY COMTNFILEDETAIL_FK1 (ATCH_FILE_ID) REFERENCES COMTNFILE(ATCH_FILE_ID) ) ; CREATE UNIQUE INDEX COMTNFILEDETAIL_PK ON COMTNFILEDETAIL ( ATCH_FILE_ID, FILE_SN ) ; CREATE INDEX COMTNFILEDETAIL_i01 ON COMTNFILEDETAIL ( ATCH_FILE_ID ) ; CREATE TABLE COMTNLOGINPOLICY ( EMPLYR_ID VARCHAR(20) NOT NULL, IP_INFO VARCHAR(23) NOT NULL, DPLCT_PERM_AT CHAR(1) NOT NULL, LMTT_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTNLOGINPOLICY_PK ON COMTNLOGINPOLICY ( EMPLYR_ID ) ; CREATE TABLE COMTNQUSTNRTMPLAT ( QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, QUSTNR_TMPLAT_TY VARCHAR(100) NULL, QUSTNR_TMPLAT_DC VARCHAR(2000) NULL, QUSTNR_TMPLAT_PATH_NM VARCHAR(100) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, QUSTNR_TMPLAT_IMAGE_INFO BLOB NULL, PRIMARY KEY (QUSTNR_TMPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNQUSTNRTMPLAT_PK ON COMTNQUSTNRTMPLAT ( QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTNQESTNRINFO ( QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, QESTNR_ID CHAR(20) NOT NULL, QUSTNR_SJ VARCHAR(255) NULL, QUSTNR_PURPS VARCHAR(1000) NULL, QUSTNR_WRITNG_GUIDANCE_CN VARCHAR(2000) NULL, QUSTNR_TRGET VARCHAR(1000) NULL, QUSTNR_BGNDE CHAR(20) NULL, QUSTNR_ENDDE CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (QUSTNR_TMPLAT_ID,QESTNR_ID), FOREIGN KEY COMTNQESTNRINFO_FK1 (QUSTNR_TMPLAT_ID) REFERENCES COMTNQUSTNRTMPLAT(QUSTNR_TMPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNQESTNRINFO_PK ON COMTNQESTNRINFO ( QUSTNR_TMPLAT_ID, QESTNR_ID ) ; CREATE INDEX COMTNQESTNRINFO_i01 ON COMTNQESTNRINFO ( QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTNQUSTNRRESPONDINFO ( QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, QESTNR_ID CHAR(20) NOT NULL, QUSTNR_RESPOND_ID CHAR(20) NOT NULL, SEXDSTN_CODE CHAR(1) NULL, OCCP_TY_CODE CHAR(1) NULL, RESPOND_NM VARCHAR(50) NULL, BRTHDY CHAR(20) NULL, AREA_NO VARCHAR(4) NULL, MIDDLE_TELNO VARCHAR(4) NULL, END_TELNO VARCHAR(4) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (QUSTNR_TMPLAT_ID,QESTNR_ID,QUSTNR_RESPOND_ID), FOREIGN KEY COMTNQUSTNRRESPONDINFO_FK1 (QUSTNR_TMPLAT_ID,QESTNR_ID) REFERENCES COMTNQESTNRINFO(QUSTNR_TMPLAT_ID,QESTNR_ID) ) ; CREATE UNIQUE INDEX COMTNQUSTNRRESPONDINFO_PK ON COMTNQUSTNRRESPONDINFO ( QUSTNR_TMPLAT_ID, QESTNR_ID, QUSTNR_RESPOND_ID ) ; CREATE INDEX COMTNQUSTNRRESPONDINFO_i01 ON COMTNQUSTNRRESPONDINFO ( QESTNR_ID, QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTCADMINISTCODE ( ADMINIST_ZONE_SE CHAR(1) NOT NULL, ADMINIST_ZONE_CODE VARCHAR(10) NOT NULL, USE_AT CHAR(1) NOT NULL, ADMINIST_ZONE_NM VARCHAR(60) NULL, UPPER_ADMINIST_ZONE_CODE VARCHAR(10) NULL, CREAT_DE CHAR(20) NULL, ABL_DE CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (ADMINIST_ZONE_SE,ADMINIST_ZONE_CODE) ) ; CREATE UNIQUE INDEX COMTCADMINISTCODE_PK ON COMTCADMINISTCODE ( ADMINIST_ZONE_SE, ADMINIST_ZONE_CODE ) ; CREATE TABLE COMTNUSERLOG ( OCCRRNC_DE CHAR(8) NOT NULL, RQESTER_ID VARCHAR(20) NOT NULL, SVC_NM VARCHAR(255) NOT NULL, METHOD_NM VARCHAR(60) NOT NULL, CREAT_CO NUMERIC(10) NULL, UPDT_CO NUMERIC(10) NULL, RDCNT NUMERIC(10) NULL, DELETE_CO NUMERIC(10) NULL, OUTPT_CO NUMERIC(10) NULL, ERROR_CO NUMERIC(10) NULL, PRIMARY KEY (OCCRRNC_DE,RQESTER_ID,SVC_NM,METHOD_NM) ) ; CREATE UNIQUE INDEX COMTNUSERLOG_PK ON COMTNUSERLOG ( OCCRRNC_DE, RQESTER_ID, SVC_NM, METHOD_NM ) ; CREATE TABLE COMTSTRSMRCVLOGSUMMARY ( OCCRRNC_DE CHAR(20) NOT NULL, TRSMRCV_SE_CODE CHAR(3) NOT NULL, PROVD_INSTT_ID CHAR(8) NOT NULL, PROVD_SYS_ID CHAR(8) NOT NULL, PROVD_SVC_ID CHAR(8) NOT NULL, REQUST_INSTT_ID CHAR(8) NOT NULL, REQUST_SYS_ID CHAR(8) NOT NULL, RDCNT NUMERIC(10) NULL, ERROR_CO NUMERIC(10) NULL, PRIMARY KEY (OCCRRNC_DE,TRSMRCV_SE_CODE,PROVD_INSTT_ID,PROVD_SYS_ID,PROVD_SVC_ID,REQUST_INSTT_ID,REQUST_SYS_ID) ) ; CREATE UNIQUE INDEX COMTSTRSMRCVLOGSUMMARY_PK ON COMTSTRSMRCVLOGSUMMARY ( OCCRRNC_DE, TRSMRCV_SE_CODE, PROVD_INSTT_ID, PROVD_SYS_ID, PROVD_SVC_ID, REQUST_INSTT_ID, REQUST_SYS_ID ) ; CREATE TABLE COMTCCMMNCLCODE ( CL_CODE CHAR(3) NOT NULL, CL_CODE_NM VARCHAR(60) NULL, CL_CODE_DC VARCHAR(200) NULL, USE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CL_CODE) ) ; CREATE UNIQUE INDEX COMTCCMMNCLCODE_PK ON COMTCCMMNCLCODE ( CL_CODE ) ; CREATE TABLE COMTCCMMNCODE ( CODE_ID VARCHAR(6) NOT NULL, CODE_ID_NM VARCHAR(60) NULL, CODE_ID_DC VARCHAR(200) NULL, USE_AT CHAR(1) NULL, CL_CODE CHAR(3) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CODE_ID), FOREIGN KEY COMTCCMMNCODE_FK1 (CL_CODE) REFERENCES COMTCCMMNCLCODE(CL_CODE) ) ; CREATE UNIQUE INDEX COMTCCMMNCODE_PK ON COMTCCMMNCODE ( CODE_ID ) ; CREATE INDEX COMTCCMMNCODE_i01 ON COMTCCMMNCODE ( CL_CODE ) ; CREATE TABLE COMTCCMMNDETAILCODE ( CODE_ID VARCHAR(6) NOT NULL, CODE VARCHAR(15) NOT NULL, CODE_NM VARCHAR(60) NULL, CODE_DC VARCHAR(200) NULL, USE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CODE_ID,CODE), FOREIGN KEY COMTCCMMNDETAILCODE_FK1 (CODE_ID) REFERENCES COMTCCMMNCODE(CODE_ID) ) ; CREATE UNIQUE INDEX COMTCCMMNDETAILCODE_PK ON COMTCCMMNDETAILCODE ( CODE_ID, CODE ) ; CREATE INDEX COMTCCMMNDETAILCODE_i01 ON COMTCCMMNDETAILCODE ( CODE_ID ) ; CREATE TABLE COMTSBBSSUMMARY ( OCCRRNC_DE CHAR(20) NOT NULL, STATS_SE VARCHAR(10) NOT NULL, DETAIL_STATS_SE VARCHAR(10) NOT NULL, CREAT_CO NUMERIC(10) NULL, TOT_RDCNT NUMERIC(10) NULL, AVRG_RDCNT NUMERIC(10) NULL, TOP_INQIRE_BBSCTT_ID VARCHAR(20) NULL, MUMM_INQIRE_BBSCTT_ID VARCHAR(20) NULL, TOP_NTCR_ID VARCHAR(20) NULL, PRIMARY KEY (OCCRRNC_DE,STATS_SE,DETAIL_STATS_SE) ) ; CREATE UNIQUE INDEX COMTSBBSSUMMARY_PK ON COMTSBBSSUMMARY ( OCCRRNC_DE, STATS_SE, DETAIL_STATS_SE ) ; CREATE TABLE COMTCZIP ( ZIP VARCHAR(6) NOT NULL, SN NUMERIC(10) NOT NULL, CTPRVN_NM VARCHAR(20) NULL, SIGNGU_NM VARCHAR(20) NULL, EMD_NM VARCHAR(60) NULL, LI_BULD_NM VARCHAR(60) NULL, LNBR_DONG_HO VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (ZIP,SN) ) ; CREATE UNIQUE INDEX COMTCZIP_PK ON COMTCZIP ( ZIP, SN ) ; CREATE TABLE COMTRDNMADRZIP ( RDMN_CODE VARCHAR(12) NOT NULL, SN NUMERIC(10) NOT NULL, CTPRVN_NM VARCHAR(20) NULL, SIGNGU_NM VARCHAR(20) NULL, RDMN VARCHAR(60) NULL, BDNBR_MNNM VARCHAR(5) NULL, BDNBR_SLNO VARCHAR(5) NULL, BULD_NM VARCHAR(60) NULL, DETAIL_BULD_NM VARCHAR(60) NULL, ZIP VARCHAR(6) NOT NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (SN) ) ; CREATE UNIQUE INDEX COMTRDNMADRZIP_PK ON COMTRDNMADRZIP ( RDMN_CODE, SN ) ; CREATE TABLE COMTNNCRD ( NCRD_ID CHAR(20) NOT NULL, NCRD_TRGTER_ID VARCHAR(20) NULL, NM VARCHAR(50) NOT NULL, TELNO VARCHAR(20) NULL, NATION_NO VARCHAR(10) NULL, AREA_NO VARCHAR(4) NULL, MIDDLE_TELNO VARCHAR(4) NULL, END_TELNO VARCHAR(4) NULL, MBTLNUM VARCHAR(20) NULL, IDNTFC_NO VARCHAR(10) NULL, MIDDLE_MBTLNUM VARCHAR(4) NULL, END_MBTLNUM VARCHAR(4) NULL, EMAIL_ADRES VARCHAR(50) NULL, CMPNY_NM VARCHAR(60) NULL, DEPT_NM VARCHAR(60) NULL, ADRES VARCHAR(100) NULL, DETAIL_ADRES VARCHAR(100) NULL, OFCPS_NM VARCHAR(60) NULL, CLSF_NM VARCHAR(60) NULL, EXTRL_USER_AT CHAR(1) NULL, OTHBC_AT CHAR(1) NOT NULL, RM VARCHAR(2500) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (NCRD_ID) ) ; CREATE UNIQUE INDEX COMTNNCRD_PK ON COMTNNCRD ( NCRD_ID ) ; CREATE TABLE COMTNNCRDUSER ( NCRD_ID CHAR(20) NOT NULL, REGIST_SE_CODE CHAR(6) NOT NULL, USE_AT CHAR(1) NOT NULL, CREAT_DT DATETIME NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, PRIMARY KEY (NCRD_ID,EMPLYR_ID), FOREIGN KEY COMTNNCRDUSER_FK1 (NCRD_ID) REFERENCES COMTNNCRD(NCRD_ID) ) ; CREATE UNIQUE INDEX COMTNNCRDUSER_PK ON COMTNNCRDUSER ( NCRD_ID, EMPLYR_ID ) ; CREATE INDEX COMTNNCRDUSER_i03 ON COMTNNCRDUSER ( NCRD_ID ) ; CREATE TABLE COMTNENTRPRSMBER ( ENTRPRS_MBER_ID VARCHAR(20) NOT NULL, ENTRPRS_SE_CODE CHAR(8) NULL, BIZRNO VARCHAR(10) NULL, JURIRNO VARCHAR(13) NULL, CMPNY_NM VARCHAR(60) NOT NULL, CXFC VARCHAR(50) NULL, ZIP VARCHAR(6) NOT NULL, ADRES VARCHAR(100) NOT NULL, ENTRPRS_MIDDLE_TELNO VARCHAR(4) NOT NULL, FXNUM VARCHAR(20) NULL, INDUTY_CODE CHAR(1) NULL, APPLCNT_NM VARCHAR(50) NOT NULL, APPLCNT_IHIDNUM VARCHAR(200) NULL, SBSCRB_DE DATETIME NULL, ENTRPRS_MBER_STTUS VARCHAR(15) NULL, ENTRPRS_MBER_PASSWORD VARCHAR(200) NULL, ENTRPRS_MBER_PASSWORD_HINT VARCHAR(100) NOT NULL, ENTRPRS_MBER_PASSWORD_CNSR VARCHAR(100) NOT NULL, GROUP_ID CHAR(20) NULL, DETAIL_ADRES VARCHAR(100) NULL, ENTRPRS_END_TELNO VARCHAR(4) NOT NULL, AREA_NO VARCHAR(4) NOT NULL, APPLCNT_EMAIL_ADRES VARCHAR(50) NOT NULL, ESNTL_ID CHAR(20) NOT NULL, LOCK_AT CHAR(1) NULL, LOCK_CNT NUMERIC(3) NULL, LOCK_LAST_PNTTM DATETIME NULL, CHG_PWD_LAST_PNTTM DATETIME NULL, PRIMARY KEY (ENTRPRS_MBER_ID), FOREIGN KEY COMTNENTRPRSMBER_FK1 (GROUP_ID) REFERENCES COMTNAUTHORGROUPINFO(GROUP_ID) ON DELETE SET NULL ) ; CREATE UNIQUE INDEX COMTNENTRPRSMBER_PK ON COMTNENTRPRSMBER ( ENTRPRS_MBER_ID ) ; CREATE INDEX COMTNENTRPRSMBER_i01 ON COMTNENTRPRSMBER ( GROUP_ID ) ; CREATE TABLE COMTNGNRLMBER ( MBER_ID VARCHAR(20) NOT NULL, PASSWORD VARCHAR(200) NOT NULL, PASSWORD_HINT VARCHAR(100) NULL, PASSWORD_CNSR VARCHAR(100) NULL, IHIDNUM VARCHAR(200) NULL, MBER_NM VARCHAR(50) NOT NULL, ZIP VARCHAR(6) NOT NULL, ADRES VARCHAR(100) NOT NULL, AREA_NO VARCHAR(4) NOT NULL, MBER_STTUS VARCHAR(15) NULL, DETAIL_ADRES VARCHAR(100) NULL, END_TELNO VARCHAR(4) NOT NULL, MBTLNUM VARCHAR(20) NOT NULL, GROUP_ID CHAR(20) NULL, MBER_FXNUM VARCHAR(20) NULL, MBER_EMAIL_ADRES VARCHAR(50) NULL, MIDDLE_TELNO VARCHAR(4) NOT NULL, SBSCRB_DE DATETIME NULL, SEXDSTN_CODE CHAR(1) NULL, ESNTL_ID CHAR(20) NOT NULL, LOCK_AT CHAR(1) NULL, LOCK_CNT NUMERIC(3) NULL, LOCK_LAST_PNTTM DATETIME NULL, CHG_PWD_LAST_PNTTM DATETIME NULL, PRIMARY KEY (MBER_ID), FOREIGN KEY COMTNGNRLMBER_FK1 (GROUP_ID) REFERENCES COMTNAUTHORGROUPINFO(GROUP_ID) ON DELETE SET NULL ) ; CREATE UNIQUE INDEX COMTNGNRLMBER_PK ON COMTNGNRLMBER ( MBER_ID ) ; CREATE INDEX COMTNGNRLMBER_i01 ON COMTNGNRLMBER ( GROUP_ID ) ; CREATE TABLE COMTNAUTHORINFO ( AUTHOR_CODE VARCHAR(30) NOT NULL, AUTHOR_NM VARCHAR(60) NOT NULL, AUTHOR_DC VARCHAR(200) NULL, AUTHOR_CREAT_DE CHAR(20) NOT NULL, PRIMARY KEY (AUTHOR_CODE) ) ; CREATE UNIQUE INDEX COMTNAUTHORINFO_PK ON COMTNAUTHORINFO ( AUTHOR_CODE ) ; CREATE TABLE COMTNEMPLYRSCRTYESTBS ( SCRTY_DTRMN_TRGET_ID VARCHAR(20) NOT NULL, MBER_TY_CODE CHAR(5) NULL, AUTHOR_CODE VARCHAR(30) NOT NULL, PRIMARY KEY (SCRTY_DTRMN_TRGET_ID) ) ; CREATE UNIQUE INDEX COMTNEMPLYRSCRTYESTBS_PK ON COMTNEMPLYRSCRTYESTBS ( SCRTY_DTRMN_TRGET_ID ) ; CREATE INDEX COMTNEMPLYRSCRTYESTBS_i04 ON COMTNEMPLYRSCRTYESTBS ( AUTHOR_CODE ) ; CREATE TABLE COMTNQAINFO ( QA_ID CHAR(20) NOT NULL, QESTN_SJ VARCHAR(255) NULL, QESTN_CN VARCHAR(2500) NULL, WRITNG_DE CHAR(20) NULL, RDCNT NUMERIC(10) NULL, EMAIL_ADRES VARCHAR(50) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, QNA_PROCESS_STTUS_CODE CHAR(1) NULL, WRTER_NM VARCHAR(20) NULL, ANSWER_CN VARCHAR(2500) NULL, WRITNG_PASSWORD VARCHAR(20) NULL, ANSWER_DE CHAR(20) NULL, EMAIL_ANSWER_AT CHAR(1) NULL, AREA_NO VARCHAR(4) NULL, MIDDLE_TELNO VARCHAR(4) NULL, END_TELNO VARCHAR(4) NULL, PRIMARY KEY (QA_ID) ) ; CREATE UNIQUE INDEX COMTNQAINFO_PK ON COMTNQAINFO ( QA_ID ) ; CREATE TABLE COMTSWEBLOGSUMMARY ( OCCRRNC_DE CHAR(8) NOT NULL, URL VARCHAR(200) NOT NULL, RDCNT NUMERIC(10) NULL, PRIMARY KEY (OCCRRNC_DE,URL) ) ; CREATE UNIQUE INDEX COMTSWEBLOGSUMMARY_PK ON COMTSWEBLOGSUMMARY ( OCCRRNC_DE, URL ) ; CREATE TABLE COMTNROLES_HIERARCHY ( PARNTS_ROLE VARCHAR(30) NOT NULL, CHLDRN_ROLE VARCHAR(30) NOT NULL, PRIMARY KEY (PARNTS_ROLE,CHLDRN_ROLE), FOREIGN KEY COMTNROLES_HIERARCHY_FK1 (PARNTS_ROLE) REFERENCES COMTNAUTHORINFO(AUTHOR_CODE) ON DELETE CASCADE, FOREIGN KEY COMTNROLES_HIERARCHY_FK2 (CHLDRN_ROLE) REFERENCES COMTNAUTHORINFO(AUTHOR_CODE) ON DELETE CASCADE ) ; CREATE UNIQUE INDEX COMTNROLES_HIERARCHY_PK ON COMTNROLES_HIERARCHY ( PARNTS_ROLE, CHLDRN_ROLE ) ; CREATE UNIQUE INDEX COMTNROLES_HIERARCHY_i01 ON COMTNROLES_HIERARCHY ( PARNTS_ROLE ) ; CREATE INDEX COMTNROLES_HIERARCHY_i02 ON COMTNROLES_HIERARCHY ( CHLDRN_ROLE ) ; CREATE TABLE COMTNROLEINFO ( ROLE_CODE VARCHAR(50) NOT NULL, ROLE_NM VARCHAR(60) NOT NULL, ROLE_PTTRN VARCHAR(300) NULL, ROLE_DC VARCHAR(200) NULL, ROLE_TY VARCHAR(80) NULL, ROLE_SORT VARCHAR(10) NULL, ROLE_CREAT_DE CHAR(20) NOT NULL, PRIMARY KEY (ROLE_CODE) ) ; CREATE UNIQUE INDEX COMTNROLEINFO_PK ON COMTNROLEINFO ( ROLE_CODE ) ; CREATE TABLE COMTNAUTHORROLERELATE ( AUTHOR_CODE VARCHAR(30) NOT NULL, ROLE_CODE VARCHAR(50) NOT NULL, CREAT_DT DATETIME NULL, PRIMARY KEY (AUTHOR_CODE,ROLE_CODE), FOREIGN KEY COMTNAUTHORROLERELATE_FK1 (AUTHOR_CODE) REFERENCES COMTNAUTHORINFO(AUTHOR_CODE) ON DELETE CASCADE, FOREIGN KEY COMTNAUTHORROLERELATE_FK2 (ROLE_CODE) REFERENCES COMTNROLEINFO(ROLE_CODE) ON DELETE CASCADE ) ; CREATE UNIQUE INDEX COMTNAUTHORROLERELATE_PK ON COMTNAUTHORROLERELATE ( AUTHOR_CODE, ROLE_CODE ) ; CREATE INDEX COMTNAUTHORROLERELATE_i01 ON COMTNAUTHORROLERELATE ( AUTHOR_CODE ) ; CREATE INDEX COMTNAUTHORROLERELATE_i02 ON COMTNAUTHORROLERELATE ( ROLE_CODE ) ; CREATE TABLE COMTNLOGINLOG ( LOG_ID CHAR(20) NOT NULL, CONECT_ID VARCHAR(20) NULL, CONECT_IP VARCHAR(23) NULL, CONECT_MTHD CHAR(4) NULL, ERROR_OCCRRNC_AT CHAR(1) NULL, ERROR_CODE CHAR(3) NULL, CREAT_DT DATETIME NULL, PRIMARY KEY (LOG_ID) ) ; CREATE UNIQUE INDEX COMTNLOGINLOG_PK ON COMTNLOGINLOG ( LOG_ID ) ; CREATE TABLE COMTNWEBLOG ( REQUST_ID VARCHAR(20) NOT NULL, OCCRRNC_DE DATETIME NULL, URL VARCHAR(200) NULL, RQESTER_ID VARCHAR(20) NULL, RQESTER_IP VARCHAR(23) NULL, PRIMARY KEY (REQUST_ID) ) ; CREATE UNIQUE INDEX COMTNWEBLOG_PK ON COMTNWEBLOG ( REQUST_ID ) ; CREATE TABLE COMTNEVENTINFO ( EVENT_ID CHAR(20) NOT NULL, BSNS_YEAR CHAR(4) NULL, BSNS_CODE VARCHAR(2) NULL, EVENT_CN VARCHAR(1000) NULL, EVENT_SVC_BGNDE CHAR(20) NULL, SVC_USE_NMPR_CO NUMERIC(10) NULL, CHARGER_NM VARCHAR(50) NULL, PRPARETG_CN VARCHAR(2500) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, EVENT_SVC_ENDDE CHAR(20) NULL, EVENT_TY_CODE CHAR(1) NULL, EVENT_CONFM_AT CHAR(1) NULL, EVENT_CONFM_DE CHAR(20) NULL, PRIMARY KEY (EVENT_ID) ) ; CREATE UNIQUE INDEX COMTNEVENTINFO_PK ON COMTNEVENTINFO ( EVENT_ID ) ; CREATE TABLE COMTNEXTRLHRINFO ( EVENT_ID CHAR(20) NOT NULL, EXTRL_HR_ID CHAR(20) NOT NULL, SEXDSTN_CODE CHAR(1) NULL, EXTRL_HR_NM VARCHAR(60) NULL, OCCP_TY_CODE CHAR(1) NULL, PSITN_INSTT_NM VARCHAR(100) NULL, BRTHDY CHAR(20) NULL, AREA_NO VARCHAR(4) NULL, MIDDLE_TELNO VARCHAR(4) NULL, END_TELNO VARCHAR(4) NULL, EMAIL_ADRES VARCHAR(50) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (EVENT_ID,EXTRL_HR_ID), FOREIGN KEY COMTNEXTRLHRINFO_FK1 (EVENT_ID) REFERENCES COMTNEVENTINFO(EVENT_ID) ) ; CREATE UNIQUE INDEX COMTNEXTRLHRINFO_PK ON COMTNEXTRLHRINFO ( EVENT_ID, EXTRL_HR_ID ) ; CREATE INDEX COMTNEXTRLHRINFO_i01 ON COMTNEXTRLHRINFO ( EVENT_ID ) ; CREATE TABLE COMTNBBSUSE ( BBS_ID CHAR(20) NOT NULL, TRGET_ID CHAR(20) NOT NULL, USE_AT CHAR(1) NOT NULL, REGIST_SE_CODE CHAR(6) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (BBS_ID,TRGET_ID), FOREIGN KEY COMTNBBSUSE_FK1 (BBS_ID) REFERENCES COMTNBBSMASTER(BBS_ID) ) ; CREATE UNIQUE INDEX COMTNBBSUSE_PK ON COMTNBBSUSE ( BBS_ID, TRGET_ID ) ; CREATE INDEX COMTNBBSUSE_i01 ON COMTNBBSUSE ( BBS_ID ) ; CREATE TABLE COMTNSTPLATINFO ( USE_STPLAT_ID CHAR(20) NOT NULL, USE_STPLAT_NM VARCHAR(100) NULL, USE_STPLAT_CN MEDIUMTEXT NULL, INFO_PROVD_AGRE_CN MEDIUMTEXT NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (USE_STPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNSTPLATINFO_PK ON COMTNSTPLATINFO ( USE_STPLAT_ID ) ; CREATE TABLE COMTNQUSTNRQESITM ( QESTNR_ID CHAR(20) NOT NULL, QUSTNR_QESITM_ID CHAR(20) NOT NULL, QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, QESTN_SN NUMERIC(10) NULL, QESTN_TY_CODE CHAR(1) NULL, QESTN_CN VARCHAR(2500) NULL, MXMM_CHOISE_CO NUMERIC(5) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NOT NULL, PRIMARY KEY (QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID), FOREIGN KEY COMTNQUSTNRQESITM_FK1 (QUSTNR_TMPLAT_ID,QESTNR_ID) REFERENCES COMTNQESTNRINFO(QUSTNR_TMPLAT_ID,QESTNR_ID) ) ; CREATE UNIQUE INDEX COMTNQUSTNRQESITM_PK ON COMTNQUSTNRQESITM ( QESTNR_ID, QUSTNR_QESITM_ID, QUSTNR_TMPLAT_ID ) ; CREATE INDEX COMTNQUSTNRQESITM_i02 ON COMTNQUSTNRQESITM ( QESTNR_ID, QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTNQUSTNRRSPNSRESULT ( QUSTNR_RSPNS_RESULT_ID CHAR(20) NOT NULL, QESTNR_ID CHAR(20) NOT NULL, QUSTNR_QESITM_ID CHAR(20) NOT NULL, QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, RESPOND_ANSWER_CN VARCHAR(1000) NULL, ETC_ANSWER_CN VARCHAR(1000) NULL, RESPOND_NM VARCHAR(50) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, QUSTNR_IEM_ID VARCHAR(20) NULL, PRIMARY KEY (QUSTNR_RSPNS_RESULT_ID,QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID), FOREIGN KEY COMTNQUSTNRRSPNSRESULT_FK1 (QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID) REFERENCES COMTNQUSTNRQESITM(QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNQUSTNRRSPNSRESULT_PK ON COMTNQUSTNRRSPNSRESULT ( QUSTNR_RSPNS_RESULT_ID, QESTNR_ID, QUSTNR_QESITM_ID, QUSTNR_TMPLAT_ID ) ; CREATE INDEX COMTNQUSTNRRSPNSRESULT_i01 ON COMTNQUSTNRRSPNSRESULT ( QESTNR_ID, QUSTNR_QESITM_ID, QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTNADBKMANAGE ( ADBK_ID CHAR(20) NOT NULL, ADBK_NM VARCHAR(50) NOT NULL, OTHBC_SCOPE VARCHAR(20) NOT NULL, USE_AT CHAR(1) NOT NULL, WRTER_ID VARCHAR(20) NULL, TRGET_ORGNZT_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (ADBK_ID) ) ; CREATE UNIQUE INDEX COMTNADBKMANAGE_PK ON COMTNADBKMANAGE ( ADBK_ID ) ; CREATE TABLE COMTNADBK ( EMPLYR_ID VARCHAR(20) NULL, NCRD_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, ADBK_CONSTNT_ID CHAR(20) NOT NULL, NM VARCHAR(50) NULL, EMAIL_ADRES VARCHAR(50) NULL, MBTLNUM VARCHAR(20) NULL, FXNUM VARCHAR(20) NULL, OFFM_TELNO VARCHAR(20) NULL, HOUSE_TELNO VARCHAR(20) NULL, ADBK_ID CHAR(20) NOT NULL, PRIMARY KEY (ADBK_CONSTNT_ID,ADBK_ID), FOREIGN KEY COMTNADBK_FK1 (ADBK_ID) REFERENCES COMTNADBKMANAGE(ADBK_ID) ON DELETE CASCADE ) ; CREATE UNIQUE INDEX COMTNADBK_PK ON COMTNADBK ( ADBK_CONSTNT_ID, ADBK_ID ) ; CREATE INDEX COMTNADBK_i01 ON COMTNADBK ( ADBK_ID ) ; CREATE TABLE COMTNQUSTNRIEM ( QUSTNR_TMPLAT_ID CHAR(20) NOT NULL, QESTNR_ID CHAR(20) NOT NULL, QUSTNR_QESITM_ID CHAR(20) NOT NULL, QUSTNR_IEM_ID VARCHAR(20) NOT NULL, IEM_SN NUMERIC(5) NULL, IEM_CN VARCHAR(1000) NULL, ETC_ANSWER_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (QUSTNR_TMPLAT_ID,QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_IEM_ID), FOREIGN KEY COMTNQUSTNRIEM_FK1 (QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID) REFERENCES COMTNQUSTNRQESITM(QESTNR_ID,QUSTNR_QESITM_ID,QUSTNR_TMPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNQUSTNRIEM_PK ON COMTNQUSTNRIEM ( QUSTNR_TMPLAT_ID, QESTNR_ID, QUSTNR_QESITM_ID, QUSTNR_IEM_ID ) ; CREATE INDEX COMTNQUSTNRIEM_i01 ON COMTNQUSTNRIEM ( QUSTNR_QESITM_ID, QESTNR_ID, QUSTNR_TMPLAT_ID ) ; CREATE TABLE COMTNADMINISTRATIONWORD ( ADMINIST_WORD_ID CHAR(20) NOT NULL, ADMINIST_WORD_NM VARCHAR(255) NULL, ADMINIST_WORD_ENG_NM VARCHAR(255) NULL, ADMINIST_WORD_ABRV_NM VARCHAR(255) NULL, THEMA_RELM VARCHAR(255) NULL, WORD_SE VARCHAR(255) NULL, RELATE_STD_WORD VARCHAR(255) NULL, ADMINIST_WORD_DFN VARCHAR(2500) NULL, ADMINIST_WORD_DC VARCHAR(4000) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (ADMINIST_WORD_ID) ) ; CREATE UNIQUE INDEX COMTNADMINISTRATIONWORD_PK ON COMTNADMINISTRATIONWORD ( ADMINIST_WORD_ID ) ; CREATE TABLE COMTNONLINEMANUAL ( ONLINE_MNL_ID CHAR(20) NOT NULL, ONLINE_MNL_SE_CODE CHAR(3) NULL, ONLINE_MNL_DFN MEDIUMTEXT NULL, ONLINE_MNL_DC MEDIUMTEXT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, ONLINE_MNL_NM VARCHAR(255) NULL, PRIMARY KEY (ONLINE_MNL_ID) ) ; CREATE UNIQUE INDEX COMTNONLINEMANUAL_PK ON COMTNONLINEMANUAL ( ONLINE_MNL_ID ) ; CREATE TABLE COMTSUSERSUMMARY ( OCCRRNC_DE CHAR(20) NOT NULL, STATS_SE VARCHAR(10) NOT NULL, DETAIL_STATS_SE VARCHAR(10) NOT NULL, USER_CO NUMERIC(10) NULL, PRIMARY KEY (OCCRRNC_DE,STATS_SE,DETAIL_STATS_SE) ) ; CREATE UNIQUE INDEX COMTSUSERSUMMARY_PK ON COMTSUSERSUMMARY ( OCCRRNC_DE, STATS_SE, DETAIL_STATS_SE ) ; CREATE TABLE COMTNFAQINFO ( FAQ_ID CHAR(20) NOT NULL, QESTN_SJ VARCHAR(255) NULL, QESTN_CN VARCHAR(2500) NULL, ANSWER_CN VARCHAR(2500) NULL, RDCNT NUMERIC(10) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NOT NULL, ATCH_FILE_ID CHAR(20) NULL, QNA_PROCESS_STTUS_CODE CHAR(1) NULL, PRIMARY KEY (FAQ_ID), FOREIGN KEY COMTNFAQINFO_FK1 (ATCH_FILE_ID) REFERENCES COMTNFILE(ATCH_FILE_ID) ) ; CREATE UNIQUE INDEX COMTNFAQINFO_PK ON COMTNFAQINFO ( FAQ_ID ) ; CREATE INDEX COMTNFAQINFO_i01 ON COMTNFAQINFO ( ATCH_FILE_ID ) ; CREATE TABLE COMTNMTGINFO ( MTG_ID CHAR(20) NOT NULL, MTG_NM VARCHAR(255) NULL, MTG_MTR_CN VARCHAR(1000) NULL, MTG_SN NUMERIC(10) NULL, MTG_CO NUMERIC(5) NULL, MTG_DE CHAR(20) NULL, MTG_PLACE VARCHAR(255) NULL, MTG_BEGIN_TM VARCHAR(14) NULL, MTG_END_TM VARCHAR(14) NULL, CLSDR_MTG_AT CHAR(1) NULL, READNG_BGNDE CHAR(20) NULL, READNG_AT CHAR(1) NULL, MTG_RESULT_CN VARCHAR(1000) NULL, MTG_RESULT_ENNC CHAR(1) NULL, ETC_MATTER VARCHAR(1000) NULL, MNGT_DEPT_ID VARCHAR(20) NULL, MNAER_ID VARCHAR(20) NULL, MNAER_DEPT_ID VARCHAR(20) NULL, MTG_AT CHAR(1) NULL, NONATDRN_CO NUMERIC(10) NULL, ATDRN_CO NUMERIC(10) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (MTG_ID) ) ; CREATE UNIQUE INDEX COMTNMTGINFO_PK ON COMTNMTGINFO ( MTG_ID ) ; CREATE TABLE COMTNREPRTSTATS ( REPRT_ID CHAR(6) NOT NULL, REPRT_NM VARCHAR(20) NOT NULL, REPRT_STTUS CHAR(2) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, REPRT_TY CHAR(2) NULL, PRIMARY KEY (REPRT_ID) ) ; CREATE UNIQUE INDEX COMTNREPRTSTATS_PK ON COMTNREPRTSTATS ( REPRT_ID ) ; CREATE TABLE COMTNSMS ( SMS_ID CHAR(20) NOT NULL, TRNSMIS_TELNO VARCHAR(12) NOT NULL, TRNSMIS_CN VARCHAR(80) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, PRIMARY KEY (SMS_ID) ) ; CREATE UNIQUE INDEX COMTNSMS_PK ON COMTNSMS ( SMS_ID ) ; CREATE TABLE COMTNSMSRECPTN ( SMS_ID CHAR(20) NOT NULL, RECPTN_TELNO VARCHAR(12) NOT NULL, RESULT_CODE VARCHAR(4) NULL, RESULT_MSSAGE VARCHAR(4000) NULL, PRIMARY KEY (SMS_ID,RECPTN_TELNO), FOREIGN KEY COMTNSMSRECPTN_FK1 (SMS_ID) REFERENCES COMTNSMS(SMS_ID) ) ; CREATE UNIQUE INDEX COMTNSMSRECPTN_PK ON COMTNSMSRECPTN ( SMS_ID, RECPTN_TELNO ) ; CREATE INDEX COMTNSMSRECPTN_i01 ON COMTNSMSRECPTN ( SMS_ID ) ; CREATE TABLE COMTNCPYRHTINFO ( CPYRHT_ID CHAR(20) NOT NULL, CPYRHT_PRTC_POLICY_CN VARCHAR(2500) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (CPYRHT_ID) ) ; CREATE UNIQUE INDEX COMTNCPYRHTINFO_PK ON COMTNCPYRHTINFO ( CPYRHT_ID ) ; CREATE TABLE COMTNSCHDULINFO ( SCHDUL_ID CHAR(20) NOT NULL, SCHDUL_SE CHAR(1) NULL, SCHDUL_DEPT_ID VARCHAR(20) NULL, SCHDUL_KND_CODE CHAR(1) NULL, SCHDUL_BGNDE CHAR(20) NULL, SCHDUL_ENDDE CHAR(20) NULL, SCHDUL_NM VARCHAR(255) NULL, SCHDUL_CN VARCHAR(2500) NULL, SCHDUL_PLACE VARCHAR(255) NULL, SCHDUL_IPCR_CODE CHAR(1) NULL, SCHDUL_CHARGER_ID VARCHAR(20) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, REPTIT_SE_CODE CHAR(1) NULL, PRIMARY KEY (SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNSCHDULINFO_PK ON COMTNSCHDULINFO ( SCHDUL_ID ) ; CREATE TABLE COMTNDIARYINFO ( SCHDUL_ID CHAR(20) NOT NULL, DIARY_ID CHAR(20) NOT NULL, DIARY_PROGRSRT NUMERIC(3) NULL, DIARY_NM VARCHAR(255) NULL, DRCT_MATTER VARCHAR(2500) NULL, PARTCLR_MATTER VARCHAR(2500) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (SCHDUL_ID,DIARY_ID), FOREIGN KEY COMTNDIARYINFO_FK1 (SCHDUL_ID) REFERENCES COMTNSCHDULINFO(SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNDIARYINFO_PK ON COMTNDIARYINFO ( SCHDUL_ID, DIARY_ID ) ; CREATE INDEX COMTNDIARYINFO_i01 ON COMTNDIARYINFO ( SCHDUL_ID ) ; CREATE TABLE COMTNONLINEPOLLMANAGE ( POLL_ID CHAR(20) NOT NULL, POLL_NM VARCHAR(255) NULL, POLL_BGNDE CHAR(10) NULL, POLL_ENDDE CHAR(10) NULL, POLL_KND CHAR(3) NULL, POLL_DSUSE_ENNC CHAR(1) NULL, POLL_ATMC_DSUSE_ENNC CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (POLL_ID) ) ; CREATE UNIQUE INDEX COMTNONLINEPOLLMANAGE_PK ON COMTNONLINEPOLLMANAGE ( POLL_ID ) ; CREATE TABLE COMTNONLINEPOLLIEM ( POLL_IEM_NM VARCHAR(255) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, POLL_IEM_ID CHAR(20) NOT NULL, POLL_ID CHAR(20) NOT NULL, PRIMARY KEY (POLL_ID,POLL_IEM_ID), FOREIGN KEY COMTNONLINEPOLLIEM_FK1 (POLL_ID) REFERENCES COMTNONLINEPOLLMANAGE(POLL_ID) ) ; CREATE UNIQUE INDEX COMTNONLINEPOLLIEM_PK ON COMTNONLINEPOLLIEM ( POLL_ID, POLL_IEM_ID ) ; CREATE INDEX COMTNONLINEPOLLIEM_i01 ON COMTNONLINEPOLLIEM ( POLL_ID ) ; CREATE TABLE COMTNONLINEPOLLRESULT ( POLL_RESULT_ID CHAR(20) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, POLL_IEM_ID CHAR(20) NOT NULL, POLL_ID CHAR(20) NOT NULL, PRIMARY KEY (POLL_RESULT_ID,POLL_IEM_ID,POLL_ID), FOREIGN KEY COMTNONLINEPOLLRESULT_FK1 (POLL_ID,POLL_IEM_ID) REFERENCES COMTNONLINEPOLLIEM(POLL_ID,POLL_IEM_ID) ) ; CREATE UNIQUE INDEX COMTNONLINEPOLLRESULT_PK ON COMTNONLINEPOLLRESULT ( POLL_RESULT_ID, POLL_IEM_ID, POLL_ID ) ; CREATE INDEX COMTNONLINEPOLLRESULT_i01 ON COMTNONLINEPOLLRESULT ( POLL_IEM_ID, POLL_ID ) ; CREATE TABLE COMTNWORDDICARYINFO ( WORD_ID CHAR(20) NOT NULL, WORD_NM VARCHAR(255) NULL, ENG_NM VARCHAR(60) NULL, WORD_DC VARCHAR(4000) NULL, SYNONM VARCHAR(100) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (WORD_ID) ) ; CREATE UNIQUE INDEX COMTNWORDDICARYINFO_PK ON COMTNWORDDICARYINFO ( WORD_ID ) ; CREATE TABLE COMTNCNTCSERVICE ( INSTT_ID VARCHAR(20) NOT NULL, SYS_ID VARCHAR(20) NOT NULL, SVC_ID VARCHAR(20) NOT NULL, SVC_NM VARCHAR(255) NULL, REQUST_MSSAGE_ID VARCHAR(20) NULL, RSPNS_MSSAGE_ID VARCHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, USE_AT CHAR(1) NULL, PRIMARY KEY (INSTT_ID,SYS_ID,SVC_ID) ) ; CREATE UNIQUE INDEX COMTNCNTCSERVICE_PK ON COMTNCNTCSERVICE ( INSTT_ID, SYS_ID, SVC_ID ) ; CREATE TABLE COMTNHPCMINFO ( HPCM_ID CHAR(20) NOT NULL, HPCM_SE_CODE CHAR(1) NULL, HPCM_DFN VARCHAR(1000) NULL, HPCM_DC VARCHAR(2500) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (HPCM_ID) ) ; CREATE UNIQUE INDEX COMTNHPCMINFO_PK ON COMTNHPCMINFO ( HPCM_ID ) ; CREATE TABLE COMTNNEWSINFO ( NEWS_ID CHAR(20) NOT NULL, NEWS_SJ VARCHAR(100) NULL, NEWS_CN VARCHAR(2500) NULL, NEWS_ORIGIN VARCHAR(250) NULL, NTCE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NOT NULL, NTCE_DE CHAR(20) NULL, ATCH_FILE_ID CHAR(20) NULL, PRIMARY KEY (NEWS_ID), FOREIGN KEY COMTNNEWSINFO_FK1 (ATCH_FILE_ID) REFERENCES COMTNFILE(ATCH_FILE_ID) ON DELETE SET NULL ) ; CREATE UNIQUE INDEX COMTNNEWSINFO_PK ON COMTNNEWSINFO ( NEWS_ID ) ; CREATE INDEX COMTNNEWSINFO_i01 ON COMTNNEWSINFO ( ATCH_FILE_ID ) ; CREATE TABLE COMTNCNSLTLIST ( CNSLT_ID CHAR(20) NOT NULL, CNSLT_SJ VARCHAR(255) NULL, OTHBC_AT CHAR(1) NULL, EMAIL_ADRES VARCHAR(50) NULL, CNSLT_CN VARCHAR(2500) NULL, MANAGT_CN VARCHAR(2500) NULL, MANAGT_DE CHAR(20) NULL, RDCNT NUMERIC(10) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, AREA_NO VARCHAR(4) NULL, MIDDLE_TELNO VARCHAR(4) NULL, END_TELNO VARCHAR(4) NULL, FRST_MBTLNUM VARCHAR(4) NULL, MIDDLE_MBTLNUM VARCHAR(4) NULL, END_MBTLNUM VARCHAR(4) NULL, WRITNG_DE CHAR(20) NULL, WRTER_NM VARCHAR(20) NULL, EMAIL_ANSWER_AT CHAR(1) NULL, QNA_PROCESS_STTUS_CODE CHAR(1) NULL, WRITNG_PASSWORD VARCHAR(20) NULL, PRIMARY KEY (CNSLT_ID) ) ; CREATE UNIQUE INDEX COMTNCNSLTLIST_PK ON COMTNCNSLTLIST ( CNSLT_ID ) ; CREATE TABLE COMTNMENUINFO ( MENU_NM VARCHAR(60) NOT NULL, PROGRM_FILE_NM VARCHAR(60) NOT NULL, MENU_NO NUMERIC(20) NOT NULL, UPPER_MENU_NO NUMERIC(20) NULL, MENU_ORDR NUMERIC(5) NOT NULL, MENU_DC VARCHAR(250) NULL, RELATE_IMAGE_PATH VARCHAR(100) NULL, RELATE_IMAGE_NM VARCHAR(60) NULL, PRIMARY KEY (MENU_NO), FOREIGN KEY COMTNMENUINFO_FK2 (PROGRM_FILE_NM) REFERENCES COMTNPROGRMLIST(PROGRM_FILE_NM) ON DELETE CASCADE, FOREIGN KEY COMTNMENUINFO_FK1 (UPPER_MENU_NO) REFERENCES COMTNMENUINFO(MENU_NO) ON DELETE CASCADE ) ; CREATE UNIQUE INDEX COMTNMENUINFO_PK ON COMTNMENUINFO ( MENU_NO ) ; CREATE INDEX COMTNMENUINFO_i02 ON COMTNMENUINFO ( UPPER_MENU_NO ) ; CREATE TABLE COMTNSITEMAP ( MAPNG_CREAT_ID VARCHAR(30) NOT NULL, CREATR_ID VARCHAR(20) NOT NULL, MAPNG_FILE_NM VARCHAR(60) NOT NULL, MAPNG_FILE_PATH VARCHAR(100) NOT NULL, PRIMARY KEY (MAPNG_CREAT_ID) ) ; CREATE UNIQUE INDEX COMTNSITEMAP_PK ON COMTNSITEMAP ( MAPNG_CREAT_ID ) ; CREATE TABLE COMTNMENUCREATDTLS ( MENU_NO NUMERIC(20) NOT NULL, AUTHOR_CODE VARCHAR(30) NOT NULL, MAPNG_CREAT_ID VARCHAR(30) NULL, PRIMARY KEY (MENU_NO,AUTHOR_CODE), FOREIGN KEY COMTNMENUCREATDTLS_FK2 (MENU_NO) REFERENCES COMTNMENUINFO(MENU_NO) ON DELETE CASCADE, FOREIGN KEY COMTNMENUCREATDTLS_FK3 (MAPNG_CREAT_ID) REFERENCES COMTNSITEMAP(MAPNG_CREAT_ID) ON DELETE CASCADE, FOREIGN KEY COMTNMENUCREATDTLS_FK1 (AUTHOR_CODE) REFERENCES COMTNAUTHORINFO(AUTHOR_CODE) ) ; CREATE UNIQUE INDEX COMTNMENUCREATDTLS_PK ON COMTNMENUCREATDTLS ( MENU_NO, AUTHOR_CODE ) ; CREATE INDEX COMTNMENUCREATDTLS_i02 ON COMTNMENUCREATDTLS ( MENU_NO ) ; CREATE INDEX COMTNMENUCREATDTLS_i03 ON COMTNMENUCREATDTLS ( MAPNG_CREAT_ID ) ; CREATE INDEX COMTNMENUCREATDTLS_i04 ON COMTNMENUCREATDTLS ( AUTHOR_CODE ) ; CREATE TABLE COMTHEMPLYRINFOCHANGEDTLS ( EMPLYR_ID VARCHAR(20) NOT NULL, CHANGE_DE CHAR(20) NOT NULL, ORGNZT_ID CHAR(20) NULL, GROUP_ID CHAR(20) NULL, EMPL_NO VARCHAR(20) NULL, SEXDSTN_CODE CHAR(1) NULL, BRTHDY CHAR(20) NULL, FXNUM VARCHAR(20) NULL, HOUSE_ADRES VARCHAR(100) NULL, HOUSE_END_TELNO VARCHAR(4) NULL, AREA_NO VARCHAR(4) NULL, DETAIL_ADRES VARCHAR(100) NULL, ZIP VARCHAR(6) NULL, OFFM_TELNO VARCHAR(20) NULL, MBTLNUM VARCHAR(20) NULL, EMAIL_ADRES VARCHAR(50) NULL, HOUSE_MIDDLE_TELNO VARCHAR(4) NULL, PSTINST_CODE CHAR(8) NULL, EMPLYR_STTUS_CODE CHAR(1) NULL, ESNTL_ID CHAR(20) NULL, PRIMARY KEY (EMPLYR_ID,CHANGE_DE), FOREIGN KEY COMTHEMPLYRINFOCHANGEDTLS_FK1 (EMPLYR_ID) REFERENCES COMTNEMPLYRINFO(EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTHEMPLYRINFOCHANGEDTLS_PK ON COMTHEMPLYRINFOCHANGEDTLS ( EMPLYR_ID, CHANGE_DE ) ; CREATE INDEX COMTHEMPLYRINFOCHANGEDTLS_i01 ON COMTHEMPLYRINFOCHANGEDTLS ( EMPLYR_ID ) ; CREATE TABLE COMTNNTFCINFO ( NTCN_NO NUMERIC(20) NOT NULL, NTCN_SJ VARCHAR(60) NOT NULL, NTCN_CN VARCHAR(100) NOT NULL, NTCN_TM VARCHAR(14) NOT NULL, BH_NTCN_INTRVL VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (NTCN_NO) ) ; CREATE UNIQUE INDEX COMTNNTFCINFO_PK ON COMTNNTFCINFO ( NTCN_NO ) ; CREATE TABLE COMTNCNTCSYSTEM ( INSTT_ID VARCHAR(20) NOT NULL, SYS_ID VARCHAR(20) NOT NULL, SYS_NM VARCHAR(255) NULL, SYS_IP VARCHAR(23) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, USE_AT CHAR(1) NULL, PRIMARY KEY (INSTT_ID,SYS_ID) ) ; CREATE UNIQUE INDEX COMTNCNTCSYSTEM_PK ON COMTNCNTCSYSTEM ( INSTT_ID, SYS_ID ) ; CREATE TABLE COMTNBBSMASTEROPTN ( BBS_ID CHAR(20) NOT NULL, ANSWER_AT CHAR(1) NOT NULL, STSFDG_AT CHAR(1) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (BBS_ID) ) ; CREATE UNIQUE INDEX COMTNBBSMASTEROPTN_PK ON COMTNBBSMASTEROPTN ( BBS_ID ) ; CREATE TABLE COMTNANSWER ( NTT_ID NUMERIC(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, WRTER_ID VARCHAR(20) NULL, ANSWER VARCHAR(200) NULL, USE_AT CHAR(1) NOT NULL, WRTER_NM VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, ANSWER_NO NUMERIC(20) NOT NULL, PRIMARY KEY (NTT_ID,BBS_ID,ANSWER_NO), FOREIGN KEY COMTNANSWER_FK1 (BBS_ID) REFERENCES COMTNBBSMASTEROPTN(BBS_ID) ) ; CREATE UNIQUE INDEX COMTNANSWER_PK ON COMTNANSWER ( NTT_ID, BBS_ID, ANSWER_NO ) ; CREATE TABLE COMTNTRSMRCVLOG ( REQUST_ID VARCHAR(20) NOT NULL, OCCRRNC_DE CHAR(20) NULL, TRSMRCV_SE_CODE CHAR(3) NULL, CNTC_ID CHAR(8) NULL, PROVD_INSTT_ID CHAR(8) NULL, PROVD_SYS_ID CHAR(8) NULL, PROVD_SVC_ID CHAR(8) NULL, REQUST_INSTT_ID CHAR(8) NULL, REQUST_SYS_ID CHAR(8) NULL, REQUST_TRNSMIT_TM VARCHAR(14) NULL, REQUST_RECPTN_TM VARCHAR(14) NULL, RSPNS_TRNSMIT_TM VARCHAR(14) NULL, RSPNS_RECPTN_TM VARCHAR(14) NULL, RESULT_CODE VARCHAR(4) NULL, RESULT_MSSAGE VARCHAR(4000) NULL, FRST_REGIST_PNTTM DATETIME NULL, RQESTER_ID VARCHAR(20) NULL, PRIMARY KEY (REQUST_ID) ) ; CREATE UNIQUE INDEX COMTNTRSMRCVLOG_PK ON COMTNTRSMRCVLOG ( REQUST_ID ) ; CREATE TABLE COMTNDAMCALRES ( ORGNZT_ID CHAR(20) NULL, EXPERT_ID CHAR(20) NULL, KNWLDG_TY_CODE VARCHAR(3) NULL, EMPLYR_ID VARCHAR(20) NULL, KNWLDG_NM VARCHAR(60) NULL, KNWLDG_CN VARCHAR(2500) NULL, ATCH_FILE_ID CHAR(20) NULL, PARNTS_KNWLDG_ID CHAR(20) NULL, ANSWER_DP NUMERIC(20) NULL, ANSWER_ORDR NUMERIC(20) NULL, ANSWER_GROUP_NO NUMERIC(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, KNWLDG_ID CHAR(20) NOT NULL, PRIMARY KEY (KNWLDG_ID) ) ; CREATE UNIQUE INDEX COMTNDAMCALRES_PK ON COMTNDAMCALRES ( KNWLDG_ID ) ; CREATE TABLE COMTNBACKUPRESULT ( BACKUP_RESULT_ID VARCHAR(20) NOT NULL, BACKUP_OPERT_ID VARCHAR(20) NOT NULL, BACKUP_FILE VARCHAR(255) NULL, STTUS VARCHAR(2) NULL, ERROR_INFO VARCHAR(2000) NULL, EXECUT_BEGIN_TM VARCHAR(14) NULL, EXECUT_END_TM VARCHAR(14) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (BACKUP_RESULT_ID) ) ; CREATE UNIQUE INDEX COMTNBACKUPRESULT_PK ON COMTNBACKUPRESULT ( BACKUP_RESULT_ID ) ; CREATE TABLE COMTHTRSMRCVMNTRNGLOGINFO ( LOG_ID CHAR(20) NOT NULL, CNTC_ID CHAR(8) NOT NULL, TEST_CLASS_NM VARCHAR(255) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, LOG_INFO VARCHAR(2000) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (LOG_ID) ) ; CREATE UNIQUE INDEX COMTHTRSMRCVMNTRNGLOGINFO_PK ON COMTHTRSMRCVMNTRNGLOGINFO ( LOG_ID ) ; CREATE TABLE COMTNSCRAP ( SCRAP_ID CHAR(20) NOT NULL, NTT_ID NUMERIC(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, SCRAP_NM VARCHAR(100) NOT NULL, USE_AT CHAR(1) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (SCRAP_ID) ) ; CREATE UNIQUE INDEX COMTNSCRAP_PK ON COMTNSCRAP ( SCRAP_ID ) ; CREATE TABLE COMTNCNTCINSTT ( INSTT_ID VARCHAR(20) NOT NULL, INSTT_NM VARCHAR(100) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDT_PNTTM DATETIME NULL, USE_AT CHAR(1) NULL, PRIMARY KEY (INSTT_ID) ) ; CREATE UNIQUE INDEX COMTNCNTCINSTT_PK ON COMTNCNTCINSTT ( INSTT_ID ) ; CREATE TABLE COMTHSYSHIST ( HIST_ID CHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, HIST_SE_CODE CHAR(6) NOT NULL, HIST_CN VARCHAR(2500) NOT NULL, SYS_NM VARCHAR(255) NOT NULL, ATCH_FILE_ID CHAR(20) NULL, PRIMARY KEY (HIST_ID) ) ; CREATE UNIQUE INDEX COMTHSYSHIST_PK ON COMTHSYSHIST ( HIST_ID ) ; CREATE TABLE COMTNHTTPMON ( SYS_ID VARCHAR(20) NOT NULL, SITE_URL VARCHAR(100) NULL, WEBSVC_KND VARCHAR(10) NULL, HTTP_STTUS_CODE VARCHAR(3) NULL, CREAT_DT DATETIME NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SYS_ID) ) ; CREATE UNIQUE INDEX COMTNHTTPMON_PK ON COMTNHTTPMON ( SYS_ID ) ; CREATE TABLE COMTHHTTPMONLOGINFO ( SYS_ID VARCHAR(20) NOT NULL, SITE_URL VARCHAR(100) NULL, WEBSVC_KND VARCHAR(10) NULL, HTTP_STTUS_CODE VARCHAR(3) NULL, CREAT_DT DATETIME NULL, LOG_INFO VARCHAR(2000) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (SYS_ID,LOG_ID), FOREIGN KEY COMTHHTTPMONLOGINFO_FK2 (SYS_ID) REFERENCES COMTNHTTPMON(SYS_ID) ) ; CREATE UNIQUE INDEX COMTHHTTPMONLOGINFO_PK ON COMTHHTTPMONLOGINFO ( SYS_ID, LOG_ID ) ; CREATE TABLE COMTHDBMNTRNGLOGINFO ( DATA_SOURC_NM VARCHAR(60) NOT NULL, SERVER_NM VARCHAR(60) NULL, DBMS_KND VARCHAR(2) NULL, CECK_SQL VARCHAR(250) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, LOG_INFO VARCHAR(2000) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (LOG_ID) ) ; CREATE UNIQUE INDEX COMTHDBMNTRNGLOGINFO_PK ON COMTHDBMNTRNGLOGINFO ( LOG_ID ) ; CREATE TABLE COMTHCONFMHISTORY ( CONFM_NO NUMERIC(8) NOT NULL, CONFM_RQESTER_ID VARCHAR(20) NOT NULL, CONFMER_ID VARCHAR(20) NULL, CONFM_DE CHAR(20) NULL, CONFM_TY_CODE CHAR(4) NOT NULL, CONFM_STTUS_CODE CHAR(4) NOT NULL, OPERT_TY_CODE CHAR(4) NULL, OPERT_ID VARCHAR(20) NULL, TRGET_JOB_TY_CODE CHAR(3) NULL, TRGET_JOB_ID CHAR(20) NULL, PRIMARY KEY (CONFM_NO) ) ; CREATE UNIQUE INDEX COMTHCONFMHISTORY_PK ON COMTHCONFMHISTORY ( CONFM_NO ) ; CREATE TABLE COMTNDAMMAPTEAM ( ORGNZT_ID CHAR(20) NOT NULL, ORGNZT_NM VARCHAR(20) NULL, CL_DE CHAR(20) NULL, KNWLDG_URL VARCHAR(255) NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (ORGNZT_ID) ) ; CREATE UNIQUE INDEX COMTNDAMMAPTEAM_PK ON COMTNDAMMAPTEAM ( ORGNZT_ID ) ; CREATE TABLE COMTNTMPLATINFO ( TMPLAT_ID CHAR(20) NOT NULL, TMPLAT_NM VARCHAR(255) NULL, TMPLAT_COURS VARCHAR(2000) NULL, USE_AT CHAR(1) NULL, TMPLAT_SE_CODE CHAR(6) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (TMPLAT_ID) ) ; CREATE UNIQUE INDEX COMTNTMPLATINFO_PK ON COMTNTMPLATINFO ( TMPLAT_ID ) ; CREATE TABLE COMTNINDVDLPGECNTNTS ( CNTNTS_ID VARCHAR(20) NOT NULL, CNTNTS_NM VARCHAR(100) NOT NULL, CNTC_URL VARCHAR(255) NOT NULL, CNTNTS_USE_AT CHAR(1) NOT NULL, CNTNTS_LINK_URL VARCHAR(1000) NULL, CNTNTS_DC VARCHAR(250) NULL, PRIMARY KEY (CNTNTS_ID) ) ; CREATE UNIQUE INDEX COMTNINDVDLPGECNTNTS_PK ON COMTNINDVDLPGECNTNTS ( CNTNTS_ID ) ; CREATE TABLE COMTNINDVDLPGEESTBS ( EMPLYR_ID VARCHAR(20) NOT NULL, UPEND_IMAGE VARCHAR(1024) NULL, TITLEBAR_COLOR CHAR(7) NULL, ALGN_MTHD CHAR(1) NULL, ALGN_CO NUMERIC(10) NULL, PRIMARY KEY (EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTNINDVDLPGEESTBS_PK ON COMTNINDVDLPGEESTBS ( EMPLYR_ID ) ; CREATE TABLE COMTNCNTNTSLIST ( CNTNTS_ID VARCHAR(20) NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, PRIMARY KEY (CNTNTS_ID,EMPLYR_ID), FOREIGN KEY COMTNCNTNTSLIST_FK1 (CNTNTS_ID) REFERENCES COMTNINDVDLPGECNTNTS(CNTNTS_ID), FOREIGN KEY COMTNCNTNTSLIST_FK2 (EMPLYR_ID) REFERENCES COMTNINDVDLPGEESTBS(EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTNCNTNTSLIST_PK ON COMTNCNTNTSLIST ( CNTNTS_ID, EMPLYR_ID ) ; CREATE INDEX COMTNCNTNTSLIST_i01 ON COMTNCNTNTSLIST ( CNTNTS_ID ) ; CREATE INDEX COMTNCNTNTSLIST_i02 ON COMTNCNTNTSLIST ( EMPLYR_ID ) ; CREATE TABLE COMTNCNTCMESSAGE ( CNTC_MSSAGE_ID VARCHAR(20) NOT NULL, CNTC_MSSAGE_NM VARCHAR(100) NULL, UPPER_CNTC_MSSAGE_ID VARCHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, USE_AT CHAR(1) NULL, PRIMARY KEY (CNTC_MSSAGE_ID) ) ; CREATE UNIQUE INDEX COMTNCNTCMESSAGE_PK ON COMTNCNTCMESSAGE ( CNTC_MSSAGE_ID ) ; CREATE TABLE COMTNCNTCMESSAGEITEM ( CNTC_MSSAGE_ID VARCHAR(20) NOT NULL, IEM_ID VARCHAR(20) NOT NULL, IEM_NM VARCHAR(100) NULL, IEM_TY VARCHAR(50) NULL, IEM_LT NUMERIC(8) NULL, USE_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (CNTC_MSSAGE_ID,IEM_ID), FOREIGN KEY COMTNCNTCMESSAGEITEM_FK1 (CNTC_MSSAGE_ID) REFERENCES COMTNCNTCMESSAGE(CNTC_MSSAGE_ID) ) ; CREATE UNIQUE INDEX COMTNCNTCMESSAGEITEM_PK ON COMTNCNTCMESSAGEITEM ( CNTC_MSSAGE_ID, IEM_ID ) ; CREATE INDEX COMTNCNTCMESSAGEITEM_i01 ON COMTNCNTCMESSAGEITEM ( CNTC_MSSAGE_ID ) ; CREATE TABLE COMTNBKMKMENUMANAGERESULT ( MENU_ID NUMERIC(20) NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, MENU_NM VARCHAR(60) NOT NULL, PROGRM_STRE_PATH VARCHAR(100) NOT NULL, PRIMARY KEY (MENU_ID,EMPLYR_ID) ) ; CREATE UNIQUE INDEX COMTNBKMKMENUMANAGERESULT_PK ON COMTNBKMKMENUMANAGERESULT ( MENU_ID, EMPLYR_ID ) ; CREATE TABLE COMTNSYSTEMCNTC ( CNTC_ID CHAR(8) NOT NULL, CNTC_NM VARCHAR(100) NULL, PROVD_INSTT_ID CHAR(8) NULL, PROVD_SYS_ID CHAR(8) NULL, PROVD_SVC_ID CHAR(8) NULL, REQUST_INSTT_ID CHAR(8) NULL, REQUST_SYS_ID CHAR(8) NULL, CONFM_AT CHAR(1) NULL, USE_AT CHAR(1) NULL, VALID_BGNDE CHAR(20) NULL, VALID_ENDDE CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, CNTC_TY VARCHAR(60) NULL, PRIMARY KEY (CNTC_ID) ) ; CREATE UNIQUE INDEX COMTNSYSTEMCNTC_PK ON COMTNSYSTEMCNTC ( CNTC_ID ) ; CREATE TABLE COMTNINDVDLINFOPOLICY ( INDVDL_INFO_POLICY_ID CHAR(20) NOT NULL, INDVDL_INFO_POLICY_CN VARCHAR(2500) NULL, INDVDL_INFO_POLICY_AGRE_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, INDVDL_INFO_POLICY_NM VARCHAR(255) NULL, PRIMARY KEY (INDVDL_INFO_POLICY_ID) ) ; CREATE UNIQUE INDEX COMTNINDVDLINFOPOLICY_PK ON COMTNINDVDLINFOPOLICY ( INDVDL_INFO_POLICY_ID ) ; CREATE TABLE COMTNBNDTMANAGE ( BNDT_ID VARCHAR(20) NOT NULL, BNDT_DE CHAR(8) NOT NULL, RM VARCHAR(2500) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (BNDT_ID,BNDT_DE) ) ; CREATE UNIQUE INDEX COMTNBNDTMANAGE_PK ON COMTNBNDTMANAGE ( BNDT_ID, BNDT_DE ) ; CREATE TABLE COMTNBNDTCECKMANAGE ( BNDT_CECK_SE CHAR(2) NOT NULL, BNDT_CECK_CODE VARCHAR(10) NOT NULL, BNDT_CECK_CODE_NM VARCHAR(255) NOT NULL, USE_AT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (BNDT_CECK_CODE,BNDT_CECK_SE) ) ; CREATE UNIQUE INDEX COMTNBNDTCECKMANAGE_PK ON COMTNBNDTCECKMANAGE ( BNDT_CECK_CODE, BNDT_CECK_SE ) ; CREATE TABLE COMTNBNDTDIARY ( BNDT_ID VARCHAR(20) NOT NULL, BNDT_DE CHAR(8) NOT NULL, BNDT_CECK_SE CHAR(2) NOT NULL, BNDT_CECK_CODE VARCHAR(10) NOT NULL, CHCK_STTUS VARCHAR(1000) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (BNDT_ID,BNDT_DE,BNDT_CECK_SE,BNDT_CECK_CODE), FOREIGN KEY COMTNBNDTDIARY_FK2 (BNDT_ID,BNDT_DE) REFERENCES COMTNBNDTMANAGE(BNDT_ID,BNDT_DE), FOREIGN KEY COMTNBNDTDIARY_FK1 (BNDT_CECK_CODE,BNDT_CECK_SE) REFERENCES COMTNBNDTCECKMANAGE(BNDT_CECK_CODE,BNDT_CECK_SE) ) ; CREATE UNIQUE INDEX COMTNBNDTDIARY_PK ON COMTNBNDTDIARY ( BNDT_ID, BNDT_DE, BNDT_CECK_SE, BNDT_CECK_CODE ) ; CREATE TABLE COMTNBATCHRESULT ( BATCH_RESULT_ID VARCHAR(20) NOT NULL, BATCH_SCHDUL_ID VARCHAR(20) NOT NULL, BATCH_OPERT_ID VARCHAR(20) NOT NULL, PARAMTR VARCHAR(250) NULL, STTUS VARCHAR(2) NULL, ERROR_INFO VARCHAR(2000) NULL, EXECUT_BEGIN_TM VARCHAR(14) NULL, EXECUT_END_TM VARCHAR(14) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, PRIMARY KEY (BATCH_RESULT_ID) ) ; CREATE UNIQUE INDEX COMTNBATCHRESULT_PK ON COMTNBATCHRESULT ( BATCH_RESULT_ID ) ; CREATE TABLE COMTNSTSFDG ( STSFDG_NO NUMERIC(20) NOT NULL, NTT_ID NUMERIC(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, WRTER_ID VARCHAR(20) NULL, WRTER_NM VARCHAR(20) NULL, PASSWORD VARCHAR(200) NULL, STSFDG NUMERIC(1) NOT NULL, STSFDG_CN VARCHAR(200) NULL, USE_AT CHAR(1) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (STSFDG_NO) ) ; CREATE UNIQUE INDEX COMTNSTSFDG_PK ON COMTNSTSFDG ( STSFDG_NO ) ; CREATE TABLE COMTNBATCHOPERT ( BATCH_OPERT_ID VARCHAR(20) NOT NULL, BATCH_OPERT_NM VARCHAR(60) NULL, BATCH_PROGRM VARCHAR(255) NULL, PARAMTR VARCHAR(250) NULL, USE_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (BATCH_OPERT_ID) ) ; CREATE UNIQUE INDEX COMTNBATCHOPERT_PK ON COMTNBATCHOPERT ( BATCH_OPERT_ID ) ; CREATE TABLE COMTNFILESYSMNTRNG ( FILE_SYS_ID CHAR(20) NOT NULL, FILE_SYS_NM VARCHAR(60) NOT NULL, FILE_SYS_MANAGE_NM VARCHAR(255) NOT NULL, FILE_SYS_SIZE NUMERIC(8) NOT NULL, FILE_SYS_THRHLD NUMERIC(8) NOT NULL, FILE_SYS_USGQTY NUMERIC(8) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (FILE_SYS_ID) ) ; CREATE UNIQUE INDEX COMTNFILESYSMNTRNG_PK ON COMTNFILESYSMNTRNG ( FILE_SYS_ID ) ; CREATE TABLE COMTNFILESYSMNTRNGLOGINFO ( FILE_SYS_ID CHAR(20) NOT NULL, FILE_SYS_NM VARCHAR(60) NOT NULL, FILE_SYS_MANAGE_NM VARCHAR(255) NOT NULL, FILE_SYS_SIZE NUMERIC(8) NOT NULL, FILE_SYS_THRHLD NUMERIC(8) NOT NULL, FILE_SYS_USGQTY NUMERIC(8) NULL, MNTRNG_STTUS CHAR(2) NULL, LOG_INFO VARCHAR(2000) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (FILE_SYS_ID,LOG_ID), FOREIGN KEY COMTNFILESYSMNTRNGLOGINFO_FK2 (FILE_SYS_ID) REFERENCES COMTNFILESYSMNTRNG(FILE_SYS_ID) ) ; CREATE UNIQUE INDEX COMTNFILESYSMNTRNGLOGINFO_PK ON COMTNFILESYSMNTRNGLOGINFO ( FILE_SYS_ID, LOG_ID ) ; CREATE TABLE COMTNBATCHSCHDUL ( BATCH_SCHDUL_ID VARCHAR(20) NOT NULL, BATCH_OPERT_ID VARCHAR(20) NOT NULL, EXECUT_CYCLE VARCHAR(2) NULL, EXECUT_SCHDUL_DE CHAR(20) NULL, EXECUT_SCHDUL_HOUR CHAR(2) NULL, EXECUT_SCHDUL_MNT CHAR(2) NULL, EXECUT_SCHDUL_SECND CHAR(2) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (BATCH_SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNBATCHSCHDUL_PK ON COMTNBATCHSCHDUL ( BATCH_SCHDUL_ID ) ; CREATE TABLE COMTNBATCHSCHDULDFK ( BATCH_SCHDUL_ID VARCHAR(20) NOT NULL, EXECUT_SCHDUL_DFK_SE CHAR(1) NOT NULL, PRIMARY KEY (BATCH_SCHDUL_ID,EXECUT_SCHDUL_DFK_SE), FOREIGN KEY COMTNBATCHSCHDULDFK_FK1 (BATCH_SCHDUL_ID) REFERENCES COMTNBATCHSCHDUL(BATCH_SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNBATCHSCHDULDFK_PK ON COMTNBATCHSCHDULDFK ( BATCH_SCHDUL_ID, EXECUT_SCHDUL_DFK_SE ) ; CREATE TABLE COMTNCTSNNMANAGE ( CTSNN_ID VARCHAR(20) NOT NULL, USER_ID VARCHAR(20) NOT NULL, CTSNN_CODE CHAR(2) NOT NULL, REQST_DE CHAR(20) NOT NULL, CTSNN_NM VARCHAR(255) NOT NULL, TRGTER_NM VARCHAR(20) NOT NULL, BRTHDY CHAR(20) NOT NULL, OCCRRNC_DE CHAR(20) NOT NULL, RELATE CHAR(2) NOT NULL, RM VARCHAR(2500) NULL, SANCTNER_ID VARCHAR(20) NOT NULL, CONFM_AT CHAR(1) NULL, SANCTN_DT DATETIME NULL, RETURN_RESN VARCHAR(1000) NULL, INFRML_SANCTN_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (CTSNN_ID) ) ; CREATE UNIQUE INDEX COMTNCTSNNMANAGE_PK ON COMTNCTSNNMANAGE ( CTSNN_ID ) ; CREATE TABLE COMTCADMINISTCODERECPTNLOG ( OCCRRNC_DE CHAR(20) NOT NULL, ADMINIST_ZONE_SE CHAR(1) NOT NULL, ADMINIST_ZONE_CODE VARCHAR(10) NOT NULL, OPERT_SN NUMERIC(10) NOT NULL, CHANGE_SE_CODE VARCHAR(2) NULL, PROCESS_SE VARCHAR(2) NULL, ADMINIST_ZONE_NM VARCHAR(60) NULL, LOWEST_ADMINIST_ZONE_NM VARCHAR(60) NULL, CTPRVN_CODE VARCHAR(2) NULL, SIGNGU_CODE VARCHAR(3) NULL, EMD_CODE VARCHAR(3) NULL, LI_CODE VARCHAR(2) NULL, CREAT_DE CHAR(20) NULL, ABL_DE CHAR(20) NULL, ABL_ENNC CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (OCCRRNC_DE,ADMINIST_ZONE_SE,ADMINIST_ZONE_CODE,OPERT_SN) ) ; CREATE UNIQUE INDEX COMTCADMINISTCODERECPTNLOG_PK ON COMTCADMINISTCODERECPTNLOG ( OCCRRNC_DE, ADMINIST_ZONE_SE, ADMINIST_ZONE_CODE, OPERT_SN ) ; CREATE TABLE COMTNTROBLINFO ( TROBL_ID CHAR(20) NOT NULL, TROBL_NM VARCHAR(60) NULL, TROBL_KND CHAR(2) NULL, TROBL_DC VARCHAR(2000) NULL, TROBL_OCCRRNC_TIME VARCHAR(14) NULL, TROBL_RQESTER_NM VARCHAR(60) NULL, TROBL_REQUST_TIME VARCHAR(14) NULL, TROBL_PROCESS_RESULT VARCHAR(2000) NULL, TROBL_OPETR_NM VARCHAR(60) NULL, TROBL_PROCESS_TIME VARCHAR(14) NULL, PROCESS_STTUS CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (TROBL_ID) ) ; CREATE UNIQUE INDEX COMTNTROBLINFO_PK ON COMTNTROBLINFO ( TROBL_ID ) ; CREATE TABLE COMTNDAMKNOIFM ( KNWLDG_ID CHAR(20) NOT NULL, KNWLDG_TY_CODE VARCHAR(3) NULL, ORGNZT_ID CHAR(20) NULL, EXPERT_ID CHAR(20) NULL, EMPLYR_ID VARCHAR(20) NULL, KNWLDG_NM VARCHAR(60) NULL, KNWLDG_CN VARCHAR(2500) NULL, KWRD VARCHAR(100) NULL, OTHBC_AT CHAR(1) NULL, KNWLDG_EVL CHAR(1) NULL, COLCT_DE CHAR(20) NULL, EVL_DE CHAR(20) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, DSUSE_DE CHAR(20) NULL, PRIMARY KEY (KNWLDG_ID) ) ; CREATE UNIQUE INDEX COMTNDAMKNOIFM_PK ON COMTNDAMKNOIFM ( KNWLDG_ID ) ; CREATE TABLE COMTNDAMMAPKNO ( KNWLDG_TY_CODE VARCHAR(3) NOT NULL, ORGNZT_ID CHAR(20) NULL, EXPERT_ID CHAR(20) NULL, KNWLDG_TY_NM VARCHAR(60) NULL, CL_DE CHAR(20) NULL, KNWLDG_URL VARCHAR(255) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (KNWLDG_TY_CODE) ) ; CREATE UNIQUE INDEX COMTNDAMMAPKNO_PK ON COMTNDAMMAPKNO ( KNWLDG_TY_CODE ) ; CREATE TABLE COMTNDAMPRO ( EXPERT_ID CHAR(20) NOT NULL, KNWLDG_TY_CODE VARCHAR(3) NOT NULL, EXPERT_GRAD CHAR(1) NOT NULL, EXPERT_CONFM_DE CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, EXPERT_DC VARCHAR(2000) NULL, PRIMARY KEY (EXPERT_ID,KNWLDG_TY_CODE,EXPERT_GRAD), FOREIGN KEY COMTNDAMPRO_FK1 (KNWLDG_TY_CODE) REFERENCES COMTNDAMMAPKNO(KNWLDG_TY_CODE) ) ; CREATE UNIQUE INDEX COMTNDAMPRO_PK ON COMTNDAMPRO ( EXPERT_ID, KNWLDG_TY_CODE, EXPERT_GRAD ) ; CREATE TABLE COMTNINFRMLSANCTN ( INFRML_SANCTN_ID CHAR(20) NOT NULL, JOB_SE_CODE CHAR(3) NOT NULL, APPLCNT_ID VARCHAR(20) NOT NULL, REQST_DE CHAR(20) NOT NULL, SANCTNER_ID VARCHAR(20) NOT NULL, CONFM_AT CHAR(1) NOT NULL, SANCTN_DT DATETIME NULL, RETURN_RESN VARCHAR(1000) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (INFRML_SANCTN_ID) ) ; CREATE UNIQUE INDEX COMTNINFRMLSANCTN_PK ON COMTNINFRMLSANCTN ( INFRML_SANCTN_ID ) ; CREATE TABLE COMTNDBMNTRNG ( DATA_SOURC_NM VARCHAR(60) NOT NULL, SERVER_NM VARCHAR(60) NULL, DBMS_KND VARCHAR(2) NULL, CECK_SQL VARCHAR(250) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (DATA_SOURC_NM) ) ; CREATE UNIQUE INDEX COMTNDBMNTRNG_PK ON COMTNDBMNTRNG ( DATA_SOURC_NM ) ; CREATE TABLE COMTNTRSMRCVMNTRNG ( CNTC_ID CHAR(8) NOT NULL, TEST_CLASS_NM VARCHAR(255) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (CNTC_ID) ) ; CREATE UNIQUE INDEX COMTNTRSMRCVMNTRNG_PK ON COMTNTRSMRCVMNTRNG ( CNTC_ID ) ; CREATE TABLE COMTNDEPTJOB ( DEPT_JOB_ID CHAR(20) NOT NULL, DEPT_JOBBX_ID CHAR(6) NOT NULL, DEPT_JOB_NM VARCHAR(255) NOT NULL, DEPT_JOB_CN VARCHAR(2500) NOT NULL, ATCH_FILE_ID CHAR(20) NULL, CHARGER_ID VARCHAR(20) NOT NULL, PRIORT CHAR(1) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (DEPT_JOB_ID) ) ; CREATE UNIQUE INDEX COMTNDEPTJOB_PK ON COMTNDEPTJOB ( DEPT_JOB_ID ) ; CREATE TABLE COMTNLEADERSCHDUL ( SCHDUL_ID CHAR(20) NOT NULL, SCHDUL_SE CHAR(1) NULL, SCHDUL_NM VARCHAR(255) NOT NULL, SCHDUL_CN VARCHAR(2500) NOT NULL, SCHDUL_PLACE VARCHAR(255) NULL, LEADER_ID VARCHAR(20) NOT NULL, REPTIT_SE_CODE CHAR(1) NULL, SCHDUL_BGNDE CHAR(20) NULL, SCHDUL_ENDDE CHAR(20) NULL, SCHDUL_CHARGER_ID VARCHAR(20) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNLEADERSCHDUL_PK ON COMTNLEADERSCHDUL ( SCHDUL_ID ) ; CREATE TABLE COMTNLEADERSCHDULDE ( SCHDUL_ID CHAR(20) NOT NULL, SCHDUL_DE CHAR(8) NOT NULL, PRIMARY KEY (SCHDUL_ID,SCHDUL_DE), FOREIGN KEY COMTNLEADERSCHDULDE_FK1 (SCHDUL_ID) REFERENCES COMTNLEADERSCHDUL(SCHDUL_ID) ) ; CREATE UNIQUE INDEX COMTNLEADERSCHDULDE_PK ON COMTNLEADERSCHDULDE ( SCHDUL_ID, SCHDUL_DE ) ; CREATE TABLE COMTNLEADERSTTUS ( LEADER_ID VARCHAR(20) NOT NULL , LEADER_STTUS CHAR(1) NOT NULL , FRST_REGIST_PNTTM DATETIME NULL , FRST_REGISTER_ID VARCHAR(20) NULL , LAST_UPDT_PNTTM DATETIME NULL , LAST_UPDUSR_ID VARCHAR(20) NULL , PRIMARY KEY (LEADER_ID) ); CREATE TABLE COMTNDEPTJOBBX ( DEPT_JOBBX_ID CHAR(6) NOT NULL, DEPT_JOBBX_NM VARCHAR(255) NOT NULL, DEPT_ID VARCHAR(20) NOT NULL, INDICT_ORDR NUMERIC(6) NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (DEPT_JOBBX_ID) ) ; CREATE UNIQUE INDEX COMTNDEPTJOBBX_PK ON COMTNDEPTJOBBX ( DEPT_JOBBX_ID ) ; CREATE TABLE COMTNDTAUSESTATS ( DTA_USE_STATS_ID CHAR(20) NOT NULL, BBS_ID CHAR(20) NOT NULL, NTT_ID NUMERIC(20) NOT NULL, ATCH_FILE_ID CHAR(20) NOT NULL, FILE_SN NUMERIC(10) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (DTA_USE_STATS_ID) ) ; CREATE UNIQUE INDEX COMTNDTAUSESTATS_PK ON COMTNDTAUSESTATS ( DTA_USE_STATS_ID ) ; CREATE TABLE COMTNINSTTCODE ( INSTT_CODE CHAR(7) NOT NULL, ALL_INSTT_NM VARCHAR(255) NULL, LOWEST_INSTT_NM VARCHAR(100) NULL, INSTT_ABRV_NM VARCHAR(50) NULL, ODR CHAR(1) NULL, ORD CHAR(3) NULL, INSTT_ODR CHAR(2) NULL, UPPER_INSTT_CODE CHAR(7) NULL, BEST_INSTT_CODE CHAR(7) NULL, REPRSNT_INSTT_CODE CHAR(7) NULL, INSTT_TY_LCLAS CHAR(2) NULL, INSTT_TY_MLSFC CHAR(2) NULL, INSTT_TY_SCLAS CHAR(2) NULL, TELNO VARCHAR(20) NULL, FXNUM VARCHAR(20) NULL, CREAT_DE CHAR(20) NULL, ABL_DE CHAR(20) NULL, ABL_ENNC CHAR(1) NULL, CHANGE_DE CHAR(20) NULL, CHANGE_TIME VARCHAR(6) NULL, BSIS_DE CHAR(20) NULL, SORT_ORDR NUMERIC(8) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (INSTT_CODE) ) ; CREATE UNIQUE INDEX COMTNINSTTCODE_PK ON COMTNINSTTCODE ( INSTT_CODE ) ; CREATE TABLE COMTNINSTTCODERECPTNLOG ( OCCRRNC_DE CHAR(20) NOT NULL, INSTT_CODE CHAR(7) NOT NULL, OPERT_SN NUMERIC(10) NOT NULL, CHANGE_SE_CODE VARCHAR(2) NULL, PROCESS_SE VARCHAR(2) NULL, ETC_CODE CHAR(2) NULL, ALL_INSTT_NM VARCHAR(255) NULL, LOWEST_INSTT_NM VARCHAR(100) NULL, INSTT_ABRV_NM VARCHAR(50) NULL, ODR CHAR(1) NULL, ORD CHAR(3) NULL, INSTT_ODR CHAR(2) NULL, UPPER_INSTT_CODE CHAR(7) NULL, BEST_INSTT_CODE CHAR(7) NULL, REPRSNT_INSTT_CODE CHAR(7) NULL, INSTT_TY_LCLAS CHAR(2) NULL, INSTT_TY_MLSFC CHAR(2) NULL, INSTT_TY_SCLAS CHAR(2) NULL, TELNO VARCHAR(20) NULL, FXNUM VARCHAR(20) NULL, CREAT_DE CHAR(20) NULL, ABL_DE CHAR(20) NULL, ABL_ENNC CHAR(1) NULL, CHANGE_DE CHAR(20) NULL, CHANGE_TIME VARCHAR(6) NULL, BSIS_DE CHAR(20) NULL, SORT_ORDR NUMERIC(8) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (OCCRRNC_DE,INSTT_CODE,OPERT_SN) ) ; CREATE UNIQUE INDEX COMTNINSTTCODERECPTNLOG_PK ON COMTNINSTTCODERECPTNLOG ( OCCRRNC_DE, INSTT_CODE, OPERT_SN ) ; CREATE TABLE COMTNINDVDLYRYCMANAGE ( OCCRRNC_YEAR CHAR(4) NOT NULL, YRYC_OCCRRNC_CO NUMERIC(5,1) NULL, USE_YRYC_CO NUMERIC(5,1) NULL, REMNDR_YRYC_CO NUMERIC(5,1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, USER_ID VARCHAR(20) NOT NULL, PRIMARY KEY (OCCRRNC_YEAR,USER_ID) ) ; CREATE UNIQUE INDEX COMTNINDVDLYRYCMANAGE_PK ON COMTNINDVDLYRYCMANAGE ( OCCRRNC_YEAR, USER_ID ) ; CREATE TABLE COMTNNTWRKSVCMNTRNG ( SYS_IP VARCHAR(23) NOT NULL, SYS_PORT NUMERIC(5) NOT NULL, SYS_NM VARCHAR(255) NOT NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, MNTRNG_STTUS CHAR(2) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, PRIMARY KEY (SYS_IP,SYS_PORT) ) ; CREATE UNIQUE INDEX COMTNNTWRKSVCMNTRNG_PK ON COMTNNTWRKSVCMNTRNG ( SYS_IP, SYS_PORT ) ; CREATE TABLE COMTNNTWRKSVCMNTRNGLOGINFO ( SYS_IP VARCHAR(23) NOT NULL, SYS_PORT NUMERIC(5) NOT NULL, SYS_NM VARCHAR(255) NOT NULL, MNTRNG_STTUS CHAR(2) NULL, LOG_INFO VARCHAR(2000) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NOT NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (SYS_IP,SYS_PORT,LOG_ID), FOREIGN KEY COMTNNTWRKSVCMNTRNGLOGINFO_FK2 (SYS_IP,SYS_PORT) REFERENCES COMTNNTWRKSVCMNTRNG(SYS_IP,SYS_PORT) ) ; CREATE UNIQUE INDEX COMTNNTWRKSVCMNTRNGLOGINFO_PK ON COMTNNTWRKSVCMNTRNGLOGINFO ( SYS_IP, SYS_PORT, LOG_ID ) ; CREATE TABLE COMTNSERVEREQPMNINFO ( SERVER_EQPMN_ID VARCHAR(20) NOT NULL, SERVER_EQPMN_NM VARCHAR(60) NULL, SERVER_EQPMN_IP VARCHAR(23) NULL, SERVER_EQPMN_MNGR VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, OPERSYSM_INFO VARCHAR(2000) NULL, CPU_INFO VARCHAR(2000) NULL, MORY_INFO VARCHAR(2000) NULL, HDDISK CHAR(18) NULL, ETC_INFO VARCHAR(250) NULL, RGSDE DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SERVER_EQPMN_ID) ) ; CREATE UNIQUE INDEX COMTNSERVEREQPMNINFO_PK ON COMTNSERVEREQPMNINFO ( SERVER_EQPMN_ID ) ; CREATE TABLE COMTNSYNCHRNSERVERINFO ( SERVER_ID CHAR(20) NOT NULL, SERVER_NM VARCHAR(60) NULL, SERVER_IP VARCHAR(23) NULL, SERVER_PORT VARCHAR(10) NULL, FTP_ID VARCHAR(20) NULL, FTP_PASSWORD VARCHAR(20) NULL, SYNCHRN_LC VARCHAR(255) NULL, REFLCT_AT CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SERVER_ID) ) ; CREATE UNIQUE INDEX COMTNSYNCHRNSERVERINFO_PK ON COMTNSYNCHRNSERVERINFO ( SERVER_ID ) ; CREATE TABLE COMTNSERVERINFO ( SERVER_ID CHAR(20) NOT NULL, SERVER_NM VARCHAR(60) NULL, SERVER_KND CHAR(2) NULL, RGSDE DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (SERVER_ID) ) ; CREATE UNIQUE INDEX COMTNSERVERINFO_PK ON COMTNSERVERINFO ( SERVER_ID ) ; CREATE TABLE COMTNSERVEREQPMNRELATE ( SERVER_EQPMN_ID VARCHAR(20) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, SERVER_ID CHAR(20) NOT NULL, PRIMARY KEY (SERVER_EQPMN_ID,SERVER_ID), FOREIGN KEY COMTNSERVEREQPMNRELATE_FK2 (SERVER_EQPMN_ID) REFERENCES COMTNSERVEREQPMNINFO(SERVER_EQPMN_ID), FOREIGN KEY COMTNSERVEREQPMNRELATE_FK1 (SERVER_ID) REFERENCES COMTNSERVERINFO(SERVER_ID) ) ; CREATE UNIQUE INDEX COMTNSERVEREQPMNRELATE_PK ON COMTNSERVEREQPMNRELATE ( SERVER_EQPMN_ID, SERVER_ID ) ; CREATE TABLE COMTNSERVERRESRCELOGINFO ( SERVER_EQPMN_ID VARCHAR(20) NOT NULL, CPU_USE_RT NUMERIC(3) NULL, MORY_USE_RT NUMERIC(3) NULL, SVC_STTUS CHAR(2) NULL, LOG_INFO VARCHAR(2000) NULL, CREAT_DT DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, SERVER_ID CHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (SERVER_EQPMN_ID,SERVER_ID,LOG_ID), FOREIGN KEY COMTNSERVERRESRCELOGINFO_FK1 (SERVER_EQPMN_ID,SERVER_ID) REFERENCES COMTNSERVEREQPMNRELATE(SERVER_EQPMN_ID,SERVER_ID) ) ; CREATE UNIQUE INDEX COMTNSERVERRESRCELOGINFO_PK ON COMTNSERVERRESRCELOGINFO ( SERVER_EQPMN_ID, SERVER_ID, LOG_ID ) ; CREATE TABLE COMTNVCATNMANAGE ( APPLCNT_ID VARCHAR(20) NOT NULL, VCATN_SE CHAR(2) NOT NULL, BGNDE CHAR(8) NOT NULL, ENDDE CHAR(8) NOT NULL, VCATN_RESN VARCHAR(200) NOT NULL, REQST_DE CHAR(20) NOT NULL, OCCRRNC_YEAR CHAR(4) NULL, SANCTNER_ID VARCHAR(20) NULL, CONFM_AT CHAR(1) NULL, SANCTN_DT DATETIME NULL, RETURN_RESN VARCHAR(1000) NULL, INFRML_SANCTN_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, NOON_SE CHAR(1) NULL, PRIMARY KEY (APPLCNT_ID,VCATN_SE,BGNDE,ENDDE) ) ; CREATE UNIQUE INDEX COMTNVCATNMANAGE_PK ON COMTNVCATNMANAGE ( APPLCNT_ID, VCATN_SE, BGNDE, ENDDE ) ; CREATE TABLE COMTNMEMOTODO ( TODO_ID CHAR(20) NOT NULL, TODO_SJ VARCHAR(255) NOT NULL, TODO_BEGIN_TIME VARCHAR(14) NOT NULL, TODO_END_TIME VARCHAR(14) NOT NULL, WRTER_ID VARCHAR(20) NOT NULL, TODO_CN VARCHAR(2500) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (TODO_ID) ) ; CREATE UNIQUE INDEX COMTNMEMOTODO_PK ON COMTNMEMOTODO ( TODO_ID ) ; CREATE TABLE COMTNNOTE ( NOTE_ID CHAR(20) NOT NULL, NOTE_SJ VARCHAR(255) NULL, NOTE_CN VARCHAR(4000) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (NOTE_ID) ) ; CREATE UNIQUE INDEX COMTNNOTE_PK ON COMTNNOTE ( NOTE_ID ) ; CREATE TABLE COMTNNOTETRNSMIT ( NOTE_ID CHAR(20) NOT NULL, NOTE_TRNSMIT_ID CHAR(20) NOT NULL, TRNSMITER_ID CHAR(20) NULL, DELETE_AT CHAR(8) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (NOTE_ID,NOTE_TRNSMIT_ID), FOREIGN KEY COMTNNOTETRNSMIT_FK1 (NOTE_ID) REFERENCES COMTNNOTE(NOTE_ID) ) ; CREATE UNIQUE INDEX COMTNNOTETRNSMIT_PK ON COMTNNOTETRNSMIT ( NOTE_ID, NOTE_TRNSMIT_ID ) ; CREATE INDEX COMTNNOTETRNSMIT_i01 ON COMTNNOTETRNSMIT ( NOTE_ID ) ; CREATE TABLE COMTNNOTERECPTN ( NOTE_ID CHAR(20) NOT NULL, NOTE_TRNSMIT_ID CHAR(20) NOT NULL, NOTE_RECPTN_ID CHAR(20) NOT NULL, RCVER_ID CHAR(20) NULL, OPEN_YN CHAR(1) NULL, RECPTN_SE CHAR(1) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (NOTE_ID,NOTE_TRNSMIT_ID,NOTE_RECPTN_ID), FOREIGN KEY COMTNNOTERECPTN_FK1 (NOTE_ID,NOTE_TRNSMIT_ID) REFERENCES COMTNNOTETRNSMIT(NOTE_ID,NOTE_TRNSMIT_ID) ) ; CREATE UNIQUE INDEX COMTNNOTERECPTN_PK ON COMTNNOTERECPTN ( NOTE_ID, NOTE_TRNSMIT_ID, NOTE_RECPTN_ID ) ; CREATE INDEX COMTNNOTERECPTN_i01 ON COMTNNOTERECPTN ( NOTE_ID, NOTE_TRNSMIT_ID ) ; CREATE TABLE COMTNEVENTMANAGE ( EVENT_ID CHAR(20) NOT NULL, EVENT_SE VARCHAR(2) NOT NULL, EVENT_NM VARCHAR(60) NOT NULL, EVENT_PURPS VARCHAR(200) NOT NULL, EVENT_BGNDE CHAR(20) NOT NULL, EVENT_ENDDE CHAR(20) NOT NULL, EVENT_AUSPC_INSTT_NM VARCHAR(60) NULL, EVENT_MNGT_INSTT_NM VARCHAR(60) NULL, EVENT_PLACE VARCHAR(200) NOT NULL, EVENT_CN VARCHAR(1000) NULL, CT_OCCRRNC_AT CHAR(1) NULL, PARTCPT_CT NUMERIC(16) NULL, PSNCPA NUMERIC(10) NOT NULL, REFRN_URL VARCHAR(1024) NULL, RCEPT_BGNDE CHAR(20) NOT NULL, RCEPT_ENDDE CHAR(20) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (EVENT_ID) ) ; CREATE UNIQUE INDEX COMTNEVENTMANAGE_PK ON COMTNEVENTMANAGE ( EVENT_ID ) ; CREATE TABLE COMTNEVENTATDRN ( APPLCNT_ID VARCHAR(20) NOT NULL, EVENT_ID CHAR(20) NOT NULL, REQST_DE CHAR(20) NOT NULL, SANCTNER_ID VARCHAR(20) NOT NULL, CONFM_AT CHAR(1) NULL, SANCTN_DT DATETIME NULL, RETURN_RESN VARCHAR(1000) NULL, INFRML_SANCTN_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (APPLCNT_ID,EVENT_ID), FOREIGN KEY COMTNEVENTATDRN_FK1 (EVENT_ID) REFERENCES COMTNEVENTMANAGE(EVENT_ID) ) ; CREATE UNIQUE INDEX COMTNEVENTATDRN_PK ON COMTNEVENTATDRN ( APPLCNT_ID, EVENT_ID ) ; CREATE INDEX COMTNEVENTATDRN_i01 ON COMTNEVENTATDRN ( EVENT_ID ) ; CREATE TABLE IMGTEMP ( ORGNZT_CODE VARCHAR(10) NOT NULL, ERNCSL_SE VARCHAR(2) NOT NULL, IMAGE_INFO BLOB NOT NULL, IMAGE_TY VARCHAR(20) NULL, PRIMARY KEY (ORGNZT_CODE,ERNCSL_SE) ) ; CREATE UNIQUE INDEX IMGTEMP_PK ON IMGTEMP ( ORGNZT_CODE, ERNCSL_SE ) ; CREATE TABLE IDS ( IDGEN_TABLE_NM VARCHAR(20) NOT NULL, IDGEN_NEXT_ID NUMERIC(30) NOT NULL, PRIMARY KEY (IDGEN_TABLE_NM) ) ; CREATE UNIQUE INDEX IDS_PK ON IDS ( IDGEN_TABLE_NM ) ; CREATE TABLE COMTNWIKMNTHNGREPRT ( REPRT_ID CHAR(6) NOT NULL, REPRT_SE CHAR(1) NOT NULL, REPRT_SJ VARCHAR(255) NOT NULL, REPORT_DE CHAR(20) NOT NULL, WRTER_ID VARCHAR(20) NOT NULL, REPORTR_ID VARCHAR(20) NOT NULL, REPORT_BGNDE CHAR(20) NOT NULL, REPORT_ENDDE CHAR(20) NOT NULL, THSWIK_REPORT_CN MEDIUMTEXT NOT NULL, NEXTWIK_REPORT_CN MEDIUMTEXT NOT NULL, PARTCLR_MATTER VARCHAR(2500) NULL, ATCH_FILE_ID CHAR(20) NULL, CONFM_DT VARCHAR(14) NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (REPRT_ID) ) ; CREATE UNIQUE INDEX COMTNWIKMNTHNGREPRT_PK ON COMTNWIKMNTHNGREPRT ( REPRT_ID ) ; CREATE TABLE COMTNTWITTER ( USER_ID VARCHAR(20) NOT NULL, CNSMR_KEY VARCHAR(50) NOT NULL, CNSMR_SECRET VARCHAR(50) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (USER_ID) ) ; CREATE UNIQUE INDEX COMTNTWITTER_PK ON COMTNTWITTER ( USER_ID ) ; CREATE TABLE COMTNWIKIBKMK ( WIKI_BKMK_ID CHAR(20) NOT NULL, USER_ID VARCHAR(20) NOT NULL, WIKI_BKMK_NM VARCHAR(1000) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (WIKI_BKMK_ID,USER_ID) ) ; CREATE UNIQUE INDEX COMTNWIKIBKMK_PK ON COMTNWIKIBKMK ( WIKI_BKMK_ID, USER_ID ) ; CREATE TABLE COMTNRWARDMANAGE ( RWARD_ID CHAR(20) NOT NULL, RWARDWNR_ID VARCHAR(20) NOT NULL, RWARD_CODE CHAR(2) NOT NULL, RWARD_DE CHAR(20) NOT NULL, RWARD_NM VARCHAR(255) NOT NULL, PBLEN_CN VARCHAR(1000) NULL, SANCTNER_ID VARCHAR(20) NOT NULL, CONFM_AT CHAR(1) NULL, SANCTN_DT DATETIME NULL, RETURN_RESN VARCHAR(1000) NULL, ATCH_FILE_ID CHAR(20) NULL, INFRML_SANCTN_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (RWARD_ID) ) ; CREATE UNIQUE INDEX COMTNRWARDMANAGE_PK ON COMTNRWARDMANAGE ( RWARD_ID ) ; CREATE TABLE COMTNRSS ( RSS_ID CHAR(20) NOT NULL, TRGET_SVC_NM VARCHAR(255) NOT NULL, TRGET_SVC_TABLE VARCHAR(255) NOT NULL, TRGET_SVC_LIST_CO NUMERIC(5) NOT NULL, HDER_TITLE VARCHAR(255) NOT NULL, HDER_LINK VARCHAR(255) NOT NULL, HDER_DC VARCHAR(4000) NOT NULL, HDER_TAG VARCHAR(255) NULL, HDER_ETC VARCHAR(250) NULL, BDT_TITLE VARCHAR(255) NULL, BDT_LINK VARCHAR(255) NULL, BDT_DC VARCHAR(4000) NULL, BDT_TAG VARCHAR(255) NULL, BDT_ETC_TAG VARCHAR(255) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (RSS_ID) ) ; CREATE UNIQUE INDEX COMTNRSS_PK ON COMTNRSS ( RSS_ID ) ; CREATE TABLE COMTNRESTDE ( RESTDE_NO NUMERIC(6) NOT NULL, RESTDE CHAR(8) NULL, RESTDE_NM VARCHAR(60) NULL, RESTDE_DC VARCHAR(200) NULL, RESTDE_SE_CODE VARCHAR(2) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (RESTDE_NO) ) ; CREATE UNIQUE INDEX COMTNRESTDE_PK ON COMTNRESTDE ( RESTDE_NO ) ; CREATE TABLE COMTNPROCESSMON ( PROCS_ID CHAR(20) NOT NULL, PROCS_NM VARCHAR(60) NULL, PROCS_STTUS VARCHAR(3) NULL, CREAT_DT DATETIME NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (PROCS_ID) ) ; CREATE UNIQUE INDEX COMTNPROCESSMON_PK ON COMTNPROCESSMON ( PROCS_ID ) ; CREATE TABLE COMTNPROCESSMONLOGINFO ( PROCS_ID CHAR(20) NOT NULL, PROCS_NM VARCHAR(60) NULL, PROCS_STTUS VARCHAR(3) NULL, CREAT_DT DATETIME NULL, LOG_INFO VARCHAR(2000) NULL, MNGR_NM VARCHAR(60) NULL, MNGR_EMAIL_ADRES VARCHAR(50) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LOG_ID CHAR(20) NOT NULL, PRIMARY KEY (PROCS_ID,LOG_ID), FOREIGN KEY COMTNPROCESSMONLOGINFO_FK2 (PROCS_ID) REFERENCES COMTNPROCESSMON(PROCS_ID) ) ; CREATE UNIQUE INDEX COMTNPROCESSMONLOGINFO_PK ON COMTNPROCESSMONLOGINFO ( PROCS_ID, LOG_ID ) ; CREATE TABLE COMTNNTWRKINFO ( NTWRK_ID CHAR(20) NOT NULL, NTWRK_IP VARCHAR(23) NULL, GTWY VARCHAR(23) NULL, SUBNET VARCHAR(23) NULL, DOMN_NM_SERVER VARCHAR(23) NULL, MANAGE_IEM CHAR(2) NULL, USER_NM VARCHAR(60) NULL, USE_AT CHAR(1) NULL, RGSDE DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (NTWRK_ID) ) ; CREATE UNIQUE INDEX COMTNNTWRKINFO_PK ON COMTNNTWRKINFO ( NTWRK_ID ) ; CREATE VIEW COMVNUSERMASTER ( ESNTL_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID, USER_SE, ORGNZT_ID ) AS SELECT ESNTL_ID, MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,' ','GNR' AS USER_SE, ' ' ORGNZT_ID FROM COMTNGNRLMBER UNION ALL SELECT ESNTL_ID,EMPLYR_ID,PASSWORD,USER_NM,ZIP,HOUSE_ADRES,EMAIL_ADRES,GROUP_ID ,'USR' AS USER_SE, ORGNZT_ID FROM COMTNEMPLYRINFO UNION ALL SELECT ESNTL_ID,ENTRPRS_MBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,' ' ,'ENT' AS USER_SE, ' ' ORGNZT_ID FROM COMTNENTRPRSMBER ORDER BY ESNTL_ID; CREATE TABLE COMTNMEMOREPRT ( REPRT_SJ VARCHAR(255) NOT NULL, REPORT_DE CHAR(20) NOT NULL, WRTER_ID VARCHAR(20) NOT NULL, REPORTR_ID VARCHAR(20) NOT NULL, REPORT_CN VARCHAR(2500) NOT NULL, ATCH_FILE_ID CHAR(20) NULL, DRCT_MATTER VARCHAR(2500) NULL, DRCT_MATTER_REGIST_DT VARCHAR(14) NULL, REPORTR_INQIRE_DT VARCHAR(14) NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, REPRT_ID CHAR(6) NOT NULL, PRIMARY KEY (REPRT_ID) ) ; CREATE UNIQUE INDEX COMTNMEMOREPRT_PK ON COMTNMEMOREPRT ( REPRT_ID ) ; CREATE TABLE COMTNMTGPLACEMANAGE ( MTGRUM_ID CHAR(20) NOT NULL, MTGRUM_NM VARCHAR(255) NOT NULL, OPN_BEGIN_TM VARCHAR(6) NOT NULL, OPN_END_TM VARCHAR(6) NOT NULL, ACEPTNC_POSBL_NMPR NUMERIC(10) NOT NULL, LC_SE CHAR(5) NULL, LC_DETAIL VARCHAR(200) NULL, ATCH_FILE_ID CHAR(20) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (MTGRUM_ID) ) ; CREATE UNIQUE INDEX COMTNMTGPLACEMANAGE_PK ON COMTNMTGPLACEMANAGE ( MTGRUM_ID ) ; CREATE TABLE COMTNMTGPLACERESVE ( RESVE_ID CHAR(20) NOT NULL, MTGRUM_ID CHAR(20) NOT NULL, MTG_SJ VARCHAR(100) NOT NULL, RSVCTM_ID VARCHAR(20) NOT NULL, RESVE_DE CHAR(8) NOT NULL, RESVE_BEGIN_TM VARCHAR(14) NOT NULL, RESVE_END_TM VARCHAR(14) NOT NULL, ATNDNC_NMPR NUMERIC(10) NULL, MTG_CN VARCHAR(2500) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (RESVE_ID), FOREIGN KEY COMTNMTGPLACERESVE_FK1 (MTGRUM_ID) REFERENCES COMTNMTGPLACEMANAGE(MTGRUM_ID) ) ; CREATE UNIQUE INDEX COMTNMTGPLACERESVE_PK ON COMTNMTGPLACERESVE ( RESVE_ID ) ; CREATE INDEX COMTNMTGPLACERESVE_i01 ON COMTNMTGPLACERESVE ( MTGRUM_ID ) ; CREATE TABLE COMTNFXTRSMANAGE ( FXTRS_CODE CHAR(14) NOT NULL, FXTRS_NM VARCHAR(100) NOT NULL, MAKR_NM VARCHAR(100) NULL, PRICE NUMERIC(16) NULL, PRIMARY KEY (FXTRS_CODE) ) ; CREATE UNIQUE INDEX COMTNFXTRSMANAGE_PK ON COMTNFXTRSMANAGE ( FXTRS_CODE ) ; CREATE TABLE COMTNMTGPLACEFXTRS ( MTGRUM_ID CHAR(20) NOT NULL, FXTRS_CODE CHAR(14) NOT NULL, QY NUMERIC(20) NOT NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (MTGRUM_ID,FXTRS_CODE), FOREIGN KEY COMTNMTGPLACEFXTRS_FK2 (MTGRUM_ID) REFERENCES COMTNMTGPLACEMANAGE(MTGRUM_ID), FOREIGN KEY COMTNMTGPLACEFXTRS_FK1 (FXTRS_CODE) REFERENCES COMTNFXTRSMANAGE(FXTRS_CODE) ) ; CREATE UNIQUE INDEX COMTNMTGPLACEFXTRS_PK ON COMTNMTGPLACEFXTRS ( MTGRUM_ID, FXTRS_CODE ) ; CREATE INDEX COMTNMTGPLACEFXTRS_i01 ON COMTNMTGPLACEFXTRS ( MTGRUM_ID ) ; CREATE TABLE COMTECOPSEQ ( TABLE_NAME VARCHAR(20) NOT NULL, NEXT_ID NUMERIC(30) NULL, PRIMARY KEY (TABLE_NAME) ) ; CREATE UNIQUE INDEX COMTECOPSEQ_PK ON COMTECOPSEQ ( TABLE_NAME ) ; CREATE TABLE COMTNANNVRSRYMANAGE ( ANNVRSRY_ID VARCHAR(20) NOT NULL, USER_ID VARCHAR(20) NOT NULL, ANNVRSRY_SE VARCHAR(2) NOT NULL, ANNVRSRY_NM VARCHAR(255) NOT NULL, ANNVRSRY CHAR(20) NOT NULL, CLDR_SE CHAR(1) NOT NULL, ANNVRSRY_NTCN_SETUP CHAR(1) NULL, ANNVRSRY_NTCN_BGNDE CHAR(20) NULL, MEMO VARCHAR(1000) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, REPTIT_AT CHAR(1) NULL, PRIMARY KEY (ANNVRSRY_ID) ) ; CREATE UNIQUE INDEX COMTNANNVRSRYMANAGE_PK ON COMTNANNVRSRYMANAGE ( ANNVRSRY_ID ) ; CREATE TABLE J_ATTACHFILE ( FILE_ID VARCHAR(13) NOT NULL, FILE_SEQ INT NOT NULL, FILE_NAME VARCHAR(100) NOT NULL, FILE_SIZE INT, FILE_MASK VARCHAR(100), DOWNLOAD_COUNT INT, DOWNLOAD_EXPIRE_DATE VARCHAR(8), DOWNLOAD_LIMIT_COUNT INT, REG_DATE DATETIME, DELETE_YN VARCHAR(1), PRIMARY KEY (FILE_ID, FILE_SEQ) ) ; CREATE UNIQUE INDEX J_ATTACHFILE_PK ON J_ATTACHFILE ( FILE_ID, FILE_SEQ ) ; CREATE TABLE COMTNROUGHMAP ( ROUGHMAP_ID VARCHAR(75) NOT NULL, ROUGHMAPSJ VARCHAR(75) NOT NULL, ROUGHMAPADDRESS VARCHAR(200) NULL, LA VARCHAR(48) NULL, LO VARCHAR(48) NULL, MARKERLA VARCHAR(48) NULL, MARKERLO VARCHAR(48) NULL, INFOWINDOW VARCHAR(20) NULL, ZOOMLEVEL VARCHAR(10) NULL, FRST_REGIST_PNTTM DATETIME NULL, FRST_REGISTER_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL ); CREATE TABLE COMTNPRIVACYLOG ( REQUST_ID VARCHAR(20) NOT NULL, INQIRE_DT DATETIME NOT NULL, SRVC_NM VARCHAR(500) NULL, INQIRE_INFO VARCHAR(100) NULL, RQESTER_ID VARCHAR(20) NULL, RQESTER_IP VARCHAR(23) NULL, PRIMARY KEY (REQUST_ID) ) ; CREATE UNIQUE INDEX COMTNPRIVACYLOG_PK ON COMTNPRIVACYLOG ( REQUST_ID ) ; CREATE TABLE COMTNCOMMUTE ( WRKTM_ID CHAR(20) NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, ORGNZT_ID VARCHAR(20) NULL, WRKT_DT VARCHAR(10) NOT NULL, WRK_START_TIME VARCHAR(14) NULL, WRK_END_TIME VARCHAR(14) NULL, WRK_HOURS CHAR(2) NULL, OVTMWRK_HOURS CHAR(2) NULL, WRK_START_STATUS VARCHAR(10) NULL, WRK_END_STATUS VARCHAR(10) NULL, RM VARCHAR(100) NULL, FRST_REGISTER_ID VARCHAR(20) NULL, FRST_REGIST_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, LAST_UPDT_PNTTM DATETIME NULL, PRIMARY KEY (EMPLYR_ID, WRKT_DT) ); CREATE TABLE COMTNBLOG ( BLOG_ID CHAR(20) NOT NULL , BLOG_NM VARCHAR(255) NOT NULL , BLOG_INTRCN VARCHAR(2400) NULL , USE_AT CHAR(1) NOT NULL , REGIST_SE_CODE CHAR(6) NULL , TMPLAT_ID CHAR(20) NULL , FRST_REGIST_PNTTM DATETIME NOT NULL , FRST_REGISTER_ID VARCHAR(20) NOT NULL , LAST_UPDT_PNTTM DATETIME NULL , LAST_UPDUSR_ID VARCHAR(20) NULL , BBS_ID CHAR(20) DEFAULT NULL, BLOG_AT CHAR(2) DEFAULT NULL, PRIMARY KEY (BLOG_ID) ); CREATE TABLE COMTNBLOGUSER ( BLOG_ID CHAR(20) NOT NULL, EMPLYR_ID VARCHAR(20) NOT NULL, MNGR_AT CHAR(1) NOT NULL, MBER_STTUS VARCHAR(15) NULL, SBSCRB_DE DATETIME NULL, SECSN_DE CHAR(20) NULL, USE_AT CHAR(1) NULL, FRST_REGIST_PNTTM DATETIME NOT NULL, FRST_REGISTER_ID VARCHAR(20) NOT NULL, LAST_UPDT_PNTTM DATETIME NULL, LAST_UPDUSR_ID VARCHAR(20) NULL, PRIMARY KEY (BLOG_ID,EMPLYR_ID), FOREIGN KEY COMTNBLOGUSER_FK1 (BLOG_ID) REFERENCES COMTNBLOG(BLOG_ID) );