Wiki Synonyms Table Schema (wiki_synonyms)


Description

Stores wiki pages synonyms

wiki_synonyms table columns

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

Subwiki instance

pageid BIGINT 19 0
page.id Implied Constraint R

Original page

pagesynonym VARCHAR 255 Pagesynonym

Page name synonym

Table contained -1 rows

wiki_synonyms table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wikisyno_pagpag_uix Must be unique Asc/Asc pageid + pagesynonym

wiki_synonyms table relationships