The short version:
If you start deleting records from tables manually, you will almost assuredly mangle your data in a way that will cause real problems. This software uses a relational database system, which means that some tables exist just to establish relationships between other pieces of data. When you delete part of that equation, Bad Things Happen(TM).
We utilize soft deletes in Snipe-IT, which means records are never really deleted, they are simply marked as deleted. This is by design, so that you don't lose history on an asset when, for example, you delete a user. Just because the user is no longer at your organization, that doesn't mean you would want to wipe the previous history of the assets they had while they were there.
ALWAYS back up your database before you start manually editing database records
so that when it breaks everything (and it probably will), you will be able to restore it.
If you absolutely insist on deleting data directly, make sure the corresponding records in the
action_logs table are also deleted. The
action_logs table holds all of the history for assets, accessories and users, and if you delete the assets, accessories, or users it ties together, things break.
If all else fails, delete the contents of
action_logs. This should be considered an absolute last resort, as you will be wiping out the history of every checkin, checkout and file upload in the history of the app.
Updated over 4 years ago