Table pvsadmin.public.congstatus 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
congstatus_id serial 10  √  nextval('congstatus_id_seq'::regclass)
congnote_status.congstatus_id congnote_status__congstatus_id_fk C
congstatus_candidate.congstatus_id congstatus_candidate__congstatus_id_fk C
congstatus_committee.congstatus_id congstatus_committee__congstatus_id C
congstatus_tag.congstatus_id congstatus_tag__congstatus_fk C
congstatus_vetotext.congstatus_id congstatus_vetotext__congstatus_id_fk C
npatcitation_congstatus.congstatus_id npatcitation_congstatus__congstatus_id C
npatrow_congstatus.congstatus_id npatrow_congstatus__congstatus_id_fkey R
congress_id int4 10
congress.congress_id congstatus__congress_id_fk C
conglevel_id bpchar 1
conglevel.conglevel_id congstatus__conglevel_id_fk R
congstage_id int2 5
congstage.congstage_id congstatus__congstage_id_fk C
congoutcome_id int2 5  √  null
congoutcome.congoutcome_id congstatus__congoutcome_id_fk C
congofficialtitle_id int4 10  √  null
congofficialtitle.congofficialtitle_id congstatus__congofficialtitle_id_fk N
congtitle_id int4 10  √  null
congtitle.congtitle_id congstatus__congtitle_id_fk N
conghighlight_id int4 10  √  null
conghighlight.conghighlight_id congstatus__conghighlight_id_fk N
congsynopsis_id int4 10  √  null
congsynopsis.congsynopsis_id congstatus__congsynopsis_id_fk N
congcategory_id int4 10  √  null
congcategory.congcategory_id congstatus__congcategory_id_fk N
congofficialsynopsis_id int4 10  √  null
congofficialsynopsis.congofficialsynopsis_id congstatus__congofficialsynopsis_id_fk N
congtext_id int4 10  √  null
congtext.congtext_id congstatus__congtext_id_fk N
release_id int2 5 0
release.release_id Implied Constraint R
rank int2 5  √  null
statusdate date 13
rollnumber int2 5  √  null
yea int2 5  √  null
nay int2 5  √  null
voicevote bool 1 false
keyvote bool 1 false
created timestamp 29,6  √  null
modified timestamp 29,6  √  null
congdocgroup_id int4 10  √  null
congdocgroup.congdocgroup_id congstatus__congdocgroup_id_fk N

Table contained 45,928 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
congstatus_id Primary key Asc congstatus__pk
congcategory_id Performance Asc congstatus__congcategory_id
conghighlight_id Performance Asc congstatus__conghighlight_id
conglevel_id Performance Asc congstatus__conglevel_id
congofficialsynopsis_id Performance Asc congstatus__congofficialsynopsis_id
congofficialtitle_id Performance Asc congstatus__congofficialtitle_id
congoutcome_id Performance Asc congstatus__congoutcome_id
congress_id Performance Asc congstatus__congress_id
congstage_id Performance Asc congstatus__congstage_id
congsynopsis_id Performance Asc congstatus__congsynopsis_id
congtext_id Performance Asc congstatus__congtext_id
congtitle_id Performance Asc congstatus__congtitle_id
release_id Performance Asc congstatus__release_id
rollnumber Performance Asc congstatus__rollnumber
statusdate Performance Asc congstatus__statusdate
voicevote Performance Asc congstatus__voicevote
Performance csc_year

Close relationships  within of separation: