한국단자 노무관리
테이블 (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)