Public.location specific status changes (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Foreign Keys

wikibot

Table

public.location_specific_status_changes

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null
locationmonitorid	integer	not null
ifserviceid	integer	not null
statuscode	integer	not null
statustime	timestamp with time zone	not null
statusreason	varchar(255)	null
responsetime	double precision	null

Primary Key

Primary Key	Columns
location_specific_status_changes_pkey	id

Indexes

Index	Type	Columns
location_specific_status_changes_statustime		statustime
location_specific_status_changes_locationmonitorid_ifserviceid		locationmonitorid, ifserviceid
location_specific_status_changes_locationmonitorid		locationmonitorid
location_specific_status_changes_ifserviceid		ifserviceid
location_specific_status_changes_locationmonitorid_loc_if_time		locationmonitorid, ifserviceid, statustime

Foreign Keys

Relation	Column	Referenced Column
public.ifservices	ifserviceid	id
public.location_monitors	locationmonitorid	id