mayauser


Description

All users of the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmayauser int8 19 null
alertconf_user.iduser FK_alertconf_user_user R
alertconfscalinguser.iduser FK_alertconfscalinguser_user R
commandexec.iduser FK_commandexec_user R
configuration_exec.iduser fk_configuration_exec_iduser R
connex_request_log.idmayauser connex_request_log_idmayauser_fkey R
drive_workflow.idmayauser fk_drive_workflow_viewedbyuser R
feedback.idmayauser fk_idmayauser R
integration_mayauser.idmayauser fk_mayauser R
macroconf_processor.idmayauser Implied Constraint R
mayauser_mayausergroup.idmayauser FK_mayauser_mayausergroup_mayauser R
mayauser_message.idmayauser FK_mayauser_message_mayauser R
mayauser_report.idmayauser fk_mayauser_report_idmayauser R
message.idmayauser fk_message_mayauser R
message.viewed_by_user fk_viewed_by_user R
mvw_mayauser_device.idmayauser fk_mvw_mayauser_device_idmayauser R
note.idmayauser_sent fk_maya_user_note R
omnitracsuser.iduser FK_omnitracsuser_user R
route_definition.idcreation_mayauser route_definition_idcreation_mayauser_fkey R
route_definition.idmodification_mayauser route_definition_idmodification_mayauser_fkey R
sharedvehicle.createdbyuser fk_modifiedbyuser R
ternium_mayauser.idmayauser fk_ternium_mayauser_idmayauser R
token.idmayauser fk_idmayauser R
vw_coverage_enabled.idmayauser Implied Constraint R
vw_mayauser_device.idmayauser Implied Constraint R
vw_user.idmayauser Implied Constraint R
idrole int4 10 √ null
role.idrole FK_mayauser_role R
idclient int4 10 null
client.idclient FK_mayauser_client R
idpreference int4 10 √ null
preference.idpreference FK_mayauser_preference R
username varchar 64 null
name varchar 64 null
lastname varchar 50 null
email varchar 128 null
phone varchar 20 null
password varchar 50 null
omnitracuser bool 1 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 null
logintries int2 5 (0)::smallint
status int4 10 0
passchanged bool 1 false
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
ctrlcode varchar 2147483647 √ null
cellphone varchar 20 √ null
phoneoutsidecountry varchar 20 √ null
countrycode varchar 3 √ null
jobtitle varchar 50 √ null

Puesto que ocupa el usuario
contactaddress varchar 200 √ null

Dirección del usuario
pin varchar 4 √ null

The Personal Identification Number (PIN) for the user
lastlogindate timestamptz 35,6 √ null

Last login date registered for this user

Indexes

Constraint Name Type Sort Column(s)
PK_idmayauser Primary key Asc idmayauser
idx_mayauser_ctrlcode Performance Asc ctrlcode
mayauser_idclient_username_idx Must be unique Asc/Asc idclient + username
UQ_mayauser_idmayauser Must be unique Asc idmayauser
UQ_mayauser_idpreference Must be unique Asc idpreference

Relationships

Close relationships within degrees of separation