users

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id uuid 2147483647 null
user_roles.user_id fk_user_roles_user R
user_name varchar 255 null
password varchar 255 null
is_active bool 1 true
is_verified bool 1 false
agency_code varchar 255 √ null
agency_id uuid 2147483647 √ null
agencies.agency_id Implied Constraint R
created_at timestamp 29,6 CURRENT_TIMESTAMP
updated_at timestamp 29,6 √ null
created_by uuid 2147483647 √ null
updated_by uuid 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_user_name_key Must be unique Asc user_name

Relationships

Close relationships within degrees of separation