api_logs
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| method | varchar(10) | No | ||||
| endpoint | varchar(255) | No | ||||
| request_data | longtext | Yes | NULL | |||
| response_data | longtext | Yes | NULL | |||
| response_code | int(11) | Yes | NULL | |||
| ip_address | varchar(45) | Yes | NULL | |||
| user_agent | text | Yes | NULL | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| idx_api_logs_endpoint | BTREE | No | No | endpoint (191) | 0 | A | No | |
| idx_api_logs_created | BTREE | No | No | created_at | 0 | A | No |
calculations
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_pr | varchar(255) | No | ||||
| calculation_name | varchar(200) | No | ||||
| user_session | varchar(255) | Yes | NULL | |||
| shipping_term | varchar(10) | No | ||||
| additional_percentage | decimal(5,2) | No | 0.00 | |||
| total_shipping_normal | decimal(15,2) | No | 0.00 | |||
| total_shipping_forme | decimal(15,2) | No | 0.00 | |||
| total_customs_duty_normal | decimal(15,2) | No | 0.00 | |||
| total_customs_duty_forme | decimal(15,2) | No | 0.00 | |||
| total_ppn_normal | decimal(15,2) | No | 0.00 | |||
| total_ppn_forme | decimal(15,2) | No | 0.00 | |||
| total_pph_normal | decimal(15,2) | No | 0.00 | |||
| total_pph_forme | decimal(15,2) | No | 0.00 | |||
| total_landed_cost_normal | decimal(15,2) | No | 0.00 | |||
| total_landed_cost_forme | decimal(15,2) | No | 0.00 | |||
| total_landedcost_plus_normal | decimal(15,2) | No | ||||
| total_landedcost_plus_forme | decimal(15,2) | No | ||||
| total_savings | decimal(15,2) | No | 0.00 | |||
| savings_percentage | decimal(5,2) | No | 0.00 | |||
| ppn_rate | decimal(5,2) | No | 11.00 | |||
| pph_rate | decimal(5,2) | No | 2.50 | |||
| form_e_discount | decimal(5,2) | No | 50.00 | |||
| exw_charge_value | decimal(15,4) | No | 0.0000 | |||
| exw_charge_currency | varchar(10) | No | IDR | |||
| ocean_freight_value | decimal(15,4) | No | 0.0000 | |||
| ocean_freight_currency | varchar(10) | No | USD | |||
| clearance_value | decimal(15,4) | No | 0.0000 | |||
| clearance_currency | varchar(10) | No | IDR | |||
| insurance_value | decimal(15,4) | No | 0.0000 | |||
| insurance_currency | varchar(10) | No | % | |||
| handling_value | decimal(15,4) | No | 0.0000 | |||
| handling_currency | varchar(10) | No | IDR | |||
| usd_to_idr | decimal(15,4) | No | 15000.0000 | |||
| cnh_to_idr | decimal(15,4) | No | 2200.0000 | |||
| eur_to_idr | decimal(15,4) | No | 17000.0000 | |||
| jpy_to_idr | decimal(15,4) | No | 110.0000 | |||
| is_active | tinyint(1) | Yes | 1 | |||
| notes | varchar(255) | No | ||||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 100 | A | No | |
| idx_user_session | BTREE | No | No | user_session (191) | 33 | A | Yes | |
| idx_created_at | BTREE | No | No | created_at | 100 | A | No |
calculation_items
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_pr | varchar(255) | No | ||||
| calculation_id | int(11) | No | calculations -> id | |||
| item_code | varchar(50) | No | ||||
| item_name | varchar(200) | No | ||||
| hs_code | varchar(20) | Yes | NULL | |||
| description_en | text | Yes | NULL | |||
| description_id | text | Yes | NULL | |||
| category_id | int(11) | Yes | NULL | |||
| quantity | int(11) | No | 1 | |||
| price_phase | varchar(10) | No | ||||
| unit_price_value | decimal(15,4) | No | 0.0000 | |||
| unit_price_currency | varchar(10) | No | USD | |||
| weight | decimal(10,3) | Yes | 0.000 | |||
| customs_duty | decimal(5,2) | Yes | 0.00 | |||
| total_value_idr | decimal(15,2) | No | 0.00 | |||
| exw_charge | decimal(15,2) | No | 0.00 | |||
| ocean_freight | decimal(15,2) | No | 0.00 | |||
| clearance | decimal(15,2) | No | 0.00 | |||
| insurance | decimal(15,2) | No | 0.00 | |||
| handling | decimal(15,2) | No | 0.00 | |||
| lartas | decimal(12,5) | No | ||||
| bm_normal | decimal(15,2) | No | 0.00 | |||
| bm_forme | decimal(15,2) | No | 0.00 | |||
| ppn_pph_normal | decimal(15,2) | No | 0.00 | |||
| additional_percentage | decimal(5,2) | No | ||||
| landed_price_normal | decimal(15,2) | No | 0.00 | |||
| landed_price_normal_formula | decimal(12,5) | No | ||||
| total_landed_price_normal | decimal(15,2) | No | 0.00 | |||
| ppn_pph_forme | decimal(15,2) | No | 0.00 | |||
| landed_price_forme | decimal(15,2) | No | 0.00 | |||
| landed_price_forme_formula | decimal(12,5) | No | ||||
| total_landed_price_forme | decimal(15,2) | No | 0.00 | |||
| notes | varchar(255) | No | ||||
| created_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 34 | A | No | |
| idx_calculation | BTREE | No | No | calculation_id | 34 | A | No | |
| idx_hs_code | BTREE | No | No | hs_code | 34 | A | Yes |
exchange_rates
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| currency_code | varchar(3) | No | ||||
| rate_to_idr | decimal(15,2) | No | ||||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No | |
| currency_code | BTREE | Yes | No | currency_code | 4 | A | No |
hs_codes
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| hs_code | varchar(20) | No | ||||
| description_en | text | No | ||||
| description_id | text | Yes | NULL | |||
| category_id | int(11) | No | hs_code_categories -> id | |||
| duty_rate | decimal(5,2) | No | ||||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 34 | A | No | |
| hs_code | BTREE | Yes | No | hs_code | 34 | A | No | |
| fk_category | BTREE | No | No | category_id | 17 | A | No | |
| idx_hs_codes_category | BTREE | No | No | category_id | 17 | A | No |
hs_code_categories
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category_name | varchar(100) | No | ||||
| category_slug | varchar(100) | No | ||||
| description | text | Yes | NULL | |||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No | |
| category_slug | BTREE | Yes | No | category_slug | 7 | A | No |
shipping_costs
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| cost_type | varchar(50) | No | ||||
| cost_value | decimal(15,2) | No | ||||
| currency | varchar(10) | No | ||||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No | |
| cost_type | BTREE | Yes | No | cost_type | 5 | A | No |
tax_settings
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| setting_name | varchar(50) | No | ||||
| setting_value | decimal(5,2) | No | ||||
| description | text | Yes | NULL | |||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| updated_at | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No | |
| setting_name | BTREE | Yes | No | setting_name | 3 | A | No |
v_hs_codes_with_category
Table comments: VIEW| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id | int(11) | No | 0 | |||
| hs_code | varchar(20) | No | ||||
| description_en | text | No | ||||
| description_id | text | Yes | NULL | |||
| duty_rate | decimal(5,2) | No | ||||
| category_name | varchar(100) | No | ||||
| category_slug | varchar(100) | No | ||||
| is_active | tinyint(1) | Yes | 1 | |||
| created_at | timestamp | No | 0000-00-00 00:00:00 | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |