Wiki Subwikis Table Schema (wiki_subwikis)


Description

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
wiki.id wikisubw_wik2_fk R

Wiki activity
groupid BIGINT 19 0

Group that owns this wiki
userid BIGINT 19 0
user.id 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

Close relationships within degrees of separation