Difference between revisions of "Public.element (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_element
+
|  
| element_mapid_elementid
 
 
|-
 
|-
 
| elementid
 
| elementid
Line 30: Line 29:
 
| not null
 
| not null
 
|  
 
|  
| pk_element
+
|  
| element_mapid_elementid
 
 
|-
 
|-
 
| elementtype
 
| elementtype
Line 37: Line 35:
 
| not null
 
| not null
 
|  
 
|  
| pk_element
 
 
|  
 
|  
 
|-
 
|-
Line 43: Line 40:
 
| varchar(256)
 
| varchar(256)
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| integer
 
| integer
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| integer
 
| integer
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_element
 +
| mapid, elementid, elementtype
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| element_mapid_elementid
 +
|
 +
| mapid, elementid
 +
|}
  
 +
=== 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:31, 11 February 2010

wikibot

Table public.element


Columns

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

Primary Key Columns
pk_element mapid, elementid, elementtype

Indexes

Index Type Columns
element_mapid_elementid mapid, elementid

Foreign Keys

Relation Column Referenced Column
public.map mapid mapid