Recent
`information_schema`.`GLOBAL_STATUS`
`information_schema`.`KEYWORDS`
`phpmyadmin`.`pma__table_coords`
`information_schema`.`FILES`
`information_schema`.`ENGINES`
`information_schema`.`PROCESSLIST`
`phpmyadmin`.`pma__favorite`
`information_schema`.`SQL_FUNCTIONS`
`information_schema`.`INDEX_STATISTICS`
`phpmyadmin`.`pma__export_templates`
Favorites
There are no favorite tables.
New
adaverificat
bank_complaint_system
citizens_community_bank
esusdb
incidencereport
information_schema
mobile_payment_system
mysql
performance_schema
phpmyadmin
test
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
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: incidencereport
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
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
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`assetsclass`.*
`assetsclass`.`assc_id`
`assetsclass`.`BankName`
`assetsclass`.`ClassName`
`assetsclass`.`Quantity`
`assetsclass`.`QtyDisposal`
`assetsclass`.`QtyAuction`
`assetsclass`.`QtyTransfer`
`assetsclass`.`BlockPrice`
`assetsclass`.`BlockType`
`assetsclass`.`otherCost`
`assetsclass`.`ActualCost`
`assetsclass`.`TotalCost`
`assetsregister`.*
`assetsregister`.`Assess_id`
`assetsregister`.`Asstype`
`assetsregister`.`AssBrand`
`assetsregister`.`AssSerNo`
`assetsregister`.`AssBranch`
`assetsregister`.`AssTagNo`
`assetsregister`.`AssStatus`
`assetsregister`.`AssetsClassName`
`assetsregister`.`Commt`
`assetsregister`.`CommReason`
`assetsregister`.`CommDate`
`assetsregister`.`OldBranch`
`assetsregister`.`NewBranch`
`assetsregister`.`InputterBranch`
`assetsregister`.`ContOrder`
`assetsregister`.`Username`
`assetsregister2`.*
`assetsregister2`.`Assess_id`
`assetsregister2`.`Asstype`
`assetsregister2`.`AssBrand`
`assetsregister2`.`AssSerNo`
`assetsregister2`.`AssBranch`
`assetsregister2`.`AssTagNo`
`assetsregister2`.`AssStatus`
`assetsregister2`.`AssetsClassName`
`assetsregister2`.`Commt`
`assetsregister2`.`CommReason`
`assetsregister2`.`CommDate`
`assetsregister2`.`OldBranch`
`assetsregister2`.`NewBranch`
`assetsregister2`.`InputterBranch`
`assetsregister2`.`ContOrder`
`assetsregister2`.`Username`
`assetsregister3`.*
`assetsregister3`.`Assess_id`
`assetsregister3`.`Asstype`
`assetsregister3`.`AssBrand`
`assetsregister3`.`AssSerNo`
`assetsregister3`.`AssBranch`
`assetsregister3`.`AssTagNo`
`assetsregister3`.`AssStatus`
`assetsregister3`.`AssetsClassName`
`assetsregister3`.`Commt`
`assetsregister3`.`CommReason`
`assetsregister3`.`CommDate`
`assetsregister3`.`OldBranch`
`assetsregister3`.`NewBranch`
`assetsregister3`.`InputterBranch`
`assetsregister3`.`ContOrder`
`assetsregister3`.`Username`
`assetsregisterold`.*
`assetsregisterold`.`Assess_id`
`assetsregisterold`.`Asstype`
`assetsregisterold`.`AssBrand`
`assetsregisterold`.`AssSerNo`
`assetsregisterold`.`AssBranch`
`assetsregisterold`.`AssTagNo`
`assetsregisterold`.`AssStatus`
`assetsregisterold`.`AssetsClassName`
`assetsregisterold`.`Commt`
`assetsregisterold`.`CommReason`
`assetsregisterold`.`CommDate`
`assetsregisterold`.`OldBranch`
`assetsregisterold`.`NewBranch`
`assetsregisterold`.`InputterBranch`
`assetsregisterold`.`ContOrder`
`assetsregisterold`.`Username`
`assetsregistert`.*
`assetsregistert`.`Assess_id`
`assetsregistert`.`Asstype`
`assetsregistert`.`AssBrand`
`assetsregistert`.`AssSerNo`
`assetsregistert`.`AssBranch`
`assetsregistert`.`AssTagNo`
`assetsregistert`.`AssStatus`
`assetsregistert`.`AssetsClassName`
`assetsregistert`.`Commt`
`assetsregistert`.`CommReason`
`assetsregistert`.`CommDate`
`assetsregistert`.`InputterBranch`
`bank`.*
`bank`.`bankid`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`ccb_phone_registry`.*
`ccb_phone_registry`.`id`
`ccb_phone_registry`.`CCB_asset_tag`
`ccb_phone_registry`.`phone_number`
`ccb_phone_registry`.`branch`
`ccb_phone_registry`.`department`
`ccb_phone_registry`.`assigned_to`
`ccb_phone_registry`.`status`
`ccb_phone_registry`.`last_lat`
`ccb_phone_registry`.`last_lon`
`ccb_phone_registry`.`last_seen`
`ccb_phone_registry`.`consent_signed`
`ccb_phone_registry`.`created_at`
`fa_asset_locations`.*
`fa_asset_locations`.`id`
`fa_asset_locations`.`asset_id`
`fa_asset_locations`.`asset_tag`
`fa_asset_locations`.`phone`
`fa_asset_locations`.`lat`
`fa_asset_locations`.`lng`
`fa_asset_locations`.`accuracy`
`fa_asset_locations`.`last_seen`
`fa_asset_locations`.`source`
`fa_assignments`.*
`fa_assignments`.`assign_id`
`fa_assignments`.`asset_id`
`fa_assignments`.`asset_tag`
`fa_assignments`.`assigned_to`
`fa_assignments`.`gender`
`fa_assignments`.`department`
`fa_assignments`.`assigned_date`
`fa_assignments`.`returned_at`
`fa_assignments`.`condition_at_issue`
`fa_assignments`.`return_condition`
`fa_assignments`.`assigned_by`
`fa_assignments`.`returned_by`
`fa_assignments`.`remarks`
`fa_assignments`.`branch`
`fa_assignments`.`status`
`fa_assignments`.`created_at`
`fa_assignments`.`staff_id`
`fa_assignments`.`phone`
`fa_assignments`.`lat`
`fa_assignments`.`lng`
`fa_audit_details`.*
`fa_audit_details`.`detail_id`
`fa_audit_details`.`audit_id`
`fa_audit_details`.`asset_id`
`fa_audit_details`.`asset_tag`
`fa_audit_details`.`expected_branch`
`fa_audit_details`.`verified_status`
`fa_audit_details`.`condition_status`
`fa_audit_details`.`actual_location`
`fa_audit_details`.`remarks`
`fa_audit_details`.`verified_by`
`fa_audit_details`.`verified_at`
`fa_audit_details`.`photo_count`
`fa_audit_photos`.*
`fa_audit_photos`.`photo_id`
`fa_audit_photos`.`detail_id`
`fa_audit_photos`.`audit_id`
`fa_audit_photos`.`asset_tag`
`fa_audit_photos`.`photo_path`
`fa_audit_photos`.`uploaded_by`
`fa_audit_photos`.`uploaded_at`
`fa_audit_sessions`.*
`fa_audit_sessions`.`audit_id`
`fa_audit_sessions`.`audit_name`
`fa_audit_sessions`.`branch`
`fa_audit_sessions`.`audit_date`
`fa_audit_sessions`.`status`
`fa_audit_sessions`.`total_assets`
`fa_audit_sessions`.`verified_count`
`fa_audit_sessions`.`created_by`
`fa_audit_sessions`.`created_at`
`fa_categories`.*
`fa_categories`.`cat_id`
`fa_categories`.`cat_name`
`fa_categories`.`dep_rate`
`fa_categories`.`useful_life_years`
`fa_categories`.`gl_code`
`fa_categories`.`created_at`
`fa_depreciation_log`.*
`fa_depreciation_log`.`log_id`
`fa_depreciation_log`.`asset_id`
`fa_depreciation_log`.`dep_month`
`fa_depreciation_log`.`dep_amount`
`fa_depreciation_log`.`acc_dep_after`
`fa_depreciation_log`.`nbv_after`
`fa_depreciation_log`.`created_at`
`fa_register`.*
`fa_register`.`asset_id`
`fa_register`.`asset_tag`
`fa_register`.`asset_name`
`fa_register`.`description`
`fa_register`.`cat_id`
`fa_register`.`branch`
`fa_register`.`location`
`fa_register`.`supplier`
`fa_register`.`invoice_no`
`fa_register`.`purchase_date`
`fa_register`.`cost`
`fa_register`.`residual_value`
`fa_register`.`useful_life_months`
`fa_register`.`dep_method`
`fa_register`.`dep_rate`
`fa_register`.`acc_dep`
`fa_register`.`nbv`
`fa_register`.`status`
`fa_register`.`disposal_date`
`fa_register`.`disposal_value`
`fa_register`.`created_by`
`fa_register`.`created_at`
`fa_transfers`.*
`fa_transfers`.`transfer_id`
`fa_transfers`.`asset_id`
`fa_transfers`.`from_branch`
`fa_transfers`.`to_branch`
`fa_transfers`.`transfer_date`
`fa_transfers`.`reason`
`fa_transfers`.`transferred_by`
`fa_transfers`.`created_at`
`fa_user_transfers`.*
`fa_user_transfers`.`transfer_id`
`fa_user_transfers`.`asset_id`
`fa_user_transfers`.`from_user`
`fa_user_transfers`.`to_user`
`fa_user_transfers`.`transfer_date`
`fa_user_transfers`.`reason`
`fa_user_transfers`.`transferred_by`
`fa_user_transfers`.`branch`
`fa_user_transfers`.`created_at`
`file`.*
`file`.`id`
`file`.`incidentId`
`file`.`name`
`file`.`mime`
`file`.`size`
`file`.`data`
`file`.`created`
`file`.`item_type`
`file`.`type`
`file`.`sendername`
`fileleave`.*
`fileleave`.`id`
`fileleave`.`incidentId`
`fileleave`.`name`
`fileleave`.`mime`
`fileleave`.`size`
`fileleave`.`data`
`fileleave`.`created`
`fileleave`.`item_type`
`fileleave`.`type`
`fileleave`.`sendername`
`gcb_gmail_inbox`.*
`gcb_gmail_inbox`.`id`
`gcb_gmail_inbox`.`phone_number`
`gcb_gmail_inbox`.`email_to`
`gcb_gmail_inbox`.`assigned_to`
`gcb_gmail_inbox`.`branch`
`gcb_gmail_inbox`.`gmail_subject`
`gcb_gmail_inbox`.`gmail_body`
`gcb_gmail_inbox`.`sent_by`
`gcb_gmail_inbox`.`status`
`gcb_gmail_inbox`.`created_at`
`gcb_phone_registry`.*
`gcb_phone_registry`.`id`
`gcb_phone_registry`.`gcb_asset_tag`
`gcb_phone_registry`.`phone_number`
`gcb_phone_registry`.`gmail`
`gcb_phone_registry`.`branch`
`gcb_phone_registry`.`department`
`gcb_phone_registry`.`assigned_to`
`gcb_phone_registry`.`accno`
`gcb_phone_registry`.`staff_id`
`gcb_phone_registry`.`consent_signed`
`gcb_phone_registry`.`consent_date`
`gcb_phone_registry`.`status`
`gcb_phone_registry`.`last_lat`
`gcb_phone_registry`.`last_lon`
`gcb_phone_registry`.`last_accuracy`
`gcb_phone_registry`.`last_seen`
`gcb_phone_registry`.`registered_by`
`gcb_phone_registry`.`created_at`
`gcb_phone_registry`.`updated_at`
`gcb_sms_inbox`.*
`gcb_sms_inbox`.`id`
`gcb_sms_inbox`.`phone_number`
`gcb_sms_inbox`.`phone_gateway`
`gcb_sms_inbox`.`assigned_to`
`gcb_sms_inbox`.`email_to`
`gcb_sms_inbox`.`sms_body`
`gcb_sms_inbox`.`branch`
`gcb_sms_inbox`.`status`
`gcb_sms_inbox`.`created_at`
`incidentdescr`.*
`incidentdescr`.`incide_id`
`incidentdescr`.`incidentnumber`
`incidentdescr`.`Template_Type`
`incidentdescr`.`Bankname`
`incidentdescr`.`Agencyname`
`incidentdescr`.`ContactNum`
`incidentdescr`.`Description`
`incidentdescr`.`Statustype`
`incidentdescr`.`IssueLogBy`
`incidentdescr`.`IssueAssignTo`
`incidentdescr`.`IssueSolution`
`incidentdescr`.`IssueLogDate`
`incidentdescr`.`IssueResolveDate`
`incidentdescr`.`IssueStatus`
`incidentdescr`.`PriorityStatus`
`incidentdescr`.`IssueAssignedDateT`
`incidentdescr`.`AddNotesUp`
`incidentdescr`.`AddNotesUpDate`
`incidentdescr`.`dateTimeS`
`incidentdescr`.`Messalert`
`incidentdescr`.`fnameAdm`
`incidentdescrit`.*
`incidentdescrit`.`incide_id`
`incidentdescrit`.`incidentnumber`
`incidentdescrit`.`Template_Type`
`incidentdescrit`.`Bankname`
`incidentdescrit`.`Agencyname`
`incidentdescrit`.`ContactNum`
`incidentdescrit`.`Description`
`incidentdescrit`.`Statustype`
`incidentdescrit`.`IssueLogBy`
`incidentdescrit`.`IssueAssignTo`
`incidentdescrit`.`IssueSolution`
`incidentdescrit`.`IssueLogDate`
`incidentdescrit`.`IssueResolveDate`
`incidentdescrit`.`IssueStatus`
`incidentdescrit`.`PriorityStatus`
`incidentdescrit`.`IssueAssignedDateT`
`incidentdescrleave`.*
`incidentdescrleave`.`incide_id`
`incidentdescrleave`.`incidentnumber`
`incidentdescrleave`.`Template_Type`
`incidentdescrleave`.`Staffname`
`incidentdescrleave`.`AppSdate`
`incidentdescrleave`.`AppEdate`
`incidentdescrleave`.`Appdays`
`incidentdescrleave`.`Bankname`
`incidentdescrleave`.`Agencyname`
`incidentdescrleave`.`ContactNum`
`incidentdescrleave`.`Description`
`incidentdescrleave`.`Statustype`
`incidentdescrleave`.`IssueLogBy`
`incidentdescrleave`.`IssueAssignTo`
`incidentdescrleave`.`IssueSolution`
`incidentdescrleave`.`IssueLogDate`
`incidentdescrleave`.`IssueResolveDate`
`incidentdescrleave`.`IssueStatus`
`incidentdescrleave`.`PriorityStatus`
`incidentdescrleave`.`IssueAssignedDateT`
`incidentdescrleave`.`AddNotesUp`
`incidentdescrleave`.`AddNotesUpDate`
`incidentdescrleave`.`dateTimeS`
`incidentdescrleave`.`Messalert`
`incidenttype`.*
`incidenttype`.`incid_id`
`incidenttype`.`IncidentTemplate`
`incidenttype`.`type`
`incidenttypeit`.*
`incidenttypeit`.`incid_id`
`incidenttypeit`.`IncidentTemplate`
`incidenttypeit`.`type`
`incidenttypeleave`.*
`incidenttypeleave`.`incid_id`
`incidenttypeleave`.`IncidentTemplate`
`incidenttypeleave`.`type`
`issuestatus`.*
`issuestatus`.`id`
`issuestatus`.`Status`
`messagealert`.*
`messagealert`.`mss_id`
`messagealert`.`FromSender`
`messagealert`.`ToSender`
`messagealert`.`Message`
`notetable`.*
`notetable`.`id`
`notetable`.`incidentnumber`
`notetable`.`NotesHistory`
`notetable`.`NotesDate`
`title`.*
`title`.`title_id`
`title`.`titlename`
`transtable`.*
`transtable`.`upload_id`
`transtable`.`upload_date`
`transtable`.`Narration`
`transtable`.`CustomerName`
`transtable`.`Credit_Amount`
`transtable`.`Debit_Amount`
`transtable`.`Debit_AccountNumber`
`transtable`.`Credit_AccountNumber`
`transtable`.`Company`
`transtable`.`Status`
`transtable`.`Upload_By`
`transtable`.`Upload_Month`
`transtable`.`upload_day`
`transtable`.`UploadYear`
`transtable`.`upload_time`
`transtable`.`Authoriser`
`transtable`.`Transid`
`transtable`.`Paid_By`
`transtable`.`Paid_Month`
`transtable`.`Paid_Year`
`transtable`.`Paid_Day`
`transtable`.`Paid_Date`
`transtable`.`Paid_Contact1`
`transtable`.`Paid_Contact2`
`transtable`.`Paid_Time`
`transtable`.`Approval_Time`
`transtable`.`idtype`
`transtable`.`idnumber`
`transtable`.`BankBranch`
`transtable`.`ServiceCharge`
`transtable`.`UploadAmount`
`transtablejournal`.*
`transtablejournal`.`upload_id`
`transtablejournal`.`upload_date`
`transtablejournal`.`Narration`
`transtablejournal`.`CustomerName`
`transtablejournal`.`Credit_Amount`
`transtablejournal`.`Debit_Amount`
`transtablejournal`.`Debit_AccountNumber`
`transtablejournal`.`Credit_AccountNumber`
`transtablejournal`.`Company`
`transtablejournal`.`Status`
`transtablejournal`.`Upload_By`
`transtablejournal`.`Upload_Month`
`transtablejournal`.`upload_day`
`transtablejournal`.`UploadYear`
`transtablejournal`.`upload_time`
`transtablejournal`.`Authoriser`
`transtablejournal`.`Transid`
`transtablejournal`.`Paid_By`
`transtablejournal`.`Paid_Month`
`transtablejournal`.`Paid_Year`
`transtablejournal`.`Paid_Day`
`transtablejournal`.`Paid_Date`
`transtablejournal`.`Paid_Contact1`
`transtablejournal`.`Paid_Contact2`
`transtablejournal`.`Paid_Time`
`transtablejournal`.`Approval_Time`
`transtablejournal`.`idtype`
`transtablejournal`.`idnumber`
`transtablejournal`.`BankBranch`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertype`.*
`usertype`.`UserT_id`
`usertype`.`User_tup`
`assetsclass`.*
`assetsclass`.`assc_id`
`assetsclass`.`BankName`
`assetsclass`.`ClassName`
`assetsclass`.`Quantity`
`assetsclass`.`QtyDisposal`
`assetsclass`.`QtyAuction`
`assetsclass`.`QtyTransfer`
`assetsclass`.`BlockPrice`
`assetsclass`.`BlockType`
`assetsclass`.`otherCost`
`assetsclass`.`ActualCost`
`assetsclass`.`TotalCost`
`assetsregister`.*
`assetsregister`.`Assess_id`
`assetsregister`.`Asstype`
`assetsregister`.`AssBrand`
`assetsregister`.`AssSerNo`
`assetsregister`.`AssBranch`
`assetsregister`.`AssTagNo`
`assetsregister`.`AssStatus`
`assetsregister`.`AssetsClassName`
`assetsregister`.`Commt`
`assetsregister`.`CommReason`
`assetsregister`.`CommDate`
`assetsregister`.`OldBranch`
`assetsregister`.`NewBranch`
`assetsregister`.`InputterBranch`
`assetsregister`.`ContOrder`
`assetsregister`.`Username`
`assetsregister2`.*
`assetsregister2`.`Assess_id`
`assetsregister2`.`Asstype`
`assetsregister2`.`AssBrand`
`assetsregister2`.`AssSerNo`
`assetsregister2`.`AssBranch`
`assetsregister2`.`AssTagNo`
`assetsregister2`.`AssStatus`
`assetsregister2`.`AssetsClassName`
`assetsregister2`.`Commt`
`assetsregister2`.`CommReason`
`assetsregister2`.`CommDate`
`assetsregister2`.`OldBranch`
`assetsregister2`.`NewBranch`
`assetsregister2`.`InputterBranch`
`assetsregister2`.`ContOrder`
`assetsregister2`.`Username`
`assetsregister3`.*
`assetsregister3`.`Assess_id`
`assetsregister3`.`Asstype`
`assetsregister3`.`AssBrand`
`assetsregister3`.`AssSerNo`
`assetsregister3`.`AssBranch`
`assetsregister3`.`AssTagNo`
`assetsregister3`.`AssStatus`
`assetsregister3`.`AssetsClassName`
`assetsregister3`.`Commt`
`assetsregister3`.`CommReason`
`assetsregister3`.`CommDate`
`assetsregister3`.`OldBranch`
`assetsregister3`.`NewBranch`
`assetsregister3`.`InputterBranch`
`assetsregister3`.`ContOrder`
`assetsregister3`.`Username`
`assetsregisterold`.*
`assetsregisterold`.`Assess_id`
`assetsregisterold`.`Asstype`
`assetsregisterold`.`AssBrand`
`assetsregisterold`.`AssSerNo`
`assetsregisterold`.`AssBranch`
`assetsregisterold`.`AssTagNo`
`assetsregisterold`.`AssStatus`
`assetsregisterold`.`AssetsClassName`
`assetsregisterold`.`Commt`
`assetsregisterold`.`CommReason`
`assetsregisterold`.`CommDate`
`assetsregisterold`.`OldBranch`
`assetsregisterold`.`NewBranch`
`assetsregisterold`.`InputterBranch`
`assetsregisterold`.`ContOrder`
`assetsregisterold`.`Username`
`assetsregistert`.*
`assetsregistert`.`Assess_id`
`assetsregistert`.`Asstype`
`assetsregistert`.`AssBrand`
`assetsregistert`.`AssSerNo`
`assetsregistert`.`AssBranch`
`assetsregistert`.`AssTagNo`
`assetsregistert`.`AssStatus`
`assetsregistert`.`AssetsClassName`
`assetsregistert`.`Commt`
`assetsregistert`.`CommReason`
`assetsregistert`.`CommDate`
`assetsregistert`.`InputterBranch`
`bank`.*
`bank`.`bankid`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`ccb_phone_registry`.*
`ccb_phone_registry`.`id`
`ccb_phone_registry`.`CCB_asset_tag`
`ccb_phone_registry`.`phone_number`
`ccb_phone_registry`.`branch`
`ccb_phone_registry`.`department`
`ccb_phone_registry`.`assigned_to`
`ccb_phone_registry`.`status`
`ccb_phone_registry`.`last_lat`
`ccb_phone_registry`.`last_lon`
`ccb_phone_registry`.`last_seen`
`ccb_phone_registry`.`consent_signed`
`ccb_phone_registry`.`created_at`
`fa_asset_locations`.*
`fa_asset_locations`.`id`
`fa_asset_locations`.`asset_id`
`fa_asset_locations`.`asset_tag`
`fa_asset_locations`.`phone`
`fa_asset_locations`.`lat`
`fa_asset_locations`.`lng`
`fa_asset_locations`.`accuracy`
`fa_asset_locations`.`last_seen`
`fa_asset_locations`.`source`
`fa_assignments`.*
`fa_assignments`.`assign_id`
`fa_assignments`.`asset_id`
`fa_assignments`.`asset_tag`
`fa_assignments`.`assigned_to`
`fa_assignments`.`gender`
`fa_assignments`.`department`
`fa_assignments`.`assigned_date`
`fa_assignments`.`returned_at`
`fa_assignments`.`condition_at_issue`
`fa_assignments`.`return_condition`
`fa_assignments`.`assigned_by`
`fa_assignments`.`returned_by`
`fa_assignments`.`remarks`
`fa_assignments`.`branch`
`fa_assignments`.`status`
`fa_assignments`.`created_at`
`fa_assignments`.`staff_id`
`fa_assignments`.`phone`
`fa_assignments`.`lat`
`fa_assignments`.`lng`
`fa_audit_details`.*
`fa_audit_details`.`detail_id`
`fa_audit_details`.`audit_id`
`fa_audit_details`.`asset_id`
`fa_audit_details`.`asset_tag`
`fa_audit_details`.`expected_branch`
`fa_audit_details`.`verified_status`
`fa_audit_details`.`condition_status`
`fa_audit_details`.`actual_location`
`fa_audit_details`.`remarks`
`fa_audit_details`.`verified_by`
`fa_audit_details`.`verified_at`
`fa_audit_details`.`photo_count`
`fa_audit_photos`.*
`fa_audit_photos`.`photo_id`
`fa_audit_photos`.`detail_id`
`fa_audit_photos`.`audit_id`
`fa_audit_photos`.`asset_tag`
`fa_audit_photos`.`photo_path`
`fa_audit_photos`.`uploaded_by`
`fa_audit_photos`.`uploaded_at`
`fa_audit_sessions`.*
`fa_audit_sessions`.`audit_id`
`fa_audit_sessions`.`audit_name`
`fa_audit_sessions`.`branch`
`fa_audit_sessions`.`audit_date`
`fa_audit_sessions`.`status`
`fa_audit_sessions`.`total_assets`
`fa_audit_sessions`.`verified_count`
`fa_audit_sessions`.`created_by`
`fa_audit_sessions`.`created_at`
`fa_categories`.*
`fa_categories`.`cat_id`
`fa_categories`.`cat_name`
`fa_categories`.`dep_rate`
`fa_categories`.`useful_life_years`
`fa_categories`.`gl_code`
`fa_categories`.`created_at`
`fa_depreciation_log`.*
`fa_depreciation_log`.`log_id`
`fa_depreciation_log`.`asset_id`
`fa_depreciation_log`.`dep_month`
`fa_depreciation_log`.`dep_amount`
`fa_depreciation_log`.`acc_dep_after`
`fa_depreciation_log`.`nbv_after`
`fa_depreciation_log`.`created_at`
`fa_register`.*
`fa_register`.`asset_id`
`fa_register`.`asset_tag`
`fa_register`.`asset_name`
`fa_register`.`description`
`fa_register`.`cat_id`
`fa_register`.`branch`
`fa_register`.`location`
`fa_register`.`supplier`
`fa_register`.`invoice_no`
`fa_register`.`purchase_date`
`fa_register`.`cost`
`fa_register`.`residual_value`
`fa_register`.`useful_life_months`
`fa_register`.`dep_method`
`fa_register`.`dep_rate`
`fa_register`.`acc_dep`
`fa_register`.`nbv`
`fa_register`.`status`
`fa_register`.`disposal_date`
`fa_register`.`disposal_value`
`fa_register`.`created_by`
`fa_register`.`created_at`
`fa_transfers`.*
`fa_transfers`.`transfer_id`
`fa_transfers`.`asset_id`
`fa_transfers`.`from_branch`
`fa_transfers`.`to_branch`
`fa_transfers`.`transfer_date`
`fa_transfers`.`reason`
`fa_transfers`.`transferred_by`
`fa_transfers`.`created_at`
`fa_user_transfers`.*
`fa_user_transfers`.`transfer_id`
`fa_user_transfers`.`asset_id`
`fa_user_transfers`.`from_user`
`fa_user_transfers`.`to_user`
`fa_user_transfers`.`transfer_date`
`fa_user_transfers`.`reason`
`fa_user_transfers`.`transferred_by`
`fa_user_transfers`.`branch`
`fa_user_transfers`.`created_at`
`file`.*
`file`.`id`
`file`.`incidentId`
`file`.`name`
`file`.`mime`
`file`.`size`
`file`.`data`
`file`.`created`
`file`.`item_type`
`file`.`type`
`file`.`sendername`
`fileleave`.*
`fileleave`.`id`
`fileleave`.`incidentId`
`fileleave`.`name`
`fileleave`.`mime`
`fileleave`.`size`
`fileleave`.`data`
`fileleave`.`created`
`fileleave`.`item_type`
`fileleave`.`type`
`fileleave`.`sendername`
`gcb_gmail_inbox`.*
`gcb_gmail_inbox`.`id`
`gcb_gmail_inbox`.`phone_number`
`gcb_gmail_inbox`.`email_to`
`gcb_gmail_inbox`.`assigned_to`
`gcb_gmail_inbox`.`branch`
`gcb_gmail_inbox`.`gmail_subject`
`gcb_gmail_inbox`.`gmail_body`
`gcb_gmail_inbox`.`sent_by`
`gcb_gmail_inbox`.`status`
`gcb_gmail_inbox`.`created_at`
`gcb_phone_registry`.*
`gcb_phone_registry`.`id`
`gcb_phone_registry`.`gcb_asset_tag`
`gcb_phone_registry`.`phone_number`
`gcb_phone_registry`.`gmail`
`gcb_phone_registry`.`branch`
`gcb_phone_registry`.`department`
`gcb_phone_registry`.`assigned_to`
`gcb_phone_registry`.`accno`
`gcb_phone_registry`.`staff_id`
`gcb_phone_registry`.`consent_signed`
`gcb_phone_registry`.`consent_date`
`gcb_phone_registry`.`status`
`gcb_phone_registry`.`last_lat`
`gcb_phone_registry`.`last_lon`
`gcb_phone_registry`.`last_accuracy`
`gcb_phone_registry`.`last_seen`
`gcb_phone_registry`.`registered_by`
`gcb_phone_registry`.`created_at`
`gcb_phone_registry`.`updated_at`
`gcb_sms_inbox`.*
`gcb_sms_inbox`.`id`
`gcb_sms_inbox`.`phone_number`
`gcb_sms_inbox`.`phone_gateway`
`gcb_sms_inbox`.`assigned_to`
`gcb_sms_inbox`.`email_to`
`gcb_sms_inbox`.`sms_body`
`gcb_sms_inbox`.`branch`
`gcb_sms_inbox`.`status`
`gcb_sms_inbox`.`created_at`
`incidentdescr`.*
`incidentdescr`.`incide_id`
`incidentdescr`.`incidentnumber`
`incidentdescr`.`Template_Type`
`incidentdescr`.`Bankname`
`incidentdescr`.`Agencyname`
`incidentdescr`.`ContactNum`
`incidentdescr`.`Description`
`incidentdescr`.`Statustype`
`incidentdescr`.`IssueLogBy`
`incidentdescr`.`IssueAssignTo`
`incidentdescr`.`IssueSolution`
`incidentdescr`.`IssueLogDate`
`incidentdescr`.`IssueResolveDate`
`incidentdescr`.`IssueStatus`
`incidentdescr`.`PriorityStatus`
`incidentdescr`.`IssueAssignedDateT`
`incidentdescr`.`AddNotesUp`
`incidentdescr`.`AddNotesUpDate`
`incidentdescr`.`dateTimeS`
`incidentdescr`.`Messalert`
`incidentdescr`.`fnameAdm`
`incidentdescrit`.*
`incidentdescrit`.`incide_id`
`incidentdescrit`.`incidentnumber`
`incidentdescrit`.`Template_Type`
`incidentdescrit`.`Bankname`
`incidentdescrit`.`Agencyname`
`incidentdescrit`.`ContactNum`
`incidentdescrit`.`Description`
`incidentdescrit`.`Statustype`
`incidentdescrit`.`IssueLogBy`
`incidentdescrit`.`IssueAssignTo`
`incidentdescrit`.`IssueSolution`
`incidentdescrit`.`IssueLogDate`
`incidentdescrit`.`IssueResolveDate`
`incidentdescrit`.`IssueStatus`
`incidentdescrit`.`PriorityStatus`
`incidentdescrit`.`IssueAssignedDateT`
`incidentdescrleave`.*
`incidentdescrleave`.`incide_id`
`incidentdescrleave`.`incidentnumber`
`incidentdescrleave`.`Template_Type`
`incidentdescrleave`.`Staffname`
`incidentdescrleave`.`AppSdate`
`incidentdescrleave`.`AppEdate`
`incidentdescrleave`.`Appdays`
`incidentdescrleave`.`Bankname`
`incidentdescrleave`.`Agencyname`
`incidentdescrleave`.`ContactNum`
`incidentdescrleave`.`Description`
`incidentdescrleave`.`Statustype`
`incidentdescrleave`.`IssueLogBy`
`incidentdescrleave`.`IssueAssignTo`
`incidentdescrleave`.`IssueSolution`
`incidentdescrleave`.`IssueLogDate`
`incidentdescrleave`.`IssueResolveDate`
`incidentdescrleave`.`IssueStatus`
`incidentdescrleave`.`PriorityStatus`
`incidentdescrleave`.`IssueAssignedDateT`
`incidentdescrleave`.`AddNotesUp`
`incidentdescrleave`.`AddNotesUpDate`
`incidentdescrleave`.`dateTimeS`
`incidentdescrleave`.`Messalert`
`incidenttype`.*
`incidenttype`.`incid_id`
`incidenttype`.`IncidentTemplate`
`incidenttype`.`type`
`incidenttypeit`.*
`incidenttypeit`.`incid_id`
`incidenttypeit`.`IncidentTemplate`
`incidenttypeit`.`type`
`incidenttypeleave`.*
`incidenttypeleave`.`incid_id`
`incidenttypeleave`.`IncidentTemplate`
`incidenttypeleave`.`type`
`issuestatus`.*
`issuestatus`.`id`
`issuestatus`.`Status`
`messagealert`.*
`messagealert`.`mss_id`
`messagealert`.`FromSender`
`messagealert`.`ToSender`
`messagealert`.`Message`
`notetable`.*
`notetable`.`id`
`notetable`.`incidentnumber`
`notetable`.`NotesHistory`
`notetable`.`NotesDate`
`title`.*
`title`.`title_id`
`title`.`titlename`
`transtable`.*
`transtable`.`upload_id`
`transtable`.`upload_date`
`transtable`.`Narration`
`transtable`.`CustomerName`
`transtable`.`Credit_Amount`
`transtable`.`Debit_Amount`
`transtable`.`Debit_AccountNumber`
`transtable`.`Credit_AccountNumber`
`transtable`.`Company`
`transtable`.`Status`
`transtable`.`Upload_By`
`transtable`.`Upload_Month`
`transtable`.`upload_day`
`transtable`.`UploadYear`
`transtable`.`upload_time`
`transtable`.`Authoriser`
`transtable`.`Transid`
`transtable`.`Paid_By`
`transtable`.`Paid_Month`
`transtable`.`Paid_Year`
`transtable`.`Paid_Day`
`transtable`.`Paid_Date`
`transtable`.`Paid_Contact1`
`transtable`.`Paid_Contact2`
`transtable`.`Paid_Time`
`transtable`.`Approval_Time`
`transtable`.`idtype`
`transtable`.`idnumber`
`transtable`.`BankBranch`
`transtable`.`ServiceCharge`
`transtable`.`UploadAmount`
`transtablejournal`.*
`transtablejournal`.`upload_id`
`transtablejournal`.`upload_date`
`transtablejournal`.`Narration`
`transtablejournal`.`CustomerName`
`transtablejournal`.`Credit_Amount`
`transtablejournal`.`Debit_Amount`
`transtablejournal`.`Debit_AccountNumber`
`transtablejournal`.`Credit_AccountNumber`
`transtablejournal`.`Company`
`transtablejournal`.`Status`
`transtablejournal`.`Upload_By`
`transtablejournal`.`Upload_Month`
`transtablejournal`.`upload_day`
`transtablejournal`.`UploadYear`
`transtablejournal`.`upload_time`
`transtablejournal`.`Authoriser`
`transtablejournal`.`Transid`
`transtablejournal`.`Paid_By`
`transtablejournal`.`Paid_Month`
`transtablejournal`.`Paid_Year`
`transtablejournal`.`Paid_Day`
`transtablejournal`.`Paid_Date`
`transtablejournal`.`Paid_Contact1`
`transtablejournal`.`Paid_Contact2`
`transtablejournal`.`Paid_Time`
`transtablejournal`.`Approval_Time`
`transtablejournal`.`idtype`
`transtablejournal`.`idnumber`
`transtablejournal`.`BankBranch`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertype`.*
`usertype`.`UserT_id`
`usertype`.`User_tup`
`assetsclass`.*
`assetsclass`.`assc_id`
`assetsclass`.`BankName`
`assetsclass`.`ClassName`
`assetsclass`.`Quantity`
`assetsclass`.`QtyDisposal`
`assetsclass`.`QtyAuction`
`assetsclass`.`QtyTransfer`
`assetsclass`.`BlockPrice`
`assetsclass`.`BlockType`
`assetsclass`.`otherCost`
`assetsclass`.`ActualCost`
`assetsclass`.`TotalCost`
`assetsregister`.*
`assetsregister`.`Assess_id`
`assetsregister`.`Asstype`
`assetsregister`.`AssBrand`
`assetsregister`.`AssSerNo`
`assetsregister`.`AssBranch`
`assetsregister`.`AssTagNo`
`assetsregister`.`AssStatus`
`assetsregister`.`AssetsClassName`
`assetsregister`.`Commt`
`assetsregister`.`CommReason`
`assetsregister`.`CommDate`
`assetsregister`.`OldBranch`
`assetsregister`.`NewBranch`
`assetsregister`.`InputterBranch`
`assetsregister`.`ContOrder`
`assetsregister`.`Username`
`assetsregister2`.*
`assetsregister2`.`Assess_id`
`assetsregister2`.`Asstype`
`assetsregister2`.`AssBrand`
`assetsregister2`.`AssSerNo`
`assetsregister2`.`AssBranch`
`assetsregister2`.`AssTagNo`
`assetsregister2`.`AssStatus`
`assetsregister2`.`AssetsClassName`
`assetsregister2`.`Commt`
`assetsregister2`.`CommReason`
`assetsregister2`.`CommDate`
`assetsregister2`.`OldBranch`
`assetsregister2`.`NewBranch`
`assetsregister2`.`InputterBranch`
`assetsregister2`.`ContOrder`
`assetsregister2`.`Username`
`assetsregister3`.*
`assetsregister3`.`Assess_id`
`assetsregister3`.`Asstype`
`assetsregister3`.`AssBrand`
`assetsregister3`.`AssSerNo`
`assetsregister3`.`AssBranch`
`assetsregister3`.`AssTagNo`
`assetsregister3`.`AssStatus`
`assetsregister3`.`AssetsClassName`
`assetsregister3`.`Commt`
`assetsregister3`.`CommReason`
`assetsregister3`.`CommDate`
`assetsregister3`.`OldBranch`
`assetsregister3`.`NewBranch`
`assetsregister3`.`InputterBranch`
`assetsregister3`.`ContOrder`
`assetsregister3`.`Username`
`assetsregisterold`.*
`assetsregisterold`.`Assess_id`
`assetsregisterold`.`Asstype`
`assetsregisterold`.`AssBrand`
`assetsregisterold`.`AssSerNo`
`assetsregisterold`.`AssBranch`
`assetsregisterold`.`AssTagNo`
`assetsregisterold`.`AssStatus`
`assetsregisterold`.`AssetsClassName`
`assetsregisterold`.`Commt`
`assetsregisterold`.`CommReason`
`assetsregisterold`.`CommDate`
`assetsregisterold`.`OldBranch`
`assetsregisterold`.`NewBranch`
`assetsregisterold`.`InputterBranch`
`assetsregisterold`.`ContOrder`
`assetsregisterold`.`Username`
`assetsregistert`.*
`assetsregistert`.`Assess_id`
`assetsregistert`.`Asstype`
`assetsregistert`.`AssBrand`
`assetsregistert`.`AssSerNo`
`assetsregistert`.`AssBranch`
`assetsregistert`.`AssTagNo`
`assetsregistert`.`AssStatus`
`assetsregistert`.`AssetsClassName`
`assetsregistert`.`Commt`
`assetsregistert`.`CommReason`
`assetsregistert`.`CommDate`
`assetsregistert`.`InputterBranch`
`bank`.*
`bank`.`bankid`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`ccb_phone_registry`.*
`ccb_phone_registry`.`id`
`ccb_phone_registry`.`CCB_asset_tag`
`ccb_phone_registry`.`phone_number`
`ccb_phone_registry`.`branch`
`ccb_phone_registry`.`department`
`ccb_phone_registry`.`assigned_to`
`ccb_phone_registry`.`status`
`ccb_phone_registry`.`last_lat`
`ccb_phone_registry`.`last_lon`
`ccb_phone_registry`.`last_seen`
`ccb_phone_registry`.`consent_signed`
`ccb_phone_registry`.`created_at`
`fa_asset_locations`.*
`fa_asset_locations`.`id`
`fa_asset_locations`.`asset_id`
`fa_asset_locations`.`asset_tag`
`fa_asset_locations`.`phone`
`fa_asset_locations`.`lat`
`fa_asset_locations`.`lng`
`fa_asset_locations`.`accuracy`
`fa_asset_locations`.`last_seen`
`fa_asset_locations`.`source`
`fa_assignments`.*
`fa_assignments`.`assign_id`
`fa_assignments`.`asset_id`
`fa_assignments`.`asset_tag`
`fa_assignments`.`assigned_to`
`fa_assignments`.`gender`
`fa_assignments`.`department`
`fa_assignments`.`assigned_date`
`fa_assignments`.`returned_at`
`fa_assignments`.`condition_at_issue`
`fa_assignments`.`return_condition`
`fa_assignments`.`assigned_by`
`fa_assignments`.`returned_by`
`fa_assignments`.`remarks`
`fa_assignments`.`branch`
`fa_assignments`.`status`
`fa_assignments`.`created_at`
`fa_assignments`.`staff_id`
`fa_assignments`.`phone`
`fa_assignments`.`lat`
`fa_assignments`.`lng`
`fa_audit_details`.*
`fa_audit_details`.`detail_id`
`fa_audit_details`.`audit_id`
`fa_audit_details`.`asset_id`
`fa_audit_details`.`asset_tag`
`fa_audit_details`.`expected_branch`
`fa_audit_details`.`verified_status`
`fa_audit_details`.`condition_status`
`fa_audit_details`.`actual_location`
`fa_audit_details`.`remarks`
`fa_audit_details`.`verified_by`
`fa_audit_details`.`verified_at`
`fa_audit_details`.`photo_count`
`fa_audit_photos`.*
`fa_audit_photos`.`photo_id`
`fa_audit_photos`.`detail_id`
`fa_audit_photos`.`audit_id`
`fa_audit_photos`.`asset_tag`
`fa_audit_photos`.`photo_path`
`fa_audit_photos`.`uploaded_by`
`fa_audit_photos`.`uploaded_at`
`fa_audit_sessions`.*
`fa_audit_sessions`.`audit_id`
`fa_audit_sessions`.`audit_name`
`fa_audit_sessions`.`branch`
`fa_audit_sessions`.`audit_date`
`fa_audit_sessions`.`status`
`fa_audit_sessions`.`total_assets`
`fa_audit_sessions`.`verified_count`
`fa_audit_sessions`.`created_by`
`fa_audit_sessions`.`created_at`
`fa_categories`.*
`fa_categories`.`cat_id`
`fa_categories`.`cat_name`
`fa_categories`.`dep_rate`
`fa_categories`.`useful_life_years`
`fa_categories`.`gl_code`
`fa_categories`.`created_at`
`fa_depreciation_log`.*
`fa_depreciation_log`.`log_id`
`fa_depreciation_log`.`asset_id`
`fa_depreciation_log`.`dep_month`
`fa_depreciation_log`.`dep_amount`
`fa_depreciation_log`.`acc_dep_after`
`fa_depreciation_log`.`nbv_after`
`fa_depreciation_log`.`created_at`
`fa_register`.*
`fa_register`.`asset_id`
`fa_register`.`asset_tag`
`fa_register`.`asset_name`
`fa_register`.`description`
`fa_register`.`cat_id`
`fa_register`.`branch`
`fa_register`.`location`
`fa_register`.`supplier`
`fa_register`.`invoice_no`
`fa_register`.`purchase_date`
`fa_register`.`cost`
`fa_register`.`residual_value`
`fa_register`.`useful_life_months`
`fa_register`.`dep_method`
`fa_register`.`dep_rate`
`fa_register`.`acc_dep`
`fa_register`.`nbv`
`fa_register`.`status`
`fa_register`.`disposal_date`
`fa_register`.`disposal_value`
`fa_register`.`created_by`
`fa_register`.`created_at`
`fa_transfers`.*
`fa_transfers`.`transfer_id`
`fa_transfers`.`asset_id`
`fa_transfers`.`from_branch`
`fa_transfers`.`to_branch`
`fa_transfers`.`transfer_date`
`fa_transfers`.`reason`
`fa_transfers`.`transferred_by`
`fa_transfers`.`created_at`
`fa_user_transfers`.*
`fa_user_transfers`.`transfer_id`
`fa_user_transfers`.`asset_id`
`fa_user_transfers`.`from_user`
`fa_user_transfers`.`to_user`
`fa_user_transfers`.`transfer_date`
`fa_user_transfers`.`reason`
`fa_user_transfers`.`transferred_by`
`fa_user_transfers`.`branch`
`fa_user_transfers`.`created_at`
`file`.*
`file`.`id`
`file`.`incidentId`
`file`.`name`
`file`.`mime`
`file`.`size`
`file`.`data`
`file`.`created`
`file`.`item_type`
`file`.`type`
`file`.`sendername`
`fileleave`.*
`fileleave`.`id`
`fileleave`.`incidentId`
`fileleave`.`name`
`fileleave`.`mime`
`fileleave`.`size`
`fileleave`.`data`
`fileleave`.`created`
`fileleave`.`item_type`
`fileleave`.`type`
`fileleave`.`sendername`
`gcb_gmail_inbox`.*
`gcb_gmail_inbox`.`id`
`gcb_gmail_inbox`.`phone_number`
`gcb_gmail_inbox`.`email_to`
`gcb_gmail_inbox`.`assigned_to`
`gcb_gmail_inbox`.`branch`
`gcb_gmail_inbox`.`gmail_subject`
`gcb_gmail_inbox`.`gmail_body`
`gcb_gmail_inbox`.`sent_by`
`gcb_gmail_inbox`.`status`
`gcb_gmail_inbox`.`created_at`
`gcb_phone_registry`.*
`gcb_phone_registry`.`id`
`gcb_phone_registry`.`gcb_asset_tag`
`gcb_phone_registry`.`phone_number`
`gcb_phone_registry`.`gmail`
`gcb_phone_registry`.`branch`
`gcb_phone_registry`.`department`
`gcb_phone_registry`.`assigned_to`
`gcb_phone_registry`.`accno`
`gcb_phone_registry`.`staff_id`
`gcb_phone_registry`.`consent_signed`
`gcb_phone_registry`.`consent_date`
`gcb_phone_registry`.`status`
`gcb_phone_registry`.`last_lat`
`gcb_phone_registry`.`last_lon`
`gcb_phone_registry`.`last_accuracy`
`gcb_phone_registry`.`last_seen`
`gcb_phone_registry`.`registered_by`
`gcb_phone_registry`.`created_at`
`gcb_phone_registry`.`updated_at`
`gcb_sms_inbox`.*
`gcb_sms_inbox`.`id`
`gcb_sms_inbox`.`phone_number`
`gcb_sms_inbox`.`phone_gateway`
`gcb_sms_inbox`.`assigned_to`
`gcb_sms_inbox`.`email_to`
`gcb_sms_inbox`.`sms_body`
`gcb_sms_inbox`.`branch`
`gcb_sms_inbox`.`status`
`gcb_sms_inbox`.`created_at`
`incidentdescr`.*
`incidentdescr`.`incide_id`
`incidentdescr`.`incidentnumber`
`incidentdescr`.`Template_Type`
`incidentdescr`.`Bankname`
`incidentdescr`.`Agencyname`
`incidentdescr`.`ContactNum`
`incidentdescr`.`Description`
`incidentdescr`.`Statustype`
`incidentdescr`.`IssueLogBy`
`incidentdescr`.`IssueAssignTo`
`incidentdescr`.`IssueSolution`
`incidentdescr`.`IssueLogDate`
`incidentdescr`.`IssueResolveDate`
`incidentdescr`.`IssueStatus`
`incidentdescr`.`PriorityStatus`
`incidentdescr`.`IssueAssignedDateT`
`incidentdescr`.`AddNotesUp`
`incidentdescr`.`AddNotesUpDate`
`incidentdescr`.`dateTimeS`
`incidentdescr`.`Messalert`
`incidentdescr`.`fnameAdm`
`incidentdescrit`.*
`incidentdescrit`.`incide_id`
`incidentdescrit`.`incidentnumber`
`incidentdescrit`.`Template_Type`
`incidentdescrit`.`Bankname`
`incidentdescrit`.`Agencyname`
`incidentdescrit`.`ContactNum`
`incidentdescrit`.`Description`
`incidentdescrit`.`Statustype`
`incidentdescrit`.`IssueLogBy`
`incidentdescrit`.`IssueAssignTo`
`incidentdescrit`.`IssueSolution`
`incidentdescrit`.`IssueLogDate`
`incidentdescrit`.`IssueResolveDate`
`incidentdescrit`.`IssueStatus`
`incidentdescrit`.`PriorityStatus`
`incidentdescrit`.`IssueAssignedDateT`
`incidentdescrleave`.*
`incidentdescrleave`.`incide_id`
`incidentdescrleave`.`incidentnumber`
`incidentdescrleave`.`Template_Type`
`incidentdescrleave`.`Staffname`
`incidentdescrleave`.`AppSdate`
`incidentdescrleave`.`AppEdate`
`incidentdescrleave`.`Appdays`
`incidentdescrleave`.`Bankname`
`incidentdescrleave`.`Agencyname`
`incidentdescrleave`.`ContactNum`
`incidentdescrleave`.`Description`
`incidentdescrleave`.`Statustype`
`incidentdescrleave`.`IssueLogBy`
`incidentdescrleave`.`IssueAssignTo`
`incidentdescrleave`.`IssueSolution`
`incidentdescrleave`.`IssueLogDate`
`incidentdescrleave`.`IssueResolveDate`
`incidentdescrleave`.`IssueStatus`
`incidentdescrleave`.`PriorityStatus`
`incidentdescrleave`.`IssueAssignedDateT`
`incidentdescrleave`.`AddNotesUp`
`incidentdescrleave`.`AddNotesUpDate`
`incidentdescrleave`.`dateTimeS`
`incidentdescrleave`.`Messalert`
`incidenttype`.*
`incidenttype`.`incid_id`
`incidenttype`.`IncidentTemplate`
`incidenttype`.`type`
`incidenttypeit`.*
`incidenttypeit`.`incid_id`
`incidenttypeit`.`IncidentTemplate`
`incidenttypeit`.`type`
`incidenttypeleave`.*
`incidenttypeleave`.`incid_id`
`incidenttypeleave`.`IncidentTemplate`
`incidenttypeleave`.`type`
`issuestatus`.*
`issuestatus`.`id`
`issuestatus`.`Status`
`messagealert`.*
`messagealert`.`mss_id`
`messagealert`.`FromSender`
`messagealert`.`ToSender`
`messagealert`.`Message`
`notetable`.*
`notetable`.`id`
`notetable`.`incidentnumber`
`notetable`.`NotesHistory`
`notetable`.`NotesDate`
`title`.*
`title`.`title_id`
`title`.`titlename`
`transtable`.*
`transtable`.`upload_id`
`transtable`.`upload_date`
`transtable`.`Narration`
`transtable`.`CustomerName`
`transtable`.`Credit_Amount`
`transtable`.`Debit_Amount`
`transtable`.`Debit_AccountNumber`
`transtable`.`Credit_AccountNumber`
`transtable`.`Company`
`transtable`.`Status`
`transtable`.`Upload_By`
`transtable`.`Upload_Month`
`transtable`.`upload_day`
`transtable`.`UploadYear`
`transtable`.`upload_time`
`transtable`.`Authoriser`
`transtable`.`Transid`
`transtable`.`Paid_By`
`transtable`.`Paid_Month`
`transtable`.`Paid_Year`
`transtable`.`Paid_Day`
`transtable`.`Paid_Date`
`transtable`.`Paid_Contact1`
`transtable`.`Paid_Contact2`
`transtable`.`Paid_Time`
`transtable`.`Approval_Time`
`transtable`.`idtype`
`transtable`.`idnumber`
`transtable`.`BankBranch`
`transtable`.`ServiceCharge`
`transtable`.`UploadAmount`
`transtablejournal`.*
`transtablejournal`.`upload_id`
`transtablejournal`.`upload_date`
`transtablejournal`.`Narration`
`transtablejournal`.`CustomerName`
`transtablejournal`.`Credit_Amount`
`transtablejournal`.`Debit_Amount`
`transtablejournal`.`Debit_AccountNumber`
`transtablejournal`.`Credit_AccountNumber`
`transtablejournal`.`Company`
`transtablejournal`.`Status`
`transtablejournal`.`Upload_By`
`transtablejournal`.`Upload_Month`
`transtablejournal`.`upload_day`
`transtablejournal`.`UploadYear`
`transtablejournal`.`upload_time`
`transtablejournal`.`Authoriser`
`transtablejournal`.`Transid`
`transtablejournal`.`Paid_By`
`transtablejournal`.`Paid_Month`
`transtablejournal`.`Paid_Year`
`transtablejournal`.`Paid_Day`
`transtablejournal`.`Paid_Date`
`transtablejournal`.`Paid_Contact1`
`transtablejournal`.`Paid_Contact2`
`transtablejournal`.`Paid_Time`
`transtablejournal`.`Approval_Time`
`transtablejournal`.`idtype`
`transtablejournal`.`idnumber`
`transtablejournal`.`BankBranch`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertype`.*
`usertype`.`UserT_id`
`usertype`.`User_tup`
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
assetsclass
assetsregister
assetsregister2
assetsregister3
assetsregisterold
assetsregistert
bank
bankbranch
ccb_phone_registry
fa_asset_locations
fa_assignments
fa_audit_details
fa_audit_photos
fa_audit_sessions
fa_categories
fa_depreciation_log
fa_register
fa_transfers
fa_user_transfers
file
fileleave
gcb_gmail_inbox
gcb_phone_registry
gcb_sms_inbox
incidentdescr
incidentdescrit
incidentdescrleave
incidenttype
incidenttypeit
incidenttypeleave
issuestatus
messagealert
notetable
title
transtable
transtablejournal
usertable
usertype
SQL query on database
incidencereport
: