Usr
User.
Name |
Type (MS SQL) |
Type (Oracle) |
Type (PostgreSQL) |
Nullable |
Description |
---|---|---|---|---|---|
Id |
BIGINT |
NUMBER(20,0) |
int8 |
not null unique |
Id of the object |
PasswordHash |
VARBINARY(64) |
RAW(64) |
bytea |
|
Hash value for user password |
AuthenticationMethod |
INT |
NUMBER(10,0) |
int4 |
not null |
Authentication method. 0: Internal, 1: UC4 (standard authentication with AE) |
IsAdmin |
BIT |
NUMBER(1,0) |
boolean |
not null |
Flag if user is administrator |
Foreign Keys
Name |
Local References |
Foreign References |
---|---|---|
FK_Usr |
Id |
Member |