testprakalpa.vtrickstech.com / localhost / precitec_test / proj_detl_temp

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.	Not a non-negative number!

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.

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.

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
proj_detl_id	int(11)
oa_no	varchar(50)	latin1_swedish_ci
proj_no	varchar(50)	latin1_swedish_ci
sa_name	varchar(200)	latin1_swedish_ci
assy_drg_no	varchar(50)	latin1_swedish_ci
sa_drg_no	varchar(50)	latin1_swedish_ci
sa_drg_revision	int(11)
sa_per_assy	int(11)
part_name	varchar(200)	latin1_swedish_ci
part_drg_no	varchar(200)	latin1_swedish_ci
batch_no	int(11)
parts_per_assy	decimal(10,3)
reqd_total_qty	decimal(10,3)
bom_qty	decimal(10,3)
stages	int(11)
trgt_date	date
class_of_parts	varchar(50)	latin1_swedish_ci
raw_mat_spec	varchar(300)	latin1_swedish_ci
raw_mat_dimension	varchar(500)	latin1_swedish_ci
bom_upload_date	date
design_eng	varchar(255)	latin1_swedish_ci
part_drg_remarks	varchar(255)	latin1_swedish_ci
part_drg_release_by	varchar(255)	latin1_swedish_ci
drg_release_dt	date
type	varchar(12)	latin1_swedish_ci
revision	int(11)
revision_date	date
make	varchar(30)	latin1_swedish_ci
model	varchar(30)	latin1_swedish_ci
uom	varchar(10)	latin1_swedish_ci
website	varchar(500)	latin1_swedish_ci
hsn_code	int(11)
sac_code	int(11)
alternate_allow	varchar(3)	latin1_swedish_ci
week_lead_time	varchar(10)	latin1_swedish_ci
last_modified_date	timestamp
last_modified_by	varchar(60)	latin1_swedish_ci
part_drg_file	varchar(200)	latin1_swedish_ci
part_drg_file_flag	int(11)
sa_drg_file	varchar(196)	latin1_swedish_ci
sa_drg_file_flag	int(11)
remarks	varchar(500)	latin1_swedish_ci
status_flag	varchar(10)	latin1_swedish_ci

Column

Type

Collation

Operator

Value

proj_detl_id

int(11)

oa_no

varchar(50)

latin1_swedish_ci

proj_no

varchar(50)

latin1_swedish_ci

sa_name

varchar(200)

latin1_swedish_ci

assy_drg_no

varchar(50)

latin1_swedish_ci

sa_drg_no

varchar(50)

latin1_swedish_ci

sa_drg_revision

int(11)

sa_per_assy

int(11)

part_name

varchar(200)

latin1_swedish_ci

part_drg_no

varchar(200)

latin1_swedish_ci

batch_no

int(11)

parts_per_assy

decimal(10,3)

reqd_total_qty

decimal(10,3)

bom_qty

decimal(10,3)

stages

int(11)

trgt_date

date

class_of_parts

varchar(50)

latin1_swedish_ci

raw_mat_spec

varchar(300)

latin1_swedish_ci

raw_mat_dimension

varchar(500)

latin1_swedish_ci

bom_upload_date

date

design_eng

varchar(255)

latin1_swedish_ci

part_drg_remarks

varchar(255)

latin1_swedish_ci

part_drg_release_by

varchar(255)

latin1_swedish_ci

drg_release_dt

date

type

varchar(12)

latin1_swedish_ci

revision

int(11)

revision_date

date

make

varchar(30)

latin1_swedish_ci

model

varchar(30)

latin1_swedish_ci

uom

varchar(10)

latin1_swedish_ci

website

varchar(500)

latin1_swedish_ci

hsn_code

int(11)

sac_code

int(11)

alternate_allow

varchar(3)

latin1_swedish_ci

week_lead_time

varchar(10)

latin1_swedish_ci

last_modified_date

timestamp

last_modified_by

varchar(60)

latin1_swedish_ci

part_drg_file

varchar(200)

latin1_swedish_ci

part_drg_file_flag

int(11)

sa_drg_file

varchar(196)

latin1_swedish_ci

sa_drg_file_flag

int(11)

remarks

varchar(500)

latin1_swedish_ci

status_flag

varchar(10)

latin1_swedish_ci

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

proj_detl_id
oa_no
proj_no
sa_name
assy_drg_no
sa_drg_no
sa_drg_revision
sa_per_assy
part_name
part_drg_no
batch_no
parts_per_assy
reqd_total_qty
bom_qty
stages
trgt_date
class_of_parts
raw_mat_spec
raw_mat_dimension
bom_upload_date
design_eng
part_drg_remarks
part_drg_release_by
drg_release_dt
type
revision
revision_date
make
model
uom
website
hsn_code
sac_code
alternate_allow
week_lead_time
last_modified_date
last_modified_by
part_drg_file
part_drg_file_flag
sa_drg_file
sa_drg_file_flag
remarks
status_flag

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Range search