-- ============================================================================
-- 인천 지리정보 플랫폼 - 전체 테이블 DDL
-- 생성일시: 2025-10-27
-- 총 테이블: 41개
-- 순서: FK 의존성 고려 (부모 → 자식)
-- ============================================================================

-- PostgreSQL database dump

-- Dumped from database version 17.6
-- Dumped by pg_dump version 17.4


-- Name: authrt; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.authrt (
    authrt_cd character varying(100) NOT NULL,
    authrt_nm character varying(200) NOT NULL,
    authrt_expln character varying(4000),
    authrt_type_cd character varying(20) NOT NULL,
    sys_cd character varying(20) NOT NULL,
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE authrt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.authrt IS '권한';


-- Name: COLUMN authrt.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.authrt_cd IS '권한코드';


-- Name: COLUMN authrt.authrt_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.authrt_nm IS '권한명';


-- Name: COLUMN authrt.authrt_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.authrt_expln IS '권한설명';


-- Name: COLUMN authrt.authrt_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.authrt_type_cd IS '권한유형코드';


-- Name: COLUMN authrt.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.sys_cd IS '시스템코드';


-- Name: COLUMN authrt.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.use_yn IS '사용여부';


-- Name: COLUMN authrt.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN authrt.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN authrt.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN authrt.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt.last_mdfcn_dt IS '최종수정일시';


-- Name: authrt_stng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.authrt_stng (
    authrt_cd character varying(100) NOT NULL,
    authrt_stng_type_cd character varying(100) NOT NULL,
    authrt_stng_trgt_cd character varying(20) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE authrt_stng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.authrt_stng IS '권한설정';


-- Name: COLUMN authrt_stng.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.authrt_cd IS '권한코드';


-- Name: COLUMN authrt_stng.authrt_stng_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.authrt_stng_type_cd IS '권한설정유형코드';


-- Name: COLUMN authrt_stng.authrt_stng_trgt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.authrt_stng_trgt_cd IS '권한설정대상코드';


-- Name: COLUMN authrt_stng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN authrt_stng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN authrt_stng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN authrt_stng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.authrt_stng.last_mdfcn_dt IS '최종수정일시';


-- Name: clct_daly_smry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.clct_daly_smry (
    tot_ymd character(8) NOT NULL,
    job_id character varying(100) NOT NULL,
    job_nm character varying(300) NOT NULL,
    data_sourc_nm character varying(300) NOT NULL,
    excn_nmtm numeric(10,0) DEFAULT 0 NOT NULL,
    tprcs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    tot_scs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    tot_fail_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    scs_rpblty numeric(5,2),
    avg_prcs_hr numeric(10,0),
    p95_prcs_hr numeric(10,0),
    max_prcs_hr numeric(10,0),
    avg_mmry numeric(10,0),
    max_mmry numeric(10,0),
    avg_cpu_load numeric(10,0),
    max_cpu_load numeric(10,0),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE clct_daly_smry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.clct_daly_smry IS '수집일별요약';


-- Name: COLUMN clct_daly_smry.tot_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.tot_ymd IS '집계일자';


-- Name: COLUMN clct_daly_smry.job_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.job_id IS '작업아이디';


-- Name: COLUMN clct_daly_smry.job_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.job_nm IS '작업명';


-- Name: COLUMN clct_daly_smry.data_sourc_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.data_sourc_nm IS '데이터소스명';


-- Name: COLUMN clct_daly_smry.excn_nmtm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.excn_nmtm IS '실행횟수';


-- Name: COLUMN clct_daly_smry.tprcs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.tprcs_nocs IS '총처리건수';


-- Name: COLUMN clct_daly_smry.tot_scs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.tot_scs_nocs IS '총성공건수';


-- Name: COLUMN clct_daly_smry.tot_fail_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.tot_fail_nocs IS '총실패건수';


-- Name: COLUMN clct_daly_smry.scs_rpblty; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.scs_rpblty IS '성공확률';


-- Name: COLUMN clct_daly_smry.avg_prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.avg_prcs_hr IS '평균처리시간';


-- Name: COLUMN clct_daly_smry.p95_prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.p95_prcs_hr IS 'P95처리시간';


-- Name: COLUMN clct_daly_smry.max_prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.max_prcs_hr IS '최대처리시간';


-- Name: COLUMN clct_daly_smry.avg_mmry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.avg_mmry IS '평균메모리';


-- Name: COLUMN clct_daly_smry.max_mmry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.max_mmry IS '최대메모리';


-- Name: COLUMN clct_daly_smry.avg_cpu_load; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.avg_cpu_load IS '평균CPU부하';


-- Name: COLUMN clct_daly_smry.max_cpu_load; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.max_cpu_load IS '최대CPU부하';


-- Name: COLUMN clct_daly_smry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN clct_daly_smry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN clct_daly_smry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN clct_daly_smry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_daly_smry.last_mdfcn_dt IS '최종수정일시';


-- Name: clct_hstry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.clct_hstry (
    clct_hstry_sn numeric(20,0) NOT NULL,
    excn_id character varying(100) NOT NULL,
    job_nm character varying(300) NOT NULL,
    job_expln character varying(4000),
    job_stcd character varying(20) NOT NULL,
    bgng_dt timestamp without time zone NOT NULL,
    end_dt timestamp without time zone,
    prcs_hr numeric(10,0),
    excn_stcd character varying(20) NOT NULL,
    prcs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    scs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    fail_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    err_msg character varying(4000),
    log_msg character varying(4000),
    excn_hr timestamp without time zone,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE clct_hstry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.clct_hstry IS '수집이력';


-- Name: COLUMN clct_hstry.clct_hstry_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.clct_hstry_sn IS '로그일련번호';


-- Name: COLUMN clct_hstry.excn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.excn_id IS '실행아이디';


-- Name: COLUMN clct_hstry.job_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.job_nm IS '작업명';


-- Name: COLUMN clct_hstry.job_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.job_expln IS '작업설명';


-- Name: COLUMN clct_hstry.job_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.job_stcd IS '작업상태코드';


-- Name: COLUMN clct_hstry.bgng_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.bgng_dt IS '시작일시';


-- Name: COLUMN clct_hstry.end_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.end_dt IS '종료일시';


-- Name: COLUMN clct_hstry.prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.prcs_hr IS '처리시간';


-- Name: COLUMN clct_hstry.excn_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.excn_stcd IS '실행상태코드';


-- Name: COLUMN clct_hstry.prcs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.prcs_nocs IS '처리건수';


-- Name: COLUMN clct_hstry.scs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.scs_nocs IS '성공건수';


-- Name: COLUMN clct_hstry.fail_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.fail_nocs IS '실패건수';


-- Name: COLUMN clct_hstry.err_msg; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.err_msg IS '오류메시지';


-- Name: COLUMN clct_hstry.log_msg; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.log_msg IS '로그메시지';


-- Name: COLUMN clct_hstry.excn_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.excn_hr IS '실행시간';


-- Name: COLUMN clct_hstry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN clct_hstry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN clct_hstry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN clct_hstry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_hstry.last_mdfcn_dt IS '최종수정일시';


-- Name: clct_intg_hstry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.clct_intg_hstry (
    clct_hstry_sn numeric(20,0) NOT NULL,
    job_id character varying(100) NOT NULL,
    job_nm character varying(300) NOT NULL,
    data_sourc_nm character varying(300) NOT NULL,
    excn_stcd character varying(20) NOT NULL,
    prcs_data_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    scs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    fail_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    excn_dt timestamp without time zone NOT NULL,
    cmptn_dt timestamp without time zone,
    prcs_hr numeric(10,0),
    excn_id character varying(100),
    excn_group_nm character varying(300),
    mmry_usqty numeric(10,0),
    cpu_load_avg numeric(5,2),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE clct_intg_hstry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.clct_intg_hstry IS '수집통합이력';


-- Name: COLUMN clct_intg_hstry.clct_hstry_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.clct_hstry_sn IS '수집이력일련번호';


-- Name: COLUMN clct_intg_hstry.job_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.job_id IS '작업아이디';


-- Name: COLUMN clct_intg_hstry.job_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.job_nm IS '작업명';


-- Name: COLUMN clct_intg_hstry.data_sourc_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.data_sourc_nm IS '데이터소스명';


-- Name: COLUMN clct_intg_hstry.excn_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.excn_stcd IS '실행상태코드';


-- Name: COLUMN clct_intg_hstry.prcs_data_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.prcs_data_nocs IS '처리데이터건수';


-- Name: COLUMN clct_intg_hstry.scs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.scs_nocs IS '성공건수';


-- Name: COLUMN clct_intg_hstry.fail_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.fail_nocs IS '실패건수';


-- Name: COLUMN clct_intg_hstry.excn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.excn_dt IS '실행일시';


-- Name: COLUMN clct_intg_hstry.cmptn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.cmptn_dt IS '완료일시';


-- Name: COLUMN clct_intg_hstry.prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.prcs_hr IS '처리시간';


-- Name: COLUMN clct_intg_hstry.excn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.excn_id IS '실행아이디';


-- Name: COLUMN clct_intg_hstry.excn_group_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.excn_group_nm IS '실행그룹명';


-- Name: COLUMN clct_intg_hstry.mmry_usqty; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.mmry_usqty IS '메모리사용량';


-- Name: COLUMN clct_intg_hstry.cpu_load_avg; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.cpu_load_avg IS 'CPU부하평균';


-- Name: COLUMN clct_intg_hstry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN clct_intg_hstry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN clct_intg_hstry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN clct_intg_hstry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_intg_hstry.last_mdfcn_dt IS '최종수정일시';


-- Name: clct_repo_queue; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.clct_repo_queue (
    clct_repo_queue_sn numeric(20,0) NOT NULL,
    flpth character varying(500) NOT NULL,
    queue_stcd character varying(20) DEFAULT 'PENDING'::character varying NOT NULL,
    job_id character varying(100),
    job_nm character varying(300),
    data_sourc_nm character varying(300),
    reg_dt timestamp without time zone NOT NULL,
    prcs_dt timestamp without time zone,
    rtry_nmtm numeric(10,0) DEFAULT 0 NOT NULL,
    err_msg character varying(4000),
    last_rtry_dt timestamp without time zone,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE clct_repo_queue; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.clct_repo_queue IS '수집리포트큐';


-- Name: COLUMN clct_repo_queue.clct_repo_queue_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.clct_repo_queue_sn IS '큐일련번호';


-- Name: COLUMN clct_repo_queue.flpth; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.flpth IS '파일경로';


-- Name: COLUMN clct_repo_queue.queue_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.queue_stcd IS '큐상태코드';


-- Name: COLUMN clct_repo_queue.job_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.job_id IS '작업아이디';


-- Name: COLUMN clct_repo_queue.job_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.job_nm IS '작업명';


-- Name: COLUMN clct_repo_queue.data_sourc_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.data_sourc_nm IS '데이터소스명';


-- Name: COLUMN clct_repo_queue.reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.reg_dt IS '등록일시';


-- Name: COLUMN clct_repo_queue.prcs_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.prcs_dt IS '처리일시';


-- Name: COLUMN clct_repo_queue.rtry_nmtm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.rtry_nmtm IS '재시도횟수';


-- Name: COLUMN clct_repo_queue.err_msg; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.err_msg IS '오류메시지';


-- Name: COLUMN clct_repo_queue.last_rtry_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.last_rtry_dt IS '최종재시도일시';


-- Name: COLUMN clct_repo_queue.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN clct_repo_queue.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN clct_repo_queue.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN clct_repo_queue.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.clct_repo_queue.last_mdfcn_dt IS '최종수정일시';


-- Name: cntn_prst_smry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.cntn_prst_smry (
    tot_ymd character(8) NOT NULL,
    hr character(2) NOT NULL,
    srvr_nm character varying(100),
    tot_sesion_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    new_sesion_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    end_sesion_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    tot_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    acml_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE cntn_prst_smry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.cntn_prst_smry IS '접속현황요약';


-- Name: COLUMN cntn_prst_smry.tot_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.tot_ymd IS '집계일자';


-- Name: COLUMN cntn_prst_smry.hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.hr IS '시간';


-- Name: COLUMN cntn_prst_smry.srvr_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.srvr_nm IS '서버명';


-- Name: COLUMN cntn_prst_smry.tot_sesion_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.tot_sesion_cnt IS '총세션수';


-- Name: COLUMN cntn_prst_smry.new_sesion_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.new_sesion_cnt IS '신규세션수';


-- Name: COLUMN cntn_prst_smry.end_sesion_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.end_sesion_cnt IS '종료세션수';


-- Name: COLUMN cntn_prst_smry.tot_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.tot_cnt IS '집계수';


-- Name: COLUMN cntn_prst_smry.acml_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.acml_cnt IS '누적수';


-- Name: COLUMN cntn_prst_smry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN cntn_prst_smry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN cntn_prst_smry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN cntn_prst_smry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_prst_smry.last_mdfcn_dt IS '최종수정일시';


-- Name: cntn_stats_daly_gis_smry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.cntn_stats_daly_gis_smry (
    tot_ymd character(8) NOT NULL,
    user_id character varying(50) NOT NULL,
    user_nm character varying(300),
    dept_cd character varying(20),
    dept_nm character varying(300),
    map_crt_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    map_shrn_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    map_utztn_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE cntn_stats_daly_gis_smry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.cntn_stats_daly_gis_smry IS '접속통계일별GIS요약';


-- Name: COLUMN cntn_stats_daly_gis_smry.tot_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.tot_ymd IS '집계일자';


-- Name: COLUMN cntn_stats_daly_gis_smry.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.user_id IS '사용자아이디';


-- Name: COLUMN cntn_stats_daly_gis_smry.user_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.user_nm IS '사용자명';


-- Name: COLUMN cntn_stats_daly_gis_smry.dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.dept_cd IS '부서코드';


-- Name: COLUMN cntn_stats_daly_gis_smry.dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.dept_nm IS '부서명';


-- Name: COLUMN cntn_stats_daly_gis_smry.map_crt_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.map_crt_cnt IS 'MAP생성수';


-- Name: COLUMN cntn_stats_daly_gis_smry.map_shrn_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.map_shrn_cnt IS 'MAP공유수';


-- Name: COLUMN cntn_stats_daly_gis_smry.map_utztn_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.map_utztn_cnt IS 'MAP이용수';


-- Name: COLUMN cntn_stats_daly_gis_smry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN cntn_stats_daly_gis_smry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN cntn_stats_daly_gis_smry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN cntn_stats_daly_gis_smry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_daly_gis_smry.last_mdfcn_dt IS '최종수정일시';


-- Name: cntn_stats_hr_smry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.cntn_stats_hr_smry (
    tot_ymd character(8) NOT NULL,
    hr character(2) NOT NULL,
    user_id character varying(50) NOT NULL,
    user_nm character varying(300),
    dept_cd character varying(20),
    dept_nm character varying(300),
    sys_cd character varying(20),
    sys_nm character varying(300),
    menu_cd character varying(20),
    menu_nm character varying(300),
    cntn_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    sesion_cnt numeric(10,0) DEFAULT 0 NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE cntn_stats_hr_smry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.cntn_stats_hr_smry IS '접속통계시간요약';


-- Name: COLUMN cntn_stats_hr_smry.tot_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.tot_ymd IS '집계일자';


-- Name: COLUMN cntn_stats_hr_smry.hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.hr IS '시간';


-- Name: COLUMN cntn_stats_hr_smry.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.user_id IS '사용자아이디';


-- Name: COLUMN cntn_stats_hr_smry.user_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.user_nm IS '사용자명';


-- Name: COLUMN cntn_stats_hr_smry.dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.dept_cd IS '부서코드';


-- Name: COLUMN cntn_stats_hr_smry.dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.dept_nm IS '부서명';


-- Name: COLUMN cntn_stats_hr_smry.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.sys_cd IS '시스템코드';


-- Name: COLUMN cntn_stats_hr_smry.sys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.sys_nm IS '시스템명';


-- Name: COLUMN cntn_stats_hr_smry.menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.menu_cd IS '메뉴코드';


-- Name: COLUMN cntn_stats_hr_smry.menu_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.menu_nm IS '메뉴명';


-- Name: COLUMN cntn_stats_hr_smry.cntn_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.cntn_cnt IS '접속수';


-- Name: COLUMN cntn_stats_hr_smry.sesion_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.sesion_cnt IS '세션수';


-- Name: COLUMN cntn_stats_hr_smry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN cntn_stats_hr_smry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN cntn_stats_hr_smry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN cntn_stats_hr_smry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.cntn_stats_hr_smry.last_mdfcn_dt IS '최종수정일시';


-- Name: com_cd; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.com_cd (
    cd character varying(20) NOT NULL,
    group_cd character varying(20) NOT NULL,
    cd_nm character varying(100) NOT NULL,
    cd_expln character varying(4000),
    cd_sort_seq numeric(10,0) NOT NULL,
    up_cd character varying(20),
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE com_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.com_cd IS '공통코드';


-- Name: COLUMN com_cd.cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.cd IS '코드';


-- Name: COLUMN com_cd.group_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.group_cd IS '그룹코드';


-- Name: COLUMN com_cd.cd_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.cd_nm IS '코드명';


-- Name: COLUMN com_cd.cd_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.cd_expln IS '코드설명';


-- Name: COLUMN com_cd.cd_sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.cd_sort_seq IS '코드정렬순서';


-- Name: COLUMN com_cd.up_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.up_cd IS '상위코드';


-- Name: COLUMN com_cd.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.use_yn IS '사용여부';


-- Name: COLUMN com_cd.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN com_cd.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN com_cd.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN com_cd.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_cd.last_mdfcn_dt IS '최종수정일시';


-- Name: com_file; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.com_file (
    atch_file_id character varying(30) NOT NULL,
    tmpr_yn character(1) DEFAULT 'N'::bpchar NOT NULL,
    trgt_nm character varying(100),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone DEFAULT now(),
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone DEFAULT now()
);


-- Name: TABLE com_file; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.com_file IS '공통파일';


-- Name: COLUMN com_file.atch_file_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.atch_file_id IS '첨부파일아이디';


-- Name: COLUMN com_file.tmpr_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.tmpr_yn IS '임시여부';


-- Name: COLUMN com_file.trgt_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.trgt_nm IS '대상명';


-- Name: COLUMN com_file.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN com_file.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN com_file.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN com_file.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file.last_mdfcn_dt IS '최종수정일시';


-- Name: com_file_dtl; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.com_file_dtl (
    file_id character varying(30) NOT NULL,
    atch_file_id character varying(30) NOT NULL,
    file_sort_seq numeric(10,0) DEFAULT 1 NOT NULL,
    orgnl_file_nm character varying(300) NOT NULL,
    strg_path_nm character varying(300) NOT NULL,
    strg_file_nm character varying(300) NOT NULL,
    file_sz numeric(14,0) NOT NULL,
    mime_type_nm character varying(100),
    del_yn character(1) DEFAULT 'N'::bpchar NOT NULL,
    del_excn_dt timestamp without time zone,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone DEFAULT now(),
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone DEFAULT now()
);


-- Name: TABLE com_file_dtl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.com_file_dtl IS '공통파일상세';


-- Name: COLUMN com_file_dtl.file_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.file_id IS '파일아이디';


-- Name: COLUMN com_file_dtl.atch_file_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.atch_file_id IS '첨부파일아이디';


-- Name: COLUMN com_file_dtl.file_sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.file_sort_seq IS '파일정렬순서';


-- Name: COLUMN com_file_dtl.orgnl_file_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.orgnl_file_nm IS '원본파일명';


-- Name: COLUMN com_file_dtl.strg_path_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.strg_path_nm IS '저장경로명';


-- Name: COLUMN com_file_dtl.strg_file_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.strg_file_nm IS '저장파일명';


-- Name: COLUMN com_file_dtl.file_sz; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.file_sz IS '파일크기';


-- Name: COLUMN com_file_dtl.mime_type_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.mime_type_nm IS 'MIME유형명';


-- Name: COLUMN com_file_dtl.del_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.del_yn IS '삭제여부';


-- Name: COLUMN com_file_dtl.del_excn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.del_excn_dt IS '삭제수행일시';


-- Name: COLUMN com_file_dtl.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN com_file_dtl.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN com_file_dtl.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN com_file_dtl.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_file_dtl.last_mdfcn_dt IS '최종수정일시';


-- Name: com_group_cd; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.com_group_cd (
    group_cd character varying(20) NOT NULL,
    group_cd_nm character varying(100) NOT NULL,
    group_cd_expln character varying(4000),
    up_group_cd character varying(20),
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE com_group_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.com_group_cd IS '공통그룹코드';


-- Name: COLUMN com_group_cd.group_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.group_cd IS '그룹코드';


-- Name: COLUMN com_group_cd.group_cd_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.group_cd_nm IS '그룹코드명';


-- Name: COLUMN com_group_cd.group_cd_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.group_cd_expln IS '그룹코드설명';


-- Name: COLUMN com_group_cd.up_group_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.up_group_cd IS '상위그룹코드';


-- Name: COLUMN com_group_cd.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.use_yn IS '사용여부';


-- Name: COLUMN com_group_cd.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN com_group_cd.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN com_group_cd.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN com_group_cd.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.com_group_cd.last_mdfcn_dt IS '최종수정일시';


-- Name: dept; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.dept (
    dept_cd character varying(20) NOT NULL,
    dept_stcd character varying(20) NOT NULL,
    dept_nm character varying(200) NOT NULL,
    dept_whol_nm character varying(200) NOT NULL,
    dept_eng_nm character varying(200),
    hghrk_inst_cd character varying(20),
    shghrk_inst_cd character varying(20),
    sfrnd_se_cd character varying(20),
    cycl numeric(7,0),
    rank_no numeric(4,0),
    rprs_telno character varying(11),
    addr character varying(200),
    daddr character varying(200),
    hmpg_url_addr character varying(2000),
    fxno character varying(20),
    eml_addr character varying(320),
    tmpr_ognz_yn character(1),
    vr_ognz_tr_yn character(1),
    vr_ognz_tr_up_cd character varying(20),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE dept; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.dept IS '부서';


-- Name: COLUMN dept.dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.dept_cd IS '부서코드';


-- Name: COLUMN dept.dept_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.dept_stcd IS '부서상태코드';


-- Name: COLUMN dept.dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.dept_nm IS '부서명';


-- Name: COLUMN dept.dept_whol_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.dept_whol_nm IS '부서전체명';


-- Name: COLUMN dept.dept_eng_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.dept_eng_nm IS '부서영문명';


-- Name: COLUMN dept.hghrk_inst_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.hghrk_inst_cd IS '최상위기관코드';


-- Name: COLUMN dept.shghrk_inst_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.shghrk_inst_cd IS '차상위기관코드';


-- Name: COLUMN dept.sfrnd_se_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.sfrnd_se_cd IS '자치단체구분코드';


-- Name: COLUMN dept.cycl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.cycl IS '차수';


-- Name: COLUMN dept.rank_no; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.rank_no IS '랭크번호';


-- Name: COLUMN dept.rprs_telno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.rprs_telno IS '대표전화번호';


-- Name: COLUMN dept.addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.addr IS '주소';


-- Name: COLUMN dept.daddr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.daddr IS '상세주소';


-- Name: COLUMN dept.hmpg_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.hmpg_url_addr IS '홈페이지URL주소';


-- Name: COLUMN dept.fxno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.fxno IS '팩스번호';


-- Name: COLUMN dept.eml_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.eml_addr IS '이메일주소';


-- Name: COLUMN dept.tmpr_ognz_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.tmpr_ognz_yn IS '임시조직여부';


-- Name: COLUMN dept.vr_ognz_tr_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.vr_ognz_tr_yn IS '가상조직트리여부';


-- Name: COLUMN dept.vr_ognz_tr_up_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.vr_ognz_tr_up_cd IS '가상조직트리상위코드';


-- Name: COLUMN dept.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN dept.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN dept.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN dept.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.dept.last_mdfcn_dt IS '최종수정일시';


-- Name: link; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.link (
    link_id character varying(50) NOT NULL,
    link_group_nm character varying(200),
    link_nm character varying(200) NOT NULL,
    link_type_cd character varying(20) NOT NULL,
    pvsn_inst_nm character varying(200),
    pvsn_sys_nm character varying(200) NOT NULL,
    cycle_cd character varying(20) NOT NULL,
    last_link_stcd character varying(20) NOT NULL,
    utztn_sys_nm character varying(200),
    use_yn character(1) NOT NULL,
    link_drc_cd character varying(20),
    lnkg_mth_cd character varying(20),
    lnkg_addr character varying(2000),
    cert_nm character varying(200),
    lnkg_trgt_nm character varying(200),
    rmrk_cn character varying(4000),
    hopr_psblty_yn character(1) NOT NULL,
    hopr_type_cd character varying(20),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE link; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.link IS '연계';


-- Name: COLUMN link.link_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.link_id IS '연계아이디';


-- Name: COLUMN link.link_group_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.link_group_nm IS '연계그룹코드';


-- Name: COLUMN link.link_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.link_nm IS '연계명';


-- Name: COLUMN link.link_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.link_type_cd IS '연계유형코드';


-- Name: COLUMN link.pvsn_inst_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.pvsn_inst_nm IS '제공기관명';


-- Name: COLUMN link.pvsn_sys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.pvsn_sys_nm IS '제공시스템명';


-- Name: COLUMN link.cycle_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.cycle_cd IS '주기코드';


-- Name: COLUMN link.last_link_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.last_link_stcd IS '최종연계상태코드';


-- Name: COLUMN link.utztn_sys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.utztn_sys_nm IS '이용시스템명';


-- Name: COLUMN link.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.use_yn IS '사용여부';


-- Name: COLUMN link.link_drc_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.link_drc_cd IS '연계방향코드';


-- Name: COLUMN link.lnkg_mth_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.lnkg_mth_cd IS '연결방식코드';


-- Name: COLUMN link.lnkg_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.lnkg_addr IS '연결주소';


-- Name: COLUMN link.cert_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.cert_nm IS '인증명';


-- Name: COLUMN link.lnkg_trgt_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.lnkg_trgt_nm IS '연결대상명';


-- Name: COLUMN link.rmrk_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.rmrk_cn IS '비고내용';


-- Name: COLUMN link.hopr_psblty_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.hopr_psblty_yn IS '수동가능여부';


-- Name: COLUMN link.hopr_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.hopr_type_cd IS '수동유형코드';


-- Name: COLUMN link.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN link.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN link.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN link.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link.last_mdfcn_dt IS '최종수정일시';


-- Name: link_data_hopr_hstry; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.link_data_hopr_hstry (
    hstry_sn numeric(20,0) NOT NULL,
    prcs_dt timestamp without time zone NOT NULL,
    atch_file_id character varying(50),
    hopr_type_cd character varying(20) NOT NULL,
    prcs_nocs numeric(10,0) DEFAULT 0 NOT NULL,
    prcs_stcd character varying(20) NOT NULL,
    rmrk_cn character varying(4000),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE link_data_hopr_hstry; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.link_data_hopr_hstry IS '연계데이터수동이력';


-- Name: COLUMN link_data_hopr_hstry.hstry_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.hstry_sn IS '이력일련번호';


-- Name: COLUMN link_data_hopr_hstry.prcs_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.prcs_dt IS '처리일시';


-- Name: COLUMN link_data_hopr_hstry.atch_file_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.atch_file_id IS '첨부파일아이디';


-- Name: COLUMN link_data_hopr_hstry.hopr_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.hopr_type_cd IS '수동유형코드';


-- Name: COLUMN link_data_hopr_hstry.prcs_nocs; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.prcs_nocs IS '처리건수';


-- Name: COLUMN link_data_hopr_hstry.prcs_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.prcs_stcd IS '처리상태코드';


-- Name: COLUMN link_data_hopr_hstry.rmrk_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.rmrk_cn IS '비고내용';


-- Name: COLUMN link_data_hopr_hstry.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN link_data_hopr_hstry.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN link_data_hopr_hstry.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN link_data_hopr_hstry.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_data_hopr_hstry.last_mdfcn_dt IS '최종수정일시';


-- Name: link_metdata; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.link_metdata (
    metdata_sn numeric(22,0) NOT NULL,
    link_id character varying(50) NOT NULL,
    sort_seq numeric(10,0) DEFAULT 0 NOT NULL,
    metdata_nm character varying(300) NOT NULL,
    metdata_expln character varying(4000),
    metdata_ty_nm character varying(100) NOT NULL,
    metdata_len_cnt numeric(10,0),
    metdata_esntl_yn character(1) NOT NULL,
    metdata_dflt_nm character varying(300),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE link_metdata; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.link_metdata IS '연계메타데이터';


-- Name: COLUMN link_metdata.metdata_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_sn IS '메타데이터일련번호';


-- Name: COLUMN link_metdata.link_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.link_id IS '연계아이디';


-- Name: COLUMN link_metdata.sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.sort_seq IS '정렬순서';


-- Name: COLUMN link_metdata.metdata_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_nm IS '메타데이터명';


-- Name: COLUMN link_metdata.metdata_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_expln IS '메타데이터설명';


-- Name: COLUMN link_metdata.metdata_ty_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_ty_nm IS '메타데이터타입명';


-- Name: COLUMN link_metdata.metdata_len_cnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_len_cnt IS '메타데이터길이수';


-- Name: COLUMN link_metdata.metdata_esntl_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_esntl_yn IS '메타데이터필수여부';


-- Name: COLUMN link_metdata.metdata_dflt_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.metdata_dflt_nm IS '메타데이터디폴트명';


-- Name: COLUMN link_metdata.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN link_metdata.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN link_metdata.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN link_metdata.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata.last_mdfcn_dt IS '최종수정일시';


-- Name: link_metdata_dmnd; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.link_metdata_dmnd (
    link_metdata_dmnd_sn numeric(20,0) NOT NULL,
    link_id character varying(50) NOT NULL,
    link_type_cd character varying(20) NOT NULL,
    dmnd_type_cd character varying(20) NOT NULL,
    dmnd_key_nm character varying(300) NOT NULL,
    dmnd_vl_nm character varying(300),
    dmnd_ty_nm character varying(100),
    dmnd_esntl_yn character(1) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE link_metdata_dmnd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.link_metdata_dmnd IS '연계메타데이터요청';


-- Name: COLUMN link_metdata_dmnd.link_metdata_dmnd_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.link_metdata_dmnd_sn IS '연계메타데이터요청일련번호';


-- Name: COLUMN link_metdata_dmnd.link_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.link_id IS '연계아이디';


-- Name: COLUMN link_metdata_dmnd.link_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.link_type_cd IS '연계유형코드';


-- Name: COLUMN link_metdata_dmnd.dmnd_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.dmnd_type_cd IS '요청유형코드';


-- Name: COLUMN link_metdata_dmnd.dmnd_key_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.dmnd_key_nm IS '요청키명';


-- Name: COLUMN link_metdata_dmnd.dmnd_vl_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.dmnd_vl_nm IS '요청값명';


-- Name: COLUMN link_metdata_dmnd.dmnd_ty_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.dmnd_ty_nm IS '요청타입명';


-- Name: COLUMN link_metdata_dmnd.dmnd_esntl_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.dmnd_esntl_yn IS '요청필수여부';


-- Name: COLUMN link_metdata_dmnd.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN link_metdata_dmnd.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN link_metdata_dmnd.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN link_metdata_dmnd.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.link_metdata_dmnd.last_mdfcn_dt IS '최종수정일시';


-- Name: map_srvc; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.map_srvc (
    map_srvc_sn numeric(20,0) NOT NULL,
    srvc_nm character varying(300) NOT NULL,
    lyr_nm character varying(300) NOT NULL,
    lyr_expln character varying(4000),
    phys_nm character varying(300) NOT NULL,
    srvc_prefix_nm character varying(100),
    lyr_group_cd character varying(20) NOT NULL,
    lclsf_cd character varying(20),
    mclsf_cd character varying(20),
    sclsf_cd character varying(20),
    cntm_nm character varying(100),
    spce_type_nm character varying(100),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE map_srvc; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.map_srvc IS '지도서비스';


-- Name: COLUMN map_srvc.map_srvc_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.map_srvc_sn IS 'MAP서비스일련번호';


-- Name: COLUMN map_srvc.srvc_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.srvc_nm IS '서비스명';


-- Name: COLUMN map_srvc.lyr_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.lyr_nm IS '레이어명';


-- Name: COLUMN map_srvc.lyr_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.lyr_expln IS '레이어설명';


-- Name: COLUMN map_srvc.phys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.phys_nm IS '물리명';


-- Name: COLUMN map_srvc.srvc_prefix_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.srvc_prefix_nm IS '서비스프리픽스명';


-- Name: COLUMN map_srvc.lyr_group_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.lyr_group_cd IS '레이어그룹코드';


-- Name: COLUMN map_srvc.lclsf_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.lclsf_cd IS '대분류코드';


-- Name: COLUMN map_srvc.mclsf_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.mclsf_cd IS '중분류코드';


-- Name: COLUMN map_srvc.sclsf_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.sclsf_cd IS '소분류코드';


-- Name: COLUMN map_srvc.cntm_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.cntm_nm IS '좌표계명';


-- Name: COLUMN map_srvc.spce_type_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.spce_type_nm IS '공간유형명';


-- Name: COLUMN map_srvc.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN map_srvc.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN map_srvc.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN map_srvc.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.map_srvc.last_mdfcn_dt IS '최종수정일시';


-- Name: menu; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.menu (
    sys_cd character varying(20) NOT NULL,
    menu_cd character varying(20) NOT NULL,
    menu_nm character varying(100) NOT NULL,
    menu_expln character varying(4000),
    up_menu_cd character varying(20),
    menu_sort_seq numeric(10,0) NOT NULL,
    icon_path_nm character varying(300),
    menu_url_addr character varying(2000),
    popup_yn character(1) DEFAULT 'N'::bpchar,
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL,
    menu_etc_url_addr character varying(2000)
);


-- Name: TABLE menu; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.menu IS '메뉴';


-- Name: COLUMN menu.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.sys_cd IS '시스템코드';


-- Name: COLUMN menu.menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_cd IS '메뉴코드';


-- Name: COLUMN menu.menu_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_nm IS '메뉴명';


-- Name: COLUMN menu.menu_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_expln IS '메뉴설명';


-- Name: COLUMN menu.up_menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.up_menu_cd IS '상위메뉴코드';


-- Name: COLUMN menu.menu_sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_sort_seq IS '메뉴정렬순서';


-- Name: COLUMN menu.icon_path_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.icon_path_nm IS '아이콘경로명';


-- Name: COLUMN menu.menu_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_url_addr IS '메뉴URL주소';


-- Name: COLUMN menu.popup_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.popup_yn IS '팝업여부';


-- Name: COLUMN menu.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.use_yn IS '사용여부';


-- Name: COLUMN menu.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN menu.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN menu.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN menu.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.last_mdfcn_dt IS '최종수정일시';


-- Name: COLUMN menu.menu_etc_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu.menu_etc_url_addr IS '메뉴기타URL주소';


-- Name: menu_role_authrt_mpng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.menu_role_authrt_mpng (
    menu_cd character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    authrt_cd character varying(100) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE menu_role_authrt_mpng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.menu_role_authrt_mpng IS '메뉴역할권한매핑';


-- Name: COLUMN menu_role_authrt_mpng.menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.menu_cd IS '메뉴코드';


-- Name: COLUMN menu_role_authrt_mpng.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.role_cd IS '역할코드';


-- Name: COLUMN menu_role_authrt_mpng.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.authrt_cd IS '권한코드';


-- Name: COLUMN menu_role_authrt_mpng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN menu_role_authrt_mpng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN menu_role_authrt_mpng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN menu_role_authrt_mpng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.menu_role_authrt_mpng.last_mdfcn_dt IS '최종수정일시';


-- Name: role; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.role (
    role_cd character varying(100) NOT NULL,
    role_nm character varying(200) NOT NULL,
    role_expln character varying(4000),
    role_type_cd character varying(20) NOT NULL,
    up_role_cd character varying(100),
    role_sort_seq numeric(10,0) NOT NULL,
    sys_cd character varying(20),
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE role; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.role IS '역할';


-- Name: COLUMN role.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.role_cd IS '역할코드';


-- Name: COLUMN role.role_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.role_nm IS '역할명';


-- Name: COLUMN role.role_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.role_expln IS '역할설명';


-- Name: COLUMN role.role_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.role_type_cd IS '역할유형코드';


-- Name: COLUMN role.up_role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.up_role_cd IS '상위역할코드';


-- Name: COLUMN role.role_sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.role_sort_seq IS '역할정렬순서';


-- Name: COLUMN role.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.sys_cd IS '시스템코드';


-- Name: COLUMN role.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.use_yn IS '사용여부';


-- Name: COLUMN role.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN role.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN role.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN role.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.role.last_mdfcn_dt IS '최종수정일시';


-- Name: srvy; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.srvy (
    srvy_sn numeric(20,0) NOT NULL,
    srvy_ttl character varying(500) NOT NULL,
    srvy_prps character varying(1000),
    gd_cn character varying(4000),
    trgt_type character varying(100),
    srvy_bgng_ymd character(8) NOT NULL,
    srvy_end_ymd character(8) NOT NULL,
    srvy_url_addr character varying(500),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE srvy; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.srvy IS '설문';


-- Name: COLUMN srvy.srvy_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_sn IS '설문일련번호';


-- Name: COLUMN srvy.srvy_ttl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_ttl IS '설문제목';


-- Name: COLUMN srvy.srvy_prps; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_prps IS '설문목적';


-- Name: COLUMN srvy.gd_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.gd_cn IS '안내내용';


-- Name: COLUMN srvy.trgt_type; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.trgt_type IS '대상유형';


-- Name: COLUMN srvy.srvy_bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_bgng_ymd IS '설문시작일자';


-- Name: COLUMN srvy.srvy_end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_end_ymd IS '설문종료일자';


-- Name: COLUMN srvy.srvy_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.srvy_url_addr IS '설문URL주소';


-- Name: COLUMN srvy.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN srvy.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN srvy.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN srvy.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy.last_mdfcn_dt IS '최종수정일시';


-- Name: srvy_qitem; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.srvy_qitem (
    qitem_sn numeric(20,0) NOT NULL,
    srvy_sn numeric(20,0) NOT NULL,
    esntl_yn character(1) NOT NULL,
    sort_seq numeric(10,0) DEFAULT 1 NOT NULL,
    qitem_type_cd character varying(20) NOT NULL,
    qitem_cn character varying(4000) NOT NULL,
    max_chc_co numeric(10,0) DEFAULT 1,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE srvy_qitem; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.srvy_qitem IS '설문문항';


-- Name: COLUMN srvy_qitem.qitem_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.qitem_sn IS '문항일련번호';


-- Name: COLUMN srvy_qitem.srvy_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.srvy_sn IS '설문일련번호';


-- Name: COLUMN srvy_qitem.esntl_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.esntl_yn IS '필수여부';


-- Name: COLUMN srvy_qitem.sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.sort_seq IS '정렬순서';


-- Name: COLUMN srvy_qitem.qitem_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.qitem_type_cd IS '문항유형코드';


-- Name: COLUMN srvy_qitem.qitem_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.qitem_cn IS '문항내용';


-- Name: COLUMN srvy_qitem.max_chc_co; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.max_chc_co IS '최대선택개수';


-- Name: COLUMN srvy_qitem.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN srvy_qitem.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN srvy_qitem.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN srvy_qitem.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem.last_mdfcn_dt IS '최종수정일시';


-- Name: srvy_qitem_artcl; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.srvy_qitem_artcl (
    artcl_sn numeric(20,0) NOT NULL,
    srvy_sn numeric(20,0) NOT NULL,
    qitem_sn numeric(20,0) NOT NULL,
    etc_ans_yn character(1) NOT NULL,
    sort_seq numeric(10,0) DEFAULT 1 NOT NULL,
    artcl_cn character varying(4000) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE srvy_qitem_artcl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.srvy_qitem_artcl IS '설문문항항목';


-- Name: COLUMN srvy_qitem_artcl.artcl_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.artcl_sn IS '항목일련번호';


-- Name: COLUMN srvy_qitem_artcl.srvy_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.srvy_sn IS '설문일련번호';


-- Name: COLUMN srvy_qitem_artcl.qitem_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.qitem_sn IS '문항일련번호';


-- Name: COLUMN srvy_qitem_artcl.etc_ans_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.etc_ans_yn IS '기타답변여부';


-- Name: COLUMN srvy_qitem_artcl.sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.sort_seq IS '정렬순서';


-- Name: COLUMN srvy_qitem_artcl.artcl_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.artcl_cn IS '항목내용';


-- Name: COLUMN srvy_qitem_artcl.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN srvy_qitem_artcl.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN srvy_qitem_artcl.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN srvy_qitem_artcl.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_qitem_artcl.last_mdfcn_dt IS '최종수정일시';


-- Name: srvy_rspdnt; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.srvy_rspdnt (
    rspdnt_sn numeric(20,0) NOT NULL,
    srvy_sn numeric(20,0) NOT NULL,
    rspdnt_id character varying(50) NOT NULL,
    rspdnt_nm character varying(300),
    gndr_cd character varying(20),
    agrde_cd character varying(20),
    dept_cd character varying(20),
    jbgd_cd character varying(20),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE srvy_rspdnt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.srvy_rspdnt IS '설문응답자';


-- Name: COLUMN srvy_rspdnt.rspdnt_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.rspdnt_sn IS '응답자일련번호';


-- Name: COLUMN srvy_rspdnt.srvy_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.srvy_sn IS '설문일련번호';


-- Name: COLUMN srvy_rspdnt.rspdnt_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.rspdnt_id IS '음답자아이디';


-- Name: COLUMN srvy_rspdnt.rspdnt_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.rspdnt_nm IS '응답자명';


-- Name: COLUMN srvy_rspdnt.gndr_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.gndr_cd IS '성별코드';


-- Name: COLUMN srvy_rspdnt.agrde_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.agrde_cd IS '연령대코드';


-- Name: COLUMN srvy_rspdnt.dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.dept_cd IS '부서코드';


-- Name: COLUMN srvy_rspdnt.jbgd_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.jbgd_cd IS '직급코드';


-- Name: COLUMN srvy_rspdnt.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN srvy_rspdnt.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN srvy_rspdnt.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN srvy_rspdnt.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspdnt.last_mdfcn_dt IS '최종수정일시';


-- Name: srvy_rspns; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.srvy_rspns (
    rspns_sn numeric(20,0) NOT NULL,
    srvy_sn numeric(20,0) NOT NULL,
    qitem_sn numeric(20,0) NOT NULL,
    rspdnt_sn numeric(20,0) NOT NULL,
    artcl_sn numeric(20,0),
    rspns_cn character varying(4000),
    etc_rspns_cn character varying(4000),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE srvy_rspns; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.srvy_rspns IS '설문응답';


-- Name: COLUMN srvy_rspns.rspns_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.rspns_sn IS '응답일련번호';


-- Name: COLUMN srvy_rspns.srvy_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.srvy_sn IS '설문일련번호';


-- Name: COLUMN srvy_rspns.qitem_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.qitem_sn IS '문항일련번호';


-- Name: COLUMN srvy_rspns.rspdnt_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.rspdnt_sn IS '응답자일련번호';


-- Name: COLUMN srvy_rspns.artcl_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.artcl_sn IS '항목일련번호';


-- Name: COLUMN srvy_rspns.rspns_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.rspns_cn IS '응답내용';


-- Name: COLUMN srvy_rspns.etc_rspns_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.etc_rspns_cn IS '기타 응답 내용';


-- Name: COLUMN srvy_rspns.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN srvy_rspns.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN srvy_rspns.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN srvy_rspns.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.srvy_rspns.last_mdfcn_dt IS '최종수정일시';


-- Name: sys; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.sys (
    sys_cd character varying(20) NOT NULL,
    sys_nm character varying(200) NOT NULL,
    sys_expln character varying(4000),
    sys_url_addr character varying(2000),
    use_bgng_ymd date,
    use_end_ymd date,
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE sys; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.sys IS '시스템';


-- Name: COLUMN sys.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.sys_cd IS '시스템코드';


-- Name: COLUMN sys.sys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.sys_nm IS '시스템명';


-- Name: COLUMN sys.sys_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.sys_expln IS '시스템설명';


-- Name: COLUMN sys.sys_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.sys_url_addr IS '시스템URL주소';


-- Name: COLUMN sys.use_bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.use_bgng_ymd IS '사용시작일자';


-- Name: COLUMN sys.use_end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.use_end_ymd IS '사용종료일자';


-- Name: COLUMN sys.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.use_yn IS '사용여부';


-- Name: COLUMN sys.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN sys.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN sys.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN sys.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys.last_mdfcn_dt IS '최종수정일시';


-- Name: sys_role_authrt_mpng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.sys_role_authrt_mpng (
    sys_cd character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    authrt_cd character varying(100) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE sys_role_authrt_mpng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.sys_role_authrt_mpng IS '시스템역할권한매핑';


-- Name: COLUMN sys_role_authrt_mpng.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.sys_cd IS '시스템코드';


-- Name: COLUMN sys_role_authrt_mpng.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.role_cd IS '역할코드';


-- Name: COLUMN sys_role_authrt_mpng.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.authrt_cd IS '권한코드';


-- Name: COLUMN sys_role_authrt_mpng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN sys_role_authrt_mpng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN sys_role_authrt_mpng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN sys_role_authrt_mpng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.sys_role_authrt_mpng.last_mdfcn_dt IS '최종수정일시';


-- Name: tmap; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.tmap (
    tmap_sn numeric(20,0) NOT NULL,
    tmap_nm character varying(300) NOT NULL,
    tmap_url_addr character varying(500),
    tmap_expln character varying(4000),
    bgng_ymd character(8),
    end_ymd character(8),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);


-- Name: TABLE tmap; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.tmap IS '주제도';


-- Name: COLUMN tmap.tmap_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.tmap_sn IS '주제도일련번호';


-- Name: COLUMN tmap.tmap_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.tmap_nm IS '주제도명';


-- Name: COLUMN tmap.tmap_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.tmap_url_addr IS '주제도URL주소';


-- Name: COLUMN tmap.tmap_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.tmap_expln IS '주제도설명';


-- Name: COLUMN tmap.bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.bgng_ymd IS '시작일자';


-- Name: COLUMN tmap.end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.end_ymd IS '종료일자';


-- Name: COLUMN tmap.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN tmap.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN tmap.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN tmap.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmap.last_mdfcn_dt IS '최종수정일시';


-- Name: tmpr_user_authrt; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.tmpr_user_authrt (
    user_id character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    role_bgng_ymd date,
    role_end_ymd date,
    aplcn_rsn character varying(4000),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE tmpr_user_authrt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.tmpr_user_authrt IS '임시사용자권한';


-- Name: COLUMN tmpr_user_authrt.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.user_id IS '사용자아이디';


-- Name: COLUMN tmpr_user_authrt.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.role_cd IS '역할코드';


-- Name: COLUMN tmpr_user_authrt.role_bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.role_bgng_ymd IS '역할시작일자';


-- Name: COLUMN tmpr_user_authrt.role_end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.role_end_ymd IS '역할종료일자';


-- Name: COLUMN tmpr_user_authrt.aplcn_rsn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.aplcn_rsn IS '적용사유';


-- Name: COLUMN tmpr_user_authrt.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN tmpr_user_authrt.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN tmpr_user_authrt.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN tmpr_user_authrt.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt.last_mdfcn_dt IS '최종수정일시';


-- Name: tmpr_user_authrt_menu_mpng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.tmpr_user_authrt_menu_mpng (
    user_id character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    authrt_cd character varying(100) NOT NULL,
    menu_cd character varying(20) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE tmpr_user_authrt_menu_mpng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.tmpr_user_authrt_menu_mpng IS '임시사용자권한메뉴매핑';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.user_id IS '사용자아이디';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.role_cd IS '역할코드';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.authrt_cd IS '권한코드';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.menu_cd IS '메뉴코드';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN tmpr_user_authrt_menu_mpng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_menu_mpng.last_mdfcn_dt IS '최종수정일시';


-- Name: tmpr_user_authrt_sys_mpng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.tmpr_user_authrt_sys_mpng (
    user_id character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    authrt_cd character varying(100) NOT NULL,
    sys_cd character varying(20) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE tmpr_user_authrt_sys_mpng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.tmpr_user_authrt_sys_mpng IS '임시사용자권한시스템매핑';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.user_id IS '사용자아이디';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.role_cd IS '역할코드';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.authrt_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.authrt_cd IS '권한코드';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.sys_cd IS '시스템코드';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN tmpr_user_authrt_sys_mpng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.tmpr_user_authrt_sys_mpng.last_mdfcn_dt IS '최종수정일시';


-- Name: trms; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.trms (
    trms_sn numeric(22,0) NOT NULL,
    sys_cd character varying(20),
    trms_ttl character varying(200) NOT NULL,
    trms_type_cd character varying(20) NOT NULL,
    trms_sort_seq numeric(10,0) NOT NULL,
    trms_ver character varying(20) NOT NULL,
    trms_expln character varying(4000),
    trms_cn text NOT NULL,
    esntl_yn character(1) NOT NULL,
    re_agre_yn character(1) NOT NULL,
    trms_stcd character varying(20) NOT NULL,
    use_yn character(1) DEFAULT 'Y'::bpchar NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE trms; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.trms IS '약관';


-- Name: COLUMN trms.trms_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_sn IS '약관일련번호';


-- Name: COLUMN trms.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.sys_cd IS '시스템코드';


-- Name: COLUMN trms.trms_ttl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_ttl IS '약관제목';


-- Name: COLUMN trms.trms_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_type_cd IS '약관유형코드';


-- Name: COLUMN trms.trms_sort_seq; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_sort_seq IS '약관정렬순서';


-- Name: COLUMN trms.trms_ver; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_ver IS '약관버전';


-- Name: COLUMN trms.trms_expln; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_expln IS '약관설명';


-- Name: COLUMN trms.trms_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_cn IS '약관내용';


-- Name: COLUMN trms.esntl_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.esntl_yn IS '필수여부';


-- Name: COLUMN trms.re_agre_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.re_agre_yn IS '재동의여부';


-- Name: COLUMN trms.trms_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.trms_stcd IS '약관상태코드';


-- Name: COLUMN trms.use_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.use_yn IS '사용여부';


-- Name: COLUMN trms.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN trms.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN trms.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN trms.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms.last_mdfcn_dt IS '최종수정일시';


-- Name: trms_agre; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.trms_agre (
    trms_agre_sn numeric(22,0) DEFAULT nextval('iccom.seq_trms_agre_sn'::regclass) NOT NULL,
    trms_sn numeric(22,0) NOT NULL,
    user_id character varying(20) NOT NULL,
    trms_ver character varying(20) NOT NULL,
    agre_dt timestamp without time zone,
    agre_yn character(1),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE trms_agre; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.trms_agre IS '약관동의';


-- Name: COLUMN trms_agre.trms_agre_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.trms_agre_sn IS '약관동의일련번호';


-- Name: COLUMN trms_agre.trms_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.trms_sn IS '약관일련번호';


-- Name: COLUMN trms_agre.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.user_id IS '사용자아이디';


-- Name: COLUMN trms_agre.trms_ver; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.trms_ver IS '약관버전';


-- Name: COLUMN trms_agre.agre_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.agre_dt IS '동의일시';


-- Name: COLUMN trms_agre.agre_yn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.agre_yn IS '동의여부';


-- Name: COLUMN trms_agre.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN trms_agre.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN trms_agre.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN trms_agre.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.trms_agre.last_mdfcn_dt IS '최종수정일시';


-- Name: user; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom."user" (
    user_unq_id character varying(20) NOT NULL,
    user_id character varying(20) NOT NULL,
    user_stcd character varying(20) NOT NULL,
    user_nm character varying(100) NOT NULL,
    user_eng_nm character varying(100),
    user_whol_nm character varying(200),
    emp_no character varying(20),
    dept_cd character varying(20) NOT NULL,
    dept_nm character varying(200) NOT NULL,
    dept_whol_nm character varying(200),
    jbgd_cd character varying(20) NOT NULL,
    jbgd_nm character varying(100) NOT NULL,
    jbps_cd character varying(20),
    jbps_nm character varying(100),
    jbttl_nm character varying(100),
    gndr_cd character varying(20) NOT NULL,
    brdt character(8),
    rank_no numeric(4,0),
    hghrk_inst_cd character varying(20),
    shghrk_inst_cd character varying(20),
    work_type_cd character varying(20),
    etc_dept_nm character varying(200),
    etc_dept_cd character varying(20),
    vhrno character varying(100),
    cn character varying(100),
    photo_path_nm character varying(300),
    ofc_telno character varying(11),
    ofc_fxno character varying(20),
    tkcg_task_cn character varying(4000),
    eml_addr character varying(320),
    otsd_eml_addr character varying(320),
    mbl_telno character varying(11),
    hmpg_url_addr character varying(2000),
    house_telno character varying(11),
    house_addr character varying(200),
    house_daddr character varying(200),
    mrg_ymd date,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE "user"; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom."user" IS '사용자';


-- Name: COLUMN "user".user_unq_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_unq_id IS '사용자고유아이디';


-- Name: COLUMN "user".user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_id IS '사용자아이디';


-- Name: COLUMN "user".user_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_stcd IS '사용자상태코드';


-- Name: COLUMN "user".user_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_nm IS '사용자명';


-- Name: COLUMN "user".user_eng_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_eng_nm IS '사용자영문명';


-- Name: COLUMN "user".user_whol_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".user_whol_nm IS '사용자전체명';


-- Name: COLUMN "user".emp_no; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".emp_no IS '사원번호';


-- Name: COLUMN "user".dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".dept_cd IS '부서코드';


-- Name: COLUMN "user".dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".dept_nm IS '부서명';


-- Name: COLUMN "user".dept_whol_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".dept_whol_nm IS '부서전체명';


-- Name: COLUMN "user".jbgd_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".jbgd_cd IS '직급코드';


-- Name: COLUMN "user".jbgd_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".jbgd_nm IS '직급명';


-- Name: COLUMN "user".jbps_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".jbps_cd IS '직위코드';


-- Name: COLUMN "user".jbps_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".jbps_nm IS '직위명';


-- Name: COLUMN "user".jbttl_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".jbttl_nm IS '직책명';


-- Name: COLUMN "user".gndr_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".gndr_cd IS '성별코드';


-- Name: COLUMN "user".brdt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".brdt IS '생년월일';


-- Name: COLUMN "user".rank_no; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".rank_no IS '랭크번호';


-- Name: COLUMN "user".hghrk_inst_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".hghrk_inst_cd IS '최상위기관코드';


-- Name: COLUMN "user".shghrk_inst_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".shghrk_inst_cd IS '차상위기관코드';


-- Name: COLUMN "user".work_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".work_type_cd IS '근무유형코드';


-- Name: COLUMN "user".etc_dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".etc_dept_nm IS '기타부서명';


-- Name: COLUMN "user".etc_dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".etc_dept_cd IS '기타부서코드';


-- Name: COLUMN "user".vhrno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".vhrno IS '차량번호';


-- Name: COLUMN "user".cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".cn IS 'CN';


-- Name: COLUMN "user".photo_path_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".photo_path_nm IS '사진경로명';


-- Name: COLUMN "user".ofc_telno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".ofc_telno IS '사무실전화번호';


-- Name: COLUMN "user".ofc_fxno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".ofc_fxno IS '사무실팩스번호';


-- Name: COLUMN "user".tkcg_task_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".tkcg_task_cn IS '담당업무내용';


-- Name: COLUMN "user".eml_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".eml_addr IS '이메일주소';


-- Name: COLUMN "user".otsd_eml_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".otsd_eml_addr IS '외부이메일주소';


-- Name: COLUMN "user".mbl_telno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".mbl_telno IS '휴대전화번호';


-- Name: COLUMN "user".hmpg_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".hmpg_url_addr IS '홈페이지URL주소';


-- Name: COLUMN "user".house_telno; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".house_telno IS '집전화번호';


-- Name: COLUMN "user".house_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".house_addr IS '집주소';


-- Name: COLUMN "user".house_daddr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".house_daddr IS '집상세주소';


-- Name: COLUMN "user".mrg_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".mrg_ymd IS '결혼일자';


-- Name: COLUMN "user".frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".frst_reg_id IS '최초등록아이디';


-- Name: COLUMN "user".frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".frst_reg_dt IS '최초등록일시';


-- Name: COLUMN "user".last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN "user".last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom."user".last_mdfcn_dt IS '최종수정일시';


-- Name: user_page_strg; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.user_page_strg (
    user_id character varying(20) NOT NULL,
    page_cd character varying(20) NOT NULL,
    page_strg_cn character varying(4000),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE user_page_strg; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.user_page_strg IS '사용자페이지설정';


-- Name: COLUMN user_page_strg.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.user_id IS '사용자아이디';


-- Name: COLUMN user_page_strg.page_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.page_cd IS '페이지코드';


-- Name: COLUMN user_page_strg.page_strg_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.page_strg_cn IS '페이지저장내용';


-- Name: COLUMN user_page_strg.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN user_page_strg.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN user_page_strg.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN user_page_strg.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_page_strg.last_mdfcn_dt IS '최종수정일시';


-- Name: user_role_aply_dtl; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.user_role_aply_dtl (
    aply_dtl_sn numeric(22,0) NOT NULL,
    aply_sn numeric(22,0) NOT NULL,
    aplcn_user_id character varying(20) NOT NULL,
    sys_cd character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE user_role_aply_dtl; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.user_role_aply_dtl IS '사용자역할신청상세';


-- Name: COLUMN user_role_aply_dtl.aply_dtl_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.aply_dtl_sn IS '신청상세일련번호';


-- Name: COLUMN user_role_aply_dtl.aply_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.aply_sn IS '신청일련번호';


-- Name: COLUMN user_role_aply_dtl.aplcn_user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.aplcn_user_id IS '적용사용자아이디';


-- Name: COLUMN user_role_aply_dtl.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.sys_cd IS '시스템코드';


-- Name: COLUMN user_role_aply_dtl.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.role_cd IS '역할코드';


-- Name: COLUMN user_role_aply_dtl.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN user_role_aply_dtl.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN user_role_aply_dtl.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN user_role_aply_dtl.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_dtl.last_mdfcn_dt IS '최종수정일시';


-- Name: user_role_aply_mst; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.user_role_aply_mst (
    aply_sn numeric(22,0) NOT NULL,
    aply_stcd character varying(20) NOT NULL,
    sys_cd character varying(20) NOT NULL,
    aplcn_user_id character varying(20) NOT NULL,
    rvw_user_id character varying(20),
    grnt_type_cd character varying(20) NOT NULL,
    atch_file_id character varying(30),
    aply_dt timestamp without time zone,
    aprv_dt timestamp without time zone,
    aply_rsn character varying(4000),
    rvw_opnn_cn character varying(4000),
    aply_bgng_ymd date,
    aply_end_ymd date,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE user_role_aply_mst; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.user_role_aply_mst IS '사용자역할신청마스터';


-- Name: COLUMN user_role_aply_mst.aply_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_sn IS '신청일련번호';


-- Name: COLUMN user_role_aply_mst.aply_stcd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_stcd IS '신청상태코드';


-- Name: COLUMN user_role_aply_mst.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.sys_cd IS '시스템코드';


-- Name: COLUMN user_role_aply_mst.aplcn_user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aplcn_user_id IS '적용사용자아이디';


-- Name: COLUMN user_role_aply_mst.rvw_user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.rvw_user_id IS '검토사용자아이디';


-- Name: COLUMN user_role_aply_mst.grnt_type_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.grnt_type_cd IS '부여유형코드';


-- Name: COLUMN user_role_aply_mst.atch_file_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.atch_file_id IS '첨부파일아이디';


-- Name: COLUMN user_role_aply_mst.aply_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_dt IS '신청일시';


-- Name: COLUMN user_role_aply_mst.aprv_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aprv_dt IS '승인일시';


-- Name: COLUMN user_role_aply_mst.aply_rsn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_rsn IS '신청사유';


-- Name: COLUMN user_role_aply_mst.rvw_opnn_cn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.rvw_opnn_cn IS '검토의견내용';


-- Name: COLUMN user_role_aply_mst.aply_bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_bgng_ymd IS '신청시작일자';


-- Name: COLUMN user_role_aply_mst.aply_end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.aply_end_ymd IS '신청종료일자';


-- Name: COLUMN user_role_aply_mst.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN user_role_aply_mst.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN user_role_aply_mst.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN user_role_aply_mst.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_aply_mst.last_mdfcn_dt IS '최종수정일시';


-- Name: user_role_mpng; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.user_role_mpng (
    user_id character varying(20) NOT NULL,
    role_cd character varying(100) NOT NULL,
    role_bgng_ymd date,
    role_end_ymd date,
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone NOT NULL,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone NOT NULL
);


-- Name: TABLE user_role_mpng; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.user_role_mpng IS '사용자역할매핑';


-- Name: COLUMN user_role_mpng.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.user_id IS '사용자아이디';


-- Name: COLUMN user_role_mpng.role_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.role_cd IS '역할코드';


-- Name: COLUMN user_role_mpng.role_bgng_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.role_bgng_ymd IS '역할시작일자';


-- Name: COLUMN user_role_mpng.role_end_ymd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.role_end_ymd IS '역할종료일자';


-- Name: COLUMN user_role_mpng.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN user_role_mpng.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN user_role_mpng.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN user_role_mpng.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.user_role_mpng.last_mdfcn_dt IS '최종수정일시';


-- Name: web_log; Type: TABLE; Schema: iccom; Owner: -

CREATE TABLE iccom.web_log (
    web_log_sn numeric(20,0) NOT NULL,
    cntn_dt timestamp without time zone NOT NULL,
    dmnd_url_addr character varying(500) NOT NULL,
    dmnd_meth_cd character varying(20) NOT NULL,
    sys_cd character varying(20),
    sys_nm character varying(300),
    menu_cd character varying(20),
    menu_nm character varying(300),
    user_id character varying(50),
    user_nm character varying(300),
    dept_cd character varying(20),
    dept_nm character varying(300),
    cntn_ip character varying(50) NOT NULL,
    sesion_id character varying(100),
    rspns_stts numeric(10,0),
    prcs_hr numeric(10,0),
    user_agen character varying(500),
    dmnd_refe character varying(500),
    device_type_nm character varying(100),
    frst_reg_id character varying(20) NOT NULL,
    frst_reg_dt timestamp without time zone,
    last_mdfcn_id character varying(20) NOT NULL,
    last_mdfcn_dt timestamp without time zone
);

CREATE SEQUENCE iccom.seq_web_log
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

SELECT setval('iccom.seq_web_log', (SELECT COALESCE(MAX(web_log_sn), 0) + 1 FROM
    iccom.web_log)::bigint, false);

ALTER TABLE iccom.web_log
    ALTER COLUMN web_log_sn SET DEFAULT nextval('iccom.seq_web_log');

-- Name: TABLE web_log; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON TABLE iccom.web_log IS '웹로그';


-- Name: COLUMN web_log.web_log_sn; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.web_log_sn IS '로그일련번호';


-- Name: COLUMN web_log.cntn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.cntn_dt IS '접속일시';


-- Name: COLUMN web_log.dmnd_url_addr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.dmnd_url_addr IS '요청URL주소';


-- Name: COLUMN web_log.dmnd_meth_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.dmnd_meth_cd IS '요청메소드코드';


-- Name: COLUMN web_log.sys_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.sys_cd IS '시스템코드';


-- Name: COLUMN web_log.sys_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.sys_nm IS '시스템명';


-- Name: COLUMN web_log.menu_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.menu_cd IS '메뉴코드';


-- Name: COLUMN web_log.menu_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.menu_nm IS '메뉴명';


-- Name: COLUMN web_log.user_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.user_id IS '사용자아이디';


-- Name: COLUMN web_log.user_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.user_nm IS '사용자명';


-- Name: COLUMN web_log.dept_cd; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.dept_cd IS '부서코드';


-- Name: COLUMN web_log.dept_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.dept_nm IS '부서명';


-- Name: COLUMN web_log.cntn_ip; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.cntn_ip IS '접속IP';


-- Name: COLUMN web_log.sesion_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.sesion_id IS '세션아이디';


-- Name: COLUMN web_log.rspns_stts; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.rspns_stts IS '응답상태';


-- Name: COLUMN web_log.prcs_hr; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.prcs_hr IS '처리시간';


-- Name: COLUMN web_log.user_agen; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.user_agen IS '사용자에이전트';


-- Name: COLUMN web_log.dmnd_refe; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.dmnd_refe IS '요청리퍼러';


-- Name: COLUMN web_log.device_type_nm; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.device_type_nm IS '디바이스유형명';


-- Name: COLUMN web_log.frst_reg_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.frst_reg_id IS '최초등록아이디';


-- Name: COLUMN web_log.frst_reg_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.frst_reg_dt IS '최초등록일시';


-- Name: COLUMN web_log.last_mdfcn_id; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.last_mdfcn_id IS '최종수정아이디';


-- Name: COLUMN web_log.last_mdfcn_dt; Type: COMMENT; Schema: iccom; Owner: -

COMMENT ON COLUMN iccom.web_log.last_mdfcn_dt IS '최종수정일시';


-- Name: authrt_stng authrt_stng_pk; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.authrt_stng
    ADD CONSTRAINT authrt_stng_pk PRIMARY KEY (authrt_cd, authrt_stng_type_cd, authrt_stng_trgt_cd);


-- Name: com_file_dtl com_file_dtl_pkey; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_file_dtl
    ADD CONSTRAINT com_file_dtl_pkey PRIMARY KEY (file_id);


-- Name: com_file com_file_pkey; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_file
    ADD CONSTRAINT com_file_pkey PRIMARY KEY (atch_file_id);


-- Name: com_group_cd com_group_cd_pkey; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_group_cd
    ADD CONSTRAINT com_group_cd_pkey PRIMARY KEY (group_cd);


-- Name: authrt pk_authrt; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.authrt
    ADD CONSTRAINT pk_authrt PRIMARY KEY (authrt_cd, sys_cd);


-- Name: clct_daly_smry pk_clct_daly_smry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.clct_daly_smry
    ADD CONSTRAINT pk_clct_daly_smry PRIMARY KEY (tot_ymd, job_id);


-- Name: clct_hstry pk_clct_hstry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.clct_hstry
    ADD CONSTRAINT pk_clct_hstry PRIMARY KEY (clct_hstry_sn);


-- Name: clct_intg_hstry pk_clct_intg_hstry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.clct_intg_hstry
    ADD CONSTRAINT pk_clct_intg_hstry PRIMARY KEY (clct_hstry_sn);


-- Name: clct_repo_queue pk_clct_repo_queue; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.clct_repo_queue
    ADD CONSTRAINT pk_clct_repo_queue PRIMARY KEY (clct_repo_queue_sn);


-- Name: cntn_prst_smry pk_cntn_prst_smry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.cntn_prst_smry
    ADD CONSTRAINT pk_cntn_prst_smry PRIMARY KEY (tot_ymd, hr);


-- Name: cntn_stats_daly_gis_smry pk_cntn_stats_daly_gis_smry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.cntn_stats_daly_gis_smry
    ADD CONSTRAINT pk_cntn_stats_daly_gis_smry PRIMARY KEY (tot_ymd, user_id);


-- Name: cntn_stats_hr_smry pk_cntn_stats_hr_smry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.cntn_stats_hr_smry
    ADD CONSTRAINT pk_cntn_stats_hr_smry PRIMARY KEY (tot_ymd, hr, user_id);


-- Name: com_cd pk_com_cd; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_cd
    ADD CONSTRAINT pk_com_cd PRIMARY KEY (cd, group_cd);


-- Name: dept pk_dept; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.dept
    ADD CONSTRAINT pk_dept PRIMARY KEY (dept_cd);


-- Name: link pk_link; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.link
    ADD CONSTRAINT pk_link PRIMARY KEY (link_id);


-- Name: link_data_hopr_hstry pk_link_data_hopr_hstry; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.link_data_hopr_hstry
    ADD CONSTRAINT pk_link_data_hopr_hstry PRIMARY KEY (hstry_sn);


-- Name: link_metdata pk_link_metdata; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.link_metdata
    ADD CONSTRAINT pk_link_metdata PRIMARY KEY (metdata_sn);


-- Name: link_metdata_dmnd pk_link_metdata_dmnd; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.link_metdata_dmnd
    ADD CONSTRAINT pk_link_metdata_dmnd PRIMARY KEY (link_metdata_dmnd_sn);


-- Name: map_srvc pk_map_srvc; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.map_srvc
    ADD CONSTRAINT pk_map_srvc PRIMARY KEY (map_srvc_sn);


-- Name: menu pk_menu; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.menu
    ADD CONSTRAINT pk_menu PRIMARY KEY (sys_cd, menu_cd);


-- Name: menu_role_authrt_mpng pk_menu_role_authrt_mpng; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.menu_role_authrt_mpng
    ADD CONSTRAINT pk_menu_role_authrt_mpng PRIMARY KEY (menu_cd, role_cd, authrt_cd);


-- Name: role pk_role; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.role
    ADD CONSTRAINT pk_role PRIMARY KEY (role_cd);


-- Name: srvy pk_srvy; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy
    ADD CONSTRAINT pk_srvy PRIMARY KEY (srvy_sn);


-- Name: srvy_qitem pk_srvy_qitem; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_qitem
    ADD CONSTRAINT pk_srvy_qitem PRIMARY KEY (qitem_sn);


-- Name: srvy_qitem_artcl pk_srvy_qitem_artcl; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_qitem_artcl
    ADD CONSTRAINT pk_srvy_qitem_artcl PRIMARY KEY (artcl_sn);


-- Name: srvy_rspdnt pk_srvy_rspdnt; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspdnt
    ADD CONSTRAINT pk_srvy_rspdnt PRIMARY KEY (rspdnt_sn);


-- Name: srvy_rspns pk_srvy_rspns; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspns
    ADD CONSTRAINT pk_srvy_rspns PRIMARY KEY (rspns_sn);


-- Name: sys pk_sys; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.sys
    ADD CONSTRAINT pk_sys PRIMARY KEY (sys_cd);


-- Name: sys_role_authrt_mpng pk_sys_role_authrt_mpng; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.sys_role_authrt_mpng
    ADD CONSTRAINT pk_sys_role_authrt_mpng PRIMARY KEY (sys_cd, role_cd, authrt_cd);


-- Name: tmap pk_tmap; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.tmap
    ADD CONSTRAINT pk_tmap PRIMARY KEY (tmap_sn);


-- Name: tmpr_user_authrt pk_tmpr_user_authrt; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.tmpr_user_authrt
    ADD CONSTRAINT pk_tmpr_user_authrt PRIMARY KEY (user_id, role_cd);


-- Name: tmpr_user_authrt_menu_mpng pk_tmpr_user_authrt_menu_mpng; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.tmpr_user_authrt_menu_mpng
    ADD CONSTRAINT pk_tmpr_user_authrt_menu_mpng PRIMARY KEY (user_id, role_cd, authrt_cd, menu_cd);


-- Name: tmpr_user_authrt_sys_mpng pk_tmpr_user_authrt_sys_mpng; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.tmpr_user_authrt_sys_mpng
    ADD CONSTRAINT pk_tmpr_user_authrt_sys_mpng PRIMARY KEY (user_id, role_cd, authrt_cd, sys_cd);


-- Name: trms_agre pk_trms_agre; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.trms_agre
    ADD CONSTRAINT pk_trms_agre PRIMARY KEY (trms_agre_sn);


-- Name: user pk_user; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom."user"
    ADD CONSTRAINT pk_user PRIMARY KEY (user_unq_id);


-- Name: user_role_aply_dtl pk_user_role_aply_dtl; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.user_role_aply_dtl
    ADD CONSTRAINT pk_user_role_aply_dtl PRIMARY KEY (aply_dtl_sn, aply_sn);


-- Name: user_role_aply_mst pk_user_role_aply_mst; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.user_role_aply_mst
    ADD CONSTRAINT pk_user_role_aply_mst PRIMARY KEY (aply_sn);


-- Name: user_role_mpng pk_user_role_mpng; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.user_role_mpng
    ADD CONSTRAINT pk_user_role_mpng PRIMARY KEY (user_id, role_cd);


-- Name: web_log pk_web_log; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.web_log
    ADD CONSTRAINT pk_web_log PRIMARY KEY (web_log_sn);


-- Name: trms trms_pkey; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.trms
    ADD CONSTRAINT trms_pkey PRIMARY KEY (trms_sn);


-- Name: menu uk_menu; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.menu
    ADD CONSTRAINT uk_menu UNIQUE (menu_cd);


-- Name: user_page_strg user_page_strg_pkey; Type: CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.user_page_strg
    ADD CONSTRAINT user_page_strg_pkey PRIMARY KEY (user_id, page_cd);


-- Name: idx_com_file_dtl_atch_file_id; Type: INDEX; Schema: iccom; Owner: -

CREATE INDEX idx_com_file_dtl_atch_file_id ON iccom.com_file_dtl USING btree (atch_file_id);


-- Name: idx_menu_up_menu_cd; Type: INDEX; Schema: iccom; Owner: -

CREATE INDEX idx_menu_up_menu_cd ON iccom.menu USING btree (up_menu_cd);


-- Name: idx_trms_01; Type: INDEX; Schema: iccom; Owner: -

CREATE INDEX idx_trms_01 ON iccom.trms USING btree (trms_type_cd, trms_stcd, use_yn);


-- Name: com_cd fk_com_cd_group; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_cd
    ADD CONSTRAINT fk_com_cd_group FOREIGN KEY (group_cd) REFERENCES iccom.com_group_cd(group_cd);


-- Name: com_file_dtl fk_com_file_dtl_atch_file; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.com_file_dtl
    ADD CONSTRAINT fk_com_file_dtl_atch_file FOREIGN KEY (atch_file_id) REFERENCES iccom.com_file(atch_file_id) ON DELETE CASCADE;


-- Name: link_metdata_dmnd fk_link_metdata_dmnd_link; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.link_metdata_dmnd
    ADD CONSTRAINT fk_link_metdata_dmnd_link FOREIGN KEY (link_id) REFERENCES iccom.link(link_id);


-- Name: srvy_qitem_artcl fk_srvy_qitem_artcl_qitem; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_qitem_artcl
    ADD CONSTRAINT fk_srvy_qitem_artcl_qitem FOREIGN KEY (qitem_sn) REFERENCES iccom.srvy_qitem(qitem_sn);


-- Name: srvy_qitem_artcl fk_srvy_qitem_artcl_srvy; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_qitem_artcl
    ADD CONSTRAINT fk_srvy_qitem_artcl_srvy FOREIGN KEY (srvy_sn) REFERENCES iccom.srvy(srvy_sn);


-- Name: srvy_qitem fk_srvy_qitem_srvy; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_qitem
    ADD CONSTRAINT fk_srvy_qitem_srvy FOREIGN KEY (srvy_sn) REFERENCES iccom.srvy(srvy_sn);


-- Name: srvy_rspdnt fk_srvy_rspdnt_srvy; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspdnt
    ADD CONSTRAINT fk_srvy_rspdnt_srvy FOREIGN KEY (srvy_sn) REFERENCES iccom.srvy(srvy_sn);


-- Name: srvy_rspns fk_srvy_rspns_artcl; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspns
    ADD CONSTRAINT fk_srvy_rspns_artcl FOREIGN KEY (artcl_sn) REFERENCES iccom.srvy_qitem_artcl(artcl_sn);


-- Name: srvy_rspns fk_srvy_rspns_qitem; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspns
    ADD CONSTRAINT fk_srvy_rspns_qitem FOREIGN KEY (qitem_sn) REFERENCES iccom.srvy_qitem(qitem_sn);


-- Name: srvy_rspns fk_srvy_rspns_rspdnt; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspns
    ADD CONSTRAINT fk_srvy_rspns_rspdnt FOREIGN KEY (rspdnt_sn) REFERENCES iccom.srvy_rspdnt(rspdnt_sn);


-- Name: srvy_rspns fk_srvy_rspns_srvy; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.srvy_rspns
    ADD CONSTRAINT fk_srvy_rspns_srvy FOREIGN KEY (srvy_sn) REFERENCES iccom.srvy(srvy_sn);


-- Name: trms_agre fk_trms_agre_trms; Type: FK CONSTRAINT; Schema: iccom; Owner: -

ALTER TABLE ONLY iccom.trms_agre
    ADD CONSTRAINT fk_trms_agre_trms FOREIGN KEY (trms_sn) REFERENCES iccom.trms(trms_sn);


-- PostgreSQL database dump complete

