digi-gov.com / 127.0.0.1 / qpsii_systemlogs

There are no recent tables.

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		qpsii_systemlogs ecao_bldg_additional_item
id : int(11)
faas_bldg_id : int(11)
PKTransID : varchar(255)
floor_no : varchar(100)
item : varchar(200)
percent_value : double
base_value : double
area : double
total : double
ts : timestamp
userid : int(11)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_bldg_assessment
ID : int(11)
FASSID : int(11)
GUID : varchar(255)
PKTransID : varchar(255)
ClassID : int(11)
ActualUseID : int(11)
BldgTypeID : int(11)
StructuralID : int(11)
Taxable : varchar(255)
ExemptionID : int(11)
ExemptionDesc : varchar(255)
UnitCost : double
TotalArea : decimal(18,4)
TotalBaseAmount : double
BasePercent : double
BaseAmount : double
SubTotalBase : double
DepPercentBase : double
DepAmountBase : double
Additional : double
AdditionalPercent : double
AdditionalAmount : double
TotalDeduction : double
TotalCons : double
MarketValue : double
AssessmentLvl : double
AssessmentAmount : double
mv_override : int(11)
av_override : int(11)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_bldg_construction
FAASID : int(11)
GUID : varchar(255)
PKTransID : varchar(255)
FloorNo : varchar(255)
FloorId : varchar(11)
Description : text
Area : decimal(18,4)
UnitCost : double
Percent : double
TotalCost : double
ts : timestamp
userid : int(11)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_bldg_floor_area
FaasId : int(11)
FloorId : int(11)
FloorArea : double
UserId : int(11)
ts : timestamp
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_bldg
faas_bldg_id : int(11)
faas_id : int(11)
ref_td_id : int(11)
ap_td_no : varchar(255)
bldg_permit_id : varchar(255)
cct : varchar(255)
bldg_age : varchar(11)
no_of_storey : varchar(150)
total_flr_area : double
total_land_area : double
uconst_cost : double
prop_app_remarks : varchar(150)
dep_rate : varchar(100)
dep_cost : double
addtnl_item : varchar(150)
dedctnl_item : varchar(150)
total_const_cost : double
total_prcnt_dep : double
total_market_value : double
description : text
descriptionid : int(11)
others : text
date_constructed : varchar(255)
date_completed : varchar(255)
date_occupied : varchar(255)
date_issued : date
CCI_on : date
COI_on : date
structural_type : varchar(255)
structural_type_id : int(11)
land_owner : text
1stflr : varchar(255)
2ndflr : varchar(255)
3rdflr : varchar(255)
4thflr : varchar(255)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_bldg_deduction_item
id : int(11)
faas_bldg_id : int(11)
PKTransID : varchar(255)
floor_no : varchar(100)
deduction_item : varchar(200)
percentage : double
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_bldg_dtl
faas_bldg_dtl_id : int(11)
faas_bldg_id : int(11)
no_of_floor : varchar(150)
area_of_floor : double
roof_material : varchar(255)
floor_material : varchar(255)
walls_n_partition : varchar(255)
ceiling_material : varchar(255)
structural_parts : varchar(255)
material_use : varchar(255)
kind : varchar(255)
Ucost : double
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_land
faas_land_id : int(11)
faas_id : int(11)
PKGUID : varchar(255)
PKTransID : varchar(255)
sub_classID : int(11)
sub_classification : varchar(255)
area : varchar(255)
unit_value : double
percent : double
market_value : double
class_name : varchar(255)
isCalculated : varchar(100)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_land_dtl
faas_land_dtl_id : int(11)
faas_id : int(11)
PKGUID : varchar(255)
PKTransID : varchar(255)
kind : varchar(150)
kindID : int(11)
improvement_area : varchar(150)
total_no : varchar(150)
unit_value : double
percent : double
market_value : double
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_land_value_adj
dtl_id : int(11)
faas_id : int(11)
PKGUID : varchar(255)
PKTransID : varchar(255)
market_value : decimal(12,2)
adjustment_factor : varchar(255)
area : double
perc_adjustment : double
value_adjustment : decimal(12,2)
adj_marketvalue : decimal(12,2)
adj_type : varchar(100)
isupdated : int(11)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_mach
faas_mach_id : int(11)
faas_id : int(11)
PKTransID : varchar(255)
kindmachinery : varchar(255)
brand_model : varchar(255)
qty : double
capacity_hp : varchar(255)
date_acquired : varchar(255)
condition : varchar(255)
conditioned : varchar(255)
no_of_yrs : varchar(255)
estimated_yrs : varchar(255)
remaining_yrs : varchar(255)
yr_installed : varchar(255)
yr_operated : varchar(255)
original_cost : double
conv_factor : varchar(255)
rcn : varchar(255)
yrs_used : varchar(255)
rate_of_depreciation : double
total_dep_prcnt : double
total_dep_value : double
dep_value : double
dep_net_value : double
remarks : text
userid : int(11)
dateSave : datetime
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_mach_dtl
dtl_id : int(11)
faas_id : int(11)
land_tdid : int(11)
land_tdno : varchar(255)
land_owner : text
land_pinprov : varchar(255)
land_pincitymun : varchar(255)
land_pinbrgy : varchar(255)
land_pinsection : varchar(255)
land_pinparcel : varchar(255)
land_pinext : varchar(255)
bldg_tdid : int(11)
bldg_tdno : varchar(255)
bldg_owner : text
bldg_pinprov : varchar(255)
bldg_pincitymun : varchar(255)
bldg_pinbrgy : varchar(255)
bldg_pinsection : varchar(255)
bldg_pinparcel : varchar(255)
bldg_pinext : varchar(255)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_prevtd_dtl
prev_td_dtl_id : int(11)
prev_td_id : int(11)
prev_td_faas_id : int(11)
new_faas_id : int(11)
new_td_id : int(11)
new_TDNo : varchar(255)
ARPNo : varchar(255)
TDNo : varchar(255)
Owner : text
Location : text
LotNo : varchar(255)
Area : varchar(255)
PIN : varchar(255)
Year : varchar(255)
TitleNo : varchar(255)
Memo : text
EffectYear : varchar(255)
MarketValue : double
AssessedValue : double
merge_stat : varchar(255)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_profile
faas_id : int(11)
faas_num : int(11)
faas_num_con_sub : varchar(500)
arp_prov : varchar(255)
arp_city_mun : varchar(255)
arp_brgy : varchar(255)
arp_no : varchar(255)
pin_prov : varchar(255)
pin_city_mun : varchar(255)
pin_brgy : varchar(255)
pin_section : varchar(255)
pin_parcel : varchar(255)
pin_ext : varchar(255)
owner_name : text
owner_address : int(11)
owner_address_mun : int(11)
owner_address_prov_id : int(11)
owner_tin : varchar(255)
owner_tel_no : varchar(255)
beneficial_name : varchar(255)
beneficial_address : varchar(255)
beneficial_address_mun : varchar(255)
beneficial_tin : varchar(255)
beneficial_tel_no : varchar(255)
property_address : int(11)
property_address_mun : int(11)
survey_no : text
lot_no : text
cad_lot_no : text
blk_no : text
north : text
south : text
east : text
west : text
prop_type : varchar(150)
prop_type1 : varchar(150)
property_classification_id : int(11)
property_classification : varchar(255)
area_slash : text
total_area_landOrBuilding : varchar(20)
tot_assessed_value : double
tot_market_value : double
tax_type : varchar(255)
quarter : varchar(255)
year : int(11)
prev_td : int(11)
appraised_by : int(11)
date_appraised : date
recommend_by : int(11)
date_recommend : date
approved_by : int(11)
date_approved : date
recorded_by : int(11)
date_recorded : date
PersonRecording : varchar(255)
PersonRecordingDate : varchar(50)
memoranda : text
faas_status : varchar(255)
owner_address_brgy : text
owner_address_city_mun : varchar(255)
owner_address_prov : varchar(255)
beneficial_address_brgy : varchar(255)
beneficial_address_city_mun : varchar(255)
beneficial_address_prov : varchar(255)
property_address_brgy : varchar(255)
property_address_city_mun : varchar(255)
property_address_prov : varchar(255)
property_address_brgy_id : int(11)
property_address_city_mun_id : int(11)
property_address_prov_id : int(11)
prev_td_prov : varchar(255)
prev_td_city_mun : varchar(255)
prev_td_no : varchar(255)
prev_td_ext : varchar(255)
saved_by_id : int(11)
modified_by_id : int(11)
saved_date : date
modified_date : date
octtctcloa_no : varchar(150)
oct_date : date
new_td_id : int(11)
owner_add_st : text
bene_add_st : text
prop_add_st : text
owner_type : varchar(150)
fdate_saved : timestamp
annotation : text
annotation_type : varchar(250)
transaction_code : varchar(255)
adjustment_reason : text
adjustment_type : varchar(50)
adjustment_amnt : double
IsImprovement : varchar(20)
ImprovementDesc : text
previous_tdno : text
present_tdno : text
arp_no1 : varchar(255)
revision_id : int(11)
rptax_id : int(11)
agri : int(11)
importedID : int(11)
migrated : int(11)
ratbookID : int(11)
for_computation : varchar(5)
printed_name : varchar(500)
cur_userid : int(11)
cur_date : datetime
cur_uiid : varchar(255)

v		qpsii_systemlogs ecao_faas_profile_dtl
ecao_faas_dtl_id : int(11)
ecao_faas_id : int(11)
PKGUID : varchar(255)
PKTransID : varchar(255)
classid : int(11)
classification : varchar(255)
sub_class_id : int(11)
sub_class : varchar(255)
actual_use : varchar(255)
actual_use_id : int(11)
taxable : varchar(10)
tax_type : varchar(100)
dtl_area : varchar(150)
unit_value : double
market_value : double
adjustment_value : double
adj_market_value : double
assessment_level : double
assessed_value : double
isupdated : int(11)
mv_override : int(11)
av_override : int(11)
cur_uiid : varchar(255)
cur_userid : int(11)
cur_date : datetime

Create relationship
FOREIGN KEY
on delete
on update