https://dbdiagram.io/d/687a6830f413ba3508958cb8

๐Ÿ“„ Synapse โ€“ Database Schema Documentation

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


๐Ÿง  Core Schema Domains

๐Ÿง‘โ€๐Ÿ’ป Talent & Organization

๐Ÿ“‹ Work & Task Management


๐Ÿงพ Enum Types for Data Integrity

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