Pingdom

Explore the interactive ERD

Table & Field Reference

maintenance_id

Column	Type	Keys
`maintenance_id`	Long	PK
`checks_id`	Long	PKFK
`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	PKFK
`country_code`	String
`number`	String
`provider`	String
`severity`	String

email

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`error_in_step`	Long
`from_date`	Instant
`message`	String
`status`	String
`to_date`	Instant

transaction_status

Column	Type	Keys
`check_id`	Long	PKFK
`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	PKFK

tms

Column	Type	Keys
`tms`	Long	PK
`maintenance_id`	Long	PKFK

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	PKFK
`iso`	String
`phone_code`	String

action

Column	Type	Keys
`time`	Instant	PK
`user_id`	Long	PK
`check_id`	Long	PKFK
`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	PKFK
`name`	String
`type`	String

team

Column	Type	Keys
`id`	Long	PK
`name`	String

result

Column	Type	Keys
`time`	Instant	PK
`checks_id`	Long	PKFK
`probe_id`	Long	PKFK
`response_time`	Long
`status`	String
`status_desc`	String
`status_desc_long`	String