123
Tables (8)
TB_PINSPECTIONBS
- CHCK_NO — VARCHAR2(18) — Primary key — NOT NULL
- UPT_HIST_CNT — NUMBER — Primary key — NOT NULL
- CHCK_FACT_SN — VARCHAR2(50) — Foreign key → TB_PINSPECTIONIT.CHCK_FACT_SN — NOT NULL
- CHCK_BAS_VAL — NUMBER — NOT NULL
TB_PINSPECTIONGR
- CHCK_FACT_GRP_NO — VARCHAR2(50) — Primary key — NOT NULL
- CHCK_FACT_GRP_NM — VARCHAR2(256) — NOT NULL
- CHCK_FACT_GRP_ORDR — NUMBER — NOT NULL
- CHCK_NO — VARCHAR2(18) — NOT NULL
- UPT_HIST_CNT — NUMBER — NOT NULL
TB_PINSPECTIONGRMP
- CHCK_FACT_SN — VARCHAR2(50) — Foreign key → TB_PINSPECTIONIT.CHCK_FACT_SN — NOT NULL
- CHCK_FACT_GRP_NO — VARCHAR2(50) — Foreign key → TB_PINSPECTIONGR.CHCK_FACT_GRP_NO — NOT NULL
- CHCK_ORDR — NUMBER — NOT NULL
TB_PINSPECTIONIT
- CHCK_FACT_SN — VARCHAR2(50) — Primary key — NOT NULL
- CHCK_NO — VARCHAR2(18) — NOT NULL
- UPT_HIST_CNT — NUMBER — NOT NULL
- CHCK_ORDR — NUMBER — NOT NULL
- CHCK_DTLS — VARCHAR2(256) — NOT NULL
- CHCK_WAY — VARCHAR2(256)
- CHCK_MAX_VAL — NUMBER
- CHCK_MIN_VAL — NUMBER
- CHCK_STDR_VAL — NUMBER
- OPER_YN — CHAR(1) — NOT NULL
- NUM_INPUT_YN — CHAR(1) — NOT NULL
- UNIT_CD — VARCHAR2(50)
- MSRE_UNT — VARCHAR2(256)
- STT — CHAR(1) — NOT NULL
TB_PINSPECTIONMS
- CHCK_NO — VARCHAR2(18) — Primary key — NOT NULL
- UPT_HIST_CNT — NUMBER — Primary key — NOT NULL
- NEW_YN — CHAR(1) — NOT NULL
- CHCK_NM — VARCHAR2(256) — NOT NULL
- MSTR_STT — VARCHAR2(50) — NOT NULL
- FNLC_SN — VARCHAR2(50) — NOT NULL
- EQ_SN — VARCHAR2(50) — NOT NULL
- PRID_CR_RULE — VARCHAR2(50) — NOT NULL
- PRID — NUMBER — NOT NULL
- PRID_TY — VARCHAR2(50) — NOT NULL
- PRID_AUTO_RULE — VARCHAR2(50) — NOT NULL
- PRID_OPER_STDE — VARCHAR2(8) — NOT NULL
- PRID_WK — VARCHAR2(18) — NOT NULL
- PRID_DAY — VARCHAR2(18) — NOT NULL
- WKPL_SN — VARCHAR2(50) — NOT NULL
- MGMT_DEPT — VARCHAR2(18) — NOT NULL
- CHCK_KND — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_PINSPECTIONOD
- CKDR_NO — VARCHAR2(18) — Primary key — NOT NULL
- CHCK_NO — VARCHAR2(18) — NOT NULL
- UPT_HIST_CNT — NUMBER — NOT NULL
- YEAR — VARCHAR2(4) — NOT NULL
- MT — VARCHAR2(2) — NOT NULL
- WK — VARCHAR2(18) — NOT NULL
- CR_DT — VARCHAR2(8) — NOT NULL
- PLAN_DT — VARCHAR2(8) — NOT NULL
- CHCK_DT — VARCHAR2(8)
- CHCK_TIME — VARCHAR2(4)
- CMPTER_ID — VARCHAR2(50)
- COMP_DT — VARCHAR2(8)
- COMP_TIME — VARCHAR2(4)
- COMP_YN — CHAR(1)
- SBCT_CD — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_PINSPECTIONRS
- CKDR_NO — VARCHAR2(18) — Primary key — NOT NULL
- CHCK_NO — VARCHAR2(18) — Primary key — NOT NULL
- UPT_HIST_CNT — NUMBER — Primary key — NOT NULL
- OBJT_SN — VARCHAR2(50) — Primary key — NOT NULL
- CHCK_FACT_SN — VARCHAR2(50) — Primary key — NOT NULL
- EXET_YN_CD — VARCHAR2(50) — NOT NULL
- CHCK_RES — VARCHAR2(50) — NOT NULL
- CHCK_VAL — NUMBER — NOT NULL
- CHCK_REG_ID — VARCHAR2(50) — NOT NULL
- CHCK_REG_NM — VARCHAR2(128) — NOT NULL
- MHRL_INFO — VARCHAR2(50)
- MSS_USER_ID — VARCHAR2(50)
- CHCK_DT — VARCHAR2(8) — NOT NULL
- CHCK_TIME — VARCHAR2(4) — NOT NULL
- STT — CHAR(1) — NOT NULL
- CHCK_STT — CHAR(1) — NOT NULL
TB_PINSPECTIONTA
- CHCK_NO — VARCHAR2(18) — Primary key — NOT NULL
- UPT_HIST_CNT — NUMBER — Primary key — NOT NULL
- OBJT_SN — VARCHAR2(50) — Primary key — NOT NULL
- FNLC_SN — VARCHAR2(50) — NOT NULL
- EQ_SN — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL