Make auth table independent of other tables. No update or delete cascade

[joweste]

Is your feature request related to a problem? Please describe.
When auth table id is deleted you are cascading delete to other tables (chats.....)

Describe the solution you'd like
A auth id can be invalid and can be deleted. But the chats, messages.... can continue being valid and not should be deleted. They depends only session_id(key), not from auth id

Describe alternatives you've considered
Make other tables independents from auth table and dependents only of 'session id'(key)

Additional context

I also need to fix some problems with models columns and unique keys to make work in postgres