Create the user permission level structure

[Francois-Werbrouck]

Context:

We currently have a user table. However most of our current users for Nachet are our affiliates. Therefore, Nachet is subject to growth and requires a permission structure in the database in the futur.

---
title: Nachet DB Structure
---
erDiagram
  user{
    uuid id PK
    text email
  }
  group{
    uuid id PK
    text name
    uuid owner_id
  }
  permission{
    int id
    text name
 }
user }o--o{ group: apart
  permission ||--|| user: has
  permission ||--|| group: has

Loading

TODO:

• SQL Script to create all necessary tables