A production management database system based on integrated circuit boards

Abstract

The present invention relates to the technical field of integrated circuit board production data management, and discloses a production management database system based on integrated circuit boards. The BOM library module, model library module, finished product library module, and coding library module of the system are run on the computer. The code scanning and uploading middle end includes a WIfi module, an embedded communication terminal, and a data registration terminal. The execution record front end includes a material library, a front-end quality inspection project, a model library, a rear-end soldering project, and defective / good circuit boards. The present invention establishes a coding database by utilizing the coding library module in a computer terminal and manufactures coding information. It can sequentially code and mark the raw materials in the material library, code and mark the production equipment in the model library, and code and mark the finished integrated circuit board. It can clearly and concisely edit and record the production process of the integrated circuit board from raw materials to finished products, so that the production data of the integrated circuit board can be traced and managed.

Description

Technical Field

[0001] The present invention relates to the technical field of integrated circuit board production data management, in particular to a production management database system based on integrated circuit boards. Background Art

[0002] Integrated circuit boards are made using semiconductor manufacturing technology, with many transistors, resistors, capacitors and other components manufactured on a smaller single-crystal silicon wafer, and the components are combined into a complete electronic circuit using multi-layer wiring or tunnel wiring methods. They are widely used in the fields of communications, information processing, remote control, etc.

[0003] The production process of integrated circuit boards can be roughly divided into four steps: design, manufacturing, installation and testing. First, in the design stage, it is necessary to use software tools to design the wiring and layout of the integrated circuit board according to the requirements of circuit drawings and external dimensions; then, in the manufacturing stage, the design files need to be converted into physical circuit boards for implementation. The specific steps include chemical etching, copper cladding, pad plating, drilling, etc.; then, in the installation stage, it is necessary to add necessary components, such as electrolytic capacitors, resistors, integrated circuit chips, sockets, etc.; finally, in the testing stage, the already manufactured circuit boards need to be subjected to various tests such as function, reliability, and environment.

[0004] However, the existing integrated circuit board production companies mostly manage the production data of integrated circuit boards within the scope of raw material and finished product management records, and the data records of the overall production process of integrated circuit boards are not comprehensive, resulting in only a single quantity inventory after the integrated circuit boards are produced and put into storage, and it is impossible to clearly perform reverse tracing work, resulting in unclear records of the overall production process of integrated circuit boards, which is not conducive to the tracing and correction work during the production of integrated circuit boards. Therefore, those skilled in the art provide a production management database system based on integrated circuit boards to solve the problems raised in the above background technology. Summary of the invention

[0005] The object of the present invention is to provide a production management database system based on integrated circuit boards to solve the problems raised in the above background technology.

[0006] To achieve the above purpose, the present invention provides the following technical solution: a production management database system based on integrated circuit boards, including a computer terminal, a code scanning and uploading middle end, and an execution record front end, wherein:

[0007] The computer terminal includes at least one computer, on which the BOM library module, machine model library module, finished product library module, and coding library module of the system are run, wherein the BOM library module, machine model library module, and finished product library module are all connected to the coding library module, which is used to mark the code and record the consumables required for the integrated circuit board production process and the production process information;

[0008] The code scanning and uploading middle end includes a WIFi module, an embedded communication terminal and a data registration terminal, and the data registration terminal is embodied in the form of a code scanning gun, which is used to scan and upload the coding information used in the integrated circuit board production process and the generated coding information;

[0009] The execution record front end includes a material library, a pre-quality inspection project, a model library, a post-soldering project, and defective / good circuit boards, which are used to record the production process of integrated circuit boards from raw materials to finished products.

[0010] As a further solution of the present invention: the coding library module establishes a coding database according to the coding operation instruction book and produces coding information;

[0011] Part of the coding information is used to encode and mark the raw materials in the material library. Before using the raw materials, scan the code to generate specific usage information, and upload the coding information remotely to the BOM library module to generate usage records;

[0012] Part of the coding information is used to code the production equipment in the model library. Before producing the corresponding model of integrated circuit board, scan the corresponding production equipment and transmit the coding information remotely to the model library module to ensure the matching of production models and equipment usage records;

[0013] A part of the coding information is used for coding marking of finished integrated circuit boards, and the production information of the integrated circuit boards is edited online to make the production data traceable.

[0014] As a further solution of the present invention: the data registration terminal at the middle end of the code scanning and uploading process has multiple groups of code scanning guns, which are distributed in but not limited to the raw material warehouse stations, production equipment stations, and finished product packaging and warehousing stations, and the code scanning guns are connected to the embedded communication terminal via the RS232 bus, and the embedded communication terminal is wirelessly connected to the WIfi module in the form of WIfi AP, and the WIfi module uploads the scanned code information to the computer terminal via the RS232 bus.

[0015] As a further solution of the present invention: the material library of the execution record front end includes but is not limited to circuit board materials, patch materials, solder paste materials, fixture materials, work clothes materials, packaging materials and related soldering tool materials.

