Public.location specific status changes (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.location_specific_status_changes

Columns[edit]

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[edit]

Primary Key Columns
location_specific_status_changes_pkey id

Indexes[edit]

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

Foreign Keys[edit]

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