1

테이블 (39)

Carrier 인입 이력 (TB_CARRIER_HIS)

  • CARRIER_HIS_ID (Key) — 기본 키 — NOT NULL
  • CARRIER_TYPE_ID (Key3) — 외래 키 → TB_CARRIER_TYPE.CARRIER_TYPE_ID — NOT NULL
  • LOAD_PORT_MAP_ID (Key2) — 외래 키 → TB_LOAD_PORT_MAP.LOAD_PORT_MAP_ID — NOT NULL
  • CARRIER_ID (Field2)
  • CARRIER_LOADED_DATE (Field3)
  • CARRIER_UNLOADED_DATE (Field4)
  • SUBSTRATE_COUNT (Field5)

TB_ALIGNPOINT_GROUP (Untitled35)

  • ALIGNPOINT_GROUP_ID (Key) — 기본 키 — NOT NULL
  • RECIPE_MAP_ALIGNPOINT_INFO_ID (Key2) — 외래 키 → TB_RECIPE_MAP_ALIGN_INFO.RECIPE_MAP_ALIGN_INFO_ID — NOT NULL
  • ALIGNPOINT_GROUP_NAME (Field11)
  • ALIGNPOINT_GROUP_TARGET_LEVEL (Field)
  • ALIGNPOINT_GROUP_ORIGIN_REFERENCE_POINT (Field2)
  • ALIGNPOINT_GROUP_ALIGNPOINT_ITEM_COUNT (Field3)
  • ALIGNPOINT_GROUP_GROUP_COLOR (Field4)
  • ALIGNPOINT_GROUP_RADIUS (Field5)
  • ALIGNPOINT_GROUP_IS_ENABLED (Field6)
  • ALIGNPOINT_GROUP_IS_CAPTURE_ENABLED (Field7)
  • ALIGNPOINT_GROUP_USE_FOR_ALIGN (Field8)
  • ALIGNPOINT_GROUP_DISTANCE_THRESHOLD (Field9)
  • ALIGNPOINT_GROUP_MEASURE_DISTANCE (Field10)

TB_ALIGNPOINT_ITEM (Untitled36)

  • ALIGNPOINT_ITEM_ID (Key) — 기본 키 — NOT NULL
  • ALIGNPOINT_GROUP_ID (Key2) — 외래 키 → TB_ALIGNPOINT_GROUP.ALIGNPOINT_GROUP_ID — NOT NULL
  • ALIGNPOINT_ITEM_NAME (Field3)
  • ALIGNPOINT_ITEM_DESIGN_POS (Field)
  • ALIGNPOINT_ITEM_CAPTURE_POS (Field2)

TB_CARRIER_MAP_STATE_HIS (Untitled30)

  • CARRIER_MAP_STATE_HIS_ID (Key) — 기본 키 — NOT NULL
  • LOT_CARRIER_MAP_ID (Key2) — 외래 키 → TB_LOT_CARRIER_MAP.LOT_CARRIER_MAP_ID — NOT NULL
  • CARRIER_STATE_TYPE_ID (Key3) — 외래 키 → TB_CARRIER_STATE_TYPE.CARRIER_STATE_TYPE_ID — NOT NULL
  • EVENT_DATE (Field)
  • EVENT_DESC (Field2)
  • EVENT_ORDER (Field3)

TB_CARRIER_STATE_TYPE (Untitled25)

  • CARRIER_STATE_TYPE_ID (Key) — 기본 키 — NOT NULL
  • CARRIER_STATE_TYPE_NAME (Field)

TB_CARRIER_TYPE (Untitled5)

  • CARRIER_TYPE_ID (Key) — 기본 키 — NOT NULL
  • CARRIER_TYPE_NAME (Field)

TB_LOAD_PORT_MAP (Untitled28)

  • LOAD_PORT_MAP_ID (Key) — 기본 키 — NOT NULL
  • LOAD_PORT_ROLE_TYPE_ID (Key3) — 외래 키 → TB_LOAD_PORT_ROLE_TYPE.LOAD_PORT_ROLE_TYPE_ID — NOT NULL
  • LOAD_PORT_TYPE_ID (Key2) — 외래 키 → TB_LOAD_PORT_TYPE.LOAD_PORT_TYPE_ID — NOT NULL
  • LOAD_PORT_NO (Field)

