Difference between revisions of "Public.location monitors (table)"

From dbscript Online Help
Jump to: navigation, search
Line 52: Line 52:
 
|}
 
|}
  
=== Detail Tables ===
+
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
| '''Detail Table
+
| '''Relation
 
| '''Column
 
| '''Column
| '''Referencing Column
+
| '''Referenced Column
  
 
|- valign="top"
 
|- valign="top"
| [[public.location_monitor_details_(table)|public.location_monitor_details]]
+
| [[public.location_monitors_(table)|public.location_monitors]]
 +
| locationmonitorid
 
| id
 
| id
 +
|- valign="top"
 +
| [[public.location_monitors_(table)|public.location_monitors]]
 
| locationmonitorid
 
| locationmonitorid
|- valign="top"
 
| [[public.location_specific_status_changes_(table)|public.location_specific_status_changes]]
 
 
| id
 
| id
| locationmonitorid
 
 
|}
 
|}

Revision as of 11:09, 27 August 2011

wikibot

Table public.location_monitors

Columns

Column Data Type Nullable Default Description
id integer not null
status varchar(31) not null
lastcheckintime timestamp with time zone null
definitionname varchar(31) not null

Primary Key

Primary Key Columns
location_monitors_pkey id

Foreign Keys

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