You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
5431 lines
118 KiB
SQL
5431 lines
118 KiB
SQL
|
|
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(30) NOT NULL,
|
|
BBS_NM VARCHAR(255) NOT NULL,
|
|
BBS_INTRCN VARCHAR(2400) NULL,
|
|
BBS_TY_CODE CHAR(6) NOT NULL,
|
|
BBS_ATTRB_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(30) 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(30) 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 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(30) 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(30) 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(30) 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 VARCHAR(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(30) 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,
|
|
DELETE_AT CHAR(1) 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 VARCHAR(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(30) 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 VARCHAR(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 VARCHAR(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(30) 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 VARCHAR(100) NULL,
|
|
INSTT_TY_MLSFC VARCHAR(100) NULL,
|
|
INSTT_TY_SCLAS VARCHAR(100) 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 VARCHAR(100) NULL,
|
|
INSTT_TY_MLSFC VARCHAR(100) NULL,
|
|
INSTT_TY_SCLAS VARCHAR(100) 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, GROUP_ID, 'GNR' AS USER_SE, '' AS ORGNZT_ID
|
|
FROM COMTNGNRLMBER
|
|
UNION ALL
|
|
SELECT ESNTL_ID, ENTRPRS_MBER_ID, ENTRPRS_MBER_PASSWORD, CMPNY_NM, ZIP, ADRES, APPLCNT_EMAIL_ADRES, GROUP_ID, 'ENT' AS USER_SE, '' AS ORGNZT_ID
|
|
FROM COMTNENTRPRSMBER
|
|
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
|
|
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(30) 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)
|
|
);
|
|
|
|
CREATE TABLE COMTCMOBILEIDSERVICE
|
|
(
|
|
SVCCODE VARCHAR(50) NOT NULL,
|
|
PRESENTTYPE INTEGER NOT NULL DEFAULT 1,
|
|
ENCRYPTTYPE INTEGER NOT NULL DEFAULT 2,
|
|
KEYTYPE INTEGER NOT NULL DEFAULT 2,
|
|
AUTHTYPE VARCHAR(50) DEFAULT NULL,
|
|
SPNAME VARCHAR(100) NOT NULL,
|
|
SERVICENAME VARCHAR(100) NOT NULL,
|
|
ATTRLIST VARCHAR(100) DEFAULT NULL,
|
|
PREDLIST VARCHAR(100) DEFAULT NULL,
|
|
CALLBACKURL VARCHAR(100) DEFAULT NULL,
|
|
REGDT TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
|
|
UDTDT TIMESTAMP NULL DEFAULT NULL,
|
|
PRIMARY KEY (SVCCODE)
|
|
);
|
|
|
|
CREATE TABLE COMTSMOBILEIDTRXINFO
|
|
(
|
|
TRXCODE VARCHAR(50) NOT NULL,
|
|
SVCCODE VARCHAR(50) NOT NULL,
|
|
OPMODE VARCHAR(50) NOT NULL,
|
|
DEVICEID VARCHAR(100) DEFAULT NULL,
|
|
BRANCHNAME VARCHAR(100) DEFAULT NULL,
|
|
NONCE VARCHAR(100) DEFAULT NULL,
|
|
ZKPNONCE VARCHAR(100) DEFAULT NULL,
|
|
VPVERIFYRESULT VARCHAR(1) NOT NULL DEFAULT 'N',
|
|
TRXSTSCODE VARCHAR(4) NOT NULL DEFAULT '0001',
|
|
PROFILESENDDT TIMESTAMP NULL DEFAULT NULL,
|
|
IMGSENDDT TIMESTAMP NULL DEFAULT NULL,
|
|
VPRECEPTDT TIMESTAMP NULL DEFAULT NULL,
|
|
ERRORCN VARCHAR(4000) DEFAULT NULL,
|
|
REGDT TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
|
|
UDTDT TIMESTAMP NULL DEFAULT NULL,
|
|
VPNAME VARCHAR(50),
|
|
PRIMARY KEY (TRXCODE)
|
|
);
|
|
|
|
|
|
/* jfile 대체 */
|
|
CREATE TABLE LETTNFILE (
|
|
ATCH_FILE_ID char(20) NOT NULL,
|
|
CREAT_DT datetime NOT NULL,
|
|
USE_AT char(1) DEFAULT NULL,
|
|
PRIMARY KEY (ATCH_FILE_ID)
|
|
) ;
|
|
|
|
|
|
|
|
CREATE TABLE LETTNFILEDETAIL (
|
|
ATCH_FILE_ID char(20) NOT NULL,
|
|
FILE_SN decimal(10,0) NOT NULL,
|
|
FILE_STRE_COURS varchar(2000) NOT NULL,
|
|
STRE_FILE_NM varchar(255) NOT NULL,
|
|
ORIGNL_FILE_NM varchar(255) DEFAULT NULL,
|
|
FILE_EXTSN varchar(20) NOT NULL,
|
|
FILE_CN mediumtext,
|
|
FILE_SIZE decimal(8,0) DEFAULT NULL,
|
|
PRIMARY KEY (ATCH_FILE_ID,FILE_SN),
|
|
CONSTRAINT LETTNFILEDETAIL_ibfk_1 FOREIGN KEY (ATCH_FILE_ID) REFERENCES LETTNFILE (ATCH_FILE_ID)
|
|
) ; |