TB_LOAD_PORT_ROLE_TYPE (Untitled29)

  • LOAD_PORT_ROLE_TYPE_ID (Key) — 기본 키 — NOT NULL

TB_LOAD_PORT_TYPE (Untitled27)

  • LOAD_PORT_TYPE_ID (Key) — 기본 키 — NOT NULL
  • LOAD_PORT_NAME (Field)
  • LOAD_PORT_ROLE (Field2)

TB_LOT_CARRIER_MAP (Untitled19)

  • LOT_CARRIER_MAP_ID (Key2) — 기본 키 — NOT NULL
  • LOT_ID (Field3) — 외래 키 → TB_LOT_HIS.LOT_ID
  • CARRIER_HIS_ID (Key) — 외래 키 → Carrier 인입 이력.CARRIER_HIS_ID — NOT NULL
  • ASSIGN_ORDER (Field4)
  • Field5

TB_LOT_HIS (Untitled)

  • LOT_ID (Field3) — 기본 키
  • RECIPE_ID (Key) — 외래 키 → TB_RECIPE.RECIPE_ID — NOT NULL
  • OPERATOR_ID
  • LOT_START_DATE (START_DATE)
  • LOT_END_DATE (END_DATE)
  • QUANTITY_TYPE_ID
  • QUANTITY
  • END_REASON (Field)
  • PROCESSED_QUANTITY (Field2)
  • Field4

TB_OBJECT_ROLE_TYPE (비전) 피사체 역할 테이블)

  • OBJECT_ROLE_TYPE_ID (아이디) — 기본 키 — NOT NULL
  • OBJECT_NAME (피사체 역할)

TB_OBJECT_TYPE (비전)피사체 종류 테이블)

  • OBJECT_TYPE_ID (아이디) — 기본 키 — NOT NULL
  • OBJECT_TYPE_NAME (피사체 종류 이름)

TB_OPERATOR (Untitled2)

  • OPERATOR_ID — 기본 키 — NOT NULL

TB_PROCESS_HIS (Untitled16)

  • PROCESS_HIS_ID (Key) — 기본 키 — NOT NULL
  • LOT_ID (Field32) — 외래 키 → TB_LOT_HIS.LOT_ID
  • SOURCE_UNIT_HIS_ID (Field2)
  • TARGET_UNIT_HIS_ID (Field3)
  • ERROR_REASON (Field5)
  • ALIGN_OFFSET_X (Field)
  • ALIGN_OFFSET_Y (Field6)
  • ALIGN_OFFSET_T (Field7)
  • SOURCE_UNIT_MEASURED_CENTER_X (Field10)
  • SOURCE_UNIT_MEASURED_CENTER_Y (Field11)
  • SOURCE_UNIT_MEASURED_CENTER_T (Field12)
  • TARGET_UNIT_CALCULATED_CENTER_X (Field13)
  • TARGET_UNIT_CALCULATED_CENTER_Y (Field14)
  • TARGET_UNIT_CALCULATED_CENTER_T (Field15)

TB_PROCESS_POINT_HIS (Untitled18)

  • POINT_HIS_ID (Key) — 기본 키 — NOT NULL
  • PROCESS_HIS_ID (Key2) — 외래 키 → TB_PROCESS_HIS.PROCESS_HIS_ID — NOT NULL
  • VISION_HIS_ID (Key3) — 외래 키 → TB_VISION_HIS.VISION_HIS_ID — NOT NULL
  • POINT_INDEX (Field)
  • POINT_NAME (Field7)
  • POINT_DESC (Field2)
  • SOURCE_UNIT_CALCULATED_POINT_X (Field3)
  • SOURCE_UNIT_CALCULATED_POINT_Y (Field4)
  • SOURCE_UNIT_MEASURED_POINT_X (Field5)
  • SOURCE_UNIT_MEASURED_POINT_Y (Field6)

