Table tlegroup
User management groups

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
tlegroup.parent_id fk1563c1b29965196c R
tlegroup_all_parents.all_parents_id fkf699215ec397020b R
tlegroup_all_parents.tlegroup_id fkf699215e41c96364 R
tlegroup_users.tlegroup_id fk42a7253b41c96364 R
description text 2147483647  √  null
name varchar 100  √  null
uuid varchar 40
institution_id int8 19
institution.id fk1563c1b2bc711081 R
parent_id int8 19  √  null
tlegroup.id fk1563c1b29965196c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc tlegroup_pkey
institution_id Performance Asc groupinstitutionindex
uuid Performance Asc groupuuidindex
parent_id Performance Asc parentgroup
uuid + institution_id Must be unique Asc/Asc tlegroup_uuid_institution_id_key

Close relationships  within of separation: