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