Tracing method and system for drill point and drill spindle of mechanical drilling

Abstract

The invention discloses a mechanical drilling drill point and drill spindle tracing method and system, and the method comprises the steps: generating a code related to the identity information of a stored drill point, and storing the code in a first database; the aluminum sheets are bound with the products, and the multiple sets of aluminum sheet-product incidence relations are stored in a second database; storing a plurality of groups of drill point-drill point position-drill spindle association relationships in a third database; storing a plurality of groups of drill shaft-aluminum sheet association relationships in a fourth database; collecting report information of the product processing equipment, and storing the report information to a fifth database; integrating data of the first database, the second database, the third database, the fourth database, the fifth database, a pre-constructed drill point static information base and a pre-constructed drill point dynamic processing information base, and constructing a tracing information base; and when the product is abnormal, tracing to the associated drill point, drill spindle and other products based on the data of the tracing information base. The reliability of mechanical drilling process control can be improved, and the problem that tracing is difficult after a product is abnormal is solved.

Description

Technical Field

[0001] This invention relates to the field of packaging substrate manufacturing technology, and in particular to a method and system for tracing mechanical drilling bits and drill spindles. Background Technology

[0002] The mechanical drilling process involves dozens or even hundreds of machines, with each machine having multiple drill spindles (4 to 6). The monthly consumption of drill bits exceeds 20,000 per machine. The drill bits are supplied by multiple manufacturers, making the traceability work extremely complex when product abnormalities occur, and sometimes even impossible to trace normally.

[0003] As engineering demands for product quality continue to rise, the need for reliable process control becomes more urgent. Accurate traceability of drill bits and drill shafts is becoming increasingly important for factory production and management, and existing technologies cannot meet current traceability and management requirements. Summary of the Invention

[0004] The main objective of this invention is to provide a method and system for tracing drill bits and drill shafts in mechanical drilling, thereby improving the reliability of process control in mechanical drilling, solving the problem of difficulty in tracing after product abnormalities, optimizing factory production management processes, and improving product quality.

[0005] The technical solution adopted in this invention is: a method for tracing mechanical drilling bits and drill spindles, comprising: After the drill bit is put into storage, an encoding associated with its identity information is generated and stored in the first database; Before processing the product, aluminum sheets are bound to the product, and the association relationships between multiple sets of aluminum sheets and products are stored in the second database; the location of the drill bit and the drill spindle used to fix the drill bit, the drill bit and the location of the drill bit are bound respectively, and the association relationships between multiple sets of drill bits, drill bit positions and drill spindles are stored in the third database; during product processing, the drill spindle is bound to the aluminum sheet, and the association relationships between multiple sets of drill spindles and aluminum sheets are stored in the fourth database; after the product processing is completed, the reported information from the product processing equipment is collected and stored in the fifth database; A traceability information database is constructed by integrating data from the first to fifth databases, a pre-built static information database of drill bits, and a dynamic processing information database of drill bits. When a product malfunctions, it can be traced back to the associated drill bit, drill spindle, and other products based on data from the traceability database.

[0006] According to the above technical solution, the identity information includes the drill bit manufacturer, warehousing date, expiration date, and specifications.

[0007] According to the above technical solution, digital identifiers are provided at the locations of the aluminum sheet, product, drill spindle, and drill bit for scanning and reading the corresponding identification code; the digital identifiers are QR codes or barcodes.

[0008] According to the above technical solution, the method of binding the drill bit and the location of the drill bit includes: binding the code of the drill bit and the identity code of the digital identifier of the location of the drill bit that is scanned and read.

[0009] According to the above technical solution, the method of binding the drill bit location and the drill shaft includes: binding the identity code of the digital identifier set at the drill bit location that is scanned and read and the identity code of the digital identifier set on the drill shaft that is scanned and read.

[0010] According to the above technical solution, the method of binding aluminum sheet to product includes binding the digital identification code set on aluminum sheet to scan and read the identity code set on product to scan and read the identity code.

[0011] According to the above technical solution, the method of binding the drill spindle to the aluminum sheet includes binding the digital identification code set on the drill spindle and the digital identification code set on the aluminum sheet.

[0012] According to the above technical solution, the reporting information of the equipment for processing the product includes product information and hole processing information; the product information includes the product part number, batch number and identification code, and the hole processing information includes the hole diameter, hole type and number of holes.

[0013] According to the above technical solution, the drill bit static information database includes the specification information of each drill bit; the specification information includes the drill bit's diameter, type, number of grinding cycles, and brand. The drill bit dynamic machining information database includes the dynamic machining information of each drill bit; the dynamic machining information includes the drill bit's diameter, lifespan, compensation value, rotation speed, feed rate, and return speed.

[0014] Another aspect of the present invention provides a traceability system for mechanical drilling drill bits and drill shafts, including a drill bit code generation module, an association binding module, a data integration module, and an anomaly traceability module; The drill bit encoding generation module is used to generate an encoding associated with the identity information of the drill bit after it is put into storage, and store it in the first database; The association and binding module is used to bind aluminum sheets to products before processing, and store multiple sets of aluminum sheet-product association relationships in a second database; to bind the drill bit location and the drill spindle used to fix the drill bit, as well as the drill bit and the drill bit location, respectively, and store multiple sets of drill bit-drill bit-drill spindle association relationships in a third database; during product processing, to bind the drill spindle to the aluminum sheets, and store multiple sets of drill spindle-aluminum sheet association relationships in a fourth database; after the product processing is completed, to collect the reported information from the product processing equipment and store it in a fifth database; The data integration module is used to integrate data from the first to fifth databases, the pre-built static information database of drill bits, and the dynamic processing information database of drill bits to construct a traceability information database. The anomaly tracing module is used to trace the product back to the associated drill bit, drill shaft, and product based on data from the traceability information database when an anomaly occurs.

[0015] The beneficial effects of this invention are as follows: This invention provides a traceability method and system for mechanical drilling bits and drill spindles. First, a code associated with the drill bit's identity information is generated, improving the uniqueness and traceability of the drill bit's identity information. Next, the drill bit-drill bit location-drill spindle, aluminum sheet-product, and drill spindle-aluminum sheet are bound separately, optimizing the accuracy of the association between the drill bit, drill spindle, and product, achieving a direct correspondence between the drill spindle position and the product processing process. Finally, data from all databases are integrated to construct a traceability information database. When product anomalies occur, the traceability information database allows for tracing back to the associated product, drill spindle, and drill bit, optimizing the efficiency of anomaly location and quickly pinpointing the drill bit or drill spindle link causing the product anomaly, meeting the reliability requirements of the packaging substrate manufacturing industry for process control.

[0016] Furthermore, this invention sets digital identifiers at the locations of the aluminum sheet, product, drill spindle, and drill bit to read the identity code, thereby optimizing the efficiency and accuracy of identity information recognition.

[0017] Furthermore, this invention constructs a static information database and a dynamic processing information database for drill bits, and binds them to the drill bits through coding. The static information database serves as benchmark data for comparison with the actual processing data reported by the equipment, providing direct specification-level basis for subsequent anomaly investigation. The dynamic processing information of the drill bits provides specific process-level evidence for tracing the source of anomalies, specifically addressing whether there are issues with processing parameter settings.

[0018] Of course, any product implementing this invention does not necessarily need to achieve all of the advantages described above at the same time. Attached Figure Description

[0019] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] Figure 1 This is a flowchart of the traceability method for mechanical drilling drill bits and drill shafts according to an embodiment of the present invention; Figure 2 This is a flowchart of another mechanical drilling drill bit and drill shaft traceability method according to an embodiment of the present invention; Figure 3 This is a schematic diagram of the drill bit storage box and digital label according to an embodiment of the present invention; Figure 4 This is a schematic diagram of the aluminum sheet, product, and digital identification according to an embodiment of the present invention; Figure 5 It is a diagram showing the correspondence between drill bit position codes, drill bit serial numbers, and drill bit boxes; Figure 6 This is a structural diagram of the traceability system for mechanical drilling drill bits and drill shafts according to an embodiment of the present invention.

[0021] Reference numerals: 11. Hole / slot; 12. Needle box; 13. Needle box number; 21. Aluminum sheet; 22. Aluminum sheet number; 23. Product; 24. Product number; 31. Drill spindle; 32. Drill spindle number; 33. Drill bit position code; 34. Drill bit position number; 81. Working terminal; 82. Internet; 83. Database; 84. Calculation module; 85. Display terminal. Detailed Implementation

