* id type key_value is_active created_at updated_at

* id book_title book_no isbn_no subject rack_no publish author qty perunitcost postdate description available is_active created_at updated_at

* id book_id duereturn_date return_date issue_date is_returned member_id is_active created_at

* id category is_active created_at updated_at

* id certificate_name certificate_text left_header center_header right_header left_footer right_footer center_footer background_image created_at updated_at created_for status header_height content_height footer_height content_width enable_student_image enable_image_height

* id chat_user_one chat_user_two ip time created_at updated_at

* id message chat_user_id ip time is_first is_read chat_connection_id created_at

* id user_type staff_id student_id create_staff_id create_student_id is_active created_at updated_at

* id class is_active created_at updated_at

* id class_id section_id is_active created_at updated_at

* id class_id staff_id section_id session_id

* id complaint_type source name contact email date description action_taken assigned note image

* id complaint_type description created_at

* id title type is_public class_id cls_sec_id file created_by note is_active created_at updated_at date

* id role content_id user_id created_at

* id name belong_to type bs_column validation field_values show_table visible_on_table weight is_active created_at updated_at

* id belong_table_id custom_field_id field_value created_at updated_at

* id department_name is_active

* id reason created_at

* id reference_no to_title address note from_title date image created_at updated_at type

* id email_type smtp_server smtp_port smtp_username smtp_password ssl_tls is_active created_at

* id name contact address reference date description follow_up_date note source email assigned class no_of_child status

* id enquiry_type description

* id event_title event_description start_date end_date event_type event_color event_for role_id is_active

* id name sesion_id note is_active created_at updated_at

* id name exam_type description is_active created_at updated_at

* id exam session_id date_from date_to description exam_group_id is_publish is_active created_at updated_at

* id exam_group_class_batch_exam_id student_id student_session_id roll_no is_active created_at updated_at

* id exam_group_class_batch_exams_id subject_id date_from time_from duration room_no max_marks min_marks credit_hours date_to is_active created_at updated_at

* id exam_group_id exam_group_class_batch_exams_id exam_weightage is_active created_at updated_at

* id exam_group_class_batch_exam_student_id exam_group_class_batch_exam_subject_id attendence get_marks note is_active created_at updated_at exam_group_student_id

* id exam_group_id student_id student_session_id is_active created_at updated_at

* id attendence exam_schedule_id student_id get_marks note is_active created_at updated_at

* id session_id exam_id teacher_subject_id date_of_exam start_to end_from room_no full_marks passing_marks note is_active created_at updated_at

* id exp_head_id name invoice_no date amount documents note is_active is_deleted created_at updated_at

* id exp_category description is_active is_deleted created_at updated_at

* id category is_active created_at updated_at

* id session_id feetype_id class_id amount description is_active created_at updated_at

* id session_id name code amount description is_active created_at

* id reminder_type day is_active created_at updated_at

* id is_system feecategory_id type code is_active created_at updated_at description

* id name is_system description is_active created_at

* id fee_session_group_id fee_groups_id feetype_id session_id amount fine_type due_date fine_percentage fine_amount is_active created_at

* id payment

* id fee_groups_id session_id is_active created_at

* id enquiry_id date next_date response note followup_by

* id image thumb_path dir_path img_name thumb_name created_at file_type file_size vid_url vid_title

* id menu slug description open_new_tab ext_url ext_url_link publish content_type is_active created_at

* id menu_id menu page_id parent_id ext_url open_new_tab ext_url_link slug weight publish description is_active created_at

* id page_type is_homepage title url type slug meta_title meta_description meta_keyword feature_image description publish_date publish sidebar is_active created_at

* id page_id content_type created_at

* id type slug url title date event_start event_end event_venue description is_active created_at meta_title meta_description meta_keyword feature_image publish_date publish sidebar

* id program_id media_gallery_id created_at

* id theme is_active_rtl is_active_front_cms is_active_sidebar logo contact_us_email complain_form_email sidebar_options fb_url twitter_url youtube_url google_plus instagram_url pinterest_url linkedin_url google_analytics footer_text fav_icon created_at

* id name contact date description follow_up_date call_dureation note call_type

* id exam_type name point mark_from mark_upto description is_active created_at updated_at

* id class_id section_id session_id homework_date submit_date staff_id subject_group_subject_id subject_id description create_date evaluation_date document created_by evaluated_by

* id homework_id student_id student_session_id date status

* id hostel_name type address intake description is_active created_at updated_at

* id hostel_id room_type_id room_no no_of_bed cost_per_bed title description created_at updated_at

* id title school_name school_address background logo sign_image header_color enable_admission_no enable_student_name enable_class enable_fathers_name enable_mothers_name enable_address enable_phone enable_dob enable_blood_group status

* id inc_head_id name invoice_no date amount note is_active is_deleted created_at updated_at documents

* id income_category description is_active is_deleted created_at updated_at

* id item_category_id name unit item_photo description created_at updated_at item_store_id item_supplier_id quantity date

* id item_category is_active description created_at updated_at

* id issue_type issue_to issue_by issue_date return_date item_category_id item_id quantity note is_returned created_at is_active

* id item_id supplier_id symbol store_id quantity purchase_price date attachment description is_active created_at

* id item_store code description

* id item_supplier phone email address contact_person_name contact_person_phone contact_person_email description

* id language short_code country_code is_deleted is_active created_at updated_at

* id type is_active

* id library_card_no member_type member_id is_active created_at

* id message record_id user_id action ip_address platform agent time created_at

* id title message send_mail send_sms is_group is_individual is_class group_list user_list created_at updated_at

* version

* id student_id student_session_id created_at updated_at

* id send_notification_id role_id is_active created_at

* id type is_mail is_sms is_notification display_notification template variables created_at

* id exam attempt exam_from exam_to time_from time_to duration passing_percentage description session_id publish_result is_active created_at updated_at

* id onlineexam_student_id created_at updated_at

* id question_id onlineexam_id session_id is_active created_at updated_at

* id onlineexam_id student_session_id created_at updated_at

* id onlineexam_student_id onlineexam_question_id select_option created_at updated_at

* id admission_no roll_no admission_date firstname lastname rte image mobileno email state city pincode religion cast dob gender current_address permanent_address category_id class_section_id route_id school_house_id blood_group vehroute_id hostel_room_id adhar_no samagra_id bank_account_no bank_name ifsc_code guardian_is father_name father_phone father_occupation mother_name mother_phone mother_occupation guardian_name guardian_relation guardian_phone guardian_occupation guardian_address guardian_email father_pic mother_pic guardian_pic is_enroll previous_school height weight note measurement_date app_key document disable_at created_at updated_at

* id payment_type api_username api_secret_key salt api_publishable_key api_password api_signature api_email paypal_demo account_no is_active created_at updated_at

* id payslip_id allowance_type amount staff_id cal_type

* id perm_group_id name short_code enable_view enable_add enable_edit enable_delete created_at

* id name short_code is_active system created_at

* id group_id name short_code is_active system created_at

* id name short_code is_active system group_id created_at

* id print_type header_image footer_content created_by entry_date

* id subject_id question opt_a opt_b opt_c opt_d opt_e correct created_at updated_at

* id question_id option_id created_at

* id question_id option created_at

* id student_id parent_id staff_id notification_id is_active created_at updated_at

* id reference description

* id name slug is_active is_system is_superadmin created_at updated_at

* id role_id perm_cat_id can_view can_add can_edit can_delete created_at

* id room_type description created_at updated_at

* id house_name description is_active

* id name biometric biometric_device email phone address lang_id languages dise_code date_format time_format currency currency_symbol is_rtl is_duplicate_fees_invoice timezone session_id cron_secret_key currency_place class_teacher start_month attendence_type image admin_logo admin_small_logo theme fee_due_days adm_auto_insert adm_prefix adm_start_from adm_no_digit adm_update_status staffid_auto_insert staffid_prefix staffid_start_from staffid_no_digit staffid_update_status is_active online_admission is_blood_group is_student_house roll_no category religion cast mobile_no student_email admission_date lastname student_photo student_height student_weight measurement_date father_name father_phone father_occupation father_pic mother_name mother_phone mother_occupation mother_pic guardian_relation guardian_email guardian_pic guardian_address current_address permanent_address route_list hostel_id bank_account_no national_identification_no local_identification_no rte previous_school_details student_note upload_documents staff_designation staff_department staff_last_name staff_father_name staff_mother_name staff_date_of_joining staff_phone staff_emergency_contact staff_marital_status staff_photo staff_current_address staff_permanent_address staff_qualification staff_work_experience staff_note staff_epf_no staff_basic_salary staff_contract_type staff_work_shift staff_work_location staff_leaves staff_account_details staff_social_media staff_upload_documents mobile_api_url app_primary_color_code app_secondary_color_code app_logo created_at updated_at

* id section is_active created_at updated_at

* id title publish_date date message visible_student visible_staff visible_parent created_by created_id is_active created_at updated_at

* id session is_active created_at updated_at

* id type name api_id authkey senderid contact username url password is_active created_at updated_at

* id source description

* id employee_id lang_id department designation qualification work_exp name surname father_name mother_name contact_no emergency_contact_no email dob marital_status date_of_joining date_of_leaving local_address permanent_address note image password gender account_title bank_account_no bank_name ifsc_code bank_branch payscale basic_salary epf_no contract_type shift location facebook twitter linkedin instagram resume joining_letter resignation_letter other_document_name other_document_file user_id is_active verification_code

* id date staff_id staff_attendance_type_id remark is_active created_at updated_at

* id type key_value is_active created_at updated_at

* id designation is_active

* id staff_id leave_type_id alloted_leave

* id staff_id leave_type_id leave_from leave_to leave_days employee_remark admin_remark status applied_by document_file date

* id basic_salary pay_scale grade is_active

* id staff_id basic total_allowance total_deduction leave_deduction tax net_salary status month year payment_mode payment_date remark

* id staff_id comment rate user_id role status entrydt

* id role_id staff_id is_active created_at updated_at

* id staff_id title timeline_date description document status date

* id parent_id admission_no roll_no admission_date firstname lastname rte image mobileno email state city pincode religion cast dob gender current_address permanent_address category_id route_id school_house_id blood_group vehroute_id hostel_room_id adhar_no samagra_id bank_account_no bank_name ifsc_code guardian_is father_name father_phone father_occupation mother_name mother_phone mother_occupation guardian_name guardian_relation guardian_phone guardian_occupation guardian_address guardian_email father_pic mother_pic guardian_pic is_active previous_school height weight measurement_date dis_reason note dis_note app_key parent_app_key disable_at created_at updated_at

* id student_session_id from_date to_date apply_date status created_at docs reason approve_by request_type

* id student_session_id biometric_attendence date attendence_type_id remark biometric_device_data is_active created_at updated_at

* id student_id title doc

* id student_session_id feemaster_id amount amount_discount amount_fine description date payment_mode is_active created_at updated_at

* id student_fees_master_id fee_groups_feetype_id amount_detail is_active created_at

* id student_session_id fees_discount_id status payment_id description is_active created_at

* id is_system student_session_id fee_session_group_id amount is_active created_at

* id session_id student_id class_id section_id route_id hostel_room_id vehroute_id transport_fees fees_discount is_active created_at updated_at

* id student_id sibling_student_id is_active created_at updated_at

* id student_session_id subject_timetable_id attendence_type_id date remark created_at

* id student_id title timeline_date description document status date

* id name code type is_active created_at updated_at

* id name description session_id created_at

* id subject_group_id class_section_id session_id description is_active created_at updated_at

* id subject_group_id session_id subject_id created_at

* id day class_id section_id subject_group_id subject_group_subject_id staff_id time_from time_to room_no session_id created_at

* id homework_id student_id message docs file_name created_at

* id session_id class_section_id subject_id teacher_id description is_active created_at updated_at

* id template heading title left_logo right_logo exam_name school_name exam_center sign background_img is_name is_father_name is_mother_name is_dob is_admission_no is_roll_no is_address is_gender is_photo is_class is_section content_footer created_at updated_at

