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

comment on table sgc.tcsErpSite is '하자) erp 현장';
bzpjAproDt is '사업승인일자';
cmpnCd is '회사 코드';
complDt is '준공일자';
constPrdFromDt is '공사 기간 from';
constPrdToDt is '공사 기간 to';
dcnt is '동수';
hhcnt is '세대수';
mdftDt is '수정 일자';
mdftPr is '수정 자';
mngHqtCd is '관리본부 코드';
mngHqtNm is '관리본부 명';
ofcFaxNo is '사무실팩스번호';
ofcTelNo is '사무실전화번호';
siteAbbNm is '현장약어명';
siteCd is '현장코드';
siteMngGbCd is '현장관리구분코드[cs019]';
siteNm is '현장명';
sitePrgsGbCd is '현장진행구분코드[cs015]';
spcmtCn is '특기사항내용';
wrteDt is '작성 일자';
wrtePr is '작성 자';


comment on table sgc.tcsSite is '하자) 하자대상현장';
bzpjAproDt is '사업승인일자';
cmpnCd is '회사 코드';
complDt is '준공일자';
constPrdFromDt is '공사 기간 from';
constPrdToDt is '공사 기간 to';
dcnt is '동수';
hhcnt is '세대수';
mdftDt is '수정 일자';
mdftPr is '수정 자';
ofcFaxNo is '사무실팩스번호';
ofcTelNo is '사무실전화번호';
prodNo is '상품분류 상품번호';
siteAbbNm is '현장약어명';
siteCd is '현장코드';
siteMngGbCd is '현장관리구분코드[cs019]';
siteNm is '현장명';
sitePrgsGbCd is '현장진행구분코드[cs015]';
spcmtCn is '특기사항내용';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsSiteTradeChrgr is '하자)현장협력업체 담당자';
chrgrCrryTelNo is '담당자휴대전화번호';
chrgrEmail is '담당자이메일';
chrgrNm is '담당자명';
chrgrSmsPermYn is '담당자Sms허용여부';
chrgrTypeCd is '담당자유형코드[cs006]';
cmpnCd is '회사 코드';
covendId is '협력업체 id';
mdftDt is '수정 일자';
mdftPr is '수정 자';
siteCd is '현장코드';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsSiteTradeDefgr is '하자)현장협력업체 하자보증';
bdmtPoReqDt is '자재발주요청일자';
cmpnCd is '회사 코드';
cntrtAmt is '계약금액';
cntrtDgr is '계약차수';
cntrtNm is '계약명';
cntrtNo is '계약번호';
covendId is '협력업체 id';
crtSysCd is '생성시스템코드';
defgrSeq is '하자보증순번';
deftCntrtYn is '하자계약여부';
elecGuarYn is '전자보증여부';
grntlAflId is '보증서첨부파일id';
guarAmt is '보증금액';
guarChgGbCd is '보증변경구분코드[co018]';
guarEndDt is '보증종료일자';
guarIntuCd is '보증기관코드[co008]';
guarIntuNm is '보증기관명';
guarStrtDt is '보증시작일자';
guarTypeCd is '보증유형코드[cs007]';
ifGuarSeq is '인터페이스보증순번';
jobtypNm is '공종명';
mdftDt is '수정 일자';
mdftPr is '수정 자';
scrtNo is '증권번호';
siteCd is '현장코드';
wrteDt is '작성 일자';
wrtePr is '작성 자';


comment on table sgc.tcsSiteDhs is '하자) 현장 동호수';
cmpnCd is '회사 코드';
cntprOcphNm is '계약 입주 자';
cpNo is '핸드폰 번호';
dong is '동';
hsno is '호수';
mdftDt is '수정 일자';
mdftPr is '수정 자';
siteCd is '현장코드';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsSiteTrade is '하자)현장협력업체';
cmpnCd is '회사 코드';
covendId is '협력업체 id';
crtSysCd is '생성시스템코드';
jobGbCd is '협력업체유형코드[cs004]';
mdftDt is '수정 일자';
mdftPr is '수정 자';
rmkCn is '비고내용';
siteCd is '현장코드';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsDeft is '하자) 하자접수처리';
aplntNm is '신청자명';
aplntRel is '신청자 관계';
asmngChrgrEmpno is '사후관리담당자사번';
cmpnCd is '회사 코드';
consCovendId is '시공협력업체id';
consMnbdCd is '시공주체코드[cs011]';
cplprNm is '완료자명';
cpltDt is '완료일자';
cpltElpsSeq is '완료 경과 순번';
crryTelNo is '휴대전화번호';
deftCausNo is '하자원인번호';
deftCn is '하자내용';
deftImgAflId is '하자사진첨부파일id';
deftJobtypNo is '하자공종번호';
deftLjobtypNo is '하자대공종번호';
deftMjobtypNo is '하자중공종번호';
deftNo is '하자번호';
deftPrcgStusCd is '하자처리상태코드[cs009]';
deftTypeNo is '하자유형번호';
dong is '동';
duraDys is '소요일수';
emgGbCd is '긴급 구분코드[cs020]';
hsno is '호수';
locNo is '위치번호';
mbilCnConfYn is '모바일내용확인여부';
mbilPrcgCn is '모바일처리내용';
mdftDt is '수정 일자';
mdftPr is '수정 자';
offrDt is '신청 일자';
pgprNm is '처리자명';
prcgAflId is '처리첨부파일id';
prcgCn is '처리내용';
prcgCovendId is '처리협력업체id';
prcgDt is '처리일자';
prcgElpsSeq is '처리 경과 순번';
prcgMnbdCd is '처리주체코드[cs011]';
rcptDt is '접수일자';
rcptMtdCd is '접수방법코드[cs010]';
rcvprEmpno is '접수자 사원번호';
rcvprNm is '접수자명';
reqCn is '요청내용';
rpdtScor is '신속도점수';
siteCd is '현장코드';
telNo is '전화번호';
upperLocNo is '상위위치번호';
vendrLbprNm is '업체작업자명';
visElpsSeq is '방문 경과 순번';
workElpsSeq is '작업 경과 순번';
workWkiNo is '작업지시서번호';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsDeftCustsign is '하자) 고객서명';
cmpnCd is '회사 코드';
deftNo is '하자번호';
fileKndNm is '파일종류명';
mdftDt is '수정 일자';
mdftPr is '수정 자';
signAflId is '서명첨부파일id';
signDt is '서명일자';
wrteDt is '작성 일자';
wrtePr is '작성 자';

comment on table sgc.tcsDeftElps is '하자) 하자처리경과';
cmpnCd is '회사 코드';
deftNo is '하자번호';
deftPrcgGbCd is '하자처리구분코드[cs013]';
mailCn is '메일 내용';
mdftDt is '수정 일자';
mdftPr is '수정 자';
pgprGbCd is '처리자 구분코드[cs016]';
pgprNm is '처리자 명';
prcgAmt is '처리 비용';
prcgElpsSeq is '처리경과순번';
prcgPrEndDt is '처리예정종료일자';
prcgPrEndTm is '처리예정종료시간to';
prcgPrStrtDt is '처리예정시작일자';
prcgPrStrtTm is '처리예정시작시간from';
prcgTypeCd is '처리유형코드[cs012]';
rmkCn is '비고내용';
wrteDt is '작성 일자';
wrtePr is '작성 자';