한국단자 노무관리

테이블 (7)

UTB_IF_MOTE_R_001 (I/F 테이블)

  • ROW_STAMP (Field7) — BIGINT(IDENTITY) — 기본 키
  • IP (Key) — VARCHAR(50) — NOT NULL
  • MOTE_ID (Key2) — VARCHAR(50) — NOT NULL
  • UID (Field) — VARCHAR(50)
  • TIME_ZONE_ID (Field2) — CHAR(1)
  • TAG_DTTM (Field8) — DATETIME
  • IN_OUT (Field9) — CHAR(1)
  • IF_FLAG (Field10) — CHAR(1)
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)

UTB_MOTE (모트장비ID)

  • MOTE_ID (Key) — VARCHAR(50) — 기본 키 — NOT NULL
  • IP (Key2) — VARCHAR(50) — 기본 키 — NOT NULL
  • MOTE_NAME (Field) — VARCHAR(100)
  • VALID (Field2) — INT
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)

UTB_NFC_CARD_EMP (작업자 NFC CARD ID 마스터)

  • EMP_ID (Field) — NVARCHAR(13) — 기본 키
  • EMP_NO (Key2) — VARCHAR(20) — 기본 키 — NOT NULL
  • PLANT_ID (Key) — VARCHAR(20) — NOT NULL
  • EMP_NAME (Field2) — NVARCHAR(30)
  • POS_ID (Field8) — CHAR(2)
  • COMP_ID (Field15) — CHAR(2)
  • MANAGE_ID (Field11) — VARCHAR(10)
  • MANAGE_NAME (Field10) — VARCHAR(100)
  • WORKER_TYPE (Field9) — VARCHAR(50)
  • GUBUN (Field12) — CHAR(1)
  • NFC_FLAG (Field13) — CHAR(1)
  • UID (Field14) — NVARCHAR(17)
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)

UTB_NFC_PROC (작업그룹)

  • NFC_PROC_ID (Field) — NVARCHAR(20) — 기본 키
  • PLANT_ID (Key) — VARCHAR(20) — NOT NULL
  • NFC_PROC_NAME (Field2) — NVARCHAR(100)
  • DIRECT_SUPPROT_FLAG (Field11) — TINYINT
  • SORT_SEQ (Field8) — INT
  • VALID (Field9) — TINYINT
  • REMARK (Field10) — NVARCHAR(100)
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)
  • PROC_GROUP_ID (Key2) — NVARCHAR(20) — NOT NULL

UTB_NFC_PROC_EMP (작업그룹 사원 매핑)

  • PLANT_ID (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • NFC_PROC_ID (Key2) — NVARCHAR(20) — 기본 키 — NOT NULL
  • EMP_ID (Field) — VARCHAR(50)
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)

UTB_NFC_PROC_MOTE (모트장비별 작업그룹)

  • MOTE_ID (PK1) — 기본 키
  • IP (PK2) — 기본 키
  • PLANT_ID (Key) — NOT NULL
  • NFC_PROC_ID (Key2) — NOT NULL
  • CREATE_DTTM (Field3)
  • SAVE_DTTM (Field4)
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)

UTB_NFC_PROC_WORK_SHOP (작업그룹 작업장 매핑)

  • PLANT_ID (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • NFC_PROC_ID (Field) — NVARCHAR(20) — 기본 키
  • WORK_SHOP_ID (Field10) — NVARCHAR(20) — 기본 키
  • STD_SPRN (Field8) — INT
  • CREATE_DTTM (Field3) — DATETIME
  • SAVE_DTTM (Field4) — DATETIME
  • CREATE_BY (Field5) — VARCHAR(50)
  • SAVE_BY (Field6) — VARCHAR(50)
  • ROW_STAMP (Field7) — BIGINT(IDENTITY)