bank Table
bank_id	int
deposit	double
balance	double
participant_id (fk)	int

financial Table
financial_id	int
deposit_paid	date
payment	double
balance_due	double
participant_id (fk)	int

health Table
health_id	int
participant_id (fk)	int
insurance_policy	varchar
emergency_contact_phone	varchar
insurance_company	varchar
conditions	mediumtext
medications	mediumtext
notes	mediumtext
insurance_id	varchar

league Table
league_id	int
league_name	varchar
commisioner	varchar
camp_session	int

participant Table
participant_id	int
lname	varchar
fname	varchar
street	varchar
city	varchar
state	varchar
zip	varchar
home_phone	varchar
day_phone	varchar
email	varchar
age	tinyint
shirt_size	varchar
entering_grade	varchar
home_coach	varchar
year	year
camp_session	int
school	varchar
team_id (fk)	int
height_feet	int
height_inches	int
status	varchar

resident Table
resident_id	int
participant_id (fk)	int
room_ext	varchar
assigned_roommate_id	int
room_number	varchar
dorm	varchar
roommate_pref_lname_1	varchar
roommate_pref_fname_1	varchar
roommate_pref_lname_2	varchar
roommate_pref_fname_2	varchar
roommate_pref_lname_3	varchar
roommate_pref_fname_3	varchar
pair_id	int

system_vars Table
id	int	1
resident_cost	int	325
daycost	int	275
discount	int	25
both_discount	int	50
deposit	int	100
discount_date	int	2003-04-30

team Table
team_id	int
league_id (fk)	int
team_name	varchar
wins	varchar
losses	varchar
coach1	varchar
coach2	varchar
camp_session	int

transaction Table
transaction_id	int
bank_id (fk)	int
transaction	varchar
amount	double