Recent
`accounting`.`law_case_document`
`budget`.`cwip_logs`
`budget`.`setup_item`
`accounting`.`glmigrate`
`qpsii_lguprocurement`.`assetpropertyreturnmain`
`general`.`tbl_issuance`
`humanresource`.`history_position`
`humanresource`.`hr_committee_setup`
`qpsii_lguengineering`.`eceo_certified_true_copy`
`budget`.`budgetsourcedescription`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: el_laravue
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
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 :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`chatlogs`.*
`chatlogs`.`id`
`chatlogs`.`email`
`chatlogs`.`fromName`
`chatlogs`.`from_uid`
`chatlogs`.`toName`
`chatlogs`.`to_uid`
`chatlogs`.`socketId`
`chatlogs`.`message`
`chatlogs`.`ts`
`chatlogs`.`isRead`
`cto_kind_business_setup`.*
`cto_kind_business_setup`.`id`
`cto_kind_business_setup`.`description`
`cto_kind_business_setup`.`class_code`
`cto_kind_business_setup`.`Clasification`
`cto_occupation_fees`.*
`cto_occupation_fees`.`id`
`cto_occupation_fees`.`description`
`cto_occupation_fees`.`income_code`
`cto_occupation_fees`.`fee`
`cto_occupation_fees`.`stat`
`docs_upload`.*
`docs_upload`.`id`
`docs_upload`.`trans_type`
`docs_upload`.`trans_id`
`docs_upload`.`file_name`
`docs_upload`.`file_path`
`docs_upload`.`file_size`
`docs_upload`.`stat`
`docs_upload`.`uid`
`ebplo_bsp`.*
`ebplo_bsp`.`id`
`ebplo_bsp`.`code`
`ebplo_bsp`.`description`
`ebplo_business_list`.*
`ebplo_business_list`.`business_number`
`ebplo_business_list`.`app_id`
`ebplo_business_list`.`business_name`
`ebplo_business_list`.`trade_name`
`ebplo_business_list`.`president`
`ebplo_business_list`.`registered`
`ebplo_business_list`.`saved_by_department_code`
`ebplo_business_list`.`business_date_started`
`ebplo_business_list`.`brgy_id`
`ebplo_business_list`.`purok_id`
`ebplo_business_list`.`purok_name`
`ebplo_business_list`.`business_address_temp`
`ebplo_business_list`.`buss_house_no`
`ebplo_business_list`.`buss_unit_no`
`ebplo_business_list`.`buss_building_name`
`ebplo_business_list`.`buss_street_no`
`ebplo_business_list`.`buss_purok`
`ebplo_business_list`.`buss_barangay`
`ebplo_business_list`.`buss_sub`
`ebplo_business_list`.`buss_city`
`ebplo_business_list`.`buss_province`
`ebplo_business_list`.`buss_email_add`
`ebplo_business_list`.`buss_contact_no`
`ebplo_business_list`.`owner_address_temp`
`ebplo_business_list`.`owner_house_no`
`ebplo_business_list`.`owner_unit_no`
`ebplo_business_list`.`owner_building_name`
`ebplo_business_list`.`owner_street_no`
`ebplo_business_list`.`owner_purok`
`ebplo_business_list`.`owner_barangay`
`ebplo_business_list`.`owner_sub`
`ebplo_business_list`.`owner_city`
`ebplo_business_list`.`owner_province`
`ebplo_business_list`.`owner_contact_no`
`ebplo_business_list`.`owner_email_add`
`ebplo_business_list`.`less_address_temp`
`ebplo_business_list`.`business_contact_no_temp`
`ebplo_business_list`.`business_email_add`
`ebplo_business_list`.`business_status`
`ebplo_business_list`.`reference_org`
`ebplo_business_list`.`less_contact_no`
`ebplo_business_list`.`less_email_add`
`ebplo_business_list`.`less_contact_person`
`ebplo_business_list`.`less_tel_no`
`ebplo_business_list`.`less_mobile`
`ebplo_business_list`.`less_email`
`ebplo_business_list`.`less_house_no`
`ebplo_business_list`.`less_unit_no`
`ebplo_business_list`.`less_building_name`
`ebplo_business_list`.`less_street_no`
`ebplo_business_list`.`less_purok`
`ebplo_business_list`.`less_barangay`
`ebplo_business_list`.`less_sub`
`ebplo_business_list`.`less_city`
`ebplo_business_list`.`less_province`
`ebplo_business_list`.`less_rental`
`ebplo_business_list`.`taxpayer`
`ebplo_business_list`.`taxpayer_lname`
`ebplo_business_list`.`taxpayer_fname`
`ebplo_business_list`.`taxpayer_mname`
`ebplo_business_list`.`local_tax_payer_id`
`ebplo_business_list`.`local_taxpayer_name`
`ebplo_business_list`.`local_business_number`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_name`.`global`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`mapa`.*
`mapa`.`id`
`mapa`.`business_id`
`mapa`.`name`
`mapa`.`address`
`mapa`.`lat`
`mapa`.`lng`
`mapa`.`type`
`mapa`.`status`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`model_has_permissions`.*
`model_has_permissions`.`permission_id`
`model_has_permissions`.`model_type`
`model_has_permissions`.`model_id`
`model_has_roles`.*
`model_has_roles`.`role_id`
`model_has_roles`.`model_type`
`model_has_roles`.`model_id`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`online_application`.*
`online_application`.`id`
`online_application`.`apptype`
`online_application`.`businessType`
`online_application`.`businesskind`
`online_application`.`businessName`
`online_application`.`tradeName`
`online_application`.`taxpayer_fname`
`online_application`.`taxpayer_mname`
`online_application`.`taxpayer_lname`
`online_application`.`ctc`
`online_application`.`barangayClearance`
`online_application`.`businessOwned`
`online_application`.`ts`
`online_application_docs`.*
`online_application_docs`.`id`
`online_application_docs`.`app_id`
`online_application_docs`.`file_size`
`online_application_docs`.`file_name`
`online_application_docs`.`file_path`
`online_application_docs`.`file_full_path`
`online_application_docs`.`entry_type`
`online_application_docs`.`ts`
`online_application_docs`.`stat`
`online_profile`.*
`online_profile`.`id`
`online_profile`.`app_id`
`online_profile`.`orgType`
`online_profile`.`mop`
`online_profile`.`isBSP`
`online_profile`.`bspNo`
`online_profile`.`bspType`
`online_profile`.`bmbeNo`
`online_profile`.`taxpayer_fname`
`online_profile`.`taxpayer_lname`
`online_profile`.`taxpayer_mname`
`online_profile`.`businessName`
`online_profile`.`tradeName`
`online_profile`.`president`
`online_profile`.`governmentIncentives`
`online_profile`.`governmentIncentivesNo`
`online_profile`.`dti_reg_no`
`online_profile`.`dti_Reg_date`
`online_profile`.`dti_Exp_date`
`online_profile`.`sss`
`online_profile`.`nfa`
`online_profile`.`pca`
`online_profile`.`ctc`
`online_profile`.`tin`
`online_profile`.`buss_house_no`
`online_profile`.`buss_unit_no`
`online_profile`.`buss_building_name`
`online_profile`.`buss_street_no`
`online_profile`.`buss_purok_name`
`online_profile`.`buss_purok`
`online_profile`.`buss_barangay`
`online_profile`.`buss_sub`
`online_profile`.`buss_city`
`online_profile`.`buss_province`
`online_profile`.`buss_contact_no`
`online_profile`.`buss_email_add`
`online_profile`.`owner_house_no`
`online_profile`.`owner_unit_no`
`online_profile`.`owner_building_name`
`online_profile`.`owner_street_no`
`online_profile`.`owner_purok`
`online_profile`.`owner_barangay`
`online_profile`.`owner_sub`
`online_profile`.`owner_city`
`online_profile`.`owner_province`
`online_profile`.`owner_contact_no`
`online_profile`.`owner_email_add`
`online_profile`.`deliveryUnit`
`online_profile`.`officeType`
`online_profile`.`OfficeOthers`
`online_profile`.`areaSqm`
`online_profile`.`representative`
`online_profile`.`male`
`online_profile`.`female`
`online_profile`.`lgucount`
`online_profile`.`less_house_no`
`online_profile`.`less_unit_no`
`online_profile`.`less_building_name`
`online_profile`.`less_street_no`
`online_profile`.`less_purok`
`online_profile`.`less_barangay`
`online_profile`.`less_sub`
`online_profile`.`less_city`
`online_profile`.`less_province`
`online_profile`.`less_contact_no`
`online_profile`.`less_email_add`
`online_profile`.`less_contact_person`
`online_profile`.`less_rental`
`online_profile`.`less_tel_no`
`online_profile`.`less_mobile`
`online_profile`.`less_email`
`online_profile`.`ts`
`online_profile`.`local_tax_payer_id`
`online_profile`.`local_taxpayer_name`
`online_profile`.`local_business_number`
`online_profile_kind_business`.*
`online_profile_kind_business`.`id`
`online_profile_kind_business`.`app_id`
`online_profile_kind_business`.`desc_id`
`online_profile_kind_business`.`desc_name`
`online_profile_kind_business`.`gross`
`online_profile_kind_business`.`remarks`
`online_profile_occupational_fee`.*
`online_profile_occupational_fee`.`id`
`online_profile_occupational_fee`.`app_id`
`online_profile_occupational_fee`.`desc_id`
`online_profile_occupational_fee`.`description`
`online_profile_occupational_fee`.`emp_count`
`online_profile_occupational_fee`.`remarks`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`guard_name`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`refbrgy`.*
`refbrgy`.`id`
`refbrgy`.`brgyCode`
`refbrgy`.`brgyDesc`
`refbrgy`.`regCode`
`refbrgy`.`provCode`
`refbrgy`.`citymunCode`
`refcitymun`.*
`refcitymun`.`id`
`refcitymun`.`psgcCode`
`refcitymun`.`citymunDesc`
`refcitymun`.`regDesc`
`refcitymun`.`provCode`
`refcitymun`.`citymunCode`
`refprovince`.*
`refprovince`.`id`
`refprovince`.`psgcCode`
`refprovince`.`provDesc`
`refprovince`.`regCode`
`refprovince`.`provCode`
`refregion`.*
`refregion`.`id`
`refregion`.`psgcCode`
`refregion`.`regDesc`
`refregion`.`regCode`
`role_has_permissions`.*
`role_has_permissions`.`permission_id`
`role_has_permissions`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`guard_name`
`roles`.`created_at`
`roles`.`updated_at`
`setup`.*
`setup`.`id`
`setup`.`transDate`
`setup`.`groupType`
`setup`.`description`
`setup`.`remarks`
`setup`.`transStat`
`setup`.`created_at`
`setup`.`updated_at`
`tbl_general_location`.*
`tbl_general_location`.`id`
`tbl_general_location`.`mun_cit_id`
`tbl_general_location`.`prov_id`
`tbl_general_location`.`reg_id`
`tbl_general_location`.`Term_From`
`tbl_general_location`.`Term_To`
`tbl_general_location`.`zip_code`
`tbl_general_location`.`overview`
`tbl_general_location`.`type`
`tbl_general_location`.`status`
`tbl_general_location`.`projectAquisition`
`tbl_general_location`.`ProjectAcq_id`
`tbl_general_location`.`year_declared`
`tbl_general_location`.`date_declared`
`tbl_item_type`.*
`tbl_item_type`.`id`
`tbl_item_type`.`name`
`tbl_item_type`.`amount`
`tbl_item_type`.`uom`
`tbl_item_type`.`status`
`tbl_items_setup`.*
`tbl_items_setup`.`id`
`tbl_items_setup`.`item_name`
`tbl_items_setup`.`uom`
`tbl_items_setup`.`date`
`tbl_items_setup`.`time`
`tbl_items_setup`.`type`
`tbl_items_setup`.`amount`
`tbl_items_setup`.`description`
`tbl_person_setup`.*
`tbl_person_setup`.`pkID`
`tbl_person_setup`.`user_id`
`tbl_person_setup`.`prefix`
`tbl_person_setup`.`fname`
`tbl_person_setup`.`mname`
`tbl_person_setup`.`lname`
`tbl_person_setup`.`suffix`
`tbl_person_setup`.`nickname`
`tbl_person_setup`.`dob`
`tbl_person_setup`.`pob`
`tbl_person_setup`.`gender`
`tbl_person_setup`.`civilStatus`
`tbl_person_setup`.`citizenship`
`tbl_person_setup`.`height`
`tbl_person_setup`.`weight`
`tbl_person_setup`.`religion`
`tbl_person_setup`.`occupation`
`tbl_person_setup`.`bloodType`
`tbl_person_setup`.`address1`
`tbl_person_setup`.`address2`
`tbl_person_setup`.`street`
`tbl_person_setup`.`barangay_id`
`tbl_person_setup`.`barangay`
`tbl_person_setup`.`cityMun_id`
`tbl_person_setup`.`cityMun`
`tbl_person_setup`.`province_id`
`tbl_person_setup`.`province`
`tbl_person_setup`.`region`
`tbl_person_setup`.`zipcode`
`tbl_person_setup`.`address1_`
`tbl_person_setup`.`address2_`
`tbl_person_setup`.`street_`
`tbl_person_setup`.`barangay_id_`
`tbl_person_setup`.`barangay_`
`tbl_person_setup`.`cityMun_id_`
`tbl_person_setup`.`cityMun_`
`tbl_person_setup`.`province_id_`
`tbl_person_setup`.`province_`
`tbl_person_setup`.`region_`
`tbl_person_setup`.`zipcode_`
`tbl_person_setup`.`telNo`
`tbl_person_setup`.`cellNo`
`tbl_person_setup`.`emailAdd`
`tbl_person_setup`.`facebook`
`tbl_person_setup`.`twitter`
`tbl_person_setup`.`instagram`
`tbl_person_setup`.`trans_stat`
`tbl_person_setup`.`created_at`
`tbl_person_setup`.`updated_at`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`local_id`
`users`.`name`
`users`.`mobile`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`verified`
`users`.`Employee_id`
`users`.`status`
`users`.`isActive`
`users`.`image_path`
`users`.`isLogin`
`users`.`cancel`
`users`.`admin`
`users`.`approved`
`users`.`Login`
`users`.`Logout`
`users`.`socketId`
`users`.`empid`
`users`.`google_id`
`vaccine_facility`.*
`vaccine_facility`.`id`
`vaccine_facility`.`facility_name`
`vaccine_facility`.`numbers`
`vaccine_facility`.`colors`
`vaccine_facility`.`target`
`vaccine_facility`.`fac_codes`
`vaccine_queuing`.*
`vaccine_queuing`.`id`
`vaccine_queuing`.`facility_id`
`vaccine_queuing`.`queuing_count`
`verify_users`.*
`verify_users`.`user_id`
`verify_users`.`token`
`verify_users`.`created_at`
`verify_users`.`updated_at`
`chatlogs`.*
`chatlogs`.`id`
`chatlogs`.`email`
`chatlogs`.`fromName`
`chatlogs`.`from_uid`
`chatlogs`.`toName`
`chatlogs`.`to_uid`
`chatlogs`.`socketId`
`chatlogs`.`message`
`chatlogs`.`ts`
`chatlogs`.`isRead`
`cto_kind_business_setup`.*
`cto_kind_business_setup`.`id`
`cto_kind_business_setup`.`description`
`cto_kind_business_setup`.`class_code`
`cto_kind_business_setup`.`Clasification`
`cto_occupation_fees`.*
`cto_occupation_fees`.`id`
`cto_occupation_fees`.`description`
`cto_occupation_fees`.`income_code`
`cto_occupation_fees`.`fee`
`cto_occupation_fees`.`stat`
`docs_upload`.*
`docs_upload`.`id`
`docs_upload`.`trans_type`
`docs_upload`.`trans_id`
`docs_upload`.`file_name`
`docs_upload`.`file_path`
`docs_upload`.`file_size`
`docs_upload`.`stat`
`docs_upload`.`uid`
`ebplo_bsp`.*
`ebplo_bsp`.`id`
`ebplo_bsp`.`code`
`ebplo_bsp`.`description`
`ebplo_business_list`.*
`ebplo_business_list`.`business_number`
`ebplo_business_list`.`app_id`
`ebplo_business_list`.`business_name`
`ebplo_business_list`.`trade_name`
`ebplo_business_list`.`president`
`ebplo_business_list`.`registered`
`ebplo_business_list`.`saved_by_department_code`
`ebplo_business_list`.`business_date_started`
`ebplo_business_list`.`brgy_id`
`ebplo_business_list`.`purok_id`
`ebplo_business_list`.`purok_name`
`ebplo_business_list`.`business_address_temp`
`ebplo_business_list`.`buss_house_no`
`ebplo_business_list`.`buss_unit_no`
`ebplo_business_list`.`buss_building_name`
`ebplo_business_list`.`buss_street_no`
`ebplo_business_list`.`buss_purok`
`ebplo_business_list`.`buss_barangay`
`ebplo_business_list`.`buss_sub`
`ebplo_business_list`.`buss_city`
`ebplo_business_list`.`buss_province`
`ebplo_business_list`.`buss_email_add`
`ebplo_business_list`.`buss_contact_no`
`ebplo_business_list`.`owner_address_temp`
`ebplo_business_list`.`owner_house_no`
`ebplo_business_list`.`owner_unit_no`
`ebplo_business_list`.`owner_building_name`
`ebplo_business_list`.`owner_street_no`
`ebplo_business_list`.`owner_purok`
`ebplo_business_list`.`owner_barangay`
`ebplo_business_list`.`owner_sub`
`ebplo_business_list`.`owner_city`
`ebplo_business_list`.`owner_province`
`ebplo_business_list`.`owner_contact_no`
`ebplo_business_list`.`owner_email_add`
`ebplo_business_list`.`less_address_temp`
`ebplo_business_list`.`business_contact_no_temp`
`ebplo_business_list`.`business_email_add`
`ebplo_business_list`.`business_status`
`ebplo_business_list`.`reference_org`
`ebplo_business_list`.`less_contact_no`
`ebplo_business_list`.`less_email_add`
`ebplo_business_list`.`less_contact_person`
`ebplo_business_list`.`less_tel_no`
`ebplo_business_list`.`less_mobile`
`ebplo_business_list`.`less_email`
`ebplo_business_list`.`less_house_no`
`ebplo_business_list`.`less_unit_no`
`ebplo_business_list`.`less_building_name`
`ebplo_business_list`.`less_street_no`
`ebplo_business_list`.`less_purok`
`ebplo_business_list`.`less_barangay`
`ebplo_business_list`.`less_sub`
`ebplo_business_list`.`less_city`
`ebplo_business_list`.`less_province`
`ebplo_business_list`.`less_rental`
`ebplo_business_list`.`taxpayer`
`ebplo_business_list`.`taxpayer_lname`
`ebplo_business_list`.`taxpayer_fname`
`ebplo_business_list`.`taxpayer_mname`
`ebplo_business_list`.`local_tax_payer_id`
`ebplo_business_list`.`local_taxpayer_name`
`ebplo_business_list`.`local_business_number`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_name`.`global`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`mapa`.*
`mapa`.`id`
`mapa`.`business_id`
`mapa`.`name`
`mapa`.`address`
`mapa`.`lat`
`mapa`.`lng`
`mapa`.`type`
`mapa`.`status`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`model_has_permissions`.*
`model_has_permissions`.`permission_id`
`model_has_permissions`.`model_type`
`model_has_permissions`.`model_id`
`model_has_roles`.*
`model_has_roles`.`role_id`
`model_has_roles`.`model_type`
`model_has_roles`.`model_id`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`online_application`.*
`online_application`.`id`
`online_application`.`apptype`
`online_application`.`businessType`
`online_application`.`businesskind`
`online_application`.`businessName`
`online_application`.`tradeName`
`online_application`.`taxpayer_fname`
`online_application`.`taxpayer_mname`
`online_application`.`taxpayer_lname`
`online_application`.`ctc`
`online_application`.`barangayClearance`
`online_application`.`businessOwned`
`online_application`.`ts`
`online_application_docs`.*
`online_application_docs`.`id`
`online_application_docs`.`app_id`
`online_application_docs`.`file_size`
`online_application_docs`.`file_name`
`online_application_docs`.`file_path`
`online_application_docs`.`file_full_path`
`online_application_docs`.`entry_type`
`online_application_docs`.`ts`
`online_application_docs`.`stat`
`online_profile`.*
`online_profile`.`id`
`online_profile`.`app_id`
`online_profile`.`orgType`
`online_profile`.`mop`
`online_profile`.`isBSP`
`online_profile`.`bspNo`
`online_profile`.`bspType`
`online_profile`.`bmbeNo`
`online_profile`.`taxpayer_fname`
`online_profile`.`taxpayer_lname`
`online_profile`.`taxpayer_mname`
`online_profile`.`businessName`
`online_profile`.`tradeName`
`online_profile`.`president`
`online_profile`.`governmentIncentives`
`online_profile`.`governmentIncentivesNo`
`online_profile`.`dti_reg_no`
`online_profile`.`dti_Reg_date`
`online_profile`.`dti_Exp_date`
`online_profile`.`sss`
`online_profile`.`nfa`
`online_profile`.`pca`
`online_profile`.`ctc`
`online_profile`.`tin`
`online_profile`.`buss_house_no`
`online_profile`.`buss_unit_no`
`online_profile`.`buss_building_name`
`online_profile`.`buss_street_no`
`online_profile`.`buss_purok_name`
`online_profile`.`buss_purok`
`online_profile`.`buss_barangay`
`online_profile`.`buss_sub`
`online_profile`.`buss_city`
`online_profile`.`buss_province`
`online_profile`.`buss_contact_no`
`online_profile`.`buss_email_add`
`online_profile`.`owner_house_no`
`online_profile`.`owner_unit_no`
`online_profile`.`owner_building_name`
`online_profile`.`owner_street_no`
`online_profile`.`owner_purok`
`online_profile`.`owner_barangay`
`online_profile`.`owner_sub`
`online_profile`.`owner_city`
`online_profile`.`owner_province`
`online_profile`.`owner_contact_no`
`online_profile`.`owner_email_add`
`online_profile`.`deliveryUnit`
`online_profile`.`officeType`
`online_profile`.`OfficeOthers`
`online_profile`.`areaSqm`
`online_profile`.`representative`
`online_profile`.`male`
`online_profile`.`female`
`online_profile`.`lgucount`
`online_profile`.`less_house_no`
`online_profile`.`less_unit_no`
`online_profile`.`less_building_name`
`online_profile`.`less_street_no`
`online_profile`.`less_purok`
`online_profile`.`less_barangay`
`online_profile`.`less_sub`
`online_profile`.`less_city`
`online_profile`.`less_province`
`online_profile`.`less_contact_no`
`online_profile`.`less_email_add`
`online_profile`.`less_contact_person`
`online_profile`.`less_rental`
`online_profile`.`less_tel_no`
`online_profile`.`less_mobile`
`online_profile`.`less_email`
`online_profile`.`ts`
`online_profile`.`local_tax_payer_id`
`online_profile`.`local_taxpayer_name`
`online_profile`.`local_business_number`
`online_profile_kind_business`.*
`online_profile_kind_business`.`id`
`online_profile_kind_business`.`app_id`
`online_profile_kind_business`.`desc_id`
`online_profile_kind_business`.`desc_name`
`online_profile_kind_business`.`gross`
`online_profile_kind_business`.`remarks`
`online_profile_occupational_fee`.*
`online_profile_occupational_fee`.`id`
`online_profile_occupational_fee`.`app_id`
`online_profile_occupational_fee`.`desc_id`
`online_profile_occupational_fee`.`description`
`online_profile_occupational_fee`.`emp_count`
`online_profile_occupational_fee`.`remarks`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`guard_name`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`refbrgy`.*
`refbrgy`.`id`
`refbrgy`.`brgyCode`
`refbrgy`.`brgyDesc`
`refbrgy`.`regCode`
`refbrgy`.`provCode`
`refbrgy`.`citymunCode`
`refcitymun`.*
`refcitymun`.`id`
`refcitymun`.`psgcCode`
`refcitymun`.`citymunDesc`
`refcitymun`.`regDesc`
`refcitymun`.`provCode`
`refcitymun`.`citymunCode`
`refprovince`.*
`refprovince`.`id`
`refprovince`.`psgcCode`
`refprovince`.`provDesc`
`refprovince`.`regCode`
`refprovince`.`provCode`
`refregion`.*
`refregion`.`id`
`refregion`.`psgcCode`
`refregion`.`regDesc`
`refregion`.`regCode`
`role_has_permissions`.*
`role_has_permissions`.`permission_id`
`role_has_permissions`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`guard_name`
`roles`.`created_at`
`roles`.`updated_at`
`setup`.*
`setup`.`id`
`setup`.`transDate`
`setup`.`groupType`
`setup`.`description`
`setup`.`remarks`
`setup`.`transStat`
`setup`.`created_at`
`setup`.`updated_at`
`tbl_general_location`.*
`tbl_general_location`.`id`
`tbl_general_location`.`mun_cit_id`
`tbl_general_location`.`prov_id`
`tbl_general_location`.`reg_id`
`tbl_general_location`.`Term_From`
`tbl_general_location`.`Term_To`
`tbl_general_location`.`zip_code`
`tbl_general_location`.`overview`
`tbl_general_location`.`type`
`tbl_general_location`.`status`
`tbl_general_location`.`projectAquisition`
`tbl_general_location`.`ProjectAcq_id`
`tbl_general_location`.`year_declared`
`tbl_general_location`.`date_declared`
`tbl_item_type`.*
`tbl_item_type`.`id`
`tbl_item_type`.`name`
`tbl_item_type`.`amount`
`tbl_item_type`.`uom`
`tbl_item_type`.`status`
`tbl_items_setup`.*
`tbl_items_setup`.`id`
`tbl_items_setup`.`item_name`
`tbl_items_setup`.`uom`
`tbl_items_setup`.`date`
`tbl_items_setup`.`time`
`tbl_items_setup`.`type`
`tbl_items_setup`.`amount`
`tbl_items_setup`.`description`
`tbl_person_setup`.*
`tbl_person_setup`.`pkID`
`tbl_person_setup`.`user_id`
`tbl_person_setup`.`prefix`
`tbl_person_setup`.`fname`
`tbl_person_setup`.`mname`
`tbl_person_setup`.`lname`
`tbl_person_setup`.`suffix`
`tbl_person_setup`.`nickname`
`tbl_person_setup`.`dob`
`tbl_person_setup`.`pob`
`tbl_person_setup`.`gender`
`tbl_person_setup`.`civilStatus`
`tbl_person_setup`.`citizenship`
`tbl_person_setup`.`height`
`tbl_person_setup`.`weight`
`tbl_person_setup`.`religion`
`tbl_person_setup`.`occupation`
`tbl_person_setup`.`bloodType`
`tbl_person_setup`.`address1`
`tbl_person_setup`.`address2`
`tbl_person_setup`.`street`
`tbl_person_setup`.`barangay_id`
`tbl_person_setup`.`barangay`
`tbl_person_setup`.`cityMun_id`
`tbl_person_setup`.`cityMun`
`tbl_person_setup`.`province_id`
`tbl_person_setup`.`province`
`tbl_person_setup`.`region`
`tbl_person_setup`.`zipcode`
`tbl_person_setup`.`address1_`
`tbl_person_setup`.`address2_`
`tbl_person_setup`.`street_`
`tbl_person_setup`.`barangay_id_`
`tbl_person_setup`.`barangay_`
`tbl_person_setup`.`cityMun_id_`
`tbl_person_setup`.`cityMun_`
`tbl_person_setup`.`province_id_`
`tbl_person_setup`.`province_`
`tbl_person_setup`.`region_`
`tbl_person_setup`.`zipcode_`
`tbl_person_setup`.`telNo`
`tbl_person_setup`.`cellNo`
`tbl_person_setup`.`emailAdd`
`tbl_person_setup`.`facebook`
`tbl_person_setup`.`twitter`
`tbl_person_setup`.`instagram`
`tbl_person_setup`.`trans_stat`
`tbl_person_setup`.`created_at`
`tbl_person_setup`.`updated_at`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`local_id`
`users`.`name`
`users`.`mobile`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`verified`
`users`.`Employee_id`
`users`.`status`
`users`.`isActive`
`users`.`image_path`
`users`.`isLogin`
`users`.`cancel`
`users`.`admin`
`users`.`approved`
`users`.`Login`
`users`.`Logout`
`users`.`socketId`
`users`.`empid`
`users`.`google_id`
`vaccine_facility`.*
`vaccine_facility`.`id`
`vaccine_facility`.`facility_name`
`vaccine_facility`.`numbers`
`vaccine_facility`.`colors`
`vaccine_facility`.`target`
`vaccine_facility`.`fac_codes`
`vaccine_queuing`.*
`vaccine_queuing`.`id`
`vaccine_queuing`.`facility_id`
`vaccine_queuing`.`queuing_count`
`verify_users`.*
`verify_users`.`user_id`
`verify_users`.`token`
`verify_users`.`created_at`
`verify_users`.`updated_at`
`chatlogs`.*
`chatlogs`.`id`
`chatlogs`.`email`
`chatlogs`.`fromName`
`chatlogs`.`from_uid`
`chatlogs`.`toName`
`chatlogs`.`to_uid`
`chatlogs`.`socketId`
`chatlogs`.`message`
`chatlogs`.`ts`
`chatlogs`.`isRead`
`cto_kind_business_setup`.*
`cto_kind_business_setup`.`id`
`cto_kind_business_setup`.`description`
`cto_kind_business_setup`.`class_code`
`cto_kind_business_setup`.`Clasification`
`cto_occupation_fees`.*
`cto_occupation_fees`.`id`
`cto_occupation_fees`.`description`
`cto_occupation_fees`.`income_code`
`cto_occupation_fees`.`fee`
`cto_occupation_fees`.`stat`
`docs_upload`.*
`docs_upload`.`id`
`docs_upload`.`trans_type`
`docs_upload`.`trans_id`
`docs_upload`.`file_name`
`docs_upload`.`file_path`
`docs_upload`.`file_size`
`docs_upload`.`stat`
`docs_upload`.`uid`
`ebplo_bsp`.*
`ebplo_bsp`.`id`
`ebplo_bsp`.`code`
`ebplo_bsp`.`description`
`ebplo_business_list`.*
`ebplo_business_list`.`business_number`
`ebplo_business_list`.`app_id`
`ebplo_business_list`.`business_name`
`ebplo_business_list`.`trade_name`
`ebplo_business_list`.`president`
`ebplo_business_list`.`registered`
`ebplo_business_list`.`saved_by_department_code`
`ebplo_business_list`.`business_date_started`
`ebplo_business_list`.`brgy_id`
`ebplo_business_list`.`purok_id`
`ebplo_business_list`.`purok_name`
`ebplo_business_list`.`business_address_temp`
`ebplo_business_list`.`buss_house_no`
`ebplo_business_list`.`buss_unit_no`
`ebplo_business_list`.`buss_building_name`
`ebplo_business_list`.`buss_street_no`
`ebplo_business_list`.`buss_purok`
`ebplo_business_list`.`buss_barangay`
`ebplo_business_list`.`buss_sub`
`ebplo_business_list`.`buss_city`
`ebplo_business_list`.`buss_province`
`ebplo_business_list`.`buss_email_add`
`ebplo_business_list`.`buss_contact_no`
`ebplo_business_list`.`owner_address_temp`
`ebplo_business_list`.`owner_house_no`
`ebplo_business_list`.`owner_unit_no`
`ebplo_business_list`.`owner_building_name`
`ebplo_business_list`.`owner_street_no`
`ebplo_business_list`.`owner_purok`
`ebplo_business_list`.`owner_barangay`
`ebplo_business_list`.`owner_sub`
`ebplo_business_list`.`owner_city`
`ebplo_business_list`.`owner_province`
`ebplo_business_list`.`owner_contact_no`
`ebplo_business_list`.`owner_email_add`
`ebplo_business_list`.`less_address_temp`
`ebplo_business_list`.`business_contact_no_temp`
`ebplo_business_list`.`business_email_add`
`ebplo_business_list`.`business_status`
`ebplo_business_list`.`reference_org`
`ebplo_business_list`.`less_contact_no`
`ebplo_business_list`.`less_email_add`
`ebplo_business_list`.`less_contact_person`
`ebplo_business_list`.`less_tel_no`
`ebplo_business_list`.`less_mobile`
`ebplo_business_list`.`less_email`
`ebplo_business_list`.`less_house_no`
`ebplo_business_list`.`less_unit_no`
`ebplo_business_list`.`less_building_name`
`ebplo_business_list`.`less_street_no`
`ebplo_business_list`.`less_purok`
`ebplo_business_list`.`less_barangay`
`ebplo_business_list`.`less_sub`
`ebplo_business_list`.`less_city`
`ebplo_business_list`.`less_province`
`ebplo_business_list`.`less_rental`
`ebplo_business_list`.`taxpayer`
`ebplo_business_list`.`taxpayer_lname`
`ebplo_business_list`.`taxpayer_fname`
`ebplo_business_list`.`taxpayer_mname`
`ebplo_business_list`.`local_tax_payer_id`
`ebplo_business_list`.`local_taxpayer_name`
`ebplo_business_list`.`local_business_number`
`failed_jobs`.*
`failed_jobs`.`id`
`failed_jobs`.`connection`
`failed_jobs`.`queue`
`failed_jobs`.`payload`
`failed_jobs`.`exception`
`failed_jobs`.`failed_at`
`form_name`.*
`form_name`.`id`
`form_name`.`module`
`form_name`.`grouping`
`form_name`.`form_name`
`form_name`.`file_route`
`form_name`.`access`
`form_name`.`global`
`form_profile`.*
`form_profile`.`id`
`form_profile`.`profile_name`
`form_profile`.`stat`
`form_profile_access`.*
`form_profile_access`.`id`
`form_profile_access`.`profile_id`
`form_profile_access`.`file_route`
`form_profile_access`.`access`
`form_user_profile`.*
`form_user_profile`.`id`
`form_user_profile`.`uid`
`form_user_profile`.`profile_id`
`lgu_brgy_setup`.*
`lgu_brgy_setup`.`SysPK_Brgy`
`lgu_brgy_setup`.`city_mun_id`
`lgu_brgy_setup`.`brgy_id`
`lgu_brgy_setup`.`brgy_name`
`lgu_brgy_setup`.`checker`
`lgu_brgy_setup`.`brgy_code`
`lgu_brgy_setup`.`URBAN_RURAL`
`lgu_brgy_setup`.`POPULATION`
`lgu_brgy_setup`.`CITY`
`lgu_brgy_setup`.`PROVINCE`
`lgu_brgy_setup`.`REGION`
`lgu_brgy_setup`.`person_code`
`lgu_brgy_setup`.`stat`
`lgu_brgy_setup`.`brgy_code1`
`lgu_purok_setup`.*
`lgu_purok_setup`.`id`
`lgu_purok_setup`.`brgy_id`
`lgu_purok_setup`.`barangay`
`lgu_purok_setup`.`purok`
`lgu_purok_setup`.`status`
`mapa`.*
`mapa`.`id`
`mapa`.`business_id`
`mapa`.`name`
`mapa`.`address`
`mapa`.`lat`
`mapa`.`lng`
`mapa`.`type`
`mapa`.`status`
`migrations`.*
`migrations`.`id`
`migrations`.`migration`
`migrations`.`batch`
`model_has_permissions`.*
`model_has_permissions`.`permission_id`
`model_has_permissions`.`model_type`
`model_has_permissions`.`model_id`
`model_has_roles`.*
`model_has_roles`.`role_id`
`model_has_roles`.`model_type`
`model_has_roles`.`model_id`
`oauth_access_tokens`.*
`oauth_access_tokens`.`id`
`oauth_access_tokens`.`user_id`
`oauth_access_tokens`.`client_id`
`oauth_access_tokens`.`name`
`oauth_access_tokens`.`scopes`
`oauth_access_tokens`.`revoked`
`oauth_access_tokens`.`created_at`
`oauth_access_tokens`.`updated_at`
`oauth_access_tokens`.`expires_at`
`oauth_auth_codes`.*
`oauth_auth_codes`.`id`
`oauth_auth_codes`.`user_id`
`oauth_auth_codes`.`client_id`
`oauth_auth_codes`.`scopes`
`oauth_auth_codes`.`revoked`
`oauth_auth_codes`.`expires_at`
`oauth_clients`.*
`oauth_clients`.`id`
`oauth_clients`.`user_id`
`oauth_clients`.`name`
`oauth_clients`.`secret`
`oauth_clients`.`redirect`
`oauth_clients`.`personal_access_client`
`oauth_clients`.`password_client`
`oauth_clients`.`revoked`
`oauth_clients`.`created_at`
`oauth_clients`.`updated_at`
`oauth_personal_access_clients`.*
`oauth_personal_access_clients`.`id`
`oauth_personal_access_clients`.`client_id`
`oauth_personal_access_clients`.`created_at`
`oauth_personal_access_clients`.`updated_at`
`oauth_refresh_tokens`.*
`oauth_refresh_tokens`.`id`
`oauth_refresh_tokens`.`access_token_id`
`oauth_refresh_tokens`.`revoked`
`oauth_refresh_tokens`.`expires_at`
`online_application`.*
`online_application`.`id`
`online_application`.`apptype`
`online_application`.`businessType`
`online_application`.`businesskind`
`online_application`.`businessName`
`online_application`.`tradeName`
`online_application`.`taxpayer_fname`
`online_application`.`taxpayer_mname`
`online_application`.`taxpayer_lname`
`online_application`.`ctc`
`online_application`.`barangayClearance`
`online_application`.`businessOwned`
`online_application`.`ts`
`online_application_docs`.*
`online_application_docs`.`id`
`online_application_docs`.`app_id`
`online_application_docs`.`file_size`
`online_application_docs`.`file_name`
`online_application_docs`.`file_path`
`online_application_docs`.`file_full_path`
`online_application_docs`.`entry_type`
`online_application_docs`.`ts`
`online_application_docs`.`stat`
`online_profile`.*
`online_profile`.`id`
`online_profile`.`app_id`
`online_profile`.`orgType`
`online_profile`.`mop`
`online_profile`.`isBSP`
`online_profile`.`bspNo`
`online_profile`.`bspType`
`online_profile`.`bmbeNo`
`online_profile`.`taxpayer_fname`
`online_profile`.`taxpayer_lname`
`online_profile`.`taxpayer_mname`
`online_profile`.`businessName`
`online_profile`.`tradeName`
`online_profile`.`president`
`online_profile`.`governmentIncentives`
`online_profile`.`governmentIncentivesNo`
`online_profile`.`dti_reg_no`
`online_profile`.`dti_Reg_date`
`online_profile`.`dti_Exp_date`
`online_profile`.`sss`
`online_profile`.`nfa`
`online_profile`.`pca`
`online_profile`.`ctc`
`online_profile`.`tin`
`online_profile`.`buss_house_no`
`online_profile`.`buss_unit_no`
`online_profile`.`buss_building_name`
`online_profile`.`buss_street_no`
`online_profile`.`buss_purok_name`
`online_profile`.`buss_purok`
`online_profile`.`buss_barangay`
`online_profile`.`buss_sub`
`online_profile`.`buss_city`
`online_profile`.`buss_province`
`online_profile`.`buss_contact_no`
`online_profile`.`buss_email_add`
`online_profile`.`owner_house_no`
`online_profile`.`owner_unit_no`
`online_profile`.`owner_building_name`
`online_profile`.`owner_street_no`
`online_profile`.`owner_purok`
`online_profile`.`owner_barangay`
`online_profile`.`owner_sub`
`online_profile`.`owner_city`
`online_profile`.`owner_province`
`online_profile`.`owner_contact_no`
`online_profile`.`owner_email_add`
`online_profile`.`deliveryUnit`
`online_profile`.`officeType`
`online_profile`.`OfficeOthers`
`online_profile`.`areaSqm`
`online_profile`.`representative`
`online_profile`.`male`
`online_profile`.`female`
`online_profile`.`lgucount`
`online_profile`.`less_house_no`
`online_profile`.`less_unit_no`
`online_profile`.`less_building_name`
`online_profile`.`less_street_no`
`online_profile`.`less_purok`
`online_profile`.`less_barangay`
`online_profile`.`less_sub`
`online_profile`.`less_city`
`online_profile`.`less_province`
`online_profile`.`less_contact_no`
`online_profile`.`less_email_add`
`online_profile`.`less_contact_person`
`online_profile`.`less_rental`
`online_profile`.`less_tel_no`
`online_profile`.`less_mobile`
`online_profile`.`less_email`
`online_profile`.`ts`
`online_profile`.`local_tax_payer_id`
`online_profile`.`local_taxpayer_name`
`online_profile`.`local_business_number`
`online_profile_kind_business`.*
`online_profile_kind_business`.`id`
`online_profile_kind_business`.`app_id`
`online_profile_kind_business`.`desc_id`
`online_profile_kind_business`.`desc_name`
`online_profile_kind_business`.`gross`
`online_profile_kind_business`.`remarks`
`online_profile_occupational_fee`.*
`online_profile_occupational_fee`.`id`
`online_profile_occupational_fee`.`app_id`
`online_profile_occupational_fee`.`desc_id`
`online_profile_occupational_fee`.`description`
`online_profile_occupational_fee`.`emp_count`
`online_profile_occupational_fee`.`remarks`
`password_resets`.*
`password_resets`.`email`
`password_resets`.`token`
`password_resets`.`created_at`
`permissions`.*
`permissions`.`id`
`permissions`.`name`
`permissions`.`guard_name`
`permissions`.`created_at`
`permissions`.`updated_at`
`personal_access_tokens`.*
`personal_access_tokens`.`id`
`personal_access_tokens`.`tokenable_type`
`personal_access_tokens`.`tokenable_id`
`personal_access_tokens`.`name`
`personal_access_tokens`.`token`
`personal_access_tokens`.`abilities`
`personal_access_tokens`.`last_used_at`
`personal_access_tokens`.`created_at`
`personal_access_tokens`.`updated_at`
`refbrgy`.*
`refbrgy`.`id`
`refbrgy`.`brgyCode`
`refbrgy`.`brgyDesc`
`refbrgy`.`regCode`
`refbrgy`.`provCode`
`refbrgy`.`citymunCode`
`refcitymun`.*
`refcitymun`.`id`
`refcitymun`.`psgcCode`
`refcitymun`.`citymunDesc`
`refcitymun`.`regDesc`
`refcitymun`.`provCode`
`refcitymun`.`citymunCode`
`refprovince`.*
`refprovince`.`id`
`refprovince`.`psgcCode`
`refprovince`.`provDesc`
`refprovince`.`regCode`
`refprovince`.`provCode`
`refregion`.*
`refregion`.`id`
`refregion`.`psgcCode`
`refregion`.`regDesc`
`refregion`.`regCode`
`role_has_permissions`.*
`role_has_permissions`.`permission_id`
`role_has_permissions`.`role_id`
`roles`.*
`roles`.`id`
`roles`.`name`
`roles`.`guard_name`
`roles`.`created_at`
`roles`.`updated_at`
`setup`.*
`setup`.`id`
`setup`.`transDate`
`setup`.`groupType`
`setup`.`description`
`setup`.`remarks`
`setup`.`transStat`
`setup`.`created_at`
`setup`.`updated_at`
`tbl_general_location`.*
`tbl_general_location`.`id`
`tbl_general_location`.`mun_cit_id`
`tbl_general_location`.`prov_id`
`tbl_general_location`.`reg_id`
`tbl_general_location`.`Term_From`
`tbl_general_location`.`Term_To`
`tbl_general_location`.`zip_code`
`tbl_general_location`.`overview`
`tbl_general_location`.`type`
`tbl_general_location`.`status`
`tbl_general_location`.`projectAquisition`
`tbl_general_location`.`ProjectAcq_id`
`tbl_general_location`.`year_declared`
`tbl_general_location`.`date_declared`
`tbl_item_type`.*
`tbl_item_type`.`id`
`tbl_item_type`.`name`
`tbl_item_type`.`amount`
`tbl_item_type`.`uom`
`tbl_item_type`.`status`
`tbl_items_setup`.*
`tbl_items_setup`.`id`
`tbl_items_setup`.`item_name`
`tbl_items_setup`.`uom`
`tbl_items_setup`.`date`
`tbl_items_setup`.`time`
`tbl_items_setup`.`type`
`tbl_items_setup`.`amount`
`tbl_items_setup`.`description`
`tbl_person_setup`.*
`tbl_person_setup`.`pkID`
`tbl_person_setup`.`user_id`
`tbl_person_setup`.`prefix`
`tbl_person_setup`.`fname`
`tbl_person_setup`.`mname`
`tbl_person_setup`.`lname`
`tbl_person_setup`.`suffix`
`tbl_person_setup`.`nickname`
`tbl_person_setup`.`dob`
`tbl_person_setup`.`pob`
`tbl_person_setup`.`gender`
`tbl_person_setup`.`civilStatus`
`tbl_person_setup`.`citizenship`
`tbl_person_setup`.`height`
`tbl_person_setup`.`weight`
`tbl_person_setup`.`religion`
`tbl_person_setup`.`occupation`
`tbl_person_setup`.`bloodType`
`tbl_person_setup`.`address1`
`tbl_person_setup`.`address2`
`tbl_person_setup`.`street`
`tbl_person_setup`.`barangay_id`
`tbl_person_setup`.`barangay`
`tbl_person_setup`.`cityMun_id`
`tbl_person_setup`.`cityMun`
`tbl_person_setup`.`province_id`
`tbl_person_setup`.`province`
`tbl_person_setup`.`region`
`tbl_person_setup`.`zipcode`
`tbl_person_setup`.`address1_`
`tbl_person_setup`.`address2_`
`tbl_person_setup`.`street_`
`tbl_person_setup`.`barangay_id_`
`tbl_person_setup`.`barangay_`
`tbl_person_setup`.`cityMun_id_`
`tbl_person_setup`.`cityMun_`
`tbl_person_setup`.`province_id_`
`tbl_person_setup`.`province_`
`tbl_person_setup`.`region_`
`tbl_person_setup`.`zipcode_`
`tbl_person_setup`.`telNo`
`tbl_person_setup`.`cellNo`
`tbl_person_setup`.`emailAdd`
`tbl_person_setup`.`facebook`
`tbl_person_setup`.`twitter`
`tbl_person_setup`.`instagram`
`tbl_person_setup`.`trans_stat`
`tbl_person_setup`.`created_at`
`tbl_person_setup`.`updated_at`
`user_logs`.*
`user_logs`.`id`
`user_logs`.`uid`
`user_logs`.`IPX`
`user_logs`.`MAC`
`user_logs`.`ts`
`users`.*
`users`.`id`
`users`.`local_id`
`users`.`name`
`users`.`mobile`
`users`.`email`
`users`.`email_verified_at`
`users`.`password`
`users`.`remember_token`
`users`.`created_at`
`users`.`updated_at`
`users`.`verified`
`users`.`Employee_id`
`users`.`status`
`users`.`isActive`
`users`.`image_path`
`users`.`isLogin`
`users`.`cancel`
`users`.`admin`
`users`.`approved`
`users`.`Login`
`users`.`Logout`
`users`.`socketId`
`users`.`empid`
`users`.`google_id`
`vaccine_facility`.*
`vaccine_facility`.`id`
`vaccine_facility`.`facility_name`
`vaccine_facility`.`numbers`
`vaccine_facility`.`colors`
`vaccine_facility`.`target`
`vaccine_facility`.`fac_codes`
`vaccine_queuing`.*
`vaccine_queuing`.`id`
`vaccine_queuing`.`facility_id`
`vaccine_queuing`.`queuing_count`
`verify_users`.*
`verify_users`.`user_id`
`verify_users`.`token`
`verify_users`.`created_at`
`verify_users`.`updated_at`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
chatlogs
cto_kind_business_setup
cto_occupation_fees
docs_upload
ebplo_bsp
ebplo_business_list
failed_jobs
form_name
form_profile
form_profile_access
form_user_profile
lgu_brgy_setup
lgu_purok_setup
mapa
migrations
model_has_permissions
model_has_roles
oauth_access_tokens
oauth_auth_codes
oauth_clients
oauth_personal_access_clients
oauth_refresh_tokens
online_application
online_application_docs
online_profile
online_profile_kind_business
online_profile_occupational_fee
password_resets
permissions
personal_access_tokens
refbrgy
refcitymun
refprovince
refregion
role_has_permissions
roles
setup
tbl_general_location
tbl_item_type
tbl_items_setup
tbl_person_setup
user_logs
users
vaccine_facility
vaccine_queuing
verify_users
SQL query on database
el_laravue
:
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.