Company entity represents businesses in the Well system. It stores main company information and serves as a central point for relationships with people, documents, and workspaces.
Table structure
Table name:companies
Main fields
| Name | Type | Required | Constraints | Allowed Values | Description | Example |
|---|---|---|---|---|---|---|
id | string, UUID, 🔒 system | ✅ Yes | Unique identifier (read-only) | – | Unique identifier of the company previously created | ”company-uuid-123” |
name | string | ✅ Yes | 1–100 chars | – | Company name | ”Acme Corp” |
description | string | ✅ Yes | max 500 chars | – | Company description explaining business purpose | ”An innovative technology company” |
domain | string | ⚪ No | max 500 chars | – | Company domain name used as unique identifier in some cases | ”acme.com” |
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
The Company entity has many relationships with other entities:One-to-Many relations
- CompanyRelation: Relationships between companies
- CompanyPerson: Links with people
- CompanyWebLink: Links to social media profiles and websites
- CompanyLocation: Company addresses/locations
- CompanyEmail: Company email addresses
- CompanyPhone: Company phone numbers
- CompanyCategory: Categories/business sectors
- CompanyDocument: Documents associated with the company
- CompanyWorkspace: Relationships with workspaces