---
# System prepended metadata

title: Database

---

# Database
[TOC]

## Definition Tables
### Workflow
> The workflow tables are used to define the business workflow and different actions and steps for processing the reports (Complaints).
- Workflow
- WorkflowDetails
- WorkflowActions

### Users
> The user tables are used to define the user information and the user access rights for locations and assets and some of the ♀users preferences.
- AirportUser
- UsersSpecificLocationsAccess
- UsersNotificationsTypes
- UsersNotificationsPreferences
- UserConferences

### User Roles
> The user role tables are used to define the roles and the access permissions for each role.
- AirportRole
- RolesModulesAccess

### Units(Tenants)
> The tenants tables are used to define the units and their association with other modules which has an impact on module and resources access.
- Tenant
- TeamsVisitPeriod
- TenantEventType
- TenantEventPoints
- TenantLocation
- TenantWorkflow
- TenantAnswerGroup
- TenantForm

### Subunits
> The subunits tables are used to define the subunits and teams and their association with the users.
- SubUnit
- SubUnitUsers

### Campaigns
> The campaigns tables are used to define the campaigns planned for a certain unit, locations and users with some criteria for activities related to the campaign.
- Campaigns
- CampaignCriterias
- CampaignLocationCriterias

### Locations
> The locations tables are used to define the locations and some information about them such as Geo-Coordinates.
- Locations
- LocationsFlatRelations
- LocationInformations
- LocationFiles

### Assets
> The assets tables are used to define the assets on a certain location and some information about them such as serial number and user manual, ...etc.
- Assets
- AssetsImages
- AssetFiles

### Form
> The forms tables are used to define the fields and the relations between the fields which will be filled by the users to submit the reports (Complaints).
- Form
- FormDetails
- FormControls
- FormAction

### Form Helpers
> The form helper tables are used to define some reusable component which could be used in multiple form to make building forms take less time and effort.
- QuestionTemplate
- QuestionTemplateDetails
- AnswerGroup
- AnswerGroupValues
- ImageLibrary

### Files
> The files helper tables are used to define the files and categories uploaded to the system and the access permissions for them.
- File
- FileCategory
- FilePermissions

### Activity
> The activities helper tables are used to define and Schedule activities on the users, units, assets, and locations for the reports that should be submitted and their associated workflow.
- Activity
- ActivityUsers
- ActivityAssetsUsers
- ActivityEventForm
- ActivityMonthlySettings
- ActivityDailySettings
- ActvityWeeklySettings

### TeamsShifts
> The TeamsShifts helper tables are used to define the working hours of certain unit members and the location availability for visit.
- TeamsShifts

---

## Logs Tables
- SchemaVersions 
    > Log the updates on the Database Schema.
- Logs
    > Store the application logs, which could be used to detect and trace issues and insure the behavior of the some features.
- RegisteredDevice
    > Store an id for the each device used by users to login to the application.
- AssetsHistory
    > Log the history of assets transition between locations.
- UserLocationCheckIn
    > Store the location at which user checked in.

## Transaction Tables
### Events
> The events tables are used to store the reports (Complaints) submitted by the users and the relation with other reports and some associated resources such as files, images, ...etc.
- Event
- EventDetails
- EventImages
- ConferenceVideo
- RecentActivities
- EscalationHistory
- EventsLinking
- EventIssues
- EventFlatAnswer
- EventConference
- EventSections

### Event Actions
> The Event Actions tables are used to store the actions,  activities and procedure performed regarding the reports workflow, issues, updates and the assignment.
- EventActions
- ActionImages
- ActionRecentActivities

### Notifications
> The notifications tables are used to store the notifications sent to the users
- Notifications
- NotificationLocations
- NotificationDetails

---

## Lookup and Configs Tables
- Setting
- SeverityLevel
- LookUpTypes
- ImportanceLevel
- ReadinessIndicator
- QuestionSucessConditionType
- NotificationsPreferences
- ModulesAcessTypes
- Modules
- LocationType
- LocationCategory
- LocationSubCategory
- LocationsAccounts
- ISICListAndType
- EventType
- EventStatus
- Entity
- Action
- ActionAvailable
- AssetsManufacturers
- AssetFilesTypes
- AssetsTypes
- ActivityType
- ActionStatus
- WorkFlowTypes
- ActionRole
- Licenses
