비산배출시설관리

테이블 (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