-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: May 09, 2023 at 09:24 AM
-- Server version: 10.6.5-MariaDB
-- PHP Version: 7.4.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `medicaid`
--

-- --------------------------------------------------------

--
-- Table structure for table `form_details`
--

CREATE TABLE `form_details` (
  `form_id` int(11) NOT NULL,
  `first_name` varchar(200) DEFAULT NULL,
  `last_name` varchar(200) DEFAULT NULL,
  `nursing_home_name` varchar(200) DEFAULT NULL,
  `medicaid_date` varchar(200) DEFAULT NULL,
  `medicaid_community` tinyint(100) DEFAULT NULL,
  `medicaid_id` varchar(200) DEFAULT NULL,
  `home_street_address` varchar(200) DEFAULT NULL,
  `home_street_address_line` varchar(200) DEFAULT NULL,
  `home_city` varchar(200) DEFAULT NULL,
  `home_state_region_province` varchar(200) DEFAULT NULL,
  `home_postal_zipcode` varchar(200) DEFAULT NULL,
  `snf_living` tinyint(100) DEFAULT NULL,
  `snf_prior_street_address` varchar(200) DEFAULT NULL,
  `snf_prior_street_address_line` varchar(200) DEFAULT NULL,
  `snf_prior_city` varchar(200) DEFAULT NULL,
  `snf_prior_state_region_province` varchar(200) DEFAULT NULL,
  `snf_prior_zipcode` varchar(200) DEFAULT NULL,
  `spouse` varchar(200) DEFAULT NULL,
  `demographics_veteran` varchar(200) DEFAULT NULL,
  `demographics_have` varchar(200) DEFAULT NULL,
  `demographics_filled` varchar(200) DEFAULT NULL,
  `employment_status` varchar(200) DEFAULT NULL,
  `vechicles_currently_own` varchar(100) NOT NULL DEFAULT 'no',
  `vechicles_renting` varchar(100) NOT NULL DEFAULT 'no',
  `vechicles_sold_past_five_year` varchar(100) NOT NULL DEFAULT 'no',
  `vechicles_rent_free` varchar(100) NOT NULL DEFAULT 'no',
  `vechiclesown_rental_property` varchar(100) NOT NULL DEFAULT 'no',
  `vechicles_other_land` varchar(100) NOT NULL DEFAULT 'no',
  `how_much_rent` varchar(200) DEFAULT NULL,
  `pay_for_water` varchar(200) DEFAULT NULL,
  `vechicles_equity_value` varchar(200) DEFAULT NULL,
  `vehicles_own` varchar(100) NOT NULL DEFAULT 'no',
  `vehicles_sold` varchar(100) DEFAULT 'no',
  `vehicles_na` varchar(100) NOT NULL DEFAULT 'no',
  `make_a_model` varchar(200) DEFAULT NULL,
  `fair_market` varchar(200) DEFAULT NULL,
  `vehicles_date_sold` varchar(250) DEFAULT NULL,
  `sold_property_house_address` varchar(250) DEFAULT NULL,
  `sold_property_house_fair_value` varchar(250) DEFAULT NULL,
  `sold_property_house_sale_price` varchar(250) DEFAULT NULL,
  `sold_property_house_date_sold` varchar(250) DEFAULT NULL,
  `sold_property_second_house_address` varchar(250) DEFAULT NULL,
  `sold_property_second_house_fair_value` varchar(250) DEFAULT NULL,
  `sold_property_second_house_sale_price` varchar(250) DEFAULT NULL,
  `sold_property_second_house_date_sold` varchar(250) DEFAULT NULL,
  `name_homeowners_insurance` varchar(250) DEFAULT NULL,
  `insurance_medicare` varchar(250) NOT NULL DEFAULT 'no',
  `insurance_medicare_replacement` varchar(250) NOT NULL DEFAULT 'no',
  `insurance_through_work` varchar(250) NOT NULL DEFAULT 'no',
  `insurance_medigap` varchar(250) NOT NULL DEFAULT 'no',
  `insurance_life_insurance` varchar(250) NOT NULL DEFAULT 'no',
  `insurance_none` varchar(250) NOT NULL DEFAULT 'no',
  `medicare_insurance` varchar(250) DEFAULT NULL,
  `hmo_name_id` varchar(250) DEFAULT NULL,
  `medicare_life_insurance` varchar(250) DEFAULT NULL,
  `medicare_cash_value` varchar(250) DEFAULT NULL,
  `medicare_policy` varchar(250) DEFAULT NULL,
  `social_security_income_payer` varchar(250) DEFAULT NULL,
  `social_security_income_amount` varchar(250) DEFAULT NULL,
  `social_security_income_frequency` varchar(250) DEFAULT NULL,
  `income_pension_payer_name` varchar(250) DEFAULT NULL,
  `income_pension_amount` varchar(250) DEFAULT NULL,
  `income_pension_frequency` varchar(250) DEFAULT NULL,
  `income_second_pension_payer` varchar(250) DEFAULT NULL,
  `income_second_pension_amount` varchar(250) DEFAULT NULL,
  `income_second_pension_frequency` varchar(250) DEFAULT NULL,
  `income_annuity_payer_name` varchar(250) DEFAULT NULL,
  `income_annuity_amount` varchar(250) DEFAULT NULL,
  `income_annuity_frequency` varchar(250) DEFAULT NULL,
  `income_distribution_payer` varchar(250) DEFAULT NULL,
  `income_distribution_amount` varchar(250) DEFAULT NULL,
  `income_stock_payer` varchar(250) DEFAULT NULL,
  `income_stock_amount` varchar(250) DEFAULT NULL,
  `income_stock_frequency` varchar(250) DEFAULT NULL,
  `income_trust_name` varchar(250) DEFAULT NULL,
  `income_trust_garantor` varchar(250) DEFAULT NULL,
  `income_trust_trustee` varchar(250) DEFAULT NULL,
  `income_trust_amount` varchar(250) DEFAULT NULL,
  `spouse_social_security_income_payer` varchar(250) DEFAULT NULL,
  `spouse_social_security_income_amount` varchar(250) DEFAULT NULL,
  `spouse_social_security_income_frequency` varchar(250) DEFAULT NULL,
  `spouse_income_pension_payer_name` varchar(250) DEFAULT NULL,
  `spouse_income_pension_amount` varchar(250) DEFAULT NULL,
  `spouse_income_pension_frequency` varchar(250) DEFAULT NULL,
  `spouse_income_second_pension_payer` varchar(250) DEFAULT NULL,
  `spouse_income_second_pension_amount` varchar(250) DEFAULT NULL,
  `spouse_income_second_pension_frequency` varchar(200) DEFAULT NULL,
  `spouse_income_annuity_payer_name` varchar(200) DEFAULT NULL,
  `spouse_income_annuity_amount` varchar(200) DEFAULT NULL,
  `spouse_income_annuity_frequency` varchar(200) DEFAULT NULL,
  `spouse_income_distribution_payer` varchar(100) DEFAULT NULL,
  `spouse_distribution_amount` varchar(100) DEFAULT NULL,
  `spouse_income_distribution_frequency` varchar(100) DEFAULT NULL,
  `spouse_income_stock_payer` varchar(200) DEFAULT NULL,
  `spouse_income_stock_amount` varchar(200) DEFAULT NULL,
  `spouse_income_stock_frequency` varchar(200) DEFAULT NULL,
  `spouse_income_trust_name` varchar(200) DEFAULT NULL,
  `spouse_income_trust_garantor` varchar(200) DEFAULT NULL,
  `spouse_income_trust_trustee` varchar(200) DEFAULT NULL,
  `spouse_income_trust_amount` varchar(200) DEFAULT NULL,
  `investments_stocks_company_name` varchar(100) DEFAULT NULL,
  `Investments_stocks_approx_value` varchar(100) DEFAULT NULL,
  `Investments_bonds_company_name` varchar(100) DEFAULT NULL,
  `Investments_bonds_approx_value` varchar(100) DEFAULT NULL,
  `Investments_annuity_company_name` varchar(100) DEFAULT NULL,
  `Investments_annuity_approx_value` varchar(200) DEFAULT NULL,
  `_investments_ira_company_name` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `form_details`
--
ALTER TABLE `form_details`
  ADD PRIMARY KEY (`form_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `form_details`
--
ALTER TABLE `form_details`
  MODIFY `form_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
