Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: public location_specific_status_changes (table)

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: 2010/06/25 22:48


wikibot

Tablepublic.location_specific_status_changes

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
locationmonitoridintegernot null  
ifserviceidintegernot null  
statuscodeintegernot null  
statustimetimestamp with time zonenot null  
statusreasonvarchar(255)null  
responsetimedouble precisionnull  

Primary Key

Primary KeyColumns
location_specific_status_changes_pkeyid

Indexes

IndexTypeColumns
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

RelationColumnReferenced Column
public.ifservicesifserviceidid
public.location_monitorslocationmonitoridid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.