111

Tables (6)

PROJECT (프로젝트)

  • PJT_CD (프로젝트코드) — VARCHAR — Primary key — NOT NULL
  • ENFC_DEP_CD (시행부서부코드) — VARHCAR
  • PJT_FIN_YN (진행상황) — VARCHAR
  • PJT_NAME (프로젝트명) — VARCHAR

TB_ACTN_MTTR_MNG (조치사항관리)

  • ACTN_MTTR_NO (조치사항번호) — VARCHAR — Primary key — NOT NULL
  • PTOUT_MTTR_NO (지적사항번호) — VARCHAR — Foreign key → TB_PTOUT_MTTR_MNG.PTOUT_MTTR_NO — NOT NULL
  • ACTN_MTTR_NM (조치사항명) — VARCHAR
  • FILE_SEQ (파일일련번호) — NUMERIC
  • RMRK (비고) — VARCHAR
  • RGTR_ID (등록자아이디) — VARHCAR
  • REG_DT (등록일자) — DATE
  • MDFR_ID (수정자아이디) — VARHCAR
  • MDFCN_DT (수정일시) — DATE

TB_BID_PBANC (입찰공고)

  • PBANC_NO (공고번호) — VARCHAR — Primary key — NOT NULL
  • PJT_CD (프로젝트코드) — VARCHAR — Foreign key → PROJECT.PJT_CD — NOT NULL
  • BID_PBANC_NM (입찰공고명) — VARCHAR
  • SCSBD_BZENTY_BZENTY (낙찰업체명) — VARCHAR

TB_CSTRN_CHCK_INFO (공사점검정보)

  • CHCK_INFO_NO (점검정보번호) — VARCHAR — Primary key — NOT NULL
  • UNIY_CTRT_NO (통합계약코드) — VARCHAR — Foreign key → TB_CTRT_MNG.UNIY_CTRT_NO — NOT NULL
  • PJT_CD (프로젝트코드) — VARCHAR — Foreign key → TB_CTRT_MNG.PJT_CD — NOT NULL
  • CHCK_NM (점검명) — VARCHAR
  • CHCK_BGNG_YMD (점검시작일) — VARCHAR
  • CHCK_END_YMD (점검종료일) — VARCHAR
  • ACTN_PRCS_YMD (조치 처리 일자) — VARCHAR
  • RGTR_ID (등록자아이디) — VARHCAR
  • REG_DT (등록일시) — DATE
  • MDFR_ID (수정자아이디) — VARCHAR
  • MDFCN_DT (수정일시) — DATE

TB_CTRT_MNG (계약관리)

  • UNIY_CTRT_NO (통합계약코드) — VARCHAR — Primary key — NOT NULL
  • PJT_CD (프로젝트코드) — VARCHAR — Foreign key → TB_BID_PBANC.PJT_CD — NOT NULL
  • BGNCST_OTST_YMD (착공착수일자) — VARCHAR
  • CUR_CMCN_YMD (금차준공일자) — VARCHAR

TB_PTOUT_MTTR_MNG (지적사항관리)

  • PTOUT_MTTR_NO (지적사항번호) — VARCHAR — Primary key — NOT NULL
  • PBANC_NO (공고번호) — VARCHAR
  • PTOUT_MTTR_NM (지적사항명) — VARCHAR
  • CHCK_YMD (점검일자) — VARCHAR
  • ACTN_YMD (조치일자) — VARCHAR
  • RVW_IDNTY_YMD (검토확인일자) — VARCHAR(8)
  • ACTN_FILE_SEQ (조치파일일련번호) — NUMBER
  • PTOUT_FILE_SEQ (지적파일일련번호) — NUMBER
  • PTOUT_MTTR_MAIN_CN (지적사항주요내용) — VARCHAR
  • RMRK (비고) — VARCHAR
  • RGTR_ID (등록자아이디) — VARHCAR
  • REG_DT (등록일시) — DATE
  • MDFR_ID (수정자아이디) — VARHCAR
  • MDFCN_DT (수정일시) — DATE