From dbscript Online Help
wikibot[edit]
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
|
