ci4.aire.my.id / 127.0.0.1 / dbm_aireprofile

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		dbm_aireprofile app_links
id : varchar(36)
platform : enum('android','ios')
url : varchar(255)
is_active : tinyint(1)
updated_at : timestamp

v		dbm_aireprofile articles
id : varchar(36)
category_id : varchar(36)
user_id : varchar(36)
thumbnail : varchar(255)
title : varchar(255)
slug : varchar(255)
excerpt : varchar(255)
content : longtext
is_published : tinyint(1)
published_at : timestamp
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile article_banner
id : varchar(36)
title : varchar(255)
subtitle : varchar(255)
image : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
updated_at : timestamp

v		dbm_aireprofile article_categories
id : varchar(36)
cdcore : varchar(50)
name : varchar(100)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile article_page_content
id : varchar(36)
brand_text : varchar(100)
title : varchar(100)
subtitle : text
updated_at : timestamp

v		dbm_aireprofile article_section_content
id : varchar(36)
title : varchar(100)
subtitle : varchar(255)
updated_at : timestamp

v		dbm_aireprofile article_sidebar_banners
id : varchar(36)
cdcore : varchar(50)
title : varchar(255)
subtitle : varchar(255)
image : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile brands
kdmerk : varchar(50)
cdcore : varchar(50)
kdjens : varchar(50)
nmmerk : varchar(100)
slug : varchar(255)
image_url : varchar(255)
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile brands_product_cta
id : int(11) unsigned
title : text
subtitle : text
btn_1_text : varchar(100)
btn_1_url : varchar(255)
btn_2_text : varchar(100)
btn_2_url : varchar(255)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile core
cdcore : varchar(50)
crjens : varchar(100)
slug : varchar(255)
sort_order : int(11)
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile core_page_app_promo
id : int(11) unsigned
cdcore : varchar(50)
title : text
subtitle : text
image_url : varchar(255)
button_1_image : varchar(255)
button_url : varchar(255)
button_2_image : varchar(255)
button_2_url : varchar(255)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile core_page_hero
id : int(11) unsigned
cdcore : varchar(50)
title : text
bg_image_url : varchar(255)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile core_page_hero_images
id : int(10) unsigned
cdcore : varchar(50)
page_type : enum('catalog','brand_list')
image_url : text
sort_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile core_page_pesan_sekarang
id : int(11) unsigned
cdcore : varchar(50)
text_image_1 : text
text_image_2 : text
text_section : text
image_1_url : varchar(255)
image_2_url : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile footer_contacts
id : varchar(36)
type : varchar(20)
value : varchar(150)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile footer_content
id : varchar(36)
logo_image : varchar(255)
about_text : text
address_text : text
newsletter_text : text
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile footer_links
id : varchar(36)
label : varchar(100)
url : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile galleries
id : varchar(36)
image : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile gallery_content
id : varchar(36)
title : varchar(100)
subtitle : varchar(255)
updated_at : timestamp

v		dbm_aireprofile hero_sections
id : varchar(36)
title : varchar(255)
subtitle : text
button_text : varchar(100)
button_url : varchar(255)
show_get_more_apps : tinyint(1)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile hero_section_images
id : varchar(36)
hero_section_id : varchar(36)
image_path : varchar(255)
alt_text : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile how_to_order_content
id : varchar(36)
title : varchar(100)
updated_at : timestamp

v		dbm_aireprofile how_to_order_steps
id : varchar(36)
title : varchar(100)
image : varchar(255)
description : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile jenis_products
kdjens : varchar(50)
cdcore : varchar(50)
nmjens : varchar(100)
title : varchar(255)
desc : text
icon_name : varchar(100)
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile menu
id_menu : varchar(36)
name : varchar(255)
url : varchar(255)
id_menu_group : varchar(36)
created_at : timestamp
updated_at : timestamp
sort : int(11)
is_crud : tinyint(1)

v		dbm_aireprofile menu_groups
id_menu_group : varchar(36)
name : varchar(255)
icon : varchar(100)
created_at : timestamp
updated_at : timestamp
sort : int(11)

v		dbm_aireprofile migrations
id : bigint(20) unsigned
version : varchar(255)
class : varchar(255)
group : varchar(255)
namespace : varchar(255)
time : int(11)
batch : int(11) unsigned

v		dbm_aireprofile mitrateknisi_app_promo
id : varchar(36)
promo_text : text
image_path : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile mitrateknisi_cta_section
id : varchar(36)
title : varchar(255)
subtitle : text
image_path : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile mitrateknisi_features
id : varchar(36)
icon_image : varchar(255)
description : text
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile mitrateknisi_hero_section
id : varchar(36)
title : varchar(255)
subtitle : text
bg_image : varchar(255)
btn_1_text : varchar(100)
btn_1_url : varchar(255)
btn_2_text : varchar(100)
btn_2_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile mitrateknisi_statistics
id : varchar(36)
value_text : varchar(50)
label_text : varchar(100)
icon : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile mitrateknisi_steps
id : varchar(36)
step_number : int(11)
description : text
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile navbar_logo
id : varchar(36)
logo_name : varchar(255)
logo_image : varchar(255)
logo_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile navbar_menus
navbar_menu_id : varchar(36)
navbar_id : varchar(36)
label : varchar(255)
url : varchar(255)
has_dropdown : tinyint(1)
dropdown_type : varchar(50)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile navbar_menu_categories
id : varchar(36)
navbar_menu_id : varchar(36)
name : varchar(100)
icon : varchar(100)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile navbar_sub_categories
id : varchar(36)
category_id : varchar(36)
name : varchar(150)
url : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile newsletter_subscribers
id : varchar(36)
email : varchar(150)
subscribed_at : timestamp
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile partners
id : varchar(36)
image : varchar(255)
icon : varchar(255)
title : varchar(100)
description : varchar(255)
button_text : varchar(100)
button_url : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile partner_brands
id : varchar(36)
image : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile partner_brand_content
id : varchar(36)
title : varchar(100)
subtitle : varchar(255)
updated_at : timestamp

v		dbm_aireprofile partner_content
id : varchar(36)
title : varchar(100)
description : varchar(255)
updated_at : timestamp

v		dbm_aireprofile products
kdprod : varchar(50)
cdcore : varchar(50)
kdjens : varchar(50)
kdmerk : varchar(50)
prod_name : varchar(255)
price : decimal(15,2)
slug : varchar(255)
ket_prod : text
srvc_id : varchar(50)
service_json : longtext
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile product_detail
kdprod : varchar(50)
slug : varchar(255)
detail_product : text
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile product_images
id : varchar(100)
kdprod : varchar(50)
image_url : text
created_at : datetime
synced_at : datetime

v		dbm_aireprofile promo_banners
id : varchar(36)
title : varchar(100)
image : varchar(255)
button_url : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile roles
role_id : varchar(36)
name : varchar(255)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile role_menu
id_role_menu : varchar(36)
role_id : varchar(36)
id_menu : varchar(36)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile services_section
id : varchar(36)
name : varchar(100)
url : varchar(255)
image : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile service_areas
id : varchar(36)
service_page_id : varchar(36)
name : varchar(100)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile service_contents
id : varchar(36)
service_id : varchar(36)
hero_title : varchar(255)
hero_image : varchar(255)
area_title : varchar(100)
area_description : text
area_count : int(11)
area_count_label : varchar(100)
other_service_title : varchar(100)
other_service_desc : text
info_title : varchar(100)
created_at : datetime
updated_at : timestamp

v		dbm_aireprofile service_detail
srvc_id : varchar(50)
slug : varchar(255)
prob_detail : text
date_log : datetime
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile service_faqs
id : varchar(36)
service_page_id : varchar(36)
question : varchar(255)
answer : text
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile service_images
id : varchar(100)
srvc_id : varchar(50)
image_url : text
created_at : datetime
synced_at : datetime

v		dbm_aireprofile service_informations
id : varchar(36)
service_page_id : varchar(36)
content : longtext
updated_at : timestamp

