-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadd_grid_consumer.sql
More file actions
10 lines (10 loc) · 1.98 KB
/
Copy pathadd_grid_consumer.sql
File metadata and controls
10 lines (10 loc) · 1.98 KB
1
2
3
4
5
6
7
8
9
10
INSERT INTO
public.asset_types (id, name, description, attributes, created_at, updated_at, normalized_name) VALUES ('d1e89c62-f79a-4e66-9c3f-c1f0d0b59b7d', 'Grid', 'Power grid connection point', '{voltage: {type: number, unit: V, label: Voltage}, frequency: {type: number, unit: Hz, label: Grid
Frequency}, congestion_level: {type: select, label: Congestion
Level, options: [low, medium, high]}, power_quality: {type: number, unit: %, label: Power
Quality}, grid_load: {type: number, unit: %, label: Grid
Load}}', '2025-01-09 17:19:31.570042+00', '2025-01-09 17:19:31.570042+00', 'grid'), ('e2f9ad73-g8ab-5f77-ad16-d2e1c1a60c8e', 'Consumer', 'Power consumption endpoint', '{power_consumption: {type: number, unit: kW, label: Power
Consumption}, peak_demand: {type: number, unit: kW, label: Peak
Demand}, load_factor: {type: number, unit: %, label: Load
Factor}, power_factor: {type: number, unit: %, label: Power
Factor}}', '2025-01-09 17:19:31.570042+00', '2025-01-09 17:19:31.570042+00', 'consumer');