User Tables
The users_changelog and users_latest tables stores the data of all users, including user type, user details and roles assigned to them.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
document_name | STRING | YES | Firestore document path reference |
document_event_id | STRING | YES | Unique identifier for the document event |
document_timestamp | TIMESTAMP | YES | Timestamp of the document modification/creation |
document_operation | STRING | YES | Type of document operation (e.g., INSERT, UPDATE, DELETE) |
document_id | STRING | YES | Unique document ID in Firestore |
accountObjectID | STRING | YES | Object ID of the associated account |
activated | BOOL | YES | Whether the account or entity is activated |
company | STRING | YES | Name of the company |
companyId | STRING | YES | Unique ID of the company |
contact.email | STRING | YES | Contact email address |
createdTimeStamp | INT64 | YES | Creation timestamp in epoch format |
customerCount | INT64 | YES | Number of customers |
defaultPage | STRING | YES | Default landing page |
enabled | BOOL | YES | Whether the entity is enabled |
firstname | STRING | YES | First name of the user |
invitedAt | INT64 | YES | Invitation timestamp in epoch format |
isAdmin | BOOL | YES | Whether the user has admin privileges |
lastUpdated | INT64 | YES | Last update timestamp in epoch format |
lastname | STRING | YES | Last name of the user |
mobileNumber | STRING | YES | User's mobile number |
objectID | STRING | YES | Unique object ID |
isSuperAdmin | BOOL | YES | Whether the user is a super admin |
lastLoggedInDateTime._seconds | INT64 | YES | Last login timestamp (seconds) |
lastLoggedInDateTime._nanoseconds | INT64 | YES | Last login timestamp (nanoseconds) |
serviceUnitDefaultObjectID | STRING | YES | Default service unit object ID |
serviceUnitName | STRING | YES | Name of the service unit |
serviceUnitObjectID | STRING | YES | Object ID of the service unit |
source | STRING | YES | Source system or origin |
status.label | STRING | YES | Label of the status |
status.value | STRING | YES | Value of the status |
supplierCreationType | STRING | YES | Type of supplier creation |
suspendTimestampAfter._seconds | INT64 | YES | Suspension timestamp (seconds) |
suspendTimestampAfter._nanoseconds | INT64 | YES | Suspension timestamp (nanoseconds) |
suspendTimestampAfterEpoch | INT64 | YES | Suspension timestamp in epoch format |
terminatedTimeStamp._seconds | INT64 | YES | Termination timestamp (seconds) |
terminatedTimeStamp._nanoseconds | INT64 | YES | Termination timestamp (nanoseconds) |
allowSwitching | BOOL | YES | Whether switching is allowed |
department | STRING | YES | Department name |
🔸 Array Columns​
Array of STRUCT
assignedRoles​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
roleId | STRING | YES | Unique id of the role |
label | STRING | YES | Label for the role |
Array of STRING
role​
Holds list of roles assigned to the user. It is not nullable