CompanyPhone

​

API operations

​

Data model

​

Attributes

​

Relationships

​

System-computed

• pk — auto-increment serial primary key (internal, never exposed via API)
• created_at — set by MikroORM onCreate hook to new Date() on insert; no onUpdate hook (column does not change after creation)
• deleted_at — null at creation; set to current timestamp by soft-delete logic in the pipeline or repository layer; never hard-deleted under normal operation
• No updated_at column on this entity (audit trail is creation + soft-delete only)
• No *_id UUID public identifier on CompanyPhone itself — the pivot is referenced via its parent Company and Phone IDs in the API; internal pk is used for joins only
• Partial unique index uniq_company_phones_primary_company is enforced by the database engine on (company_pk) WHERE deleted_at IS NULL AND is_primary IS TRUE — only one active primary phone per company is permitted at the DB level
• Composite index idx_company_phones_company_deleted (company_pk, deleted_at) and reverse index idx_company_phones_phone (phone_pk) are maintained automatically; added by Migration20260416100000 to cover the forward and reverse array-relationship traversal patterns identified via production Query Insights

​

Example

{
  "data": {
    "type": "company_phone",
    "id": "a3f7c821-91be-4d02-b56a-3e1234567890",
    "attributes": {
      "is_primary": true,
      "is_verify": false,
      "label": "main",
      "created_at": "2025-10-14T08:23:11.000Z",
      "deleted_at": null
    },
    "relationships": {
      "company": {
        "data": { "type": "company", "id": "9e2b1c44-0001-4321-abcd-000000000001" }
      },
      "phone": {
        "data": { "type": "phone", "id": "bb44f109-dead-beef-cafe-123456789abc" }
      }
    }
  }
}