테스트
테이블 (9)
TB_ASSY_HISTORY
- ID — INT — 기본 키 — NOT NULL
- LINE_NO — INT
- SHAFT_OGR — VARCHAR(50) — 외래 키 → TB_BCR_MASTER.READ_BCR — NOT NULL
- SHAFT_LSR — VARCHAR(50)
- CORE_OGR — VARCHAR(50)
- CORE_L3 — VARCHAR(50)
- CORE_L4 — VARCHAR(50)
- FRT_PLATE — VARCHAR(50)
- RR_PLATE — VARCHAR(50)
- CREATE_TIME — DATETIME2(3)
TB_BCR_MASTER
- ID — INT — 기본 키 — NOT NULL
- LINE_NO — INT — NOT NULL
- IS_USED — INT — NOT NULL
- MODEL — VARCHAR(20) — NOT NULL
- GROUP — VARCHAR(20) — NOT NULL
- PART_NO — VARCHAR(50) — 외래 키 → TB_MODEL_LIST.PART_NO — NOT NULL
- READ_BCR — VARCHAR(50)
- CREATED_BCR — VARCHAR(50)
- DATE — CHAR(6) — NOT NULL
- SERIAL_NO — INT — NOT NULL
- CREATE_TIME — DATETIME2(3)
TB_CURRENT_PLC_STATUS
- PROCESS_CODE — INT — 기본 키 — NOT NULL
- LINE_NO — INT
- PROCESS_NAME — NVARCHAR(100)
- STATUS — NVARCHAR(20) — NOT NULL
- LAST_UPDATE_TIME — DATETIME2(3)
TB_MODEL_LIST
- ID — INT — 기본 키 — NOT NULL
- MODEL_CODE — VARCHAR(20) — NOT NULL
- GROUP — VARCHAR(20) — NOT NULL
- PART_NO — VARCHAR(50) — NOT NULL
- IS_ACTIVE — INT
TB_PLC_STATUS_HISTORY
- ID — BIGINT — 기본 키 — NOT NULL
- LINE_NO — INT
- PROCESS_CODE — INT — 외래 키 → TB_CURRENT_PLC_STATUS.PROCESS_CODE — NOT NULL
- STATUS — NVARCHAR(20) — NOT NULL
- START_TIME — DATETIME2(3)
- END_TIME — DATETIME2(3)
- DURATION_SEC — INT
TB_PROCESS_DATA_600
- ID — BIGINT — 기본 키 — NOT NULL
- LINE_NO — INT
- PALLET_NO — VARCHAR(20)
- SHAFT_OGR — VARCHAR(50)
- CORE_OGR — VARCHAR(50)
- RESULT — VARCHAR(20)
- VALUE_1 — NVARCHAR(255)
- VALUE_2 — NVARCHAR(255)
- VALUE_3 — NVARCHAR(255)
- JOB_TIME — DATETIME2(3)
TB_RFID_HISTORY
- ID — BIGINT — 기본 키 — NOT NULL
- LINE_NO — INT
- PROCESS_CODE — INT — NOT NULL
- BCR_OGR — VARCHAR(50)
- PALLET_NO — VARCHAR(20)
- RESULT_VALUE — INT — NOT NULL
- EVENT_TIME — DATETIME2(3)
TB_WORK_HISTORY
- ID — INT — 기본 키 — NOT NULL
- LINE_NO — INT
- BCR_OGR — VARCHAR(50) — 외래 키 → TB_WORK_TRACKING.BCR_OGR — NOT NULL
- PALLET_NO — VARCHAR(20)
- STEP_CODE — INT — NOT NULL
- RESULT — VARCHAR(10)
- EVENT_TIME — DATETIME2(3)
TB_WORK_TRACKING
- ID — INT — 기본 키 — NOT NULL
- LINE_NO — INT
- BCR_OGR — VARCHAR(50) — 외래 키 → TB_BCR_MASTER.READ_BCR — NOT NULL
- PALLET_NO — VARCHAR(20)
- CURRENT_STEP — INT — NOT NULL
- LAST_RESULT — VARCHAR(10)
- IS_COMPLETED — INT
- UPDATE_TIME — DATETIME2(3)