Reportbuilder Grp Org User Table Schema (reportbuilder_grp_org_user)


Description

Restricted organisations that will see only allowed records

reportbuilder_grp_org_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 repogrporguser_rep2_fk R
orgid BIGINT 19 null
org.id repogrporguser_org2_fk R
includechildren BIT 1 √ 0
timecreated BIGINT 19 0

Table contained -1 rows

reportbuilder_grp_org_user table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repogrporguser_org_ix Performance Asc orgid
repogrporguser_rep_ix Performance Asc reportbuilderuserid

reportbuilder_grp_org_user table relationships

Close relationships within degrees of separation