Reportbuilder Grp Pos User Table Schema (reportbuilder_grp_pos_user)


Description

Restricted positions that will see only allowed records

reportbuilder_grp_pos_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 repogrpposuser_rep2_fk R
posid BIGINT 19 null
pos.id repogrpposuser_pos2_fk R
includechildren BIT 1 √ 0
timecreated BIGINT 19 0

Table contained -1 rows

reportbuilder_grp_pos_user table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repogrpposuser_pos_ix Performance Asc posid
repogrpposuser_rep_ix Performance Asc reportbuilderuserid

reportbuilder_grp_pos_user table relationships

Close relationships within degrees of separation