Recent
`materiel_cf_v1_verify_20260716b`.`fleet_component_master`
`materiel_cf_v1_verify_20260716b`.`pemandu_spanco`
`materiel_cf_v1_verify_20260716b`.`jawatan_master`
`materiel_cf_v1_verify_20260716b`.`jawatan_scope`
`materiel_cf_v1_verify_20260716b`.`pakaian_stock_forecast`
`materiel_cf_v1_verify_20260716`.`mh_faq`
`materiel_cf_v1_verify_20260716b`.`mh_faq`
`materiel_cf_v1_verify_20260716`.`mh_bookmarks`
`materiel_cf_v1_verify_20260716b`.`jawatan_merge_log`
`materiel_cf_v1_verify_20260716b`.`pakaian_permohonan`
Favourites
There are no favourite tables.
New
information_schema
materiel
materiel
materiel_cf_v1_verify_20260716
materiel_cf_v1_verify_20260716b
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise 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
).
main
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.
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.
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: materiel_cf_v1_verify_20260716b
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
action
module
user_id
actor_user_pk
actor_no_tentera
target_id
target_table
old_data
new_data
changed_fields
created_at
ip_address
request_method
user_agent
*
id
source_audit_log_id
action
module
user_id
actor_user_pk
actor_no_tentera
target_id
target_table
old_data
new_data
changed_fields
created_at
ip_address
request_method
user_agent
archived_at
archive_batch_id
archived_by
archive_reason
*
id
table_name
record_id
action_type
field_name
old_value
new_value
old_data
new_data
changed_fields
user_id
ip_address
module
action_scope
request_method
user_agent
created_at
*
id
source_audit_trail_id
table_name
record_id
action_type
field_name
old_value
new_value
old_data
new_data
changed_fields
user_id
ip_address
module
action_scope
request_method
user_agent
created_at
archived_at
archive_batch_id
archived_by
archive_reason
*
id
nama_agama
created_at
updated_at
*
id
nama_bangsa
created_at
updated_at
*
ID
kekananan
tred
pangkat_tred
kod_tred
kepakaran_nama
pangkat_kepakaran
kepakaran_kod
*
id
tred
pkt_nama
created_at
*
id
attempt_key
identifier
ip_address
user_agent
success
created_at
*
ID
kekananan
kategori
kategori_short
pengambilan
jantina
jum_digit
no_hadapan
*
ID
kekananan
pkt_full
pkt_short
pkt_nama
gelaran
pengambilan
kategori_pangkat
grup_pangkat
pangkat
deleted_at
created_at
updated_at
*
id
user_id
nombor_tentera
nama
old_profile_picture
backup_reason
backup_at
*
ID
user_id
movement_type
previous_unit
new_unit
previous_skn_caw_bhg
new_skn_caw_bhg
previous_bahagian
new_bahagian
kuasa_bertukar_keluar_unit
tarikh_melapor_asal
final_tarikh_melapor
updated_by
updated_at
ip_address
user_agent
*
ID
posting_history_id
sequence_no
kuasa_penangguhan
tarikh_melapor_baru
created_at
*
ID
user_id
previous_pangkat
new_pangkat
kuasa_kenaikan_pangkat
tarikh_kuatkuasa
tarikh_pemakaian_pangkat
updated_by
updated_at
system_action
ip_address
user_agent
*
ID
nombor_tentera
pangkat
pangkat_id
nama
nama_panggilan
call_sign
email
nombor_telefon
email_verified_at
email_verified_value
email_verification_token_hash
email_verification_expires_at
email_verification_last_sent_at
email_verification_grace_used_at
password
role
status
unit
unit_id
skn_caw_bhg
reset_token_hash
reset_token_expires
alamat
alamat_keluarga_lokasi
alamat_keluarga_poskod
alamat_keluarga_daerah
alamat_keluarga_negeri
alamat_semasa_lokasi
alamat_semasa_poskod
alamat_semasa_daerah
alamat_semasa_negeri
tarikh_lahir
tarikh_tauliah
status_perkahwinan
agama
bangsa
jantina
profile_picture
profile_identity_locked
jawatan
bahagian
tred
kepakaran
allow_maklumat_lesen
updated_at
mapping_verified_at
*
id
user_id
role_code
status
assigned_by
assigned_at
revoked_by
revoked_at
unit_id
active_user_id
active_role_code
active_unit_scope_key
*
id
user_id
role_code
status
assigned_by
assigned_at
revoked_by
revoked_at
unit_id
archived_at
archive_reason
*
ID
kenderaan_id
kategori_bateri
jenis_bateri
kti_bateri
created_at
*
ID
kenderaan_id
kategori_belt
Jenis_belt
kti_belt
*
id
component_key
component_name
description
default_unit
allows_multiple
write_mode
is_active
created_by
updated_by
deleted_at
deleted_by
created_at
updated_at
*
id
component_category_id
field_key
field_label
field_type
unit_label
is_required
is_searchable
display_order
validation_json
options_json
is_active
created_by
updated_by
created_at
updated_at
*
id
component_id
field_definition_id
value_text
value_number
value_date
value_boolean
created_by
updated_by
created_at
updated_at
*
id
kenderaan_id
kategori_filter
jenis_filter
kti_filter
created_at
*
ID
kenderaan_id
Jenis
saiz_kanopi
panjang_kanopi_ft
lebar_kanopi_ft
tinggi_kanopi_ft
kti_kanopi
created_at
*
id
component_uid
kenderaan_id
component_category_id
component_key
component_name
position_label
specification
quantity
unit_label
source_table
source_id
metadata_json
source_mode
legacy_identity_key
component_status
installed_at
removed_at
replaced_component_id
notes
version_no
created_by
updated_by
deleted_at
deleted_by
created_at
updated_at
*
ID
kenderaan_id
kategori_pmp
jenis_pmp
kti_liter
catatan
created_at
updated_at
*
id
migration_key
component_id
issue_code
component_uid
old_specification
old_quantity
old_metadata_json
old_component_status
component_created_at
component_updated_at
recovered_specification
recovered_quantity
evidence_source
evidence_checksum
recovery_status
archived_at
*
ID
kenderaan_id
no_daftar
jenis_tyr
jenis_tayar
saiz_tyr_depan
psi_tyr_depan
kti_tyr_depan
saiz_tyr_rear
psi_tyr_rear
kti_tyr_rear
saiz_tyr_spare
psi_tyr_spare
saiz_tube_depan
saiz_tube_belakang
saiz_tube_spare
saiz_pelapik_depan
saiz_pelapik_belakang
saiz_pelapik_spare
*
ID
kenderaan_id
saiz_front_left
saiz_front_right
saiz_rear
created_at
*
ID
no_daftar
no_daftar_awam
kategori_kenderaan_id
kategori_kenderaan
jenis_kenderaan_id
jenis_kenderaan
model_kenderaan
model_kenderaan_spanco_id
jenis_minyak
unit_id
unit
nombor_pengenalan
nombor_pendaftaran_aset
tmk
jenis_transmisi
tarikh_manufacture
tahun_pengeluar
no_chasis
no_enjin
ciri_istimewa
tugas_khas
had_min_pemandu
had_max_penumpang
harga_perolehan
harga_perolehan_backup_20260519
harga_semasa
created_by
updated_by
created_at
updated_at
status_kenderaan
scrap_by
scrap_at
deleted_at
deleted_by
is_deleted
*
ID
kenderaan_id
komponen
component_category_id
component_id
tarikh_pasang
odo_pasang
tarikh_due
odo_due
tarikh_tukar_sebenar
odo_tukar_sebenar
wwyy
tarikh_manufacturing
kondisi
status
catatan
created_at
created_by
updated_at
updated_by
*
id
unit_id
created_by
created_at
updated_by
updated_at
*
id
pegangan_id
kategori_kenderaan_id
jumlah
*
ID
kenderaan_id
pembaikan
nilai_pembaikan
odometer_masuk
odometer_keluar
no_rujuk_kewpa10
tarikh_kewpa10
kelulusan
tarikh_kelulusan
tarikh_masuk_bengkel
tarikh_keluar_bengkel
nama_bengkel
tarikh_waranti_mula
tarikh_waranti_tamat
penilaian_bengkel
ulasan_pengguna
created_by
updated_by
created_at
updated_at
deleted_at
deleted_by
is_deleted
*
id
fleet_repair_id
sequence_no
no_rujuk_kewpa10
tarikh_kewpa10
created_by
updated_by
created_at
updated_at
*
id
pembaikan_kenderaan_id
legacy_no_kenderaan
kenderaan_id
created_at
*
id
jawatan_id
authority_tag_id
is_active
created_at
updated_at
active_authority_map_key
*
id
jawatan_id
authority_tag_id
is_active
created_at
updated_at
canonical_id
archived_at
archive_reason
*
id
tag_key
tag_label
tag_description
is_active
created_at
updated_at
active_tag_key
*
id
tag_key
tag_label
tag_description
is_active
created_at
updated_at
canonical_id
archived_at
archive_reason
*
id
jawatan_id
unit_id
branch_id
section_id
conflict_type
conflict_status
resolved_by
resolved_at
resolution_note
created_at
updated_at
*
id
jawatan_full
jawatan_short
jawatan_full_key
jawatan_short_key
scope_level
status
is_active
merged_into_jawatan_id
pending_duplicate_review
duplicate_review_note
created_at
updated_at
*
id
source_jawatan_id
target_jawatan_id
merged_by
merged_at
merge_reason
affected_user_count
affected_scope_count
affected_authority_count
created_at
*
id
jawatan_id
unit_id
branch_id
section_id
scope_template_key
is_template_based
is_active
created_at
updated_at
*
id
user_id
jawatan_id
unit_id
branch_id
section_id
is_primary
priority_no
status
effective_start
effective_end
ended_at
ended_by
end_reason
created_at
updated_at
*
id
user_id
question
response_summary
rating
created_at
*
id
question_id
answer
is_verified
verification_level
verified_by
verified_at
helpful_count
created_by
created_at
*
id
user_id
source_type
source_id
created_at
*
id
title
message
status
created_by
created_at
*
id
title
content
category
tags
status
created_by
created_at
updated_at
*
id
source_type
source_id
comment
created_by
created_at
*
id
user_id
source_type
source_id
points
reason
created_at
*
id
title
category
tags
keywords
description
file_name
file_path
mime_type
file_size
version
effective_date
status
replacement_document_id
is_must_read
must_read_audience
must_read_unit
total_views
total_bookmarks
created_by
created_at
updated_by
updated_at
deleted_at
deleted_by
is_deleted
*
id
document_id
page_number
statement_text
normalized_text
text_hash
rects_json
created_by
created_at
*
id
document_id
user_id
opened_at
acknowledged_at
ip_address
reading_status
understanding_status
understanding_note
not_understood_reason
document_version
total_pages
pages_completed
last_page_number
resume_page_number
total_read_seconds
grace_started_at
grace_until
forced_at
completed_at
updated_at
*
id
document_id
user_id
document_version
event_type
event_message
page_number
event_payload
session_token
ip_address
user_agent_hash
created_at
*
id
document_id
user_id
document_version
page_number
first_seen_at
last_seen_at
dwell_seconds
is_completed
completed_at
session_token
created_at
updated_at
*
id
document_id
user_id
document_version
reminder_count
first_shown_at
last_shown_at
last_dismissed_at
next_allowed_at
force_after
created_at
updated_at
*
id
document_id
version
change_note
file_name
file_path
created_by
created_at
*
id
document_id
user_id
session_token
opened_at
last_seen_at
closed_at
ip_address
user_agent_hash
*
id
question
answer
source_type
source_id
status
created_by
created_at
*
id
user_id
target_audience
title
message
source_type
source_id
is_read
created_by
created_at
*
id
document_id
question
additional_reference
question_type
selected_statement
selected_page
selected_source
status
verified_answer_id
verification_level
verified_by
verified_at
verification_reason
total_views
like_count
created_by
created_at
updated_at
*
id
question_id
user_id
created_at
*
id
user_id
query_text
source_area
result_count
created_at
*
id
title
category
content
status
is_featured
like_count
comment_count
created_by
created_at
reviewed_by
reviewed_at
*
id
question_id
answer_id
version_no
verification_level
verified_by
reason
created_at
*
id
opened_by
start_at
end_at
reason
status
closed_by
closed_at
close_reason
created_at
*
id
kategori_id
sub_no_pakaian
nama_pakaian
pangkat
jantina
agama
bangsa
kategori_pangkat
kelayakan_tred
kelayakan_kepakaran
kelayakan_bekalan
image_path
is_active
created_by
updated_by
created_at
updated_at
*
id
pakaian_item_id
component_name
size_options
skala
is_required
sort_order
is_active
created_by
updated_by
created_at
updated_at
*
id
no_pakaian
kategori_pakaian
is_active
created_at
updated_at
*
id
user_id
nombor_tentera
pakaian_item_id
pakaian_item_name
component_id
component_key
component_name
old_size
new_size
action_type
audit_message
ip_address
user_agent
created_by
created_at
*
id
user_id
nombor_tentera
pakaian_item_id
component_id
component_key
component_name
selected_size
created_by
updated_by
created_at
updated_at
*
id
request_no
no_bpsi
user_id
pemohon_user_id
submitted_by_user_id
wakil_user_id
wakil_authorization_id
is_wakil
pemohon_nama
pemohon_no_tentera_snapshot
pemohon_pangkat
pemohon_unit
submitted_by_nama
submitted_by_no_tentera
wakil_nama
wakil_no_tentera
wakil_pangkat
wakil_jawatan
pemohon_no_tentera
nama
pangkat
pangkat_group
kategori_pangkat
jantina
unit
bahagian
tred
kepakaran
status
created_by
updated_by
created_at
updated_at
deleted_at
deleted_by
is_deleted
*
id
permohonan_id
component_row_id
original_file_name
stored_file_name
file_path
file_type
file_size
status
uploaded_by
uploaded_at
removed_by
removed_at
remove_reason
*
id
permohonan_id
pakaian_item_id
kategori_pakaian
sub_no_pakaian
nama_pakaian
size_baju
size_seluar
size_kasut
created_at
*
id
permohonan_item_id
permohonan_id
pakaian_item_id
component_id
component_name
selected_size
qty_dimohon
sebab_permohonan
catatan_permohonan
baki_sedia_ada
qty_diluluskan
catatan_pelulus
qty_reserved
reserved_at
reserved_by
reservation_status
qty_diterima
catatan_penerimaan
created_at
*
id
reason_name
description
requires_attachment
is_active
sort_order
created_by
created_at
updated_by
updated_at
*
id
permohonan_id
action
description
performed_by
performed_role
metadata_json
created_at
*
id
batch_id
parent_unit_id
allocated_qty
reserve_percent
reserve_qty
operational_qty
current_qty
reserve_status
fifo_sequence
is_active
created_by
updated_by
created_at
updated_at
*
id
pakaian_item_id
component_id
saiz
batch_no
pembekal
rujukan_perolehan
total_stok
tarikh_perolehan
tarikh_terima
tahun_perolehan
spesifikasi_ringkas
catatan_spec
is_active
created_by
updated_by
created_at
updated_at
*
id
allocation_id
batch_id
parent_unit_id
pakaian_item_id
component_id
jenis_transaksi
kuantiti
baki_sebelum
baki_selepas
operational_sebelum
operational_selepas
reserve_sebelum
reserve_selepas
rujukan
catatan
created_by
created_at
*
id
module_code
unit_code
running_year
running_month
last_number
updated_at
*
forecast_id
pakaian_item_id
kategori_pakaian
sub_no_pakaian
nama_pakaian
size_baju
size_seluar
size_kasut
unit
pangkat_group
jantina
tred
kepakaran
request_date
request_month
total_request_line
total_quantity
*
id
parent_unit_id
nama_lokasi
bangunan
bilik
rak
bin
catatan
is_active
created_by
updated_by
created_at
updated_at
*
id
perolehan_allocation_id
batch_id
parent_unit_id
pakaian_item_id
component_id
lokasi_id
qty_lokasi
catatan
is_active
created_by
updated_by
created_at
updated_at
*
id
pemohon_user_id
wakil_user_id
scope
status
valid_from
valid_until
catatan
created_by
created_at
revoked_by
revoked_at
revoke_reason
*
ID
core_user_id
user_id
gambar
taraf_kesihatan
tarikh_tamat_kesihatan
status
catatan
self_registration_status
verification_status
rejection_category
last_verified_snapshot
last_resubmit_snapshot
last_modified_at
last_modified_by
self_registered_at
self_registration_block_until
verified_by
verified_at
rejected_by
rejected_at
reject_remark
resubmitted_at
rejection_reason
created_at
updated_at
deleted_at
deleted_by
created_by
updated_by
*
ID
pemandu_id
no_bat_b3017
tarikh_tamat
status
*
ID
pemandu_id
jenis
kategori
status
no_bat_d41
tarikh_tamat
kelas
kelayakan_kelas_f
*
ID
pemandu_id
no_tentera
nama_pemandu
jenis
jenis_kemahiran
jenis_sijil
kelas_lesen
no_sijil
fail_sijil
file_name
file_path
uploaded_at
updated_at
*
ID
pemandu_id
kelas_lesen
no_siri_lesen
no_jpjl6
tarikh_tamat
*
ID
pemandu_id
status
permohonan_sijil
no_sijil
tarikh_tamat
had_kawasan
perbah_pendaftaran
perbah_pembatalan
permohonan_luar_had_pengguna
permohonan_luar_had_fleet
keputusan_sismat
rujuk_sismat
*
ID
unit_short
nombor_tentera
created_by
created_at
updated_at
*
id
kategori_id
jenis
kasting_tahun
kasting_mileage
*
ID
kod
jenis_tayar
maksud
*
id
kategori_filter
created_at
*
ID
kategori
*
id
kategori_id
komponen
is_optional
created_at
updated_at
*
ID
kod
jenis_pmp
kegunaan
*
id
kategori_kenderaan
jenis_kenderaan
model_kenderaan
cc
jenis_minyak
susunan
created_at
*
id
policy_code
source_table
archive_table
retention_days
archive_enabled
purge_enabled
notes
created_at
updated_at
*
cache_key
scope_label
payload_json
generated_by
generated_at
expires_at
duration_ms
*
archive_id
cache_key
scope_label
payload_json
generated_by
generated_at
expires_at
duration_ms
archived_at
archive_reason
*
id
issue_type
issue_code
table_name
record_id
issue_detail
created_at
column_name
invalid_value
action_taken
detected_at
*
id
relationship_code
child_table
child_column
parent_table
parent_column
fk_name
index_name
on_delete_rule
on_update_rule
enforcement_mode
is_active
fk_status
orphan_count
constraint_exists
last_error
last_checked_at
created_at
updated_at
*
id
relationship_code
child_table
child_column
parent_table
parent_column
contract_fk_status
computed_status
validation_severity
live_orphan_count
actual_constraint_exists
validation_message
captured_at
*
id
migration_key
source_table
duplicate_id
canonical_id
dedup_key
action_taken
created_at
*
id
cleanup_code
source_table
source_id
canonical_id
source_value
canonical_value
action_taken
detail
created_at
*
id
guard_code
api_key
parent_table
parent_column
guard_scope
is_active
guard_note
created_at
updated_at
*
id
migration
batch
applied_at
checksum
migration_file
executed_by
execution_ms
status
error_message
metadata_json
updated_at
*
id
migration
migration_file
checksum
status
message
executed_by
execution_ms
created_at
*
ID
markas
parent_markas
parent_markas_id
institut_latihan
ptj
main_unit
unit_kategori
parent_unit_id
is_internal_branch
unit_full
unit_short
is_ptj
kekananan
has_fleet_kenderaan
ptj_id
*
id
unit_id
source_unit_id
branch_name
branch_short
branch_type
has_fleet_kenderaan
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
active_branch_key
*
id
unit_id
source_unit_id
branch_name
branch_short
branch_type
has_fleet_kenderaan
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
canonical_id
archived_at
archive_reason
*
id
child_unit_id
parent_unit_id
relationship_type
remarks
is_active
created_at
updated_at
active_relationship_key
*
id
child_unit_id
parent_unit_id
relationship_type
remarks
is_active
created_at
updated_at
canonical_id
archived_at
archive_reason
*
id
branch_id
section_name
section_short
section_type
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
active_section_key
*
id
branch_id
section_name
section_short
section_type
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
canonical_id
archived_at
archive_reason
*
relationship_code
table_name
record_id
column_name
invalid_value
parent_table
parent_column
*
relationship_code
child_table
child_column
parent_table
parent_column
orphan_table_name
orphan_record_id
orphan_column_name
invalid_value
required_action
*
relationship_code
child_table
child_column
parent_table
parent_column
computed_status
validation_severity
live_orphan_count
actual_constraint_exists
validation_message
required_action
*
relationship_code
child_table
child_column
parent_table
parent_column
fk_name
on_delete_rule
on_update_rule
enforcement_mode
fk_status
constraint_exists
live_orphan_count
last_orphan_count
last_error
last_checked_at
readiness_status
*
relationship_code
child_table
child_column
parent_table
parent_column
fk_name
index_name
on_delete_rule
on_update_rule
enforcement_mode
contract_fk_status
contract_constraint_exists
child_table_exists
parent_table_exists
child_column_exists
parent_column_exists
schema_ready
actual_constraint_exists
actual_fk_names
live_orphan_count
computed_status
validation_severity
validation_message
last_recorded_orphan_count
last_error
last_checked_at
*
computed_status
validation_severity
relationship_total
live_orphan_total
enforced_total
missing_schema_total
*
source_table
legacy_source_rows
canonical_source_rows
row_difference
parity_status
*
id
user_id
role_code
status
assigned_by
assigned_at
revoked_by
revoked_at
unit_id
*
ID
kenderaan_id
kategori_bateri
jenis_bateri
kti_bateri
created_at
*
ID
kenderaan_id
no_daftar
jenis_tyr
jenis_tayar
saiz_tyr_depan
psi_tyr_depan
kti_tyr_depan
saiz_tyr_rear
psi_tyr_rear
kti_tyr_rear
saiz_tyr_spare
psi_tyr_spare
saiz_tube_depan
saiz_tube_belakang
saiz_tube_spare
saiz_pelapik_depan
saiz_pelapik_belakang
saiz_pelapik_spare
*
ID
kenderaan_id
pembaikan
nilai_pembaikan
odometer_masuk
odometer_keluar
no_rujuk_kewpa10
tarikh_kewpa10
kelulusan
tarikh_kelulusan
tarikh_masuk_bengkel
tarikh_keluar_bengkel
nama_bengkel
tarikh_waranti_mula
tarikh_waranti_tamat
penilaian_bengkel
ulasan_pengguna
created_by
updated_by
created_at
updated_at
*
id
question_id
answer
is_verified
verification_level
verified_by
verified_at
helpful_count
created_by
created_at
*
id
document_id
user_id
opened_at
acknowledged_at
ip_address
reading_status
understanding_status
understanding_note
not_understood_reason
document_version
total_pages
pages_completed
last_page_number
resume_page_number
total_read_seconds
grace_started_at
grace_until
forced_at
completed_at
updated_at
*
id
document_id
user_id
document_version
page_number
first_seen_at
last_seen_at
dwell_seconds
is_completed
completed_at
session_token
created_at
updated_at
*
id
pakaian_item_id
component_name
size_options
is_required
sort_order
is_active
created_by
updated_by
created_at
updated_at
*
id
permohonan_id
pakaian_item_id
kategori_pakaian
sub_no_pakaian
nama_pakaian
size_baju
size_seluar
size_kasut
created_at
*
ID
pemandu_id
no_tentera
nama_pemandu
jenis
jenis_kemahiran
jenis_sijil
kelas_lesen
no_sijil
fail_sijil
file_name
file_path
uploaded_at
updated_at
*
ID
pemandu_id
kelas_lesen
no_siri_lesen
no_jpjl6
tarikh_tamat
*
ID
pemandu_id
status
permohonan_sijil
no_sijil
tarikh_tamat
had_kawasan
perbah_pendaftaran
perbah_pembatalan
permohonan_luar_had_pengguna
permohonan_luar_had_fleet
keputusan_sismat
rujuk_sismat
*
id
unit_id
source_unit_id
branch_name
branch_short
branch_type
has_fleet_kenderaan
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
*
id
child_unit_id
parent_unit_id
relationship_type
remarks
is_active
created_at
updated_at
*
id
child_unit_id
parent_unit_id
relationship_type
remarks
is_active
created_at
updated_at
*
id
branch_id
section_name
section_short
section_type
sort_order
is_active
pending_admin_review
requested_by
requested_at
request_source
created_at
updated_at
*
ID
no_daftar
no_daftar_awam
kategori_kenderaan_id
kategori_kenderaan
jenis_kenderaan_id
jenis_kenderaan
model_kenderaan_spanco_id
model_kenderaan
jenis_minyak
unit_id
unit
unit_full
nombor_pengenalan
nombor_pendaftaran_aset
tmk
no_chasis
no_enjin
ciri_istimewa
tugas_khas
had_min_pemandu
had_max_penumpang
harga_perolehan
harga_semasa
status_kenderaan
created_by
updated_by
created_at
updated_at
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_log
audit_log_archive
audit_trail
audit_trail_archive
core_agama
core_bangsa
core_kepakaran
core_kepakaran_tred_rank
core_login_attempts
core_no_tentera
core_pangkat
core_profile_picture_backup
core_profile_posting_history
core_profile_posting_postponement
core_profile_rank_history
core_user
core_user_roles
core_user_roles_archive
fleet_component_bateri
fleet_component_belting
fleet_component_category
fleet_component_field_definition
fleet_component_field_value
fleet_component_filter
fleet_component_kanopi
fleet_component_master
fleet_component_pmp
fleet_component_recovery_archive
fleet_component_tayar
fleet_component_wiper
fleet_kenderaan
fleet_maintenance_status
fleet_rekod_pegangan
fleet_rekod_pegangan_detail
fleet_repair
fleet_repair_kewpa10
fleet_repair_vehicle_snapshot
jawatan_authority_map
jawatan_authority_map_archive
jawatan_authority_tag
jawatan_authority_tag_archive
jawatan_conflict_log
jawatan_master
jawatan_merge_log
jawatan_scope
jawatan_user_assignment
mh_ai_feedback
mh_answers
mh_bookmarks
mh_broadcasts
mh_clarifications
mh_comments
mh_contributor_points
mh_documents
mh_document_highlights
mh_document_reads
mh_document_read_events
mh_document_read_pages
mh_document_read_reminders
mh_document_versions
mh_document_view_sessions
mh_faq
mh_notifications
mh_questions
mh_question_likes
mh_search_logs
mh_sharing
mh_verification_history
pakaian_audit_access_window
pakaian_item
pakaian_item_component
pakaian_kategori
pakaian_maklumat_audit_log
pakaian_maklumat_user
pakaian_permohonan
pakaian_permohonan_attachment
pakaian_permohonan_item
pakaian_permohonan_item_component
pakaian_permohonan_reason
pakaian_permohonan_timeline
pakaian_perolehan_allocation
pakaian_perolehan_batch
pakaian_perolehan_transaksi
pakaian_running_number
pakaian_stock_forecast
pakaian_stok_lokasi
pakaian_stok_lokasi_allocation
pakaian_wakil_authorization
pemandu
pemandu_bat_b3017
pemandu_bat_d41
pemandu_kemahiran_khas
pemandu_lesen_awam
pemandu_spanco
pemandu_unit_admin
ref_jenis_kenderaan
ref_jenis_tayar
ref_kategori_filter
ref_kategori_kenderaan
ref_kategori_komponen
ref_kategori_pmp
ref_model_kenderaan_spanco
sys_audit_lifecycle_policy
sys_dashboard_cache
sys_dashboard_cache_archive
sys_database_integrity_issues
sys_database_relationship_contract
sys_database_relationship_validation_snapshot
sys_data_deduplication_map
sys_master_data_cleanup_log
sys_master_delete_guard_contract
sys_migrations
sys_migration_execution_log
unit
unit_branch
unit_branch_archive
unit_relationship
unit_relationship_archive
unit_section
unit_section_archive
vw_database_integrity_orphans
vw_database_relationship_blocker_detail
vw_database_relationship_blocker_queue
vw_database_relationship_readiness
vw_database_relationship_validation
vw_database_relationship_validation_summary
vw_fleet_component_framework_parity
vw_integrity_orphan_core_user_roles_user
vw_integrity_orphan_fleet_component_bateri
vw_integrity_orphan_fleet_component_tayar
vw_integrity_orphan_fleet_repair
vw_integrity_orphan_mh_answers_question
vw_integrity_orphan_mh_document_reads
vw_integrity_orphan_mh_read_pages
vw_integrity_orphan_pakaian_item_component
vw_integrity_orphan_pakaian_permohonan_item
vw_integrity_orphan_pemandu_kemahiran
vw_integrity_orphan_pemandu_lesen_awam
vw_integrity_orphan_pemandu_spanco
vw_integrity_orphan_unit_branch_unit
vw_integrity_orphan_unit_relationship_child
vw_integrity_orphan_unit_relationship_parent
vw_integrity_orphan_unit_section_branch
vw_kenderaan_reference
.
select column