jhi_user

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
jhi_user_authority.user_id fk_user_id R
login varchar 50 null
password_hash varchar 60 null
first_name varchar 50 √ null
jhi_authority.name Implied Constraint R
last_name varchar 50 √ null
jhi_authority.name Implied Constraint R
email varchar 191 √ null
image_url varchar 256 √ null
activated bool 1 null
lang_key varchar 10 √ null
activation_key varchar 20 √ null
reset_key varchar 20 √ null
created_by varchar 50 null
created_date timestamp 29,6 √ null
reset_date timestamp 29,6 √ null
last_modified_by varchar 50 √ null
last_modified_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
jhi_user_pkey Primary key Asc id
ux_user_email Must be unique Asc email
ux_user_login Must be unique Asc login

Relationships

Close relationships within degrees of separation