近期访问
`loansystemdb`.`tb_user`
`loansystemdb`.`tb_cashcount`
`loansystemdb`.`tb_customer`
`loansystemdb`.`tb_customerattach`
`loansystemdb`.`tb_loanrequest`
`loansystemdb`.`tb_cashtransfer`
`loansystemdb`.`tb_saving`
`loansystemdb`.`tb_uniqueinvoice`
`loansystemdb`.`tb_product`
`loansystemdb`.`readme`
表收藏夹
表收藏夹为空。
新建
information_schema
loansystemdb
mysql
performance_schema
phpmyadmin
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: loansystemdb
结构
SQL
搜索
查询
(current)
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
切换到
可视化查询生成器
搜索已经保存的书签:
新建书签
字段:
`readme`.*
`readme`.`id`
`readme`.`Message`
`readme`.`Email`
`readme`.`Bitcoin_Address`
`tb_branchoffice`.*
`tb_branchoffice`.`ID`
`tb_branchoffice`.`branchname`
`tb_branchoffice`.`Khmername`
`tb_branchoffice`.`Englishname`
`tb_branchoffice`.`Address`
`tb_branchoffice`.`officephone`
`tb_branchoffice`.`email`
`tb_branchoffice`.`website`
`tb_branchoffice`.`status`
`tb_cashclose`.*
`tb_cashclose`.`id`
`tb_cashclose`.`cashid`
`tb_cashclose`.`dateclose`
`tb_cashclose`.`amtcash`
`tb_cashclose`.`currency`
`tb_cashclose`.`Username`
`tb_cashclose`.`Branchoffice`
`tb_cashcount`.*
`tb_cashcount`.`id`
`tb_cashcount`.`cashid`
`tb_cashcount`.`branchoffice`
`tb_cashcount`.`dateclose`
`tb_cashcount`.`currency`
`tb_cashcount`.`cashcount`
`tb_cashcount`.`number`
`tb_cashcount`.`username`
`tb_cashrecieve`.*
`tb_cashrecieve`.`ID`
`tb_cashrecieve`.`Timestamp`
`tb_cashrecieve`.`UserName`
`tb_cashrecieve`.`BranchOffice`
`tb_cashrecieve`.`loanID`
`tb_cashrecieve`.`InvoiceType`
`tb_cashrecieve`.`CustomerID`
`tb_cashrecieve`.`BookingType`
`tb_cashrecieve`.`DateBooking`
`tb_cashrecieve`.`Currency`
`tb_cashrecieve`.`AmtDeposit`
`tb_cashrecieve`.`AmtWithdraw`
`tb_cashrecieve`.`AccountID`
`tb_cashrecieve`.`Note`
`tb_cashrecieve`.`StaffID`
`tb_cashrecieve`.`UserNTm`
`tb_cashrecieve`.`Principlepaid`
`tb_cashrecieve`.`Interestpaid`
`tb_cashrecieve`.`OperationPaid`
`tb_cashrecieve`.`SavingPaid`
`tb_cashrecieve`.`PenaltyPaid`
`tb_cashrecieve`.`AmtPaid`
`tb_cashrecieve`.`No`
`tb_cashrecieve`.`datepayment`
`tb_cashtransfer`.*
`tb_cashtransfer`.`ID`
`tb_cashtransfer`.`TimeStamp`
`tb_cashtransfer`.`date`
`tb_cashtransfer`.`Branchoffice`
`tb_cashtransfer`.`Username`
`tb_cashtransfer`.`AccountID`
`tb_cashtransfer`.`CashIn`
`tb_cashtransfer`.`CashOut`
`tb_cashtransfer`.`Currency`
`tb_cashtransfer`.`Branchname`
`tb_cashtransfer`.`Note`
`tb_category`.*
`tb_category`.`CategoryID`
`tb_category`.`Username`
`tb_category`.`CategoryName`
`tb_category`.`CDesption`
`tb_category`.`Category_Pic`
`tb_category`.`CWidth`
`tb_category`.`CLength`
`tb_category`.`CNorth`
`tb_category`.`CSouth`
`tb_category`.`CWest`
`tb_category`.`CEast`
`tb_category`.`CVillage`
`tb_category`.`CCommune`
`tb_category`.`CDistrict`
`tb_category`.`CCity`
`tb_category`.`UserNTm`
`tb_chartaccount`.*
`tb_chartaccount`.`ID`
`tb_chartaccount`.`TimeStamp`
`tb_chartaccount`.`Username`
`tb_chartaccount`.`AccountID`
`tb_chartaccount`.`AccountName`
`tb_chartaccount`.`AccountType`
`tb_chartaccount`.`SubAccountID`
`tb_chartaccount`.`Status`
`tb_collateral`.*
`tb_collateral`.`ID`
`tb_collateral`.`LoanID`
`tb_collateral`.`CustomerID`
`tb_collateral`.`CollateralType`
`tb_collateral`.`DateAttd`
`tb_collateral`.`CollateralName`
`tb_collateral`.`CollateralNo`
`tb_collateral`.`OwnerName`
`tb_collateral`.`DateIssued`
`tb_collateral`.`Price`
`tb_collateral`.`Status`
`tb_collateral`.`CollateralPic`
`tb_collateraldocument`.*
`tb_collateraldocument`.`ID`
`tb_collateraldocument`.`TimeStamp`
`tb_collateraldocument`.`Username`
`tb_collateraldocument`.`Branchoffice`
`tb_collateraldocument`.`LoanID`
`tb_collateraldocument`.`CustomerID`
`tb_collateraldocument`.`DocType`
`tb_collateraldocument`.`DocNum`
`tb_collateraldocument`.`DateIssued`
`tb_collateraldocument`.`OwnerDoc`
`tb_collateralestate`.*
`tb_collateralestate`.`ID`
`tb_collateralestate`.`TimeStamp`
`tb_collateralestate`.`Username`
`tb_collateralestate`.`Branchoffice`
`tb_collateralestate`.`LoanID`
`tb_collateralestate`.`CustomerID`
`tb_collateralestate`.`DocType`
`tb_collateralestate`.`DateIssued`
`tb_collateralestate`.`DocNum`
`tb_collateralestate`.`CollateralType`
`tb_collateralestate`.`Issuedby`
`tb_collateralestate`.`Size`
`tb_collateralestate`.`North`
`tb_collateralestate`.`South`
`tb_collateralestate`.`East`
`tb_collateralestate`.`West`
`tb_collateralestate`.`Note`
`tb_collateralestate`.`EstimatePrice`
`tb_collateralestate`.`Pic`
`tb_collateralvichel`.*
`tb_collateralvichel`.`ID`
`tb_collateralvichel`.`Username`
`tb_collateralvichel`.`Branchoffice`
`tb_collateralvichel`.`LoanID`
`tb_collateralvichel`.`CustomerID`
`tb_collateralvichel`.`CollatType`
`tb_collateralvichel`.`Brand`
`tb_collateralvichel`.`Color`
`tb_collateralvichel`.`PlateNum`
`tb_collateralvichel`.`BodyNum`
`tb_collateralvichel`.`MachineNum`
`tb_collateralvichel`.`YearProduct`
`tb_collateralvichel`.`latabot`
`tb_collateralvichel`.`Issuedby`
`tb_collateralvichel`.`DocType`
`tb_collateralvichel`.`Note`
`tb_collateralvichel`.`EstimatePrice`
`tb_collateralvichel`.`Pic`
`tb_customer`.*
`tb_customer`.`CustomerID`
`tb_customer`.`Timestamp`
`tb_customer`.`UserName`
`tb_customer`.`BranchOffice`
`tb_customer`.`KhmerName`
`tb_customer`.`LatinName`
`tb_customer`.`Sex`
`tb_customer`.`Nationality`
`tb_customer`.`Dob`
`tb_customer`.`IDCard`
`tb_customer`.`NoCard`
`tb_customer`.`DateIssue`
`tb_customer`.`DateExpir`
`tb_customer`.`Issued By`
`tb_customer`.`NoStreet`
`tb_customer`.`NoHouse`
`tb_customer`.`Addgroup`
`tb_customer`.`Village`
`tb_customer`.`Commune`
`tb_customer`.`District`
`tb_customer`.`City`
`tb_customer`.`Job`
`tb_customer`.`WorkPlace`
`tb_customer`.`Role`
`tb_customer`.`CellPhone`
`tb_customer`.`HomePhone`
`tb_customer`.`WorkPhone`
`tb_customer`.`Email`
`tb_customer`.`Facebook`
`tb_customer`.`CustPhoto`
`tb_customer`.`Address_Map`
`tb_customer`.`Relationship`
`tb_customer`.`Co_KhmerName`
`tb_customer`.`Co_LatinName`
`tb_customer`.`Co_Sex`
`tb_customer`.`Co_Nationality`
`tb_customer`.`Co_Dob`
`tb_customer`.`Co_IDCard`
`tb_customer`.`Co_NoCard`
`tb_customer`.`Co_DateIssue`
`tb_customer`.`Co_DateExpir`
`tb_customer`.`Co_Issued By`
`tb_customer`.`Co_NoStreet`
`tb_customer`.`Co_NoHouse`
`tb_customer`.`Co_Group`
`tb_customer`.`Co_Village`
`tb_customer`.`Co_Commune`
`tb_customer`.`Co_District`
`tb_customer`.`Co_City`
`tb_customer`.`Co_Job`
`tb_customer`.`Co_WorkPlace`
`tb_customer`.`Co_Role`
`tb_customer`.`Co_CellPhone`
`tb_customer`.`Co_HomePhone`
`tb_customer`.`Co_WorkPhone`
`tb_customer`.`Co_Email`
`tb_customer`.`Co_Facebook`
`tb_customer`.`Co_CustPhoto`
`tb_customer`.`Status`
`tb_customer`.`UserNTm`
`tb_customerattach`.*
`tb_customerattach`.`ID`
`tb_customerattach`.`CustomerID`
`tb_customerattach`.`BranchOffice`
`tb_customerattach`.`DateAttached`
`tb_customerattach`.`AttachName`
`tb_customerattach`.`OwnerName`
`tb_customerattach`.`AttachNo`
`tb_customerattach`.`AttachPic`
`tb_guarantee`.*
`tb_guarantee`.`GuaranteeID`
`tb_guarantee`.`Timestamp`
`tb_guarantee`.`UserName`
`tb_guarantee`.`BranchOffice`
`tb_guarantee`.`Khmername`
`tb_guarantee`.`LatinName`
`tb_guarantee`.`Sex`
`tb_guarantee`.`Nationality`
`tb_guarantee`.`Dob`
`tb_guarantee`.`IDCard`
`tb_guarantee`.`NoCard`
`tb_guarantee`.`DateIssue`
`tb_guarantee`.`DateExpir`
`tb_guarantee`.`Issued By`
`tb_guarantee`.`NoStreet`
`tb_guarantee`.`NoHouse`
`tb_guarantee`.`Addgroup`
`tb_guarantee`.`Village`
`tb_guarantee`.`Commune`
`tb_guarantee`.`District`
`tb_guarantee`.`City`
`tb_guarantee`.`Job`
`tb_guarantee`.`WorkPlace`
`tb_guarantee`.`Role`
`tb_guarantee`.`CellPhone`
`tb_guarantee`.`HomePhone`
`tb_guarantee`.`WorkPhone`
`tb_guarantee`.`Email`
`tb_guarantee`.`Facebook`
`tb_guarantee`.`GuarPhoto`
`tb_guarantee`.`Address_Map`
`tb_guarantee`.`Relationship`
`tb_guarantee`.`Co_KhmerName`
`tb_guarantee`.`Co_LatinName`
`tb_guarantee`.`Co_Sex`
`tb_guarantee`.`Co_Nationality`
`tb_guarantee`.`Co_Dob`
`tb_guarantee`.`Co_IDCard`
`tb_guarantee`.`Co_NoCard`
`tb_guarantee`.`Co_DateIssue`
`tb_guarantee`.`Co_DateExpir`
`tb_guarantee`.`Co_Issued By`
`tb_guarantee`.`Co_NoStreet`
`tb_guarantee`.`Co_NoHouse`
`tb_guarantee`.`Co_Group`
`tb_guarantee`.`Co_Village`
`tb_guarantee`.`Co_Commune`
`tb_guarantee`.`Co_District`
`tb_guarantee`.`Co_City`
`tb_guarantee`.`Co_Job`
`tb_guarantee`.`Co_WorkPlace`
`tb_guarantee`.`Co_Role`
`tb_guarantee`.`Co_CellPhone`
`tb_guarantee`.`Co_HomePhone`
`tb_guarantee`.`Co_WorkPhone`
`tb_guarantee`.`Co_Email`
`tb_guarantee`.`Co_Facebook`
`tb_guarantee`.`Co_GuarPhoto`
`tb_guarantee`.`Status`
`tb_guarantee`.`UserNTm`
`tb_invoicedetail`.*
`tb_invoicedetail`.`ID`
`tb_invoicedetail`.`UserName`
`tb_invoicedetail`.`BranchOffice`
`tb_invoicedetail`.`InvoiceDate`
`tb_invoicedetail`.`InvoiceID`
`tb_invoicedetail`.`CustomerID`
`tb_invoicedetail`.`ProductID`
`tb_invoicedetail`.`Quanty`
`tb_invoicedetail`.`Price`
`tb_invoicedetail`.`Discount`
`tb_invoicedetail`.`Tax`
`tb_invoicedetail`.`Cost`
`tb_invoicedetail`.`Invoicetype`
`tb_journalentry`.*
`tb_journalentry`.`ID`
`tb_journalentry`.`UserName`
`tb_journalentry`.`BranchOffice`
`tb_journalentry`.`GLID`
`tb_journalentry`.`DateGL`
`tb_journalentry`.`Transection_Type`
`tb_journalentry`.`Currency`
`tb_journalentry`.`AccountID`
`tb_journalentry`.`Debit`
`tb_journalentry`.`Credit`
`tb_journalentry`.`Note`
`tb_journalentry`.`CashID`
`tb_journalentry`.`UserNTm`
`tb_journalid`.*
`tb_journalid`.`GLID`
`tb_journalid`.`TimeStamp`
`tb_journalid`.`Username`
`tb_journalid`.`BranchOffice`
`tb_journalid`.`UserNTm`
`tb_loanrequest`.*
`tb_loanrequest`.`loanID`
`tb_loanrequest`.`TimeStamp`
`tb_loanrequest`.`UserName`
`tb_loanrequest`.`BranchOffice`
`tb_loanrequest`.`CustomerID`
`tb_loanrequest`.`LoanType`
`tb_loanrequest`.`LoanCycle`
`tb_loanrequest`.`Currency`
`tb_loanrequest`.`Loansize`
`tb_loanrequest`.`InterestRate`
`tb_loanrequest`.`Term`
`tb_loanrequest`.`TimePayment`
`tb_loanrequest`.`PaymentType`
`tb_loanrequest`.`DateDisbusement`
`tb_loanrequest`.`DateCollect`
`tb_loanrequest`.`DateClose`
`tb_loanrequest`.`StaffID`
`tb_loanrequest`.`DepositRequire`
`tb_loanrequest`.`AdminFee`
`tb_loanrequest`.`OtherFee`
`tb_loanrequest`.`OperationFee`
`tb_loanrequest`.`Saving`
`tb_loanrequest`.`GuaranteeID`
`tb_loanrequest`.`RalationShip`
`tb_loanrequest`.`LoanPurpose`
`tb_loanrequest`.`LoanStatus`
`tb_loanrequest`.`DateWriteOff`
`tb_loanrequest`.`ComisionCo`
`tb_loanrequest`.`ComisionID`
`tb_loanrequest`.`ComisionAgent`
`tb_loanrequest`.`Amtfirstday`
`tb_loanrequest`.`UserNTm`
`tb_product`.*
`tb_product`.`ProductID`
`tb_product`.`UserName`
`tb_product`.`ProductName`
`tb_product`.`ProductType`
`tb_product`.`CategoryID`
`tb_product`.`PDesption`
`tb_product`.`Unit`
`tb_product`.`Cost`
`tb_product`.`Price`
`tb_product`.`tax`
`tb_product`.`PWidth`
`tb_product`.`PLength`
`tb_product`.`PNorth`
`tb_product`.`PSouth`
`tb_product`.`PWest`
`tb_product`.`PEast`
`tb_product`.`PVillage`
`tb_product`.`PCommune`
`tb_product`.`PDistrict`
`tb_product`.`PCity`
`tb_product`.`Status`
`tb_product`.`Product_Pic`
`tb_product`.`UserNTm`
`tb_repaymentterm`.*
`tb_repaymentterm`.`ID`
`tb_repaymentterm`.`InvoiceID`
`tb_repaymentterm`.`CustomerID`
`tb_repaymentterm`.`DatePay`
`tb_repaymentterm`.`AmtPay`
`tb_repaymentterm`.`Percentage`
`tb_saving`.*
`tb_saving`.`SavingID`
`tb_saving`.`Timestamp`
`tb_saving`.`UserName`
`tb_saving`.`BranchOffice`
`tb_saving`.`CustomerID`
`tb_saving`.`SavingType`
`tb_saving`.`Cycle`
`tb_saving`.`Currency`
`tb_saving`.`SavingAmount`
`tb_saving`.`Rate`
`tb_saving`.`Term`
`tb_saving`.`TimeSaving`
`tb_saving`.`Note`
`tb_saving`.`DateSaving`
`tb_saving`.`DateClose`
`tb_saving`.`AdminFee`
`tb_saving`.`StaffID`
`tb_saving`.`ComisionCo`
`tb_saving`.`ComisionID`
`tb_saving`.`ComisionAgent`
`tb_saving`.`UserNTm`
`tb_savingschedule`.*
`tb_savingschedule`.`ID`
`tb_savingschedule`.`savingID`
`tb_savingschedule`.`customerid`
`tb_savingschedule`.`No`
`tb_savingschedule`.`Bbprint`
`tb_savingschedule`.`principle`
`tb_savingschedule`.`interest`
`tb_savingschedule`.`amtpay`
`tb_savingschedule`.`endingbalance`
`tb_savingschedule`.`datepayment`
`tb_schedule`.*
`tb_schedule`.`ID`
`tb_schedule`.`LoanID`
`tb_schedule`.`CustomerID`
`tb_schedule`.`No`
`tb_schedule`.`DatePayment`
`tb_schedule`.`NumbDay`
`tb_schedule`.`BeginnigBalance`
`tb_schedule`.`Principle`
`tb_schedule`.`Interest`
`tb_schedule`.`Operation`
`tb_schedule`.`Saving`
`tb_schedule`.`AmtPayment`
`tb_schedule`.`LoanOutstanding`
`tb_schedule`.`Status`
`tb_staff`.*
`tb_staff`.`StaffID`
`tb_staff`.`TimeStamp`
`tb_staff`.`UserName`
`tb_staff`.`StaffName`
`tb_staff`.`Phone`
`tb_staff`.`BranchOffice`
`tb_staff`.`Type`
`tb_staff`.`Status`
`tb_staff`.`Photo`
`tb_staff`.`UserNTm`
`tb_uniqueinvoice`.*
`tb_uniqueinvoice`.`InvoiceID`
`tb_uniqueinvoice`.`TimeStamp`
`tb_uniqueinvoice`.`UserName`
`tb_uniqueinvoice`.`BranchOffice`
`tb_uniqueinvoice`.`InvoiceDate`
`tb_uniqueinvoice`.`CustomerID`
`tb_uniqueinvoice`.`AmtPay`
`tb_uniqueinvoice`.`Currency`
`tb_uniqueinvoice`.`Exchange`
`tb_uniqueinvoice`.`Ref_PO`
`tb_uniqueinvoice`.`StaffID`
`tb_uniqueinvoice`.`ComisionerID`
`tb_uniqueinvoice`.`StaffFee`
`tb_uniqueinvoice`.`ComisionerFee`
`tb_uniqueinvoice`.`DatePay`
`tb_uniqueinvoice`.`UserNTm`
`tb_user`.*
`tb_user`.`UserID`
`tb_user`.`TimeStamp`
`tb_user`.`Inputer`
`tb_user`.`Username`
`tb_user`.`Password`
`tb_user`.`Role`
`tb_user`.`Status`
`tb_user`.`User_Photo`
`tb_user`.`LoginStatus`
`tb_user`.`TimeIn`
`tb_user`.`TimeOut`
`tb_usersetting`.*
`tb_usersetting`.`ID`
`tb_usersetting`.`Role`
`tb_usersetting`.`Description`
`tb_usersetting`.`Setting`
`tb_usersetting`.`User`
`tb_usersetting`.`ChartAcct`
`tb_usersetting`.`Journal`
`tb_usersetting`.`SalesStaff`
`tb_usersetting`.`Customer`
`tb_usersetting`.`Loan`
`tb_usersetting`.`Saving`
`tb_usersetting`.`Authorise`
`tb_usersetting`.`CashReciev`
`tb_usersetting`.`RepCust`
`tb_usersetting`.`Loanlate`
`tb_usersetting`.`RepColl`
`tb_usersetting`.`LoanDeposit`
`tb_usersetting`.`RepPmt`
`tb_usersetting`.`RepDis`
`tb_usersetting`.`RepStaff`
`tb_usersetting`.`LoanClosed`
`tb_usersetting`.`RepCollateral`
`tb_usersetting`.`Loansummarise`
`tb_usersetting`.`RepCashInOut`
`tb_usersetting`.`RepProfit`
`tb_usersetting`.`RepBalShet`
`tb_usersetting`.`RepCashVerify`
`readme`.*
`readme`.`id`
`readme`.`Message`
`readme`.`Email`
`readme`.`Bitcoin_Address`
`tb_branchoffice`.*
`tb_branchoffice`.`ID`
`tb_branchoffice`.`branchname`
`tb_branchoffice`.`Khmername`
`tb_branchoffice`.`Englishname`
`tb_branchoffice`.`Address`
`tb_branchoffice`.`officephone`
`tb_branchoffice`.`email`
`tb_branchoffice`.`website`
`tb_branchoffice`.`status`
`tb_cashclose`.*
`tb_cashclose`.`id`
`tb_cashclose`.`cashid`
`tb_cashclose`.`dateclose`
`tb_cashclose`.`amtcash`
`tb_cashclose`.`currency`
`tb_cashclose`.`Username`
`tb_cashclose`.`Branchoffice`
`tb_cashcount`.*
`tb_cashcount`.`id`
`tb_cashcount`.`cashid`
`tb_cashcount`.`branchoffice`
`tb_cashcount`.`dateclose`
`tb_cashcount`.`currency`
`tb_cashcount`.`cashcount`
`tb_cashcount`.`number`
`tb_cashcount`.`username`
`tb_cashrecieve`.*
`tb_cashrecieve`.`ID`
`tb_cashrecieve`.`Timestamp`
`tb_cashrecieve`.`UserName`
`tb_cashrecieve`.`BranchOffice`
`tb_cashrecieve`.`loanID`
`tb_cashrecieve`.`InvoiceType`
`tb_cashrecieve`.`CustomerID`
`tb_cashrecieve`.`BookingType`
`tb_cashrecieve`.`DateBooking`
`tb_cashrecieve`.`Currency`
`tb_cashrecieve`.`AmtDeposit`
`tb_cashrecieve`.`AmtWithdraw`
`tb_cashrecieve`.`AccountID`
`tb_cashrecieve`.`Note`
`tb_cashrecieve`.`StaffID`
`tb_cashrecieve`.`UserNTm`
`tb_cashrecieve`.`Principlepaid`
`tb_cashrecieve`.`Interestpaid`
`tb_cashrecieve`.`OperationPaid`
`tb_cashrecieve`.`SavingPaid`
`tb_cashrecieve`.`PenaltyPaid`
`tb_cashrecieve`.`AmtPaid`
`tb_cashrecieve`.`No`
`tb_cashrecieve`.`datepayment`
`tb_cashtransfer`.*
`tb_cashtransfer`.`ID`
`tb_cashtransfer`.`TimeStamp`
`tb_cashtransfer`.`date`
`tb_cashtransfer`.`Branchoffice`
`tb_cashtransfer`.`Username`
`tb_cashtransfer`.`AccountID`
`tb_cashtransfer`.`CashIn`
`tb_cashtransfer`.`CashOut`
`tb_cashtransfer`.`Currency`
`tb_cashtransfer`.`Branchname`
`tb_cashtransfer`.`Note`
`tb_category`.*
`tb_category`.`CategoryID`
`tb_category`.`Username`
`tb_category`.`CategoryName`
`tb_category`.`CDesption`
`tb_category`.`Category_Pic`
`tb_category`.`CWidth`
`tb_category`.`CLength`
`tb_category`.`CNorth`
`tb_category`.`CSouth`
`tb_category`.`CWest`
`tb_category`.`CEast`
`tb_category`.`CVillage`
`tb_category`.`CCommune`
`tb_category`.`CDistrict`
`tb_category`.`CCity`
`tb_category`.`UserNTm`
`tb_chartaccount`.*
`tb_chartaccount`.`ID`
`tb_chartaccount`.`TimeStamp`
`tb_chartaccount`.`Username`
`tb_chartaccount`.`AccountID`
`tb_chartaccount`.`AccountName`
`tb_chartaccount`.`AccountType`
`tb_chartaccount`.`SubAccountID`
`tb_chartaccount`.`Status`
`tb_collateral`.*
`tb_collateral`.`ID`
`tb_collateral`.`LoanID`
`tb_collateral`.`CustomerID`
`tb_collateral`.`CollateralType`
`tb_collateral`.`DateAttd`
`tb_collateral`.`CollateralName`
`tb_collateral`.`CollateralNo`
`tb_collateral`.`OwnerName`
`tb_collateral`.`DateIssued`
`tb_collateral`.`Price`
`tb_collateral`.`Status`
`tb_collateral`.`CollateralPic`
`tb_collateraldocument`.*
`tb_collateraldocument`.`ID`
`tb_collateraldocument`.`TimeStamp`
`tb_collateraldocument`.`Username`
`tb_collateraldocument`.`Branchoffice`
`tb_collateraldocument`.`LoanID`
`tb_collateraldocument`.`CustomerID`
`tb_collateraldocument`.`DocType`
`tb_collateraldocument`.`DocNum`
`tb_collateraldocument`.`DateIssued`
`tb_collateraldocument`.`OwnerDoc`
`tb_collateralestate`.*
`tb_collateralestate`.`ID`
`tb_collateralestate`.`TimeStamp`
`tb_collateralestate`.`Username`
`tb_collateralestate`.`Branchoffice`
`tb_collateralestate`.`LoanID`
`tb_collateralestate`.`CustomerID`
`tb_collateralestate`.`DocType`
`tb_collateralestate`.`DateIssued`
`tb_collateralestate`.`DocNum`
`tb_collateralestate`.`CollateralType`
`tb_collateralestate`.`Issuedby`
`tb_collateralestate`.`Size`
`tb_collateralestate`.`North`
`tb_collateralestate`.`South`
`tb_collateralestate`.`East`
`tb_collateralestate`.`West`
`tb_collateralestate`.`Note`
`tb_collateralestate`.`EstimatePrice`
`tb_collateralestate`.`Pic`
`tb_collateralvichel`.*
`tb_collateralvichel`.`ID`
`tb_collateralvichel`.`Username`
`tb_collateralvichel`.`Branchoffice`
`tb_collateralvichel`.`LoanID`
`tb_collateralvichel`.`CustomerID`
`tb_collateralvichel`.`CollatType`
`tb_collateralvichel`.`Brand`
`tb_collateralvichel`.`Color`
`tb_collateralvichel`.`PlateNum`
`tb_collateralvichel`.`BodyNum`
`tb_collateralvichel`.`MachineNum`
`tb_collateralvichel`.`YearProduct`
`tb_collateralvichel`.`latabot`
`tb_collateralvichel`.`Issuedby`
`tb_collateralvichel`.`DocType`
`tb_collateralvichel`.`Note`
`tb_collateralvichel`.`EstimatePrice`
`tb_collateralvichel`.`Pic`
`tb_customer`.*
`tb_customer`.`CustomerID`
`tb_customer`.`Timestamp`
`tb_customer`.`UserName`
`tb_customer`.`BranchOffice`
`tb_customer`.`KhmerName`
`tb_customer`.`LatinName`
`tb_customer`.`Sex`
`tb_customer`.`Nationality`
`tb_customer`.`Dob`
`tb_customer`.`IDCard`
`tb_customer`.`NoCard`
`tb_customer`.`DateIssue`
`tb_customer`.`DateExpir`
`tb_customer`.`Issued By`
`tb_customer`.`NoStreet`
`tb_customer`.`NoHouse`
`tb_customer`.`Addgroup`
`tb_customer`.`Village`
`tb_customer`.`Commune`
`tb_customer`.`District`
`tb_customer`.`City`
`tb_customer`.`Job`
`tb_customer`.`WorkPlace`
`tb_customer`.`Role`
`tb_customer`.`CellPhone`
`tb_customer`.`HomePhone`
`tb_customer`.`WorkPhone`
`tb_customer`.`Email`
`tb_customer`.`Facebook`
`tb_customer`.`CustPhoto`
`tb_customer`.`Address_Map`
`tb_customer`.`Relationship`
`tb_customer`.`Co_KhmerName`
`tb_customer`.`Co_LatinName`
`tb_customer`.`Co_Sex`
`tb_customer`.`Co_Nationality`
`tb_customer`.`Co_Dob`
`tb_customer`.`Co_IDCard`
`tb_customer`.`Co_NoCard`
`tb_customer`.`Co_DateIssue`
`tb_customer`.`Co_DateExpir`
`tb_customer`.`Co_Issued By`
`tb_customer`.`Co_NoStreet`
`tb_customer`.`Co_NoHouse`
`tb_customer`.`Co_Group`
`tb_customer`.`Co_Village`
`tb_customer`.`Co_Commune`
`tb_customer`.`Co_District`
`tb_customer`.`Co_City`
`tb_customer`.`Co_Job`
`tb_customer`.`Co_WorkPlace`
`tb_customer`.`Co_Role`
`tb_customer`.`Co_CellPhone`
`tb_customer`.`Co_HomePhone`
`tb_customer`.`Co_WorkPhone`
`tb_customer`.`Co_Email`
`tb_customer`.`Co_Facebook`
`tb_customer`.`Co_CustPhoto`
`tb_customer`.`Status`
`tb_customer`.`UserNTm`
`tb_customerattach`.*
`tb_customerattach`.`ID`
`tb_customerattach`.`CustomerID`
`tb_customerattach`.`BranchOffice`
`tb_customerattach`.`DateAttached`
`tb_customerattach`.`AttachName`
`tb_customerattach`.`OwnerName`
`tb_customerattach`.`AttachNo`
`tb_customerattach`.`AttachPic`
`tb_guarantee`.*
`tb_guarantee`.`GuaranteeID`
`tb_guarantee`.`Timestamp`
`tb_guarantee`.`UserName`
`tb_guarantee`.`BranchOffice`
`tb_guarantee`.`Khmername`
`tb_guarantee`.`LatinName`
`tb_guarantee`.`Sex`
`tb_guarantee`.`Nationality`
`tb_guarantee`.`Dob`
`tb_guarantee`.`IDCard`
`tb_guarantee`.`NoCard`
`tb_guarantee`.`DateIssue`
`tb_guarantee`.`DateExpir`
`tb_guarantee`.`Issued By`
`tb_guarantee`.`NoStreet`
`tb_guarantee`.`NoHouse`
`tb_guarantee`.`Addgroup`
`tb_guarantee`.`Village`
`tb_guarantee`.`Commune`
`tb_guarantee`.`District`
`tb_guarantee`.`City`
`tb_guarantee`.`Job`
`tb_guarantee`.`WorkPlace`
`tb_guarantee`.`Role`
`tb_guarantee`.`CellPhone`
`tb_guarantee`.`HomePhone`
`tb_guarantee`.`WorkPhone`
`tb_guarantee`.`Email`
`tb_guarantee`.`Facebook`
`tb_guarantee`.`GuarPhoto`
`tb_guarantee`.`Address_Map`
`tb_guarantee`.`Relationship`
`tb_guarantee`.`Co_KhmerName`
`tb_guarantee`.`Co_LatinName`
`tb_guarantee`.`Co_Sex`
`tb_guarantee`.`Co_Nationality`
`tb_guarantee`.`Co_Dob`
`tb_guarantee`.`Co_IDCard`
`tb_guarantee`.`Co_NoCard`
`tb_guarantee`.`Co_DateIssue`
`tb_guarantee`.`Co_DateExpir`
`tb_guarantee`.`Co_Issued By`
`tb_guarantee`.`Co_NoStreet`
`tb_guarantee`.`Co_NoHouse`
`tb_guarantee`.`Co_Group`
`tb_guarantee`.`Co_Village`
`tb_guarantee`.`Co_Commune`
`tb_guarantee`.`Co_District`
`tb_guarantee`.`Co_City`
`tb_guarantee`.`Co_Job`
`tb_guarantee`.`Co_WorkPlace`
`tb_guarantee`.`Co_Role`
`tb_guarantee`.`Co_CellPhone`
`tb_guarantee`.`Co_HomePhone`
`tb_guarantee`.`Co_WorkPhone`
`tb_guarantee`.`Co_Email`
`tb_guarantee`.`Co_Facebook`
`tb_guarantee`.`Co_GuarPhoto`
`tb_guarantee`.`Status`
`tb_guarantee`.`UserNTm`
`tb_invoicedetail`.*
`tb_invoicedetail`.`ID`
`tb_invoicedetail`.`UserName`
`tb_invoicedetail`.`BranchOffice`
`tb_invoicedetail`.`InvoiceDate`
`tb_invoicedetail`.`InvoiceID`
`tb_invoicedetail`.`CustomerID`
`tb_invoicedetail`.`ProductID`
`tb_invoicedetail`.`Quanty`
`tb_invoicedetail`.`Price`
`tb_invoicedetail`.`Discount`
`tb_invoicedetail`.`Tax`
`tb_invoicedetail`.`Cost`
`tb_invoicedetail`.`Invoicetype`
`tb_journalentry`.*
`tb_journalentry`.`ID`
`tb_journalentry`.`UserName`
`tb_journalentry`.`BranchOffice`
`tb_journalentry`.`GLID`
`tb_journalentry`.`DateGL`
`tb_journalentry`.`Transection_Type`
`tb_journalentry`.`Currency`
`tb_journalentry`.`AccountID`
`tb_journalentry`.`Debit`
`tb_journalentry`.`Credit`
`tb_journalentry`.`Note`
`tb_journalentry`.`CashID`
`tb_journalentry`.`UserNTm`
`tb_journalid`.*
`tb_journalid`.`GLID`
`tb_journalid`.`TimeStamp`
`tb_journalid`.`Username`
`tb_journalid`.`BranchOffice`
`tb_journalid`.`UserNTm`
`tb_loanrequest`.*
`tb_loanrequest`.`loanID`
`tb_loanrequest`.`TimeStamp`
`tb_loanrequest`.`UserName`
`tb_loanrequest`.`BranchOffice`
`tb_loanrequest`.`CustomerID`
`tb_loanrequest`.`LoanType`
`tb_loanrequest`.`LoanCycle`
`tb_loanrequest`.`Currency`
`tb_loanrequest`.`Loansize`
`tb_loanrequest`.`InterestRate`
`tb_loanrequest`.`Term`
`tb_loanrequest`.`TimePayment`
`tb_loanrequest`.`PaymentType`
`tb_loanrequest`.`DateDisbusement`
`tb_loanrequest`.`DateCollect`
`tb_loanrequest`.`DateClose`
`tb_loanrequest`.`StaffID`
`tb_loanrequest`.`DepositRequire`
`tb_loanrequest`.`AdminFee`
`tb_loanrequest`.`OtherFee`
`tb_loanrequest`.`OperationFee`
`tb_loanrequest`.`Saving`
`tb_loanrequest`.`GuaranteeID`
`tb_loanrequest`.`RalationShip`
`tb_loanrequest`.`LoanPurpose`
`tb_loanrequest`.`LoanStatus`
`tb_loanrequest`.`DateWriteOff`
`tb_loanrequest`.`ComisionCo`
`tb_loanrequest`.`ComisionID`
`tb_loanrequest`.`ComisionAgent`
`tb_loanrequest`.`Amtfirstday`
`tb_loanrequest`.`UserNTm`
`tb_product`.*
`tb_product`.`ProductID`
`tb_product`.`UserName`
`tb_product`.`ProductName`
`tb_product`.`ProductType`
`tb_product`.`CategoryID`
`tb_product`.`PDesption`
`tb_product`.`Unit`
`tb_product`.`Cost`
`tb_product`.`Price`
`tb_product`.`tax`
`tb_product`.`PWidth`
`tb_product`.`PLength`
`tb_product`.`PNorth`
`tb_product`.`PSouth`
`tb_product`.`PWest`
`tb_product`.`PEast`
`tb_product`.`PVillage`
`tb_product`.`PCommune`
`tb_product`.`PDistrict`
`tb_product`.`PCity`
`tb_product`.`Status`
`tb_product`.`Product_Pic`
`tb_product`.`UserNTm`
`tb_repaymentterm`.*
`tb_repaymentterm`.`ID`
`tb_repaymentterm`.`InvoiceID`
`tb_repaymentterm`.`CustomerID`
`tb_repaymentterm`.`DatePay`
`tb_repaymentterm`.`AmtPay`
`tb_repaymentterm`.`Percentage`
`tb_saving`.*
`tb_saving`.`SavingID`
`tb_saving`.`Timestamp`
`tb_saving`.`UserName`
`tb_saving`.`BranchOffice`
`tb_saving`.`CustomerID`
`tb_saving`.`SavingType`
`tb_saving`.`Cycle`
`tb_saving`.`Currency`
`tb_saving`.`SavingAmount`
`tb_saving`.`Rate`
`tb_saving`.`Term`
`tb_saving`.`TimeSaving`
`tb_saving`.`Note`
`tb_saving`.`DateSaving`
`tb_saving`.`DateClose`
`tb_saving`.`AdminFee`
`tb_saving`.`StaffID`
`tb_saving`.`ComisionCo`
`tb_saving`.`ComisionID`
`tb_saving`.`ComisionAgent`
`tb_saving`.`UserNTm`
`tb_savingschedule`.*
`tb_savingschedule`.`ID`
`tb_savingschedule`.`savingID`
`tb_savingschedule`.`customerid`
`tb_savingschedule`.`No`
`tb_savingschedule`.`Bbprint`
`tb_savingschedule`.`principle`
`tb_savingschedule`.`interest`
`tb_savingschedule`.`amtpay`
`tb_savingschedule`.`endingbalance`
`tb_savingschedule`.`datepayment`
`tb_schedule`.*
`tb_schedule`.`ID`
`tb_schedule`.`LoanID`
`tb_schedule`.`CustomerID`
`tb_schedule`.`No`
`tb_schedule`.`DatePayment`
`tb_schedule`.`NumbDay`
`tb_schedule`.`BeginnigBalance`
`tb_schedule`.`Principle`
`tb_schedule`.`Interest`
`tb_schedule`.`Operation`
`tb_schedule`.`Saving`
`tb_schedule`.`AmtPayment`
`tb_schedule`.`LoanOutstanding`
`tb_schedule`.`Status`
`tb_staff`.*
`tb_staff`.`StaffID`
`tb_staff`.`TimeStamp`
`tb_staff`.`UserName`
`tb_staff`.`StaffName`
`tb_staff`.`Phone`
`tb_staff`.`BranchOffice`
`tb_staff`.`Type`
`tb_staff`.`Status`
`tb_staff`.`Photo`
`tb_staff`.`UserNTm`
`tb_uniqueinvoice`.*
`tb_uniqueinvoice`.`InvoiceID`
`tb_uniqueinvoice`.`TimeStamp`
`tb_uniqueinvoice`.`UserName`
`tb_uniqueinvoice`.`BranchOffice`
`tb_uniqueinvoice`.`InvoiceDate`
`tb_uniqueinvoice`.`CustomerID`
`tb_uniqueinvoice`.`AmtPay`
`tb_uniqueinvoice`.`Currency`
`tb_uniqueinvoice`.`Exchange`
`tb_uniqueinvoice`.`Ref_PO`
`tb_uniqueinvoice`.`StaffID`
`tb_uniqueinvoice`.`ComisionerID`
`tb_uniqueinvoice`.`StaffFee`
`tb_uniqueinvoice`.`ComisionerFee`
`tb_uniqueinvoice`.`DatePay`
`tb_uniqueinvoice`.`UserNTm`
`tb_user`.*
`tb_user`.`UserID`
`tb_user`.`TimeStamp`
`tb_user`.`Inputer`
`tb_user`.`Username`
`tb_user`.`Password`
`tb_user`.`Role`
`tb_user`.`Status`
`tb_user`.`User_Photo`
`tb_user`.`LoginStatus`
`tb_user`.`TimeIn`
`tb_user`.`TimeOut`
`tb_usersetting`.*
`tb_usersetting`.`ID`
`tb_usersetting`.`Role`
`tb_usersetting`.`Description`
`tb_usersetting`.`Setting`
`tb_usersetting`.`User`
`tb_usersetting`.`ChartAcct`
`tb_usersetting`.`Journal`
`tb_usersetting`.`SalesStaff`
`tb_usersetting`.`Customer`
`tb_usersetting`.`Loan`
`tb_usersetting`.`Saving`
`tb_usersetting`.`Authorise`
`tb_usersetting`.`CashReciev`
`tb_usersetting`.`RepCust`
`tb_usersetting`.`Loanlate`
`tb_usersetting`.`RepColl`
`tb_usersetting`.`LoanDeposit`
`tb_usersetting`.`RepPmt`
`tb_usersetting`.`RepDis`
`tb_usersetting`.`RepStaff`
`tb_usersetting`.`LoanClosed`
`tb_usersetting`.`RepCollateral`
`tb_usersetting`.`Loansummarise`
`tb_usersetting`.`RepCashInOut`
`tb_usersetting`.`RepProfit`
`tb_usersetting`.`RepBalShet`
`tb_usersetting`.`RepCashVerify`
`readme`.*
`readme`.`id`
`readme`.`Message`
`readme`.`Email`
`readme`.`Bitcoin_Address`
`tb_branchoffice`.*
`tb_branchoffice`.`ID`
`tb_branchoffice`.`branchname`
`tb_branchoffice`.`Khmername`
`tb_branchoffice`.`Englishname`
`tb_branchoffice`.`Address`
`tb_branchoffice`.`officephone`
`tb_branchoffice`.`email`
`tb_branchoffice`.`website`
`tb_branchoffice`.`status`
`tb_cashclose`.*
`tb_cashclose`.`id`
`tb_cashclose`.`cashid`
`tb_cashclose`.`dateclose`
`tb_cashclose`.`amtcash`
`tb_cashclose`.`currency`
`tb_cashclose`.`Username`
`tb_cashclose`.`Branchoffice`
`tb_cashcount`.*
`tb_cashcount`.`id`
`tb_cashcount`.`cashid`
`tb_cashcount`.`branchoffice`
`tb_cashcount`.`dateclose`
`tb_cashcount`.`currency`
`tb_cashcount`.`cashcount`
`tb_cashcount`.`number`
`tb_cashcount`.`username`
`tb_cashrecieve`.*
`tb_cashrecieve`.`ID`
`tb_cashrecieve`.`Timestamp`
`tb_cashrecieve`.`UserName`
`tb_cashrecieve`.`BranchOffice`
`tb_cashrecieve`.`loanID`
`tb_cashrecieve`.`InvoiceType`
`tb_cashrecieve`.`CustomerID`
`tb_cashrecieve`.`BookingType`
`tb_cashrecieve`.`DateBooking`
`tb_cashrecieve`.`Currency`
`tb_cashrecieve`.`AmtDeposit`
`tb_cashrecieve`.`AmtWithdraw`
`tb_cashrecieve`.`AccountID`
`tb_cashrecieve`.`Note`
`tb_cashrecieve`.`StaffID`
`tb_cashrecieve`.`UserNTm`
`tb_cashrecieve`.`Principlepaid`
`tb_cashrecieve`.`Interestpaid`
`tb_cashrecieve`.`OperationPaid`
`tb_cashrecieve`.`SavingPaid`
`tb_cashrecieve`.`PenaltyPaid`
`tb_cashrecieve`.`AmtPaid`
`tb_cashrecieve`.`No`
`tb_cashrecieve`.`datepayment`
`tb_cashtransfer`.*
`tb_cashtransfer`.`ID`
`tb_cashtransfer`.`TimeStamp`
`tb_cashtransfer`.`date`
`tb_cashtransfer`.`Branchoffice`
`tb_cashtransfer`.`Username`
`tb_cashtransfer`.`AccountID`
`tb_cashtransfer`.`CashIn`
`tb_cashtransfer`.`CashOut`
`tb_cashtransfer`.`Currency`
`tb_cashtransfer`.`Branchname`
`tb_cashtransfer`.`Note`
`tb_category`.*
`tb_category`.`CategoryID`
`tb_category`.`Username`
`tb_category`.`CategoryName`
`tb_category`.`CDesption`
`tb_category`.`Category_Pic`
`tb_category`.`CWidth`
`tb_category`.`CLength`
`tb_category`.`CNorth`
`tb_category`.`CSouth`
`tb_category`.`CWest`
`tb_category`.`CEast`
`tb_category`.`CVillage`
`tb_category`.`CCommune`
`tb_category`.`CDistrict`
`tb_category`.`CCity`
`tb_category`.`UserNTm`
`tb_chartaccount`.*
`tb_chartaccount`.`ID`
`tb_chartaccount`.`TimeStamp`
`tb_chartaccount`.`Username`
`tb_chartaccount`.`AccountID`
`tb_chartaccount`.`AccountName`
`tb_chartaccount`.`AccountType`
`tb_chartaccount`.`SubAccountID`
`tb_chartaccount`.`Status`
`tb_collateral`.*
`tb_collateral`.`ID`
`tb_collateral`.`LoanID`
`tb_collateral`.`CustomerID`
`tb_collateral`.`CollateralType`
`tb_collateral`.`DateAttd`
`tb_collateral`.`CollateralName`
`tb_collateral`.`CollateralNo`
`tb_collateral`.`OwnerName`
`tb_collateral`.`DateIssued`
`tb_collateral`.`Price`
`tb_collateral`.`Status`
`tb_collateral`.`CollateralPic`
`tb_collateraldocument`.*
`tb_collateraldocument`.`ID`
`tb_collateraldocument`.`TimeStamp`
`tb_collateraldocument`.`Username`
`tb_collateraldocument`.`Branchoffice`
`tb_collateraldocument`.`LoanID`
`tb_collateraldocument`.`CustomerID`
`tb_collateraldocument`.`DocType`
`tb_collateraldocument`.`DocNum`
`tb_collateraldocument`.`DateIssued`
`tb_collateraldocument`.`OwnerDoc`
`tb_collateralestate`.*
`tb_collateralestate`.`ID`
`tb_collateralestate`.`TimeStamp`
`tb_collateralestate`.`Username`
`tb_collateralestate`.`Branchoffice`
`tb_collateralestate`.`LoanID`
`tb_collateralestate`.`CustomerID`
`tb_collateralestate`.`DocType`
`tb_collateralestate`.`DateIssued`
`tb_collateralestate`.`DocNum`
`tb_collateralestate`.`CollateralType`
`tb_collateralestate`.`Issuedby`
`tb_collateralestate`.`Size`
`tb_collateralestate`.`North`
`tb_collateralestate`.`South`
`tb_collateralestate`.`East`
`tb_collateralestate`.`West`
`tb_collateralestate`.`Note`
`tb_collateralestate`.`EstimatePrice`
`tb_collateralestate`.`Pic`
`tb_collateralvichel`.*
`tb_collateralvichel`.`ID`
`tb_collateralvichel`.`Username`
`tb_collateralvichel`.`Branchoffice`
`tb_collateralvichel`.`LoanID`
`tb_collateralvichel`.`CustomerID`
`tb_collateralvichel`.`CollatType`
`tb_collateralvichel`.`Brand`
`tb_collateralvichel`.`Color`
`tb_collateralvichel`.`PlateNum`
`tb_collateralvichel`.`BodyNum`
`tb_collateralvichel`.`MachineNum`
`tb_collateralvichel`.`YearProduct`
`tb_collateralvichel`.`latabot`
`tb_collateralvichel`.`Issuedby`
`tb_collateralvichel`.`DocType`
`tb_collateralvichel`.`Note`
`tb_collateralvichel`.`EstimatePrice`
`tb_collateralvichel`.`Pic`
`tb_customer`.*
`tb_customer`.`CustomerID`
`tb_customer`.`Timestamp`
`tb_customer`.`UserName`
`tb_customer`.`BranchOffice`
`tb_customer`.`KhmerName`
`tb_customer`.`LatinName`
`tb_customer`.`Sex`
`tb_customer`.`Nationality`
`tb_customer`.`Dob`
`tb_customer`.`IDCard`
`tb_customer`.`NoCard`
`tb_customer`.`DateIssue`
`tb_customer`.`DateExpir`
`tb_customer`.`Issued By`
`tb_customer`.`NoStreet`
`tb_customer`.`NoHouse`
`tb_customer`.`Addgroup`
`tb_customer`.`Village`
`tb_customer`.`Commune`
`tb_customer`.`District`
`tb_customer`.`City`
`tb_customer`.`Job`
`tb_customer`.`WorkPlace`
`tb_customer`.`Role`
`tb_customer`.`CellPhone`
`tb_customer`.`HomePhone`
`tb_customer`.`WorkPhone`
`tb_customer`.`Email`
`tb_customer`.`Facebook`
`tb_customer`.`CustPhoto`
`tb_customer`.`Address_Map`
`tb_customer`.`Relationship`
`tb_customer`.`Co_KhmerName`
`tb_customer`.`Co_LatinName`
`tb_customer`.`Co_Sex`
`tb_customer`.`Co_Nationality`
`tb_customer`.`Co_Dob`
`tb_customer`.`Co_IDCard`
`tb_customer`.`Co_NoCard`
`tb_customer`.`Co_DateIssue`
`tb_customer`.`Co_DateExpir`
`tb_customer`.`Co_Issued By`
`tb_customer`.`Co_NoStreet`
`tb_customer`.`Co_NoHouse`
`tb_customer`.`Co_Group`
`tb_customer`.`Co_Village`
`tb_customer`.`Co_Commune`
`tb_customer`.`Co_District`
`tb_customer`.`Co_City`
`tb_customer`.`Co_Job`
`tb_customer`.`Co_WorkPlace`
`tb_customer`.`Co_Role`
`tb_customer`.`Co_CellPhone`
`tb_customer`.`Co_HomePhone`
`tb_customer`.`Co_WorkPhone`
`tb_customer`.`Co_Email`
`tb_customer`.`Co_Facebook`
`tb_customer`.`Co_CustPhoto`
`tb_customer`.`Status`
`tb_customer`.`UserNTm`
`tb_customerattach`.*
`tb_customerattach`.`ID`
`tb_customerattach`.`CustomerID`
`tb_customerattach`.`BranchOffice`
`tb_customerattach`.`DateAttached`
`tb_customerattach`.`AttachName`
`tb_customerattach`.`OwnerName`
`tb_customerattach`.`AttachNo`
`tb_customerattach`.`AttachPic`
`tb_guarantee`.*
`tb_guarantee`.`GuaranteeID`
`tb_guarantee`.`Timestamp`
`tb_guarantee`.`UserName`
`tb_guarantee`.`BranchOffice`
`tb_guarantee`.`Khmername`
`tb_guarantee`.`LatinName`
`tb_guarantee`.`Sex`
`tb_guarantee`.`Nationality`
`tb_guarantee`.`Dob`
`tb_guarantee`.`IDCard`
`tb_guarantee`.`NoCard`
`tb_guarantee`.`DateIssue`
`tb_guarantee`.`DateExpir`
`tb_guarantee`.`Issued By`
`tb_guarantee`.`NoStreet`
`tb_guarantee`.`NoHouse`
`tb_guarantee`.`Addgroup`
`tb_guarantee`.`Village`
`tb_guarantee`.`Commune`
`tb_guarantee`.`District`
`tb_guarantee`.`City`
`tb_guarantee`.`Job`
`tb_guarantee`.`WorkPlace`
`tb_guarantee`.`Role`
`tb_guarantee`.`CellPhone`
`tb_guarantee`.`HomePhone`
`tb_guarantee`.`WorkPhone`
`tb_guarantee`.`Email`
`tb_guarantee`.`Facebook`
`tb_guarantee`.`GuarPhoto`
`tb_guarantee`.`Address_Map`
`tb_guarantee`.`Relationship`
`tb_guarantee`.`Co_KhmerName`
`tb_guarantee`.`Co_LatinName`
`tb_guarantee`.`Co_Sex`
`tb_guarantee`.`Co_Nationality`
`tb_guarantee`.`Co_Dob`
`tb_guarantee`.`Co_IDCard`
`tb_guarantee`.`Co_NoCard`
`tb_guarantee`.`Co_DateIssue`
`tb_guarantee`.`Co_DateExpir`
`tb_guarantee`.`Co_Issued By`
`tb_guarantee`.`Co_NoStreet`
`tb_guarantee`.`Co_NoHouse`
`tb_guarantee`.`Co_Group`
`tb_guarantee`.`Co_Village`
`tb_guarantee`.`Co_Commune`
`tb_guarantee`.`Co_District`
`tb_guarantee`.`Co_City`
`tb_guarantee`.`Co_Job`
`tb_guarantee`.`Co_WorkPlace`
`tb_guarantee`.`Co_Role`
`tb_guarantee`.`Co_CellPhone`
`tb_guarantee`.`Co_HomePhone`
`tb_guarantee`.`Co_WorkPhone`
`tb_guarantee`.`Co_Email`
`tb_guarantee`.`Co_Facebook`
`tb_guarantee`.`Co_GuarPhoto`
`tb_guarantee`.`Status`
`tb_guarantee`.`UserNTm`
`tb_invoicedetail`.*
`tb_invoicedetail`.`ID`
`tb_invoicedetail`.`UserName`
`tb_invoicedetail`.`BranchOffice`
`tb_invoicedetail`.`InvoiceDate`
`tb_invoicedetail`.`InvoiceID`
`tb_invoicedetail`.`CustomerID`
`tb_invoicedetail`.`ProductID`
`tb_invoicedetail`.`Quanty`
`tb_invoicedetail`.`Price`
`tb_invoicedetail`.`Discount`
`tb_invoicedetail`.`Tax`
`tb_invoicedetail`.`Cost`
`tb_invoicedetail`.`Invoicetype`
`tb_journalentry`.*
`tb_journalentry`.`ID`
`tb_journalentry`.`UserName`
`tb_journalentry`.`BranchOffice`
`tb_journalentry`.`GLID`
`tb_journalentry`.`DateGL`
`tb_journalentry`.`Transection_Type`
`tb_journalentry`.`Currency`
`tb_journalentry`.`AccountID`
`tb_journalentry`.`Debit`
`tb_journalentry`.`Credit`
`tb_journalentry`.`Note`
`tb_journalentry`.`CashID`
`tb_journalentry`.`UserNTm`
`tb_journalid`.*
`tb_journalid`.`GLID`
`tb_journalid`.`TimeStamp`
`tb_journalid`.`Username`
`tb_journalid`.`BranchOffice`
`tb_journalid`.`UserNTm`
`tb_loanrequest`.*
`tb_loanrequest`.`loanID`
`tb_loanrequest`.`TimeStamp`
`tb_loanrequest`.`UserName`
`tb_loanrequest`.`BranchOffice`
`tb_loanrequest`.`CustomerID`
`tb_loanrequest`.`LoanType`
`tb_loanrequest`.`LoanCycle`
`tb_loanrequest`.`Currency`
`tb_loanrequest`.`Loansize`
`tb_loanrequest`.`InterestRate`
`tb_loanrequest`.`Term`
`tb_loanrequest`.`TimePayment`
`tb_loanrequest`.`PaymentType`
`tb_loanrequest`.`DateDisbusement`
`tb_loanrequest`.`DateCollect`
`tb_loanrequest`.`DateClose`
`tb_loanrequest`.`StaffID`
`tb_loanrequest`.`DepositRequire`
`tb_loanrequest`.`AdminFee`
`tb_loanrequest`.`OtherFee`
`tb_loanrequest`.`OperationFee`
`tb_loanrequest`.`Saving`
`tb_loanrequest`.`GuaranteeID`
`tb_loanrequest`.`RalationShip`
`tb_loanrequest`.`LoanPurpose`
`tb_loanrequest`.`LoanStatus`
`tb_loanrequest`.`DateWriteOff`
`tb_loanrequest`.`ComisionCo`
`tb_loanrequest`.`ComisionID`
`tb_loanrequest`.`ComisionAgent`
`tb_loanrequest`.`Amtfirstday`
`tb_loanrequest`.`UserNTm`
`tb_product`.*
`tb_product`.`ProductID`
`tb_product`.`UserName`
`tb_product`.`ProductName`
`tb_product`.`ProductType`
`tb_product`.`CategoryID`
`tb_product`.`PDesption`
`tb_product`.`Unit`
`tb_product`.`Cost`
`tb_product`.`Price`
`tb_product`.`tax`
`tb_product`.`PWidth`
`tb_product`.`PLength`
`tb_product`.`PNorth`
`tb_product`.`PSouth`
`tb_product`.`PWest`
`tb_product`.`PEast`
`tb_product`.`PVillage`
`tb_product`.`PCommune`
`tb_product`.`PDistrict`
`tb_product`.`PCity`
`tb_product`.`Status`
`tb_product`.`Product_Pic`
`tb_product`.`UserNTm`
`tb_repaymentterm`.*
`tb_repaymentterm`.`ID`
`tb_repaymentterm`.`InvoiceID`
`tb_repaymentterm`.`CustomerID`
`tb_repaymentterm`.`DatePay`
`tb_repaymentterm`.`AmtPay`
`tb_repaymentterm`.`Percentage`
`tb_saving`.*
`tb_saving`.`SavingID`
`tb_saving`.`Timestamp`
`tb_saving`.`UserName`
`tb_saving`.`BranchOffice`
`tb_saving`.`CustomerID`
`tb_saving`.`SavingType`
`tb_saving`.`Cycle`
`tb_saving`.`Currency`
`tb_saving`.`SavingAmount`
`tb_saving`.`Rate`
`tb_saving`.`Term`
`tb_saving`.`TimeSaving`
`tb_saving`.`Note`
`tb_saving`.`DateSaving`
`tb_saving`.`DateClose`
`tb_saving`.`AdminFee`
`tb_saving`.`StaffID`
`tb_saving`.`ComisionCo`
`tb_saving`.`ComisionID`
`tb_saving`.`ComisionAgent`
`tb_saving`.`UserNTm`
`tb_savingschedule`.*
`tb_savingschedule`.`ID`
`tb_savingschedule`.`savingID`
`tb_savingschedule`.`customerid`
`tb_savingschedule`.`No`
`tb_savingschedule`.`Bbprint`
`tb_savingschedule`.`principle`
`tb_savingschedule`.`interest`
`tb_savingschedule`.`amtpay`
`tb_savingschedule`.`endingbalance`
`tb_savingschedule`.`datepayment`
`tb_schedule`.*
`tb_schedule`.`ID`
`tb_schedule`.`LoanID`
`tb_schedule`.`CustomerID`
`tb_schedule`.`No`
`tb_schedule`.`DatePayment`
`tb_schedule`.`NumbDay`
`tb_schedule`.`BeginnigBalance`
`tb_schedule`.`Principle`
`tb_schedule`.`Interest`
`tb_schedule`.`Operation`
`tb_schedule`.`Saving`
`tb_schedule`.`AmtPayment`
`tb_schedule`.`LoanOutstanding`
`tb_schedule`.`Status`
`tb_staff`.*
`tb_staff`.`StaffID`
`tb_staff`.`TimeStamp`
`tb_staff`.`UserName`
`tb_staff`.`StaffName`
`tb_staff`.`Phone`
`tb_staff`.`BranchOffice`
`tb_staff`.`Type`
`tb_staff`.`Status`
`tb_staff`.`Photo`
`tb_staff`.`UserNTm`
`tb_uniqueinvoice`.*
`tb_uniqueinvoice`.`InvoiceID`
`tb_uniqueinvoice`.`TimeStamp`
`tb_uniqueinvoice`.`UserName`
`tb_uniqueinvoice`.`BranchOffice`
`tb_uniqueinvoice`.`InvoiceDate`
`tb_uniqueinvoice`.`CustomerID`
`tb_uniqueinvoice`.`AmtPay`
`tb_uniqueinvoice`.`Currency`
`tb_uniqueinvoice`.`Exchange`
`tb_uniqueinvoice`.`Ref_PO`
`tb_uniqueinvoice`.`StaffID`
`tb_uniqueinvoice`.`ComisionerID`
`tb_uniqueinvoice`.`StaffFee`
`tb_uniqueinvoice`.`ComisionerFee`
`tb_uniqueinvoice`.`DatePay`
`tb_uniqueinvoice`.`UserNTm`
`tb_user`.*
`tb_user`.`UserID`
`tb_user`.`TimeStamp`
`tb_user`.`Inputer`
`tb_user`.`Username`
`tb_user`.`Password`
`tb_user`.`Role`
`tb_user`.`Status`
`tb_user`.`User_Photo`
`tb_user`.`LoginStatus`
`tb_user`.`TimeIn`
`tb_user`.`TimeOut`
`tb_usersetting`.*
`tb_usersetting`.`ID`
`tb_usersetting`.`Role`
`tb_usersetting`.`Description`
`tb_usersetting`.`Setting`
`tb_usersetting`.`User`
`tb_usersetting`.`ChartAcct`
`tb_usersetting`.`Journal`
`tb_usersetting`.`SalesStaff`
`tb_usersetting`.`Customer`
`tb_usersetting`.`Loan`
`tb_usersetting`.`Saving`
`tb_usersetting`.`Authorise`
`tb_usersetting`.`CashReciev`
`tb_usersetting`.`RepCust`
`tb_usersetting`.`Loanlate`
`tb_usersetting`.`RepColl`
`tb_usersetting`.`LoanDeposit`
`tb_usersetting`.`RepPmt`
`tb_usersetting`.`RepDis`
`tb_usersetting`.`RepStaff`
`tb_usersetting`.`LoanClosed`
`tb_usersetting`.`RepCollateral`
`tb_usersetting`.`Loansummarise`
`tb_usersetting`.`RepCashInOut`
`tb_usersetting`.`RepProfit`
`tb_usersetting`.`RepBalShet`
`tb_usersetting`.`RepCashVerify`
别名:
显示:
排序:
递增
递减
递增
递减
递增
递减
排序规则:
1
2
3
1
2
3
1
2
3
条件:
插入:
且:
删除:
或:
修改:
或:
且:
插入
删除
或:
且:
插入
删除
插入
删除
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
在数据库
loansystemdb
执行 SQL 语句: