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 10 null
blockinstanceid bigint 10 null
block_instances.id bloczoolrepouser_blo2_fk R

Block instance ID

userid bigint 10 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