Recent
Favorites
  • There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: yida_dataset_v1
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_v1.dim_employee
yida_dataset_v1.fact_kpi_actual
yida_dataset_v1.fact_kpi_target
yida_dataset_v1.trx_notification_log
yida_dataset_v1.v_master_view
yida_dataset_v1.v_master_view_base
yida_dataset_v1.v_notif_payload_manajemen
yida_dataset_v1.v_notif_payload_pegawai
yida_dataset_v1.v_periode_berjalan
yida_dataset_v1.v_target_cross_periode
Number of tables: 10
v yida_dataset_v1 dim_employee
* User_ID : varchar(50)
* Nama : varchar(150)
* Jabatan : varchar(150)
* Manager_ID : varchar(50)
* Head_Unit_ID : varchar(50)
* Head_ID : varchar(50)
* ID_DT : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v yida_dataset_v1 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_v1 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_v1 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_v1 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)
* Pegawai User ID : varchar(50)
* Pegawai Nama : varchar(150)
* Pegawai Jabatan : varchar(150)
* Pegawai DT ID : varchar(100)
* 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_v1 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)
* Pegawai User ID : varchar(50)
* Pegawai Nama : varchar(150)
* Pegawai Jabatan : varchar(150)
* Pegawai DT ID : varchar(100)
* 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_v1 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_v1 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_v1 v_periode_berjalan
* Periode : date
v yida_dataset_v1 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