Merge Locations/Items Into a Single "Entity" type

[mcarbonne]

What is the problem you are trying to solve with this feature?

Currently, lot of features already exists for Items but are missing for Locations. There are several issues opened to also implement them for locations (qr code, pictures, maintenance...)

What is the solution you are proposing?

In order to simplify code base, merging items and locations into a single entity will enabled to share all features between items and locations.
The original idea is taken from hay-kot/homebox#696.
To sum up, the idea is to use only one table for everything and add a type column (item or location for now) + a parent column.

I haven't looked yet into details, but it should solve all those issues :

• Photo for location #216
• simplify sub-items handling
• Add Pictures to Locations #52
• Real estate property management details for Locations #51
• Add ability to record Maintenance for Locations #38
• Containers #27 (as it easily allow to create new types of entities)
• Location QR Codes #9
• Feature Request: Ability to Move all Child Items when the Location of the Parent Item is Changed #110

What alternatives have you considered?

No response

Additional context

No response

Contributions

• I have searched through existing issues and feature requests to see if my idea has already been proposed.
• If this feature is accepted, I would be willing to help implement and maintain this feature.
• If this feature is accepted, I'm willing to sponsor the development of this feature.

[tankerkiller125]

We're already looking into doing this, we have a roadmap we're working on putting finishing touches on and we'll release that to the community most likely immediately after the next version is released.

[tioan]

/boss 10

[boss-bounty]

Total Bounty: $10

Bounties

Bounties paid automatically on close:

• @tioan: $10