users

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
assignment_result.user_id assignment_result_user_id_foreign C
auth_groups_users.user_id auth_groups_users_user_id_foreign C
auth_identities.user_id auth_identities_user_id_foreign C
auth_permissions_users.user_id auth_permissions_users_user_id_foreign C
auth_remember_tokens.user_id auth_remember_tokens_user_id_foreign C
case_result.user_id case_result_user_id_foreign C
training_users.user_id training_users_user_id_foreign C
uploads.user_id uploads_user_id_foreign C
user_meta.user_id user_meta_user_id_foreign C
username VARCHAR 30 √ null
firstname TEXT 65535 null
middlename TEXT 65535 null
lastname TEXT 65535 null
status VARCHAR 255 √ null
status_message VARCHAR 255 √ null
active BIT 1 0
last_active DATETIME 19 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
username Must be unique Asc username

Relationships

Close relationships within degrees of separation