First ERB messaging #14

tonitch · 2023-12-13T16:18:31+01:00

tonitch commented

2023-12-13 16:18:31 +01:00

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

No description provided.

ERD-1.png

71 KiB