Reportbuilder Grp Org Record Table Schema (reportbuilder_grp_org_record)


Description

Organisations that restricted users can see

reportbuilder_grp_org_record table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
reportbuilderrecordid BIGINT 19 null
report_builder_global_restriction.id repogrporgreco_rep2_fk R
orgid BIGINT 19 null
org.id repogrporgreco_org2_fk R
includechildren BIT 1 √ 0
timecreated BIGINT 19 0

Table contained -1 rows

reportbuilder_grp_org_record table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repogrporgreco_org_ix Performance Asc orgid
repogrporgreco_rep_ix Performance Asc reportbuilderrecordid

reportbuilder_grp_org_record table relationships

Close relationships within degrees of separation