일반출장위험성평가표신설(HRMS)
테이블 (5)
Copy Of RISMDTL (출장 위험성평가표상세)
- SEQ (Key2) — NUMERIC(5,0) — 기본 키 — NOT NULL
- RIS_FACTOR (Field) — VARCHAR(4000)
- RIS_RESULT (Field2) — VARCHAR(200)
- RIS_ACTION (Field3) — VARCHAR(4000)
- RIS_FRE (Field4) — NUMERIC(5,0)
- RIS_ROB (Field5) — NUMERIC(5,0)
- RIS_VAL (Field6) — NUMERIC(5,0)
- INS_ID (Field8) — VARCHAR(20)
- INS_TMS (Field10) — TIMESTAMP
- UPD_ID (Field11) — VARCHAR(20)
- UPD_TMS (Field12) — TIMESTAMP
- EMP_NO (Key22) — VARCHAR(20) — 외래 키 → RISAMST.EMP_NO — NOT NULL
- RISA_NO (Key3) — VARCHAR(100) — 외래 키 → RISAMST.RISA_NO — NOT NULL
- MNG_CD (Key23) — VARCHAR(40) — 외래 키 → RISMMST.MNG_CD — NOT NULL
RISADTL_ADD (출장 위험성평가표상세(추가적위험성 사항))
- SEQ (Key2) — NUMERIC(5,0) — 기본 키 — NOT NULL
- RIS_ADD (Field) — VARCHAR(4000)
- RIS_FRE (Field4) — NUMERIC(5,0)
- RIS_ROB (Field5) — NUMERIC(5,0)
- RIS_VAL (Field6) — NUMERIC(5,0)
- IMPLE_TMS (Field8) — TIMESTAMP
- INS_ID (Field10) — VARCHAR(20)
- INS_TMS (Field11) — TIMESTAMP
- UPD_ID (Field12) — VARCHAR(20)
- UPD_TMS (Field2) — TIMESTAMP
- SEQ (Key22) — NUMERIC(5,0) — 외래 키 → Copy Of RISMDTL.SEQ — NOT NULL
RISAMST (출장 위험성평가표)
- EMP_NO (Key2) — VARCHAR(20) — 기본 키 — NOT NULL
- RISA_NO (Key) — VARCHAR(100) — 기본 키 — NOT NULL
- WRK_DT (Field) — VARCHAR(20)
- CFR_NO (Field2) — VARCHAR(20)
- CFR_DT (Field3) — VARCHAR(20)
- APP_YN (Field4) — VARCHAR(1)
- STS (Field5) — VARCHAR(1)
- INS_ID (Field6) — VARCHAR(20)
- INS_TMS (Field7) — TIMESTAMP
- UPD_ID (Field8) — VARCHAR(20)
- UPD_TMS (Field9) — TIMESTAMP
- MNG_CD (Key22) — VARCHAR(40) — 외래 키 → RISMMST.MNG_CD — NOT NULL
RISMDTL (위험성평가표관리 상세)
- SEQ (Key) — NUMERIC(5,0) — 기본 키 — NOT NULL
- RIS_FACTOR (Field) — VARCHAR(4000)
- RIS_RESULT (Field2) — VARCHAR(200)
- RIS_ACTION (Field3) — VARCHAR(4000)
- RIS_FRE (Field4) — NUMERIC(5,0)
- RIS_ROB (Field5) — NUMERIC(5,0)
- RIS_VAL (Field6) — NUMERIC(5,0)
- ORD (Field7) — NUMERIC(5,0)
- INS_ID (Field8) — VARCHAR(20)
- INS_TMS (Field10) — TIMESTAMP
- UPD_ID (Field11) — VARCHAR(20)
- UPD_TMS (Field12) — TIMESTAMP
- MNG_CD (Key2) — VARCHAR(40) — 외래 키 → RISMMST.MNG_CD — NOT NULL
RISMMST (위험성평가표관리)
- MNG_CD (Key2) — VARCHAR(40) — 기본 키 — NOT NULL
- MNG_NM (Field) — VARCHAR(200)
- ACT_NM (Field2) — VARCHAR(200)
- WRK_NM (Field3) — VARCHAR(200)
- USE_YN (Field4) — VARCHAR(1)
- INS_ID (Field5) — VARCHAR(20)
- INS_TMS (Field6) — TIMESTAMP
- UPD_ID (Field7) — VARCHAR(20)
- UPD_TMS (Field8) — TIMESTAMP