users

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
banknotecountprotocol.user_id FK_C15A35D9A76ED395R
cashjournal.completedByUser_id FK_A7F52B634956C29R
cashreport.user_id FK_7D290034A76ED395R
cashreportitem.user_id FK_AA0D882A76ED395R
contact.contactClerk_id FK_4C62E638CE4DBD6CR
contact_excludeduser.user_id FK_20E02005A76ED395C
contact_user.user_id FK_A56C54B6A76ED395C
contactmessage.user_id FK_DF1CE07DA76ED395R
csvimport.executedByUser_id FK_20CB513AC0848D2R
customform_user.user_id FK_D2A0705AA76ED395C
customformaction_user.user_id FK_6762B9FEA76ED395C
customformfield.createdByUser_id FK_59E39350E1F44B34R
customformfield_excludeduser.user_id FK_BF117F21A76ED395C
customformfield_user.user_id FK_878DAF37A76ED395C
customformgrid_user.user_id FK_1587CE8DA76ED395C
customformgrid_usercanaddcolumns.user_id FK_963F47F2A76ED395C
customformgridaction_user.user_id FK_6EAB345EA76ED395C
desktopdownloadjob.user_id FK_A8240721A76ED395R
ecreport.user_id FK_329AF1E9A76ED395R
ecreportitem.user_id FK_4313015BA76ED395R
entitylog.user_id FK_685BD0A8A76ED395R
liability.clerk_id FK_3B59ECCCD95C1FC6R
mailjob.user_id FK_55EE4AC9A76ED395R
maillog.user_id FK_2109C2F4A76ED395R
offer.clerk_id FK_29D6873ED95C1FC6R
orderinternalcomment.user_id FK_76487907A76ED395R
orders.clerk_id FK_E52FFDEED95C1FC6R
payment_user.user_id FK_AC10413DA76ED395C
picklistreservation.user_id FK_D296DC42A76ED395R
posterminal_priceuser.user_id FK_4692CEFCA76ED395C
posterminal_user.user_id FK_8A4CDD1DA76ED395C
printjob.completedByUser_id FK_5BB8166434956C29R
printjob.user_id FK_5BB81664A76ED395R
product.createdByUser_id FK_D34A04ADE1F44B34R
report.gridReportForUser_id FK_C42F7784A258C4EBR
shirtnetworkprintjob.user_id FK_F51458C5A76ED395R
timetracking.user_id FK_88B32207A76ED395R
user_client.user_id FK_A2161F68A76ED395R
user_excludedpage.user_id FK_15020E5AA76ED395C
user_excludedroute.user_id FK_B215B0E3A76ED395C
user_excludedwidget.user_id FK_9593B51AA76ED395C
user_grantedpage.user_id FK_DE545B69A76ED395C
user_grantedroute.user_id FK_D0E87A0A76ED395C
user_grantedwidget.user_id FK_7AF9BE07A76ED395C
user_inversedobjectgroup.user_id FK_FD512877A76ED395C
user_objectgroup.user_id FK_4EBC158A76ED395C
user_posterminal.user_id FK_3F25404FA76ED395C
user_posterminalprice.user_id FK_ED271B4BA76ED395C
user_usergroup.user_id FK_4A84F5F3A76ED395C
usermessage.forUser_id FK_2ADCCCC1A763F1AER
usermessage.fromUser_id FK_2ADCCCC11CD1765AR
usermessagechannel_user.user_id FK_23873805A76ED395C
usermetafield.user_id FK_5B3BE760A76ED395R
users.wawilistenerUser_id FK_1483A5E9A6DCF3A5R
usersession.user_id FK_4C25296AA76ED395R
vendorconditions.productionOrderClerk_id FK_739D79358334E7BR
vendororder.clerk_id FK_82C1E65CD95C1FC6R
vendororderdelivery.user_id FK_44EAB757A76ED395R
voucherreport.user_id FK_8BACCD26A76ED395R
voucherreportitem.user_id FK_7BED79A2A76ED395R
warehouse_excludeduser.user_id FK_2CCAAE63A76ED395C
warehouse_user.user_id FK_52F9D69DA76ED395C
warehousebooking.user_id FK_FC6BD52CA76ED395R
warehousestoragelocation.reservedByUser_id FK_CBC9E6B77BB449EFR
warehousestoragelocation_boxforuser.user_id FK_E8590EFDA76ED395C
workflowactionjob.user_id FK_E5086F87A76ED395R
username VARCHAR 255 null
username_canonical VARCHAR 255 null
email VARCHAR 255 null
email_canonical VARCHAR 255 null
enabled BIT 1 null
salt VARCHAR 255 null
password VARCHAR 255 null
last_login DATETIME 19 √ null
confirmation_token VARCHAR 255 √ null
password_requested_at DATETIME 19 √ null
roles LONGTEXT 2147483647 null

(DC2Type:array)
posUserNumber VARCHAR 255 √ null
firstName VARCHAR 255 √ null
lastName VARCHAR 255 √ null
posPin INT 10 √ null
wawilistenerUser_id INT 10 √ null
users.id FK_1483A5E9A6DCF3A5R
locked BIT 1 null
expired BIT 1 null
expires_at DATETIME 19 √ null
credentials_expired BIT 1 null
credentials_expire_at DATETIME 19 √ null
wawilistener_id VARCHAR 36 √ null
wawilistener.id FK_1483A5E95DBC5E14R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_1483A5E95DBC5E14 Performance Asc wawilistener_id
IDX_1483A5E9A6DCF3A5 Performance Asc wawilistenerUser_id
UNIQ_1483A5E992FC23A8 Must be unique Asc username_canonical
UNIQ_1483A5E9A0D96FBF Must be unique Asc email_canonical

Relationships

Close relationships within degrees of separation