# Grepsr schema ERD

Table and field reference for the Fivetran Grepsr connector.

## Table & Field Reference

### project_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| name | String |  |
| service_id | Unknown |  |
| type | String |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| description | String |  |
| name | String |  |
| status | String |  |

### dataset_column

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| dataset_project_report_history_id | Unknown | PK, FK |
| dataset_project_report_id | Unknown | PK, FK |

### dataset

| Column | Type | Keys |
| --- | --- | --- |
| project_report_history_id | Unknown | PK, FK |
| project_report_id | Unknown | PK, FK |
| name | Unknown |  |
| rows | Json |  |

### report_stat_column

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| report_stat_id | Unknown | PK, FK |

### report_stat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_report_history_id | Unknown | FK |
| project_report_id | Unknown | FK |
| name | Unknown |  |
| report_name | Unknown |  |

### schedule_parameter

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| schedule_id | Unknown | FK |
| name | Unknown |  |
| value | Unknown |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_report_id | Unknown | FK |
| end_date | Unknown |  |
| next_update | Unknown |  |
| start_date | Unknown |  |

### project_report_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| project_report_id | Unknown | FK |
| bandwidth_download | Unknown |  |
| bandwidth_upload | Unknown |  |
| created | Unknown |  |
| csv_file | String |  |
| item_count | Unknown |  |
| modified | Unknown |  |
| request_count | Unknown |  |
| run_ended | Unknown |  |
| run_started | Unknown |  |
| status | String |  |

### report_parameter

| Column | Type | Keys |
| --- | --- | --- |
| service_id | Unknown | PK |
| project_report_id | Unknown | FK |
| description | String |  |
| label | String |  |
| name | String |  |

## Relationships

- project_report(project_id) → project(id)
- dataset_column(dataset_project_report_id) → dataset(project_report_id)
- dataset_column(dataset_project_report_history_id) → dataset(project_report_history_id)
- dataset(project_report_id) → project_report(id)
- dataset(project_report_history_id) → project_report_history(id)
- report_stat_column(report_stat_id) → report_stat(id)
- report_stat(project_report_id) → project_report(id)
- report_stat(project_report_history_id) → project_report_history(id)
- schedule_parameter(schedule_id) → schedule(id)
- schedule(project_report_id) → project_report(id)
- project_report_history(project_id) → project(id)
- project_report_history(project_report_id) → project_report(id)
- report_parameter(project_report_id) → project_report(id)