Difference between revisions of "Public.vlan (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 23: Line 23:
 
| not null
 
| not null
 
|  
 
|  
| pk_vlan
 
 
|  
 
|  
 
|-
 
|-
Line 30: Line 29:
 
| not null
 
| not null
 
|  
 
|  
| pk_vlan
 
 
|  
 
|  
 
|-
 
|-
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
| vlan_vlanname_idx
 
 
|-
 
|-
 
| vlantype
 
| vlantype
 
| integer
 
| integer
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| integer
 
| integer
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| char(1)
 
| char(1)
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| timestamp without time zone
 
| timestamp without time zone
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_vlan
 +
| nodeid, vlanid
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| vlan_vlanname_idx
 +
|
 +
| vlanname
 +
|}
  
 +
=== 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:33, 11 February 2010

wikibot

Table public.vlan


Columns

Column Data Type Nullable Default Description
nodeid integer not null
vlanid integer not null
vlanname varchar(64) not null
vlantype integer null
vlanstatus integer null
status char(1) not null
lastpolltime timestamp without time zone not null

Primary Key

Primary Key Columns
pk_vlan nodeid, vlanid

Indexes

Index Type Columns
vlan_vlanname_idx vlanname

Foreign Keys

Relation Column Referenced Column
public.node nodeid nodeid