wiki_pages

0 rows


Description

Stores wiki pages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
wiki_links.frompageid wikilink_fro2_fkR
wiki_locks.pageid wiki_locks_erd_wikipageidR
wiki_synonyms.pageid wiki_synonyms_erd_pageidR
wiki_versions.pageid wikivers_pag2_fkR
subwikiid BIGINT 19 0
wiki_subwikis.id wikipage_sub2_fkR

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
user.id Implied ConstraintR

Edition author

pageviews BIGINT 19 0

Number of page views

readonly BIT 1 0

Read only flag

Indexes

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

Relationships