PGL/Clyde
3
2 Fork 3
Code Issues 13 Pull Requests Actions Projects 3 Releases 2 Wiki Activity

First ERB messaging #14

Merged
tonitch merged 2 commits from erb_messaging into master 2023-12-15 14:36:11 +01:00
Conversation 2 Commits 2 Files Changed 2
+88
tonitch commented 2023-12-13 16:18:31 +01:00
Owner
Copy link
Copy source

Entity relational diagram

Messaging extension

%%{init: { "er": {"fontSize": 25}}}%%
erDiagram

%% General
Users

%% Messages
Discussions{
    Integer id PK
    String name
}

Messages{
    Integer id PK
    Integer response FK "Messages"
    String content
}

Discussions ||--o{ Messages: "" 
Discussions ||--o{ Users: ""

Messages o|--o{ Messages: "answers"

%% Forums
Forums{
    Integer id PK
    String name
}

Topics{
    Integer id PK
    String subject
    String content
    Boolean locked
}
Answers{
    Integer id PK
    String content
    Boolean anonymous
    TimeStamp creation_time 
}

Polls{
    Integer id PK
    enum PollType
}
Options{
    Integer id PK
    String name
}

Forums ||--o{ Users: "Registered"
Forums ||--|| Teacher: "Owner"
Forums ||--|| Course: ""
Forums ||--o{ Topics: ""
Forums ||--o{ Polls: ""

Topics ||--|| Teacher: "Author"
Topics ||--|| Users: "Author"
Topics ||--o{ Answers: ""

Polls ||--o{ Options: ""

Options ||--o{ Votes : ""

Votes }o--|| Users: "Voter"


%% Appointments
Teachers
Appointments{
    Integer id PK
    TIME sent_time
    enum Status
}

Appointments ||--|| Teachers: ""
Appointments ||--|| Users: ""

Debucquoy Anthony

# Entity relational diagram ## Messaging extension ```mermaid %%{init: { "er": {"fontSize": 25}}}%% erDiagram %% General Users %% Messages Discussions{ Integer id PK String name } Messages{ Integer id PK Integer response FK "Messages" String content } Discussions ||--o{ Messages: "" Discussions ||--o{ Users: "" Messages o|--o{ Messages: "answers" %% Forums Forums{ Integer id PK String name } Topics{ Integer id PK String subject String content Boolean locked } Answers{ Integer id PK String content Boolean anonymous TimeStamp creation_time } Polls{ Integer id PK enum PollType } Options{ Integer id PK String name } Forums ||--o{ Users: "Registered" Forums ||--|| Teacher: "Owner" Forums ||--|| Course: "" Forums ||--o{ Topics: "" Forums ||--o{ Polls: "" Topics ||--|| Teacher: "Author" Topics ||--|| Users: "Author" Topics ||--o{ Answers: "" Polls ||--o{ Options: "" Options ||--o{ Votes : "" Votes }o--|| Users: "Voter" %% Appointments Teachers Appointments{ Integer id PK TIME sent_time enum Status } Appointments ||--|| Teachers: "" Appointments ||--|| Users: "" ``` Debucquoy Anthony
tonitch added the Waiting for review label 2023-12-13 16:19:35 +01:00
tonitch commented 2023-12-13 22:46:12 +01:00
Author
Owner
Copy link
Copy source
No description provided.
ERD-1.png
71 KiB
ERD-1.png
tonitch force-pushed erb_messaging from 2522cef18a to d4e3ded3da 2023-12-13 22:57:59 +01:00 Compare
tonitch requested review from Owners 2023-12-13 22:59:08 +01:00
Maxime approved these changes 2023-12-14 13:25:52 +01:00
Maxime left a comment
Owner
Copy link
Copy source

je suis pas certain des noms sur les associations

je suis pas certain des noms sur les associations
tonitch merged commit 4f1a44549b into master 2023-12-15 14:36:11 +01:00
tonitch referenced this issue from a commit 2023-12-15 14:36:11 +01:00
ERB msg done (#14)
tonitch deleted branch erb_messaging 2023-12-15 14:36:11 +01:00
Sign in to join this conversation.
Reviewers
No Reviewers
Maxime
Labels
Clear labels
Bug
Done
finie, en attente de validation pour ou pret à la fermeture
 Pas urgent
A faire que si on a le temps
 Proposition
Question
TODO
Tests
URGENT BORDEL DE Q
Waiting for review
back
front
No labels Waiting for review
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
LeoMoulin Maxime Wal tonitch (Debucquoy Anthony)
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: PGL/Clyde#14