RdsDiagram
TyreModel
id: INTEGER
EnterpriseID: INTEGER
ManufacturerID: INTEGER
ModelKindID: INTEGER
SizeTypeID: INTEGER
MileageNorm: INTEGER
ColdPressureNom: DECIMAL(2,1)
TemperatureMax: INTEGER
TreadDepthNom: INTEGER
TreadDepthMin: INTEGER
Cost: DECIMAL(10,2)
TKMHNom: INTEGER
IsRemoved: BOOLEAN
TyreManufacturer
id: INTEGER
EnterpriseID: INTEGER
Name: VARCHAR(128)
IsRemoved: BINARY(0)
TyreSizeType
id: INTEGER
EnterpriseID: INTEGER
Width: INTEGER
Height: INTEGER
Diameter: INTEGER
IsRemoved: BINARY(0)
TyreObjectModel
id: INTEGER
ObjectModelID: INTEGER
WheelFormulaID: INTEGER
SizeTypeID: INTEGER
IsRemoved: BINARY(0)
WeightCapacity: INTEGER
VolumeCapacity: INTEGER
Weight: INTEGER
AxisEmpty: INTEGER
AxisLoad: INTEGER
TyreObject
id: INTEGER
ObjectID: INTEGER
ObjectModelID: INTEGER
ExtenalId: INTEGER
IsRemoved: BINARY(0)
Tyre
id: INTEGER
SerialNumber: VARCHAR(30)
ModelID: INTEGER
ManufacturedAt: DATE
InitialMilleage: INTEGER
ExploitationedAt: DATE
IsDecomission: BOOLEAN
DecomissionedAt: DATE
IsRemoved: BOOLEAN
TyreAction
id: INTEGER
TyreID: INTEGER
ActionType: INTEGER
ActionAt: DATE
ObjectID: INTEGER
WheelPositionID: INTEGER
StockId: INTEGER
StockLine: INTEGER
StockTier: INTEGER
Creator_EmployeeID: INTEGER
Updater_EmployeeID: INTEGER
Remover_EmployeeID: INTEGER
Comment: VARCHAR(255)
IsRemoved: BINARY(0)
TyreStock
ZoneID: INTEGER
EnterpriseID: INTEGER
Name: VARCHAR(64)
TyreEmployeeConfirmation
id: INTEGER
TyreID: INTEGER
ConfirmationType: INTEGER
ConfirmedAt: INTEGER
Creator_EmployeeID: INTEGER
Updater_EmployeeID: INTEGER
Remover_EmployeeID: INTEGER
Comment: VARCHAR(255)
IsRemoved: BINARY(0)
TyreDamageType
id: INTEGER
EnterpriseID: INTEGER
Name: VARCHAR(64)
Repairability: BOOLEAN
TyreInspection
id: INTEGER
TyreID: INTEGER
DamageTypeID: INTEGER
InspectedAt: DATE
DamageSize: INTEGER
Comment: VARCHAR(255)
Creator_EmployeeID: INTEGER
Updater_EmployeeID: INTEGER
Remover_EmployeeID: INTEGER
IsRemoved: BOOLEAN
TyreRepairDetail
id: INTEGER
ActionID: INTEGER
DamageTypeID: INTEGER
Comment: VARCHAR(255)
IsRemoved: BINARY(0)
TyreModuleParameter
Id: INTEGER
EnterpriseID: INTEGER
Parameter: VARCHAR(64)
Name: VARCHAR(255)
Value: VARCHAR(0)
ValueType: INTEGER
Unit: VARCHAR(32)
TyreWheelFormula
ID: INTEGER
Name: VARCHAR(64)
SchemePath?: INTEGER
IsRemoved: BINARY(0)
TyreWheelPosition
ID: INTEGER
WheelFormulaID: INTEGER
AxelNum: INTEGER
PositionNum: INTEGER
FullName: VARCHAR(100)
ShortName: VARCHAR(5)
SchemePosX: INTEGER
SchemePosY: INTEGER
IsRemoved: BINARY(0)
Module
Id: INTEGER
Name: INTEGER
ModuleObject
Id: INTEGER
ObjectID: INTEGER
ModuleID: INTEGER
EnterpriseModule
Id: INTEGER
EnterpriseID: INTEGER
ModuleID: INTEGER
TyreObjectShiftMileage
id: INTEGER
ObjectID: INTEGER
ShiftID: INTEGER
Day: DATE
Mileage: INTEGER
TyreTreadMeasurement
ID: INTEGER
TyreID: INTEGER
MeasuredAt: DATE
Out1Measure: INTEGER
Out2Measure: INTEGER
In1Measure: INTEGER
In2Measure: INTEGER
Creator_EmployeeID: INTEGER
Updater_EmployeeID: INTEGER
Remover_EmployeeID: INTEGER
IsRemoved: BINARY(0)
Zone
id: INTEGER
EnterpriseID: INTEGER
Name: VARCHAR(120)
Zone: INTEGER
ZoneObjectState
ObjectID: INTEGER
Zone: INTEGER
StartedAt: DATE
Employee
id: INTEGER
Name: INTEGER
SensorArchive
Id: INTEGER
SENSORID: INTEGER
objectid: INTEGER
TIME: INTEGER
Value: INTEGER
lat: INTEGER
lon: INTEGER
speed: INTEGER
height: INTEGER
course: INTEGER
AreaID: INTEGER
Sensor
Id: INTEGER
TyreObjectTransition
id: INTEGER
ObjectID: INTEGER
StartAt: DATE
EndAt: DATE
Mileage: INTEGER
TyreObectTrip
id: INTEGER
ObjectID: INTEGER
StartAt: INTEGER
EndAt: INTEGER
Weight: INTEGER
LoadedMileage: INTEGER
DeltaHeight: INTEGER
ShovName: VARCHAR(30)
UnloadName: VARCHAR(30)
TyreShiftViolation
TyreID: INTEGER
ShiftID: INTEGER
Day: DATE
Mileage: DECIMAL(3,3)
OverPressureMileage: DECIMAL(3,3)
UnderPressureMileage: DECIMAL(3,3)
OverTKMHMileage: DECIMAL(3,3)
OverloadMileage: DECIMAL(3,3)
OverSpeedMileage: DECIMAL(3,3)
TyreInspectionPhoto
id: INTEGER
InspectionID: INTEGER
Photo: INTEGER
TyreRepairPhoto
id: INTEGER
RepairDetailID: INTEGER
Photo: INTEGER
SensorAlarm
Id: INTEGER
SensorID: INTEGER
ObjectID: INTEGER
Range: INTEGER
StartAt: INTEGER
EndAt: INTEGER
RangeLimit: INTEGER
AVGValue: INTEGER
MaxValue: INTEGER
SensorAlarmState
Id: INTEGER
SensorId: INTEGER
ObjectID: INTEGER
SavedAt: DATE
Range: INTEGER
StartAt: INTEGER
EndAt: INTEGER
RangeLimit: INTEGER
AVGValue: INTEGER
MaxValue: INTEGER
SensorState
Id: INTEGER
SENSORID: INTEGER
objectid: INTEGER
TIME: INTEGER
Value: INTEGER
lat: INTEGER
lon: INTEGER
speed: INTEGER
height: INTEGER
course: INTEGER
AreaID: INTEGER
ChangedAt: INTEGER
TyreModelKind
id: INTEGER
EnterpriseID: INTEGER
ManufacturerID: INTEGER
Name: VARCHAR(128)
IsRemoved: BINARY(0)