Table Overview
Total Rows
18764
Columns
39
Created
2025-12-26
Collation
utf8mb4_0900_ai_ci
Download Table Data
Preparing download... This may take a while for large tables.
Note: CSV and Excel downloads include all table data. SQL Schema includes table structure only. SQL Dump includes both schema and all data. Large tables may take several minutes to download.
Schema Information
| Column Name | Data Type | Nullable | Default | Key | Extra |
|---|---|---|---|---|---|
| id | int | NOT NULL | NULL | PRIMARY | auto_increment |
| category_level1 | varchar(255) | NULL | NULL | INDEX | - |
| category_level2 | varchar(255) | NULL | NULL | INDEX | - |
| category_level3 | varchar(255) | NULL | NULL | INDEX | - |
| make | varchar(16) | NULL | NULL | - | - |
| mpn | varchar(30) | NULL | NULL | INDEX | - |
| product_category | varchar(19) | NULL | NULL | - | - |
| base_part_no | varchar(22) | NULL | NULL | - | - |
| replacement_part | varchar(255) | NULL | NULL | - | - |
| lifecycle_status | varchar(16) | NULL | NULL | - | - |
| grade | varchar(20) | NULL | NULL | - | - |
| aec_qualified | varchar(18) | NULL | NULL | - | - |
| packing_qty | int | NULL | NULL | - | - |
| packing_carrier | varchar(255) | NULL | NULL | - | - |
| environmental_compliance | varchar(255) | NULL | NULL | - | - |
| termination_style | varchar(23) | NULL | NULL | - | - |
| no_of_terminations | int | NULL | NULL | - | - |
| package | varchar(255) | NULL | NULL | - | - |
| operating_temperature_range | int | NULL | NULL | - | - |
| storage_temperature_range | varchar(255) | NULL | NULL | - | - |
| type | varchar(33) | NULL | NULL | - | - |
| construction | varchar(30) | NULL | NULL | - | - |
| type_of_magnetic_shield | varchar(22) | NULL | NULL | - | - |
| size_in_inch | decimal(20,2) | NULL | NULL | - | - |
| length_mm | decimal(20,2) | NULL | NULL | - | - |
| width_mm | decimal(20,2) | NULL | NULL | - | - |
| thickness_mm | decimal(20,2) | NULL | NULL | - | - |
| inductance_h_uh | decimal(20,2) | NULL | NULL | - | - |
| rated_current_ma_a | decimal(20,2) | NULL | NULL | - | - |
| dc_resistance_max_m_ohm | decimal(20,2) | NULL | NULL | - | - |
| self_resonant_frequency_hz | decimal(20,2) | NULL | NULL | - | - |
| q | varchar(255) | NULL | NULL | - | - |
| isat_a | varchar(255) | NULL | NULL | - | - |
| irms_a | varchar(255) | NULL | NULL | - | - |
| tolerance_min_percent | decimal(20,2) | NULL | NULL | - | - |
| tolerance_max_percent | decimal(20,2) | NULL | NULL | - | - |
| additional_info | json | NULL | NULL | - | - |
| created_at | timestamp | NULL | CURRENT_TIMESTAMP | - | DEFAULT_GENERATED |
| source_table | varchar(50) | NULL | NULL | - | - |
Indexes
| Index Name | Column | Type | Unique |
|---|---|---|---|
| PRIMARY | id | BTREE | YES |
| unique_mpn_manufacturer | mpn | BTREE | YES |
| unique_mpn_manufacturer | make | BTREE | YES |
| category_level1 | category_level1 | BTREE | NO |
| category_level2 | category_level2 | BTREE | NO |
| category_level3 | category_level3 | BTREE | NO |
Sample Data (First 10 Rows)
| id | category_level1 | category_level2 | category_level3 | make | mpn | product_category | base_part_no | replacement_part | lifecycle_status | grade | aec_qualified | packing_qty | packing_carrier | environmental_compliance | termination_style | no_of_terminations | package | operating_temperature_range | storage_temperature_range | type | construction | type_of_magnetic_shield | size_in_inch | length_mm | width_mm | thickness_mm | inductance_h_uh | rated_current_ma_a | dc_resistance_max_m_ohm | self_resonant_frequency_hz | q | isat_a | irms_a | tolerance_min_percent | tolerance_max_percent | additional_info | created_at | source_table |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N3B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.04 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 2 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N4B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.07 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 3 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N5B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.07 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 4 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N6B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.07 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 5 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N7B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.08 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 6 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N8B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.11 | 20000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 7 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV0N9B02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.00 | 500.00 | 0.11 | 17000000000.00 | NULL | NULL | NULL | -0.10 | 0.10 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 8 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV10NH02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.01 | 70.00 | 2.30 | 6000000000.00 | NULL | NULL | NULL | -3.00 | 3.00 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 9 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV11NH02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.01 | 70.00 | 2.80 | 5000000000.00 | NULL | NULL | NULL | -3.00 | 3.00 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
| 10 | passive | inductorsandchokeandcoil | inductors | Murata | LQP01HV12NH02L | inductors | LQP01HV_02 | NULL | Active | Industrial | NULL | 2500 | NULL | NULL | Surface Mount | 2 | NULL | 105 | NULL | High Frequency Circuits | Film | Non-Shielded | 8004.00 | 0.25 | 0.13 | 0.21 | 0.01 | 70.00 | 2.80 | 5000000000.00 | NULL | NULL | NULL | -3.00 | 3.00 | {} | 2025-12-26 10:23:29 | passive_inductorsandchokeandcoil_inductors |
Data Types Summary
4
INT
23
VARCHAR
10
DECIMAL
1
JSON
1
TIMESTAMP