People entity represents individuals in the Well system. It stores basic personal information and serves as a central point for relationships with other entities such as companies, documents, and workspaces.
Table structure
Table name:peoples
Main fields
| Name | Type | Required | Constraints | Allowed Values | Description | Example |
|---|---|---|---|---|---|---|
id | string, UUID, 🔒 system | ✅ Yes | Unique identifier (read-only) | – | UUID or slug | ”person-uuid-123” |
first_name | string (1–50) | ✅ Yes | max 50 chars | – | First name | ”Ada” |
last_name | string (1–50) | ✅ Yes | max 50 chars | – | Last name | ”Lovelace” |
full_name | string (1–100) 🔒 System | ⚪ No | auto if not set | – | Full name | ”Ada Lovelace” |
job_title | string (0–100) | ⚪ No | max 100 chars | – | Job title | ”Mathematician” |
avatar_image | string | ⚪ No | nullable URL | – | Profile image URL | ”https://example.com/avatar.jpg” |
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 | ”2024-01-01T12:00:00Z” |
deleted_at | string | null | ⚪ No | nullable ISO 8601 | – | Deletion timestamp (soft delete) | “2024-01-01T12:00:00Z” |
Relations
The People entity has numerous relationships with other entities:One-to-Many relations
- PersonWorkspaces: Links with workspaces
- PersonPhone: Associated phone numbers
- PersonEmail: Associated email addresses
- PersonLocation: Addresses/locations
- PersonSocialLink: Links to social networks
- PersonDocument: Documents associated with the person
- Membership: Memberships in organizations
- Collect: Related data collections
- CompanyPerson: Relationships with companies