The History Of Baseball

franchise_id Franchise Id	franchise_name Franchise Name	active Active	na_assoc Na Assoc
ALT	Altoona Mountain City	N	nan
ANA	Los Angeles Angels of Anaheim	Y	nan
ARI	Arizona Diamondbacks	Y	nan
ATH	Philadelphia Athletics	N	PNA
ATL	Atlanta Braves	Y	BNA
BAL	Baltimore Orioles	Y	nan
BFB	Buffalo Bisons	N	nan
BFL	Buffalo Bisons	N	nan
BLC	Baltimore Canaries	nan	nan
BLO	Baltimore Orioles	N	nan


CREATE TABLE team_franchise (
  "franchise_id" VARCHAR,
  "franchise_name" VARCHAR,
  "active" VARCHAR,
  "na_assoc" VARCHAR
);