Block Zoola Reports User Table Schema (block_zoola_reports_user)


Description

Users that can access this block instance

block_zoola_reports_user table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
blockinstanceid BIGINT 19 null
block_instances.id bloczoolrepouser_blo2_fk R

Block instance ID
userid BIGINT 19 null
user.id bloczoolrepouser_use2_fk R

User ID

Table contained -1 rows

block_zoola_reports_user table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bloczoolrepouser_blo_ix Performance Asc blockinstanceid
bloczoolrepouser_blouse_uix Must be unique Asc/Asc blockinstanceid + userid
bloczoolrepouser_use_ix Performance Asc userid

block_zoola_reports_user table relationships

Close relationships within degrees of separation