omnitracsuser


Description

A role equivalent to a superuser that can manage several accounts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
iduseromni int4 10 null
idclient int4 10 √ null
client.idclient FK_omnitracsuser_client R
iduser int8 19 √ null
mayauser.idmayauser FK_omnitracsuser_user R
enabled bool 1 true

Indexes

Constraint Name Type Sort Column(s)
PK_OMNITRACSUSER Primary key Asc iduseromni
UQ_omniuser_iduseromni Must be unique Asc iduseromni

Relationships

Close relationships within degrees of separation