Report Builder Global Restriction table / report_builder_global_restriction - Totara Learn 12 Database schema / Zoola Analytics

report_builder_global_restriction table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

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

One
Two degrees

Report Builder Global Restriction Table Schema (report_builder_global_restriction)

Description

report_builder_global_restriction table columns

report_builder_global_restriction table indexes

report_builder_global_restriction table relationships

Close relationships within degrees of separation