public location_specific_status_changes (table)

Modified on 2011/08/27 11:44 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| public.location_specific_status_changes
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| id
| integer
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| locationmonitorid
| integer
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| ifserviceid
| integer
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| statuscode
| integer
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| statustime
| timestamp with time zone
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| statusreason
| varchar(255)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| responsetime
| double precision
| null
| &nbsp;
| &nbsp;
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| location_specific_status_changes_pkey
| id
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| location_specific_status_changes_ifserviceid
| &nbsp;
| ifserviceid
|- valign="top"
| location_specific_status_changes_locationmonitorid
| &nbsp;
| locationmonitorid
|- valign="top"
| location_specific_status_changes_locationmonitorid_ifserviceid
| &nbsp;
| locationmonitorid, ifserviceid
|- valign="top"
| location_specific_status_changes_locationmonitorid_loc_if_time
| &nbsp;
| locationmonitorid, ifserviceid, statustime
|- valign="top"
| location_specific_status_changes_statustime
| &nbsp;
| statustime
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[public ifservices (table)|public.ifservices]]
| ifserviceid
| id
|- valign="top"
| [[public location_monitors (table)|public.location_monitors]]
| locationmonitorid
| id
|}

devio dbscript ScrewTurn Wiki

Navigation¶

public location_specific_status_changes (table)