[0022] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention.

[0023] It should be noted that the illustrations provided in the embodiments of the present invention are only schematic representations of the basic concept of the present invention. Therefore, the drawings only show the components related to the present invention and are not drawn according to the number, shape and size of the components in actual implementation. In actual implementation, the form, quantity and proportion of each component can be arbitrarily changed, and the layout of the components may also be more complex.

[0024] In this invention, it should also be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application. Furthermore, the terms "first" and "second" are used only for descriptive and distinguishing purposes and should not be construed as indicating or implying relative importance.

[0025] Example 1 This invention provides a method for tracing mechanical drilling bits and drill spindles, the process of which is as follows: Figure 1 As shown, the steps include: T1. Generate a unique code associated with the identification information of the drill bit after it is put into storage, and store it in the first database. This step generates a unique code associated with the identification information of the drill bit after it is put into storage and stores it in the first database, establishing an initial traceability certificate for the drill bit and realizing the traceability foundation of the drill bit storage process.

[0026] Specifically, the identification information includes the drill bit's manufacturer, warehousing date, expiration date, and specifications. This information is the core data associated with the drill bit's code, ensuring that the code comprehensively reflects the drill bit's basic attributes and providing crucial foundational information for subsequent traceability.

[0027] T2. Before processing product 23, bind aluminum sheet 21 to product 23 and store multiple sets of association relationships between aluminum sheet 21 and product 23 in the second database; bind the position of drill bit and drill shaft 31 used to fix drill bit, drill bit and drill bit position respectively, and store multiple sets of association relationships between drill bit and drill position and drill shaft 31 in the third database; when processing product 23, bind drill shaft 31 to aluminum sheet 21 and store multiple sets of association relationships between drill shaft 31 and aluminum sheet 21 in the fourth database; after product 23 is processed, collect the reported information from the product 23 processing equipment and store it in the fifth database.

[0028] Before processing, this step completes the binding of aluminum sheet 21 and product 23, stores the association relationship in the second database, and establishes the corresponding link between product 23 and aluminum sheet 21; at the same time, it completes the dual binding of drill bit position and drill spindle 31, and drill bit position, stores the association relationship of the three in the third database, and clarifies the unique correspondence between drill bit, installation position, and fixing device; during processing, drill spindle 31 is bound to aluminum sheet 21, and the association relationship is stored in the fourth database, establishing the connection between the core component of processing equipment and the carrier of product 23; after processing, the equipment-reported information is collected and stored in the fifth database to record the actual data during the processing.

[0029] Specifically, each aluminum sheet 21, product 23, drill spindle 31, and drill bit is marked with a digital identifier. This digital identifier is used for scanning and reading the identification code corresponding to the specific location of the aluminum sheet 21, product 23, drill spindle 31, and drill bit. The identification code is used to determine the location of the specific aluminum sheet 21, product 23, drill spindle 31, and drill bit. The digital identifier can be a QR code or a barcode.

[0030] This step defines the carrier and form of identification. Digital identifiers are placed at the locations of aluminum sheet 21, product 23, drill spindle 31, and drill bit to achieve the identifiable transformation of key objects in the traceability chain. The digital identifiers are used for scanning and reading the corresponding object's identity code, providing a technical entry point for information collection and association binding of each object. Furthermore, the digital identifiers are limited to QR codes or barcodes, clarifying the specific implementation form of the identifiers and ensuring that they possess the characteristics of being easy to scan and easy to store information.

[0031] The method of binding drill bits and their locations includes binding the drill bit's code with the digital identifier of the drill bit's location, which is scanned and read to establish a unique correspondence between the drill bit and its installation location, providing a data association basis for subsequent location of the drill bit's specific installation location.

[0032] The method of binding the drill bit location and the drill shaft 31 includes binding the identification code of the digital identifier set at the drill bit location that is scanned and read and the identification code of the digital identifier set on the drill shaft 31 that is scanned and read, so as to realize the association between the drill bit installation position and the fixing device and clarify the correspondence between the two.

[0033] The method of binding aluminum sheet 21 to product 23 includes binding the digital identification code set on aluminum sheet 21 and the digital identification code set on product 23 to establish a unique correspondence between aluminum sheet 21 and product 23, providing data support for subsequent association of product 23 information through aluminum sheet 21.

