Table transmart.searchapp.search_auth_user Generated by
SchemaSpy
Legend: SourceForge.net
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
saved_faceted_search.user_id saved_faceted_search_user_id R
search_auth_user_sec_access.search_auth_user_id search_sec_a_u_fk R
search_gene_signature.created_by_auth_user_id gene_sig_create_auth_user_fk1 R
search_gene_signature.modified_by_auth_user_id gene_sig_mod_auth_user_fk1 R
search_role_auth_user.authorities_id fkfb14ef79287e0cac R
search_auth_principal.id sh_auth_user_id_fk R
email varchar 255  √  null
email_show bool 1  √  null
passwd varchar 255  √  null
user_real_name varchar 255  √  null
username varchar 255  √  null
federated_id varchar 255  √  null
change_passwd bool 1  √  null

Table contained 5 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc sys_c0011119  
federated_id Must be unique Asc sau_fed_id_key This unique column is also nullable

Close relationships  within of separation: