user

154 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('user_id_seq'::regclass)
api_key.bound_user_id api_key_bound_user_id_fkeyR
backup_role.user_id backup_role_user_id_fkeyC
pinned_vessel.user_id pinned_vessel_user_id_fkeyC
push_notification_token.user_id pushnotificationtoken_user_id_fkeyC
email text 2147483647 null
password_hash text 2147483647 null
first_name text 2147483647 null
last_name text 2147483647 null
created_at timestamptz 35,6 CURRENT_DATE
created_by int4 10 null
modified_at timestamptz 35,6 CURRENT_DATE
modified_by int4 10 null
role_id serial 10 √ nextval('user_role_id_seq'::regclass)
role.id public_role_id_fkeyC
last_login_time timestamptz 35,6 √ null
last_login_data jsonb 2147483647 √ null
status text 2147483647 'active'::text
last_session_time timestamptz 35,6 √ null
registration_code_id int8 19 √ null
registration_codes.id user_registration_code_id_fkeyN
time_zone text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc id
index_lower_email Must be unique
index_lower_first_name Performance
index_lower_last_name Performance
last_login_time_idx Performance Asc last_login_time
last_session_time_idx Performance Asc/Asc last_session_time + registration_code_id
uniq_email Must be unique Asc email
user_status_index Performance Asc status

Relationships

Close relationships within degrees of separation