# Pingdom schema ERD

Table and field reference for the Fivetran Pingdom connector.

## Table & Field Reference

### maintenance_id

| Column | Type | Keys |
| --- | --- | --- |
| maintenance_id | Long | PK |
| checks_id | Long | PK, FK |
| id | Unknown | FK |

### checks

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created | Instant |  |
| hostname | String |  |
| ipv_6 | Boolean |  |
| last_down_end | Instant |  |
| last_down_start | Instant |  |
| last_error_time | Instant |  |
| last_response_time | Long |  |
| last_test_time | Instant |  |
| maintenance_ids | Json |  |
| name | String |  |
| resolution | Long |  |
| status | String |  |
| type | String |  |
| verify_certificate | Boolean |  |

### sms

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Long | PK, FK |
| country_code | String |  |
| number | String |  |
| provider | String |  |
| severity | String |  |

### email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Long | PK, FK |
| address | String |  |
| severity | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| member_id | Unknown | FK |
| name | String |  |
| owner | Boolean |  |
| paused | Boolean |  |
| type | String |  |

### check_description

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK, FK |
| created | Instant |  |
| custom_message | String |  |
| hostname | String |  |
| integration_ids | Json |  |
| ipv_6 | Boolean |  |
| last_down_end | Instant |  |
| last_down_start | Instant |  |
| last_error_time | Instant |  |
| last_response_time | Long |  |
| last_test_time | Instant |  |
| name | String |  |
| notify_again_every | Long |  |
| notify_when_backup | Boolean |  |
| probe_filters | Json |  |
| resolution | Long |  |
| responsetime_threshold | Long |  |
| send_notification_when_down | Long |  |
| ssl_down_days_before | Long |  |
| status | String |  |
| type_http_encryption | Boolean |  |
| type_http_password | String |  |
| type_http_port | Long |  |
| type_http_post_data | String |  |
| type_http_should_contain | String |  |
| type_http_should_not_contain | String |  |
| type_http_url | String |  |
| type_http_user_agent | String |  |
| type_http_username | String |  |
| type_http_verify_certificate | Boolean |  |
| userids | Json |  |

### analysis

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| checks_id | Long | PK, FK |
| time_confirm_test | Instant |  |
| time_first_test | Instant |  |

### maintenance_occurrence

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| maintenance_id | Long | FK |
| duration | Long |  |
| duration_unit | String |  |
| from_date | Instant |  |
| to_date | Instant |  |

### state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_status_check_id | Long | PK, FK |
| error_in_step | Long |  |
| from_date | Instant |  |
| message | String |  |
| status | String |  |
| to_date | Instant |  |

### transaction_status

| Column | Type | Keys |
| --- | --- | --- |
| check_id | Long | PK, FK |
| name | String |  |

### probe

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| city | String |  |
| country | String |  |
| country_iso | String |  |
| hostname | String |  |
| ip | String |  |
| ipv_6 | String |  |
| name | String |  |
| region | String |  |

### uptime

| Column | Type | Keys |
| --- | --- | --- |
| uptime | Long | PK |
| maintenance_id | Long | PK, FK |

### tms

| Column | Type | Keys |
| --- | --- | --- |
| tms | Long | PK |
| maintenance_id | Long | PK, FK |

### maintenance

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| day_of_week_in_month | Long |  |
| description | String |  |
| duration | Long |  |
| duration_unit | String |  |
| effective_to | Instant |  |
| from_date | Instant |  |
| recurrence_type | String |  |
| repeat_every | Long |  |
| to_date | Instant |  |

### region

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| country_id | Long | FK |
| date_time_format_id | Long | FK |
| number_format_id | Long | FK |
| timezone_id | Long | FK |
| description | String |  |

### time_zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| description | String |  |
| offsets | Long |  |
| timezone | String |  |

### date_time_format

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| dateformat | String |  |
| description | String |  |
| timeformat | String |  |

### number_format

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| description | String |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| iso | String |  |
| name | String |  |

### phone_code

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| country_id | Long | PK, FK |
| iso | String |  |
| phone_code | String |  |

### action

| Column | Type | Keys |
| --- | --- | --- |
| time | Instant | PK |
| user_id | Long | PK |
| check_id | Long | PK, FK |
| charged | Boolean |  |
| message_full | String |  |
| message_short | String |  |
| sent_to | String |  |
| status | String |  |
| username | String |  |
| via | String |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| team_id | Long | PK, FK |
| name | String |  |
| type | String |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### result

| Column | Type | Keys |
| --- | --- | --- |
| time | Instant | PK |
| checks_id | Long | PK, FK |
| probe_id | Long | PK, FK |
| response_time | Long |  |
| status | String |  |
| status_desc | String |  |
| status_desc_long | String |  |

## Relationships

- maintenance_id(checks_id) → checks(id)
- maintenance_id(id) → maintenance(id)
- sms(contact_id) → contact(id)
- email(contact_id) → contact(id)
- contact(member_id) → member(id)
- check_description(id) → checks(id)
- analysis(checks_id) → checks(id)
- maintenance_occurrence(maintenance_id) → maintenance(id)
- state(transaction_status_check_id) → transaction_status(check_id)
- transaction_status(check_id) → checks(id)
- uptime(maintenance_id) → maintenance(id)
- tms(maintenance_id) → maintenance(id)
- region(country_id) → country(id)
- region(date_time_format_id) → date_time_format(id)
- region(number_format_id) → number_format(id)
- region(timezone_id) → time_zone(id)
- phone_code(country_id) → country(id)
- action(check_id) → checks(id)
- member(team_id) → team(id)
- result(probe_id) → probe(id)
- result(checks_id) → checks(id)