https://dbdiagram.io/d/687a6830f413ba3508958cb8
This document describes the PostgreSQL database schema powering Synapse, a collaborative talent and task management platform. It supports structured teams, skill-based task assignment, real-time collaboration, and granular user roles.
โก๏ธ Explore visually on dbdiagram.io
teams: Organizational units. Each team has a unique name and exactly one manager.users: All platform participants. Tracks user roles, availability, and team memberships.skills: Canonical list of normalized platform-wide skills.skill_aliases: Maps alternate or common variants of skill names to canonical skills.user_skills: Represents user proficiency across various skills.invitations: Supports role-based onboarding with email invites and optional team linkage.projects: Containers for related tasks. All projects are now explicitly tied to a team.tasks: Core work unit in Synapse. Tasks belong to projects and can be assigned to users.task_required_skills: Lists skills required to perform a specific task.| Enum Type | Values | Description |
|---|---|---|
availability_status |
available, busy |
Indicates a user's task availability |
task_status |
open, in_progress, done |
Tracks task lifecycle |
task_priority |
low, medium, high, critical |
Specifies task urgency |
proficiency_level |
beginner, intermediate, expert |
Represents user expertise |
user_role |
admin, manager, engineer |
Defines permissions and scope of control |