CLIENTUSERSEXTENSION (4.0SP20)

ID

uniqueidentifier

CLIENTUSERID

int

false

Client user ID

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PROVIDERNAME

nvarchar(128)

false

Provider name

IDENTIFIER

nvarchar(512)

false

Identifier returned by provider

DISPLAYNAME

nvarchar(256)

false

Display name

PREFERREDUSERNAME

nvarchar(256)

false

Preferred username

GIVENNAME

nvarchar(128)

false

Given name

FAMILYNAME

nvarchar(128)

false

Family name

FORMATTEDNAME

nvarchar(256)

false

Formatted name

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

IX_CLIENTUSERSEXTENSION_CLIENTUSERID

False

False

False

IX_CLIENTUSERSEXTENSION_DATEADDED

False

False

True

IX_CLIENTUSERSEXTENSION_DATECHANGED

False

False

False

PK_CLIENTUSERSEXTENSION

True

True

False

UC_CLIENTUSERSEXTENSION_IDENTIFIER

True

False

False

TR_CLIENTUSERSEXTENSION_AUDIT_UPDATE

TR_CLIENTUSERSEXTENSION_AUDIT_DELETE