[0016] As a further solution of the present invention: the pre-quality inspection project that executes the record front end is used for the pre-production inspection of integrated circuit boards, including solder paste thickness detection, tray IC automatic detection, online automatic image detection one, online automatic image detection two, and online soldering automatic detection.

[0017] As a further solution of the present invention: the model library of the execution record front end is used for the patch and printing of integrated circuit boards, including an image inspection machine, a reflow oven, a high-speed patch machine 1, a high-speed patch machine 2, and a printer.

[0018] As a further solution of the present invention: the post-soldering project that executes and records the front end is used for post-inspection work of integrated circuit boards, including pre-processing, plug-in, DIP soldering, correction, post-attachment soldering, AOI inspection, ICT inspection, FCT inspection, and substrate segmentation.

[0019] As a further solution of the present invention: the execution record of the defective / good circuit boards at the front end is used to distinguish between good products and waste products, and the two forms of circuit board coding information are uploaded to the finished product warehouse module. After the good circuit boards are coded and put into the warehouse, subsequent production and sales are carried out. After the waste circuit boards are coded and put into the warehouse, it is convenient to reverse trace and check the causes of the defects.

[0020] Compared with the prior art, the present invention has the following beneficial effects:

[0021] The present invention establishes a coding database and manufactures coding information by utilizing a coding library module in a computer terminal. It can sequentially code and mark raw materials in a material library, code and mark production equipment in a model library, and code and mark finished integrated circuit boards. Then, a code scanning and uploading middle end is utilized to scan and mark the encoded execution record front end for uploading. It can clearly and concisely edit and record the production process of integrated circuit boards from raw materials to finished products, and generate a complete production data management library, so that production data can be retrieved through any information such as production equipment model name, production time, serial number, and operator ID, so that the production data of integrated circuit boards can be traced and managed. On the one hand, the materialization and clarity of the production information of integrated circuit boards are further improved, and on the other hand, it is convenient to perform reverse tracing and correction work based on production scraps. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 It is a structural diagram of a production management database system based on integrated circuit boards;

[0023] Figure 2 It is a schematic diagram of the structure of a QR code scanning and uploading middle end in a production management database system based on an integrated circuit board;

[0024] Figure 3It is a flow chart of the pre-quality inspection project in a production management database system based on integrated circuit boards;

[0025] Figure 4 It is a schematic diagram of the production process of a model library in a production management database system based on integrated circuit boards;

[0026] Figure 5 A schematic diagram of the post-soldering process in a production management database system based on integrated circuit boards DETAILED DESCRIPTION

[0027] See also Figures 1 to 5 In an embodiment of the present invention, a production management database system based on an integrated circuit board includes a computer terminal, a code scanning and uploading middle end, and an execution record front end, wherein: the computer terminal includes at least one computer, and the BOM library module, the model library module, the finished product library module, and the coding library module of the system are run on the computer, wherein the BOM library module, the model library module, and the finished product library module are all connected to the coding library module, which is used to mark the code and record the consumables required for the integrated circuit board production process and the production process information; the code scanning and uploading middle end includes a WIfi module, an embedded communication terminal, and a data registration terminal, and the data registration terminal is embodied in the form of a code scanning gun, which is used to scan and upload the coding information used in the integrated circuit board production process and the generated coding information; the execution record front end includes a material library, a front-end quality inspection project, a model library, a post-soldering project, and a defective / good circuit board, which is used to record the production process of the integrated circuit board from raw materials to finished products.

[0028] The coding library module establishes a coding database according to the coding operation manual and generates coding information; part of the coding information is used to encode and mark the raw materials in the material library. Before using the raw materials, scan the code to generate specific usage information, and upload the coding information remotely to the BOM library module to generate usage records; part of the coding information is used for coding and marking the production equipment in the model library. Before producing the corresponding model of integrated circuit boards, scan the corresponding production equipment, and remotely transmit the coding information to the model library module to ensure the matching of production models and equipment usage records; part of the coding information is used for coding and marking finished integrated circuit boards, and the production information of the integrated circuit boards is edited online to make the production data traceable.

[0029] The data registration terminal at the middle end of the code scanning upload has multiple groups of code scanning guns, which are distributed but not limited to the raw material warehouse station, production equipment station, and finished product packaging warehousing station. The code scanning guns are connected to the embedded communication terminal through the RS232 bus, and the embedded communication terminal is wirelessly connected to the WIfi module in the form of WIfi AP. The WIfi module uploads the scanned code information to the computer terminal through the RS232 bus.

[0030] The material library of the execution record front end includes but is not limited to circuit board materials, patch materials, solder paste materials, jig materials, work clothes materials, packaging materials and related soldering tool materials.

[0031] Execute and record the front-end pre-quality inspection project, which is used for the pre-production inspection of integrated circuit boards, including solder paste thickness detection, tray IC automatic detection, online automatic portrait detection 1, online automatic portrait detection 2, online soldering automatic detection, and the pre-production inspection process of integrated circuit boards, including: solder paste thickness detection can use a 3D solder paste thickness detector to check the solder paste printing thickness and area; tray IC automatic detection can use a tray IC automatic detector to check the tray IC missing parts, insufficient parts, and mixed materials (silk screen printing errors); online automatic portrait detection 1 can use the online automatic portrait inspection system to automatically detect and alarm the missing, reverse, and wrong parts of the CN furnace front plug-in socket; online automatic portrait detection 2 can use the online automatic portrait inspection system to automatically detect the missing parts, reversed devices, wrong parts, and damage of the furnace front plug-in; online soldering automatic detection can use the online solder automatic inspection system to check the insufficient solder, insufficient solder, and blocked eyes.

