Table pvsadmin.public.npatmatrix 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
npatmatrix_id serial 10  √  nextval('npatmatrix_id_seq'::regclass)
npatanswer.npatmatrix_id npatanswer__npatmatrix_id_fk R
npatmatrix_category.npatmatrix_id npatmatrix_category_npatmatrix_id_fkey C
npatmatrix_p.npatmatrix_id Implied Constraint R
npatform_id int4 10
npatform.npatform_id npatmatrix_npatform_id_fkey C
npatrow_id int4 10
npatrow.npatrow_id npatmatrix__npatrow_id_fk R
path ltree 2147483647
rank int2 5 0

Table contained 107,891 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
npatmatrix_id Primary key Asc npatmatrix_pk
npatform_id Performance Asc npatmatrix__npatform_id
npatrow_id Performance Asc npatmatrix__npatrow_id
path Performance Asc npatmatrix__path_gist
rank Performance Asc npatmatrix__rank

Close relationships  within of separation: