Recent
Favorites
  • There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: yida_dataset
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
yida_dataset.dim_employee
yida_dataset.fact_kpi_actual
yida_dataset.fact_kpi_target
yida_dataset.trx_notification_log
yida_dataset.v_employee_hierarchy
yida_dataset.v_master_view
yida_dataset.v_master_view_base
yida_dataset.v_notif_payload_manajemen
yida_dataset.v_notif_payload_pegawai
yida_dataset.v_periode_berjalan
yida_dataset.v_target_cross_periode
Number of tables: 11
v yida_dataset dim_employee
* User_ID : varchar(50)
* Nama : varchar(150)
* Jabatan : varchar(150)
* Atasan_ID : varchar(50)
* ID_DT : varchar(100)
* Departemen : varchar(150)
* created_at : timestamp
* updated_at : timestamp
v yida_dataset fact_kpi_actual
* Actual_ID : varchar(100)
* Periode : date
* User_ID : varchar(50)
* KPI_ID : varchar(50)
* Nilai_Actual : decimal(18,2)
v yida_dataset fact_kpi_target
* Periode : date
* User_ID : varchar(50)
* KPI_ID : varchar(50)
* Nama_Indikator : varchar(255)
* Sifat : enum('More','Less')
* Target : decimal(18,2)
* Satuan : varchar(50)
* Weight : decimal(5,4)
* Source_Sheet_ID : varchar(255)
* Source_Sheet_Name : varchar(255)
v yida_dataset trx_notification_log
* id : int(11)
* periode : date
* user_id : varchar(50)
* nama_penerima : varchar(150)
* dingtalk_user_id : varchar(100)
* recipient_type : enum('PEGAWAI','MANAJEMEN')
* nilai_kpi_dikirim : decimal(5,2)
* status_send : enum('PENDING','SUCCESS','FAILED')
* error_message : text
* sent_at : timestamp
* created_at : timestamp
v yida_dataset v_employee_hierarchy
* Pegawai_User_ID : varchar(50)
* BOD_User_ID : varchar(50)
* Head_User_ID : varchar(50)
* Head_Unit_User_ID : varchar(50)
* Manager_User_ID : varchar(50)
* Supervisor_User_ID : varchar(50)
v yida_dataset v_master_view
* BOD User ID : varchar(50)
* BOD Nama : varchar(150)
* BOD Gestun : varchar(150)
* BOD DT ID : varchar(100)
* Head User ID : varchar(50)
* Head Nama : varchar(150)
* Head Jabatan : varchar(150)
* Head DT ID : varchar(100)
* Head Unit User ID : varchar(50)
* Head Unit Nama : varchar(150)
* Head Unit Jabatan : varchar(150)
* Head Unit DT ID : varchar(100)
* Manager User ID : varchar(50)
* Manager Nama : varchar(150)
* Manager Jabatan : varchar(150)
* Manager DT ID : varchar(100)
* Supervisor User ID : varchar(50)
* Supervisor Nama : varchar(150)
* Supervisor Jabatan : varchar(150)
* Supervisor DT ID : varchar(100)
* Pegawai User ID : varchar(50)
* Pegawai Nama : varchar(150)
* Pegawai Jabatan : varchar(150)
* Pegawai DT ID : varchar(100)
* Pegawai Departemen : varchar(150)
* Periode : date
* Indikator KPI : varchar(255)
* Target : decimal(18,2)
* Satuan : varchar(50)
* Actual : decimal(18,2)
* Achieved : decimal(24,6)
* Score : int(1)
* Weight : decimal(5,4)
* KPI (Score x Weight) : decimal(5,2)
v yida_dataset v_master_view_base
* BOD User ID : varchar(50)
* BOD Nama : varchar(150)
* BOD Gestun : varchar(150)
* BOD DT ID : varchar(100)
* Head User ID : varchar(50)
* Head Nama : varchar(150)
* Head Jabatan : varchar(150)
* Head DT ID : varchar(100)
* Head Unit User ID : varchar(50)
* Head Unit Nama : varchar(150)
* Head Unit Jabatan : varchar(150)
* Head Unit DT ID : varchar(100)
* Manager User ID : varchar(50)
* Manager Nama : varchar(150)
* Manager Jabatan : varchar(150)
* Manager DT ID : varchar(100)
* Supervisor User ID : varchar(50)
* Supervisor Nama : varchar(150)
* Supervisor Jabatan : varchar(150)
* Supervisor DT ID : varchar(100)
* Pegawai User ID : varchar(50)
* Pegawai Nama : varchar(150)
* Pegawai Jabatan : varchar(150)
* Pegawai DT ID : varchar(100)
* Pegawai Departemen : varchar(150)
* Periode : date
* Indikator KPI : varchar(255)
* Target : decimal(18,2)
* Satuan : varchar(50)
* Actual : decimal(18,2)
* Weight : decimal(5,4)
* Achieved : decimal(24,6)
v yida_dataset v_notif_payload_manajemen
* Periode : date
* User_ID : varchar(50)
* Nama : varchar(150)
* DingTalk_ID : varchar(100)
* Recipient_Type : varchar(9)
* Nilai_KPI : decimal(28,2)
v yida_dataset v_notif_payload_pegawai
* Periode : date
* User_ID : varchar(50)
* Nama : varchar(150)
* DingTalk_ID : varchar(100)
* Recipient_Type : varchar(7)
* Nilai_KPI : decimal(27,2)
v yida_dataset v_periode_berjalan
* Periode : date
v yida_dataset v_target_cross_periode
* Periode_Berjalan : date
* User_ID : varchar(50)
* KPI_ID : varchar(50)
* Nama_Indikator : varchar(255)
* Sifat : enum('More','Less')
* Target : decimal(18,2)
* Satuan : varchar(50)
* Weight : decimal(5,4)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship