Table transmart.searchapp.search_auth_principal 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
search_auth_group.id sh_auth_gp_id_fk R
search_auth_group_member.auth_user_id sch_user_gp_m_usr_fk R
search_auth_sec_object_access.auth_principal_id sch_sec_a_u_fk R
search_auth_user.id sh_auth_user_id_fk R
search_gene_signature_item.id Implied Constraint R
principal_type varchar 255  √  null
date_created timestamp 29,6
description varchar 255  √  null
last_updated timestamp 29,6
name varchar 255  √  null
unique_id varchar 255  √  null
enabled bool 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pk_search_principal

Close relationships  within of separation: