Markvision Enterprise
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.
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.
*This data type is required for Microsoft SQL Server.
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
The user’s full name.
LAST_LOGIN
TIMESTAMP
The time stamp of the last login attempt.
LOGIN_ATTEMPT
The current number of attempts made at a successful login.
REFRESH_TOKEN
The authentication token when the user logs in.
USER_ROLE
This table describes the association of users to roles.
The foreign key back to USERS.USER_NAME.
VARCHAR(30)
The foreign key back to MASTER_ROLE.ROLE_NAME.