Improve the existing DB structure #58

New issue

Open

opened 2022-05-30 17:59:27 +00:00 by MCWertGaming · 0 comments

MCWertGaming commented

2022-05-30 17:59:27 +00:00

(Migrated from github.com)

We should change the DB schema to comply with SQL procedures:

Combining the verify, user and profile tables into one
Using IDs as foreign keys, as well as others maybe as well
Check if UUIDs can be changed to auto increment
verify code table?
minimize data like names if possible
badge table?
audit log table (user login logs)

We should change the DB schema to comply with SQL procedures: - [ ] Combining the verify, user and profile tables into one - [ ] Using IDs as foreign keys, as well as others maybe as well - [ ] Check if UUIDs can be changed to auto increment - [ ] verify code table? - [ ] minimize data like names if possible - [ ] badge table? - [ ] audit log table (user login logs)

Commenting is not possible because the repository is archived.