sg.md

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.