[0034] The method of binding the drill spindle 31 to the aluminum sheet 21 includes binding the digital identifier set on the drill spindle 31 and the digital identifier set on the aluminum sheet 21 to establish a corresponding link between the drill spindle 31 and the aluminum sheet 21, thereby realizing the indirect association between the drill spindle 31 and the product 23.

[0035] The reported information from the equipment processing product 23 includes product 23 information and hole processing information. The product 23 information includes the product's part number, batch number, and identification code. The hole processing information includes the borehole diameter, hole type, and number of holes. This step defines the specific scope of the equipment's reported information, comprehensively covering key information about the processing object, processing results, and tools used. It further clarifies that the hole processing information includes the borehole diameter, hole type, and number of holes, providing detailed data for accurately tracing processing parameters and results.

[0036] T3. Integrate the data from the first to fifth databases, as well as the pre-built static and dynamic machining information databases for drill bits, to construct a traceability information database. This step is used to achieve centralized management and association of data.

[0037] Specifically, the drill bit static information database includes the specifications of each drill bit. These specifications include the drill bit's diameter, type, number of grinding passes, and brand. The drill bit's specifications are associated with a specific drill bit through its code, used to match the drilling bit used by the equipment with the hole machining information reported by the equipment.

[0038] The drill bit dynamic machining information database includes dynamic machining information for each drill bit. This dynamic machining information includes the drill bit's diameter, lifespan, compensation value, revolutions per minute (RPM), feed rate, and return rate. The dynamic machining information is associated with specific drill bits through their codes, providing data support for analyzing the impact of drill bit lifespan on product machining and for tracing machining parameters. Lifespan is used to trace whether the actual lifespan of the drill bit matches the standard lifespan, thereby determining whether anomalies in a batch of products are due to excessive wear of the drill bits.

[0039] T4. When product 23 is abnormal, based on the data in the traceability information database, trace back to the associated drill spindle 31, drill bit and other products 23.

[0040] Specifically, when product 23 malfunctions, the drill bit code to be processed is determined based on the product 23 information and hole processing information reported by the device in the fifth database, as well as the drill bit specification information in the drill bit static information database.

[0041] Based on the drill bit code, the location of the drill bit and the drill shaft 31 used to fix the drill bit are determined by querying a third database.

[0042] Based on the identification code of the drill spindle 31 used to fix the drill bit, other products processed via the drill spindle can be identified by querying the sixth and second databases.

[0043] Example 2 Based on Example 1, this example provides another method for tracing mechanical drilling bits and drill spindles, the process of which is as follows: Figure 2 As shown, it includes the following steps: S1: Obtain drill bit procurement information data, generate a unique identification code for the drill bit after it is put into the first database D0, and generate a drill bit warehousing traceability code.

[0044] The information read after scanning the drill bit's identification code includes the drill bit's manufacturer, warehousing date, expiration date, and specifications.

[0045] like Figure 3 As shown, before being put into storage, the drill bits are stored in the slots 11 of the needle box 12. The needle box 12 has multiple slots 11 distributed inside, and one needle box 12 stores a set of drill bits. The needle box 12 is equipped with a needle box number label 13, which is a QR code. The storage of the drill bits is completed by scanning this QR code.

[0046] When binding aluminum sheet 21 and product 23, it is necessary to define aluminum sheet 21ID and product 23ID.

[0047] S2: Before processing product 23, aluminum sheet 21 and product 23 need to be bound together to form an association between aluminum sheet 21ID and product 23PNLID (product digital identifier 24, i.e. product panel unique identification code), thereby generating the second database D1.

[0048] like Figure 4 As shown, aluminum sheet 21 is provided with aluminum sheet number identification 22, which is used to associate and bind with product 23.

[0049] S3: Define the drill bit position, associate it with information, and form a unique traceability identification code for drill bit-drill shaft 31.

[0050] Before production, the drill bit needs to be bound to the drill bit position to generate a third database D2. At this time, the traceability code identification database has a unique association between the drill bit information, drill bit position information, and drill shaft 31 information.

[0051] S31: In this step, as Figure 5 As shown, the drill bit position is defined for device identification.

[0052] S32: Drill spindle digital identifier 32, used to bind product 23 to drill spindle 31. The binding information is uploaded through a barcode scanning device, forming the drill spindle 31-product 23 database, i.e., the fourth database D3.

[0053] S33: Define drill bit position code 33.

[0054] Define drill bit positions ZZ1-1# containing drill bit numbers 1 to 50, drill bit ZZ1-2# containing drill bit numbers 51 to 100, and so on.

[0055] Mechanical drilling typically uses 6 axes, with the 6th axis numbered ZZ1-6#; where ZZ1 represents the 1st machining axis, and if it is the 2nd machining axis, it is ZZ2.

[0056] S34: Set a drill bit position number identifier 34 at the drill bit position to mark the drill bit position code 33.

[0057] S4: Create a static drill bit information database D3. This database is used to associate the specifications of the drill bits used with the information reported by the equipment. By comparing and correlating the data reported by the equipment, information that can be identified by the operators is formed. The specifications of the drill bits are shown in Table 1:

[0058] Table 1 Drill Bit Specification Information S5: Create a drill bit life control table, and construct the drill bit dynamic processing information database D4 from the data contained in the control table. This control table is used by the equipment to identify the drill bit life, provide dynamic processing information for the drill bit, and automatically jump to the next drill bit when the drill bit life is reached. The dynamic processing information of the drill bit is shown in Table 2:

[0059] Table 2 Drill Bit Dynamic Machining Information Table The role of dynamic machining information of drill bits is to control the life of drill bits and to determine which specification of drill bit to use for different hole diameters.

[0060] S6: When processing product 23, bind the aluminum sheet ID and the equipment drill spindle ID 31 to generate the data information database D5.

[0061] S7: After completing the processing of product 23, the equipment reports the product 23 information and hole processing information, and generates the data information database D6.

[0062] S8: Integrate databases D0~D6 and output a traceability information database for batches / pieces of drill bits or drill shafts 31.

[0063] This embodiment also provides a traceability system for mechanical drilling bits and drill spindles, such as... Figure 6 As shown, it includes: The work terminal 81 is used to bind the aluminum sheet 21 to the product 23, bind the drill bit, drill bit position, and spindle, bind the aluminum sheet 21 to the drill spindle 31, and control the device to report information. Internet 82 is used to upload data from the work terminal 81 to the server 83; Data information repository 83 is used to store data according to a defined database format; The calculation module 84 is used to integrate the databases of D0 to D6 through the calculation module 85 to form a traceability information database; Display terminal 85 is used to display data from the traceability information database, making it convenient for operators to query.

[0064] This invention constructs a complete closed-loop control system for drill bit and drill shaft traceability by defining the association methods for drill bit warehousing management, drill bit location information, drill shaft 31 information, equipment number and product 23 information.

[0065] Example 3 This embodiment provides a specific application of the traceability method for mechanical drilling bits and drill shafts described in Embodiment 2.

[0066] Specific application 1: Abnormal drilling quality in a single product. Traceability path: The system queries database D1 based on the product ID to obtain the aluminum sheet ID used when processing the board. It then queries database D5 based on the aluminum sheet ID to confirm the drill spindle performing the processing. Next, it queries database D6 to determine the drill bit used for processing based on the hole processing information reported by the equipment. Finally, it queries database D0 and the drill bit dynamic processing information database D4 to obtain the drill bit lifespan consumption during processing.

[0067] Results of the investigation: If the actual life of the drill bit does not match the standard life, the cause of the defect can be highly attributed to excessive wear of the drill bit.

[0068] Specific application 2: Common anomalies among multiple products in the same batch. Traceability path: Based on all product IDs showing anomalies, query database D1 to identify the set of drill spindles that processed these products. If the drill spindles themselves are found to be normal, query database D6 to identify the drill bits used to process the abnormal products based on the hole processing information reported by the equipment, and then query the identification information of that batch of drill bits through database D0.

[0069] Traceability Results: A risk warning was issued, recommending that the batch of drill bits be immediately discontinued, and other affected products be traced.

[0070] In summary, this invention provides a method and system for tracing drill bits and drill shafts in mechanical drilling, which can improve the reliability of process control in mechanical drilling and solve the problem of difficulty in tracing after product abnormalities.

