mayausergroup


Description

Most permissions a visibility are given to a usergroup

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmayausergroup int8 19 null
coverage_usergroup.idmayausergroup FK_coverage_usergroup_mayausergroup C
mayauser_mayausergroup.idmayausergroup FK_mayauser_mayausergroup_mayausergroup R
idclient int4 10 null
client.idclient FK_mayausergroup_client R
alias varchar 50 null
description varchar 100 √ null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_idmayausergroup Primary key Asc idmayausergroup
UQ_mayausergroup_idmayausergroup Must be unique Asc idmayausergroup

Relationships

Close relationships within degrees of separation