Export information
This document provides information about the database tables and their structure in the SoloDB system.
Table of Contents
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 profile |
CompanyName | string | Yes | Company name of the user, data fetched from the profile |
Country | string | Yes | Country of the user, data fetched from the profile |
Statute | string | Yes | Statute of the user, data fetched from the profile |
Payroll | string | Yes | Payroll status of the user, data fetched from the profile |
Department | string | Yes | Department of the user, data fetched from the profile |
PersonnelNumber | string | Yes | Personnel number of the user, data fetched from the profile |
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
Table for Equipment. Contains reference data for Equipment entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Grade | string | Yes | |
Name | string | Yes | |
MESName | string | Yes | |
Code | string | Yes | |
SerialNumber | string | Yes | |
GroupId | integer | Yes | |
VendorId | integer | Yes | |
IsActive | boolean | Yes | |
IsActiveInMES | boolean | Yes | |
IsSchedulerEnabled | boolean | Yes | |
IsReservationPossible | boolean | Yes | |
IsDoubleBookingPossible | boolean | Yes | |
IsReservationApprovalRequired | boolean | Yes | |
TrainingOption | string | Yes | |
Ownership | string | ||
AvailableForRental | boolean | Yes | |
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_module_property
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ModuleId | integer | Yes | |
PropertyId | integer | ||
Value | string | Yes | |
ValueArray | string | Yes | |
ValueInteger | integer | Yes |
equipment_property
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Type | string | Yes | |
Property | string | ||
Label | string | ||
Values | string | Yes |
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 | ||
IsBlockReservation | boolean | ||
ReservationType | string | ||
ProjectId | integer | Yes |
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 |
equipment_logging_parameter
Equipment Parameter information. Contains data related to equipment and their Parameter.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
ParameterId | integer | ||
UnitId | integer | Yes |
equipment_group
Table for Group. Contains reference data for Group entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Description | string | Yes |
vendor
Table for Vendor. Contains reference data for Vendor entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string |
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 |
email_message
This table contains all emails sent by the system.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Identifier | string | ||
DateCreated | date | ||
UserId | integer | Yes | |
MailingUserId | integer | Yes | |
TemplateId | integer | Yes | |
SenderId | integer | Yes | |
EmailAddress | string | ||
RecipientName | string | ||
Subject | string | ||
Message | string | ||
AmountOfAttachments | integer | ||
LatestEvent | string | Yes | |
DateLatestEvent | date | Yes | |
MailerId | integer |
program
Table for Program. Contains reference data for Program entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
IsActive | boolean | ||
IsPrivate | boolean |
team
Table for Team. Contains reference data for Team entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
IsActive | boolean | Yes | |
Purpose | string | Yes | Purpose(s) of the team. |
GroupId | integer | Yes | A team can be part of a group. |
group
Table for Group. Contains reference data for Group entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
IsActive | boolean | Yes |
group_user
Table for group users. Contains all users who are or were part of a group.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
GroupId | integer | Fk to group | |
UserId | integer | Fk to user | |
IsActive | boolean | True if the user is active in the group and as user in SoloDB | |
DateCreated | date | Date when the user was added to the group | |
StartDate | date | Yes | Date when group membership started |
EndDate | date | Yes | Date when group membership ended |
group_role
Table for group roles. Contains all roles who are or were part of a group.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
GroupId | integer | Fk to group | |
RoleId | integer | Fk to organisation_role | |
UserId | integer | Fk to user | |
Comment | string | Yes | Comment |
IsActive | boolean | True if the role is active in the group and as role in SoloDB | |
DateCreated | date | Date when the role was added to the group | |
StartDate | date | Yes | Date when group membership started |
EndDate | date | Yes | Date when group membership ended |
organisation_role
Table for organisation roles, each role on a group, team or project has this role
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Title | string | Title of the role | |
Description | string | Yes | Description of the role |
IsActive | boolean | Yes | True if the role is active and can be assigned to users |
team_user
Table for team users. Contains all users who are or were part of a team.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
TeamId | integer | Fk to team | |
UserId | integer | Fk to user | |
IsActive | boolean | True if the user is active in the team and as user in SoloDB | |
DateCreated | date | Date when the user was added to the team | |
StartDate | date | Yes | Date when team membership started |
EndDate | date | Yes | Date when team membership ended |
team_role
Table for team roles. Contains all roles who are or were part of a team.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
TeamId | integer | Fk to team | |
RoleId | integer | Fk to organisation_role | |
UserId | integer | Fk to user | |
Comment | string | Yes | Comment |
IsActive | boolean | True if the role is active in the team and as role in SoloDB | |
DateCreated | date | Date when the role was added to the team | |
StartDate | date | Yes | Date when team membership started |
EndDate | date | Yes | Date when team membership ended |
project
Table for Project. Contains reference data for Project entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Abbr | string | ||
Wbs | string | Yes | |
IsActive | boolean | Yes | |
IsPrivate | boolean | Yes |
project_user
Table for project users. Contains all users who are or were part of a project.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ProjectId | integer | Fk to project | |
UserId | integer | Fk to user | |
IsActive | boolean | True if the user is active in the project and as user in SoloDB | |
DateCreated | date | Date when the user was added to the project | |
StartDate | date | Yes | Date when project membership started |
EndDate | date | Yes | Date when project membership ended |
project_role
Table for project roles. Contains all roles who are or were part of a project.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
ProjectId | integer | Fk to project | |
RoleId | integer | Fk to organisation_role | |
UserId | integer | Fk to user | |
Comment | string | Yes | Comment |
IsActive | boolean | True if the role is active in the project and as role in SoloDB | |
DateCreated | date | Date when the role was added to the project | |
StartDate | date | Yes | Date when project membership started |
EndDate | date | Yes | Date when project membership ended |
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 |
baseline
Table for Baseline. Contains reference data for Baseline entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Description | string |
process
Table for Process. Contains reference data for Process entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | Yes | |
Number | integer | Yes | |
CategoryId | integer | Yes | Foreign Key to process_category |
IsActive | boolean | 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 |
process_module_recipe
Process Module Recipe. Contains data related to a recipe.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
Name | string | ||
Description | string | Yes | |
DateCreated | date | ||
LastUpdate | date | Yes | |
ProcessModuleId | integer | Fk to process_module | |
TypeId | integer | Yes | Fk to process_module_recipe_type |
Status | string | Status of the recipe | |
LatestVersion | integer | Yes | Latest version of the recipe, null in case a recipe has no version |
process_module_recipe_version
Process Module Recipe version. Contains data related to a recipe version.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
DateCreated | date | ||
Version | integer | ||
RecipeId | integer | Fk to process_module_recipe | |
Notes | string | Yes |
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 |
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 | |
SkippedDate | date | Yes | |
SkippedTime | 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 | Fk to process_module_recipe_version |
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_part
Table for run parts. Contains reference data for Run part entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
RunId | integer | Reference to run | |
PartId | integer | Internal part id | |
ShortLabel | string | ||
Label | string | Yes | |
BaselineId | integer | Yes | Reference to baseline |
ParentId | integer | Yes | Reference to parent part |
Level | integer |
run_step_part
Table for run step parts. Contains reference data for run step part entities.
Column | Type | Nullable | Description |
|---|---|---|---|
Id | integer | ||
StepId | integer | Reference to step | |
PartId | integer | Reference to part | |
DateCreated | date | Date of creation | |
LastUpdate | date | Yes | Date of last update |
DateStarted | date | Yes | Date of process start |
DateProcessed | date | Yes | Date of process end |
DateFailed | date | Yes | Date of process failure |
Comment | string | Yes | Comment |
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_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_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 |
scheduler_job_status
A job can have multiple statuses, this table gives an overview of all statuses per job.
Column | Type | Nullable | Description |
|---|---|---|---|
JobId | integer | Reference to ID of the job in the fact_job table | |
UserId | integer | Reference to ID of the user in the user table | |
StatusId | integer | Reference to ID of the status in the status table | |
CreationDate | date | ||
CreationTime | time |
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 |
ServiceValidMonths | integer | Yes | Service Valid Period in months |
MinutesNeededForServiceColumn | integer | Yes | Minutes needed for service |
ExternalCompanyId | integer | Yes | |
PlaceId | integer | Yes | |
AutoPlanned | boolean | Yes | Auto planned service |
LatestEventId | integer | Yes | ID of latest event related to the 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_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 |