Skip to content

Database

Kravchuk Roman edited this page Apr 17, 2023 · 2 revisions

Intro

In this section, I'll tell you what data schema I created and why I created it that way.

Schema

The schema of the database is as follows:

schema

I decided to store passwords in a separate table and add a salt field to the table with users, as I thought this method of storing important data would be the most secure.

I also have a couple of tables:

  • storages_types
  • settings_categories

whos existence is still in question, as these tables are unlikely to hold much data and it would be fair to move them inside the application. And after removing these tables, add category field for the settings table, and redo the storages_types_tips table and use type instead of id_storage_type field.

Clone this wiki locally