users

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('users_id_seq'::regclass)
assets.created_by assets_created_by_fkey R
channels.created_by channels_created_by_fkey R
scenario_assets.created_by scenario_assets_created_by_fkey R
scenarios.created_by scenarios_created_by_fkey R
sources.created_by sources_created_by_fkey R
user_channels.user_id user_channels_user_id_fkey C
video_projects.user_id video_projects_user_id_fkey R
videos.created_by videos_created_by_fkey R
username varchar 50 null
email varchar 255 null
password_hash varchar 255 null
role user_roles 2147483647 null
is_active bool 1 √ null
first_name varchar 100 √ null
last_name varchar 100 √ null
avatar_url varchar 500 √ null
last_login timestamp 29,6 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
ix_users_email Must be unique Asc email
ix_users_username Must be unique Asc username

Relationships

Close relationships within degrees of separation