user

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
activity_assignment.user_id FK_65277AB2A76ED395 C
assignment.user_id FK_30C544BAA76ED395 C
booking.user_id FK_E00CEDDEA76ED395 C
location_assignment.user_id FK_89ED4565A76ED395 C
user_permission.user_id FK_472E5446A76ED395 C
object_id VARCHAR 255 √ NULL
pid VARCHAR 255 null
email VARCHAR 255 √ NULL
first_name VARCHAR 255 √ NULL
last_name VARCHAR 255 √ NULL
profile_picture_url VARCHAR 512 √ NULL
created_at DATETIME 19 null
updated_at DATETIME 19 null
role_id INT UNSIGNED 10 null
role.id FK_8D93D649D60322AC R

Indexes

Constraint Name Type Sort Column(s)
user_s_pk Primary key Asc id
IDX_8D93D649D60322AC Performance Asc role_id
PRIMARY Must be unique Asc id
UNIQ_8D93D649232D562B Must be unique Asc object_id
UNIQ_8D93D6495550C4ED Must be unique Asc pid
UNIQ_8D93D649E7927C74 Must be unique Asc email

Relationships

Close relationships within degrees of separation