Wiki Pages Table Schema (wiki_pages)


Stores wiki pages

wiki_pages table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
wiki_links.frompageid wikilink_fro2_fk R
wiki_versions.pageid wikivers_pag2_fk R
subwikiid BIGINT 19 0 wikipage_sub2_fk R

Subwiki instance of this page

title VARCHAR 255 title

Page name

cachedcontent LONGTEXT 2147483647 null

Cache wiki content

timecreated BIGINT 19 0

Wiki page creation timestamp

timemodified BIGINT 19 0

page edition timestamp

timerendered BIGINT 19 0

Last render timestamp

userid BIGINT 19 0 Implied Constraint R

Edition author

pageviews BIGINT 19 0

Number of page views

readonly BIT 1 0

Read only flag

Table contained -1 rows

wiki_pages table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wikipage_sub_ix Performance Asc subwikiid
wikipage_subtituse_uix Must be unique Asc/Asc/Asc subwikiid + title + userid

wiki_pages table relationships