Recent
Favorites
  • There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: landed_cost_calculator
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
landed_cost_calculator.api_logs
landed_cost_calculator.calculations
landed_cost_calculator.calculation_items
landed_cost_calculator.exchange_rates
landed_cost_calculator.hs_codes
landed_cost_calculator.hs_code_categories
landed_cost_calculator.shipping_costs
landed_cost_calculator.tax_settings
landed_cost_calculator.v_hs_codes_with_category
Number of tables: 9
v landed_cost_calculator api_logs
* id : int(11)
* method : varchar(10)
* endpoint : varchar(255)
* request_data : longtext
* response_data : longtext
* response_code : int(11)
* ip_address : varchar(45)
* user_agent : text
* created_at : timestamp
v landed_cost_calculator calculations
* id : int(11)
* no_pr : varchar(255)
* calculation_name : varchar(200)
* user_session : varchar(255)
* shipping_term : varchar(10)
* additional_percentage : decimal(5,2)
* total_shipping_normal : decimal(15,2)
* total_shipping_forme : decimal(15,2)
* total_customs_duty_normal : decimal(15,2)
* total_customs_duty_forme : decimal(15,2)
* total_ppn_normal : decimal(15,2)
* total_ppn_forme : decimal(15,2)
* total_pph_normal : decimal(15,2)
* total_pph_forme : decimal(15,2)
* total_landed_cost_normal : decimal(15,2)
* total_landed_cost_forme : decimal(15,2)
* total_landedcost_plus_normal : decimal(15,2)
* total_landedcost_plus_forme : decimal(15,2)
* total_savings : decimal(15,2)
* savings_percentage : decimal(5,2)
* ppn_rate : decimal(5,2)
* pph_rate : decimal(5,2)
* form_e_discount : decimal(5,2)
* exw_charge_value : decimal(15,4)
* exw_charge_currency : varchar(10)
* ocean_freight_value : decimal(15,4)
* ocean_freight_currency : varchar(10)
* clearance_value : decimal(15,4)
* clearance_currency : varchar(10)
* insurance_value : decimal(15,4)
* insurance_currency : varchar(10)
* handling_value : decimal(15,4)
* handling_currency : varchar(10)
* usd_to_idr : decimal(15,4)
* cnh_to_idr : decimal(15,4)
* eur_to_idr : decimal(15,4)
* jpy_to_idr : decimal(15,4)
* is_active : tinyint(1)
* notes : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator calculation_items
* id : int(11)
* no_pr : varchar(255)
* calculation_id : int(11)
* item_code : varchar(50)
* item_name : varchar(200)
* hs_code : varchar(20)
* description_en : text
* description_id : text
* category_id : int(11)
* quantity : int(11)
* price_phase : varchar(10)
* unit_price_value : decimal(15,4)
* unit_price_currency : varchar(10)
* weight : decimal(10,3)
* customs_duty : decimal(5,2)
* total_value_idr : decimal(15,2)
* exw_charge : decimal(15,2)
* ocean_freight : decimal(15,2)
* clearance : decimal(15,2)
* insurance : decimal(15,2)
* handling : decimal(15,2)
* lartas : decimal(12,5)
* bm_normal : decimal(15,2)
* bm_forme : decimal(15,2)
* ppn_pph_normal : decimal(15,2)
* additional_percentage : decimal(5,2)
* landed_price_normal : decimal(15,2)
* landed_price_normal_formula : decimal(12,5)
* total_landed_price_normal : decimal(15,2)
* ppn_pph_forme : decimal(15,2)
* landed_price_forme : decimal(15,2)
* landed_price_forme_formula : decimal(12,5)
* total_landed_price_forme : decimal(15,2)
* notes : varchar(255)
* created_at : timestamp
v landed_cost_calculator exchange_rates
* id : int(11)
* currency_code : varchar(3)
* rate_to_idr : decimal(15,2)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator hs_codes
* id : int(11)
* hs_code : varchar(20)
* description_en : text
* description_id : text
* category_id : int(11)
* duty_rate : decimal(5,2)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator hs_code_categories
* id : int(11)
* category_name : varchar(100)
* category_slug : varchar(100)
* description : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator shipping_costs
* id : int(11)
* cost_type : varchar(50)
* cost_value : decimal(15,2)
* currency : varchar(10)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator tax_settings
* id : int(11)
* setting_name : varchar(50)
* setting_value : decimal(5,2)
* description : text
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v landed_cost_calculator v_hs_codes_with_category
* id : int(11)
* hs_code : varchar(20)
* description_en : text
* description_id : text
* duty_rate : decimal(5,2)
* category_name : varchar(100)
* category_slug : varchar(100)
* is_active : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship