This section has three tables:

• menu items table that stores the menu in the application
• menu roles table that stores the permissions on menu items for each role
• menu users table that stores the special permissions on menu items for each user

Menu Items table

The menu items table stores the menu items in the application.

Its columns are:

• menu item id primary key populated from sequence
• menu item parent id - the parent menu item id
• menu item order - the order of the menu items under the same parent
• menu item label

Menu Roles table

The menu roles table stores the permissions on menu items for each role.

Its columns are:

• menu item id - foreign key to menu item id in the menu items table
• role id - foreign key to role id in the roles table

The primary key is a combination of menu item id and role id.

Menu Users table

The menu users table stores the special permissions on menu items for each user.

Its columns are:

• menu item id - foreign key to menu item id in the menu items table
• user id - foreign key to user id in the users table

The primary key is a combination of menu item id and role id.