* id emp_id reason user_id ts dats

* ID TransID Reference UserID FullName objectName Path MethodName LineNumber ObjectCaption System Message Action IP PCName LocalTime ServerTime

* overtime_id employee_number overtime_hrs_from overtime_hrs_to overtime_date overtime_status

* id frmid frm_name transaction_id process_description signId signDate status reason TS

* id ref_no trans_type source_data orig_data new_data table_type field_name user_id User_name datelog remarks IP_PC

* field

* id type status

* ID BusinessNumber TypeOfAddress street barangay city province zip country DefaultAddress AddressCode imported_from_excel

* ID BusinessNumber ContactName ContactNumber ContactEmailAdd street barangay city province zip country

* SystemName ServerName DatabaseName Port User Password

* ID TRANSID DOCS FILENAME TS

* ID HOST USERNAME PASSWORD PORT

* id form_id user_id color type

* id form_name NAME stamp

* id Descripion orderby category

* SysPK_City_mun province_id zipcode_id city_mun_id city_mun_name status_name country province_area zip_code municipal_code checker citydate

* SysPK_City_mun province_id zipcode_id city_mun_id city_mun_name status_name country province_area zip_code municipal_code checker

* Signatory_ID Signatory_Name Signatory_Position Signatory_Position_New Signatory_Position_Display Signatory_PP_ID Dept_id

* id message created_at

* id net_use set_source set_destination xcopy setexePath start

* Id Installer_Version Patch_Version DatePatch AssemblyName Activate

* ID ObjName ObjectGroup SubGroup ObjCaption CommandName tile_name status

* ID ObjName

* ID RoleID Allowed ObjName ObjectGroup SubGroup ObjCaption CommandName tile_name status

* ID RoleID Allowed ObjName ObjectGroup SubGroup ObjCaption CommandName tile_name status

* id Description E_Charge

* title_id title_name title_desc1 title_desc2 title_logo1 title_logo2 status tin sss pagibig philhealth userid Contact header_img footer_img system_gen title_system header1 header2 header3 title_code savedate sec_no bir_regdate ZIP LGUName LGUAddress Province LguLogo LguLogo2 LguLogo3 Region

* ID Parent RoleName

* pk_id user_code savedate

* id company_type branches status project_type

* pk_id user_id user_name user_log save_date

* project_id title_id project_code project_name project_type project_location project_remarks bir_code telno tin sss philhealth pag_ibig status date_saved Main_office_id officeAlias Starting Ending Duration Amount ContractorId bp_number registration_no

* area_id area_proj area_price

* project_id project_detail_employee_no project_number

* id office_type savedate userid form_name

* title_id project_id username employee_Id

* formName save modify approve cancel print employee_id main

* signatory_id form_id setupType_id prefix suffix employee_id priority_no location designation title_id savedate status

* id type form_id status

* status_id status_name

* id system_name transdate

* title_id title_no title_name title_desc1 title_desc2 title_logo1 title_logo2 title_location title_loc_id status active tin sss pagibig philhealth userid savedate area_price area_location form_name

* pk_id user_name pass_word display_name user_type employee_id department_id project_id title_id status save_date static photo_loc

* ID EMPID EMPNAME FORM_NAME SIGNATORY SIGNATURE_IMG USED_DEFAULT PREFIX SUFFIX SIGIMG autosign

* ID FORM_NAME

* ID POSITION_TYPE

* log_id form_id form_name bns_id pp_id user_id head_id head_name head_position mayor_id mayor_name mayor_position brgy_cap_id brgy_cap_name brgy_cap_pos Chief_of_pol_id Chief_of_pol_name Chief_of_pol_pos date_save date_update remarks timestamp

* id Employee_id Picture_Path save_date status save_by

* ID SIGNAME

* ID Property Status

* ID Property Values UID Pwd Status

* ID ISoN

* ID FrmName FrmClass PropertiesExternal

* id form_id Appname Modules FRM_CAPTION FRM_CLASS Properties DefaultValue RType

* ID Profilename AddedByUID Status

* ID ProfileID ProfileName FrmClass FormName Properties Value

* ID FrmClass FrmName GroupName ORDERED ADDEDBYUSERID TS Status Task

* ID UID RMID TS Uname UFullName RMName imported_from_excel

* ID RoleID RoleName ProfileName

* ID ProfileName UID TS UserName

* id userid compid themes palette HostName

* id connection status savedate

* order_no counselor_id mayor_id vmayor_id term_from term_to

