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