wiki_page


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
user_favorite.wiki_page_id fk_fav_wiki_page_id R
user_wiki_page_visit.wiki_page_id fk_visit_page_id R
wiki_page.parent_id wiki_page_parent_id R
wiki_page_attachment.page_id wiki_page_attachment_page_id R
wiki_page_audience.wiki_page_id fk_page_audience_page_id R
wiki_page_history.wiki_page_id fk_wiki_page_id R
parent_id INT 10 √ null
wiki_page.id wiki_page_parent_id R
name VARCHAR 100 null
title VARCHAR 100 null
description TEXT 65535 √ null
content_html LONGTEXT 2147483647 √ null
content_text LONGTEXT 2147483647 √ null
content_type VARCHAR 100 √
content_length INT UNSIGNED 10 √ null
date_created DATETIME 19 √ null
last_updated DATETIME 19 √ null
state VARCHAR 50 √ null
admin_only BIT 1 √ 0
draft_content_html LONGTEXT 2147483647 √ null
draft_content_text LONGTEXT 2147483647 √ null
draft_content_type VARCHAR 100 √ null
draft_content_length INT UNSIGNED 10 √ null
draft_content_created_date DATETIME 19 √ null
last_published_date DATETIME 19 √ null
order_index INT 10 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc/Asc parent_id + name

Relationships

Close relationships within degrees of separation