* id form_id series_include series_format series_order type

* id main_id counselor_id order_no

* id term_id mayor_id vmayor_id term_from term_to type status

* id config_id header1 header2 header3 footer1 footer2 footer3 system_geb_by agency_number tel_number cell_number fax_number email_address official_website address

* id mun_cit_id prov_id reg_id Term_From Term_To zip_code overview type status projectAquisition ProjectAcq_id year_declared date_declared

* id setup_name status

* id main_id matrix_id profile_id profile_name group_id group_name core_function success_indicator actual_accomplishment q e t a remarks status savedate

* id evaluation_id indicator_description

* id main_id eval_dtl_id rating_id Comment adjectival numerical_val ts

* id emp_id work_assignment evaluation_title date_from dateto_date uid status ts comments

* id title_id indicator_name descriptions Percentage status

* id dtl_id Rating_Name Rating_Description order_by

* id evaluation_id rating_name numerical

* ID DESCRIPTION VALUES_FROM VALUES_TO

* id decription

* id emp_id emp_name dept_id dept_name pos_id pos_name profile_id profile_name period_from period_to savedate status assessed_by ratee_by approved_by

* id trans_date department category function_type perf_type mfo success_indicator form_from function_from form_to function_to rating_id rating_from rating_to budget STATUS

* id main_id quality efficiency timeliness

* id rating_id perf_type q_from q_to e_type e_from e_to e_category timeliness time_type time_category

* id scale_name scale min_ max_ numerical adjectival Remarks

* ID Decription Numirical

* id department category_name status

* id main_id matrix_id group_name Function_type mfo accountable budget success_indicator actual_accomplishment q e t a remarks status savedate

* id dept_id dept_name period_from period_to savedate status assessed_by ratee_by approved_by

* id man_id reviewed_by ts entry_type

* issue_id issue_date orig_form_id issue_form_id ref_id issue_form issue_by action issue_remarks issue_time timestamp stat issue_status ref_code business_number business_app_id issued_same_payment

* log_id uid username timelog login_status user_ip user_computername remarks

* id descriprion

* id form_name status module

* signatory_id form_id setupType_id employee_id priority_no project_id title_id savedate status display_emp bypass

* bypass_id signatory_id form_id setuptype_id bypass status

* priority_id signatory_id form_id ranking result project_id title_id status

* id type status savedate

* id nameForm form_name status module form_status form_number MODULE_NAME APP_NAME series_type series_length series_start series_reset series_separator series_ref_no series_grouping cert_id req_ver_doc req_ver_dept

* id nameForm form_name status module form_status form_number MODULE_NAME APP_NAME series_type series_length series_start series_reset series_separator series_ref_no cert_id req_ver_doc req_ver_dept

* int user_id notif_id notif_name

* int notif_name

* pk_id form_id title_id proj_id user_id allow save update cancel print ProfileID

* ID UID User_Full_Name ACCESS_DESC Password TITLEID LOCATION

* id title_id proj_id user_id full_control

* desc

* ID userID UserFullName ShutReason TimeLog LogType IP PCName

* id formid button activity computer ip_address username employee timestamp

* ID EmpID User Dept

* ID PasswordS

* ID FORMID ProfileID allow save update cancel print

* ID Profilename

* ID User Role

* id UserName_User Password_User Password_User_web Type_User person_id Employee_id dept_id ACCESSED title_id project_id status last_login last_logout RESTRICT email_address digital_signature position_id override security un_issued savedate IsReset IMG UserFull_Name IsLogin market_type approve_electronic leave_approval can_upload_esig can_access_bio_reg auto_head_approved

* ID COMPID TRANSREF uname UserFullName FormName form_id GRP UID MODULES COMMAND ACTIONS DateLogs PCNAME IPADD ts date_from date_to print_count

* id user_id activity module date_created

* id user_name user_pass emp_id logo

* id usertype user_id save_date status title_id project_id can_override

* id version_no

