Home Inventory Database with Barcode Functionality

I am looking to create a home inventory database which operates entirely without subscriptions.
The system should support barcode scanning and allow me to track the location and status of items throughout my home.
Initial Categories
1. Books
• Scan existing ISBN barcodes where available.
• Record title, author, location and notes.
• Ability to search for books.
2. Clothing
I want a more advanced tracking system for clothing.
Example: Socks
Socks will be stored in a sock organiser.
I plan to photograph each pair of socks and display the photograph in the corresponding organiser location.
Each clothing item should have a unique barcode.
The system should support the following states:
1. In Organiser
2. Being Worn
3. In Laundry
4. Taken on Vacation
5. Disposed Of
6. Replaced
I would like to be able to scan an item and update its status quickly.
Future Expansion
The system should be capable of expanding to additional categories such as:
• Car brochures
• Magazines
• Documents
• Household items
• Electronics
• Furniture
• Storage boxes
• Attic contents
• Shed contents
Long-Term Goal
My long-term goal is to create a complete inventory of household possessions so that every significant item can be identified, located and tracked through barcode scanning.
Requirements
• No subscription fees.
• Data stored locally.
• Windows PC compatible.
• Android phone compatible.
• Wireless barcode scanner support.
• Ability to print barcode labels.
• Ability to attach photographs to records.
• Ability to search and filter inventory records.
• Ability to export and back up the database.
• Simple enough for daily use.
• Must remain usable with thousands of inventory records.