wiki_page_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
wiki_page_id INT 10 √ null
wiki_page.id fk_wiki_page_id R
page_title VARCHAR 100 √ null
subject VARCHAR 100 √ null
body LONGTEXT 2147483647 √ null
user_id INT 10 √ null
sys_users.user_id fk_user_id R
proxy_user_id INT 10 √ null
sys_users.user_id fk_proxy_user_id R
event_type VARCHAR 100 √ null
timestamp DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
key_proxy_user_id Performance Asc proxy_user_id
key_user_id Performance Asc user_id
key_wiki_page_id Performance Asc wiki_page_id

Relationships

Close relationships within degrees of separation