# GreenPowerMonitor schema ERD

Table and field reference for the Fivetran GreenPowerMonitor connector.

## Table & Field Reference

### plant_parameter

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| plant_id | Unknown | FK |
| key | Unknown |  |
| value | Unknown |  |

### plant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| alarm_color | Unknown |  |
| alert_icon | Unknown |  |
| name | Unknown |  |
| unique_id | Unknown |  |

### element

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| plant_id | Unknown | FK |
| name | Unknown |  |
| type | Unknown |  |
| type_string | Unknown |  |
| unique_id | Unknown |  |

### datalist_year

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| data_source_id | Unknown | FK |
| value | Unknown |  |

### element_parameter

| Column | Type | Keys |
| --- | --- | --- |
| data_source_id | Unknown | PK, FK |
| element_id | Unknown | PK, FK |
| component_id | Unknown |  |
| fixed_type | Unknown |  |
| name | Unknown |  |
| portal_id | Unknown |  |
| sub_type | Unknown |  |

### element_description

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| element_id | Unknown | FK |
| key | Unknown |  |
| value | Unknown |  |

### datasource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| plant_id | Unknown | FK |
| data_source_name | Unknown |  |
| element_id | Unknown |  |
| unit | Unknown |  |

### datalist

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| data_source_id | Unknown | FK |
| value | Unknown |  |

### kpi_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| data_source_id | Unknown | FK |
| plant_id | Unknown | FK |
| fixed_type | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### datalist_month

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| data_source_id | Unknown | FK |
| value | Unknown |  |

## Relationships

- plant_parameter(plant_id) → plant(id)
- element(parent_id) → element(id)
- element(plant_id) → plant(id)
- datalist_year(data_source_id) → datasource(id)
- element_parameter(data_source_id) → datasource(id)
- element_parameter(element_id) → element(id)
- element_description(element_id) → element(id)
- datasource(id) → element(id)
- datasource(plant_id) → plant(id)
- datalist(data_source_id) → datasource(id)
- kpi_value(data_source_id) → datasource(id)
- kpi_value(plant_id) → plant(id)
- datalist_month(data_source_id) → datasource(id)