create table participant (
		participant_id  char(5),
		part_fname  char(15),
		part_lname  char(15));
		
create table team (
		team_id  char(3),
		team_name  char(20),
		fax  char(10),
		league_code char(2));
		
create table league (
		league_code char(2),
		league_name char(20));
create table event  (
		event_code  char(4),
		event_type  char(1),
		event_desc  char(30));
		
create table event_result  (
		event_result_code  char(2),
		event_result_desc  char(30));
		
create table role  (
		role_code  char(2),
		role_description  char(20));
		
create table game  (
		game_id  char(5),
		date  date,
		time time with time zone,
		home_team  char(3),
		away_team  char(3));
		
create table participant_game  (
		key  char(10),
		participant_id  char(5),
		team_id  char(3),
		game_id  char(5),
		role_code  char(2),
		inning  char(2),
		inning_order char(3),
		event_code  char(4),
		event_result_code  char(2),
		event_text  char(40));
		
create index pgkey on participant_game (key);