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. |
Last active
October 27, 2020 09:12
-
-
Save jdvor/a57745ab333e585bedcd3d38de06f6d6 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment