STATEs
Tables (3)
BILL (Untitled3)
- Bill_name (Key) — VARCHAR(50) — Primary key — NOT NULL
- Date_of_vote (Field) — DATE
- Passed_or_failed (Field2) — VARCHAR(10)
- Sponsor (Field3) — VARCHAR(20)
- Name (Key2) — VARCHAR(20) — Foreign key → CONGRESSPERSON.Name — NOT NULL
- Name (Key22) — VARCHAR(20) — Foreign key → CONGRESSPERSON.Name — NOT NULL
CONGRESSPERSON (Untitled2)
- Name (Key) — VARCHAR(20) — Primary key — NOT NULL
- Name (Key2) — VARCHAR(20) — Foreign key → STATE.Name — NOT NULL
- Party (Field3) — VARCHAR(15)
- District (Field) — VARCHAR(20)
- Start_date (Field2) — DATE
STATE (Untitled)
- Name (Key) — VARCHAR(20) — Primary key — NOT NULL
- Regions (Field) — VARCHAR(20)