Wiki Subwikis Table Schema (wiki_subwikis)


Stores subwiki instances

wiki_subwikis table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
wiki_links.subwikiid wikilink_sub2_fk R
wiki_pages.subwikiid wikipage_sub2_fk R
wikiid BIGINT 19 0 wikisubw_wik2_fk R

Wiki activity

groupid BIGINT 19 0

Group that owns this wiki

userid BIGINT 19 0 Implied Constraint R

Owner of that subwiki

Table contained -1 rows

wiki_subwikis table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wikisubw_wik_ix Performance Asc wikiid
wikisubw_wikgrouse_uix Must be unique Asc/Asc/Asc wikiid + groupid + userid

wiki_subwikis table relationships