Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in full-screen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v payitsea_jnablr a01_set_locations
* location_id : int(11)
* location_name : varchar(50)
* order_by : tinytext
* active_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a01_set_school_code
* s_id : int(11)
* school_code : text
* location_id : int(11)
v payitsea_jnablr a01_set_school_info
* sl_id : int(11)
* trust_name : varchar(100)
* institution_name : text
* address1 : varchar(150)
* address2 : varchar(150)
* city : varchar(50)
* city_code : varchar(20)
* contact1 : varchar(12)
* contact2 : varchar(12)
* logo_1 : text
* logo_2 : text
* certified_no : varchar(20)
* certify_details : varchar(150)
* school_latitude : double
* school_longitude : double
* website : varchar(50)
* email : varchar(100)
* facebook : varchar(150)
* twitter : varchar(150)
* bank_current_ac : varchar(50)
* bank_ifsc_code : varchar(50)
* bank_name : varchar(100)
* bank_branch : varchar(100)
* bank_city : varchar(100)
* active_status : tinyint(4)
* modified_at : datetime
v payitsea_jnablr a02_set_academic_year
* yr_id : int(11)
* ac_year : varchar(10)
* start_date : date
* end_date : date
* present_year : int(11)
* default_year : int(11)
* user : int(11)
* upcoming_year : int(11)
* active_status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr a03_set_institutiontype
* inst_type_id : int(11)
* institution_type : varchar(20)
* yr_id : int(11)
* active_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a04_set_course_group
* cgroup_id : int(11)
* cgroup_name : varchar(50)
* inst_type_id : int(11)
* competitive_exam : int(11)
* user : int(11)
* status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr a05_set_course_r_batch
* course_id : int(11)
* course_name : varchar(50)
* cgroup_id : int(11)
* eclass_id : int(11)
* test_resource : int(11)
* class_resoure : int(11)
* consolidated_format : varchar(50)
* consolidate_custom : varchar(100)
* marks_card_format : varchar(50)
* marks_card_attendance : varchar(50)
* marks_card_remarks : varchar(50)
* marks_card_custom : text
* class_teacher_signature : varchar(50)
* user : int(11)
* status : tinyint(4)
* age_eligibility : tinyint(4)
* age_eligibility_in_months : smallint(6)
* page_orientation : varchar(50)
* modified_at : timestamp
v payitsea_jnablr a06_set_course_section
* section_id : int(11)
* section_name : varchar(50)
* course_id : int(11)
* class_teacher_sign : int(11)
* principal_sign : int(11)
* admin_sign : int(11)
* coordinator_sign : int(11)
* user : int(11)
* status : int(11)
* modified_at : timestamp
v payitsea_jnablr a07_set_course_r_batch_start_date
* cs_id : int(11)
* course_id : int(11)
* start_date : varchar(50)
* end_date : varchar(50)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a07_set_header_group
* hgroup_id : int(11)
* head_group : varchar(51)
v payitsea_jnablr a08_set_header
* header_id : int(11)
* hgroup_id : int(11)
* main_head : varchar(50)
* sub_head : varchar(50)
* address : varchar(50)
* contact_number : varchar(50)
* govt_approved_details : varchar(50)
* logo_one : varchar(10)
* logo_two : varchar(10)
* logo_three : varchar(10)
* modified_at : timestamp
v payitsea_jnablr a09_set_lang_compit_list
* lc_id : int(11)
* lang_compit_type : varchar(50)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a09_set_templates
* tid : int(11)
* template_name : varchar(50)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a10_set_template_module
* module_id : int(11)
* module_name : varchar(50)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a11_set_ltnwise_assign_template
* lt_id : int(11)
* location_id : int(11)
* cgroup_id : int(11)
* module_id : int(11)
* section_id : int(11)
* template_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a12_set_ltnwise_asign_exam_grp
* exam_gid : int(11)
* location_id : int(11)
* location : varchar(50)
* section_id : int(11)
* pa_group_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr a13_set_ltnwise_asign_course_sec_grp
* course_grp_id : int(11)
* location_id : int(11)
* location : varchar(50)
* section_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a14_set_ltnwise_asign_header
* head_gid : int(11)
* location_id : int(11)
* location : varchar(50)
* header_id : int(11)
* section_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a15_set_ltnwise_asign_exam_grade_grp
* gd_gid : int(11)
* location_id : int(11)
* location : varchar(50)
* section_id : int(11)
* gradem_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a15_set_ltnwise_asign_exam_grade_grp_part_b
* pb_gd_gid : int(11)
* location_id : int(11)
* location : varchar(50)
* section_id : int(11)
* pb_gradem_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a16_set_ltnwise_asign_fee_grp
* fee_gid : int(11)
* location_id : int(11)
* location : varchar(50)
* section_id : int(11)
* feegp_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a17_set_ltnwise_remove_mob_menu
* rmid : int(11)
* location_id : int(11)
* cgroup_id : int(11)
* menu_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr a18_set_ltnwise_asign_school_info
* l_sclid : int(11)
* location_id : int(11)
* location : varchar(50)
* sl_id : int(11)
* course_id : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr aa01_payroll_shift
* shift_id : int(11)
* shift_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa01_payroll_shift_cron
* cron_id : int(11)
* last_update_date : datetime
v payitsea_jnablr aa02_payroll_shift_details
* sd_id : int(11)
* days : varchar(50)
* start_time : time
* end_time : time
* excuse : time
* weekend : tinyint(4)
* shift_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa03_payroll_shift_halfday_value
* hd_id : int(11)
* value : time
* shift_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa04_payroll_salary_group
* sg_id : int(11)
* salary_group_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa05_payroll_salary_group_earnings
* sge_id : int(11)
* earnings : varchar(50)
* type : varchar(10)
* sg_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa06_payroll_salary_group_earnings_value
* sgev_id : int(11)
* value : decimal(10,2)
* effective_date : date
* sge_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa07_payroll_salary_group_deductions
* sgd_id : int(11)
* deductions : varchar(50)
* type : varchar(10)
* sg_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa08_payroll_salary_group_deductions_value
* sgdv_id : int(11)
* value : decimal(10,2)
* effective_date : date
* sgd_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa09_payroll_salary_group_tax
* sgt_id : int(11)
* tax : varchar(50)
* value_from : int(11)
* value_to : int(11)
* sg_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa10_payroll_salary_group_tax_value
* sgtv_id : int(11)
* value : decimal(10,2)
* effective_date : date
* sgd_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa11_payroll_salary_advance
* sa_id : int(11)
* emp_id : int(11)
* amount : decimal(10,2)
* payment_mode : varchar(6)
* effective_date : date
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa12_payroll_basic_salary
* bs_id : int(11)
* emp_id : int(11)
* salary_increment : decimal(10,2)
* effective_date : date
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa13_payroll_public_holidays
* ph_id : int(11)
* public_holiday : varchar(100)
* holiday_date : date
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa14_payroll_leave_types
* lt_id : int(11)
* leave_type : varchar(50)
* short_name : varchar(10)
* valid_from : date
* carry_forward : enum('Y','N')
* max_leave : int(11)
* monthly_limit : int(11)
* description : text
* active_status : tinyint(1)
* delete_status : tinyint(1)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa15_payroll_assign_shifts
* as_id : int(11)
* empid : int(11)
* shift_id : int(11)
* shift_effective_start_date : date
* shift_effective_end_date : date
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr aa16_payroll_emp_leave_details
* eld_id : int(11)
* empid : int(11)
* attend_date : date
* login : datetime
* logout : datetime
* lt_id : int(11)
* short_name : varchar(50)
* value : decimal(10,1)
* pr_location_id : int(11)
* delete_status : tinyint(4)
* approve_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr aa17_payroll_date_settings
* pd_id : int(11)
* start_date : date
* end_date : date
* delete_status : tinyint(4)
* approve_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr aa18_payroll_weekends
* w_id : int(11)
* weekend_date : date
* pd_id : int(11)
* shift_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr aa19_payroll_report_formats
* rf_id : int(11)
* format_type : varchar(50)
* format_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr add_new_occupation
* occupation_id : int(11)
* occupation_name : varchar(50)
v payitsea_jnablr app_settings
* settings_id : int(11)
* description : varchar(200)
* settings_type : varchar(200)
* format : varchar(200)
* additional_info : varchar(200)
* current_value : int(11)
v payitsea_jnablr attendancelog
* DeviceLogId : int(11)
* DeviceId : int(11)
* Card_No : varchar(250)
* AttnDate : date
* AttnTime : datetime
* FunctionCode : varchar(2000)
* DownloadDate : datetime
* Status : tinyint(4)
* processed : tinyint(4)
v payitsea_jnablr attendancelog_bck
* DeviceLogId : int(11)
* DeviceId : int(11)
* Card_No : varchar(250)
* AttnDate : date
* AttnTime : datetime
* FunctionCode : varchar(2000)
* DownloadDate : datetime
* Status : varchar(2)
v payitsea_jnablr attendance_login_details
* Card_No : tinyint(4)
* AttnDate : tinyint(4)
* Login : tinyint(4)
* FunctionCode : tinyint(4)
* DeviceID : tinyint(4)
* short_name : tinyint(4)
* value : tinyint(4)
v payitsea_jnablr attendance_logout_details
* Card_No : tinyint(4)
* AttnDate : tinyint(4)
* Logout : tinyint(4)
* FunctionCode : tinyint(4)
* DeviceID : tinyint(4)
* short_name : tinyint(4)
* value : tinyint(4)
v payitsea_jnablr b01_set_exam_parta_group
* pa_group_id : int(11)
* group_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b01_set_exam_parta_terms
* terms_id : int(11)
* terms : varchar(50)
* pa_group_id : int(11)
* added_by : int(11)
* delete_status : tinyint(4)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b02_set_exam_parta_mainactivity
* pa_macty_id : int(11)
* mainactivity : varchar(50)
* format : varchar(20)
* category : varchar(20)
* terms_id : int(11)
* ecat_id : int(11)
* exam_end_date : date
* publish_status : tinyint(4)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr b03_set_exam_parta_mainsubject
* pa_msubject_id : int(11)
* main_subject : varchar(50)
* pa_macty_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b04_set_exam_parta_coresubject
* pa_coresubject_id : int(11)
* core_subject : varchar(50)
* pa_msubject_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr b05_set_exam_parta_subactivity
* pa_sacty_id : int(11)
* subactivity : varchar(50)
* max_mark : int(11)
* convert_percent : int(11)
* pa_coresubject_id : int(11)
* omr_exam_id : int(11)
* entry_type : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b06_set_exam_partbcd_type
* pb_type_id : int(11)
* pbexam_type : varchar(50)
* pa_macty_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : datetime
* modified_at : timestamp
v payitsea_jnablr b07_set_exam_partb_subjects
* pbcd_sub_id : int(11)
* pbcd_subjects : varchar(50)
* pb_type_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b08_set_exam_partbcd_activity
* pb_acty_id : int(11)
* pbcd_sub_id : int(11)
* pbactivity : varchar(50)
* max_mark : int(11)
* convertion : int(11)
* entry_type : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b09_set_exam_grade_method
* gradem_id : int(11)
* grade_method : varchar(20)
* modified_at : timestamp
v payitsea_jnablr b09_set_exam_grade_method_part_b
* pb_gradem_id : int(11)
* pb_grade_method : varchar(20)
* modified_at : timestamp
v payitsea_jnablr b09_set_exam_grade_method_view
* gradem_id : tinyint(4)
* grade_method : tinyint(4)
v payitsea_jnablr b10_set_exam_grade_details
* grade_id : int(11)
* percent_from : decimal(10,2)
* percent_to : decimal(10,2)
* grade : varchar(5)
* details : varchar(50)
* remarks : varchar(100)
* gradem_id : int(11)
* grade_cal_id : int(11)
* modified_at : timestamp
v payitsea_jnablr b10_set_exam_grade_details_part_b
* pb_grade_id : int(11)
* pb_percent_from : decimal(10,2)
* pb_percent_to : decimal(10,2)
* pb_grade : varchar(5)
* pb_details : varchar(50)
* pb_gradem_id : int(11)
* pb_grade_cal_id : int(11)
* modified_at : timestamp
v payitsea_jnablr b10_set_exam_grade_details_view
* grade_id : tinyint(4)
* percent_from : tinyint(4)
* percent_to : tinyint(4)
* grade : tinyint(4)
* details : tinyint(4)
* remarks : tinyint(4)
* gradem_id : tinyint(4)
* grade_cal_id : tinyint(4)
v payitsea_jnablr b11_set_compit_exam_master
* cem_id : int(11)
* compit_exam : varchar(50)
* ecat_id : int(11)
v payitsea_jnablr b12_set_class_timetable_subject
* sub_id : int(11)
* subject : varchar(100)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b12_set_timetable_exams
* tt_exam_id : int(11)
* tt_exam_name : varchar(100)
* section_id : int(11)
* instruction : text
* verify_status : tinyint(4)
* publish_by : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr b12_set_timetable_exam_details
* tt_exam_did : int(11)
* tt_exam_id : int(11)
* tt_exam_sub_id : int(11)
* tt_exam_date : date
* tt_exam_time : varchar(50)
* section_id : int(11)
* verify_status : tinyint(4)
* publish_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b12_set_timetable_exam_subject
* exam_sub_id : int(11)
* exam_subject : varchar(100)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr b12_set_timetable_notes
* tt_notes_id : int(11)
* tt_notes : text
* section_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr c01_aca_student_abstract_certificate
* a_id : int(11)
* ref_number : varchar(50)
* sid : int(11)
* issued_date : datetime
* issued_by : int(11)
* added_by : int(11)
* added_at : datetime
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c01_aca_student_basic_details
* sid : int(11)
* chatid : varchar(15)
* roll_number : varchar(50)
* admission_number : varchar(50)
* sts_number : varchar(50)
* first_name : varchar(150)
* last_name : varchar(150)
* date_of_birth : date
* blood_group_id : int(11)
* gender : int(11)
* nationality_id : int(11)
* religion_id : int(11)
* caste_id : int(11)
* sub_caste_id : int(11)
* caste_category_id : int(11)
* father_guardian_name : varchar(50)
* father_guardian_qualification : varchar(20)
* father_guardian_occupation : varchar(20)
* mother_name : varchar(50)
* mother_qualification : varchar(50)
* mother_occupation : varchar(50)
* whatsapp_number : varchar(15)
* whatsapp_number_new : varchar(15)
* contact_one : varchar(15)
* contact_two : varchar(15)
* email_address : varchar(50)
* address_one : varchar(150)
* address_two : varchar(150)
* city : varchar(50)
* zipcode : varchar(50)
* country_code : int(11)
* student_image : text
* std_profile_image : text
* facility : text
* previous_institution : text
* mode_of_transport : int(11)
* user_id : varchar(15)
* password : varchar(15)
* account_number : varchar(50)
* bank_name : varchar(50)
* ifsc_code : varchar(50)
* mob_app_permit : int(11)
* eclass_id : varchar(10)
* menu_type_id : int(11)
* active_status : tinyint(4)
* sibling_id : varchar(50)
* sibling_id_1 : int(11)
* pr_location_id : int(11)
* pr_location_name : varchar(30)
* pr_yr_id : int(11)
* pr_ac_year : varchar(50)
* pr_inst_type_id : int(11)
* pr_institution_type : varchar(30)
* pr_cgroup_id : int(11)
* pr_cgroup_name : varchar(30)
* pr_course_id : int(11)
* pr_course_name : varchar(30)
* pr_section_id : int(11)
* pr_section_name : varchar(30)
* mobile_permission : int(11)
* added_by : int(11)
* device_type : varchar(250)
* device_token : text
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
* lang_compit_type : varchar(50)
* omrexamtype : varchar(50)
v payitsea_jnablr c01_aca_student_study_certificate
* c_id : int(11)
* ref_number : varchar(50)
* sid : int(11)
* issued_date : datetime
* issued_by : int(11)
* added_by : int(11)
* added_at : datetime
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c01_aca_student_transfer_certificate
* tc_id : int(11)
* tc_number : varchar(50)
* sid : int(11)
* sc_st : int(11)
* higher_standard_status : tinyint(4)
* promotion_std : int(11)
* current_std : int(11)
* languages_studied : varchar(50)
* medium_of_instruction : varchar(50)
* elective_paper : varchar(50)
* physically_challenged : int(11)
* last_attendance_date : date
* tc_application_date : date
* date_of_admission : date
* transfer_certificate_issue_date : date
* number_of_working_days : int(11)
* number_of_attendend_days : int(11)
* fee_paid_status : varchar(50)
* fee_concessions : varchar(50)
* scholarship_status : varchar(50)
* conduct : varchar(50)
* place_of_birth : varchar(50)
* student_status : varchar(50)
* tc_amount : varchar(50)
* taulk : varchar(50)
* district : varchar(50)
* state : varchar(50)
* tc_type : int(11)
* invoice_details : varchar(50)
* added_by : int(11)
* added_at : datetime
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c02_aca_student_other_details
* id : int(11)
* sid : int(11)
* old_new_id : int(11)
* feecat_id : int(11)
* section_id : int(11)
* location_id : int(11)
* yr_id : int(11)
* active_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c03_aca_student_custom_details
* id : int(11)
* sid : int(11)
* field1 : int(11)
* field2 : int(11)
* modified_at : timestamp
v payitsea_jnablr c05_aca_student_attendance_device
* id : int(11)
* sid : int(11)
* date : date
* attend_type_id : int(11)
* delete_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr c06_aca_student_attendance
* id : int(11)
* sid : int(11)
* attend_date : date
* attend_type_id : tinyint(4)
* attend_sesn_id : int(11)
* yr_id : int(11)
* section_id : int(11)
* message_send : enum('Y','N')
* delete_status : tinyint(4)
* added_by : int(11)
* sync_status : enum('Y','N')
* added_at : timestamp
* modified_at : timestamp
v payitsea_jnablr c06_aca_student_attendance_settings
* auto_absent_all : enum('Y','N')
* send_message : enum('Y','N')
* message_type : enum('SMS','WHATSAPP')
* session_wise_message : enum('Y','N')
* send_message_onsubmit : enum('Y','N')
v payitsea_jnablr c07_aca_student_apply_leave
* leave_id : int(11)
* sid : int(11)
* from_date : date
* to_date : date
* attend_type_id : int(11)
* reason : varchar(100)
* aprvd_status : tinyint(4)
* aprvd_by : int(11)
* delete_status : tinyint(4)
* yr_id : int(11)
* user : int(11)
* modified_at : datetime
* added_at : timestamp
v payitsea_jnablr c08_aca_student_attendance_verify
* vfy_id : int(11)
* verify_date : date
* verify_by : int(11)
* verify_status : tinyint(4)
* section_id : int(11)
* attend_sesn_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* is_holiday : enum('Y','N')
* user : int(11)
* created_at : timestamp
* modified_at : timestamp
v payitsea_jnablr c08_attendance_verify_calendar_employee
* vfy_id : int(11)
* verify_date : date
* verify_by : int(11)
* verify_status : tinyint(4)
* department_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr c08_attendance_verify_calendar_student
* vfy_id : int(11)
* verify_date : date
* verify_by : int(11)
* verify_status : tinyint(4)
* section_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr c10_aca_student_application
* app_id : int(11)
* reg_number : varchar(25)
* issue_date : date
* first_name : varchar(150)
* last_name : varchar(150)
* gender : int(11)
* guardian_first_name : varchar(50)
* guardian_last_name : varchar(50)
* occupation : varchar(50)
* address : text
* city : varchar(50)
* pincode : int(11)
* mobile : varchar(15)
* whatsapp : varchar(15)
* other_contact : varchar(15)
* email : varchar(100)
* fee_amount : int(11)
* category : int(11)
* dependent_details : text
* pre_inst_name : varchar(50)
* pre_inst_address : text
* acadamic_year_id : int(11)
* course_id : int(11)
* course_batch_id : int(11)
* app_fee_id : int(11)
* mode_of_transport : int(11)
* transport_route : int(11)
* note : text
* application_status : tinyint(4)
* fee_status : tinyint(4)
* fee_paid_date : datetime
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr c10_aca_student_application_online
* app_id : int(11)
* fname : varchar(150)
* gender : varchar(10)
* dob : date
* birth_place : varchar(150)
* bvillage_town : varchar(150)
* btaluk : varchar(150)
* bdistrict : varchar(150)
* m_tongue : varchar(50)
* father_name : varchar(150)
* mother_name : varchar(150)
* issue_date : date
* guardian_last_name : varchar(50)
* whatsapp_number : varchar(15)
* contact_one : varchar(15)
* contact_two : varchar(15)
* religion : varchar(50)
* caste : varchar(50)
* category : varchar(10)
* caste_belogs : varchar(10)
* b_group : varchar(10)
* syllabus : varchar(10)
* admission_class : varchar(10)
* opt_stay : varchar(15)
* std_adhaar : varchar(15)
* std_sats : varchar(15)
* std_bhagyalakshmi : varchar(15)
* allergy : varchar(15)
* illness : varchar(15)
* address : text
* address_city : varchar(50)
* address_pin : varchar(10)
* email : varchar(255)
* pre_inst_name : varchar(50)
* pre_inst_address : text
* pre_inst_city : varchar(50)
* pre_inst_pin : varchar(10)
* application_status : tinyint(4)
* transactionid : varchar(250)
* fee_status : tinyint(4)
* fee_paid_date : datetime
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c10_aca_student_application_online_payment_details
* pay_id : int(11)
* payment_id : varchar(250)
* status : varchar(150)
* currency : varchar(150)
* amount : varchar(150)
* mac : varchar(150)
* fee_paid_date : datetime
v payitsea_jnablr c11_aca_student_application_fee
* appfee_id : int(11)
* fee_amount : varchar(15)
* group_id : int(11)
* batch_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* total_number_seats : int(11)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr c12_aca_main_events
* mevent_id : int(11)
* event_name : varchar(100)
* start_date : date
* start_time : time
* end_date : date
* end_time : time
* description : varchar(50)
* attachment : varchar(100)
* remaind_date : date
* location_id : int(11)
* yr_id : int(11)
* cgroup_id : int(11)
* user : int(11)
* delete_status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr c12_aca_sub_events
* sevent_id : int(11)
* sub_event_name : varchar(100)
* sub_start_date : date
* sub_start_time : time
* sub_end_time : time
* sub_event_details : varchar(50)
* mevent_id : int(11)
* user : int(11)
* delete_status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr c13_aca_homework
* hw_id : int(11)
* homework_type : int(11)
* attachment : text
* homework_content : text
* date_of_home_work : date
* location_id : int(11)
* subject_id : int(11)
* course_id : int(11)
* course_name : varchar(50)
* section_id : int(11)
* section_name : varchar(50)
* chapter_id : int(11)
* publish_status : tinyint(4)
* publish_by : int(11)
* publish_teacher : varchar(100)
* verified_by : int(11)
* verify_status : tinyint(4)
* veryfied_date : date
* yr_id : int(11)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
* delete_status : tinyint(4)
v payitsea_jnablr c13_aca_homework_chapters
* chapter_id : int(11)
* chapter_name : varchar(100)
* subject_id : int(11)
* subject : varchar(50)
* batch_id : int(11)
* batch_name : varchar(50)
* group_id : int(11)
* group : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr c13_aca_homework_done_students
* hwdone_id : int(11)
* attachment : text
* std_id : int(11)
* hw_id : int(11)
* uploaded_at : timestamp
* correction_by : int(11)
* correction_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
* yr_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr c13_aca_homework_subject
* subject_id : int(11)
* subject_name : varchar(50)
* eclass_sub_id : int(11)
* course_id : int(11)
* status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
v payitsea_jnablr c14_aca_homework_merged_pdf
* merge_id : int(11)
* attachment : text
* hw_id : int(11)
* yr_id : int(11)
* merged_by : int(11)
* merged_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
* delete_status : tinyint(4)
v payitsea_jnablr c15_aca_circular
* cir_id : int(11)
* circular_head : varchar(200)
* attachment_path : text
* posted_date : date
* location_id : int(11)
* cgroup_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr c16_aca_public_holidays
* holiday_id : int(11)
* holiday : varchar(100)
* holiday_date : date
* h_type_id : int(11)
* section_id : int(11)
* cgroup_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* modified_at : timestamp
v payitsea_jnablr d01_exam_parta_marks_entry
* paid : int(11)
* sid : int(11)
* marks : decimal(10,1)
* pa_sacty_id : int(11)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d02_exam_partbcd_marks_entry
* pbid : int(11)
* sid : int(11)
* pb_acty_id : int(11)
* marks : decimal(4,1)
* added_by : int(11)
* modified_by : int(11)
* added_at : timestamp
* modified_at : timestamp
v payitsea_jnablr d03_exam_parta_absentees
* abid : int(11)
* sid : int(11)
* pa_sacty_id : int(11)
* absent_status : tinyint(4)
* added_by : varchar(10)
* modified_by : varchar(10)
* added_at : timestamp
* modified_at : timestamp
v payitsea_jnablr d04_exam_partb_absentees
* pbabid : int(11)
* sid : int(11)
* pb_acty_id : int(11)
* added_by : varchar(10)
* added_at : timestamp
* absent_status : tinyint(4)
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr d05_exam_health_status
* hid : int(11)
* sid : int(11)
* terms_id : int(11)
* height : float
* weight : float
* v_left : int(11)
* v_right : int(11)
* section_id : int(11)
* added_by : varchar(10)
* remarks : varchar(100)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr d05_exam_remarks_entry
* remark_id : int(11)
* sid : int(11)
* section_id : int(11)
* pa_acty_id : int(11)
* remarks : varchar(250)
* working_days : int(11)
* present_days : int(11)
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_marks_entry_history
* history_id : int(11)
* course_id : int(11)
* type : char(4)
* activity_id : int(11)
* marks_update_at : datetime
* is_consolidate_report_created : tinyint(4)
* consolidated_report_created_at : datetime
* is_progress_report_created : tinyint(4)
* progress_report_created_at : datetime
v payitsea_jnablr d05_student_achivements_entry
* achivement_id : int(11)
* sid : int(11)
* portfolio_id : int(11)
* level_id : int(11)
* position_id : int(11)
* comments : text
* achieve_date : date
* yr_id : int(11)
* added_by : int(11)
* added_at : timestamp
* remark_status : tinyint(4)
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_student_achivement_levels
* level_id : int(11)
* level_type : text
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_student_achivement_place
* position_id : int(11)
* position : text
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_student_achivement_portfolio
* portfolio_id : int(11)
* portfolio : text
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_student_remarks_category
* category_id : int(11)
* category : varchar(250)
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d05_student_remarks_entry
* remark_id : int(11)
* sid : int(11)
* category : int(11)
* remarks : text
* added_by : int(11)
* added_at : timestamp
* remark_status : tinyint(4)
* yr_id : int(11)
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr d06_exam_attendance_entry
* attendance_id : int(11)
* sid : int(11)
* section_id : int(11)
* pa_macty_id : int(11)
* working_days : varchar(250)
* present_days : varchar(250)
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr da8_co_scholastic_subjects
* sub_id : int(11)
* sub_name : varchar(250)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr da8_exam_group
* exam_group_id : int(11)
* group_name : varchar(250)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr da8_exam_type
* exam_type_id : int(11)
* exam_type : varchar(250)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr da8_scholastic_subjects
* sub_id : int(11)
* sub_name : varchar(250)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modeified_by : int(11)
* modified_at : datetime
v payitsea_jnablr devices
* DeviceId : int(11)
* DeviceName : varchar(250)
* IPAddress : varchar(250)
* CommPassword : varchar(100)
* SerialNumber : varchar(100)
* Location : varchar(250)
* PingDelay : int(11)
* TransactionTimestamp : varchar(100)
* UserTimestamp : varchar(100)
* DeleteTimestamp : varchar(100)
* LastPingTimestamp : varchar(100)
* TimeZoneDiffMins : int(11)
v payitsea_jnablr e01_set_online_fee_group
* feegp_id : int(11)
* fee_group : varchar(50)
* is_transport_fee : enum('Y','N')
* receipt_header : varchar(150)
* account_number : varchar(50)
* ifsc : varchar(50)
* modified_at : timestamp
v payitsea_jnablr e02_set_fee_feecategory
* feecatid : int(11)
* fee_category : varchar(50)
* status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr e02_set_online_fee_mainfee
* mfee_id : int(11)
* main_fee : varchar(50)
* feegp_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr e03_set_online_fee_payout_accounts
* pac_id : int(11)
* account_name : varchar(100)
* account_number : varchar(50)
* ifsc_code : varchar(50)
* bank_name : varchar(50)
* delete_status : tinyint(4)
v payitsea_jnablr e03_set_online_fee_payout_splitdetails
* psplit_id : int(11)
* account_numberid : varchar(50)
* paid_date : date
* amount : double
* added_by : smallint(6)
* added_at : datetime
* modified_by : smallint(6)
* modified_at : datetime
v payitsea_jnablr e03_set_online_fee_subfee
* sfee_id : int(11)
* sub_fee : varchar(50)
* mfee_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr e04_set_online_fee_feecategory
* feecat_id : int(11)
* fee_category : varchar(50)
* sfee_id : int(11)
* status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr e05_set_fee_monthly_fee
* mfeetypeid : int(11)
* mfee_type : varchar(50)
* no_of_months : int(11)
* months_start : int(11)
* feegp_id : int(11)
* status : tinyint(4)
* modified_at : timestamp
v payitsea_jnablr e06_set_fee_months
* monthid : int(11)
* months : varchar(50)
* modified_at : timestamp
v payitsea_jnablr e07_set_fee_monthlyfee_master
* mfeealotid : int(11)
* old_new : int(11)
* gender_id : int(11)
* feecatid : int(11)
* section_id : int(11)
* amount : int(11)
* modified_at : timestamp
v payitsea_jnablr e08_set_fee_hostelfee
* hfeetypeid : int(11)
* hfee_type : varchar(50)
* delete_status : tinyint(4)
* add_by : int(11)
* add_at : datetime
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr e08_set_fee_hostel_min_day_calc
* min_id : int(11)
* number_of_days : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr e09_set_fee_hostelfee_master
* hfeealotid : int(11)
* old_new : int(11)
* gender_id : int(11)
* feecatid : int(11)
* section_id : int(11)
* amount : int(11)
* modified_at : timestamp
v payitsea_jnablr e10_assign_hostel_to_students
* assign_id : int(11)
* student_id : int(11)
* hostel_type_id : int(11)
* room_id : varchar(250)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* delete_status : tinyint(4)
* modified_at : datetime
v payitsea_jnablr e10_set_hostel_master
* hostel_id : int(11)
* hostel_type : varchar(60)
* room_number : int(11)
* warden_name : varchar(250)
* supervision : varchar(250)
* warden_contact : varchar(250)
* supervision_contact : varchar(250)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* delete_status : tinyint(4)
* modified_at : datetime
v payitsea_jnablr e10_set_online_fee_hostelfee_std_allot
* hallot_id : int(11)
* sid : int(11)
* section_id : int(11)
* modified_at : timestamp
v payitsea_jnablr e11_set_fee_individual_fee
* indfeetypeid : int(11)
* indfee_type : varchar(50)
* fee_start_date : date
* fee_due_Date : date
* add_by : int(11)
* add_at : datetime
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e13_set_fee_individual_fee_assign_class
* fee_id : int(11)
* group_id : int(11)
* class_id : int(11)
* individual_fee_id : int(11)
* fee_category_id : int(11)
* old_boy_amount : varchar(50)
* old_girl_amount : varchar(50)
* new_boy_amount : varchar(50)
* new_girl_amount : varchar(50)
* assign_to_all : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e13_set_hostel_fee_assign_class
* fee_id : int(11)
* group_id : int(11)
* class_id : int(11)
* hostel_fee_id : int(11)
* fee_category_id : int(11)
* old_boy_amount : varchar(50)
* old_girl_amount : varchar(50)
* new_boy_amount : varchar(50)
* new_girl_amount : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e13_set_monthly_fee_assign_class
* fee_id : int(11)
* group_id : int(11)
* course_id : int(11)
* fee_monthly_type_id : int(11)
* feecatid : int(11)
* old_boy_amount : varchar(50)
* old_girl_amount : varchar(50)
* new_boy_amount : varchar(50)
* new_girl_amount : varchar(50)
* num_of_month : varchar(50)
* month_starts : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e13_set_online_fee_assign_feeto_class
* afee_id : int(11)
* sfee_id : int(11)
* course_id : int(11)
* feecat_id : int(11)
* old_new : varchar(50)
* boy_girl : varchar(50)
* amount : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e14_set_fee_individaul_fee_std_allot
* indfeealotid : int(11)
* sid : int(11)
* indfeeid : int(11)
* section_id : int(11)
* modified_at : timestamp
v payitsea_jnablr e15_set_online_fee_transport_group
* tgroup_id : int(11)
* group_name : varchar(50)
* location_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr e16_set_fee_transport_min_day_calc
* min_id : int(11)
* number_of_days : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr e17_set_fee_transport_months
* month_id : int(11)
* month_name : varchar(20)
* delete_status : tinyint(4)
v payitsea_jnablr e18_set_online_fee_transport_area
* tarea_id : int(11)
* area_name : varchar(50)
* group_id : int(11)
* delete_status : tinyint(4)
* user : int(11)
v payitsea_jnablr e19_set_online_fee_transport_area_amount
* areaamt_id : int(11)
* one_two_way : int(11)
* month_year_amt : varchar(50)
* tarea_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e20_set_online_fee_transport_assign_student
* assn_id : int(11)
* sid : int(11)
* tarea_id : int(11)
* up_and_down : int(11)
* start_date : date
* inactive_date : date
* changed_area_count : int(11)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr e21_fee_transcations
* feetrn_id : int(11)
* receipt_no : int(11)
* transcation_no : int(11)
* sid : int(11)
* fee_id : int(11)
* is_hostal_or_transport : int(11)
* fee_desc_type : int(11)
* fee_amount : int(11)
* received_date : date
* year : int(11)
* user : int(11)
* added_at : timestamp
* modified_at : timestamp
v payitsea_jnablr e22_fee_concession
* c_id : int(11)
* fee_id : int(11)
* is_hostal_or_transport : int(11)
* concession_amount : int(11)
* added_at : date
* year : int(11)
* added_by : int(11)
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr f01_set_aca_bloodgroup
* blood_group_id : int(11)
* blood_group : varchar(50)
v payitsea_jnablr f02_set_aca_gender
* gender_id : int(11)
* gender : varchar(50)
* atype : varchar(10)
* delete_status : tinyint(4)
v payitsea_jnablr f03_set_aca_caste
* caste_id : int(11)
* caste : varchar(50)
v payitsea_jnablr f04_set_aca_sub_caste
* sub_caste_id : int(11)
* caste_id : int(11)
* subcaste : varchar(50)
v payitsea_jnablr f05_set_aca_caste_category
* caste_category_id : int(11)
* caste_category : varchar(50)
v payitsea_jnablr f07_set_aca_oldnew
* old_new_id : int(11)
* old_new : varchar(10)
v payitsea_jnablr f08_set_aca_nationality
* nationality_id : int(11)
* nationality : varchar(10)
v payitsea_jnablr f09_set_aca_religion
* religion_id : int(11)
* religion : varchar(10)
v payitsea_jnablr f10_set_aca_attendance_sessions
* attend_sesn_id : int(11)
* session_type : varchar(50)
* att_short_name : varchar(50)
* week_day : varchar(5)
* attend_value : decimal(10,2)
* batch_id : int(11)
* order_no : tinyint(4)
* delete_status : tinyint(4)
v payitsea_jnablr f10_set_aca_attendance_value
* attend_type_id : tinyint(11)
* attend_type : varchar(10)
* attend_value : decimal(10,1)
v payitsea_jnablr f11_set_aca_attendance_data_fetch_type
* data_fetch_id : int(11)
* data_fetch_type : varchar(10)
v payitsea_jnablr f12_set_aca_mobile_app_type
* appt_id : int(11)
* app_type : varchar(25)
v payitsea_jnablr f12_set_aca_mobile_menu
* menu_id : int(11)
* display_name : varchar(25)
v payitsea_jnablr f13_set_aca_set_mobile_assign_menu
* amenu_id : int(11)
* menu_id : int(11)
* appt_id : int(11)
v payitsea_jnablr g01_set_emp_category
* empcatid : int(11)
* emp_category : varchar(50)
* short_name : tinytext
* active_status : tinyint(1)
* modified_at : timestamp
v payitsea_jnablr g02_set_emp_position
* pstnid : int(11)
* position : varchar(50)
* empcatid : int(11)
* active_status : tinyint(1)
* modified_at : timestamp
v payitsea_jnablr g03_set_emp_department
* deptid : int(11)
* emp_department : varchar(50)
* active_status : tinyint(1)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr h01_emp_basic_details
* empid : int(11)
* chatid : varchar(15)
* role : varchar(50)
* first_name : varchar(50)
* last_name : varchar(50)
* date_of_birth : date
* designation : varchar(50)
* department : varchar(50)
* date_of_joining : date
* confirmation_date : date
* employement_status : varchar(50)
* teaching_experience : varchar(50)
* other_experience : varchar(50)
* notice_period : varchar(50)
* unique_id : varchar(50)
* biometric_id : varchar(50)
* languages_known : varchar(50)
* languages_type : varchar(50)
* blood_group_id : int(11)
* religion_id : int(11)
* caste_id : int(11)
* gender_id : int(11)
* sub_caste_id : int(11)
* caste_category_id : int(11)
* father_guardian_name : varchar(50)
* father_guardian_qualification : varchar(50)
* father_guardian_occupation : varchar(50)
* mother_name : varchar(50)
* mother_qualification : varchar(50)
* mother_occupation : varchar(50)
* account_number : varchar(50)
* bank_name : varchar(50)
* ifsc_code : varchar(50)
* facility : varchar(50)
* com_address_one : varchar(150)
* com_address_two : varchar(150)
* com_city : varchar(50)
* com_zipcode : mediumint(9)
* country_code : int(11)
* marital_status : varchar(50)
* qualification : varchar(50)
* whatsapp_number : varchar(15)
* contact_one : varchar(15)
* contact_two : varchar(15)
* email_address : varchar(100)
* address_one : varchar(150)
* address_two : varchar(150)
* city : varchar(50)
* zipcode : varchar(50)
* submenu_permition : varchar(50)
* mob_app_permit : int(11)
* menu_type_id : int(11)
* pr_location_id : int(11)
* pr_inst_type_id : int(11)
* pr_institution_type : varchar(30)
* pr_yr_id : int(11)
* active_status : tinyint(1)
* added_by : int(11)
* modified_by : int(11)
* modified_at : timestamp
* employee_image : text
* authorization : int(11)
v payitsea_jnablr h01_emp_documnet_details
* docid : int(11)
* empid : int(11)
* document_type : varchar(50)
* document_path : text
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr h01_emp_language_details
* langid : int(11)
* empid : int(11)
* languages : varchar(50)
* reading : varchar(3)
* writing : varchar(3)
* speaking : varchar(3)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr h02_emp_batch_sec_permition
* epermit_id : int(11)
* empid : int(11)
* cgroup_id : int(11)
* course_id : int(11)
* section_id : int(11)
* subject : varchar(50)
* cgroup_name : varchar(50)
* course_name : varchar(50)
* section_name : varchar(100)
* ac_year : varchar(20)
* yr_id : int(11)
* eclass_id : varchar(30)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr h02_emp_office_details
* empoffid : int(11)
* emp_id : int(15)
* location_id : int(15)
* empcatid : int(11)
* pstnid : int(11)
* category_id : int(11)
* deptid : int(11)
* salcat_id : int(11)
* user_name : varchar(50)
* password : text
* sign : text
* role : int(11)
* status : tinyint(4)
* special_permission : tinyint(4)
* host_user : varchar(250)
* host_password : varchar(250)
* zoom_cred_id : int(11)
* created_by : int(11)
* created_at : datetime
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr h03_emp_attendance
* atnd_id : int(11)
* empid : int(11)
* attend_date : date
* attend_type_id : int(11)
* attend_sesn_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr h04_emp_attendance_sessions
* attend_sesn_id : int(11)
* session_type : varchar(50)
* week_day : varchar(5)
* attend_value : decimal(10,2)
* department_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr h05_emp_attendance_verify
* evfy_id : int(11)
* verify_date : date
* verify_by : int(11)
* verify_status : tinyint(4)
* department_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr h06_aca_emp_apply_leave
* tleave_id : int(11)
* empid : int(11)
* from_date : date
* to_date : date
* attend_type_id : int(11)
* reason : varchar(100)
* aprvd_status : tinyint(4)
* aprvd_by : int(11)
* delete_status : tinyint(4)
* yr_id : int(11)
* user : int(11)
* modified_at : datetime
* added_at : timestamp
v payitsea_jnablr h06_emp_apply_leave
* eleave_id : int(11)
* empid : int(11)
* from_date : date
* to_date : date
* attend_type_id : int(11)
* reason : varchar(100)
* aprvd_status : tinyint(4)
* aprvd_by : int(11)
* delete_status : tinyint(4)
* yr_id : int(11)
* user : int(11)
* modified_at : datetime
* added_at : timestamp
v payitsea_jnablr i01_set_payroll_emp_lop_wdays
* lopid : int(11)
* lop_type : varchar(50)
* working_days : int(11)
* salcat_id : int(11)
* active_status : tinyint(1)
* modified_at : timestamp
v payitsea_jnablr i02_set_payroll_leave_types
* leavetypeid : int(11)
* leave_type : varchar(50)
* short_name : varchar(10)
* valid_from : date
* carry_forward : enum('Y','N')
* max_leave : int(11)
* active_status : tinyint(1)
* modified_at : timestamp
v payitsea_jnablr i03_set_payroll_calc_settings
* psetid : int(11)
* payroll_settings : varchar(50)
* active_status : tinyint(1)
* modified_at : timestamp
v payitsea_jnablr i04_set_payroll_salary_category
* salcat_id : smallint(11)
* salcategory_name : varchar(50)
v payitsea_jnablr i05_set_payroll_salary_components
* components_id : int(11)
* components_name : varchar(50)
* short_name : varchar(10)
* type : varchar(10)
* value_type : varchar(10)
* calc_a : varchar(25)
* calc_b : varchar(25)
* calc_c : varchar(25)
* calc_d : varchar(25)
* calc_e : varchar(25)
* calc_f : varchar(25)
* salcat_id : smallint(11)
v payitsea_jnablr i06_set_payroll_gross_salary
* salary_id : int(11)
* emp_id : int(11)
* type : varchar(50)
* amount : int(11)
* effective_date : date
v payitsea_jnablr j01_set_sms_category
* smscat_id : int(11)
* smscategory_name : varchar(50)
* status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr j02_set_sms_category_message
* message_id : int(11)
* smscat_id : int(11)
* message_template : text
* message_format : text
* variable_details : text
* status : tinyint(4)
* template_id : varchar(50)
* dlt_id : varchar(50)
* msg_category : varchar(50)
* active_status : varchar(50)
* add_by : int(11)
* added_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr j03_set_sms_sender_id
* s_id : int(11)
* sender_id : varchar(7)
* status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr j04_set_sms_gateway
* g_id : int(11)
* api_key : varchar(150)
* status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr j04_set_sms_menu_list
* smenu_id : int(11)
* sms_menu : varchar(100)
* active_status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr k01_send_sms_details
* smsid : int(11)
* sms_gateway : int(11)
* message_id : varchar(20)
* campaign : varchar(100)
* section_id : text
* department_id : varchar(20)
* schedule : int(11)
* mode_of_transport : int(11)
* schedule_date : datetime
* schedule_status : tinyint(4)
* message : text
* yr_id : int(11)
* sent_by : int(11)
* sent_date : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr k01_send_sms_details_individual
* smsid : int(11)
* sms_gateway : int(11)
* message_id : varchar(20)
* campaign : varchar(100)
* section_id : text
* department_id : varchar(20)
* student_id : int(11)
* mobile_number : varchar(50)
* schedule : int(11)
* mode_of_transport : int(11)
* schedule_date : datetime
* schedule_status : tinyint(4)
* message : text
* yr_id : int(11)
* sent_by : int(11)
* sent_date : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr k01_sms_delivery_status
* msg_del_id : int(11)
* campaign_id : varchar(255)
* mobile : varchar(15)
* del_status : tinyint(4)
* message_type : tinyint(4)
* delivary_status : varchar(250)
* modified_at : timestamp
v payitsea_jnablr m01_set_omr_1-10
* id : int(11)
* barcode : int(11)
* roll_no : int(15)
* exam_id : int(11)
* qtn_id : int(11)
* bubble1 : int(11)
* bubble2 : int(11)
* bubble3 : int(11)
* bubble4 : int(11)
* image_path : varchar(50)
v payitsea_jnablr m01_set_omr_2-10
* id : int(11)
* barcode : int(11)
* regist_no : int(15)
* exam_id : int(11)
* qtn_id : int(11)
* field1 : int(11)
* field2 : int(11)
* field3 : int(11)
* field4 : int(11)
* field5 : int(11)
* field6 : int(11)
* field7 : int(11)
* field8 : int(11)
* field9 : int(11)
* field10 : int(11)
* field11 : int(11)
* field12 : int(11)
* field13 : int(11)
* field14 : int(11)
* field15 : int(11)
* field16 : int(11)
* field17 : int(11)
* field18 : int(11)
* field19 : int(11)
* field20 : int(11)
* field21 : int(11)
* field22 : int(11)
* field23 : int(11)
* field24 : int(11)
* field25 : int(11)
* field26 : int(11)
* field27 : int(11)
* field28 : int(11)
* field29 : int(11)
* field30 : int(11)
* field31 : int(11)
* field32 : int(11)
* field33 : int(11)
* field34 : int(11)
* field35 : int(11)
* field36 : int(11)
* field37 : int(11)
* field38 : int(11)
* field39 : int(11)
* field40 : int(11)
* field41 : int(11)
* field42 : int(11)
* field43 : int(11)
* field44 : int(11)
* field45 : int(11)
* field46 : int(11)
* field47 : int(11)
* field48 : int(11)
* field49 : int(11)
* field50 : int(11)
* exam_subject : int(11)
* image_path : varchar(50)
v payitsea_jnablr m02_set_omr_11-15
* id : int(11)
* barcode : int(11)
* d0 : int(11)
* d1 : int(11)
* d2 : int(11)
* d3 : int(11)
* d4 : int(11)
* d5 : int(11)
* d6 : int(11)
* d7 : int(11)
* d8 : int(11)
* d9 : int(11)
* m0 : int(11)
* m1 : int(11)
* m2 : int(11)
* m3 : int(11)
* m4 : int(11)
* m5 : int(11)
* m6 : int(11)
* m7 : int(11)
* m8 : int(11)
* m9 : int(11)
* y0 : int(11)
* y1 : int(11)
* y2 : int(11)
* y3 : int(11)
* y4 : int(11)
* y5 : int(11)
* y6 : int(11)
* y7 : int(11)
* y8 : int(11)
* y9 : int(11)
* sid : int(11)
* p1 : int(11)
* p2 : int(11)
* p3 : int(11)
* p4 : int(11)
* p5 : int(11)
* p6 : int(11)
* p7 : int(11)
* p8 : int(11)
* p9 : int(11)
v payitsea_jnablr m03_set_omr_16-20
* id : int(11)
* barcode : int(11)
* date : date
* subject_id : int(11)
* section_id : int(11)
v payitsea_jnablr main_menu
* menu_id : tinyint(11)
* menu_name : varchar(50)
* order_by : tinytext
v payitsea_jnablr mandatory_field_settings
* mid : int(11)
* type : varchar(50)
* mandatory_fields : text
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr mobile_menu_permission
* menu_id : int(11)
* app_type : varchar(30)
* menu_type : varchar(30)
* menu : varchar(50)
* permission : int(11)
* modified_at : timestamp
v payitsea_jnablr mobile_menu_user_permission
* id : int(11)
* app_type : varchar(30)
* menu_title : varchar(30)
* menu_id : varchar(50)
* permission : int(11)
* user_id : int(11)
* modified_at : timestamp
v payitsea_jnablr omr_omrsms
* message_id : int(11)
* message_format : text
* variable_details : text
* status : tinyint(4)
* template_id : varchar(50)
* dlt_id : varchar(50)
* sender_id : varchar(6)
* instance_id : varchar(50)
* access_token : varchar(50)
* msg_category : varchar(50)
* active_status : varchar(50)
* add_by : int(11)
* added_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr opay_upi_response
* id : int(11)
* response : longtext
* added_at : timestamp
v payitsea_jnablr otp_verify
* id : int(11)
* otpmobile : varchar(50)
* otp : int(11)
* send_date_time : datetime
* status : int(11)
* verified_at : datetime
v payitsea_jnablr parent_menu
* pmenu_id : int(11)
* parent_menu_name : varchar(50)
* smenu_id : int(11)
* height : int(11)
* status : tinyint(4)
v payitsea_jnablr pdf_list
* id : int(11)
* oem_id : int(11)
* empID : int(11)
* file_name : varchar(2048)
* creatingDate : timestamp
v payitsea_jnablr report_login
* login_id : int(11)
* username : text
* password : text
v payitsea_jnablr report_user_login
* user_id : int(11)
* username : text
* password : text
* group_id : int(11)
* first_name : varchar(50)
* last_name : varchar(50)
* active_status : tinyint(4)
v payitsea_jnablr sample_table
* id : int(11)
* first_name : varchar(50)
* second_name : varchar(50)
* first_number : int(11)
* second_number : int(11)
v payitsea_jnablr sb_ca_academics_classinfo
* classid : int(11)
* Class : varchar(15)
* ClassName : varchar(15)
* Section : varchar(10)
* Boys_Regular_limit : int(11)
* Girls_Regular_limit : int(11)
* Boys_Hostel_limit : int(11)
* Girls_Hostel_limit : int(11)
* Boys_Transport_limit : int(11)
* Girls_Transport_limit : int(11)
* ClassNamefordoc : varchar(20)
* Promotedclassname : varchar(20)
* Promotedwordclassname : varchar(20)
* SyllabusType : varchar(10)
* AcademicYear : varchar(10)
* SerialNo : varchar(50)
* ClassName1 : varchar(25)
* Status : enum('Y','N')
* modified_at : timestamp
v payitsea_jnablr sb_ca_accounts_fee_master
* fmid : int(11)
* Fee : varchar(10)
* DisplayName : varchar(100)
* Active : enum('Y','N')
* AcademicYear : int(11)
* SyllabusType : int(11)
* monthly_fee : enum('Y','N')
* groupby : varchar(10)
* groupname : varchar(100)
* receipt_head : varchar(200)
* account_number : varchar(100)
* account_name : varchar(100)
* ifsc_code : varchar(50)
* set_readonly : enum('Y','N')
* is_mandatory : tinyint(4)
* receipt_format : varchar(50)
* modified_at : timestamp
* order_by : varchar(50)
v payitsea_jnablr sb_ca_accounts_hostel_transport_receiptformat
* htreceipt_id : int(11)
* Fee : varchar(10)
* receipt_format : varchar(50)
* account_number : varchar(50)
* ifsc : varchar(50)
* description : varchar(50)
* account_name : varchar(100)
v payitsea_jnablr sb_ca_account_feetransaction_receipt
* ftrid : int(11)
* AcademicYear : varchar(10)
* SID : int(11)
* Fee1 : int(11)
* Fee2 : int(11)
* Fee3 : int(11)
* Fee4 : int(11)
* Fee5 : int(11)
* Fee6 : int(11)
* Fee7 : int(11)
* Fee8 : int(11)
* Fee9 : int(11)
* Fee10 : int(11)
* Fee11 : int(11)
* Fee12 : int(11)
* Fee13 : int(11)
* Fee14 : int(11)
* Fee15 : int(11)
* Fee16 : int(11)
* Fee17 : int(11)
* Fee18 : int(11)
* Fee19 : int(11)
* Fee20 : int(11)
* Fee21 : int(11)
* Fee22 : int(11)
* Fee23 : int(11)
* Fee24 : int(11)
* Fee25 : int(11)
* Fee26 : int(11)
* Fee27 : int(11)
* Fee28 : int(11)
* Fee29 : int(11)
* Fee30 : int(11)
* Transport : int(11)
* Hostel : int(11)
* Hostel_Deposit : int(11)
* Fine_Fee : int(11)
* DOP : date
* User : varchar(10)
* ModifiedUser : varchar(10)
* rnd : int(20)
* hostel_rno : int(20)
* df_rno : int(20)
* sfrno : int(20)
* cfrno : int(20)
* Ed : varchar(1)
* SyllabusType : varchar(50)
* Class : varchar(10)
* PaymentType : varchar(20)
* Bank : varchar(50)
* PayStatus : varchar(50)
* CheckClearanceDate : date
* ChequeNo : varchar(500)
* CCReferenceNo : varchar(50)
* Reason : varchar(500)
* bounce_amount : varchar(50)
* wrongaccountdeposite : varchar(50)
* modified_at : timestamp
v payitsea_jnablr sb_ca_class_schoolname
* S_NO : int(11)
* AcademicYear : varchar(50)
* SyllabusType : varchar(50)
* SyllabusDisplayName : varchar(50)
* SyllabusDisplayName1 : varchar(50)
* Class : varchar(50)
* ClassName : varchar(50)
* TrustName : varchar(100)
* InstitutionName : text
* ShortName : varchar(50)
* Address : varchar(150)
* City : varchar(50)
* Zipcode : varchar(20)
* ContactNo : varchar(50)
* Email : varchar(100)
* Logo_1 : varchar(20)
* Logo_2 : varchar(20)
* Logo_3 : varchar(20)
* Descriptions : varchar(150)
* DiceCode : varchar(150)
* Signature : varchar(50)
* TeacherSignature : varchar(50)
* PresidentSignature : varchar(50)
* SecretorySignature : varchar(50)
* Active : varchar(1)
* Managing : varchar(150)
* PB1 : varchar(1)
* PB2 : varchar(1)
* PB3 : varchar(1)
* PB4 : varchar(1)
* PB5 : varchar(1)
* PB6 : varchar(1)
* PB7 : varchar(1)
* PB8 : varchar(1)
* PB9 : varchar(1)
* PB10 : varchar(1)
* PB11 : varchar(1)
* PB12 : varchar(1)
* PB13 : varchar(1)
* PB14 : varchar(1)
* PB15 : varchar(1)
* PB16 : varchar(1)
* PB17 : varchar(1)
* PB18 : varchar(1)
* PB19 : varchar(1)
* PB20 : varchar(1)
* AutoAttendance : varchar(1)
* AcademicYearDisplay : varchar(8)
* InstitutionShortName : text
* TC_DiceCode : varchar(50)
* TC_Descriptions : varchar(150)
* TC_SchoolCode : varchar(150)
* school_college_code : varchar(150)
* school_latitude : double
* school_longitude : double
* stock_receipt_heading : varchar(500)
* stock_address : varchar(500)
* GSTNo : varchar(50)
* Website : varchar(50)
* TransportNote : varchar(200)
* HostelNote : varchar(200)
* RegularNote : varchar(200)
* TransportInstallments : int(11)
* accountnumber : varchar(200)
* schoofee_head : varchar(200)
* schoofee_address : varchar(200)
* developmentfee_head : varchar(200)
* developmentfee_address : varchar(200)
* governmentfee_head : varchar(200)
* governmentfee_address : varchar(200)
* otherfee_head : varchar(200)
* otherfee_address : varchar(200)
* hostelfee_head : varchar(200)
* hostelfee_address : varchar(200)
* transportfee_head : varchar(200)
* transportfee_address : varchar(200)
* ifsc : varchar(50)
* account_name : varchar(200)
* modified_at : datetime
v payitsea_jnablr sb_ca_settings_syllabusmaster
* SYID : int(11)
* Syllabus : varchar(20)
* DisplayName : varchar(10)
* Status : enum('Y','N')
* modified_at : timestamp
v payitsea_jnablr send_sms_status_record
* id : int(11)
* mobilenumber : text
* randomString : text
* template_id : text
* update_at : timestamp
* status : tinyint(4)
v payitsea_jnablr sms_history
* id : int(11)
* SmsDate : date
* Message : text
* Mobile : varchar(10)
* AcademicYear : varchar(50)
* SentType : varchar(20)
* SMSHZID : varchar(100)
* Status : varchar(100)
* sms_gateway : varchar(50)
* Message_Resend : varchar(2)
* SID_Emp_ID : varchar(50)
* Name : varchar(50)
* Class : varchar(15)
* Section : varchar(3)
* send_by : varchar(3)
* modified_at : timestamp
v payitsea_jnablr sub_menu
* smenu_id : tinyint(11)
* submenu_name : varchar(50)
* menu_id : tinyint(11)
* status : tinyint(4)
v payitsea_jnablr tally
* n : int(11)
v payitsea_jnablr user_menu_permission
* prmsn_id : int(11)
* role_id : int(11)
* menu_id : int(11)
* access : int(11)
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr user_role
* role_id : int(11)
* role_name : varchar(50)
* super_admin : int(11)
* dashboard : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr user_role_permission
* prmsn_id : int(11)
* role_id : int(11)
* smenu_id : int(11)
* read : int(11)
* add : int(11)
* edit : int(11)
* delete : int(11)
* print : int(11)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr whatsapp_history
* wpid : int(11)
* Date : date
* Message : text
* Mobile : varchar(10)
* AcademicYear : varchar(50)
* SentType : varchar(50)
* SubType : varchar(50)
* attachment : longtext
* WPSID : varchar(100)
* Status : varchar(100)
* output : longtext
* werror : longtext
* gateway : varchar(50)
* SID_Emp_ID : varchar(50)
* Name : varchar(50)
* Class : varchar(15)
* Section : varchar(3)
* msg_send : varchar(1)
* send_by : varchar(50)
* modified_at : timestamp
v payitsea_jnablr y01_eclass_category
* ecat_id : int(11)
* ecategory : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y01_eclass_class
* eclass_id : int(11)
* eclass : varchar(50)
* cgroup_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y01_eclass_subject
* subject_id : int(11)
* subject : varchar(50)
* eclass_id : int(11)
* eclass : varchar(10)
* cgroup : varchar(10)
* ecat_id : int(11)
* class_resoure : int(11)
* test_resource : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y02_eclass_chapters
* chapter_id : int(11)
* chapter_name : text
* subject_id : int(11)
* subject : varchar(50)
* eclass : varchar(50)
* eclass_id : int(11)
* group_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y03_eclass_chapters_video
* c_video_id : int(11)
* video_name : varchar(100)
* chapter_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y03_eclass_chapters_video_youtube
* c_video_id : int(11)
* video_name : varchar(100)
* youtube_video_id : text
* chapter_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y04_eclass_chapters_notes
* c_notes_id : int(11)
* notes_head : varchar(100)
* chapter_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y05_eclass_chapters_textbook
* c_textbook_id : int(11)
* textbook_head : varchar(100)
* chapter_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y11_eclass_test_questions
* qtn_id : int(11)
* question : text
* chapter_id : int(11)
* priority : int(11)
* medium : int(11)
* delete_status : tinyint(4)
* yr_id : int(11)
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr y12_eclass_test_choices
* ans_id : int(11)
* choice : text
* qtn_id : int(11)
* correct_answer : int(11)
v payitsea_jnablr zoomtoken
* tokenid : int(11)
* cred_id : int(11)
* access_token : text
* refresh_token : text
* modifiedat : datetime
v payitsea_jnablr zoom_credentials
* cred_id : int(11)
* user_group_id : int(11)
* host_user : varchar(250)
* host_password : varchar(250)
* client_id : text
* client_secret : text
* active_status : tinyint(4)
* modifiedat : datetime
v payitsea_jnablr zoom_credentials_web
* cred_id : int(11)
* user_group_id : int(11)
* host_user : varchar(250)
* host_password : varchar(250)
* client_id : text
* client_secret : text
* active_status : tinyint(4)
* modifiedat : datetime
v payitsea_jnablr z_dashboard_flashcard_wishes
* flash_id : int(11)
* wishing_head : varchar(100)
* wishing_date : date
* file_path : text
* cgroup_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11) unsigned
* modified_by : int(11) unsigned
* modified_at : timestamp
* addedat : datetime
v payitsea_jnablr z_mobile_aboutus
* abt_id : int(11)
* location_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_at : timestamp
v payitsea_jnablr z_mobile_app_feedback
* feedbk_id : int(11)
* ratings : int(11)
* comment : varchar(200)
* sid : int(11)
* feedcat_id : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_class_timetable
* ct_id : int(11)
* week_day : varchar(50)
* periods : varchar(25)
* timings : varchar(25)
* subject : varchar(100)
* asigd_teacher : varchar(25)
* section_id : int(11)
* yr_id : int(11)
* added_by : int(11)
* added_at : timestamp
v payitsea_jnablr z_mobile_class_timetable_periods
* period_id : int(11)
* period_name : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
v payitsea_jnablr z_mobile_class_timetable_update
* ct_id : int(11)
* update_date : date
* week_day : varchar(50)
* periods : varchar(25)
* timings : varchar(25)
* subject : varchar(100)
* asigd_teacher : varchar(25)
* section_id : int(11)
* yr_id : int(11)
* added_by : int(11)
* added_at : timestamp
v payitsea_jnablr z_mobile_eclass_menu_permission
* emenu_id : int(11)
* emenu : varchar(50)
* permission : int(11)
* app_type : varchar(30)
* tab_type : varchar(10)
* order_by : varchar(10)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_emp_basic_details
* eid : int(11)
* empid : int(11)
* date_of_birth : date
* blood_group_id : int(11)
* father_guardian_name : varchar(50)
* father_guardian_qualification : varchar(50)
* father_guardian_occupation : varchar(50)
* mother_name : varchar(50)
* mother_qualification : varchar(50)
* com_address_one : varchar(100)
* com_address_two : varchar(100)
* com_city : varchar(50)
* com_zipcode : int(11)
* country_code : int(11)
* marital_status : varchar(50)
* whatsapp_number : varchar(15)
* contact_one : varchar(15)
* contact_two : varchar(15)
* modified_at : datetime
* email_address : varchar(100)
* address_one : varchar(100)
* address_two : varchar(100)
* city : varchar(50)
* zipcode : int(11)
* pr_inst_type_id : int(11)
* modified_by : int(11)
* employee_image : text
v payitsea_jnablr z_mobile_emp_submenu_permission
* smenu_id : int(11)
* sub_menu : varchar(50)
* order_by : varchar(10)
* permission : int(11)
* user : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_exam_category
* ecat_id : int(11)
* exam_category : varchar(50)
v payitsea_jnablr z_mobile_exam_result
* r_id : int(11)
* mainactivity : varchar(20)
* exam_date : date
* sid : int(11)
* pa_macty_id : int(11)
* ecat_id : int(11)
* section_id : int(11)
* yr_id : int(11)
* percentage : decimal(10,2)
* view_permit : int(11)
* publish_by : int(11)
* remark : varchar(100)
* posted_date : datetime
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : timestamp
* delete_status : tinyint(4)
v payitsea_jnablr z_mobile_fee_agreegator
* agreegator_id : int(11)
* agreegator : varchar(50)
* active_status : tinyint(4)
* added_at : datetime
* added_by : int(11)
v payitsea_jnablr z_mobile_fee_cal_conyenacefee
* ocfee_id : int(11)
* cal_type : varchar(100)
* conveyance_fee : int(11)
* description : varchar(100)
* school_account_no : varchar(100)
* ifsc_code : varchar(100)
* upi_address : varchar(100)
* payee_name : varchar(100)
* vpa_address : varchar(100)
* school_code : varchar(100)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_fee_ccavenue_payment_details
* did : int(11)
* ref_id : varchar(250)
* std_id : varchar(250)
* added_at : datetime
* is_expired : tinyint(4)
* moved_at : datetime
* added_by : int(11)
* yr_id : int(11)
* moved_by : int(11)
v payitsea_jnablr z_mobile_fee_transcations
* ofee_tid : int(11)
* unique_id : varchar(50)
* reference_id : varchar(200)
* transactionId : text
* school_code : varchar(10)
* amount : decimal(10,2)
* dop : datetime
* tran_status : tinyint(4)
* agreegator : int(11)
* fund_trans_status : tinyint(4)
* fund_trans_date_time : datetime
* fund_trans_by : int(11)
* fee_desc : varchar(50)
* update_status : tinyint(4)
* yr_id : int(11)
* added_at : datetime
* added_by : int(11)
v payitsea_jnablr z_mobile_fee_transcations_sessions1
* id : int(11)
* session_id : varchar(150)
* biller_id : varchar(200)
* student_id : text
* payingamount : int(11)
* processed_at : datetime
* yr_id : int(11)
* added_at : datetime
* added_by : int(11)
v payitsea_jnablr z_mobile_fee_transcations_settlement
* transactionId : varchar(50)
* merchantTxnId : varchar(50)
* transactionDate : datetime
* merchantId : varchar(20)
* merchantName : varchar(255)
* commissionPercentage : decimal(5,2)
* commissionFlat : decimal(10,2)
* postingAmount : decimal(10,2)
* mdr : decimal(10,2)
* gstOnMdr : decimal(10,2)
* netSettlementAmount : decimal(10,2)
* refundAmount : decimal(10,2)
* refundType : varchar(50)
* bankRefNo : varchar(50)
* isGenerated : char(1)
* utrNo : varchar(50)
* settlementDate : datetime
* emailId : varchar(100)
* udf1 : varchar(50)
* udf2 : varchar(50)
* udf3 : varchar(50)
* udf4 : varchar(50)
* udf5 : varchar(50)
* instrumentId : varchar(20)
* spName : varchar(20)
* productId : varchar(20)
v payitsea_jnablr z_mobile_fee_transcations_status
* tid : int(11)
* session_id : varchar(250)
* transaction_id : varchar(250)
* platformBillID : varchar(250)
* student_id : text
* paidamount : decimal(10,2)
* payment_mode : varchar(50)
* card_name : varchar(50)
* conveyance_fee : decimal(10,2)
* conveyance_fee_type : varchar(250)
* payer_vpa : varchar(250)
* sender_ifsc : varchar(250)
* sender_account_number : varchar(250)
* status : tinyint(4)
* moved_status : smallint(6)
* transaction_at : datetime
* payment_type : varchar(50)
* upi_ref : varchar(100)
* remarks : varchar(200)
* schoolCode : varchar(10)
* yr_id : int(11)
* added_at : datetime
* moved_at : datetime
* added_by : int(11)
* moved_by : int(11)
v payitsea_jnablr z_mobile_flash_screen
* flash_id : int(11)
* flash_head : varchar(100)
* flash_description : varchar(200)
* app_type : varchar(20)
v payitsea_jnablr z_mobile_help
* help_id : int(11)
* video_id : varchar(100)
* heading : varchar(100)
* description : varchar(200)
* app_type : varchar(10)
* active_status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_home_menu_permission
* hmenu_id : int(11)
* hmenu_type_id : int(11)
* hmenu_type : varchar(30)
* hmenu_name : varchar(50)
* hmenu_icon : text
* permission : int(11)
* app_type : varchar(30)
* order_by : varchar(30)
* modified_at : timestamp
v payitsea_jnablr z_mobile_live_class_groups
* lc_gid : int(11)
* group_name : varchar(100)
* active_status : tinyint(4)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_live_class_group_participants
* lc_pid : int(11)
* sid : int(11)
* empid : int(11)
* participant_name : varchar(100)
* contact_no : varchar(15)
* lc_gid : int(11)
* section_id : int(11)
* delete_status : tinyint(4)
* active_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_live_class_hosts
* host_id : int(11)
* host_name : varchar(100)
* contact_no : varchar(15)
* host_image : text
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_live_class_schedule
* schdle_id : int(11)
* subject : varchar(100)
* schdle_date : date
* connect_id : text
* password : varchar(10)
* meeting_id : text
* start_time : time
* duration : int(11)
* lc_gid : int(11)
* host_id : int(11)
* host_user_login : text
* host_user_password : text
* is_an_host : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_logout_details
* log_id : int(11)
* std_id : int(11)
* date : datetime
* logout_status : tinyint(4)
* yr_id : int(11)
v payitsea_jnablr z_mobile_logout_schedule_date
* s_id : int(11)
* max_date : date
v payitsea_jnablr z_mobile_menu_permission
* menu_id : int(11)
* menu_type_id : int(11)
* menu_type : varchar(30)
* menu_name : varchar(50)
* menu_icon : text
* permission : int(11)
* app_type : varchar(30)
* order_by : varchar(30)
* modified_at : timestamp
v payitsea_jnablr z_mobile_notification
* notify_id : int(11)
* notification_head : varchar(50)
* notification_details : varchar(150)
* batch_id : int(11)
* section_id : text
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_notification_individuals
* notify_id : int(11)
* notification_head : varchar(50)
* notification_details : varchar(150)
* batch_id : int(11)
* section_id : text
* student_id : int(11)
* mobile_number : varchar(50)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_assign_pdfpaper
* apdf_id : int(11)
* oem_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_online_exam_assign_qtns
* aqtn_id : int(11)
* qtn_id : int(11)
* chosen_ans : int(11)
* oem_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_category
* oem_catid : int(11)
* category_type : varchar(100)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_master
* oem_id : int(11)
* online_exam : varchar(100)
* template : smallint(6)
* subject : varchar(100)
* e_class_sub_id : int(11)
* exam_date : date
* start_time : varchar(50)
* end_time : varchar(50)
* duration : varchar(50)
* no_of_questions : int(11)
* exam_category_id : int(11)
* max_marks : int(11)
* exam_type_id : int(11)
* exam_type : varchar(50)
* instructions : text
* passage : text
* group_id : int(11)
* course_id : int(11)
* section_id : varchar(50)
* yr_id : int(11)
* assign_status : tinyint(4)
* assigned_by : int(11)
* publish_status : tinyint(4)
* publish_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_master_omr
* oem_id : int(11)
* online_exam : varchar(100)
* template : smallint(6)
* subject : varchar(100)
* e_class_sub_id : int(11)
* exam_date : date
* start_time : varchar(50)
* end_time : varchar(50)
* duration : varchar(50)
* no_of_questions : int(11)
* exam_category_id : int(11)
* max_marks : int(11)
* exam_type_id : int(11)
* exam_type : varchar(50)
* instructions : text
* passage : text
* group_id : int(11)
* course_id : int(11)
* section_id : varchar(50)
* yr_id : int(11)
* assign_status : tinyint(4)
* assigned_by : int(11)
* publish_status : tinyint(4)
* publish_by : int(11)
* delete_status : tinyint(4)
* pdf_path : text
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_master_omr_new
* oem_id : int(11)
* online_exam : varchar(100)
* omr_test : varchar(200)
* template : smallint(6)
* exam_date : date
* exam_type : varchar(50)
* instructions : text
* yr_id : int(11)
* delete_status : tinyint(4)
* pdf_url : text
* key_answer_update : text
* key_answer_update_datetime : datetime
* std_answer_update : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_omr_subjects
* sub_id : int(11)
* subject : varchar(100)
* no_of_question : int(11)
* oem_id : int(11)
* subject_order_by : int(11)
* grace_mark_questions : text
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_online_exam_omr_subjects_master
* sub_id : int(11)
* subject : varchar(100)
* active_status : tinyint(4)
v payitsea_jnablr z_mobile_online_exam_std_upload_anspdf
* anspdf_id : int(11)
* oem_id : int(11)
* std_id : int(11)
* uploaded_at : timestamp
* started_time : time
* ended_time : time
* correction_by : int(11)
* no_of_qtns_or_maxm : int(11)
* correct_ans : int(11)
* skipped : int(11)
* obtained_marks : decimal(10,1)
* correction_at : timestamp
* publish_status : tinyint(4)
* publish_by : int(11)
* sms_status : tinyint(4)
* sms_send_date_time : datetime
* modified_by : int(11)
* modified_at : timestamp
* yr_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr z_mobile_online_exam_std_upload_anspdf_omr
* anspdf_id : int(11)
* oem_id : int(11)
* std_id : int(11)
* uploaded_at : timestamp
* started_time : time
* ended_time : time
* correction_by : int(11)
* no_of_qtns_or_maxm : int(11)
* correct_ans : int(11)
* skipped : int(11)
* obtained_marks : decimal(10,1)
* correction_at : timestamp
* publish_status : tinyint(4)
* publish_by : int(11)
* sms_status : tinyint(4)
* sms_send_date_time : datetime
* report_url : text
* modified_by : int(11)
* modified_at : timestamp
* yr_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr z_mobile_online_exam_std_upload_anspdf_omrtempalte
* omrtmp_id : int(11)
* anspdf_id : int(11)
* oem_id : int(11)
* template : int(11)
* subjects : varchar(10)
* correction_by : int(11)
* no_of_qtns_or_maxm : int(11)
* correct_ans : int(11)
* skipped : int(11)
* obtained_marks : decimal(10,1)
* except_right : text
* modified_by : int(11)
* modified_at : timestamp
* yr_id : int(11)
* delete_status : tinyint(4)
v payitsea_jnablr z_mobile_online_exam_student_ans
* sans_id : int(11)
* std_id : int(11)
* qtn_id : int(11)
* ans_id : int(11)
* oem_id : int(11)
v payitsea_jnablr z_mobile_online_fee_remarks
* frid : int(11)
* sid : varchar(50)
* remarks : longtext
* dueamount : varchar(50)
* status : int(11)
* created_at : timestamp
* modified_at : timestamp
v payitsea_jnablr z_mobile_online_fixed_fee
* fixedfee_id : int(11)
* std_id : varchar(50)
* sfee_id : varchar(50)
* sub_fee : varchar(50)
* fee_category : tinyint(4)
* is_mandatory : tinyint(4)
* development_fee_mandatory : tinyint(4)
* is_edit : tinyint(4)
* discount_applicable : tinyint(4)
* due_date : date
* fixed_fee : int(11)
* due_amount : int(11)
* paid : int(11)
* concession : int(11)
* total_paid : int(11)
* yr_id : int(11)
* order_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_online_fixed_fee_bck
* fixedfee_id : int(11)
* std_id : varchar(50)
* sfee_id : int(11)
* sub_fee : varchar(50)
* is_mandatory : tinyint(4)
* fixed_fee : int(11)
* due_amount : int(11)
* paid : int(11)
* concession : int(11)
* total_paid : int(11)
* yr_id : int(11)
* order_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_online_fixed_fee_discount
* did : int(11)
* year : int(11)
* fee_category : int(11)
* fee_type : varchar(100)
* discount_applicable : enum('Y','N')
v payitsea_jnablr z_mobile_online_fixed_fee_other
* ofid : int(11)
* yr_id : int(11)
* pac_id : varchar(50)
* sfee_id : varchar(50)
* is_mandatory : int(11)
* is_edit : int(11)
* fee_name : varchar(50)
* amount : decimal(20,2)
* display : enum('Y','N')
* display_parent_app : enum('Y','N')
v payitsea_jnablr z_mobile_online_fixed_fee_tmp
* fixedfee_id : int(11)
* std_id : varchar(50)
* sfee_id : varchar(50)
* sub_fee : varchar(50)
* is_mandatory : tinyint(4)
* fixed_fee : int(11)
* due_amount : int(11)
* paid : int(11)
* concession : int(11)
* total_paid : int(11)
* yr_id : int(11)
* order_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_online_oem_recent
* recent_id : int(11)
* oem_id : varchar(100)
* template_id : tinyint(4)
* answer_sheet : text
v payitsea_jnablr z_mobile_online_oem_recent_omr
* recent_id : int(11)
* oem_id : varchar(100)
* template_id : tinyint(4)
* answer_sheet : text
* grace_marks : varchar(100)
* answer_key_issue : tinyint(4)
* number_of_student_answer_processed : int(11)
v payitsea_jnablr z_mobile_online_paying_amount
* pamount_id : int(11)
* std_id : varchar(50)
* paying_amount : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_online_sub_fee_amount
* fee_id : int(11)
* order_id : varchar(100)
* transaction_id : varchar(100)
* sub_fee : varchar(50)
* batch_name : varchar(50)
* amount : double(10,2)
* discount : double(10,2)
* added_by : int(11)
* added_at : timestamp
v payitsea_jnablr z_mobile_online_upi_qrcode_details
* qr_id : int(11)
* std_id : varchar(50)
* unique_id : varchar(200)
* due_amount : int(11)
* qr_url : text
* yr_id : int(11)
* order_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modify_at : timestamp
v payitsea_jnablr z_mobile_question_paper_assign_qtns
* aqtn_id : int(11)
* qtn_id : int(11)
* mq_type_id : int(11)
* oem_id : int(11)
* chapter_id : int(11)
* yr_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_question_paper_exam_master
* oem_id : int(11)
* online_exam : varchar(100)
* subject : varchar(100)
* e_class_sub_id : int(11)
* exam_date : date
* start_time : varchar(50)
* end_time : varchar(50)
* duration : varchar(50)
* no_of_questions : varchar(50)
* instructions : text
* course_id : int(11)
* section_id : varchar(50)
* yr_id : varchar(50)
* assign_status : tinyint(4) unsigned
* assigned_by : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_question_paper_main_questions
* mq_id : int(11)
* main_question : varchar(150)
* e_class_sub_id : int(11)
* delete_status : tinyint(4)
* added_by : int(11)
* added_at : timestamp
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_question_paper_questions
* qtn_id : int(11)
* question : text
* chapter_id : int(11)
* mq_id : int(11)
* priority : int(11)
* medium : int(11)
* delete_status : tinyint(4)
* modified_by : int(11)
* modified_at : timestamp
v payitsea_jnablr z_mobile_reports
* report_id : int(11)
* report_menu : varchar(100)
* active_status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_reports_user_group
* group_id : int(11)
* group_name : varchar(100)
* read : tinyint(4)
* update : tinyint(4)
* add_by : int(11)
* active_status : tinyint(4)
v payitsea_jnablr z_mobile_student_basic_details
* m_id : int(11)
* sid : int(11)
* father_guardian_name : varchar(50)
* added_by : int(11)
* added_at : datetime
* modified_by : int(11)
* modified_at : datetime
v payitsea_jnablr z_mobile_student_feedback_category
* feedcat_id : int(11)
* feedbackcat_name : varchar(50)
* status : tinyint(4)
* add_by : int(11)
* add_at : timestamp
* modify_by : int(11)
* modified_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship