visibility_group_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
site_visibility_group_id INT 10 √ null
site_visibility_group.id FK_vglog_site_visibility_group_id C
project_visibility_group_id INT 10 √ null
project_visibility_group.id FK_vglog_project_visibility_group_id C
message VARCHAR 1000 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_vglog_proxy_user_id R
subject VARCHAR 50 √ null
timestamp DATETIME 23 null
user_id INT 10 null
sys_users.user_id FK_vglog_user_id R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_vglog_project_visibility_group_id Performance Asc project_visibility_group_id
FK_vglog_proxy_user_id Performance Asc proxy_user_id
FK_vglog_site_visibility_group_id Performance Asc site_visibility_group_id
FK_vglog_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation