SchemaSpy - Table pvsadmin.public.congtools

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

congtools_id

serial

√

nextval('congtools_id_seq'::regclass)

congtype_id

bpchar

congtype.congtype_id

congtools__congtype_id_fk R

conglevel_id

bpchar

conglevel.conglevel_id

congtools__conglevel_id_fk R

congstage_id

int2

congstage.congstage_id

congtools__congstage_id_fk R

congoutcome_id

int2

congoutcome.congoutcome_id

congtools__congoutcome_id_fk R

congoutcometext_id

int2

congoutcometext.congoutcometext_id

congtools__congoutcometext_id_fk R

rank

int2

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
congtools_id	Primary key	Asc	congtools__pk
congoutcometext_id	Performance	Asc	congtools__congoutcometext_id
congtype_id + conglevel_id + congstage_id + congoutcome_id	Must be unique	Asc/Asc/Asc/Asc	congtools_unique