GRE Stats - Laravel Schema Designer

Schools

id increments
name string (200)
address text
phone string
city string (60)
state string (50)
country string (70)
website string (80)
is_public boolean
total_faculty integer
total_students integer
total_grad_students integer
full_instate_tuition mediumInteger
full_outstate_tuition mediumInteger
instate_per_credit mediumInteger
outstate_per_credit mediumInteger
credits_for_fulltime tinyInteger
tuition_waivers mediumInteger
have_domestic_loans boolean
have_int_loans boolean

Departments

id increments
school_id ^FK integer
name string (90)
address text
phone string (20)
chair_name string (40)
chair_email string (80)
contact_name string (40)
contact_email string (80)
total_full_faculty tinyInteger
total_faculty smallInteger
total_grad_students mediumInteger
total_postdocs smallInteger
total_firstyears smallInteger
total_firstyear_female tinyInteger
website text
dom_app_deadline string (100)
int_app_deadline string (100)
app_fee smallInteger
int_app_fee mediumInteger
need_gre boolean
need_subj_gre tinyInteger
min_gpa float
app_data_year mediumInteger
apps mediumInteger
admits mediumInteger
enrolled mediumInteger
need_toefl boolean
min_pbt mediumInteger
min_ibt mediumInteger
min_quant_gre mediumInteger
min_verb_gre mediumInteger
min_writ_gre mediumInteger
avg_quant_gre mediumInteger
avg_verb_gre mediumInteger
avg_writ_gre mediumInteger
min_subj_gre mediumInteger
avg_subj_gre mediumInteger
notes text

Programs

id increments
school_id ^FK integer
department_id ^FK integer
degree_type tinyInteger
avg_ta_stipend mediumInteger
avg_ra_stipend mediumInteger
avg_fellow_stipend mediumInteger
stipend_notes text
requirements text
other_info text
field string (120)

Applications

id increments
user_id ^FK integer
program_id ^FK integer
season_id mediumInteger
status tinyInteger
stipend mediumInteger

User_Profiles

id increments
gre_taken boolean
date_to_take_gre date
what_sub_gre tinyInteger
date_to_take_sub date
email string (100)
registered boolean
gpa float
gre smallInteger
sub_gre smallInteger
country string (100)
city string (50)
year mediumInteger
major string (20)
work_experience tinyInteger
research_experience tinyInteger
gender tinyInteger
anonymity tinyInteger

Users

id increments
username string (15)
email string (50)
password string (60)
password_temp string (60)
is_admin boolean
code string (60)
active integer

Comments

id increments
date date
user_from ^FK integer
user_to ^FK integer
body text

Messages

id increments
date date
user_from ^FK integer
user_to ^FK integer
read boolean
subject text
body text

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01