# Cimis schema ERD

Table and field reference for the Fivetran Cimis connector.

## Table & Field Reference

### station_zipcode

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK, FK |
| station_id | Long | PK, FK |

### station

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| city | String |  |
| connect_date | Unknown |  |
| county | String |  |
| disconnect_date | Unknown |  |
| elevation | Long |  |
| ground_cover | String |  |
| hms_latitude | String |  |
| hms_longitude | String |  |
| is_active | Boolean |  |
| is_eto_station | Boolean |  |
| name | String |  |
| regional_office | String |  |
| siting_desc | String |  |

### spatial_zipcode

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| connect_date | Unknown |  |
| disconnect_date | Unknown |  |
| is_active | Boolean |  |

### data_item_record

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| station_id | Unknown | FK |
| station_zipcode_id | Unknown | FK |
| date | Unknown |  |
| day_air_tmp_avg_qc | Unknown |  |
| day_air_tmp_avg_unit | Unknown |  |
| day_air_tmp_avg_value | Unknown |  |
| day_air_tmp_max_qc | Unknown |  |
| day_air_tmp_max_unit | Unknown |  |
| day_air_tmp_max_value | Unknown |  |
| day_air_tmp_min_qc | Unknown |  |
| day_air_tmp_min_unit | Unknown |  |
| day_air_tmp_min_value | Unknown |  |
| day_asce_eto_qc | Unknown |  |
| day_asce_eto_unit | Unknown |  |
| day_asce_eto_value | Unknown |  |
| day_dew_pnt_qc | Unknown |  |
| day_dew_pnt_unit | Unknown |  |
| day_dew_pnt_value | Unknown |  |
| day_precip_qc | Unknown |  |
| day_precip_unit | Unknown |  |
| day_precip_value | Unknown |  |
| day_rel_hum_avg_qc | Unknown |  |
| day_rel_hum_avg_unit | Unknown |  |
| day_rel_hum_avg_value | Unknown |  |
| day_rel_hum_max_qc | Unknown |  |
| day_rel_hum_max_unit | Unknown |  |
| day_rel_hum_max_value | Unknown |  |
| day_rel_hum_min_qc | Unknown |  |
| day_rel_hum_min_unit | Unknown |  |
| day_rel_hum_min_value | Unknown |  |
| day_soil_tmp_avg_qc | Unknown |  |
| day_soil_tmp_avg_unit | Unknown |  |
| day_soil_tmp_avg_value | Unknown |  |
| day_sol_rad_avg_qc | Unknown |  |
| day_sol_rad_avg_unit | Unknown |  |
| day_sol_rad_avg_value | Unknown |  |
| day_vap_pres_avg_qc | Unknown |  |
| day_vap_pres_avg_unit | Unknown |  |
| day_vap_pres_avg_value | Unknown |  |
| day_wind_run_qc | Unknown |  |
| day_wind_run_unit | Unknown |  |
| day_wind_run_value | Unknown |  |
| day_wind_spd_avg_qc | Unknown |  |
| day_wind_spd_avg_unit | Unknown |  |
| day_wind_spd_avg_value | Unknown |  |
| julian | Unknown |  |
| scope | Unknown |  |
| standard | Unknown |  |

### data_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| station_id | Long | FK |
| name | String |  |
| owner | Unknown |  |
| type | Unknown |  |

## Relationships

- station_zipcode(id) → spatial_zipcode(id)
- station_zipcode(station_id) → station(id)
- data_item_record(station_id) → data_item(station_id)
- data_item_record(station_zipcode_id) → station_zipcode(id)
- data_item(station_id) → station(id)