SchemaSpy - Table pvsadmin.public.npatoption

Generated by
SchemaSpy

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

npatoption_id

serial

√

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

npatoptiontext.npatoptiontext_id

npatoption__npatoptiontext_id_fk R

npatoptiongroup_id

int4

npatoptiongroup.npatoptiongroup_id

npatoption__npatoptiongroup_id_fk R

rank

int4

code

bpchar

√

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