[0071] It should be noted that, depending on the implementation needs, the various steps / components described in this application can be broken down into more steps / components, or two or more steps / components or parts of the operation of steps / components can be combined into new steps / components to achieve the purpose of this invention.

[0072] The sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.

[0073] It should be understood that those skilled in the art can make improvements or modifications based on the above description, and all such improvements and modifications should fall within the protection scope of the appended claims.

Claims

1. A method for tracing mechanical drilling bits and drill spindles, characterized in that, include: After the drill bit is put into storage, an encoding associated with its identity information is generated and stored in the first database; Before processing the product, aluminum sheets are bound to the product, and the association relationships between multiple sets of aluminum sheets and products are stored in the second database; the location of the drill bit and the drill spindle used to fix the drill bit, the drill bit and the location of the drill bit are bound respectively, and the association relationships between multiple sets of drill bits, drill bit positions and drill spindles are stored in the third database; during product processing, the drill spindle is bound to the aluminum sheet, and the association relationships between multiple sets of drill spindles and aluminum sheets are stored in the fourth database; after the product processing is completed, the reported information from the product processing equipment is collected and stored in the fifth database; A traceability information database is constructed by integrating data from the first to fifth databases, a pre-built static information database of drill bits, and a dynamic processing information database of drill bits. When a product malfunctions, the related drill bit, drill shaft, and other products can be traced based on data from the traceability database.

2. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 1, characterized in that, The identification information includes the drill bit's manufacturer, warehousing date, expiration date, and specifications.

3. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 1, characterized in that, The aluminum sheet, product, drill spindle, and drill bit are all marked with digital identifiers for scanning and reading the corresponding identification codes; the digital identifiers are QR codes or barcodes.

4. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 3, characterized in that, Methods for binding drill bits and their locations include binding the drill bit's code with the identification code of the drill bit's location, which is scanned and read.

5. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 3, characterized in that, The method of binding the drill bit location and the drill shaft includes binding the identification code of the digital identifier set at the drill bit location that is scanned and read and the identification code of the digital identifier set on the drill shaft that is scanned and read.

6. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 3, characterized in that, Methods for binding aluminum sheets to products include binding the digital identification code set on the aluminum sheet to the digital identification code set on the product to the digital identification code set on the product.

7. The method for tracing the drill bit and drill spindle in mechanical drilling according to claim 3, characterized in that, The method of binding the drill spindle to the aluminum sheet includes binding the digital identification code set on the drill spindle and the digital identification code set on the aluminum sheet.

8. The method for tracing drill bits and drill spindles in mechanical drilling according to claim 1, characterized in that, The information reported by the equipment for processing the products includes product information and hole processing information; the product information includes the product part number, batch number and identification code, and the hole processing information includes the hole diameter, hole type and number of holes.

9. The method for tracing mechanical drilling bits and drill spindles according to claim 1, characterized in that, The static information database of drill bits includes the specification information of each drill bit; the specification information includes the drill bit diameter, type, number of grinding cycles, and brand; the dynamic machining information database of drill bits includes the dynamic machining information of each drill bit; the dynamic machining information includes the drill bit diameter, lifespan, compensation value, revolutions, feed rate, and return rate.

10. A traceability system for mechanical drilling bits and drill spindles, characterized in that, It includes a drill bit code generation module, an association binding module, a data integration module, and an anomaly tracing module; The drill bit encoding generation module is used to generate an encoding associated with the identity information of the drill bit after it is put into storage, and store it in the first database; The association and binding module is used to bind aluminum sheets to products before processing, and store multiple sets of aluminum sheet-product association relationships in a second database; to bind the drill bit location and the drill spindle used to fix the drill bit, as well as the drill bit and the drill bit location, respectively, and store multiple sets of drill bit-drill bit-drill spindle association relationships in a third database; during product processing, to bind the drill spindle to the aluminum sheets, and store multiple sets of drill spindle-aluminum sheet association relationships in a fourth database; after the product processing is completed, to collect the reported information from the product processing equipment and store it in a fifth database; The data integration module is used to integrate data from the first to fifth databases, the pre-built static information database of drill bits, and the dynamic processing information database of drill bits to construct a traceability information database. The anomaly tracing module is used to trace the product back to the associated drill bit, drill shaft, and product based on data from the traceability information database when an anomaly occurs.

Images