Reportbuilder Grp Cohort User Table Schema (reportbuilder_grp_cohort_user)


Description

Restricted cohorts that will see only allowed records

reportbuilder_grp_cohort_user table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reportbuilderuserid BIGINT 19 null
report_builder_global_restriction.id repogrpcohouser_rep2_fk R
cohortid BIGINT 19 null
cohort.id repogrpcohouser_coh2_fk R
timecreated BIGINT 19 0

Table contained -1 rows

reportbuilder_grp_cohort_user table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repogrpcohouser_coh_ix Performance Asc cohortid
repogrpcohouser_rep_ix Performance Asc reportbuilderuserid

reportbuilder_grp_cohort_user table relationships

Close relationships within degrees of separation