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