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 0 0
allrecords BIT 0 0

True means no restrictions

allusers BIT 0 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