macbook-air-user.tail9925bb.ts.net / localhost / weichai_crm

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customise 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 -

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		weichai_crm activity_documentations
id : int(11) unsigned
title : varchar(200)
category : varchar(100)
activity_date : date
shipyard_id : int(11) unsigned
description : text
user_id : int(11) unsigned
created_at : datetime
deleted_at : datetime

v		weichai_crm activity_documentation_files
id : int(11) unsigned
documentation_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
thumb_name : varchar(255)
media_type : enum('photo','video')
uploaded_at : datetime

v		weichai_crm activity_documentation_shipyards
id : int(11) unsigned
documentation_id : int(11) unsigned
shipyard_id : int(11) unsigned

v		weichai_crm activity_logs
id : int(11) unsigned
user_id : int(11) unsigned
user_name : varchar(150)
module : varchar(50)
action : varchar(20)
record_label : varchar(255)
description : varchar(255)
changes : text
created_at : datetime

v		weichai_crm after_sales_units
id : int(11) unsigned
contract_id : int(11) unsigned
item_name : varchar(200)
unit_no : smallint(5) unsigned
vessel_name : varchar(150)
serial_number : varchar(100)
order_number : varchar(100)
commissioning_date : date
commissioning_input_date : date
warranty_start : date
warranty_end : date
remarks : text
updated_by : int(11) unsigned
created_at : datetime
updated_at : datetime

v		weichai_crm agenda_events
id : int(11) unsigned
title : varchar(150)
event_date : date
start_time : time
shipyard_id : int(11) unsigned
note : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime

v		weichai_crm alt_fuel_engine_catalogs
id : int(11) unsigned
category : varchar(20)
fuel_type : varchar(30)
model_name : varchar(100)
subtitle : varchar(150)
configuration : varchar(150)
bore_stroke : varchar(100)
starting_method : varchar(100)
cylinders : varchar(50)
displacement : varchar(50)
engine_rotation : varchar(100)
photo : varchar(255)
diagram_front : varchar(255)
diagram_side : varchar(255)
note : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm alt_fuel_engine_dimensions
id : int(11) unsigned
alt_fuel_catalog_id : int(11) unsigned
context : varchar(50)
length_mm : varchar(50)
width_mm : varchar(50)
height_mm : varchar(50)
height_star_mm : varchar(50)
dry_weight_kg : varchar(50)
sort_order : int(11)

v		weichai_crm alt_fuel_engine_ratings
id : int(11) unsigned
alt_fuel_catalog_id : int(11) unsigned
model_variant : varchar(100)
power : varchar(50)
speed : varchar(50)
technical_route : varchar(150)
application : varchar(50)
governor : varchar(50)
aspiration : varchar(50)
emission : varchar(50)
rating : varchar(50)
sort_order : int(11)

v		weichai_crm app_settings
setting_key : varchar(100)
setting_value : varchar(255)

v		weichai_crm auxiliary_engine_catalogs
id : int(11) unsigned
model_name : varchar(100)
subtitle : varchar(150)
configuration : varchar(150)
bore_stroke : varchar(100)
starting_method : varchar(100)
cylinders : varchar(50)
displacement : varchar(50)
engine_rotation : varchar(100)
photo : varchar(255)
diagram_front : varchar(255)
diagram_side : varchar(255)
note : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm auxiliary_engine_dimensions
id : int(11) unsigned
auxiliary_engine_catalog_id : int(11) unsigned
application : varchar(50)
length_mm : varchar(50)
width_mm : varchar(50)
height_mm : varchar(50)
height_star_mm : varchar(50)
dry_weight_kg : varchar(50)
sort_order : int(11)

v		weichai_crm auxiliary_engine_ratings
id : int(11) unsigned
auxiliary_engine_catalog_id : int(11) unsigned
application : varchar(50)
model_variant : varchar(100)
power_kw : varchar(50)
speed : varchar(50)
governor : varchar(50)
aspiration : varchar(50)
emission : varchar(50)
rating : varchar(50)
sort_order : int(11)

