Report Builder Global Restriction Table Schema (report_builder_global_restriction)


Description

Global Report Restrictions

report_builder_global_restriction table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reportbuilder_grp_cohort_record.reportbuilderrecordid repogrpcohoreco_rep2_fk R
reportbuilder_grp_cohort_user.reportbuilderuserid repogrpcohouser_rep2_fk R
reportbuilder_grp_org_record.reportbuilderrecordid repogrporgreco_rep2_fk R
reportbuilder_grp_org_user.reportbuilderuserid repogrporguser_rep2_fk R
reportbuilder_grp_pos_record.reportbuilderrecordid repogrpposreco_rep2_fk R
reportbuilder_grp_pos_user.reportbuilderuserid repogrpposuser_rep2_fk R
reportbuilder_grp_user_record.reportbuilderrecordid repogrpuserreco_rep2_fk R
reportbuilder_grp_user_user.reportbuilderuserid repogrpuseruser_rep2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 √ null

Description of the global report restriction
active BIT 1 0
allrecords BIT 1 0

True means no restrictions
allusers BIT 1 0

True means this restriction can be used by all users
sortorder BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 √ null

Table contained -1 rows

report_builder_global_restriction table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

report_builder_global_restriction table relationships

Close relationships within degrees of separation