SQL Database

We chose MariaDB as the database for the forum because it is a powerful, reliable, and scalable relational database. Being an open-source database with an active community, it ensures continuous development and support. Its compatibility and seamless integration with the existing technology stack of the forum were additional reasons for its selection.

Using the JPA (Java Persistence API) Entity Manager, the following tables are automatically created for the entity classes:

Entity Relationship Diagram

    erDiagram
    User {
        UUID id  PK
        string Username 
        string Bio
        String Password
        Enum Role 
    }
    Post {
        UUID id PK
        UUID User FK
        string Title
        string Content
        DateTime CreatedAt
        Boolean edited

    }
    Comment {
        UUID id PK
        UUID User FK
        UUID Post FK
        string Content
        DateTime CreatedAt
    }
    User ||--o{ Post : "author"
    User ||--o{ Comment : "author"
    Post ||--o{ Comment : "comments"

Loading