Cacher is the code snippet organizer for pro developers

CREATE TABLE `application` (
  `fafsa_id` varchar(100) DEFAULT NULL,
  `last_name` varchar(25) DEFAULT NULL,
  `first_name` varchar(25) DEFAULT NULL,
  `middle_initial` varchar(5) DEFAULT NULL,
  `street_address` varchar(35) DEFAULT NULL,
  `city` varchar(16) DEFAULT NULL,
  `mailing_state` varchar(5) DEFAULT NULL,
  `zip_code` varchar(25) DEFAULT NULL,
  `social_security_number` varchar(15) DEFAULT NULL,
  `date_of_birth` varchar(8) DEFAULT NULL,
  `students_permanent_telephone_number` varchar(15) DEFAULT NULL,
  `students_drivers_license_number` varchar(25) DEFAULT NULL,
  `students_drivers_license_state` varchar(5) DEFAULT NULL,
  `students_email_address` varchar(350) DEFAULT NULL,
  `citizenship` int(9) DEFAULT NULL,
  `alien_registration_number` varchar(10) DEFAULT NULL,
  `students_marital_status` varchar(2) DEFAULT NULL,
  `students_marital_status_date` varchar(8) DEFAULT NULL,
  `students_state_of_legal_residence` varchar(2) DEFAULT NULL,
  `student_legal_resident_before_010108` varchar(2) DEFAULT NULL,
  `students_legal_residence_date` varchar(2) DEFAULT NULL,
  `are_you_male_or_female` varchar(2) DEFAULT NULL,
  `selective_service_registration` varchar(2) DEFAULT NULL,
  `drug_conviction_affecting_eligibility` varchar(2) DEFAULT NULL,
  `fathers_highest_educational_level` varchar(2) DEFAULT NULL,
  `mothers_highest_educational_or_equivalent` varchar(2) DEFAULT NULL,
  `high_school_diploma_or_equivalent` varchar(2) DEFAULT NULL,
  `high_school_name` varchar(50) DEFAULT NULL,
  `high_school_city` varchar(28) DEFAULT NULL,
  `high_school_state` varchar(2) DEFAULT NULL,
  `bachelors_degree` varchar(2) DEFAULT NULL,
  `grade_level_in_college` varchar(2) DEFAULT NULL,
  `degreecertificate` varchar(2) DEFAULT NULL,
  `interested_in_receiving_workstudy` varchar(2) DEFAULT NULL,
  `students_tax_return_status` varchar(2) DEFAULT NULL,
  `students_type_of_tax_return` varchar(2) DEFAULT NULL,
  `student_eligible_for_1040aez` varchar(2) DEFAULT NULL,
  `students_agi` varchar(6) DEFAULT NULL,
  `students_taxes_paid` varchar(5) DEFAULT NULL,
  `students_exemptions` varchar(2) DEFAULT NULL,
  `students_income` varchar(6) DEFAULT NULL,
  `spouses_income` varchar(6) DEFAULT NULL,
  `students_cash_savings_and_checking` varchar(6) DEFAULT NULL,
  `students_real_estateinvestment_6_worth` varchar(6) DEFAULT NULL,
  `students_businessfarm_net_6_worth` varchar(6) DEFAULT NULL,
  `students_education_credits` varchar(5) DEFAULT NULL,
  `students_child_support_paid` varchar(5) DEFAULT NULL,
  `students_needbased_employment` varchar(5) DEFAULT NULL,
  `students_grantscholarship_aid` varchar(5) DEFAULT NULL,
  `students_combat_pay` varchar(5) DEFAULT NULL,
  `students_coop_earnings` varchar(5) DEFAULT NULL,
  `students_pension_payments` varchar(5) DEFAULT NULL,
  `students_ira_payments` varchar(5) DEFAULT NULL,
  `students_child_support_received` varchar(5) DEFAULT NULL,
  `students_interest_income` varchar(5) DEFAULT NULL,
  `students_ira_distributions` varchar(5) DEFAULT NULL,
  `students_untaxed_pensions` varchar(5) DEFAULT NULL,
  `students_miliaryclergy_allowances` varchar(5) DEFAULT NULL,
  `students_veterans_noneducation_benefits` varchar(5) DEFAULT NULL,
  `students_other_untaxed_income` varchar(5) DEFAULT NULL,
  `students_other_nonreported_money_received` varchar(5) DEFAULT NULL,
  `born_before_1190` varchar(2) DEFAULT NULL,
  `is_student_married` varchar(2) DEFAULT NULL,
  `graduate_or_professional_student` varchar(2) DEFAULT NULL,
  `active_duty_military` varchar(2) DEFAULT NULL,
  `veteran_status` varchar(2) DEFAULT NULL,
  `do_you_have_children` varchar(2) DEFAULT NULL,
  `dependents_other_than_children__spouse` varchar(2) DEFAULT NULL,
  `orphan_or_ward_of_the_court` varchar(2) DEFAULT NULL,
  `emancipated_minor` varchar(2) DEFAULT NULL,
  `in_legal_guardianship` varchar(2) DEFAULT NULL,
  `homeless_youth_determined_by_school` varchar(2) DEFAULT NULL,
  `homeless_youth_detemined_by_hud` varchar(2) DEFAULT NULL,
  `at_risk_of_homelessness` varchar(2) DEFAULT NULL,
  `parents_marital_status` varchar(2) DEFAULT NULL,
  `parents_marital_status_date` varchar(8) DEFAULT NULL,
  `fathers_ssn` varchar(6) DEFAULT NULL,
  `fathers_last_name` varchar(9) DEFAULT NULL,
  `fathers_first_initial` varchar(16) DEFAULT NULL,
  `fathers_date_of_birth` varchar(8) DEFAULT NULL,
  `mothers_ssn` varchar(9) DEFAULT NULL,
  `mothers_last_name` varchar(16) DEFAULT NULL,
  `mothers_first_initial` varchar(2) DEFAULT NULL,
  `mothers_date_of_birth` varchar(8) DEFAULT NULL,
  `parents_email_address` varchar(50) DEFAULT NULL,
  `parents_state_of_legal_residence` varchar(2) DEFAULT NULL,
  `parents_legal_residents_before_1_1108` varchar(2) DEFAULT NULL,
  `parents_legal_residence_date` varchar(8) DEFAULT NULL,
  `parents_number_of_family_members` varchar(2) DEFAULT NULL,
  `parents_number_in_college` varchar(2) DEFAULT NULL,
  `parents_ssi_benefits` varchar(2) DEFAULT NULL,
  `parents_snap_benefits` varchar(2) DEFAULT NULL,
  `parents_freereduced_price_lunch` varchar(2) DEFAULT NULL,
  `parents_tanf_benefits` varchar(2) DEFAULT NULL,
  `parents_wic_benefits` varchar(2) DEFAULT NULL,
  `parents_tax_return_status` varchar(2) DEFAULT NULL,
  `parents_type_of_tax_return` varchar(2) DEFAULT NULL,
  `parents_eligible_for_1040aez` varchar(2) DEFAULT NULL,
  `parent_dislocated_worker` varchar(2) DEFAULT NULL,
  `parents_agi` varchar(6) DEFAULT NULL,
  `parents_taxes_paid` varchar(6) DEFAULT NULL,
  `parents_exemptions` varchar(2) DEFAULT NULL,
  `fathers_income` varchar(6) DEFAULT NULL,
  `mothers_income` varchar(6) DEFAULT NULL,
  `parents_cash_savings_and_checking` varchar(6) DEFAULT NULL,
  `parents_real_estateinvestment_net_worth` varchar(6) DEFAULT NULL,
  `parents_businessfarm_net_worth` varchar(6) DEFAULT NULL,
  `parents_education_credits` varchar(6) DEFAULT NULL,
  `parents_child_support_paid` varchar(5) DEFAULT NULL,
  `parents_needbased_employment` varchar(5) DEFAULT NULL,
  `parents_grantscholarship_aid` varchar(5) DEFAULT NULL,
  `parents_combat_pay` varchar(5) DEFAULT NULL,
  `parents_coop_earnings` varchar(5) DEFAULT NULL,
  `parents_pension_payments` varchar(5) DEFAULT NULL,
  `parents_ira_payments` varchar(5) DEFAULT NULL,
  `parents_child_support_received` varchar(5) DEFAULT NULL,
  `parents_interest_income` varchar(5) DEFAULT NULL,
  `patents_ira_distributions` varchar(5) DEFAULT NULL,
  `parents_untaxed_pensions` varchar(5) DEFAULT NULL,
  `parents_miliaryclergy_5_allowances` varchar(5) DEFAULT NULL,
  `parents_veterans_5_noneducation_benefits` varchar(5) DEFAULT NULL,
  `parents_other_untaxed_income` varchar(5) DEFAULT NULL,
  `students_number_of_family_members` varchar(2) DEFAULT NULL,
  `students_number_in_college` varchar(2) DEFAULT NULL,
  `students_ssi_benefits` varchar(2) DEFAULT NULL,
  `students_snap_benefits` varchar(2) DEFAULT NULL,
  `students_freereduced_price_lunch` varchar(2) DEFAULT NULL,
  `students_tanf_benefits` varchar(2) DEFAULT NULL,
  `students_wic_benefits` varchar(2) DEFAULT NULL,
  `studentspouse_dislocated_worker` varchar(2) DEFAULT NULL,
  `college_choices` text,
  `housing_plans` text,
  `date_completed` varchar(8) DEFAULT NULL,
  `signed_by` varchar(2) DEFAULT NULL,
  `parents_asset_threshold_exceeded` varchar(2) DEFAULT NULL,
  `students_asset_threshold_exceeded` varchar(100) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=9875 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;