PGL/Clyde
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

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
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

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 Label
Waiting for review
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: PGL/Clyde#14
No description provided.
Delete Branch "erb_messaging"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?