Authentication and authorization

The following tables are used for the user authentication and authorization mechanism of MVE.

MASTER_ROLE

This table contains all the roles supported by MVE.

Field name	Data type	Description
ID	BIGINT	The primary key.
ROLE_NAME	VARCHAR(255)	The name of the role.

USERS

This table lists all the internal user accounts of MVE.

Field name	Data type	Description
*This data type is required for Microsoft SQL Server.
ID	BIGINT	The primary key.
USER_NAME	VARCHAR(15)	The user-supplied user name.
USER_PASS	VARCHAR(1024)	The user-supplied password.
ENABLED	SMALLINT/ TINYINT*	The flag indicating whether this account is enabled.
NAME	VARCHAR(255)	The user’s full name.
LAST_LOGIN	TIMESTAMP	The time stamp of the last login attempt.
LOGIN_ATTEMPT	BIGINT	The current number of attempts made at a successful login.
REFRESH_TOKEN	VARCHAR(1024)	The authentication token when the user logs in.

USER_ROLE

This table describes the association of users to roles.

Field name	Data type	Description
ID	BIGINT	The primary key.
USER_NAME	VARCHAR(15)	The foreign key back to USERS.USER_NAME.
ROLE_NAME	VARCHAR(30)	The foreign key back to MASTER_ROLE.ROLE_NAME.