bireportaccess


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userGroupId INT 10 null
usergroup.id fk_biAccessUserGroup R
biReportId INT 10 null
bireport.id fk_biAccessReport R
accessLevel VARCHAR 45 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_biAccessReport_idx Performance Asc biReportId
fk_biAccessUserGroup_idx Performance Asc userGroupId
uk_biAccessUserReport Must be unique Asc/Asc userGroupId + biReportId

Relationships

Close relationships within degrees of separation