Welcome Guest, you are in: <root> • Login

Page History: public location_specific_status_changes (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/25 22:48

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