I'm attempting to design a database to track IT Fixed Assets and Consumable Parts; what is the best practice for this?

Should I design separate tables for Fixed Assets and Consumables, or should I have just one table containing rows for both types of items, with a Category field?

1 Answer 1


If the Fixed Assets and Consumables have some identical columns, they can be in one table. Then create a category like table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.