SchemaSpy - Table pvsadmin.public.mailmerge

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
mailmerge_id	int4	10	√	null
candidate_id	int4	10	√	null
election_candidate_id	int4	10	√	null
npataddress	bool	1	√	null
deadline	date	13	√	null
password	text	2147483647	√	null
title	text	2147483647	√	null
seekingtitle	text	2147483647	√	null
districtname	text	2147483647	√	null
firstname	text	2147483647	√	null
middlename	text	2147483647	√	null
lastname	text	2147483647	√	null
suffix	text	2147483647	√	null
address	text	2147483647	√	null
city	text	2147483647	√	null
state	text	2147483647	√	null
zip	text	2147483647	√	null
contacttitle	text	2147483647	√	null
contactname	text	2147483647	√	null
status	text	2147483647	√	null
email	text	2147483647	√	null
mergedate	timestamp	29,6		now()

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

Indexes:

Column(s)	Type	Sort	Constraint Name
mailmerge_id	Performance	Asc	mailmerge__mailmerge_id
mergedate	Performance	Asc	mailmerge__mergedate