Skip to content

Instantly share code, notes, and snippets.

@jdvor
Last active October 27, 2020 09:12
Show Gist options
  • Save jdvor/a57745ab333e585bedcd3d38de06f6d6 to your computer and use it in GitHub Desktop.
Save jdvor/a57745ab333e585bedcd3d38de06f6d6 to your computer and use it in GitHub Desktop.
table description
account List of accounts with access to DES Portal and SmartGrid.API.
account__device Just the mapping table between Account and Device tables.
account__permission_role Just the mapping table between Account and PermissionRole tables.
adapter List of device adapters.
alerts Triggered alerts per device.
apikey SmartGrid.Api API keys.
automat_group_internal_beats Cron expressions per group of devices for automat's internal beat.
automat_internal_beats Cron expressions per device for automat's internal beat.
automat_ruleset__device Pairing automat rule sets and devices.
automat_rulesets Automat named rule sets containing list of CLR types derived from AutomatRule.
command_history List of all fired commands.
customer List of customers.
device List of devices connected to the SmartGrid.API.
device_business_data Device business data. Ususally origin of this data is contract.
device_business_data_audit Audit of the table device_business_data.
device_business_data_keys Keys for the table device_business_data.
device_daily_sums Sums of working hours and starts per device and per day.
device_failure List of failures per device.
device_price_calc_tariff_type Device price tariff types.
device_price_data Counted prices (equity and vdt) per device.
device_relation List of relations between devices.
device_snapshot_history List of snapshots per device.
device_yearly_sums Sums of working hours per device and per year.
energy_deal List of energy deals. Flexibility or emergency transfers with 3rd party customers.
market_data Source data for equity calculation.
notification_audit List of notification audits.
notification_rule List of notification rules.
password Account password.
permission Account permissions.
permission_item Account permissions.
permission_role List of permision role.
pricing_rule Pricing rules for invoice price calculation.
pricing_tariff Device pricing tariffs for invoice price calculation.
recommended_action_audit List of recommended actions per device published by SmartGrid.Automat.
runtime_configs Runtime environment configuration.
slack_channel Slack channels properties.
utilization_profile Utilization profile per device and day.
utilization_profile_audit Audit table. Created by trigger on utilization_profile table.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment