Table tleuser
Internal users table

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
email_address varchar 255  √  null
first_name varchar 255
last_name varchar 255
password varchar 255
username varchar 255
uuid varchar 40
institution_id int8 19
institution.id fkb6646e38bc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc tleuser_pkey
Performance lowercase_username
uuid + institution_id Must be unique Asc/Asc tleuser_uuid_institution_id_key
institution_id Performance Asc userinstitutionindex
uuid Performance Asc useruuidindex

Close relationships  within of separation: