Table pvsadmin.public.npatrow 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
npatrow_id serial 10  √  nextval('npatrow_id_seq'::regclass)
npatcitation.npatrow_id npatcitation__npatrow_id C
npatmatrix.npatrow_id npatmatrix__npatrow_id_fk R
npatrow_category.npatrow_id npatrow_category__npatrow_id_fkey R
npatrow_congstatus.npatrow_id npatrow_congstatus__npatrow_id_fkey R
npatrow_p.npatrow_id Implied Constraint R
npatrow_sig.npatrow_id npatrow_sig__npatrow_id_fkey R
npatrowshorttext.npatrow_id npatrowshorttext__npatrow_id_fk R
npatrowtext_id int4 10
npatrowtext.npatrowtext_id npatrow_npatrowtext_id_fkey C
npatrowtype_id int4 10
npatrowtype.npatrowtype_id npatrow_npatrowtype_id_fkey R
wordlimit int2 5  √  null
profile bool 1  √  null

Table contained 20,050 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
npatrow_id Primary key Asc npatrow__pk
npatrowtext_id Performance Asc npatrow_npatrowtext
npatrowtype_id Performance Asc npatrow_npatrowtype

Close relationships  within of separation: