Table pvsadmin.public.npatanswer 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
npatanswer_id serial 10  √  nextval('npatanswer_id_seq'::regclass)
npatanswer_category.npatanswer_id npatanswer_category_npatanswer_id_fkey C
npatanswer_tag.npatanswer_id npatanswer_tag_npatanswer_id_fkey C
npatanswerlocking.npatanswer_id npatanswerlocking_npatanswer_id_fkey C
npatmatrix_id int4 10
npatmatrix.npatmatrix_id npatanswer__npatmatrix_id_fk R
npatcandidate_id int4 10
npatcandidate.npatcandidate_id npatanswer__npatcandidate_id_fk C
npatoption_id int4 10  √  null
npatoption.npatoption_id npatanswer__npatoption_id_fk C
answertext text 2147483647 ''::text
our_npatoption_id int4 10  √  null
npatoption.npatoption_id npatanswer__our_npatoption_id_fk C
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 3,364,548 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
npatanswer_id Primary key Asc npatanswer__pk
npatcandidate_id Performance Asc npatanswer__npatcandidate_id
npatmatrix_id Performance Asc npatanswer__npatmatrix_id
npatmatrix_id + npatcandidate_id Must be unique Asc/Asc npatanswer__npatmatrix_id_npatcandidate_id
npatoption_id Performance Asc npatanswer__npatoption_id
our_npatoption_id Performance Asc npatanswer__our_npatoption_id

Close relationships  within of separation: