competence-rs.com / localhost / herp / crm_leads

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.

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

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

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

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:

Column

Type

Collation

Operator

Value

leadid

int(11)

mst_branchid

varchar(100)

latin1_swedish_ci

leads_date

date

leadcode

varchar(50)

latin1_swedish_ci

lead_subject

varchar(255)

latin1_swedish_ci

company_name

varchar(255)

latin1_swedish_ci

leadfile

varchar(255)

latin1_swedish_ci

lead_Category

varchar(255)

latin1_swedish_ci

lead_source

varchar(255)

latin1_swedish_ci

lead_Stage

varchar(255)

latin1_swedish_ci

lead_status

varchar(255)

latin1_swedish_ci

lead_Priority

varchar(255)

latin1_swedish_ci

sale_executive

varchar(255)

latin1_swedish_ci

description

text

latin1_swedish_ci

created_date

date

created_by

int(11)

modified_date

date

deleted_status

enum('Y', 'N')

latin1_swedish_ci

Convert_IntoAccountStatus

enum('Y', 'N')

latin1_swedish_ci

Convert_AccountId

int(11)

Quotes_Status

varchar(255)

latin1_swedish_ci

CompanyId

int(11)

EST_Status

int(10)

store

int(10)

contact_name

varchar(255)

latin1_swedish_ci

another_contact

varchar(255)

latin1_swedish_ci

department

int(10)

designation

int(10)

department1

int(10)

designation1

int(10)

address1

varchar(255)

latin1_swedish_ci

address2

varchar(255)

latin1_swedish_ci

address3

varchar(255)

latin1_swedish_ci

varchar(30)

latin1_swedish_ci

phone

varchar(20)

latin1_swedish_ci

fax

varchar(20)

latin1_swedish_ci

mobile

varchar(20)

latin1_swedish_ci

zipcode

varchar(10)

latin1_swedish_ci

country

int(10)

city

int(10)

state

int(10)

groupname

varchar(255)

latin1_swedish_ci

groupid

varchar(255)

latin1_swedish_ci

lead_function

varchar(255)

latin1_swedish_ci

clientstatus

enum('0', '1')

latin1_swedish_ci

lead_type

varchar(3)

latin1_swedish_ci

website

varchar(30)

latin1_swedish_ci

cemail

varchar(30)

latin1_swedish_ci

cmobile2

varchar(20)

latin1_swedish_ci

cemail2

varchar(30)

latin1_swedish_ci

dealerid

int(11)

userid

varchar(30)

latin1_swedish_ci

ref_name

varchar(200)

latin1_swedish_ci

ref_addres

varchar(500)

latin1_swedish_ci

ref_phone

varchar(50)

latin1_swedish_ci

ref_email

varchar(100)

latin1_swedish_ci

leadid
mst_branchid
leads_date
leadcode
lead_subject
company_name
leadfile
lead_Category
lead_source
lead_Stage
lead_status
lead_Priority
sale_executive
description
created_date
created_by
modified_date
deleted_status
Convert_IntoAccountStatus
Convert_AccountId
Quotes_Status
CompanyId
EST_Status
store
contact_name
another_contact
department
designation
department1
designation1
address1
address2
address3
email
phone
fax
mobile
zipcode
country
city
state
groupname
groupid
lead_function
clientstatus
lead_type
website
cemail
cmobile2
cemail2
dealerid
userid
ref_name
ref_addres
ref_phone
ref_email

SQL upload ( 0 ) x-