SWDB
← Versions / 6.5.3.3 /

user

Fields (17)

Name Type Null Key Default Extra
id binary(16) NO PRI NULL
username varchar(255) NO UNI NULL
password varchar(255) NO NULL
first_name varchar(255) NO NULL
last_name varchar(255) NO NULL
title varchar(255) YES NULL
email varchar(255) NO UNI NULL
active tinyint(1) NO 0
admin tinyint(1) YES NULL
avatar_id binary(16) YES MUL NULL
locale_id binary(16) NO MUL NULL
store_token varchar(255) YES NULL
last_updated_password_at datetime(3) YES NULL
time_zone varchar(255) NO UTC
custom_fields json YES NULL
created_at datetime(3) NO NULL
updated_at datetime(3) YES NULL

Indexes (5)

Name Columns Unique
fk.user.avatar_id avatar_id No
fk.user.locale_id locale_id No
PRIMARY id Yes
uniq.user.email email Yes
uniq.user.username username Yes

Relations From (2)

avatar_id media . id
locale_id locale . id

Referenced By (12)

acl_user_role . user_id id
customer . created_by_id id
customer . updated_by_id id
import_export_log . user_id id
media . user_id id
notification . created_by_user_id id
order . created_by_id id
order . updated_by_id id
state_machine_history . user_id id
user_access_key . user_id id
user_config . user_id id
user_recovery . user_id id