A construction method of a material data management platform and the material data management platform

Abstract

The application relates to the technical field of material management, in particular to a construction method of a material data management platform and the material data management platform, which comprises the following steps: in a database, a plurality of data tables related to materials are constructed; and an operation interface for material management according to the plurality of data tables is constructed. In the application, the data tables can be extended, the attribute information of the materials can be flexibly added, and users can utilize the operation interface to manage the materials, so that the problems of display redundancy, poor maintenance flexibility, low retrieval performance and data fragmentation are solved, and the application can be realized based on a relational database and does not conflict with the design concept of the relational database.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of material management, and in particular to a construction method of a material data management platform and the material data management platform. BACKGROUND

[0002] It is crucial for enterprises to improve the information level by constructing enterprise-level material data resource platforms and strengthening the management of data resources. According to the design and production characteristics of enterprises, the material master data management system is designed by using the standardized database design method, which is the mainstream of the current industry technology development. The commonly used material master data management system is a WEB-side business data management module. The WEB-side business data management module is designed based on a relational database, using a high-level programming language as an operation means, and using a PC-side browser as a display method. The WEB-side business data management module supports general maintenance operations of business data. Based on the design of the WEB-side business data management module, combined with the requirements of PMC informatization construction, three commonly used information material management modes with classification management modes are generated, including a commonly used tree table mode, a multi-table mode and a serialization mode. However, the following defects exist:

[0003] 1) The commonly used tree table mode is relatively fuzzy in the classification of materials, and displays too many redundant attributes in the material data detail display, which is not conducive to information viewing and cannot achieve the effect of flexibly increasing material attributes.

[0004] 2) The multi-table mode has poor flexibility in data maintenance, and needs to maintain multiple database tables at the same time. The data retrieval logic is also relatively complex and has low performance, and cannot achieve the effect of flexibly increasing material attributes.

[0005] 3) Although the serialization mode can flexibly increase attributes, due to a large number of fragmented data, the serialization mode does not have advantages in various aspects of data management, and is contrary to the design concept of the relational database. SUMMARY

[0006] The present application relates to the technical field of material management, and in particular to a construction method of a material data management platform and the material data management platform.

[0007] 1) In a first aspect, the present application provides a construction method of a material data management platform, and the specific technical solutions are as follows:

[0008] In the database, a plurality of data tables associated with the material are constructed.

[0009] An operation interface for material management according to the plurality of data tables is constructed.

[0010] The technical effects of the construction method of the material data management platform are as follows:

[0011] The data table can be extended to flexibly increase attribute information of the material, and the user can use the operation interface to manage the material, so as to solve the problems of display redundancy, poor maintenance flexibility, low search performance and data fragmentation, and can be implemented based on a relational database, and does not conflict with the design concept of the relational database.

[0012] On the basis of the above scheme, the construction method of the material data management platform can be further improved as follows.

[0013] Further, the plurality of data tables associated with the material include a material classification table and a material information table;

[0014] The material classification table is used to store classification information of all types of materials;

[0015] The material information table is used to store all information of the material.

[0016] Further, the plurality of data tables associated with the material further include a general attribute table, and the general attribute table is used to store all attributes of all types of materials.

[0017] Further, the operation interface receives a user operation, selects a target attribute from the general attribute table, and adds the target attribute to the material information table, and adds attribute information of the target attribute in the material information table.

[0018] Further, the plurality of data tables associated with the material further include a classification attribute table, and the method further includes:

[0019] According to the user requirement, the general attribute table and the material classification table are associated to obtain attributes of each target type of material, and the attributes of each target type of material are stored in the classification attribute table.

[0020] Further, the plurality of data tables associated with the material further include a scene attribute table, and the scene attribute table is used to store a binding relationship between a form and an attribute of the material in the classification attribute table, and the method further includes:

[0021] When the operation interface receives a user operation to fill in a target form, attribute information of the material in the target form is determined according to the binding relationship stored in the scene attribute table and the association relationship between the material classification table and the material information table, so that the user fills in the target form.

[0022] Further, the plurality of data tables associated with the material further include a splicing rule table, and the splicing rule table stores attribute splicing rules for splicing at least two attribute information.

[0023] Further, the database is a relational database.

[0024] 2) The application further provides a material data management platform, and the specific technical scheme is as follows:

[0025] The application further provides a material data management platform constructed by using any one of the construction methods of the material data management platform.

