Difference between revisions of "Public.location specific status changes (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.location_specific_status_changes |- |} {| border="1" cellpadding="5" ...)
 
Line 20: Line 20:
 
|-
 
|-
 
| id
 
| id
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 27: Line 27:
 
|-
 
|-
 
| locationmonitorid
 
| locationmonitorid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 34: Line 34:
 
|-
 
|-
 
| ifserviceid
 
| ifserviceid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 41: Line 41:
 
|-
 
|-
 
| statuscode
 
| statuscode
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
Line 48: Line 48:
 
|-
 
|-
 
| statustime
 
| statustime
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
Line 55: Line 55:
 
|-
 
|-
 
| statusreason
 
| statusreason
|  
+
| varchar(255)
 
| null
 
| null
 
|  
 
|  
Line 62: Line 62:
 
|-
 
|-
 
| responsetime
 
| responsetime
|  
+
| double precision
 
| null
 
| null
 
|  
 
|  

Revision as of 14:43, 7 August 2009

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