This section has three tables:

• users table that stores the users in the application
• roles table that stores the roles in the application
• users roles table that stores the roles for each user

Users table

The users table stores the users in the application.

Its columns are:

• user id primary key populated from sequence
• user name
• user mail
• user login

Roles table

The roles table stores the roles in the application. A user can have one or more roles. Each role has a set of permissions on menu items.

Its columns are:

• role id primary key populated from sequence
• role name

Users Roles table

The roles table stores the roles for each user. A user can have one or more roles.

Its columns are:

• user id - foreign key to user id in users table
• role id - foreign key to role id in roles table

The primary key is the combination of user id and role id.