bygrace.example.ngrok.com / 127.0.0.1 / erp_data

`performance_schema`.`events_waits_history`
`information_schema`.`INNODB_CMP_PER_INDEX`
`mysql`.`procs_priv`
`information_schema`.`TABLESPACES`
`hr_data`.`rental_properties_table`
`hr_data`.`rental_invoice_table`
`information_schema`.`INNODB_FT_INDEX_TABLE`
`erp_data`.`stockin_table`
`information_schema`.`INNODB_BUFFER_PAGE_LRU`
`information_schema`.`USER_PRIVILEGES`
There are no favorite tables.

  
New
cm9vdA==.ZXJwX2RhdGE=cm9vdA==.ZXJwX2RhdGE=0
erp_data
cm9vdA==.aHJfZGF0YQ==cm9vdA==.aHJfZGF0YQ==0
hr_data
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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.

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.

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.

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 -

Server: 127.0.0.1 »

Database: erp_data

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

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 :

Untitled *

v		erp_data account_access_table
DBID : int(250)
DBPathName : text
DBPageName : text
DBAccountNum : text
DBHasAccess : text
DBSubAccess : text
DBBranchNum : text

v		erp_data account_edit_table
DBID : int(250)
DBAccountNum : text
DBEditBy : text
DBRemarks : text
DBDate : text
DBBranchNum : text

v		erp_data account_schedule_table
DBID : int(250)
DBAccountNum : text
DBHasLunchBreak_Monday : text
DBWorkDate_Monday : text
DBTimeIN_Monday : text
DBTimeOUT_Monday : text
DBHasLunchBreak_Tuesday : text
DBWorkDate_Tuesday : text
DBTimeIN_Tuesday : text
DBTimeOUT_Tuesday : text
DBHasLunchBreak_Wednesday : text
DBWorkDate_Wednesday : text
DBTimeIN_Wednesday : text
DBTimeOUT_Wednesday : text
DBHasLunchBreak_Thursday : text
DBWorkDate_Thursday : text
DBTimeIN_Thursday : text
DBTimeOUT_Thursday : text
DBHasLunchBreak_Friday : text
DBWorkDate_Friday : text
DBTimeIN_Friday : text
DBTimeOUT_Friday : text
DBHasLunchBreak_Saturday : text
DBWorkDate_Saturday : text
DBTimeIN_Saturday : text
DBTimeOUT_Saturday : text
DBHasLunchBreak_Sunday : text
DBWorkDate_Sunday : text
DBTimeIN_Sunday : text
DBTimeOUT_Sunday : text
DBBranchNum : text

v		erp_data account_table
DBID : int(250)
DBName : text
DBRFID_Number : text
DBAccount_Number : text
DBBank_Number : text
DBUsername : text
DBPassword : text
DBRole : text
DBDepartment : text
DBPosition : text
DBBirthDate : text
DBAddress : text
DBContact : text
DBTIN : text
DBSSS : text
DBPagIbig : text
DBPhilhealth : text
DBSSSAmount : text
DBPagIbigAmount : text
DBPhilhealthAmount : text
DBSalary : text
DBNumberOfWorkingDays : text
DBStatus : text
DBLeaveCredits : text
DBStatusOfEmployment : text
DBDateHired : text
DBEmail : text
DBOvertimePayment : text
DBBranchNum : text
DBFixedSalary : text
DBNoHolidayPay : text
DBNoOvertimePay : text
DBNoNDPay : text
DBAllowance : text
DBAllowanceType : text
DBFilterChecker : text
DBCurrentSession : text

v		erp_data branch_table
DBID : int(250)
DBBranchName : text
DBAddress : text
DBContact : text
DBEmail : text
DBStatus : text
DBDate : text
DBDoubleScan : text
DBCode : text
DBMergeCode : text
DBAPIKey : text

v		erp_data dailytime_leaveofabsence_table
DBID : int(250)
DBAccountNum : text
DBDate : text
DBWorkStart : text
DBWorkEnd : text
DBTimeIn : text
DBTimeOut : text
DBReason : text
DBStatus : text
DBApprovedBy : text
DBDateApproved : text
DBLeaveType : text
DBPaymentType : text
DBBranchNum : text

