기준정보_물리
테이블 (13)
TB_ATTFILE
- ATFL_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- ATFL_TY — CHAR(1) — NOT NULL
- ATFL_REAL_FILE_NM — VARCHAR2(256) — NOT NULL
- ATFL_EXT — VARCHAR2(50) — NOT NULL
- ATFL_URL — VARCHAR2(256) — NOT NULL
- ATFL_STRE_PATH — VARCHAR2(2000) — NOT NULL
- ATFL_VOL — VARCHAR2(50) — NOT NULL
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
TB_ATTFILEHSMP
- HIST_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- ATFL_NO — VARCHAR2(50) — 기본 키 — NOT NULL
TB_CLASS
- CLSS_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- CLSS_CD — VARCHAR2(50) — NOT NULL
- CLSS_NM — VARCHAR2(256) — NOT NULL
- USE_YN — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_CLASSDATA
- CLSS_MANP_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- CLSS_SN — VARCHAR2(50) — NOT NULL
- ORDR — NUMBER — NOT NULL
- CLSS_MANP_CD — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_EQUIPMENTBM
- EQ_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- ITEM_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- SET_QY — NUMBER — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_EQUIPMENTHS
- EQ_HIST_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- EQ_SN (EQ_SN2) — VARCHAR2(50) — 외래 키 → TB_EQUIPMENTMS.EQ_SN — NOT NULL
- HIST_CONT — VARCHAR2(5000)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- UPT_DT — DATE
- UPT_ID — VARCHAR2(50)
TB_EQUIPMENTMS
- EQ_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- EQ_NO — VARCHAR2(18) — NOT NULL
- EQ_NM — VARCHAR2(256) — NOT NULL
- USE_YN — VARCHAR2(50) — NOT NULL
- FNLC_SN — VARCHAR2(50) — NOT NULL
- UPER_EQ_SN — VARCHAR2(50) — NOT NULL
- FILD_MGMT_NO — VARCHAR2(60) — NOT NULL
- EQ_CATE_CD — VARCHAR2(50) — NOT NULL
- EQ_SE_CD — VARCHAR2(50) — NOT NULL
- OBJT_TY_CD — VARCHAR2(50) — NOT NULL
- CLSS_SN — VARCHAR2(50) — NOT NULL
- MGMT_DEPT — VARCHAR2(50) — NOT NULL
- WKPL_SN — VARCHAR2(50) — NOT NULL
- ASSET_NO — VARCHAR2(18) — NOT NULL
- FRST_OPER_DT — VARCHAR2(8) — NOT NULL
- COCEN_CD — VARCHAR2(50)
- MAKER — VARCHAR2(500)
- MAKE_DT — VARCHAR2(8)
- STT — CHAR(1) — NOT NULL
TB_EQUIPMENTSP
- EQ_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- EQ_MANP_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- ORDR — NUMBER — NOT NULL
- CLSS_MANP_CD — VARCHAR2(50) — NOT NULL
- MANP_VAL — VARCHAR2(256) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_FLOCATIONBM
- FNLC_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- ITEM_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- SET_QY — NUMBER — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_FLOCATIONHS
- FNLC_HIST_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- FNLC_SN (FNLC_SN2) — VARCHAR2(50) — 외래 키 → TB_FLOCATIONMS.FNLC_SN — NOT NULL
- HIST_CONT — VARCHAR2(5000)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- UPT_DT — DATE
- UPT_ID — VARCHAR2(50)
TB_FLOCATIONMS
- FNLC_SN — VARCHAR2(50) — 기본 키 — NOT NULL
- FNLC_NO — VARCHAR2(18) — NOT NULL
- FNLC_NM — VARCHAR2(256) — NOT NULL
- UPER_FNLC_SN — VARCHAR2(50) — NOT NULL
- USE_YN — VARCHAR2(50) — NOT NULL
- FNLC_LC_CD — VARCHAR2(50) — NOT NULL
- MGMT_DEPT — VARCHAR2(50) — NOT NULL
- WKPL_SN — VARCHAR2(50) — NOT NULL
- ASSET_NO — VARCHAR2(18) — NOT NULL
- COCEN_CD — VARCHAR2(50)
- FRST_OPER_DT — VARCHAR2(8) — NOT NULL
- ROOM_NO — VARCHAR2(128)
- FCLT_GRP_CD — VARCHAR2(50) — NOT NULL
- STT — CHAR(1) — NOT NULL
TB_MATERIALS
- ITEM_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- ITEM_NM — VARCHAR2(500) — NOT NULL
- LCLAS_NM — VARCHAR2(500) — NOT NULL
- MLSFC_NM — VARCHAR2(500)
- SCLAS_NM — VARCHAR2(500)
- DTLCLFC_NM — VARCHAR2(500)
- BAS_UNIT — VARCHAR2(50)
- USE_YN — CHAR(1) — NOT NULL
TB_MATERIALSTCK
- ITEM_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- EVAL_TYPE — VARCHAR2(18) — 기본 키 — NOT NULL
- ITEM_LC_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- ITEM_QY — NUMBER