v		weichai_crm catalog_documents
id : int(11) unsigned
model_name : varchar(150)
category : varchar(100)
doc_type : varchar(100)
original_name : varchar(255)
stored_name : varchar(255)
size : bigint(20) unsigned
note : text
uploaded_at : datetime
deleted_at : datetime

v		weichai_crm contracts
id : int(11) unsigned
shipyard_id : int(11) unsigned
external_customer_name : varchar(200)
number : varchar(50)
handover_location : varchar(200)
contract_month : tinyint(2) unsigned
contract_year : smallint(4) unsigned
status : varchar(100)
payment_status : varchar(100)
is_addendum : tinyint(1)
created_at : datetime
updated_at : datetime
additional_silencer : text
additional_throttle_cable : text
additional_tva_report : text
additional_notes : text
dp_date : date
payment_date : date
term_days : varchar(50)
deadline : date
goods_status : varchar(200)
estimasi_sampai : date
shipping_note : text
note : text
deleted_at : datetime

v		weichai_crm contract_deliveries
id : int(11) unsigned
contract_id : int(11) unsigned
item_name : varchar(200)
unit_no : smallint(5) unsigned
status : varchar(20)
delivery_date : date
updated_by : int(11) unsigned
created_at : datetime
updated_at : datetime

v		weichai_crm contract_files
id : int(11) unsigned
contract_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
uploaded_at : datetime

v		weichai_crm contract_items
id : int(11) unsigned
contract_id : int(11) unsigned
item_name : varchar(200)
qty : decimal(12,2)
unit : varchar(30)

v		weichai_crm daily_activities
id : int(11) unsigned
user_id : int(11) unsigned
activity_date : date
shipyard_id : int(11) unsigned
tujuan : varchar(1000)
report : text
notes : text
created_at : datetime
deleted_at : datetime

v		weichai_crm daily_activity_shipyards
id : int(11) unsigned
activity_id : int(11) unsigned
shipyard_id : int(11) unsigned

v		weichai_crm engine_catalogs
id : int(11) unsigned
model_name : varchar(100)
subtitle : varchar(150)
configuration : varchar(150)
bore_stroke : varchar(100)
starting_method : varchar(100)
cylinders : varchar(50)
displacement : varchar(50)
engine_rotation : varchar(100)
length_mm : varchar(50)
width_mm : varchar(50)
height_mm : varchar(50)
height_star_mm : varchar(50)
dry_weight_kg : varchar(50)
photo : varchar(255)
diagram_front : varchar(255)
diagram_side : varchar(255)
note : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm engine_catalog_ratings
id : int(11) unsigned
engine_catalog_id : int(11) unsigned
model_variant : varchar(100)
power : varchar(50)
speed : varchar(50)
technical_route : varchar(100)
aspiration : varchar(50)
emission : varchar(50)
rating : varchar(50)
sort_order : int(11)

v		weichai_crm genset_catalogs
id : int(11) unsigned
category : varchar(20)
model_name : varchar(150)
subtitle : varchar(150)
configuration : varchar(150)
starting_method : varchar(100)
cylinders : varchar(50)
engine_rotation : varchar(100)
photo : varchar(255)
diagram_front : varchar(255)
diagram_side : varchar(255)
note : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm genset_catalog_dimensions
id : int(11) unsigned
genset_catalog_id : int(11) unsigned
series : varchar(50)
model : varchar(100)
length_mm : varchar(50)
width_mm : varchar(50)
height_mm : varchar(50)
height_star_mm : varchar(50)
dry_weight_kg : varchar(50)
sort_order : int(11)

v		weichai_crm genset_catalog_ratings
id : int(11) unsigned
genset_catalog_id : int(11) unsigned
engine_series : varchar(50)
displacement : varchar(50)
set_model : varchar(100)
power_kw : varchar(50)
frequency_hz : varchar(20)
voltage : varchar(50)
phase : varchar(20)
governor : varchar(50)
emission : varchar(50)
rating : varchar(50)
sort_order : int(11)

v		weichai_crm migrations
id : bigint(20) unsigned
version : varchar(255)
class : varchar(255)
group : varchar(255)
namespace : varchar(255)
time : int(11)
batch : int(11) unsigned

v		weichai_crm other_files
id : int(11) unsigned
folder_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
size : bigint(20) unsigned
user_id : int(11) unsigned
uploaded_at : datetime
deleted_at : datetime

v		weichai_crm other_file_folders
id : int(11) unsigned
parent_id : int(11) unsigned
name : varchar(200)
description : text
visible_to_all : tinyint(1)
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm other_file_folder_roles
id : int(11) unsigned
folder_id : int(11) unsigned
role_id : int(11) unsigned

v		weichai_crm projects
id : int(11) unsigned
title : varchar(200)
project_date : date
shipyard_id : int(11) unsigned
description : text
user_id : int(11) unsigned
created_at : datetime
deleted_at : datetime

v		weichai_crm project_files
id : int(11) unsigned
project_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
size : bigint(20) unsigned
uploaded_at : datetime

v		weichai_crm project_shipyards
id : int(11) unsigned
project_id : int(11) unsigned
shipyard_id : int(11) unsigned

v		weichai_crm quotations
id : int(11) unsigned
shipyard_id : int(11) unsigned
external_customer_name : varchar(200)
external_pic : varchar(150)
quotation_date : date
last_followup_at : datetime
note : text
number : varchar(50)
status : varchar(50)
cancel_reason : text
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm quotation_files
id : int(11) unsigned
quotation_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
uploaded_at : datetime

v		weichai_crm quotation_followups
id : int(11) unsigned
quotation_id : int(11) unsigned
followup_date : date
status : varchar(100)
note : text
user_id : int(11) unsigned
user_name : varchar(150)
created_at : datetime

v		weichai_crm quotation_items
id : int(11) unsigned
quotation_id : int(11) unsigned
item_name : varchar(200)
qty : decimal(12,2)
created_at : datetime
unit : varchar(30)

v		weichai_crm quotation_term_presets
id : int(11) unsigned
delivery_label : varchar(100)
status_label : varchar(100)
terms : text
payment : text
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		weichai_crm roles
id : int(11) unsigned
name : varchar(100)
is_system : tinyint(1)
created_at : datetime
updated_at : datetime

v		weichai_crm role_permissions
id : int(11) unsigned
role_id : int(11) unsigned
module : varchar(50)
can_view : tinyint(1)
can_create : tinyint(1)
can_update : tinyint(1)
can_delete : tinyint(1)
can_export : tinyint(1)

v		weichai_crm sales_reps
id : int(11) unsigned
name : varchar(150)
email : varchar(150)
phone : varchar(50)
mobile : varchar(50)
created_at : datetime

v		weichai_crm shipyards
id : int(11) unsigned
name : varchar(200)
sales_pic : varchar(100)
location : varchar(200)
category : enum('Buyer','No')
logo : varchar(255)
last_visit : date
special_note : text
last_order : date
notes : text
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm shipyard_capacities
id : int(11) unsigned
shipyard_id : int(11) unsigned
year : varchar(20)
capacity : text
project : text
created_at : datetime

v		weichai_crm shipyard_contacts
id : int(11) unsigned
shipyard_id : int(11) unsigned
contact_name : varchar(100)
phone : varchar(50)
position : varchar(100)
created_at : datetime

v		weichai_crm users
id : int(11) unsigned
name : varchar(150)
email : varchar(150)
password : varchar(255)
role_id : int(11) unsigned
is_active : tinyint(1)
last_seen_at : datetime
logged_out_at : datetime
created_at : datetime
updated_at : datetime

v		weichai_crm vessels
id : int(11) unsigned
shipyard_id : int(11) unsigned
owner_name : varchar(150)
vessel_name : varchar(150)
vessel_type : varchar(100)
build_year : smallint(4) unsigned
notes : text
user_id : int(11) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		weichai_crm vessel_engines
id : int(11) unsigned
vessel_id : int(11) unsigned
engine_role : varchar(60)
engine_model : varchar(150)
qty : smallint(5) unsigned
sort_order : smallint(5) unsigned

v		weichai_crm vessel_photos
id : int(11) unsigned
vessel_id : int(11) unsigned
original_name : varchar(255)
stored_name : varchar(255)
size : int(11) unsigned
uploaded_at : datetime

Create relationship
FOREIGN KEY
on delete
on update