select table activation_status activitylog application_ot approval_process audit_logs audit_logs_exlude authorize_setup businessaddresses businesscontacts db_configuration deposit_attachment filezillaaccounts form_color form_name form_properties lgu_city_mun_setup lgu_city_mun_setup_temp lgu_signatory messages patchcreation patch_tracker permissionobject permissionobject_defaults permissionroleobject permissionroleobject_copy projectacquisition project_title role setup_code setup_company setup_logs setup_project setup_project_area setup_project_detail setup_project_office setup_security setup_security_dtl setup_signatory setup_signatorytype setup_status setup_system setup_title setup_user signatories signatories_form_type signatories_type signatory_logs signatory_setup sigtype specialaccess specialaccesspermission sso systemformproperties systemforms systemprofile systemprofileforms systemprofileorders systemreportingmanager systemroleprofile systemuserroleprofile system_themes tbl_connection tbl_councilor_setup tbl_form_setup_series tbl_general_elected_counselors tbl_general_elected_officials tbl_general_header_setup tbl_general_location tbl_general_setting tbl_hr_ipcr_detail tbl_hr_ipcr_evaluation_details tbl_hr_ipcr_evaluation_entry_details tbl_hr_ipcr_evaluation_entry_main tbl_hr_ipcr_evaluation_main tbl_hr_ipcr_evaluation_rating tbl_hr_ipcr_evaluation_rating_numerical tbl_hr_ipcr_evaluation_rating_scale tbl_hr_ipcr_evaluation_title tbl_hr_ipcr_main tbl_hr_ipcr_rating_matrix tbl_hr_ipcr_rating_matrix_details_quality tbl_hr_ipcr_rating_matrix_details_system tbl_hr_ipcr_rating_scale tbl_hr_ipcr_scalling tbl_hr_ipcr_work_category tbl_hr_opcr_detail tbl_hr_opcr_main tbl_ipcr_reviewed tbl_issuance tbl_login_logs tbl_order_personnel tbl_signatoryform tbl_signatorymain tbl_signatorypass tbl_signatoryrank tbl_signatorytype tbl_user_form tbl_user_form_copy tbl_user_notif_access tbl_user_notif_access_setup tbl_user_restrictions tbl_user_restrictions_check tbl_user_restrictions_journal tbl_user_security_alter timelogs transaction_logs userdepartment useroverideaccess userprofiledefaultsettings userprofilelist userrole users usersactivitylog users_activities user_employee user_type version_no . 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 activation_status activitylog application_ot approval_process audit_logs audit_logs_exlude authorize_setup businessaddresses businesscontacts db_configuration deposit_attachment filezillaaccounts form_color form_name form_properties lgu_city_mun_setup lgu_city_mun_setup_temp lgu_signatory messages patchcreation patch_tracker permissionobject permissionobject_defaults permissionroleobject permissionroleobject_copy projectacquisition project_title role setup_code setup_company setup_logs setup_project setup_project_area setup_project_detail setup_project_office setup_security setup_security_dtl setup_signatory setup_signatorytype setup_status setup_system setup_title setup_user signatories signatories_form_type signatories_type signatory_logs signatory_setup sigtype specialaccess specialaccesspermission sso systemformproperties systemforms systemprofile systemprofileforms systemprofileorders systemreportingmanager systemroleprofile systemuserroleprofile system_themes tbl_connection tbl_councilor_setup tbl_form_setup_series tbl_general_elected_counselors tbl_general_elected_officials tbl_general_header_setup tbl_general_location tbl_general_setting tbl_hr_ipcr_detail tbl_hr_ipcr_evaluation_details tbl_hr_ipcr_evaluation_entry_details tbl_hr_ipcr_evaluation_entry_main tbl_hr_ipcr_evaluation_main tbl_hr_ipcr_evaluation_rating tbl_hr_ipcr_evaluation_rating_numerical tbl_hr_ipcr_evaluation_rating_scale tbl_hr_ipcr_evaluation_title tbl_hr_ipcr_main tbl_hr_ipcr_rating_matrix tbl_hr_ipcr_rating_matrix_details_quality tbl_hr_ipcr_rating_matrix_details_system tbl_hr_ipcr_rating_scale tbl_hr_ipcr_scalling tbl_hr_ipcr_work_category tbl_hr_opcr_detail tbl_hr_opcr_main tbl_ipcr_reviewed tbl_issuance tbl_login_logs tbl_order_personnel tbl_signatoryform tbl_signatorymain tbl_signatorypass tbl_signatoryrank tbl_signatorytype tbl_user_form tbl_user_form_copy tbl_user_notif_access tbl_user_notif_access_setup tbl_user_restrictions tbl_user_restrictions_check tbl_user_restrictions_journal tbl_user_security_alter timelogs transaction_logs userdepartment useroverideaccess userprofiledefaultsettings userprofilelist userrole users usersactivitylog users_activities user_employee user_type version_no .	select column