TB_PROCESS_STATE_HIS (Untitled4)

  • PROCESS_STATE_HIS_ID (Key) — 기본 키 — NOT NULL
  • LOT_ID (Field3) — 외래 키 → TB_LOT_HIS.LOT_ID
  • PROCESS_STATE_TYPE_ID — 외래 키 → TB_PROCESS_STATE_TYPE.PROCESS_STATE_TYPE_ID — NOT NULL
  • SOURCE_UNIT_HIS_ID (Field)
  • TARGET_UNIT_HIS_ID (Field2)
  • EVENT_DATE
  • EVENT_DESC

TB_PROCESS_STATE_TYPE (Untitled3)

  • PROCESS_STATE_TYPE_ID — 기본 키 — NOT NULL
  • PROCESS_STATE_TYPE_NAME

TB_QUANTITY_TYPE (TYPE)

  • QUANTITY_TYPE_ID — 기본 키 — NOT NULL
  • QUANTITY_TYPE_NAME

TB_RECIPE (Untitled37)

  • RECIPE_ID (Key) — 기본 키 — NOT NULL
  • RECIPE_MAP_ID (RECIPE_ID) — 외래 키 → TB_RECIPE_MAP.RECIPE_MAP_ID — NOT NULL

TB_RECIPE_MAP (Copy)

  • RECIPE_MAP_ID (RECIPE_ID) — 기본 키 — NOT NULL
  • RECIPE_MAP_STRUCT_INFO_ID (Key) — 외래 키 → TB_RECIPE_MAP_STRUCT_INFO.RECIPE_MAP_STRUCT_INFO_ID — NOT NULL
  • RECIPE_MAP_ALIGN_INFO_ID (Key2) — 외래 키 → TB_RECIPE_MAP_ALIGN_INFO.RECIPE_MAP_ALIGN_INFO_ID — NOT NULL
  • RECIPE_MAP_DESC (Field)
  • RECIPE_MAP_LAST_UPDATE_DATE (Field2)
  • RECIPE_MAP_LAST_UPDATE_OPERATOR_ID (Field3)
  • RECIPE_MAP_ALIGNMARK_INFO_ID (Field5)

TB_RECIPE_MAP_ALIGN_INFO (Untitled14)

  • RECIPE_MAP_ALIGN_INFO_ID (Key) — 기본 키 — NOT NULL
  • RECIPE_MAP_ALIGN_NAME (Field)
  • RECIPE_MAP_ALIGN_DESC (Field2)
  • RECIE_MAP_ALIGN_MATRIX (Field3)

TB_RECIPE_MAP_STRUCT_CELL_LAYER (Untitled15)

  • RECIPE_MAP_STRUCT_CELL_LAYER_ID (Key) — 기본 키 — NOT NULL

TB_RECIPE_MAP_STRUCT_INFO (Untitled12)

  • RECIPE_MAP_STRUCT_INFO_ID (Key) — 기본 키 — NOT NULL
  • MAP_LAYER_ID (Key2) — 외래 키 → TB_RECIPE_MAP_STRUCT_LAYER.LAYER_ID — NOT NULL
  • BLOCK_LAYER_ID (Key3) — 외래 키 → TB_RECIPE_MAP_STRUCT_LAYER.LAYER_ID — NOT NULL
  • UNIT_LAYER_ID (Key4) — 외래 키 → TB_RECIPE_MAP_STRUCT_LAYER.LAYER_ID — NOT NULL
  • CELL_LAYER_ID (Key5) — 외래 키 → TB_RECIPE_MAP_STRUCT_CELL_LAYER.RECIPE_MAP_STRUCT_CELL_LAYER_ID — NOT NULL

TB_RECIPE_MAP_STRUCT_LAYER (Untitled13)

  • LAYER_ID (Key) — 기본 키 — NOT NULL
  • RECIPE_MAP_STRUCT_LAYER_TYPE_ID (Field)
  • OFFSET (Field2)
  • PITCH (Field3)
  • SIZE (Field4)
  • ROWS (Field5)
  • COLS (Field6)

