Public.element (table)

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