app_wiki_pages

0 rows


Description

Stores wiki pages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_wiki_pages_id_seq'::regclass)
app_wiki_links.frompageid Defined in XML R
app_wiki_versions.pageid Defined in XML R
subwikiid int8 19 0
app_wiki_subwikis.id Defined in XML R
title varchar 255 'title'::character varying
cachedcontent text 2147483647 null
timecreated int8 19 0
timemodified int8 19 0
timerendered int8 19 0
userid int8 19 0
pageviews int8 19 0
readonly int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_wikipage_id_pk Primary key Asc id
app_wikipage_sub_ix Performance Asc subwikiid
app_wikipage_subtituse_uix Must be unique Asc/Asc/Asc subwikiid + title + userid

Relationships