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.
EMAIL 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.