Table pvsadmin.public.npatoption 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
npatoption_id serial 10  √  nextval('npatoption_id_seq'::regclass)
npatanswer.npatoption_id npatanswer__npatoption_id_fk C
npatanswer.our_npatoption_id npatanswer__our_npatoption_id_fk C
npatrow_sig.npatoption_id npatrow_sig__npatoption_id_fkey R
npatoptiontext_id int4 10
npatoptiontext.npatoptiontext_id npatoption__npatoptiontext_id_fk R
npatoptiongroup_id int4 10
npatoptiongroup.npatoptiongroup_id npatoption__npatoptiongroup_id_fk R
rank int4 10
code bpchar 1  √  null

Table contained 73 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
npatoption_id Primary key Asc npatoption__pk
npatoptiongroup_id Performance Asc npatoption__npatoptiongroup_id
npatoptiontext_id Performance Asc npatoption__npatoptiontext_id

Close relationships  within of separation: