user_wiki_page_visit


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
user_id INT 10 null
sys_users.user_id fk_visit_user_id R
wiki_page_id INT 10 √ null
wiki_page.id fk_visit_page_id R
last_visit_date DATETIME 19 √ CURRENT_TIMESTAMP
visit_count INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
key_visit_user_id Performance Asc user_id
key_visit_wiki_page_id Performance Asc wiki_page_id

Relationships

Close relationships within degrees of separation