v		erp_data dailytime_notimein_table
DBID : int(250)
DBAccountNum : text
DBDate : text
DBWorkStart : text
DBWorkEnd : text
DBTimeIn : text
DBTimeOut : text
DBReason : text
DBStatus : text
DBPenalty : text
DBApprovedBy : text
DBDateApproved : text
DBBranchNum : text

v		erp_data dailytime_overtime_table
DBID : int(250)
DBDailyTimeNum : text
DBAccountNum : text
DBDate : text
DBReason : text
DBApprovedBy : text
DBDateApproved : text
DBStatus : text
DBBranchNum : text

v		erp_data dailytime_shiftschedule_table
DBID : int(250)
DBDateRequest : text
DBDateFiled : text
DBDayType : text
DBHasLunchBreak : text
DBWorkStart : text
DBWorkEnd : text
DBLogBy : text
DBReason : text
DBAccountNum : text
DBBranchNum : text

v		erp_data dailytime_table
DBID : int(250)
DBAccountNum : text
DBTimeIn : text
DBTimeOut : text
DBDate : text
DBLunchOut : text
DBLunchBack : text
DBWorkStart : text
DBWorkEnd : text
DBDayType : text
DBSalary : text
DBPaymentStatus : text
DBPenalty : text
DBBonus : text
DBOvertimeStart : text
DBOvertimeIn : text
DBOvertimeOut : text
DBBreakOut1 : text
DBBreakBack2 : text
DBBreakOut2 : text
DBFixedSalary : text
DBNoHolidayPay : text
DBNoOvertimePay : text
DBNoNDPay : text
DBHasLunchBreak : text
DBOvertimePayment : text
DBPaidAmount : text
DBBreakBack1 : text
DBBranchNum : text

v		erp_data dailytime_timeadjustment_table
DBID : int(250)
DBDailyTimeNum : text
DBAccountNum : text
DBDate : text
DBWorkStart : text
DBWorkEnd : text
DBTimeIn : text
DBTimeOut : text
DBReason : text
DBStatus : text
DBPenalty : text
DBApprovedBy : text
DBDateApproved : text
DBBranchNum : text

v		erp_data ecommerce_account_table
DBID : int(250)
DBStoreName : text
DBMarketPlace : text
DBStatus : text
DBDate : text
seller_id : text
access_token : text
refresh_token : text
country_code : text
DBBranchNum : text

v		erp_data ecommerce_dropoff_table
DBID : int(250)
DBTrackingNumber : text
DBMarketPlace : text
DBBatchDropIn : text
DBDropInBy : text
DBDropInDate : text
DBDropInTime : text
DBBatchDropOut : text
DBDropOutBy : text
DBDropOutDate : text
DBDropOutTime : text
DBBranchNum : text

v		erp_data ecommerce_order_table
DBID : int(250)
DBOrderNumber : text
DBTrackingNumber : text
DBBatchUpload : text
DBBatchReleased : text
DBStatus : text
DBInventoryNum : text
DBPrice : text
DBCost : text
DBUploadedBy : text
DBDateUpload : text
DBTimeUpload : text
DBPreparedBy : text
DBDatePrepared : text
DBTimePrepared : text
DBCheckedBy : text
DBDateChecked : text
DBTimeChecked : text
DBReleasedBy : text
DBDateReleased : text
DBTimeReleased : text
DBReturnedBy : text
DBDateReturned : text
DBTimeReturned : text
DBCancelledBy : text
DBDateCancelled : text
DBTimeCancelled : text
DBPrintedBy : text
DBDatePrinted : text
DBTimePrinted : text
DBCustomer : text
DBCustomerContact : text
DBCourier : text
DBMarketPlace : text
DBFilterChecker : text
DBNote : text
DBPaymentStatus : text
DBDeductionType : text
DBSellerNum : text
DBBranchNum : text

v		erp_data ecommerce_payment_table
DBID : int(250)
DBOrderNumber : text
DBAmount : text
DBCount : text
DBDate : text
DBBranchNum : text

v		erp_data ecommerce_waybill_table
DBID : int(250)
DBTrackingNumber : text
DBAccountNum : text
DBDate : text
DBTime : text
DBBranchNum : text

v		erp_data error_table
DBID : int(250)
DBMessage : text
DBDate : text
DBTime : text

v		erp_data holidays_table
DBID : int(250)
DBDate : text
DBHolidayDate : text
DBHoliday : text
DBType : text
DBAccountNum : text
DBBranchNum : text

v		erp_data inventory_daily_record_table
DBID : int(250)
DBDate : text
DBInventoryTotalAmount : text
DBInventoryTotalStock : text
DBBranchNum : text

v		erp_data inventory_edit_stock_table
DBID : int(250)
DBInventoryNum : text
DBEditBy : text
DBFilterChecker : text
DBPreviousQuantity : text
DBNewQuantity : text
DBDate : text
DBTime : text
DBTransactionType : text
DBRemarks : text
DBBranchNum : text

v		erp_data inventory_edit_table
DBID : int(250)
DBInventoryNum : text
DBEditBy : text
DBRemarks : text
DBEditRemarks : text
DBDate : text
DBBranchNum : text

v		erp_data inventory_subitem_table
DBID : int(250)
DBDate : text
DBSubSKU : text
DBInventoryNumList : text
DBQuantityList : text
DBAccountNum : text
DBBranchNum : text

v		erp_data inventory_table
DBID : int(250)
DBProductName : text
DBBarcode : text
DBSKU : text
DBBrand : text
DBCategory : text
DBUnit : text
DBPrice1 : text
DBPrice2 : text
DBPrice3 : text
DBCost : text
DBThreshold : text
DBStatus : text
DBOnlinePrice : text
DBOnlineDiscount : text
DBOnlineDescription : text
DBDate : text
DBQuantity : text
DBBranchNum : text
TSUTSUME : text
CG : text
JF : text
FMAC : text

v		erp_data payslip_deduction_payment_table
DBID : int(250)
DBDeductionNum : text
DBDate : text
DBPayment : text
DBLogBy : text
DBBranchNum : text

v		erp_data payslip_deduction_table
DBID : int(250)
DBDetails : text
DBAmount : text
DBLogBy : text
DBDate : text
DBUnderBy : text
DBStatus : text
DBType : text
DBBranchNum : text

v		erp_data pos_cashcount_table
DBID : int(250)
DBDate : text
DBTime : text
DBAmount : text
DBAccountNum : text
DBCheckedBy : text
DBBranchNum : text

v		erp_data pos_cashrecord_table
DBID : int(250)
DBReferenceNumber : text
DBTransactionNumber : text
DBTransactionType : text
DBAmount : text
DBCashFlow : text
DBModeOfPayment : text
DBNote : text
DBDate : text
DBTime : text
DBAccountNum : text
DBBranchNum : text

v		erp_data pos_customer_credit_balance_table
DBID : int(250)
DBAccountNum : text
DBReferenceNumber : text
DBDetail : text
DBAmount : text
DBDate : text
DBTime : text
DBBranchNum : text

v		erp_data pos_customer_table
DBID : int(250)
DBCustomerName : text
DBAddress : text
DBContact : text
DBOtherInformation : text
DBStatus : text
DBDate : text
DBBranchNum : text

v		erp_data pos_payment_table
DBID : int(250)
DBReferenceNumber : text
DBPayment : text
DBModeOfPayment : text
DBNote : text
DBDate : text
DBPaymentDate : text
DBTime : text
DBAccountNum : text
DBCustomerNum : text
DBBranchNum : text

v		erp_data pos_table
DBID : int(250)
DBReferenceNumber : text
DBInvoiceNumber : text
DBDraft : text
DBTransactionType : text
DBQuantity : text
DBPrice : text
DBCost : text
DBDiscount : text
DBDate : text
DBTime : text
DBInvoiceDate : text
DBPaymentDate : text
DBInventoryNum : text
DBAccountNum : text
DBCustomerNum : text
DBCustomerType : text
DBBranchNum : text
DBFilterChecker : text
DBShippingFee : text
DBPreparedBy : text
DBDatePrepared : text
DBTimePrepared : text

