Difference between revisions of "Public.pathoutage (table)"

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| 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"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 24: Line 24:
 
|  
 
|  
 
|  
 
|  
| pathoutage_nodeid
 
 
|-
 
|-
 
| criticalpathip
 
| criticalpathip
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
| pathoutage_criticalpathip
 
 
|-
 
|-
 
| criticalpathservicename
 
| criticalpathservicename
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| pathoutage_nodeid
 +
| Unique
 +
| nodeid
 +
|-
 +
| pathoutage_criticalpathip
 +
|
 +
| criticalpathip
 +
|-
 
| pathoutage_criticalpathservicename_idx
 
| pathoutage_criticalpathservicename_idx
 +
|
 +
| criticalpathservicename
 
|}
 
|}
  
 
+
=== 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"

Revision as of 08:32, 11 February 2010

wikibot

Table public.pathoutage


Columns

Column Data Type Nullable Default Description
nodeid integer null
criticalpathip varchar(16) not null
criticalpathservicename varchar(32) null

Indexes

Index Type Columns
pathoutage_nodeid Unique nodeid
pathoutage_criticalpathip criticalpathip
pathoutage_criticalpathservicename_idx criticalpathservicename

Foreign Keys

Relation Column Referenced Column
public.node nodeid nodeid