* id crime_details_id case_id districtid Proceedings_remarks dt_next_proceeding doc_proceeding Submitted_On Submitted_by

* id child_name father_name mother_name gender place_of_birth dob district address family_income institution_type institution_name date_of_registration disablity_status

* id ip_address timestamp data

* id case_id crime_details_id useremail filing_no case_selected OH_name OH_room_avail date_to_OH date_of_bail care_person relationwith_care POS_name date_to_POS filing_date cnr_no regis_no fir datetimefir date_of_institution nature_of_case districtid dt_proceeding Jimny_Order

* id case_id crime_details_id districtid order_doc order_date facility_type sending_date_in_SH decision_remarks Submitted_On Submitted_by

* id fir undersection police_station copyfir datetimefir district_ps dt_fir brief_description information_officer cwp_officer cwp_officer_no religion name dob gender father_name mother_name guardian_name state district ward_details p_address contact_no marital_status ppp_no aadhar abled_check abled textarea_other edudetails reasonschoolleaving laststudied vtraining majorityfrnds family_details reasonhomeleaving whetherfamilyinvolved includefamilymember habitofchild formabuse_check whetherabuse_div verbalabuse verbalabuseremarks physicalabuse parentalabuseremarks sexualabuse namefamily relationshipfamily incomefamily mental_illness addictions agefamily sexualabuseremarks victimofoffence drugpeddling parentalneglect apprehended detailsofarticlesrecovered allegedrole suggestionpolice status submitted_by Lastupdated_by districtid Submitted_On Lastupdated_On requestfromJJB Circumstances Reason_for_alleged_offence apprehended_earlier_offence previous_case physical_appearance health_condition mental_condition other_remarks verified_by_lpo case_status care_plan_status

* id child_id id_crime slno JJBAddress poname natureofoffence caste religion landmarkaddress addressoflastresidence detailsofspouse fathermother fatherchild motherchild fathersiblings mothersiblings childsiblings childgrandparents attitudereligion presentconditions otherfactorimportance Extracurricular outstanding childreacrioninhome employementdetails workrecord attitudeofclassmates attitudeofteachers laststudied childtofrnds frndtochild neighbourstochild observationneighbour tendencytorun apprehended_earlier_offence previous_case physical_appearance health_condition mental_condition other_remarks district LPONameWhoVerified VerifiedOn

* Id District_Name Password Name

* id child_data_id Supervisor_Name Restoration_Type Restoration_doc Restoration_date Restoration_Person_Name Restoration_Person_Mobile Restoration_Person_Address PersonState PersonDistrict Restoration_Person_FamilyId actionSelect

* harihar_transfer_child_data_id child_data_id Supervisor_Name district_cci CCI_Name Transfer_date Transfer_Doc actionSelect

* id name dob gender religion father_name mother_name g_name p_address landmark last_address contact_number maritial_status

* id Children_Home_Type Institute_Type Institution_Name Category_of_Children District_code Address Supervisor_Name Mobile_Number Designation Username Pass_word

* Id districtid usertype password designation email

* Id District_Name Password Name designation

* id designation district office

* id nameofoffice districtid districtname Address totalcapacity totalfilled

* OH_id OH_name total_capacity girls_capacity boys_capacity strength_of_OH gender

* ID slno child_Id JJBAddress poname natureofoffence district_ps name dob gender caste religion guardian_name state district ward_details p_address landmarkaddress addressoflastresidence Contact_No abled_check abled relationshipfamily namefamily agefamily incomefamily mental_illness addictions marital_status fathermother fatherchild motherchild fathersiblings mothersiblings childsiblings childgrandparents whetherfamilyinvolved attitudereligion presentconditions otherfactorimportance habitofchild Extracurricular outstanding childreacrioninhome employementdetails workrecord edudetails attitudeofclassmates attitudeofteachers reasonschoolleaving laststudied vtraining majorityfrnds childtofrnds frndtochild neighbourstochild observationneighbour reasonhomeleaving formabuse_check verbalabuse verbalabuseremarks physicalabuse sexualabuse sexualabuseremarks victimofoffence drugpeddling tendencytorun parentalneglect apprehended allegedrole apprehended_earlier_offence previous_case physical_appearance health_condition mental_condition other_remarks LPONameWhoVerified VerifiedOn

* Id District Name Phone Mobile Email

* Id districtid usertype facility_type password designation email salt

* Id District_Name usertype Pass_word designation email

* Id Under_Section

* Id District_Name Password Name designation last_login

* District_code State_code District_Name

* State_code State_Name Is_Active Createdby Createdon Last_Updatedby Last_Updatedon Remark

* id type_user role

* filed

* id name designation pppid mobile email password districtId districtname

* id type_user district nameofuser mobileofuser email designation confirmPassword

* Id District_Name District_Code Block_Name Block_Code Ward_Village_Name Ward_Village_Code

select table case_proceedings child_data ci_sessions crime_case crime_case_verdicts crime_details crime_details_lpo districtlogin harihar_restoration_and_protection harihar_transfer_child_data icps_data institute_master jjblogin lpologin nodallogin observationhomedetails oh_master only_lpo policestationmaster pologin ppologin sections sjpulogin tbl_district_master tbl_state_master tbl_type_user testubf users user_login wardlist . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table case_proceedings child_data ci_sessions crime_case crime_case_verdicts crime_details crime_details_lpo districtlogin harihar_restoration_and_protection harihar_transfer_child_data icps_data institute_master jjblogin lpologin nodallogin observationhomedetails oh_master only_lpo policestationmaster pologin ppologin sections sjpulogin tbl_district_master tbl_state_master tbl_type_user testubf users user_login wardlist .	select column