Educational project

Just an educational project for repeating and consolidating acquired knowledge.

Boards & Diagrams & Design

• Trello board
• Miro board
• Dbdiagram (for creating used PgAdmin => Backup => plain => Only schema => Remove all checkboxes => Generate .sql => Import to the dbdiagram)
• Figma

Applications

• Backend — .NET 6, PostgreSQL
• Frontend — Angular 14, rxjs

Requirements

• NodeJS (16.10.x);
• TypeScript (4.8.x);
• RxJS (7.4.x);
• NPM (8.x.x);
• PostgreSQL (14.2)

Tools

• pgAdmin
• VSCode
• Visual Studio

DB Schema

For diagram creation used Mermerd tool

erDiagram
    RefreshTokens {
        integer Id PK
        text Token 
        text JwtId 
        timestamp_with_time_zone ExpiresAt 
        boolean Used 
        boolean Invalidated 
        integer UserId FK
        timestamp_with_time_zone CreatedAt 
        timestamp_with_time_zone UpdatedAt 
    }

    Users {
        integer Id PK
        text Username 
        timestamp_with_time_zone CreatedAt 
        timestamp_with_time_zone UpdatedAt 
        bytea PasswordHash 
        bytea PasswordSalt 
        timestamp_with_time_zone VerifiedAt 
        text Email 
    }

    RefreshTokens }o--|| Users : "UserId"