# User

Schema reference for user profiles and the preferences attached to them.

### Users Table

**Table Name:** `users`\
**Description:** User profiles and preferences

{% tabs %}
{% tab title="Schema" %}

| Column               | Type      | Description             |
| -------------------- | --------- | ----------------------- |
| `_id`                | string    | Internal identifier     |
| `additional_context` | json      | Custom user context     |
| `email`              | string    | User email address      |
| `first_name`         | string    | User first name         |
| `last_name`          | string    | User last name          |
| `org_id`             | string    | Organization identifier |
| `preferences`        | json      | User preferences        |
| `region_name`        | string    | User region             |
| `role`               | string    | User role               |
| `updated_at`         | timestamp | Last update timestamp   |
| `user_id`            | string    | User unique identifier  |
| `user_models`        | json      | Personalization models  |
| {% endtab %}         |           |                         |

{% tab title="Query Example" %}

```sql
SELECT
  user_id,
  email,
  role,
  preferences,
  updated_at
FROM users
ORDER BY updated_at DESC;
```

{% endtab %}
{% endtabs %}