Public.location specific status changes (table)

From dbscript Online Help
Revision as of 15:43, 7 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table public.location_specific_status_changes


Column Data Type Nullable Default PK Index
id integer not null location_specific_status_changes_pkey
locationmonitorid integer not null location_specific_status_changes_locationmonitorid_ifserviceidlocation_specific_status_changes_locationmonitoridlocation_specific_status_changes_locationmonitorid_loc_if_time
ifserviceid integer not null location_specific_status_changes_locationmonitorid_ifserviceidlocation_specific_status_changes_ifserviceidlocation_specific_status_changes_locationmonitorid_loc_if_time
statuscode integer not null
statustime timestamp with time zone not null location_specific_status_changes_statustimelocation_specific_status_changes_locationmonitorid_loc_if_time
statusreason varchar(255) null
responsetime double precision null


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