Wiki Table Schema (wiki)


Stores Wiki activity configuration

wiki table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
wiki_subwikis.wikiid wikisubw_wik2_fk R
course BIGINT 19 0

Course wiki activity belongs to

name VARCHAR 255 Wiki

name field for moodle instances

intro LONGTEXT 2147483647 null

General introduction of the wiki activity

introformat SMALLINT 5 0

Format of the intro field (MOODLE, HTML, MARKDOWN...)

timecreated BIGINT 19 0
timemodified BIGINT 19 0
firstpagetitle VARCHAR 255 First Page

Wiki first page's name

wikimode VARCHAR 20 collaborative

Wiki mode (individual, collaborative)

defaultformat VARCHAR 20 creole

Wiki's default editor

forceformat BIT 1 1

Forces the default editor

editbegin BIGINT 19 0


editend BIGINT 19 0


Table contained -1 rows

wiki table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wiki_cou_ix Performance Asc course

wiki table relationships