Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create the container structure #34

Open
1 task
Francois-Werbrouck opened this issue Jun 7, 2024 · 0 comments
Open
1 task

Create the container structure #34

Francois-Werbrouck opened this issue Jun 7, 2024 · 0 comments
Labels
good first issue Good for newcomers

Comments

@Francois-Werbrouck
Copy link
Contributor

Francois-Werbrouck commented Jun 7, 2024

Context:

Currently each user is attributed a Blob storage container to upload their picture. However, we might want multiple users to have access to multiple containers. Therefore, we need a DB structure to manage this in the upcoming futur.

---
title: Nachet DB Structure
---
erDiagram
  user{
    uuid id PK
    text email
  }
  group{
    uuid id PK
    text name
    uuid owner_id
  }
  container{
    uuid id
    text name
    uuid created_by
 }
user }o--o{ group: apart
  container||--|| user: uses
  container||--|| group: uses
Loading

TODO:

  • SQL Script to create all necessary tables
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers
Projects
Status: Todo
Status: Todo
Development

No branches or pull requests

1 participant