비산배출시설관리
테이블 (17)
INSTALLSPEC_TEMP
- USERS_SEQ — NUMBER
- ID — VARCHAR2
- CO_NAME — VARCHAR2
- FAC_CD — VARCHAR2
- FAC_CD_NAME — VARCHAR2
- FAC_MID_CD_NAME — VARCHAR2
- PROCESS_SEQ — NUMBER
- PROCESS_SEQ_NAME — VARCHAR2
- PROC_ID — VARCHAR2
- FAC_ID — VARCHAR2
- PND_ID — VARCHAR2
- MASSBALANCE_SEQ — NUMBER
- MASSBALANCE_SEQ_NAME — VARCHAR2
- MASSBALANCE_NAME — VARCHAR2
- SCAL — VARCHAR2
- FAC_STDCD — VARCHAR2
- FAC_RMK — VARCHAR2
LEAK
- SEQ — NUMBER — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- INSTALLSPEC_SEQ — NUMBER — NOT NULL
- LEAK_YMD — VARCHAR2
- DEPT — VARCHAR2
- PERSON — VARCHAR2
- EQUIP — VARCHAR2
- MID_PROCESS — VARCHAR2
- SMALL_PROCESS — VARCHAR2
- UNIT — VARCHAR2
- TAGID — VARCHAR2
- LOCATION — VARCHAR2
- POSSIBLE — VARCHAR2
- HARD_RMK — VARCHAR2
- LEAK_PPM — VARCHAR2
- RESULT_RMK — VARCHAR2
- RESULT_YMD — VARCHAR2
- AFTER_PPM — VARCHAR2
- UPD_DATE — DATE
- RPT_YY — VARCHAR2
결함 및 조치사항 (DEFECT)
- SEQ — NUMBER — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- INSTALLSPEC_SEQ — NUMBER — NOT NULL
- DEFECT_YMD — VARCHAR2
- DEFECT_RMK — VARCHAR2
- RESULT_RMK — VARCHAR2
- RESULT_FR_YMD — VARCHAR2
- RESULT_TO_YMD — VARCHAR2
- UPD_DATE — DATE
- RPT_YY — VARCHAR2
- SEQ (SEQ2) — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL
공용코드 (AA_CODES)
- 그룹코드 (GRP_CD) — VARCHAR2 — 기본 키 — NOT NULL — 그룹코드
- 코드 (CD) — VARCHAR2 — NOT NULL — 코드
- 코드명 (CD_NM) — VARCHAR2 — NOT NULL — 코드명
- 사용여부 (USED_YN) — VARCHAR2 — 사용여부
- ORD — NUMBER — 조회순서
- ATR1 — VARCHAR2
- ATR2 — VARCHAR2 — 속성2
- ATR3 — VARCHAR2 — 속성3
- ATR4 — VARCHAR2 — 속성4
- ATR5 — VARCHAR2 — 속성5
- ATR6 — VARCHAR2 — 속성6
- ATR7 — VARCHAR2 — 속성7
- ATR8 — VARCHAR2 — 속성8
- ATR9 — VARCHAR2 — 속성9
- ATR10 — VARCHAR2 — 속성10
- USER_ID — VARCHAR2 — NOT NULL — 사용자계정
- UPD_DATE — DATE — 갱신일자
- SEQ — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL
공정 (PROCESS)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- PROC_NM — VARCHAR2
- PROC_DESC — VARCHAR2
- PROC_RMK — VARCHAR2
- PROC_ORD — NUMBER
- PROC_IMG1 — NUMBER
- PROC_IMG2 — NUMBER
- PROC_IMG3 — NUMBER
- USE_YN — VARCHAR2
- UPD_DATE — DATE
- PROC_IMG0 — NUMBER
- SEQ (SEQ2) — NUMBER — 외래 키 → 비산배출시설 설치명세.SEQ — NOT NULL
공지사항 (H_BOARD)
- IDX — NUMBER — NOT NULL
- GUBUN — VARCHAR2
- TITLE — VARCHAR2
- CONTENTS — VARCHAR2
- RDATE — DATE
- FILENM — VARCHAR2
관리물질 (MASSBALANCE_DETAIL)
- SEQ — NUMBER — 기본 키 — NOT NULL
- MASSBALANCE_SEQ — NUMBER — NOT NULL
- MATR_CD — VARCHAR2
- CONCEN — VARCHAR2
- UPD_DATE — DATE
- GUBUN — VARCHAR2
- ETC_MATR_NM — VARCHAR2
- SEQ (SEQ2) — NUMBER — 외래 키 → 물질수지.SEQ — NOT NULL
대상시설별 세부관리계획 (PLAN_DETAIL)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- RPT_YY — VARCHAR2
- INSTALLSPEC_SEQ — NUMBER — NOT NULL
- MATR_QTY — NUMBER
- PLAN_YM — VARCHAR2
- DOC_NM — VARCHAR2
- EXP_YN — VARCHAR2
- EXP_RMK — VARCHAR2
- UPD_DATE — DATE
- SEQ (SEQ2) — NUMBER — 외래 키 → 비산배출시설 설치명세.SEQ — NOT NULL
물질수지 (MASSBALANCE)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- SUJI — VARCHAR2
- PRODUCT — VARCHAR2
- UPD_DATE — DATE
- SEQ (SEQ2) — NUMBER — 외래 키 → 비산배출시설 설치명세.SEQ — NOT NULL
비산배출시설 설치명세 (INSTALLSPEC)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- FAC_CD — VARCHAR2
- FAC_MID_CD — VARCHAR2
- PROCESS_SEQ — NUMBER
- PROC_ID — VARCHAR2
- FAC_ID — VARCHAR2
- PND_ID — VARCHAR2
- MASSBALANCE_SEQ — NUMBER
- DENST — VARCHAR2
- SCAL — VARCHAR2
- FAC_STDCD — VARCHAR2
- FAC_RMK — VARCHAR2
- USE_YN — VARCHAR2
- UPD_DATE — DATE
- FAC_CD_NAME — VARCHAR2
- FAC_MID_CD_NAME — VARCHAR2
- PROCESS_SEQ_NAME — VARCHAR2
- MASSBALANCE_SEQ_NAME — VARCHAR2
- MASSBALANCE_NAME — VARCHAR2
- FAC_STDCD2 — VARCHAR2
사업장별 변경신고내역 (CHANGESPEC)
- 일련번호 (SEQ) — NUMBER — 기본 키 — NOT NULL
- 사업장번호 (USERS_SEQ) — NUMBER — NOT NULL
- 신고번호 (REPORT_SEQ) — NUMBER — NOT NULL
- CHG_TAG — VARCHAR2 — NOT NULL
- INSTALLSPEC_SEQ — NUMBER
- FAC_CD — VARCHAR2
- FAC_MID_CD — VARCHAR2
- PROCESS_SEQ — NUMBER
- PROC_ID — VARCHAR2
- FAC_ID — VARCHAR2
- PND_ID — VARCHAR2
- MASSBALANCE_SEQ — NUMBER
- DENST — VARCHAR2
- SCAL — VARCHAR2
- FAC_STDCD — VARCHAR2
- MATR_QTY — NUMBER
- PLAN_YM — VARCHAR2
- EXP_YN — VARCHAR2
- CHG_DESC — VARCHAR2
- EQP_STA_DT — VARCHAR2
- UPD_DATE — DATE
- CLOSE_YMD — VARCHAR2
- 일련번호 (SEQ2) — NUMBER — 외래 키 → 사용자.일련번호 — NOT NULL
사업장별 운영/변경 신고, 점검보고 (REPORT)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- RPT_TAG — VARCHAR2 — NOT NULL
- RPT_YY — VARCHAR2 — NOT NULL
- BIZ_CD — NUMBER
- RPT_SEQ — NUMBER
- CO_NO — VARCHAR2 — NOT NULL
- CO_NAME — VARCHAR2 — NOT NULL
- BIZ_INQNM — VARCHAR2
- ZIPCODE — VARCHAR2
- ADDR — VARCHAR2
- ADDR_DTL — VARCHAR2
- CO_TEL — VARCHAR2
- REGNCODE — VARCHAR2
- CO_CEO — VARCHAR2
- CEO_BIRDAY — VARCHAR2
- CEO_TEL — VARCHAR2
- CEO_POSTNO — VARCHAR2
- CEO_ADDR1 — VARCHAR2
- CEO_ADDR2 — VARCHAR2
- REFNUMBER — VARCHAR2
- MATRS_VIEW1 — VARCHAR2
- MATRS_VIEW2 — VARCHAR2
- CHG_DESC — VARCHAR2
- EQP_STA_DT — VARCHAR2
- EQP_OPEN_DT — VARCHAR2
- USR_NAME — VARCHAR2
- USR_CEL — VARCHAR2
- USR_FAX — VARCHAR2
- USR_DEPT — VARCHAR2
- USR_EMAIL — VARCHAR2
- FILE_NM — VARCHAR2
- MNG_AGNCD — VARCHAR2
- MNG_AGNNM — VARCHAR2
- RCV_RMK — VARCHAR2
- MNG_USER_ID — VARCHAR2
- MNG_UPD_DATE — DATE
- USER_ID — VARCHAR2
- FILE_NM1 — VARCHAR2
- IND_NM — VARCHAR2
- STATUS — VARCHAR2
- APPLY_DATE — DATE
- RECEIVE_DATE — DATE
- FEEDBACK_DATE — DATE
- REAPPLY_DATE — DATE
- APPROVAL_DATE — DATE
- RETURN_DATE — DATE
- STATUS_DESC — VARCHAR2
- UPD_DATE — DATE
- SEMS_CLS — VARCHAR2
- ATT_FILE1 — NUMBER
- ATT_FILE2 — NUMBER
- ATT_FILE3 — NUMBER
- ATT_FILE4 — NUMBER
- ATT_FILE5 — NUMBER
- 일련번호 (SEQ2) — NUMBER — 외래 키 → 사용자.일련번호 — NOT NULL
사용자 (USERS)
- 일련번호 (SEQ) — NUMBER — 기본 키 — NOT NULL
- ID — VARCHAR2 — NOT NULL
- 사업자번호 (CO_NO) — VARCHAR2
- 구분번호 (CO_TYPE) — VARCHAR2
- 비밀번호 (PWD) — VARCHAR2
- 사용자그룹 (CD_GRP) — VARCHAR2 — NOT NULL
- 담당자명 (CO_NAME) — VARCHAR2
- 대표자명 (CO_CEO) — VARCHAR2
- CD_OWN — VARCHAR2
- CD_REGN — VARCHAR2
- ZIPCODE — VARCHAR2
- ADDR — VARCHAR2
- ADDR_DTL — VARCHAR2
- CO_TEL — VARCHAR2
- CO_FAX — VARCHAR2
- USR_NAME — VARCHAR2
- USR_DEPT — VARCHAR2
- USR_POS — VARCHAR2
- USR_TEL — VARCHAR2
- USR_FAX — VARCHAR2
- USR_CEL — VARCHAR2
- USR_EMAIL — VARCHAR2
- DT_REG — CHAR
- DN_STR — VARCHAR2
- REFNUMBER — VARCHAR2
- AUTHCODE — VARCHAR2
- AUTHRMK — VARCHAR2
- MNG_AGNCD — VARCHAR2
- BIZ_CD — VARCHAR2
- EDATE — VARCHAR2
- USER_ID — VARCHAR2 — NOT NULL
- UPD_DATE — DATE
- EQP_OPEN_DT_1 — VARCHAR2
- STATUS — VARCHAR2
- PRES_BIRDAY — VARCHAR2
- PRES_TEL — VARCHAR2
- PRES_POSTNO — VARCHAR2
- PRES_ADDR1 — VARCHAR2
- PRES_ADDR2 — VARCHAR2
- Field
시설관리기준 적용 제외시설 (INSTALLSPECEX)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- FAC_CD — VARCHAR2
- FAC_MID_CD — VARCHAR2
- PROCESS_SEQ — NUMBER — NOT NULL
- PROC_ID — VARCHAR2
- FAC_ID — VARCHAR2
- PND_ID — VARCHAR2
- MASSBALANCE_SEQ — NUMBER — NOT NULL
- DENST — VARCHAR2
- SCAL — VARCHAR2
- FAC_EXCD — VARCHAR2
- FAC_RMK — VARCHAR2
- USE_YN — VARCHAR2
- UPD_DATE — DATE
- EX_GUBUN — VARCHAR2
- RPT_YY — VARCHAR2
- SEQ (SEQ2) — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL
신고(운영/변경/점검)별 설치명세 (REPORTSPEC)
- 일련번호 (SEQ) — NUMBER — 기본 키 — NOT NULL
- 사업자번호 (USERS_SEQ) — NUMBER — NOT NULL
- 신고번호 (REPORT_SEQ) — NUMBER — NOT NULL
- 시설번호 (INSTALLSPEC_SEQ) — NUMBER
- 배출시설대분류 (FAC_CD) — VARCHAR2
- FAC_MID_CD — VARCHAR2
- PROCESS_SEQ — NUMBER — NOT NULL
- PROC_ID — VARCHAR2
- FAC_ID — VARCHAR2
- PND_ID — VARCHAR2
- MASSBALANCE_SEQ — NUMBER — NOT NULL
- DENST — VARCHAR2
- SCAL — VARCHAR2
- FAC_STDCD — VARCHAR2
- FAC_RMK — VARCHAR2
- USE_YN — VARCHAR2
- UPD_DATE — DATE
- SEQ (SEQ2) — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL
운영기록 (OPERRECORD)
- SEQ — NUMBER — 기본 키 — NOT NULL
- USERS_SEQ — NUMBER — NOT NULL
- FAC_STD_CD — VARCHAR2
- INSTALLSPEC_SEQ — NUMBER — NOT NULL
- DETAIL_FAC_NM — VARCHAR2
- FAC_PART — VARCHAR2
- FAC_QTY — NUMBER
- FROM_YMD — VARCHAR2
- TO_YMD — VARCHAR2
- RESULT1_RMK — VARCHAR2
- RESULT2_RMK — VARCHAR2
- RESULT3_RMK — VARCHAR2
- RESULT4_RMK — VARCHAR2
- RESULT5_RMK — VARCHAR2
- RESULT6_RMK — VARCHAR2
- RESULT7_RMK — VARCHAR2
- RESULT8_RMK — VARCHAR2
- RESULT9_RMK — VARCHAR2
- RESULT10_RMK — VARCHAR2
- UPD_DATE — DATE
- RPT_YY — VARCHAR2
- SEQ (SEQ2) — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL
첨부화일 (ATTACH)
- SEQ — NUMBER — 기본 키 — NOT NULL
- SVR_ID — VARCHAR2
- SRC_ID — VARCHAR2
- PATH — VARCHAR2
- IMG_SIZE — VARCHAR2
- USERS_SEQ — NUMBER
- SEQ (SEQ2) — NUMBER — 외래 키 → 사업장별 운영/변경 신고, 점검보고.SEQ — NOT NULL