Skip to content
Teleport

Migrating from version 1? Use the migration script.

CREATE TABLE `teleport_solar_power_flash` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `teleport_hash_id` varchar(32) NOT NULL, -- uniquely identifies the teleport device
  `asset_identifier` varchar(128) NOT NULL, -- globally unique identifier of the asset, when available the brand and serial number of the asset
  `attempt` int unsigned NOT NULL, -- 0-indexed delivery attempt
  `active_power` decimal(23,3) DEFAULT NULL, -- in W
  `available_active_power` decimal(23,3) DEFAULT NULL, -- in W, can be null. Always null if no pyranometer or irradiance sensor is installed
  `setpoints_confirmed_active_power_limit_percentage` decimal(4, 1) DEFAULT NULL, -- in %
  `setpoints_confirmed_active_power_limit` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_confirmed_reactive_power_reactive_power` decimal(23, 3) DEFAULT NULL, -- setpoint for "fixedReactivePower" mode, in var.
  `setpoints_confirmed_reactive_power_power_factor` decimal(5, 4) DEFAULT NULL, -- setpoint for "fixedPowerFactor" mode, unitless.
  `setpoints_confirmed_reactive_power_mode` varchar(32) DEFAULT NULL, -- reactive power control mode, either "fixedReactivePower" or "fixedPowerFactor".
  `setpoints_desired_active_power_limit_cloud` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_active_control` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_grid_operator` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_modbus_server` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_afrr_delta` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_afrr_padding` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_active_power_limit_afrr_reference` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_desired_reactive_power_cloud_reactive_power` decimal(23, 3) DEFAULT NULL, -- setpoint for "fixedReactivePower" mode, in var.
  `setpoints_desired_reactive_power_cloud_power_factor` decimal(5, 4) DEFAULT NULL, -- setpoint for "fixedPowerFactor" mode, unitless.
  `setpoints_desired_reactive_power_cloud_mode` varchar(32) DEFAULT NULL, -- reactive power control mode, either "fixedReactivePower" or "fixedPowerFactor".
  `setpoints_desired_reactive_power_grid_operator_reactive_power` decimal(23, 3) DEFAULT NULL, -- setpoint for "fixedReactivePower" mode, in var.
  `setpoints_desired_reactive_power_grid_operator_power_factor` decimal(5, 4) DEFAULT NULL, -- setpoint for "fixedPowerFactor" mode, unitless.
  `setpoints_desired_reactive_power_grid_operator_mode` varchar(32) DEFAULT NULL, -- reactive power control mode, either "fixedReactivePower" or "fixedPowerFactor".
  `setpoints_desired_reactive_power_active_control_reactive_power` decimal(23, 3) DEFAULT NULL, -- setpoint for "fixedReactivePower" mode, in var.
  `setpoints_desired_reactive_power_active_control_power_factor` decimal(5, 4) DEFAULT NULL, -- setpoint for "fixedPowerFactor" mode, unitless.
  `setpoints_desired_reactive_power_active_control_mode` varchar(32) DEFAULT NULL, -- reactive power control mode, either "fixedReactivePower" or "fixedPowerFactor".
  `setpoints_effective_active_power_limit` decimal(23, 3) DEFAULT NULL, -- in W
  `setpoints_effective_reactive_power_reactive_power` decimal(23, 3) DEFAULT NULL, -- setpoint for "fixedReactivePower" mode, in var.
  `setpoints_effective_reactive_power_power_factor` decimal(5, 4) DEFAULT NULL, -- setpoint for "fixedPowerFactor" mode, unitless.
  `setpoints_effective_reactive_power_mode` varchar(32) DEFAULT NULL, -- reactive power control mode, either "fixedReactivePower" or "fixedPowerFactor".
  `measured_at` datetime(3) NOT NULL, -- when read-out started, in UTC
  `created_at` datetime NOT NULL, -- when row was written, in UTC
  PRIMARY KEY (`id`),
  KEY `teleport` (`teleport_hash_id`,`created_at`),
  UNIQUE KEY `teleport_asset` (`teleport_hash_id`,`asset_identifier`,`measured_at`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='{"version":2}';