App Database : jiveUser Table

Container table for user data.

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		Creation date.
email	varchar	100	false		Email address.
emailVisible	int	N/A	false		Privacy flag for showing email to other users (Boolean).
federated	int	N/A	false		Indicates if the system of record is outside clearspace
firstName	varchar	100	true	true	First name.
isExternal	int	N/A	false		Indicates if a user is external to the system and this account is simply a place holder
lastLoggedIn	bigint	N/A	false		Last time the user logged in.
lastName	varchar	100	true	true	Last name.
lastProfileUpdate	bigint	N/A	false		Last time the user's profile was updated.
modificationDate	bigint	N/A	false		Last modified date.
name	varchar	100	true	true	Full name.
nameVisible	int	N/A	false		Privacy flag for showing name to other users (Boolean).
passwordHash	varchar	64	false		AES-265 One-way hash of the user password and salt.
status	int	N/A	false		The current status of a newly registered user
userEnabled	int	N/A	false		Whether the current user is enabled or not.
userID	bigint	N/A	false		User ID. Primary key.
username	varchar	100	false	true	User name.
visible	int	N/A	false		Indicates if the user will be in a search result or not