TB_SEQUENCE_HIS (Untitled11)

  • SEQUENCE_HIS_ID (Key2) — 기본 키 — NOT NULL
  • PROCESS_HIS_ID (Key) — 외래 키 → TB_PROCESS_HIS.PROCESS_HIS_ID — NOT NULL
  • SEQUENCE_START_DATE (Field5)
  • SEQUENCE_END_DATE (Field)
  • SEQUENCE_END_REASON (Field2)
  • SEQUENCE_SUCESS (Field3)
  • SEQUENCE_STEP_COUNT (Field4)

TB_SEQUENCE_STEP_HIS (Untitled33)

  • SEQUENCE_STEP_HIS_ID (Key3) — 기본 키 — NOT NULL
  • SEQUENCE_STEP_TYPE_ID (Key) — 외래 키 → TB_SEQUENCE_STEP_TYPE.SEQUENCE_STEP_TYPE_ID — NOT NULL
  • SEQUENCE_HIS_ID (Key2) — 외래 키 → TB_SEQUENCE_HIS.SEQUENCE_HIS_ID — NOT NULL
  • SEQUENCE_STEP_ORDER (Field)
  • SEQUENCE_STEP_START_DATE (Field2)
  • SEQUENCE_STEP_END_DATE (Field3)
  • SEQUENCE_STEP_END_REASON (Field5)
  • SEQUENCE_STEP_SUCCESS (Field4)
  • SEQUENCE_STEP_RESULT_COUNT (Field6)

TB_SEQUENCE_STEP_RESULT (Untitled34)

  • SEQUENCE_STEP_RESULT_ID (Key) — 기본 키 — NOT NULL
  • SEQUENCE_STEP_HIS_ID (Key3) — 외래 키 → TB_SEQUENCE_STEP_HIS.SEQUENCE_STEP_HIS_ID — NOT NULL
  • Field

TB_SEQUENCE_STEP_TYPE (Untitled32)

  • SEQUENCE_STEP_TYPE_ID (Key) — 기본 키 — NOT NULL
  • SEQUENCE_STEP_TYPE_NAME (Field)

TB_STEP_MOTION_PARAM_MAP (Untitled38)

  • STEP_MOTION_PARAM_ID (Key) — 기본 키 — NOT NULL
  • SEQUENCE_STEP_TYPE_ID (Key2) — 외래 키 → TB_SEQUENCE_STEP_TYPE.SEQUENCE_STEP_TYPE_ID — NOT NULL
  • AXIS_NO (Field)
  • VELOCITY (Field2)
  • ACCELERATION (Field3)
  • DECELERATION (Field4)
  • KILLDECALERATION (Field5)
  • JERK (Field6)
  • RESERVED_1 (Field7)
  • RESERVED_2 (Field8)
  • RESERVED_3 (Field9)

TB_SUBSTRATE_HIS (Untitled7)

  • SUBSTRATE_HIS_ID — 기본 키 — NOT NULL
  • CARRIER_HIS_ID — 외래 키 → Carrier 인입 이력.CARRIER_HIS_ID — NOT NULL
  • SUBSTRATE_TYPE_ID — 외래 키 → TB_SUBSTRATE_TYPE.SUBSTRATE_TYPE_ID — NOT NULL
  • SUBSTRATE_ID (Field3)
  • SUBSTRATE_LOADED_DATE (Field4)
  • SUBSTRATE_UNLOADED_DATE (Field5)
  • SUBSTRATE_ORDER (Field6)
  • UNIT_COUNT (Field7)
  • UNIT_ROWS (Field)
  • UNIT_COLS (Field2)

TB_SUBSTRATE_STATE_HIS (Untitled31)

  • SUBSTRATE_STATE_HIS_ID (Key) — 기본 키 — NOT NULL
  • SUBSTRATE_HIS_ID (Key2) — 외래 키 → TB_SUBSTRATE_HIS.SUBSTRATE_HIS_ID — NOT NULL
  • SUBSTRATE_STATE_TYPE_ID (Key3) — 외래 키 → TB_SUBSTRATE_STATE_TYPE.SUBSTRATE_STATE_TYPE_ID — NOT NULL
  • EVENT_DATE (Field)
  • EVENT_DESC (Field2)
  • EVENT_ORDER (Field3)

TB_SUBSTRATE_STATE_TYPE (Untitled24)

  • SUBSTRATE_STATE_TYPE_ID (Key) — 기본 키 — NOT NULL
  • SUBSTRATE_STATE_TYPE_NAME (Field)

TB_SUBSTRATE_TYPE (Untitled8)

  • SUBSTRATE_TYPE_ID (Key) — 기본 키 — NOT NULL
  • SUBSTRATE_TYPE_NAME (Field)

TB_UNIT_HIS (Untitled10)

  • UNIT_HIS_ID (Key) — 기본 키 — NOT NULL
  • UNIT_STATE_TYPE_ID (Key2) — 외래 키 → TB_UNIT_STATE_TYPE.UNIT_STATE_TYPE_ID — NOT NULL
  • UNIT_TYPE_ID (Key3) — 외래 키 → TB_UNIT_TYPE.UNIT_TYPE_ID — NOT NULL
  • CARRIER_HIS_ID (Key5) — 외래 키 → Carrier 인입 이력.CARRIER_HIS_ID — NOT NULL
  • SUBSTRATE_HIS_ID (Key4) — 외래 키 → TB_SUBSTRATE_HIS.SUBSTRATE_HIS_ID — NOT NULL
  • UNIT_ID (Field4)
  • UNIT_HANDLING_DONE_DATE (Field)
  • UNIT_COL_IDX (Field6)
  • UNIT_ROW_IDX (Field7)

TB_UNIT_STATE_TYPE (Untitled17)

  • UNIT_STATE_TYPE_ID (Key) — 기본 키 — NOT NULL
  • UNIT_STATE_TYPE_NAME (Field)

TB_UNIT_TYPE (Untitled9)

  • UNIT_TYPE_ID (Key) — 기본 키 — NOT NULL
  • UNIT_TYPE_NAME (Field2)

TB_VISION_HIS (비전) 이력 테이블)

  • VISION_HIS_ID (아이디) — 기본 키 — NOT NULL
  • OBJECT_ROLE_TYPE_ID (피사체 역할 아이디) — 외래 키 → TB_OBJECT_ROLE_TYPE.OBJECT_ROLE_TYPE_ID — NOT NULL
  • OBJECT_TYPE_ID (피사체 종류) — 외래 키 → TB_OBJECT_TYPE.OBJECT_TYPE_ID — NOT NULL
  • CAMERA_ID (카메라 식별자)
  • PIXEL_CENTER_X (피사체 중심 픽셀 X)
  • PIXEL_CENTER_Y (피사체 중심 픽셀Y)
  • PIXEL_CENTER_T (피사체 픽셀 Theta)
  • ACTUAL_CENTER_X (피사체 중심 X)
  • ACTUAL_CENTER_Y (피사체 중심 Y)
  • ACTUAL_CENTER_T (피사체 Theta)
  • REQEUSET_DATE (촬영 요청 수신 일시)
  • RESPONSE_DATE (촬영 응답 수신 일시)
  • VERTEX_COUNT (피사체가 구성한 점 수)
  • IMAGE_PATH (촬영 이미지 경로)

TB_VISION_VERTEX_HIS (비전)피사체 구성요소 테이블)

  • VERTEX_HIS_ID (아이디) — 기본 키 — NOT NULL
  • VISION_HIS_ID (Vision His 아이디) — 외래 키 → TB_VISION_HIS.VISION_HIS_ID — NOT NULL
  • VERTEX_ROLE (점 역할)
  • VERTEX_INDEX (순서)
  • PIXEL_X (픽셀 X좌표)
  • PIXEL_Y (픽셀 Y좌표)