v		erp_data purchase_order_table
DBID : int(250)
DBReferenceNumber : text
DBInvoiceNumber : text
DBStatus : text
DBReceivingStatus : text
DBInventoryNum : text
DBOldCost : text
DBNewCost : text
DBQuantity : text
DBNote : text
DBDate : text
DBTime : text
DBDateApproved : text
DBTimeApproved : text
DBApprovedBy : text
DBSupplierNum : text
DBFilterChecker : text
DBAccountNum : text
DBBranchNum : text

v		erp_data registration_table
DBID : int(250)
DBEmail : text
DBPassword : text
DBDate : text
DBStatus : text

v		erp_data rental_billing_table
DBID : int(250)
DBBillingName : text
DBBillingCode : text
DBAmount : text
DBStatus : text
DBAutoInput : text
DBDateCreated : text
DBTimeCreated : text
DBBranchNum : text

v		erp_data rental_invoice_payment_table
DBID : int(250)
DBReferenceNumber : text
DBPayment : text
DBModeOfPayment : text
DBNote : text
DBDate : text
DBPaymentDate : text
DBTime : text
DBAccountNum : text
DBPropertyNum : text
DBPropertyOwnerNum : text
DBBranchNum : text

v		erp_data rental_invoice_table
DBID : int(250)
DBReferenceNumber : text
DBInvoiceNumber : text
DBBillingNum : text
DBBillReading : text
DBRate : text
DBAmount : text
DBPropertyOwnerNum : text
DBPropertyNum : text
DBIsVoid : text
DBVoidDate : text
DBVoidTime : text
DBVoidBy : text
DBInvoiceDate : text
DBDateCreated : text
DBTimeCreated : text
DBAccountNum : text
DBDueDate : text
DBBranchNum : text

v		erp_data rental_properties_table
DBID : int(250)
DBProperty : text
DBPropertyType : text
DBDescription : text
DBBuildingNumber : text
DBPropertyOwnerNum : text
DBTenantNum : text
DBSquareMeter : text
DBRentalRate : text
DBAssociationDue : text
DBElectricty_PER_KWH : text
DBWater_PER_CUBIC : text
DBOccupiedDate : text
DBDateCreated : text
DBTimeCreated : text
DBBranchNum : text

v		erp_data rental_property_owner_table
DBID : int(250)
DBName : text
DBEmail : text
DBContact : text
DBPassword : text
DBStatus : text
DBDateCreated : text
DBTimeCreated : text
DBBranchNum : text

v		erp_data rental_tenant_table
DBID : int(250)
DBName : text
DBEmail : text
DBContact : text
DBPassword : text
DBStatus : text
DBDateCreated : text
DBTimeCreated : text
DBBranchNum : text

v		erp_data stockin_pending_table
DBID : int(250)
DBStockInID : text
DBStockReceived : text
DBAccountNum : text
DBDate : text
DBTime : text
DBBranchNum : text

v		erp_data stockin_table
DBID : int(250)
DBReferenceNumber : text
DBInvoiceNumber : text
DBInvoiceQuantity : text
DBActualQuantity : text
DBCost : text
DBNewCost : text
DBOldCost : text
DBNote : text
DBDate : text
DBInvoiceDate : text
DBInventoryNum : text
DBSupplierNum : text
DBFilterChecker : text
DBAccountNum : text
DBBranchNum : text

v		erp_data stockout_table
DBID : int(250)
DBReferenceNumber : text
DBInvoiceNumber : text
DBQuantity : text
DBCost : text
DBNote : text
DBDate : text
DBInvoiceDate : text
DBInventoryNum : text
DBFilterChecker : text
DBAccountNum : text
DBBranchNum : text

v		erp_data supplier_table
DBID : int(250)
DBSupplierName : text
DBAddress : text
DBContact : text
DBStatus : text
DBDate : text
DBBranchNum : text

Create relationship
FOREIGN KEY
on delete
on update