I have doubts on creating table schema. Fields are different based on Customer Income type
customer form inputs;
name, age,email,mobile, income_type (salaried, self_employed, salaried_professional)
company_name, designation, salary, salary_credited_type, salary_credited_bank, payslip, form16, form16_yrs, company_location, present_work_exp, total_work_exp, official_email, office_landline, office_address, office_landmark
biz_name, biz_location, biz_constitution, about_biz, turn_over, itr_status, itr_filed_yrs, gst_no_status, gst_no, dor,
bank_name, ac_no, ac_type
net_cross_salary, pt_deduction, epf_deduction, form16, exp_yrs, salary_credit_type, income_proof, bank_statment_months, company_name, professional_degree, valid_membership, negative_profile
I think you should structure that exactly as you've listed above, with such tables:
But then it depends on what data you would present and what DB queries you would run in the future.
Okay Thank you.