테스트

테이블 (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)