# Open Exchange Rates schema ERD

Table and field reference for the Fivetran Open Exchange Rates connector.

## Table & Field Reference

### rate

| Column | Type | Keys |
| --- | --- | --- |
| data_base | Unknown | PK |
| data_timestamps | Instant | PK |
| currency_code | Unknown | PK, FK |
| rate | Unknown |  |

### historical_rate

| Column | Type | Keys |
| --- | --- | --- |
| historical_base | Unknown | PK |
| historical_timestamps | Instant | PK |
| currency_code | Unknown | PK, FK |
| rate | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| name | Unknown |  |

## Relationships

- rate(currency_code) → currency(code)
- historical_rate(currency_code) → currency(code)