* id template heading title left_logo right_logo exam_name school_name exam_center left_sign middle_sign right_sign exam_session is_name is_father_name is_mother_name is_dob is_admission_no is_roll_no is_photo is_division is_customfield background_img date is_class is_section content content_footer created_at updated_at

* id teacher_subject_id day_name start_time end_time room_no is_active created_at updated_at

* id route_title no_of_vehicle fare note is_active created_at updated_at

* id user role ipaddress user_agent login_datetime

选择表 attendence_type books book_issues categories certificates chat_connections chat_messages chat_users classes class_sections class_teacher complaint complaint_type contents content_for custom_fields custom_field_values department disable_reason dispatch_receive email_config enquiry enquiry_type events exams exam_groups exam_group_class_batch_exams exam_group_class_batch_exam_students exam_group_class_batch_exam_subjects exam_group_exam_connections exam_group_exam_results exam_group_students exam_results exam_schedules expenses expense_head feecategory feemasters fees_discounts fees_reminder feetype fee_groups fee_groups_feetype fee_receipt_no fee_session_groups follow_up front_cms_media_gallery front_cms_menus front_cms_menu_items front_cms_pages front_cms_page_contents front_cms_programs front_cms_program_photos front_cms_settings general_calls grades homework homework_evaluation hostel hostel_rooms id_card income income_head item item_category item_issue item_stock item_store item_supplier languages leave_types libarary_members logs messages migrations multi_class_students notification_roles notification_setting onlineexam onlineexam_attempts onlineexam_questions onlineexam_students onlineexam_student_results online_admissions payment_settings payslip_allowance permission_category permission_group permission_parent permission_student print_headerfooter questions question_answers question_options read_notification reference roles roles_permissions room_types school_houses sch_settings sections send_notification sessions sms_config source staff staff_attendance staff_attendance_type staff_designation staff_leave_details staff_leave_request staff_payroll staff_payslip staff_rating staff_roles staff_timeline students student_applyleave student_attendences student_doc student_fees student_fees_deposite student_fees_discounts student_fees_master student_session student_sibling student_subject_attendances student_timeline subjects subject_groups subject_group_class_sections subject_group_subjects subject_timetable submit_assignment teacher_subjects template_admitcards template_marksheets timetables transport_route userlog . 选择字段
显示

排序	递增	递减
添加为	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一个字段
	选择表 attendence_type books book_issues categories certificates chat_connections chat_messages chat_users classes class_sections class_teacher complaint complaint_type contents content_for custom_fields custom_field_values department disable_reason dispatch_receive email_config enquiry enquiry_type events exams exam_groups exam_group_class_batch_exams exam_group_class_batch_exam_students exam_group_class_batch_exam_subjects exam_group_exam_connections exam_group_exam_results exam_group_students exam_results exam_schedules expenses expense_head feecategory feemasters fees_discounts fees_reminder feetype fee_groups fee_groups_feetype fee_receipt_no fee_session_groups follow_up front_cms_media_gallery front_cms_menus front_cms_menu_items front_cms_pages front_cms_page_contents front_cms_programs front_cms_program_photos front_cms_settings general_calls grades homework homework_evaluation hostel hostel_rooms id_card income income_head item item_category item_issue item_stock item_store item_supplier languages leave_types libarary_members logs messages migrations multi_class_students notification_roles notification_setting onlineexam onlineexam_attempts onlineexam_questions onlineexam_students onlineexam_student_results online_admissions payment_settings payslip_allowance permission_category permission_group permission_parent permission_student print_headerfooter questions question_answers question_options read_notification reference roles roles_permissions room_types school_houses sch_settings sections send_notification sessions sms_config source staff staff_attendance staff_attendance_type staff_designation staff_leave_details staff_leave_request staff_payroll staff_payslip staff_rating staff_roles staff_timeline students student_applyleave student_attendences student_doc student_fees student_fees_deposite student_fees_discounts student_fees_master student_session student_sibling student_subject_attendances student_timeline subjects subject_groups subject_group_class_sections subject_group_subjects subject_timetable submit_assignment teacher_subjects template_admitcards template_marksheets timetables transport_route userlog .	选择字段

X