What data is loaded
Every table behind the site, its size, and the screen that reads it.
30
Tables in use
648M
Rows (estimated)
37.9 GB
On disk
Row counts are InnoDB estimates, not exact counts — the largest table alone holds a
quarter of a billion rows and counting it on demand would be pointless. Exact figures
were verified against the source files when the data was loaded.
| Table | What it holds | Used by | Rows | Size |
|---|---|---|---|---|
| catalog | One row per vehicle catalog | Vehicle Input | 1,429 | 144.0 KB |
| vehicle_identification | VIN / frame prefix to catalog | Vehicle Model Select | 548,749 | 64.6 MB |
| vehicle | One row per vehicle built | Vehicle Information | 258,936,104 | 18.6 GB |
| frame_serial | Month to starting frame serial | Vehicle Information | 298,221 | 24.1 MB |
| frame_applicability | Frame ranges a catalog covers | Catalog detail | 210,238 | 17.5 MB |
| catalog_section | Which part groups are in which section | Illustrated Index | 4,123,900 | 198.7 MB |
| section_name | Section names by language | Illustrated Index | 2,534 | 176.0 KB |
| section_figure | Figures belonging to a section | Parts Index | 570,432 | 46.6 MB |
| section_primary_figure | Cover figure per section | Illustrated Index | 210,859 | 10.5 MB |
| figure_catalog | Which catalogs show a figure | Figure | 537,285 | 24.5 MB |
| illustration | One illustration per figure | Figure | 494,944 | 40.6 MB |
| illustration_hotspot | Clickable regions linking figure to parts | Figure | 12,410,913 | 739.0 MB |
| illustration_note | Readable annotations per figure | Illustration Notes | 322,759 | 28.6 MB |
| figure_thumbnail | 157x113 PNG thumbnail per figure | Illustrated Index | 195,254 | 17.5 MB |
| part | The parts grid line items | Part Number Translation | 27,771,884 | 3.0 GB |
| part_name | Part name per PNC, per language | Part Number List | 494,426 | 58.1 MB |
| part_number_index | Part number to group and section | Part Number Application | 10,677,384 | 680.0 MB |
| part_applicability | Applicability tokens per part | Part detail | 75,159,919 | 2.9 GB |
| applicability_code | Per-catalog code legend | Characteristics | 90,667 | 6.5 MB |
| applicability_attr | Per-catalog attribute labels | Characteristics | 30,024 | 2.5 MB |
| abbreviation | Dataset-wide dictionary | Abbreviation Search | 25,160 | 2.5 MB |
| part_remark | Remark text per part | Part detail | 20,278,163 | 1.8 GB |
| part_color | What a part number suffix means | Part detail | 6,321,246 | 357.9 MB |
| part_price | List price in yen (JP only) | List Price | 1,997,035 | 100.6 MB |
| part_supersession | Old part to new part | Substitution History | 1,789,087 | 119.7 MB |
| part_substitute | Interchangeable numbers | Substitution History | 3,153,742 | 243.8 MB |
| catalog_group_member | Catalogue group to model variant | Group List | 110,681,372 | 5.0 GB |
| siyopt | Spec and value codes (surrogate ids) | Spec / Option | 110,188,305 | 3.8 GB |
| siyopt_file | Region file to content variant | Spec / Option | 1,297 | 112.0 KB |
| jpio_accessory | Port-installed accessories | J-PIO List | 33,728 | 11.5 MB |
Every table in the database is read by at least one screen.
8.0.46-0ubuntu0.24.04.3 · database toyota_epc · utf8mb4