Skip to content

Add User Profile and Team History #34

@IgorPolyakov

Description

@IgorPolyakov

Implement additional table team_history to store user team history.
The team_members must be renamed to profiles table.

Database Schema Changes

  1. Table profiles:

    • id (UUID): Primary key.
    • user_id (UUID): Foreign key referencing users(id).
    • current_team_id (UUID): Foreign key referencing teams(id).
    • created_at (TIMESTAMP): Timestamp of profile creation.
    • updated_at (TIMESTAMP): Timestamp of last profile update.
  2. Table team_history:

    • id (UUID): Primary key.
    • user_id (UUID): Foreign key referencing users(id).
    • team_id (UUID): Foreign key referencing teams(id).
    • joined_at (TIMESTAMP): Timestamp when the user joined the team.
    • left_at (TIMESTAMP): Timestamp when the user left the team (nullable).

Metadata

Metadata

Assignees

No one assigned

    Labels

    server-apiIssues for server api

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions