Project

General

Profile

FermiShuttle Application Wiki

This application will support the creation and management of shuttle tours, originating from on-site or off-site.

User Management

The users for this application are stored within the FESSPROD database schema in a table named FERMI_APP_USER.

COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ID NUMBER No 1
APPLICATION_ID NUMBER Yes 2
FERMI_ID VARCHAR2 Yes 3
USERNAME VARCHAR2 Yes 4
ENTER_DATE DATE Yes 5
SECURITY_ROLE VARCHAR2 Yes 6

Notifications

- Create Shuttle Request: Notification sent to requester and admins

Database

Schema