[0032] The model library of the execution record front end is used for the patch and printing of integrated circuit boards, including image inspection machine, reflow oven, high-speed patch machine 1, high-speed patch machine 2, printer, and integrated circuit board production equipment, among which: the image inspection machine can adopt Omron model image inspection machine, high-speed patch machine 1 can adopt CM602 model high-speed patch machine, high-speed patch machine 2 can adopt NPM model high-speed patch machine, and the printer can adopt MPM model printer.

[0033] Execute and record the front-end post-soldering project, which is used for the post-inspection work of integrated circuit boards, including pre-processing, plug-in, DIP welding, correction, post-attachment welding, AOI inspection, ICT inspection, FCT inspection, substrate segmentation, integrated circuit board patch and printing, among which: pre-processing includes size specification quality inspection; plug-in includes stability and polarity inspection of components; DIP welding includes soldering of plug-ins and management and control of welding time and temperature; correction includes cleaning of soldering foreign matter; post-attachment includes repair and cleaning of soldering foreign matter; AOI inspection, ICT inspection and FCT inspection include welding defects, electrical characteristics of electronic components and functional inspection; substrate segmentation includes cutting of integrated circuit boards.

[0034] The defective / good circuit boards at the front end are recorded to distinguish good products from waste products, and the two forms of circuit board coding information are uploaded to the finished product library module. After the good circuit boards are coded and put into storage, subsequent production and sales are carried out. After the waste circuit boards are coded and put into storage, it is convenient to reverse trace and check the causes of defects.

[0035] What is described above is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A production management database system based on integrated circuit boards, characterized in that: It includes a computer terminal, a code scanning and uploading middle end, and an execution and recording front end, wherein: the computer terminal includes at least one computer, on which the BOM library module, the model library module, the finished product library module, and the coding library module of the system are run, wherein the BOM library module, the model library module, and the finished product library module are all connected to the coding library module, which are used to mark the code and record the consumables required for the integrated circuit board production process and the production process information; the code scanning and uploading middle end includes a WIfi module, an embedded communication terminal, and a data registration terminal, and the data registration terminal is embodied in the form of a code scanning gun, which is used to scan and upload the coding information used in the integrated circuit board production process and the generated coding information; the execution and recording front end includes a material library, a pre-quality inspection project, a model library, a post-soldering project, and a defective / good circuit board, which is used to record the production process of the integrated circuit board from raw materials to finished products; The coding library module establishes a coding database according to the coding operation manual and generates coding information; a part of the coding information is used to code and mark the raw materials in the material library. Before using the raw materials, scan the code to generate specific usage information, and remotely upload the coding information to the BOM library module to generate usage records; a part of the coding information is used to code and mark the production equipment in the model library. Before producing the corresponding model of the integrated circuit board, scan the corresponding production equipment, and remotely transmit the coding information to the model library module to ensure the matching of the production model and the equipment usage record; a part of the coding information is used for the coding marking of the finished integrated circuit board, and the production information of the integrated circuit board is edited online to make the production data traceable and manageable; The data registration terminal at the middle end of the code scanning upload has multiple groups of code scanning guns, which are distributed but not limited to the raw material warehouse station, production equipment station, and finished product packaging storage station, and the code scanning gun is connected to the embedded communication terminal in the form of RS232 bus, and the embedded communication terminal is wirelessly connected to the WIfi module in the form of WIfi AP, and the WIfi module uploads the scanned code information to the computer terminal in the form of RS232 bus; The material library of the execution record front end includes, but is not limited to, circuit board materials, patch materials, solder paste materials, fixture materials, work clothes materials, packaging materials and related soldering tool materials; The execution record front-end pre-quality inspection project is used for the pre-production inspection of integrated circuit boards, including solder paste thickness detection, tray IC automatic detection, online automatic image detection 1, online automatic image detection 2, and online soldering automatic detection; The model library of the execution record front end is used for patch and printing of integrated circuit boards, including an image inspection machine, a reflow oven, a high-speed patch machine 1, a high-speed patch machine 2, and a printing machine; The execution records the post-soldering process at the front end, which is used for the post-inspection of integrated circuit boards, including pre-processing, plug-in, DIP soldering, correction, post-attachment soldering, AOI inspection, ICT inspection, FCT inspection, and substrate segmentation; The execution records the defective / good circuit boards at the front end, which are used to distinguish good products from waste products, and upload the two forms of circuit board coding information to the finished product library module. After the good circuit boards are coded and put into storage, subsequent production and sales will be carried out. After the waste circuit boards are coded and put into storage, it is convenient to reverse trace and check the causes of defects.

Images