PersonWorkspace entity represents the relationship between a person and a workspace in the Well system. It serves as a Many-to-Many linking table and enables sharing people between different workspaces while maintaining workspace isolation.
Table structure
Table name:person_workspaces
Main fields
| Name | Type | Required | Constraints | Allowed Values | Description | Example |
|---|---|---|---|---|---|---|
id | string, UUID, 🔒 system | ✅ Yes | Unique identifier (read-only) | – | Unique identifier of the person-workspace relationship | ”person-workspace-uuid-123” |
person | People (UUID) | ✅ Yes | Foreign key reference | – | Reference to the person | ”person-uuid-456” |
workspace | Workspace (UUID) | ✅ Yes | Foreign key reference | – | Reference to the workspace | ”workspace-uuid-789” |
created_at | string (ISO 8601) 🔒 system | – | auto timestamp | – | Creation timestamp | ”2023-01-01T12:00:00Z” |
updated_at | string (ISO 8601) 🔒 system | – | auto timestamp | – | Last updated timestamp | ”2024-01-01T12:00:00Z” |
deleted_at | string | null 🔒 system | ⚪ No | nullable ISO 8601 | – | Deletion timestamp (soft delete) | “2024-01-01T12:00:00Z” |
Relations
Many-to-One relations
- People: The person in the relationship
- Workspace: The workspace in the relationship