Export information
This document provides information about the database tables and their structure in the SoloDB system.
Table of Contents
User Management
user
User information
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
FirstName | string | ||
LastName | string | ||
DisplayName | string | ||
EmailAddress | string | ||
IsActive | boolean | Yes | |
IsAdmin | boolean | Yes | Boolean value to determine if a user is admin |
UserPrincipalName | string | Yes | |
Equivalency | string | Yes | Equivalency of the user in the company, data fetched from the HR information |
CompanyName | string | Yes | Company name of the user, data fetched from the HR information |
Country | string | Yes | Country of the user, data fetched from the HR information |
Statute | string | Yes | Statute of the user, data fetched from the HR information |
Payroll | string | Yes | Payroll status of the user, data fetched from the HR information |
Department | string | Yes | Department of the user, data fetched from the HR information |
PersonnelNumber | string | Yes | Personnel number of the user, data fetched from the HR information |
role
Table for Role. Contains reference data for Role entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Description | string | Yes |
user_role
Table for user role. Contains transactional data between users and the role.
Column | Type | Nullable | Description |
|---|---|---|---|
UserId | integer | FK to user table | |
RoleId | integer | Fk to role table |
Equipment Management
equipment
Table for Equipment. Contains reference data for Equipment entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
MESName | string | Yes | |
Code | string | Yes | |
SerialNumber | string | Yes | |
VendorId | integer | Yes | |
IsActive | boolean | Yes | |
IsActiveInMES | boolean | Yes | |
IsReservationPossible | boolean | Yes | |
IsDoubleBookingPossible | boolean | Yes | |
IsReservationApprovalRequired | boolean | Yes | |
isTrainingPossible | boolean | Yes | |
ownership | string | ||
Description | string | Yes | |
RoomId | integer | Yes | |
ZoneId | integer | Yes |
equipment_role
Table for Role. Contains reference data for Role entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Title | string | Yes | |
Description | string | Yes |
equipment_equipment_role
Equipment Role information. Contains data related to equipment and their Role.
Column | Type | Nullable | Description |
|---|---|---|---|
EquipmentId | integer | ||
RoleId | integer | ||
UserId | integer | ||
InApprovalFlow | boolean | Yes | |
IsActive | boolean | Yes | |
Comment | string | Yes |
equipment_equipment_user
Equipment User information. Contains data related to equipment and their User.
Column | Type | Nullable | Description |
|---|---|---|---|
EquipmentId | integer | ||
UserId | integer | ||
IsActive | boolean | Yes | |
Comment | string | Yes |
equipment_module
Equipment module information
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
EquipmentId | integer | ||
Name | string | ||
MESName | string | Yes | |
IsActive | boolean | Yes | |
IsMainTool | boolean | Yes | |
IsReservationPossible | boolean | Yes |
equipment_module_type
Equipment Type information. Contains data related to equipment and their Type.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Type | string | Yes |
equipment_module_changelog
Equipment module changelog information
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ModuleId | integer | ||
UserId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
Type | string | ||
Source | string | ||
RunStepId | integer | Yes | |
RunStepChecklistId | integer | Yes |
equipment_module_status
Equipment module status information. Each record represents a status of a module and the end-time is determined by the start time of the next status.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ModuleId | integer | ||
StatusId | integer | ||
IsActive | boolean | Yes | |
UserId | integer | ||
StartDate | date | ||
StartTime | time | ||
Description | string | Yes |
equipment_status
Table for Status. Contains reference data for Status entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Status | string |
equipment_reservation
This table contains all the reservations for the module
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
EquipmentId | integer | ||
UserId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
StartDate | date | ||
StartTime | time | ||
EndDate | date | ||
EndTime | time | ||
Title | string | Yes | |
Description | string | Yes | |
IsRecurring | boolean | Yes | |
IsBlockReservation | boolean | Yes | |
IsTechnicalReservation | boolean | Yes | |
ProjectId | boolean | Yes |
equipment_logging_parameter
Equipment Parameter information. Contains data related to equipment and their Parameter.
Column | Type | Nullable | Description |
|---|---|---|---|
ParameterId | integer | ||
Name | string | Yes | |
ParameterId | integer | ||
UnitId | integer | Yes |
equipment_module_external_activity
Equipment module external activity
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ModuleId | integer | The module id | |
UserId | integer | The user id | |
CreationDate | date | The date the activity was created | |
CreationTime | time | The time the activity was created | |
TypeId | integer | The external activity type id | |
Account | string | Yes | The account used to log the activity |
Activity | string | The activity performed | |
Comment | string | Yes | The comment for the activity |
equipment_module_external_activity_type
Equipment module External activity type
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Type | string | ||
Description | string | Yes | Description of the external activity type |
IsActive | boolean | Yes | Boolean flag whether the external activity type is due to activity or not |
Room Management
room
Table for Room. Contains reference data for Room entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Code | string | Yes | |
Phone | string | Yes | |
Department | string | Yes | |
Purpose | string | Yes | |
Tags | string | Yes | |
OpeningHours | string | Yes | |
AfterOfficeHours | string | Yes | |
BuildingId | integer | Yes | |
LocationDetails | string | Yes | |
Description | string | Yes |
site
Table for Site. Contains reference data for Site entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Code | string | Yes |
building
Table for Building. Contains reference data for Building entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Code | string | Yes | |
SiteId | integer | Yes |
room_role
Table for Role. Contains reference data for Role entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Title | string | Yes | |
Description | string | Yes |
room_room_role
Room Role information. Contains data related to rooms and their Role.
Column | Type | Nullable | Description |
|---|---|---|---|
RoomId | integer | ||
RoleId | integer | ||
UserId | integer | ||
InApprovalFlow | boolean | Yes | |
IsActive | boolean | Yes | |
Comment | string | Yes |
room_room_user
Room User information. Contains data related to rooms and their User.
Column | Type | Nullable | Description |
|---|---|---|---|
RoomId | integer | ||
UserId | integer | ||
IsActive | boolean | Yes | |
Status | string | Yes | Status of the user in the room |
Comment | string | Yes |
Process Management
process
Table for Process. Contains reference data for Process entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Number | integer | Yes |
process_category
Table for Category. Contains reference data for Category entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Number | integer | Yes |
process_type
Table for Type. Contains reference data for Type entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes |
process_type_category
Table for process type category. Contains relationship between process types and process categories
Column | Type | Nullable | Description |
|---|---|---|---|
TypeId | integer | Fk to process type | |
CategoryId | integer | Fk to process category |
process_module
Process Module information. Contains data related to processes and their Module.
Column | Type | Nullable | Description |
|---|---|---|---|
TypeId | integer | ||
ProcessId | integer | ||
ModuleId | integer |
Run Management
run
Table for Run. Contains reference data for Run entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Motivation | string | Yes | |
RunTypeId | integer |
run_role
Table for Role. Contains reference data for Role entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Title | string | Yes | |
Description | string | Yes |
run_type
Table for RunType. Contains reference data for RunType entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Type | string | Yes |
run_run_role
Run Role information. Contains data related to runs and their Role.
Column | Type | Nullable | Description |
|---|---|---|---|
RunId | integer | ||
RoleId | integer | ||
UserId | integer | ||
IsActive | boolean | Yes | |
Comment | string | Yes |
run_step
Run Step information. Contains data related to runs and their Step.
Column | Type | Nullable | Description |
|---|---|---|---|
StepId | integer | ||
Sequence | integer | ||
RunId | integer | ||
StartDate | date | Yes | |
StartTime | time | Yes | |
FinishDate | date | Yes | |
FinishTime | time | Yes | |
FinishDate | date | Yes | |
FinishTime | time | Yes | |
UserId | integer | ||
UserStartId | integer | Yes | |
UserFinishId | integer | Yes | |
SubSteps | integer | ||
HasParts | boolean | Yes | |
HasRequirement | boolean | Yes | |
HasRecipe | boolean | Yes | |
ProcessModuleId | integer | ||
RecipeVersionId | integer | Yes | |
ProcessName | string | Yes | |
TemplateStepId | integer | Yes | |
MonitorStepId | integer | Yes |
run_step_parameter
Run Parameter information. Contains data related to runs and their Parameter.
Column | Type | Nullable | Description |
|---|---|---|---|
RunStepParameterId | integer | ||
StepId | integer | ||
ParameterId | integer | ||
UnitId | integer | Yes | |
Sequence | integer |
run_step_parameter_value
Run Value information. Contains data related to runs and their Value.
Column | Type | Nullable | Description |
|---|---|---|---|
RunStepParameterId | integer | ||
Value | string | Yes | |
Sequence | integer |
run_measurement
Run Measurement information. Contains data related to runs and their Measurement.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Title | string | ||
Definition | string | ||
Method | string | ||
StepId | integer | ||
RequirementId | integer | Yes |
run_measurement_result
Run Result information. Contains data related to runs and their Result.
Column | Type | Nullable | Description |
|---|---|---|---|
ResultId | integer | ||
MeasurementId | integer | ||
UUID | string |
run_entity_measurement_result_value
Run Value information. Contains data related to runs and their Value.
Column | Type | Nullable | Description |
|---|---|---|---|
ResultId | integer | ||
FloatValue | float | Yes | |
StringValue | string | Yes | |
IntValue | integer | Yes | |
StdDev | float | Yes | |
Unit | string | Yes |
run_run_priority
Run Priority information. Contains data related to runs and their Priority.
Column | Type | Nullable | Description |
|---|---|---|---|
RunId | integer | ||
PriorityId | integer | ||
UserId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
UpdateDate | date | Yes | |
UpdateTime | time | Yes | |
Description | string | Yes | |
IsActive | boolean | Yes |
run_priority
Table for Priority. Contains reference data for Priority entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Code | string | Yes | |
Description | string | Yes |
run_changelog
Run Changelog information. Contains data related to runs and their Changelog.
Column | Type | Nullable | Description |
|---|---|---|---|
RunId | integer | ||
UserId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
Type | string | ||
Source | string | ||
Message | string | Yes |
run_run_hold_code
Run HoldCode information. Contains data related to runs and their HoldCode.
Column | Type | Nullable | Description |
|---|---|---|---|
RunId | integer | ||
HoldCodeId | integer | ||
UserId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
UpdateDate | date | Yes | |
UpdateTime | time | Yes | |
Description | string | Yes | |
IsActive | boolean | Yes |
run_hold_code
Table for HoldCode. Contains reference data for HoldCode entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Code | string | Yes | |
Description | string | Yes |
Scheduler
scheduler_job
Jobs created on equipment using the scheduler system
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
UserId | integer | ||
StatusId | integer | ||
ProgramId | integer | Yes | |
LotId | string | Yes | |
CreationDate | date | ||
CreationTime | time | ||
Description | string | Yes | |
EquipmentFilter | string | Yes |
scheduler_job_status
Table for Scheduler job status. Contains reference data for job status entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Code | string | ||
Text | string |
scheduler_job_queue
A list of all queues (segments) in the scheduler, each job consists of one or more queues.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Identifier | string | ||
JobId | integer | ||
EquipmentId | integer | ||
CreationDate | date | ||
CreationTime | time | ||
StartDate | date | ||
StartTime | time | ||
EndDate | date | ||
EndTime | time | ||
StartedDate | date | Yes | |
StartedTime | time | Yes | |
FinishedDate | date | Yes | |
FinishedTime | time | Yes | |
EquipmentReservationId | integer | Yes |
scheduler_job_equipment
A job can have multiple equipment, this table gives an overview of all selected equipment per job.
Column | Type | Nullable | Description |
|---|---|---|---|
JobId | integer | ||
EquipmentId | integer | ||
Include | boolean | Yes | If the equipment is included in the job this value is set |
Motivation | string | Yes | Motivation for excluding the equipment in the job |
Service Management
service
Table for Service. Contains transactional data related to services.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
CreationDate | date | ||
CreationTime | time | ||
ServiceTypeId | integer | Yes | Foreign key to the service type |
EquipmentId | integer | Yes | Foreign key to the equipment |
DepartmentId | integer | Yes | Foreign key to the department |
TeamId | integer | Yes | Foreign key to the team |
ServiceValidYears | integer | Yes | Service Valid Period in years |
MinutesNeededForServiceColumn | integer | Yes | Minutes needed for service |
service_type
Service ServiceType information. Contains data related to services and their ServiceType.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string |
service_event
Service Event information. Contains data related to services and their Event.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
CreationDate | date | ||
CreationTime | time | ||
ServiceId | integer | ||
PlannedDate | date | Yes | |
PlannedTime | time | Yes | |
ExecutedDate | date | Yes | |
ExecutedTime | time | Yes | |
PerformedBy | string | Yes | |
PurchaseOrderNumber | string | Yes | |
ExternalCompanyId | integer | Yes | |
PlaceId | integer | Yes |
service_team
Table for Team. Contains reference data for Team entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes |
service_event_place
Service Place information. Contains data related to services and their Place.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
IsExternal | boolean | Yes | Is external |
CreationDate | date | ||
CreationTime | time |
Reference Data
date
Table for Date. Contains reference data for Date entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Date | date | ||
WeekNumber | integer | ||
DayNumberInWeek | integer | ||
DayNumberInMonth | integer | ||
DayNumberInYear | integer | ||
DayName | string | ||
MonthNumber | integer | ||
MonthName | string | ||
MonthNameShort | string | ||
CalendarQuarter | string | ||
CalendarYear | integer |
vendor
Table for Vendor. Contains reference data for Vendor entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string |
program
Table for Program. Contains reference data for Program entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
Status | string | ||
Private | string | ||
IsActive | boolean | Yes | |
IsPrivate | boolean | Yes |
project
Table for Project. Contains reference data for Project entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
Wbs | string | Yes | |
Status | string | ||
Private | string | ||
IsActive | boolean | Yes | |
IsPrivate | boolean | Yes |
department
Table for Department. Contains reference data for Department entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string |
external_company
Table for ExternalCompany. Contains reference data for ExternalCompany entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string |