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

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.element
 
| public.element
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| mapid
 
| mapid
 
| integer
 
| integer
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementid
 
| elementid
 
| integer
 
| integer
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementtype
 
| elementtype
 
| char(1)
 
| char(1)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementlabel
 
| elementlabel
 
| varchar(256)
 
| varchar(256)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementicon
 
| elementicon
 
| varchar(256)
 
| varchar(256)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementx
 
| elementx
 
| integer
 
| integer
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| elementy
 
| elementy
 
| integer
 
| integer
Line 67: Line 65:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_element
 
| pk_element
 
| mapid, elementid, elementtype
 
| mapid, elementid, elementtype
Line 78: Line 76:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| element_mapid_elementid
 
| element_mapid_elementid
 
|  
 
|  
Line 91: Line 89:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[public.map_(table)|public.map]]
 
| [[public.map_(table)|public.map]]
 
| mapid
 
| mapid
 
| mapid
 
| mapid
 
|}
 
|}

Latest revision as of 23:38, 24 June 2010

wikibot[edit]

Table public.element

Columns[edit]

Column Data Type Nullable Default Description
mapid integer not null
elementid integer not null
elementtype char(1) not null
elementlabel varchar(256) not null
elementicon varchar(256) null
elementx integer null
elementy integer null

Primary Key[edit]

Primary Key Columns
pk_element mapid, elementid, elementtype

Indexes[edit]

Index Type Columns
element_mapid_elementid mapid, elementid

Foreign Keys[edit]

Relation Column Referenced Column
public.map mapid mapid