Table: UserLogin

Database schema and system attributes for UserLogin.

ApiKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 100

ApiKeyPurpose

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Description

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 500

EntityTypeId

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

FailedPasswordAttemptCount

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

FailedPasswordAttemptWindowStartDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

Id

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

IsConfirmed

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsLockedOut

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsOnLine

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsPasswordChangeRequired

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

LastActivityDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastLockedOutDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastLoginDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastPasswordChangedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastPasswordExpirationWarningDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

ModifiedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Password

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 256

PersonId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

UserName

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 510