GreenPowerMonitor
Explore the interactive ERD
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 | PKFK |
element_id | Unknown | PKFK |
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 | PKFK |
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 | |
