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좌표)