Organizations
The organizations table contains data the organization. It will only ever contain one row.
This table can be used to determine the organization's name and some settings, as well as metadata about the organization such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| name | The name of the organization as displayed in the user interface. | VARCHAR | Yes |
| subdomain | The subdomain of the organization. | VARCHAR | Yes |
| settings | A JSON representation of organizational settings. | JSONB | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| country_code | The country for the organization, in two character format. | VARCHAR | Yes |
| administrator_user_id | The numerical identifier of the user who is noted as the administrative contact for this organization. Relates to the id column in the users table. |
INT4 | Yes |
| default_country | The default country for the organization, in two character format. | VARCHAR | Yes |
| api_enabled | Whether the API is enabled for this organization or not. | BOOL | Yes |