SchemaSpy - Table pvsadmin.public.election

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

election_webaddress_id

serial

√

nextval('election_webaddress_id_seq'::regclass)

election_candidate_id

int4

√

null

election_candidate.election_candidate_id

election_webaddress__election_candidate_id_fk C

webaddresstype_id

int2

webaddresstype.webaddresstype_id

election_webaddress__webaddresstype_id_fk R

addresstype_id

int2

addresstype.addresstype_id

election_webaddress__addresstype_id_fk R

webaddress

varchar

2147483647

√

null

Table contained 218,288 rows at Tue Jan 03 04:46 MST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
election_webaddress_id	Primary key	Asc	election_webaddress__pk
addresstype_id	Performance	Asc	election_webaddress__addresstype_id
election_candidate_id	Performance	Asc	election_webaddress__ec_id
webaddresstype_id	Performance	Asc	election_webaddress__webaddresstype_id