| Column | Type | Description |
|---|---|---|
id | uuidv4 | Unique user ID generated by LearnInk |
custom_id | text | Optional — the custom identifier you passed via the Identify API (useful for joining with your own data) |
registration_status | text | imported = added to the user list but not yet registered · registered = has completed registration · archived = deactivated, excluded from analytics and unable to access content |
user_groups | jsonb | Array of user group IDs assigned to this user — join with the user_groups table for group names |
custom_name | text | Imported name if provided, otherwise the name entered during registration |
phone_number | text | Phone number used at registration (if applicable) |
country | text | Selected by the user during registration |
region | text | Selected by the user during registration |
sex | text | Selected by the user during registration |
age_bracket | text | Selected by the user during registration |
created_at | timestamptz | When the user was created in LearnInk (same as registered_at unless they were pre-imported) |
registered_at | timestamptz | When the user completed registration |
last_active | timestamptz | When the user was last active in the app |
updated_at | timestamptz | When this row was last updated |
Table Reference
users
User profiles and registration status for your organisation
Each row represents a single user connected to your organisation.