SsoToken

SSO Authentication Token.

Name

Type (MS SQL)

Type (Oracle)

Type (PostgreSQL)

Nullable

Description

Id

BIGINT

NUMBER(20,0)

int8

not null unique

Id of the object

Guild

NVARCHAR(255)

NVARCHAR2(255)

varchar(255)

not null unique

Guid of Token

System

NVARCHAR(255)

NVARCHAR2(255)

varchar(255)

not null

Name of the AE system

Client

INT

NUMBER(10,0)

int4

not null

Client in AE

Username

NVARCHAR(255)

NVARCHAR2(255)

varchar(255)

not null

Username

Department

NVARCHAR(255)

NVARCHAR2(255)

varchar(255)

not null

Department of user

Token

NVARCHAR(255)

NVARCHAR2(255)

varchar(255)

not null

Token for SSO

CreationTimeStamp

DATETIME

TIMESTAMP(4)

timestamp

not null

Timestamp of token creation

Used

BIT

NUMBER(1,0)

boolean

not null

Defines if Token has been used.