ODA
Tables (38)
CPS_BASS_INFO (CPS기본정보)
- CPS_SN (CPS순번) — VARCHAR(4) — Primary key — NOT NULL
DAC_CD_MNGT (DAC코드관리)
- ODA_DAC_CD_ID (ODADAC코드ID) — VARCHAR(20) — Primary key — NOT NULL
IATI_BIZ_FILE_GNRT_INFO (IATI사업파일생성정보)
- GNRT_YEAR (생성년도) — VARCHAR(4) — Primary key — NOT NULL
- FILE_TYP_CD (파일유형코드) — VARCHAR(2) — Primary key — NOT NULL
- FILE_GNRT_SN (파일생성순번) — VARCHAR(4) — Primary key — NOT NULL
- Field (생성일자) — VARCHAR(8)
IATI_BIZ_MNGT (IATI사업관리)
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
IATI_BIZ_OPNITM_MNGT (IATI공개항목관리)
- IATI_BIZ_OPNITM_YEAR (IATI사업공개항목년도) — VARCHAR(4) — Primary key — NOT NULL
- IATI_BIZ_OPNITM_SN (IATI사업공개항목순번) — VARCHAR(4) — Primary key — NOT NULL
- IATI_BIZ_OPNITM_NM (IATI사업공개항목명) — VARCHAR(400) — Primary key — NOT NULL
IATI_BIZ_SCTN_MNGT (IATI사업분야관리)
- IATI_BIZ_SCTN_ID (IATI사업분야ID) — VARCHAR(20) — Primary key — NOT NULL
IATI_CNTR_MNGT (IATI수원국관리)
- CNTR_ID (수원국ID) — VARCHAR(20) — Foreign key → RCPT_CNTR_BASS_INFO.CNTR_ID — NOT NULL
IATI_DOC_ADRS_MNGT (IATI파일경로관리)
- DOC_ADRS_SN (파일경로순번) — VARCHAR(4) — Primary key — NOT NULL
- GNRT_YEAR (생성년도) — VARCHAR(4) — Foreign key → IATI_BIZ_FILE_GNRT_INFO.GNRT_YEAR — NOT NULL
- FILE_TYP_CD (파일유형코드) — VARCHAR(2) — Foreign key → IATI_BIZ_FILE_GNRT_INFO.FILE_TYP_CD — NOT NULL
- FILE_GNRT_SN (파일생성순번) — VARCHAR(4) — Foreign key → IATI_BIZ_FILE_GNRT_INFO.FILE_GNRT_SN — NOT NULL
IATI_INST_MNGT (IATI기관관리)
- INST_ID (기관ID) — VARCHAR(20) — Primary key — NOT NULL
IMPL_PLN_JUDG_ INFO_MNGT (시행계획심사정보관리)
- IMPL_PLN_JUDG_RSLT_SN (시행계획심사정보순번) — VARCHAR(4) — Primary key — NOT NULL
- IMPL_PLN_ID (시행계획ID) — VARCHAR(20) — Foreign key → IMPL_PLN_MNGT.IMPL_PLN_ID — NOT NULL
- IMPL_PLN_JUDG_STND_SN (시행계획심사기준순번) — VARCHAR(4) — Foreign key → IMPL_PLN_JUDG_STND_MNGT.IMPL_PLN_JUDG_STND_SN — NOT NULL
IMPL_PLN_JUDG_DATA_MNGT (시행계획심사자료관리)
- IMPL_PLN_JUDG_DATA_SN (시행계획심사자료순번) — VARCHAR(4) — Primary key — NOT NULL
- IMPL_PLN_JUDG_INFO_SN (시행계획심사정보순번) — VARCHAR(4) — Foreign key → IMPL_PLN_JUDG_ INFO_MNGT.IMPL_PLN_JUDG_RSLT_SN — NOT NULL
IMPL_PLN_JUDG_RSLT_MNGT (시행계획심사결과관리)
- IMPL_PLN_JUDG_RSLT_SN (시행계획심사결과순번) — VARCHAR(4) — Primary key — NOT NULL
- IMPL_PLN_JUDG_RSLT_SN (시행계획심사정보순번) — VARCHAR(4) — Foreign key → IMPL_PLN_JUDG_ INFO_MNGT.IMPL_PLN_JUDG_RSLT_SN — NOT NULL
IMPL_PLN_JUDG_STND_MNGT (시행계획심사기준관리)
- IMPL_PLN_JUDG_STND_SN (시행계획심사기준순번) — VARCHAR(4) — Primary key — NOT NULL
IMPL_PLN_MNGT (시행계획관리)
- IMPL_PLN_ID (시행계획ID) — VARCHAR(20) — Primary key — NOT NULL
- PRE_BIZ_ID (예비사업ID) — VARCHAR(20) — Foreign key → PRE_BIZ_MNGT.PRE_BIZ_ID — NOT NULL
- CPS_SN (CPS순번) — VARCHAR(4) — Foreign key → CPS_BASS_INFO.CPS_SN — NOT NULL
- SDGS_SN (SDGS순번) — VARCHAR(4) — Foreign key → SDGS_BASS_INFO.SDGS_SN — NOT NULL
- RCPT_SN (수원국순번) — VARCHAR(4) — Foreign key → RCPT_CNTR_BASS_INFO.CNTR_ID — NOT NULL
- OCR_TNFR_SN (OCR변환ID) — VARCHAR(20) — Foreign key → OCR_TNFR_INFO.OCR_TNFR_SN — NOT NULL
- PRFM_IDCD_SN (성과지표순번) — VARCHAR(4) — Foreign key → PRFM_IDCT_MNGT.PRFM_IDCD_SN — NOT NULL
LNK_EXMN_RSLT_MNGT (연계검토결과관리)
- LNK_EXMN_RSLT_ID (연계검토결과ID) — VARCHAR(20) — Primary key — NOT NULL
- LNK_RQST_EXMN_RSLT_ID (연계요청ID) — VARCHAR(20) — Foreign key → LNK_RQST_MNGT.LNK_RQST_ID — NOT NULL
LNK_RQST_MNGT (연계요청관리)
- LNK_RQST_ID (연계요청ID) — VARCHAR(20) — Primary key — NOT NULL
- RQST_PRE_BIZ_ID (요청예비사업ID) — VARCHAR(20) — Primary key — NOT NULL
- TRGT_PRE_BIZ_ID (대상예비사업ID) — VARCHAR(20) — Foreign key → PRE_BIZ_MNGT.PRE_BIZ_ID — NOT NULL
NPRGR_BIZ_MNGT (미진행사업관리)
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
OCR_TNFR_INFO (OCR변환정보)
- OCR_TNFR_SN (OCR변환ID) — VARCHAR(20) — Primary key — NOT NULL
ODA_CD_MNGT (ODA코드관리)
- ODA_CD_ID (ODA코드ID) — VARCHAR(20) — Primary key — NOT NULL
ODA_EVL_CMTT_IMPL_PLN_MNGT (ODA평가위이행점검관리)
- ODA_EVL_CMTT_IMPL_PLN_SN (ODA평가위이행점검순번) — VARCHAR(4) — Primary key — NOT NULL
- ODA_ITSLF_EVL_IMPL_PLN_SN (ODA자체평가이행계획순번) — VARCHAR(4) — Foreign key → ODA_ITSLF_EVL_IMPL_PLN_MNGT.ODA_ITSLF_EVL_IMPL_PLN_SN — NOT NULL
- ODA_ITSLF_EVL_SN (ODA자체평가순번) — VARCHAR(4) — Foreign key → ODA_ITSLF_EVL_IMPL_PLN_MNGT.ODA_ITSLF_EVL_SN — NOT NULL
- ODA_ITSLF_EVL_YEAR (ODA자체평가년차) — VARCHAR(4) — Foreign key → ODA_ITSLF_EVL_IMPL_PLN_MNGT.ODA_ITSLF_EVL_YEAR — NOT NULL
ODA_ITSLF_EVL_IMPL_PLN_MNGT (ODA자체평가이행계획관리)
- ODA_ITSLF_EVL_IMPL_PLN_SN (ODA자체평가이행계획순번) — VARCHAR(4) — Primary key — NOT NULL
- ODA_ITSLF_EVL_SN (ODA자체평가순번) — VARCHAR(4) — Foreign key → ODA_ITSLF_EVL_MNGT.ODA_ITSLF_EVL_SN — NOT NULL
- ODA_ITSLF_EVL_YEAR (ODA자체평가년차) — VARCHAR(4) — Foreign key → ODA_ITSLF_EVL_MNGT.ODA_ITSLF_EVL_YEAR — NOT NULL
ODA_ITSLF_EVL_MNGT (ODA자체평가관리)
- ODA_ITSLF_EVL_YEAR (ODA자체평가년차) — VARCHAR(4) — Primary key — NOT NULL
- ODA_ITSLF_EVL_SN (ODA자체평가순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
OECD_SBMT_MNGT (OECD제출관리)
- OECD_SBMT_SN (OECD제출순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
PCP_MNGT (PCP관리)
- PCP_ID (PCPID) — VARCHAR(20) — Primary key — NOT NULL
PKG_BIZ_BASE_INFO (패키지사업기본정보)
- PKG_BIZ_YEAR (패키지사업년도) — VARCHAR(4) — Primary key — NOT NULL
- PKG_BIZ_TYP_CD (패키지사업유형코드) — VARCHAR(2) — Primary key — NOT NULL
- PRFM_IDCD_SN (성과지표순번) — VARCHAR(4) — Foreign key → PRFM_IDCT_MNGT.PRFM_IDCD_SN — NOT NULL
- Field (총괄담당기관ID)
- Field (총괄담당자ID)
PKG_BIZ_MNGT (패키지사업관리)
- PKG_BIZ_ID (패키지사업ID) — VARCHAR(20) — Primary key — NOT NULL
- PKG_BIZ_DVD_CD (패키지사업ID구분코드) — VARCHAR(2) — Primary key — NOT NULL
- PKG_BIZ_YEAR (패키지사업년도) — VARCHAR(4) — Foreign key → PKG_BIZ_BASE_INFO.PKG_BIZ_YEAR — NOT NULL
- PKG_BIZ_TYP_CD (패키지사업유형코드) — VARCHAR(2) — Foreign key → PKG_BIZ_BASE_INFO.PKG_BIZ_TYP_CD — NOT NULL
- IMPL_PLN_ID (시행계획ID) — VARCHAR(20) — Foreign key → IMPL_PLN_MNGT.IMPL_PLN_ID — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
- Field (패키지유효시작일자)
- Field2 (패키지유효종료일자)
PLCY_RIUMRKR_BASS_INFO (정책리우마커기본정보)
- PLCY_RIUMRKR_SN (정책리우마커순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
PRE_BIZ_MNGT (예비사업관리)
- PRE_BIZ_ID (예비사업ID) — VARCHAR(20) — Primary key — NOT NULL
- PCP_ID (PCPID) — VARCHAR(20) — Foreign key → PCP_MNGT.PCP_ID — NOT NULL
- CPS_SN (CPS순번) — VARCHAR(4) — Foreign key → CPS_BASS_INFO.CPS_SN — NOT NULL
- SDGS_SN (SDGS순번) — VARCHAR(4) — Foreign key → SDGS_BASS_INFO.SDGS_SN — NOT NULL
- RCPT_SN (수원국순번) — VARCHAR(4) — Foreign key → RCPT_CNTR_BASS_INFO.CNTR_ID — NOT NULL
- OCR_TNFR_SN (OCR변환ID) — VARCHAR(20) — Foreign key → OCR_TNFR_INFO.OCR_TNFR_SN — NOT NULL
- PRFM_IDCD_SN (성과지표순번) — VARCHAR(4) — Foreign key → PRFM_IDCT_MNGT.PRFM_IDCD_SN — NOT NULL
PRFM_IDCT_ ITM_MNGT (성과지표항목관리)
- PRFM_IDCD_ITM_SN (성과지표항목순번) — VARCHAR(4) — Primary key — NOT NULL
- PRFM_IDCD_SN (성과지표순번) — VARCHAR(4) — Foreign key → PRFM_IDCT_MNGT.PRFM_IDCD_SN — NOT NULL
PRFM_IDCT_MNGT (성과지표관리)
- PRFM_IDCD_SN (성과지표순번) — VARCHAR(4) — Primary key — NOT NULL
- Field (성과년도) — VARCHAR(4)
PRGR_BIZ_EXCT_MNGT (진행사업집행관리)
- PRGR_BIZ_EXCT_SN (진행사업순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
PRGR_BIZ_MNGT (진행사업관리)
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Primary key — NOT NULL
- IMPL_PLN_ID (시행계획ID) — VARCHAR(20) — Foreign key → IMPL_PLN_MNGT.IMPL_PLN_ID — NOT NULL
PRGR_BIZ_TRIN_MNGT (진행사업연수생관리)
- TRIN_SN (연수생순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
PSI_BASS_INFO (PSI기본정보)
- PSI_SN (PSI순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL
RCPT_CNTR_BASS_INFO (수원국기본정보)
- CNTR_ID (수원국ID) — VARCHAR(20) — Primary key — NOT NULL
RCPT_CNTR_GIS_INFO (수원국GIS정보)
- GIS_TYP_CD (GIS유형코드) — VARCHAR(2) — Primary key — NOT NULL
- GIS_SN (GIS순번) — VARCHAR(4) — Primary key — NOT NULL
- LTTD (위도) — NUMBER(10,4) — Primary key — NOT NULL
- LGTD (경도) — NUMBER(10,4) — Primary key — NOT NULL
- CNTR_ID (수원국ID) — VARCHAR(20) — Foreign key → RCPT_CNTR_BASS_INFO.CNTR_ID — NOT NULL
SDGS_BASS_INFO (SDGS기본정보)
- SDGS_SN (SDGS순번) — VARCHAR(4) — Primary key — NOT NULL
STTS_TRNF_MNGT (통계이관관리)
- STTS_TRNF_SN (통계이관순번) — VARCHAR(4) — Primary key — NOT NULL
- PRGR_BIZ_ID (진생사업ID) — VARCHAR(20) — Foreign key → PRGR_BIZ_MNGT.PRGR_BIZ_ID — NOT NULL