Block Zoola Reports Cohort Table Schema (block_zoola_reports_cohort)


Description

Cohorts that can access this block instance

block_zoola_reports_cohort table columns

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

Block instance ID
cohortid BIGINT 19 null
cohort.id bloczoolrepocoho_coh2_fk R

Cohort ID

Table contained -1 rows

block_zoola_reports_cohort table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bloczoolrepocoho_blo_ix Performance Asc blockinstanceid
bloczoolrepocoho_blocoh_uix Must be unique Asc/Asc blockinstanceid + cohortid
bloczoolrepocoho_coh_ix Performance Asc cohortid

block_zoola_reports_cohort table relationships

Close relationships within degrees of separation