sgc-portal/mobile-src/docs/TABLE_COLS.txt

COMMENT ON TABLE SGC.TCS_ERP_SITE IS '하자) ERP 현장';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.BZPJ_APRO_DT IS '사업_승인_일자';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.COMPL_DT IS '준공_일자';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.CONST_PRD_FROM_DT IS '공사 기간 FROM';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.CONST_PRD_TO_DT IS '공사 기간 TO';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.DCNT IS '동수';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.HHCNT IS '세대수';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.MNG_HQT_CD IS '관리본부 코드';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.MNG_HQT_NM IS '관리본부 명';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.OFC_FAX_NO IS '사무실_팩스번호';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.OFC_TEL_NO IS '사무실_전화번호';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SITE_ABB_NM IS '현장_약어_명';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SITE_MNG_GB_CD IS '현장관리구분코드[CS019]';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SITE_NM IS '현장_명';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SITE_PRGS_GB_CD IS '현장진행구분코드[CS015]';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.SPCMT_CN IS '특기사항_내용';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_ERP_SITE.WRTE_PR IS '작성 자';


COMMENT ON TABLE SGC.TCS_SITE IS '하자) 하자대상현장';
COMMENT ON COLUMN SGC.TCS_SITE.BZPJ_APRO_DT IS '사업_승인_일자';
COMMENT ON COLUMN SGC.TCS_SITE.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE.COMPL_DT IS '준공_일자';
COMMENT ON COLUMN SGC.TCS_SITE.CONST_PRD_FROM_DT IS '공사 기간 FROM';
COMMENT ON COLUMN SGC.TCS_SITE.CONST_PRD_TO_DT IS '공사 기간 TO';
COMMENT ON COLUMN SGC.TCS_SITE.DCNT IS '동수';
COMMENT ON COLUMN SGC.TCS_SITE.HHCNT IS '세대수';
COMMENT ON COLUMN SGC.TCS_SITE.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE.OFC_FAX_NO IS '사무실_팩스번호';
COMMENT ON COLUMN SGC.TCS_SITE.OFC_TEL_NO IS '사무실_전화번호';
COMMENT ON COLUMN SGC.TCS_SITE.PROD_NO IS '상품분류 상품번호';
COMMENT ON COLUMN SGC.TCS_SITE.SITE_ABB_NM IS '현장_약어_명';
COMMENT ON COLUMN SGC.TCS_SITE.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE.SITE_MNG_GB_CD IS '현장관리구분코드[CS019]';
COMMENT ON COLUMN SGC.TCS_SITE.SITE_NM IS '현장_명';
COMMENT ON COLUMN SGC.TCS_SITE.SITE_PRGS_GB_CD IS '현장진행구분코드[CS015]';
COMMENT ON COLUMN SGC.TCS_SITE.SPCMT_CN IS '특기사항_내용';
COMMENT ON COLUMN SGC.TCS_SITE.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_SITE_TRADE_CHRGR IS '하자)현장협력업체 담당자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CHRGR_CRRY_TEL_NO IS '담당자_휴대_전화번호';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CHRGR_EMAIL IS '담당자_이메일';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CHRGR_NM IS '담당자_명';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CHRGR_SMS_PERM_YN IS '담당자_SMS_허용_여부';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CHRGR_TYPE_CD IS '담당자유형코드[CS006]';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.COVEND_ID IS '협력업체 ID';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_CHRGR.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_SITE_TRADE_DEFGR IS '하자)현장협력업체 하자보증';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.BDMT_PO_REQ_DT IS '자재_발주_요청_일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CNTRT_AMT IS '계약_금액';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CNTRT_DGR IS '계약_차수';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CNTRT_NM IS '계약_명';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CNTRT_NO IS '계약번호';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.COVEND_ID IS '협력업체 ID';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.CRT_SYS_CD IS '생성시스템코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.DEFGR_SEQ IS '하자보증_순번';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.DEFT_CNTRT_YN IS '하자_계약_여부';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.ELEC_GUAR_YN IS '전자_보증_여부';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GRNTL_AFL_ID IS '보증서_첨부파일ID';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_AMT IS '보증_금액';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_CHG_GB_CD IS '보증변경구분코드[CO018]';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_END_DT IS '보증_종료_일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_INTU_CD IS '보증기관코드[CO008]';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_INTU_NM IS '보증_기관_명';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_STRT_DT IS '보증_시작_일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.GUAR_TYPE_CD IS '보증유형코드[CS007]';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.IF_GUAR_SEQ IS '인터페이스_보증_순번';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.JOBTYP_NM IS '공종_명';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.SCRT_NO IS '증권번호';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE_DEFGR.WRTE_PR IS '작성 자';


COMMENT ON TABLE SGC.TCS_SITE_DHS IS '하자) 현장 동호수';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CNTPR_OCPH_NM IS '계약 입주 자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CP_NO IS '핸드폰 번호';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.DONG IS '동';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.HSNO IS '호수';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_SITE_TRADE IS '하자)현장협력업체';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.COVEND_ID IS '협력업체 ID';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.CRT_SYS_CD IS '생성시스템코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.JOB_GB_CD IS '협력업체유형코드[CS004]';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.RMK_CN IS '비고_내용';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE_TRADE.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_DEFT IS '하자) 하자접수처리';
COMMENT ON COLUMN SGC.TCS_DEFT.APLNT_NM IS '신청자_명';
COMMENT ON COLUMN SGC.TCS_DEFT.APLNT_REL IS '신청자 관계';
COMMENT ON COLUMN SGC.TCS_DEFT.ASMNG_CHRGR_EMPNO IS '사후관리_담당자_사번';
COMMENT ON COLUMN SGC.TCS_DEFT.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_DEFT.CONS_COVEND_ID IS '시공_협력업체ID';
COMMENT ON COLUMN SGC.TCS_DEFT.CONS_MNBD_CD IS '시공주체코드[CS011]';
COMMENT ON COLUMN SGC.TCS_DEFT.CPLPR_NM IS '완료자_명';
COMMENT ON COLUMN SGC.TCS_DEFT.CPLT_DT IS '완료_일자';
COMMENT ON COLUMN SGC.TCS_DEFT.CPLT_ELPS_SEQ IS '완료 경과 순번';
COMMENT ON COLUMN SGC.TCS_DEFT.CRRY_TEL_NO IS '휴대_전화번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_CAUS_NO IS '하자원인번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_CN IS '하자_내용';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_IMG_AFL_ID IS '하자사진_첨부파일ID';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_JOBTYP_NO IS '하자공종번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_LJOBTYP_NO IS '하자대공종번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_MJOBTYP_NO IS '하자중공종번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_NO IS '하자번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_PRCG_STUS_CD IS '하자처리상태코드[CS009]';
COMMENT ON COLUMN SGC.TCS_DEFT.DEFT_TYPE_NO IS '하자유형번호';
COMMENT ON COLUMN SGC.TCS_DEFT.DONG IS '동';
COMMENT ON COLUMN SGC.TCS_DEFT.DURA_DYS IS '소요_일수';
COMMENT ON COLUMN SGC.TCS_DEFT.EMG_GB_CD IS '긴급 구분코드[CS020]';
COMMENT ON COLUMN SGC.TCS_DEFT.HSNO IS '호수';
COMMENT ON COLUMN SGC.TCS_DEFT.LOC_NO IS '위치번호';
COMMENT ON COLUMN SGC.TCS_DEFT.MBIL_CN_CONF_YN IS '모바일_내용_확인_여부';
COMMENT ON COLUMN SGC.TCS_DEFT.MBIL_PRCG_CN IS '모바일_처리_내용';
COMMENT ON COLUMN SGC.TCS_DEFT.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_DEFT.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_DEFT.OFFR_DT IS '신청 일자';
COMMENT ON COLUMN SGC.TCS_DEFT.PGPR_NM IS '처리자_명';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_AFL_ID IS '처리_첨부파일ID';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_CN IS '처리_내용';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_COVEND_ID IS '처리_협력업체ID';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_DT IS '처리_일자';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_ELPS_SEQ IS '처리 경과 순번';
COMMENT ON COLUMN SGC.TCS_DEFT.PRCG_MNBD_CD IS '처리주체코드[CS011]';
COMMENT ON COLUMN SGC.TCS_DEFT.RCPT_DT IS '접수_일자';
COMMENT ON COLUMN SGC.TCS_DEFT.RCPT_MTD_CD IS '접수방법코드[CS010]';
COMMENT ON COLUMN SGC.TCS_DEFT.RCVPR_EMPNO IS '접수자 사원번호';
COMMENT ON COLUMN SGC.TCS_DEFT.RCVPR_NM IS '접수자_명';
COMMENT ON COLUMN SGC.TCS_DEFT.REQ_CN IS '요청_내용';
COMMENT ON COLUMN SGC.TCS_DEFT.RPDT_SCOR IS '신속도_점수';
COMMENT ON COLUMN SGC.TCS_DEFT.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_DEFT.TEL_NO IS '전화번호';
COMMENT ON COLUMN SGC.TCS_DEFT.UPPER_LOC_NO IS '상위_위치번호';
COMMENT ON COLUMN SGC.TCS_DEFT.VENDR_LBPR_NM IS '업체_작업자_명';
COMMENT ON COLUMN SGC.TCS_DEFT.VIS_ELPS_SEQ IS '방문 경과 순번';
COMMENT ON COLUMN SGC.TCS_DEFT.WORK_ELPS_SEQ IS '작업 경과 순번';
COMMENT ON COLUMN SGC.TCS_DEFT.WORK_WKI_NO IS '작업_지시서_번호';
COMMENT ON COLUMN SGC.TCS_DEFT.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_DEFT.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_DEFT_CUSTSIGN IS '하자) 고객서명';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.DEFT_NO IS '하자번호';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.FILE_KND_NM IS '파일_종류_명';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.SIGN_AFL_ID IS '서명_첨부파일ID';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.SIGN_DT IS '서명_일자';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_DEFT_CUSTSIGN.WRTE_PR IS '작성 자';

COMMENT ON TABLE SGC.TCS_DEFT_ELPS IS '하자) 하자처리경과';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.DEFT_NO IS '하자번호';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.DEFT_PRCG_GB_CD IS '하자처리구분코드[CS013]';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.MAIL_CN IS '메일 내용';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PGPR_GB_CD IS '처리자 구분코드[CS016]';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PGPR_NM IS '처리자 명';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_AMT IS '처리 비용';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_ELPS_SEQ IS '처리_경과_순번';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_PR_END_DT IS '처리_예정_종료_일자';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_PR_END_TM IS '처리_예정_종료_시간TO';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_PR_STRT_DT IS '처리_예정_시작_일자';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_PR_STRT_TM IS '처리_예정_시작_시간FROM';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.PRCG_TYPE_CD IS '처리유형코드[CS012]';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.RMK_CN IS '비고_내용';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_DEFT_ELPS.WRTE_PR IS '작성 자';