digi-gov.com / 127.0.0.1 / bac_lgu

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
queue
repository
service_request_db

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`).
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.

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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

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 :

Untitled *

v		bac_lgu bacc_1pre
id : int(11)
bacc_proj_id : int(11)
trans_date : date
ref_no : varchar(225)
name_of_project : varchar(225)
remarks : varchar(225)
proc_type : varchar(225)

v		bac_lgu bacc_2invitationtobid
id : int(11)
bacc_proj_id : int(11)
project_name : varchar(225)
itb_no : varchar(225)
philgep : date
prebidd_conference : date
opening : date
bid_fees : decimal(26,2)
itb_member_id : int(11)
ref : varchar(225)

v		bac_lgu bacc_2invitationtobid_activities
id : int(11)
bacc_proj_id : int(11)
activities : varchar(225)
schedule : varchar(225)

v		bac_lgu bacc_7suplemental
id : int(11)
bacc_proj_id : int(22)
proj_name : varchar(225)
trans_date : date
ref_no : varchar(225)
supplemental : varchar(225)
remarks : varchar(225)

v		bac_lgu bacc_15resolution
id : int(11)
bacc_proj_id : int(22)
proj_name : varchar(225)
trans_date : date
ref_no : varchar(225)
mop : varchar(225)
remarks : varchar(225)

v		bac_lgu bacc_16noa
id : int(11)
bacc_proj_id : int(22)
proj_name : varchar(225)
trans_date : date
ref_no : varchar(225)
mop : varchar(225)
date_effictive : date
remarks : varchar(225)

v		bac_lgu bacc_account_mapping
id : int(11)
entry_type : varchar(10)
account_code : varchar(225)

v		bac_lgu bacc_bid_bulletin
id : int(11)
proj_id : int(11)
bull_no : varchar(225)
trans_type : varchar(20)
attch_description : varchar(225)
remarks : varchar(225)
doctype_id : int(11)
file_name : varchar(200)
file_path : varchar(225)
file_size : varchar(30)
stat : varchar(30)
uid : int(11)
ts : timestamp
doc_main_id : int(11)

v		bac_lgu bacc_bid_opening
id : int(11)
proj_id : int(11)
business_number : int(11)
business_name : varchar(225)
bid_fees : decimal(20,2)
or_date : date
or_no : varchar(225)
abc_amount : decimal(20,2)
security_type : varchar(30)
security_remarks : varchar(225)
bidsecurity : decimal(26,2)
bidamount : decimal(26,2)
rating : varchar(225)
remarks : varchar(225)
stat : int(11)
ts : timestamp
winner : int(11)

v		bac_lgu bacc_commite_tag
id : int(11)
org_id : int(12)
description : varchar(225)

v		bac_lgu bacc_contract
id : int(11)
proj_id : int(11)
contract_date : date
contract_cost : decimal(20,6)
request_ : varchar(225)
date_sp_request : date
session_date : date
reso_attach : varchar(225)
sp_resolution_no : varchar(200)
remarks : varchar(225)

v		bac_lgu bacc_invitation_bidopening_docs
id : int(11)
proj_id : int(11)
type : varchar(225)
type_id : int(11)
file_name : varchar(225)
file_path : varchar(225)
file_size : double
stat : int(1)
ts : timestamp
uid : int(11)

v		bac_lgu bacc_invitation_opening_bid
id : int(11)
proj_id : int(11)
entry_type : varchar(225)
business_id : int(11)
business_name : varchar(200)
date_invitation : date
date_receipt : date
attachment : varchar(200)
ts : timestamp
winner : int(11)
itb_no : varchar(225)
doc_amount : decimal(26,2)
abc_amount : decimal(20,2)
organization : varchar(225)

v		bac_lgu bacc_invitation_prebid
id : int(11)
proj_id : int(11)
entry_type : varchar(225)
business_id : int(11)
business_name : varchar(200)
organization : varchar(225)
date_invitation : date
date_receipt : date
attachment : varchar(200)
ts : timestamp

v		bac_lgu bacc_invitation_prebid_docs
id : int(11)
proj_id : int(11)
type : varchar(225)
type_id : int(11)
file_name : varchar(225)
file_path : varchar(225)
file_size : double
stat : int(1)
ts : datetime
uid : int(11)

v		bac_lgu bacc_noa
id : int(11)
proj_id : int(11)
business_number : int(11)
business_name : varchar(225)
bidamount : decimal(26,2)
noa_issuance_date : date
noa_receipt : date
deadline_dole_approved : date
performance_type : varchar(30)
performance_date : date
performance_amount : decimal(20,6)
dole_cshp : date
remarks : varchar(225)
ts : timestamp
proc_type : varchar(225)

v		bac_lgu bacc_ntp
id : int(11)
proj_id : int(11)
contract_duration : varchar(200)
ntp_issuance : date
effectivity : date
expected_completion : date
remarks : text

v		bac_lgu bacc_preproc_docs
id : int(11)
type : varchar(224)
description : varchar(100)
order : int(11)
stats : int(11)

v		bac_lgu bacc_pre_docs_entry
id : int(11)
proj_id : int(11)
bull_no : varchar(225)
trans_type : varchar(20)
attch_description : varchar(225)
remarks : varchar(225)
doctype_id : int(11)
file_name : varchar(200)
file_path : varchar(225)
file_size : varchar(30)
stat : varchar(30)
uid : int(11)
ts : timestamp

v		bac_lgu bacc_proc_process
id : int(11)
process_name : varchar(225)
orderby : int(11)

v		bac_lgu bacc_proj
id : int(11)
mop_id : int(11)
mop_name : varchar(220)
proc_type : varchar(300)
ref_no : varchar(22)
itb_no : varchar(225)
trans_date : date
steps : int(11)
pow_id : int(11)
proj_id : int(11)
doc_ref : varchar(22)
title_of_project : varchar(225)
ABC : varchar(225)
SOF : varchar(225)
pre_proc : date
posting : date
pre_bid : date
bid_opening : date
post_qua : date
noa : date
posting2 : date
perf_sec : date
sp_resolution : date
contract_date : date
ntp_issuance : date
ntp_effective : date
winning_bidder : varchar(225)
bidder_id : int(11)
contract_cost : decimal(20,2)
contract_duration : varchar(30)
expected_date_completion : date
remarks : varchar(200)
ts : timestamp
stat : int(11)
bid_bulletin : tinytext
row_index : int(11)
loc_project : varchar(255)

v		bac_lgu bacc_proj_bid_declaration
id : int(11)
declaration : varchar(225)
bac_proj_id : int(11)

v		bac_lgu bacc_proj_docs
id : int(11)
bac_proj_id : int(11)
file_size : varchar(225)
file_name : varchar(225)
file_path : varchar(225)
file_full_path : varchar(225)
entry_type : varchar(225)
ts : timestamp

v		bac_lgu bacc_resolution
id : int(11)
trans_date : date
resolution_no : varchar(224)
mop_id : int(11)
mop_name : varchar(224)
mop_others : varchar(224)
remarks : text
ts : timestamp
stat : int(11)

v		bac_lgu bacc_resolution_details
id : int(11)
resolution_id : int(11)
pr_id : int(11)
title : text
pr_ref : varchar(225)
AMOUNT : decimal(26,2)
status : int(11)

v		bac_lgu bacc_resolution_title
id : int(11)
date : date
resolution_title : varchar(255)
status : int(11)

v		bac_lgu bac_attendancemember
id : int(11)
mem_id : int(11)
bacmember_id : int(11)
emp_name : varchar(225)
position : varchar(225)
category : varchar(225)
present : varchar(225)

v		bac_lgu bac_bid_invitation_leter
id : int(11)
itb_no : varchar(225)
trans_type : varchar(30)
trans_date : date
bidDate : date
bidTime : time
to_person : text
very_truly : text
approved_by : text
stat : int(11)
ts : timestamp

v		bac_lgu bac_members
id : int(11)
emp_id : int(11)
emp_name : varchar(225)
position : varchar(225)
category : varchar(225)
type : varchar(225)
status : int(11)
sig : int(11)
sig_position : varchar(225)

v		bac_lgu eligibility_documents
id : int(11)
mainID : int(11)
documents_issued : varchar(225)
date_issued : date
status : int(11)

v		bac_lgu eligibility_documents_setup
id : int(11)
document_name : varchar(225)
stat : int(11)

v		bac_lgu eligibility_main
id : int(11)
row_num : varchar(225)
business_id : int(11)
business_name : varchar(225)
business_owner : varchar(225)
business_address : varchar(225)
eligibility_description : text
mop : int(11)
abc_a : int(11)
abc_b : int(11)
abc_c : int(11)
remarks_others : varchar(225)
stat : int(11)
uid : int(11)
upid : int(11)
ts : timestamp
validity : date
Vat : varchar(225)

v		bac_lgu eligibility_non_main
id : int(11)
row_num : varchar(225)
business_id : int(11)
business_name : varchar(225)
business_owner : varchar(225)
business_address : varchar(225)
mop : int(11)
stat : int(11)
uid : int(11)
upid : int(11)
ts : timestamp
Vat : varchar(225)

v		bac_lgu eligibility_remarks
id : int(11)
main_id : int(11)
remarks : varchar(225)

v		bac_lgu isgroup_setup
ID : int(11)
MainGroup : varchar(255)
SubGroup1 : varchar(255)
SubGroup2 : varchar(255)
GroupOrder : int(11)
STATUS : varchar(10)

v		bac_lgu motion_recon
id : int(11)
bac_project_id : int(11)
mop_id : int(11)
mop_name : varchar(220)
proc_type : varchar(300)
doc_ref : varchar(22)
title_of_project : varchar(225)
ABC : varchar(225)
pre_proc : date
contract_date : date
contract_cost : decimal(20,2)
contract_duration : varchar(30)
remarks : varchar(225)
ts : timestamp
stat : int(11)
bid_bulletin : tinytext

Create relationship
FOREIGN KEY
on delete
on update