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)