UD_USER
Description
This table stores user information for the Detect system, including authentication and profile details.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| ID | BIGINT(20) | The unique identifier for the user. |
| VARCHAR(255) | The email address of the user. | |
| INTERNAL | BIT(1) | Indicates if the user is an internal user. |
| USERNAME | VARCHAR(255) | The unique username of the user. |
| PARTITION_ID | BIGINT(20) | The partition ID associated with the user. |
| PARTITION_NAME | VARCHAR(50) | The name of the partition. |
| LOCALE | VARCHAR(50) | The locale preference for the user. |
| TENANT_ID | VARCHAR(50) | The tenant identifier for multi-tenancy support. |
| PLATFORM_USER_ID | BIGINT(20) | The unique identifier from the Unica Platform. |
| CREATED_DATE | DATETIME | The date and time when the record was created. |
| CREATED_BY | BIGINT | The user ID who created the record. |
| UPDATED_BY | BIGINT | The user ID who last updated the record. |