v		dbm_aireprofile service_items
srvc_id : varchar(50)
srvprodid : varchar(50)
cdcore : varchar(50)
slug : varchar(255)
srvc_name : varchar(255)
srvc_desc : text
base_price : decimal(15,2)
date_log : datetime
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile service_packages
srv_prodid : varchar(50)
kdjens : varchar(50)
cdcore : varchar(50)
srv_package_name : varchar(255)
srv_icon : varchar(255)
slug : varchar(255)
srv_short_desc : text
bg_image : varchar(255)
subtitle : varchar(255)
order_sort : int(11)
synced_at : datetime
is_active : tinyint(1)

v		dbm_aireprofile service_pages
id : varchar(36)
service_id : varchar(36)
slug : varchar(255)
hero_title : varchar(255)
hero_image : varchar(255)
area_title : varchar(100)
area_description : text
area_count : int(11)
area_count_label : varchar(100)
map_embed_url : text
other_service_title : varchar(100)
other_service_desc : text
info_title : varchar(100)
updated_at : timestamp

v		dbm_aireprofile service_page_others
id : varchar(36)
service_page_id : varchar(36)
service_id : varchar(36)
sort_order : int(11)

v		dbm_aireprofile service_pricelists
id : varchar(36)
service_page_id : varchar(36)
name : varchar(100)
price : decimal(12,0)
price_unit : varchar(100)
is_featured : tinyint(1)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile service_pricelist_features
id : varchar(36)
pricelist_id : varchar(36)
feature : varchar(255)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile service_section_content
id : varchar(36)
title : varchar(100)
subtitle : varchar(255)
updated_at : datetime

v		dbm_aireprofile site_cta
id : int(11) unsigned
page_key : varchar(100)
title : text
subtitle : text
bg_image : varchar(255)
btn_1_text : varchar(150)
btn_1_url : varchar(500)
btn_2_text : varchar(150)
btn_2_url : varchar(500)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		dbm_aireprofile tentang_page_content
id : varchar(36)
hero_title : varchar(255)
hero_subtitle : text
hero_bg_image : varchar(255)
intro_logo : varchar(255)
intro_text : text
partners_title : varchar(255)
partners_subtitle : text
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile tentang_partners
id : varchar(36)
partner_name : varchar(100)
logo_image : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile tentang_statistics
id : varchar(36)
icon_image : varchar(255)
value_text : varchar(50)
label_text : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile testimonials
id : varchar(36)
name : varchar(100)
city : varchar(100)
review : text
rating : tinyint(1)
photo : varchar(255)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile testimonial_content
id : varchar(36)
title : varchar(100)
subtitle : varchar(255)
updated_at : timestamp

v		dbm_aireprofile user
user_id : int(10) unsigned
full_name : varchar(100)
email : varchar(100)
phone_number : varchar(20)
password_hash : varchar(255)
role : varchar(36)
status : varchar(20)
last_login_at : datetime
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile vendor_benefits
id : varchar(36)
title : varchar(255)
description : text
illustration_image : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile vendor_benefit_items
id : varchar(36)
benefit_id : varchar(36)
title : varchar(255)
description : text
icon_name : varchar(100)
icon_path : varchar(255)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile vendor_cta
id : varchar(36)
title : varchar(255)
subtitle : text
btn_text : varchar(100)
btn_url : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile vendor_hero
id : varchar(36)
title : text
subtitle : text
bg_image : varchar(255)
btn_text_1 : varchar(100)
btn_url_1 : varchar(255)
btn_text_2 : varchar(100)
btn_url_2 : varchar(255)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile vendor_statistics
id : varchar(36)
value : varchar(100)
label : varchar(255)
icon_name : varchar(100)
icon_path : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		dbm_aireprofile why_choose_us_content
id : varchar(36)
image : varchar(255)
title : varchar(100)
subtitle : varchar(255)
updated_at : timestamp

v		dbm_aireprofile why_choose_us_items
id : varchar(36)
icon : varchar(100)
title : varchar(100)
description : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update