I am designing a database for an asset management system.
The assets are pieces of equipment, some of which are
components for other pieces of equipment.
The requirements state that there is a set of common
columns for each piece of equipment, e.g. value. A
suggested database design is a table for each piece of
equipment with columns specific to that piece of equipment
and another table containing the columns common to all
pieces of equipment. Each equipment-specific table would
have a foreign key to the common table, establishing a one-
to-one relationship. One of the suggested common columns