server.tailade547.ts.net / 127.0.0.1 / gti_erp

There are no favorite tables.

Customize appearance of the navigation panel.

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.

Customize the navigation tree.

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 display options.

Servers

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 display options.

Databases

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

Tables display options.

Tables

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		gti_erp activity_logs
id : bigint(20) unsigned
user_id : bigint(20) unsigned
module : varchar(50)
action : varchar(50)
doc_type : varchar(50)
doc_id : bigint(20) unsigned
description : text
old_values : longtext
new_values : longtext
ip_address : varchar(45)
user_agent : varchar(255)
created_at : datetime

v		gti_erp approval_delegations
id : bigint(20) unsigned
original_approver_type : enum('role','user','position')
original_approver_id : bigint(20) unsigned
delegated_to_type : enum('role','user','position')
delegated_to_id : bigint(20) unsigned
reason : text
effective_from : datetime
effective_to : datetime
created_at : datetime
created_by : bigint(20) unsigned

v		gti_erp approval_histories
id : bigint(20) unsigned
approval_request_id : bigint(20) unsigned
approval_step_id : bigint(20) unsigned
action : enum('approve','reject','return','hold','escalate','cancel','resume')
actor_user_id : bigint(20) unsigned
notes : text
metadata : longtext
action_at : datetime

v		gti_erp approval_matrixes
id : bigint(20) unsigned
doc_type : varchar(50)
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
location_id : bigint(20) unsigned
name : varchar(150)
mode : enum('sequential','parallel','any_one','all_must')
is_active : tinyint(1)
effective_from : datetime
effective_to : datetime
created_at : datetime
updated_at : datetime

v		gti_erp approval_matrix_details
id : bigint(20) unsigned
matrix_id : bigint(20) unsigned
sequence_no : int(10) unsigned
department_id : bigint(20) unsigned
min_amount : decimal(18,2)
max_amount : decimal(18,2)
risk_level : varchar(50)
approver_type : enum('role','user','position')
approver_role_id : bigint(20) unsigned
approver_user_id : bigint(20) unsigned
approver_position_id : bigint(20) unsigned
required_count : int(10) unsigned
created_at : datetime
updated_at : datetime

v		gti_erp approval_requests
id : bigint(20) unsigned
doc_type : varchar(50)
doc_id : bigint(20) unsigned
matrix_id : bigint(20) unsigned
matrix_detail_id : bigint(20) unsigned
workflow_instance_id : bigint(20) unsigned
requester_user_id : bigint(20) unsigned
amount : decimal(18,2)
risk_level : varchar(50)
status : enum('pending','approved','rejected','returned','cancelled','expired')
created_at : datetime
updated_at : datetime

v		gti_erp approval_request_steps
id : bigint(20) unsigned
approval_request_id : bigint(20) unsigned
matrix_detail_id : bigint(20) unsigned
step_status : enum('pending','approved','rejected','returned','cancelled','delegated','expired')
assigned_to_user_id : bigint(20) unsigned
assigned_at : datetime
resolved_at : datetime

v		gti_erp branches
id : bigint(20) unsigned
company_id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
address : text
phone : varchar(30)
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp business_units
id : bigint(20) unsigned
company_id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
description : text
status : enum('active','inactive')
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp companies
id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
address : text
phone : varchar(30)
email : varchar(100)
npwp : varchar(30)
logo : varchar(255)
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp departments
id : bigint(20) unsigned
code : varchar(50)
name : varchar(100)
description : text
status : enum('draft','active','inactive','archived')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp document_histories
id : bigint(20) unsigned
doc_type : varchar(50)
doc_id : bigint(20) unsigned
workflow_instance_id : bigint(20) unsigned
action : varchar(50)
actor_user_id : bigint(20) unsigned
from_state : varchar(50)
to_state : varchar(50)
notes : text
metadata : longtext
action_at : datetime
created_at : datetime

v		gti_erp employee_profiles
id : bigint(20) unsigned
user_id : bigint(20) unsigned
employee_code : varchar(50)
nik : varchar(30)
join_date : date
birth_date : date
gender : enum('M','F')
address : text
emergency_contact : varchar(150)
emergency_phone : varchar(30)
created_at : datetime
updated_at : datetime

v		gti_erp inspection
id : bigint(20) unsigned
gti_id : varchar(30)
psr_number : varchar(50)
hasil_inspeksi : enum('OK','REJECT')
catatan_qc : text
inspektor_id : bigint(20) unsigned
created_at : datetime

v		gti_erp locations
id : bigint(20) unsigned
branch_id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
description : text
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp login_histories
id : bigint(20) unsigned
user_id : bigint(20) unsigned
login_time : datetime
ip_address : varchar(45)
user_agent : varchar(255)

v		gti_erp number_sequences
id : bigint(20) unsigned
doc_type : varchar(50)
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
location_id : bigint(20) unsigned
template : varchar(255)
reset_period : enum('none','yearly','monthly','daily')
seq_width : int(10) unsigned
is_active : tinyint(1)
effective_from : datetime
effective_to : datetime
created_at : datetime
updated_at : datetime

v		gti_erp permissions
id : bigint(20) unsigned
code : varchar(100)
name : varchar(150)
module : varchar(50)
action : varchar(50)
description : text
created_at : datetime
updated_at : datetime

v		gti_erp plants
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
address : text
status : enum('active','inactive')
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp positions
id : bigint(20) unsigned
department_id : bigint(20) unsigned
code : varchar(50)
name : varchar(100)
level : tinyint(3) unsigned
status : enum('active','inactive')
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp receiving
id : bigint(20) unsigned
gti_id : varchar(30)
tgl_masuk : date
customer_name : varchar(150)
component_name : varchar(150)
dn_customer : varchar(100)
status_barang : enum('Waiting Inspection','Inspected','Rejected')
created_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime

v		gti_erp roles
id : bigint(20) unsigned
code : varchar(50)
name : varchar(100)
description : text
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp role_permissions
id : bigint(20) unsigned
role_id : bigint(20) unsigned
permission_id : bigint(20) unsigned
created_at : datetime

v		gti_erp schema_versions
id : bigint(20) unsigned
migration_name : varchar(200)
checksum : varchar(64)
applied_by : varchar(100)
applied_at : datetime
status : enum('applied','rolled_back')

v		gti_erp sequence_counters
id : bigint(20) unsigned
sequence_id : bigint(20) unsigned
period_key : varchar(32)
current_value : bigint(20) unsigned
created_at : datetime
updated_at : datetime

v		gti_erp users
id : bigint(20) unsigned
role_id : bigint(20) unsigned
department_id : bigint(20) unsigned
username : varchar(100)
password : varchar(255)
nama_lengkap : varchar(150)
email : varchar(150)
phone : varchar(20)
status : enum('active','inactive')
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
deleted_at : datetime

v		gti_erp user_roles
id : bigint(20) unsigned
user_id : bigint(20) unsigned
role_id : bigint(20) unsigned
created_by : bigint(20) unsigned
created_at : datetime

v		gti_erp user_sessions
id : bigint(20) unsigned
user_id : bigint(20) unsigned
session_token : varchar(128)
ip_address : varchar(45)
user_agent : varchar(255)
last_active : datetime
expires_at : datetime
created_at : datetime

v		gti_erp workflow_definitions
id : bigint(20) unsigned
doc_type : varchar(50)
name : varchar(150)
version : int(10) unsigned
is_active : tinyint(1)
effective_from : datetime
effective_to : datetime
created_at : datetime
updated_at : datetime

v		gti_erp workflow_histories
id : bigint(20) unsigned
workflow_instance_id : bigint(20) unsigned
from_state_id : bigint(20) unsigned
to_state_id : bigint(20) unsigned
action : varchar(50)
actor_user_id : bigint(20) unsigned
notes : text
metadata : longtext
action_at : datetime
created_at : datetime

v		gti_erp workflow_instances
id : bigint(20) unsigned
doc_type : varchar(50)
doc_id : bigint(20) unsigned
definition_id : bigint(20) unsigned
current_state_id : bigint(20) unsigned
created_by : bigint(20) unsigned
initiated_at : datetime
completed_at : datetime
is_cancelled : tinyint(1)
created_at : datetime
updated_at : datetime

v		gti_erp workflow_states
id : bigint(20) unsigned
definition_id : bigint(20) unsigned
code : varchar(50)
name : varchar(150)
is_terminal : tinyint(1)
sort_order : int(10) unsigned
created_at : datetime
updated_at : datetime

v		gti_erp workflow_transitions
id : bigint(20) unsigned
definition_id : bigint(20) unsigned
from_state_id : bigint(20) unsigned
to_state_id : bigint(20) unsigned
action : varchar(50)
sequence_no : int(10) unsigned
requires_approval : tinyint(1)
created_at : datetime
updated_at : datetime

Create relationship
FOREIGN KEY
on delete
on update