A database design and associated support tools for storing Intelligent Part Numbering System (IPNS) metadata for the purpose of interfacing with information systems in a more efficient way, thereby reducing maintenance requirement and improving information technology (IT) searching options. Embodiments of the present invention are directed to a method, system, and computer-readable medium for storing one or more attributes of a part number family in a database as metadata. The method includes associating a part number code with each attribute in the database; receiving one or more user inputs, each user input indicating a selection of one of the attributes; determining the part number codes associated with each of the selected attributes; and generating a part number based on the part number codes associated with each of the selected attributes.