[0026] 3) The application further provides a computer device, which comprises a processor and a memory coupled with the processor, and the memory stores at least one computer program, the at least one computer program is loaded and executed by the processor, so that the computer device implements the construction method of any one of the material data management platforms.

[0027] 4) In the fourth aspect, the application further provides a computer readable storage medium, which stores at least one computer program, the at least one computer program is loaded and executed by the processor, so that the computer implements the construction method of any one of the material data management platforms.

[0028] It should be noted that the technical solutions of the second aspect to the fourth aspect of the application and the corresponding possible implementation manners have the beneficial effects as described above for the first aspect and the corresponding possible implementation manners, and will not be described here. BRIEF DESCRIPTION OF DRAWINGS

[0029] Other features, objects and advantages of the application will become more apparent from the following detailed description of non-limiting embodiments with reference to the accompanying drawings:

[0030] Figure 1 FIG. 1 is a flowchart of a construction method of a material data management platform according to an embodiment of the application;

[0031] Figure 2 FIG. 2 is a schematic diagram of a material data management mode;

[0032] Figure 3 FIG. 3 is a structural schematic diagram of a computer device according to an embodiment of the application. DETAILED DESCRIPTION

[0033] As shown in FIGS. 1, 2 and 3, the construction method of the material data management platform according to an embodiment of the application comprises the following steps: Figure 1 and Figure 2 The construction method of the material data management platform according to an embodiment of the application comprises the following steps:

[0034] S1, constructing a plurality of data tables associated with the material in the database;

[0035] The database is the basis of functional design, and a relational database such as Dream Database (V8) or other relational databases can be used according to actual conditions.

[0036] S2, the operation interface for material management according to multiple data tables is constructed, and the specific form of the operation interface can be set according to actual conditions.

[0037] Optionally, in the above technical solution, the multiple data tables associated with the material include a material classification table and a material information table.

[0038] The material classification table is used for storing classification information of all material categories, and the classification information of the material includes classification name, classification code, classification order and classification description and the like.

[0039] The material information table is used for storing all information of the material, and the all information of the material includes some basic and general attributes, i.e., basic attributes, and the basic attributes include material name, material code, model specification, supplier, code description and selection grade and the like.

[0040] Furthermore, the material information table is also provided with an extension field domain, the extension field domain is composed of ten large field types, and the extension field domain can meet the use requirement of material attribute extension to the greatest extent, and the user can customize and extend the attributes of the material by using the extension field domain, the material attributes customized and extended in the form of structured objects are stored into the extension field domain, and the all information of the material also includes the material attributes customized and extended by the user.

[0041] Optionally, in the above technical solution, the multiple data tables associated with the material also include a general attribute table, and the general attribute table is used for storing all attributes of all material categories.

[0042] The all attributes refer to all designed material attributes, and specifically include parameter attributes, design attributes, basic attributes, procurement attributes, application attributes and management attributes of the material and the like.

[0043] 1) The configurable information of the basic attributes includes material code, material name, material classification, specification model, detailed specification, quality grade, measurement unit and material state and the like.

[0044] 2) The configurable information of the design attributes includes product appearance diagram, product three-dimensional diagram, product ALTIUM principle diagram, CADENCE principle diagram and MENTOR principle diagram and the like.

[0045] 3) The configurable information of the procurement attributes includes procurement cycle, unit price, inventory, procurement quantity in the past three years and safety stock and the like.

[0046] 4) The configurable information of the application attributes includes use type, whether to stop production, substitute material, use quantity and use frequency and the like.

[0047] 5) The configurable information of the management attributes includes self-controllable condition, control mark, material state and forbidden and limited use list and the like.

[0048] It should be noted that the parameter attribute, design attribute, basic attribute, procurement attribute, application attribute and management attribute of the material can be used for the binding of the material classification.

[0049] Optionally, in the above technical solution, further comprising:

[0050] S10, the operation interface receives user operation, selects target attribute from the general attribute table, and adds the target attribute to the material information table, and adds attribute information of the target attribute in the material information table. Wherein, the user selects the target attribute from the general attribute table according to the actual situation.

[0051] Among them, the configurable information in the general attribute table includes attribute identification, attribute name, attribute type, attribute group, input expansion configuration, splicing rule binding, form configuration attribute and retrieval configuration attribute.

[0052] Optionally, in the above technical solution, the plurality of data tables associated with the material further comprises a classification attribute table, and the method further comprises:

[0053] S11, according to the user requirement, the general attribute table and the material classification table are associated, the attribute of each target class material is obtained, and the attribute of each target class material is stored in the classification attribute table.

[0054] Among them, the user requirement of a certain class of material is the target class material, and the S11 is explained as follows taking the target class material as capacitor as an example:

[0055] For example, the parameter attribute of the general attribute table includes the size of the material, and the size is a configurable information. The material classification table includes capacitor, which is a target class material. If the capacitor classification needs the attribute of "size", it is necessary to associate "size of material" from the general attribute table and store it in the classification attribute table. When using the platform, the "size" attribute field can be displayed in the capacitor classification, so as to facilitate the user to fill in.

[0056] Optionally, in the above technical solution, further comprising:

[0057] S12, according to the user requirement, the material target type is added in the material classification table, when creating the material in the material information table, the material target type is specified in the material information table, then the material attribute of the material target type is entered, and then saved.

[0058] The material target type in the material classification table and the information of each material belonging to the material target type in the material information table are associated, the material target type is added in the material information table, and the material target type is associated with the information of each material belonging to the material target type. The specific implementation is realized by the way of foreign key.

[0059] The material type required by the user is the material target type, the material target type is added in the material classification table, and the material target type is specified in the material information table when creating the material in the material information table. After the material target type is specified, the material properties of the material target type are entered, for example, the material of the capacitor type is a multilayer chip magnetic dielectric capacitor with a model number of GCT41L-0603-2C1-50V-104-K, and the information of the multilayer chip magnetic dielectric capacitor includes material code, material name, detailed specification, unit of measurement, quality grade, and size. The multilayer chip magnetic dielectric capacitor with the model number of GCT41L-0603-2C1-50V-104-K is automatically associated with the capacitor type, and the information of the multilayer chip magnetic dielectric capacitor can be viewed under the capacitor type in the material information table. When the information of the multilayer chip magnetic dielectric capacitor is viewed, the information of the multilayer chip magnetic dielectric capacitor is displayed according to the configuration of the capacitor type in the material information table.

[0060] The material classification table is also used to store the association relationship between the material type and the material, and each material corresponding to the material target type can be determined through the association relationship.

[0061] Optionally, in the above technical solution, the plurality of data tables associated with the material further include a scene attribute table, the scene attribute table is used to store a binding relationship between a form and an attribute of the material in the classification attribute table, and the method further includes:

[0062] S13, when the operation interface receives a user operation of filling in a target form, attribute information of the material in the target form is determined according to the binding relationship stored in the scene attribute table and the association relationship between the material classification table and the material information table, so that the user fills in the target form. The binding relationship and the association relationship are explained as follows:

[0063] 1) The binding relationship stored in the scene attribute table is the corresponding relationship between the classification attribute table and the form scene. According to the user's requirements, after binding a certain classification attribute to a specified form scene, the classification attribute can be viewed and used in the corresponding form scene; the form scene includes application, approval, change, and details, that is, there are different forms in the scenes of application, approval, change, and details.

[0064] 2) The association relationship between the material classification table and the material information table is that after the material is determined according to the material classification, the corresponding classification attribute is found according to the material classification.

[0065] The scene attribute table is used to store the information bound by the form scene and the classification attribute table, the scene attribute table inherits the information of the classification attribute, and is bound in combination with the workflow node.

[0066] Optionally, in the above technical solution, the plurality of data tables associated with the material further include a splicing rule table, the splicing rule table storing attribute splicing rules for splicing at least two attribute information, so that the attribute value can be automatically generated when the material is applied.

[0067] Optionally, in the above technical solution, the process of constructing the operation interface for material management according to the plurality of data tables comprises:

[0068] SpringBoot is adopted as a basic framework, a dream database is adopted as a data storage source, JAVA and MybatisPlus are used to operate the data source and manage and maintain data, a program design adopts an MVC mode to realize data from a data source to front-end data display, Spring-Activiti is integrated to manage and configure a work flow, vue and elementui are used to display and render front-end data, and wherein:

[0069] 1) The coding of the material classification table adopts an agreed generation rule, so that the material classification information is clearer, and the classification table adopts a parent primary key setting mode to construct a tree structure.

[0070] 2) The material information table and the material classification table are associated in a foreign key mode.

[0071] 3) When the material information table extension field is stored, a dream database is used to process a JSON format function, that is, a JSON format condition is verified, and a dream database JSON content parsing acquisition function is used to take out.

[0072] 4) The field name of the general attribute table is set to verify uniqueness, so as to ensure the correctness of the database JSON storage.

[0073] 5) The classification attribute table inherits the information of the general attribute table, but does not make a strong association, so as to release the coupling between attributes.

[0074] 6) The scene attribute table is associated with the work flow approval node, so that the dynamic display of the form of different approval nodes can be realized, the scene attribute table can set the dynamic form according to the information inherited from the classification attribute table, such as dynamic display of form attributes, compulsory verification of form attributes, automatic splicing of attributes, editable state of form attributes, and drop-down options in form attributes, whether to upload attachments or pictures, etc.

[0075] 7) The data list retrieval is dynamically displayed according to the material classification attribute table, and the configuration of whether to perform fuzzy search, whether to perform accurate search, and whether to perform boundary search on a certain attribute can be performed.

[0076] This completed the implementation of the material master data management platform, enabling the application system's front-end configuration to extend material classification, attributes, and other attributes.

[0077] This invention discloses a method for constructing a material data management platform, which is a highly scalable material master data management platform implementation method. It utilizes database tables to achieve a highly scalable material management model. Through programmatic design of the database tables, system administrators can manually configure material classification, attribute expansion, data linkage, form scenario differentiation, and search condition configuration on the application system front end. This solves the problems of display redundancy, poor maintenance flexibility, low search performance, and data fragmentation in the web-based business data management module. This method allows users to perform material classification maintenance, attribute expansion, data linkage, form scenario differentiation, and freely configure search conditions in a clear and user-friendly interface, reducing development costs, shortening maintenance cycles, and improving system scalability.

[0078] Figure 2 The material data management mode in the system is as follows:

[0079] ① The front-end uses Axios to interact with the back-end for data exchange.

[0080] ②The backend uses MybatisPlus to maintain and control data with the database.

[0081] ③ The backend interacts with the workflow module via RESTful API to exchange process information.

[0082] a. The material classification table is linked with the general attribute table to store the classification attribute table.

[0083] b. Classification attributes control the extended attributes of materials.

[0084] c. The material information table and the material classification table are linked using foreign keys.

[0085] d. Associate the form scenario table with the approval nodes in the workflow.

[0086] e. The form scenario table controls the attributes of each scenario in the material information table.

[0087] right Figure 2 The text content is explained as follows:

[0088] 1) Backend: Spring Boot is a project based on the Spring framework. Compared with Spring, Spring Boot is easier to build and quicker to configure. Spring Boot also has a built-in container and application service. Similar to Spring, Spring Boot also distinguishes between the controller layer, business layer, and data persistence layer, and divides the modules according to the business, mainly including: material information module, material classification module, general attribute module, classification attribute module, and splicing rule module, etc.

[0089] 2) Workflow: Implemented based on Activiti, a workflow engine defined using the specialized modeling language BPMN 2.0. The workflow module supports functions such as workflow definition, workflow instance management, and workflow task management. Currently, the workflow module's preset material management workflows include material requisition workflows and material change workflows.

[0090] 3) Frontend: The project's frontend uses Vue and Element UI. Vue is a progressive JavaScript framework with a well-developed ecosystem, offering ease of use and flexibility. Furthermore, Vue's data display mode is a better fit for material classification and maintenance functions. Element UI is an open-source component library based on Vue. Element UI's design style is relatively simple, enabling a more user-friendly human-computer interaction mode.

[0091] 4) Database: DM Database V8 is an independently controllable domestic database. DM Database V8 is a powerful, reliable, and secure relational database that supports the DM_SQL language and provides multiple drivers to meet various usage scenarios. It is the data structure foundation for the design of this invention.

[0092] In another embodiment, the method for constructing a material data management platform according to the present invention is a highly scalable material master data management platform implementation method. Through programmatic design of database tables, it enables system administrators to manually configure material classification management, attribute expansion, data linkage, form scenario differentiation, and search condition configuration on the application system front end. Specifically, it includes:

[0093] S101. Database Table Design: Database tables are the foundation of functional design. The database used in this invention is a relational database. Specifically, the database tables, namely the multiple data tables related to materials, are designed using DM Database (V8) as follows:

[0094] 1) Material classification table: The material classification table is used to store the association basis of the material classification information and the material information table, and the material classification information includes classification name, classification code, classification order, classification description and other information.

[0095] 2) Material information main table: The material information main table is used to store all attributes of the material information, including some basic and general attributes such as material name, material code, model specification, supplier, code description and selection grade, in addition, the material information main table sets an extension field domain, which is composed of ten large field types, which meets the attribute expansion use requirement to the greatest extent, and the self-defined extended attributes of the material are stored in the form of structured objects in the extension field domain.

[0096] 3) General attribute table: The general attribute table is used to store all designed material attributes, including parameter attributes and design attributes of the material, and after increasing the general attribute, it can be used for binding of the material classification; The configurable information of the general attribute includes attribute identification, attribute name, attribute type, attribute group, input expansion configuration, splicing rule binding, form configuration attribute, retrieval configuration attribute and the like.

[0097] 4) Classification attribute table: The classification attribute table is used to store the information of the binding of the material classification and the general attribute table, and the material information can be stored and displayed according to the classification attribute table, and the classification attribute is bound based on the general attribute and the classification information.

[0098] 5) Scene attribute table: The scene attribute table is used to store the information of the binding of the form scene and the classification attribute table, and the scene attribute table inherits the information of the classification attribute and is bound with the workflow node.

[0099] 6) Splicing rule table: The splicing rule table is used to store the attribute splicing rule, and the splicing rule can bind the attribute to automatically generate the attribute value when the material is applied.

[0100] In the design of the database table, the tree structure of the classification table is constructed by setting the parent primary key; the material information main table for storing all attributes of the material information and the extension field domain is created; the general attribute table for storing all designed material attributes is created; the classification attribute table for storing the material classification and the binding information of the general attribute table is created; the scene attribute table for storing the form scene and the binding information of the classification attribute table is created, which inherits the information of the classification attribute and is bound with the workflow node; the splicing rule table for storing the attribute splicing rule is created, and the splicing rule binds the attribute to automatically generate the attribute value when the material is applied.

[0101] S102, programming: the program of the material management mode uses SpringBoot as the basic framework, uses Dm database as the data storage source, uses JAVA and MybatisPlus to operate the data source, carries out data management and maintenance, the program design adopts MVC mode to realize data from data source to front-end data display, the system integrates Spring-Activiti to manage and configure the workflow, uses vue and elementui to display and render the front-end data, specifically:

[0102] 1) The coding of the material classification table adopts the agreed generation rule, so that the material classification information is more clear, and the classification table adopts the method of setting parent primary key to construct the tree structure.

[0103] 2) The material information table and the material classification table are associated by using foreign keys.

[0104] 3) When storing the extended field of the material information table, the JSON format processing function of Dm database is used to check the JSON format condition, and the JSON content parsing function of Dm database is used to get the JSON content.

[0105] 4) The field name of the general attribute table is checked for uniqueness to ensure the correctness of the database JSON storage.

[0106] 5) The classification attribute table inherits the information of the general attribute table, but does not make strong association, so as to eliminate the coupling between attributes.

[0107] 6) The scene attribute table is associated with the workflow approval node, which can realize the dynamic display of different approval node forms. The scene attribute table can set the dynamic form according to the information inherited from the classification attribute table, such as dynamic display of form attributes, mandatory check of form attributes, automatic splicing of attributes, editable state of form attributes, and drop-down options in form attributes, whether to upload attachments or pictures, etc.

[0108] 7) The data list retrieval is dynamically displayed according to the material classification attribute table, and the configuration of whether to search for a certain attribute, whether to search accurately, and whether to search for the boundary can be performed.

[0109] Thus, the material master data management platform is realized, so as to realize the purpose of expanding material classification, attribute, etc. in the front-end configuration of the application system.

[0110] This invention discloses a method for constructing a material data management platform, utilizing database tables to achieve a highly scalable material management model. This invention solves the problems of redundant display, poor maintenance flexibility, low retrieval performance, and data fragmentation in web-based business data management modules. Through this method, users can perform material classification maintenance, attribute expansion, data linkage, form scenario differentiation, and freely configure search conditions in a clear and user-friendly interface, reducing development costs, shortening maintenance cycles, and improving scalability.

[0111] In the above embodiments, although the steps are numbered S1, S2, etc., they are only specific embodiments given in this application. Those skilled in the art can adjust the execution order of S1, S2, etc. according to the actual situation, which is also within the protection scope of this invention. It can be understood that in some embodiments, some or all of the above embodiments may be included.

[0112] This invention provides a material data management platform constructed using any of the methods for constructing a material data management platform.

