View pvsadmin.public.v_congstatus_candidate 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
congress_id int4 10  √  null
congtype_id bpchar 1  √  null
congtype.congtype_id Implied Constraint R
state_id bpchar 2  √  null
state.state_id Implied Constraint R
congstatus_id int4 10  √  null
conglevel_id bpchar 1  √  null
conglevel.conglevel_id Implied Constraint R
congstage_id int2 5  √  null
congstage.congstage_id Implied Constraint R
congoutcome_id int2 5  √  null
congoutcome.congoutcome_id Implied Constraint R
congofficialtitle_id int4 10  √  null
congtitle_id int4 10  √  null
conghighlight_id int4 10  √  null
congsynopsis_id int4 10  √  null
congcategory_id int4 10  √  null
congofficialsynopsis_id int4 10  √  null
office_candidate_id int4 10  √  null
candidate_id int4 10  √  null
congaction_id bpchar 1  √  null
congaction.congaction_id Implied Constraint R
congactiontype_id bpchar 1  √  null
congactiontype.congactiontype_id Implied Constraint R
congress_release_id int2 5  √  null
congstatus_release_id int2 5  √  null
billnumber varchar 2147483647  √  null
statename varchar 2147483647  √  null
url varchar 2147483647  √  null
rank int2 5  √  null
statusdate date 13  √  null
rollnumber int2 5  √  null
level varchar 2147483647  √  null
stage varchar 2147483647  √  null
outcome varchar 2147483647  √  null
yea int2 5  √  null
nay int2 5  √  null
voicevote bool 1  √  null
congress_note varchar 2147483647  √  null
congstatus_note varchar 2147483647  √  null
officialtitle text 2147483647  √  null
title varchar 2147483647  √  null
highlight text 2147483647  √  null
synopsis text 2147483647  √  null
officialsynopsis text 2147483647  √  null
congaction varchar 2147483647  √  null
congactioncode varchar 2147483647  √  null

Analyzed at Tue Jan 03 04:46 MST 2017


Close relationships: