# crm_companies

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

CRM company records (e.g. agencies, universities) in the client's CRM namespaces.

| Column | Description |
| --- | --- |
| `id` | Unique identifier for the company |
| `name` | Name of the company |
| `domain` | Website domain of the company |
| `notes` | Free-text notes about the company |
| `tax_number` | Tax identification number of the company |
| `unique_reference` | Unique reference of the company |
| `crm_namespace_id` | Internal identifier of the CRM namespace the company belongs to |
| `crm_namespace_uuid` | UUID of the CRM namespace the company belongs to; matches crm_namespaces.uuid |
| `created_at` | Timestamp indicating when the company was created |
| `updated_at` | Timestamp indicating when the company was last updated |
| `timestamp` | Date when the table was last synchronized |