[0113] like Figure 3 As shown, an embodiment of the present invention provides a computer device 300, which includes a processor 320 coupled to a memory 310. The memory 310 stores at least one computer program 330, which is loaded and executed by the processor 320 to enable the computer device 300 to implement any of the above-mentioned methods for constructing a material data management platform. Specifically:

[0114] The computer device 300 can vary considerably due to differences in configuration or performance. It may include one or more processors 320 (Central Processing Units, CPUs) and one or more memories 310. The one or more memories 310 store at least one computer program 330, which is loaded and executed by the one or more processors 320 to enable the computer device 300 to implement any of the material data management platform construction methods provided in the above embodiments. Of course, the computer device 300 may also have wired or wireless network interfaces, a keyboard, and input / output interfaces for input and output. The computer device 300 may also include other components for implementing device functions, which will not be elaborated upon here.

[0115] An embodiment of the present invention provides a computer-readable storage medium storing at least one computer program, which is loaded and executed by a processor to enable a computer to implement any of the above-described methods for constructing a material data management platform.

[0116] Optionally, the computer readable storage medium can be a Read-Only Memory (ROM), a Random Access Memory (RAM), a Compact Disc Read-Only Memory (CD-ROM), a magnetic tape, a floppy disk, and an optical data storage device, etc.

[0117] In the example embodiment, a computer program product or computer program is also provided, which includes computer instructions stored in a computer readable storage medium. A processor of a computer device reads the computer instructions from the computer readable storage medium, and the processor executes the computer instructions, so that the computer device executes any of the above-mentioned material data management platform construction methods.

[0118] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application are used to distinguish similar objects, and represent no limitation on the specific order or sequence. The order of use of similar objects can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described.

[0119] Those skilled in the art know that the present application can be implemented as a system, a method or a computer program product, therefore, the present disclosure can be specifically implemented as follows: it can be a complete hardware, a complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software, which is generally referred to as "circuit", "module" or "system" herein. In addition, in some embodiments, the present application can also be implemented as a computer program product in one or more computer readable media, which includes computer readable program code.

[0120] Any combination of one or more computer readable medium can be utilized. The computer readable medium can be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium can be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

[0121] Although the embodiments of the present application have been shown and described above, it should be understood by those skilled in the art that the above embodiments are exemplary, and are not to be understood as limiting the present application, and that changes, modifications, substitutions and variations of the above embodiments can be made by those skilled in the art within the scope of the present application.

Claims

1. A construction method of a material data management platform, characterized by, The method comprises the following steps: constructing a plurality of data tables of material association in a database; constructing an operation interface for material management according to the plurality of data tables; the plurality of data tables of material association comprises a material classification table and a material information table; the material classification table is used for storing classification information of all types of materials, and the classification information of the material comprises a classification name, a classification code, a classification order and a classification description; the material information table is used for storing all information of the material, and the all information of the material comprises a material name, a material code, a model specification, a supplier, a code description and a selection grade; the plurality of data tables of material association further comprises a general attribute table, and the general attribute table is used for storing all attributes of all types of materials, and the all attributes comprise an attribute identifier, an attribute name, an attribute type, an attribute group, an input extension configuration, a splicing rule binding, a form configuration attribute and a retrieval configuration attribute; the method further comprises the following steps: the operation interface receives a user operation, selects a target attribute from the general attribute table, and adds the target attribute to the material information table, and adds attribute information of the target attribute in the material information table; the plurality of data tables of material association further comprises a classification attribute table, and the method further comprises the following steps: according to a user requirement, associating the general attribute table and the material classification table to obtain attributes of each target type of material, and storing the attributes of each target type of material in the classification attribute table; the plurality of data tables of material association further comprises a scene attribute table, and the scene attribute table is used for storing a binding relationship between a form and the attributes of the material in the classification attribute table, and the method further comprises the following steps: when the operation interface receives a user operation and fills in a target form, according to the binding relationship stored in the scene attribute table and an association relationship between the material classification table and the material information table, attribute information of the material in the target form is determined, so that the user fills in the target form.

2. The method of claim 1, wherein, the plurality of data tables of material association further comprises a splicing rule table, and the splicing rule table stores attribute splicing rules for splicing at least two attribute information.

3. The method of claim 1 or 2, wherein the method further comprises: the database is a relational database.

4. A material data management platform constructed by the construction method of the material data management platform in any one of claims 1 to 3.

Images