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

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
dim_employee   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 63 InnoDB utf8mb4_general_ci 32 KiB -
fact_kpi_actual   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 533 InnoDB utf8mb4_general_ci 112 KiB -
fact_kpi_target   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 284 InnoDB utf8mb4_general_ci 112 KiB -
trx_notification_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14 InnoDB utf8mb4_general_ci 32 KiB -
v_employee_hierarchy   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_master_view   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_master_view_base   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_notif_payload_manajemen   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_notif_payload_pegawai   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_periode_berjalan   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
v_target_cross_periode   Browse Browse Structure Structure Search Search Insert Insert   Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
11 tables Sum ~894 InnoDB latin1_swedish_ci 288 KiB 0 B
With selected:

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns: