Wiki Links Table Schema (wiki_links)


Page wiki links

wiki_links table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
subwikiid BIGINT 19 0 wikilink_sub2_fk R

Subwiki instance

frompageid BIGINT 19 0 wikilink_fro2_fk R

Page id with a link

topageid BIGINT 19 0

Page id that recives a link

tomissingpage VARCHAR 255 null

link to a nonexistent page

Table contained -1 rows

wiki_links table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wikilink_fro_ix Performance Asc frompageid
wikilink_sub_ix Performance Asc subwikiid

wiki_links table relationships