Phone - Well Starter Kit

The Phone entity represents phone numbers in the Well system. It can be associated with people, companies, and workspaces, and includes verification status, primary designation, and contextual labels.

Table structure

Table name: phones

Main fields

Name	Type	Required	Constraints	Allowed Values	Description	Example
`id`	string, UUID, 🔒 system	—	Unique identifier (read-only)	—	Unique ID	`”phone-uuid-123”`
`number`	string	✅ Yes	E.164 formatted number	E.164 format (+33123456789)	Phone number	`”+33123456789”`
`is_primary`	boolean	⚪ No	default: true, only valid when in relationship with a Person or Company	`true`, `false`	Marks preferred phone	`true`
`is_verified`	boolean	⚪ No	default: false, only valid when in relationship with a Person or Company	`true`, `false`	Verification flag for 2FA setup	`true`
`label`	string (50 char)	⚪ No	max 50 chars, only valid when in relationship with a Person or Company	`work`, `mobile`, `home`, `other`	Tag for extra context when having multiple phones	`”mobile”`
`created_at`	string (ISO 8601) 🔒 system	—	auto timestamp	—	Creation timestamp	`”2023-01-01T12:00:00Z”`
`updated_at`	string (ISO 8601) 🔒 system	—	auto timestamp	—	Last update timestamp	`”2023-01-01T12:00:00Z”`
`deleted_at`	string \| null 🔒 system	—	nullable ISO 8601	—	Deletion timestamp (soft delete)	`“2024-01-01T12:00:00Z”`

Relations

Many-to-Many relations

People: Can be associated with multiple people
Companies: Can be associated with multiple companies
Workspaces: Can be associated with multiple workspaces

Relationship schema

Phone (N) ←→ (N) People
Phone (N) ←→ (N) Companies
Phone (N) ←→ (N) Workspaces

# Direct relationship without intermediate tables
# Each phone can belong to multiple people/companies/workspaces
# Each person/company/workspace can have multiple phones

Data Model

​Table structure

​Main fields

​Relations

​Many-to-Many relations

​Relationship schema

Table structure

Main fields

Relations

Many-to-Many relations

Relationship schema