Block Zoola Schedule Rcp Table Schema (block_zoola_schedule_rcp)


Description

Scheduled reports recipients

block_zoola_schedule_rcp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id bloczoolschercp_use2_fk R

user that receives report
schrepsid BIGINT 19 √ null
block_zoola_reports_schreps.id bloczoolschercp_sch2_fk R

schedule id

Table contained -1 rows

block_zoola_schedule_rcp table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bloczoolschercp_sch_ix Performance Asc schrepsid
bloczoolschercp_schuse_ix Performance Asc/Asc schrepsid + userid
bloczoolschercp_use_ix Performance Asc userid

block_zoola_schedule_rcp table relationships

Close relationships within degrees of separation