Difference between revisions of "Nookipedia:Project Database/List of tables"
From Nookipedia, the Animal Crossing wiki
PanchamBro (talk | contribs) (adding some additional cargo_tables to the list) |
SuperHamster (talk | contribs) m (Text replacement - ""collapsible collapsed"" to ""mw-collapsible mw-collapsed"") |
||
Line 28: | Line 28: | ||
| [[Amiibo]] cards | | [[Amiibo]] cards | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 7 fields}} | ! {{Colorshow|4c4c4c|Open to view 7 fields}} | ||
Line 48: | Line 48: | ||
| {{CF|short}} art | | {{CF|short}} art | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 11 fields}} | ! {{Colorshow|4c4c4c|Open to view 11 fields}} | ||
Line 72: | Line 72: | ||
| {{CF|short}} bugs | | {{CF|short}} bugs | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 57 fields}} | ! {{Colorshow|4c4c4c|Open to view 57 fields}} | ||
Line 142: | Line 142: | ||
| {{CF|short}} fish | | {{CF|short}} fish | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 56 fields}} | ! {{Colorshow|4c4c4c|Open to view 56 fields}} | ||
Line 211: | Line 211: | ||
| {{CF|short}} villager homes (some parts used in villager endpoint) | | {{CF|short}} villager homes (some parts used in villager endpoint) | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 13 fields}} | ! {{Colorshow|4c4c4c|Open to view 13 fields}} | ||
Line 237: | Line 237: | ||
| {{CF|short}} villagers | | {{CF|short}} villagers | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 7 fields}} | ! {{Colorshow|4c4c4c|Open to view 7 fields}} | ||
Line 257: | Line 257: | ||
| [[e-Reader card]]s | | [[e-Reader card]]s | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 10 fields}} | ! {{Colorshow|4c4c4c|Open to view 10 fields}} | ||
Line 281: | Line 281: | ||
| {{NH|short}} art | | {{NH|short}} art | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 27 fields}} | ! {{Colorshow|4c4c4c|Open to view 27 fields}} | ||
Line 321: | Line 321: | ||
| {{NH|short}} bugs | | {{NH|short}} bugs | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 41 fields}} | ! {{Colorshow|4c4c4c|Open to view 41 fields}} | ||
Line 375: | Line 375: | ||
| {{NH|short}} clothing | | {{NH|short}} clothing | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 26 fields}} | ! {{Colorshow|4c4c4c|Open to view 26 fields}} | ||
Line 414: | Line 414: | ||
| {{NH|short}} clothing variations | | {{NH|short}} clothing variations | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 6 fields}} | ! {{Colorshow|4c4c4c|Open to view 6 fields}} | ||
Line 433: | Line 433: | ||
| {{NH|short}} fish | | {{NH|short}} fish | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 48 fields}} | ! {{Colorshow|4c4c4c|Open to view 48 fields}} | ||
Line 494: | Line 494: | ||
| {{NH|short}} furniture | | {{NH|short}} furniture | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 41 fields}} | ! {{Colorshow|4c4c4c|Open to view 41 fields}} | ||
Line 548: | Line 548: | ||
| {{NH|short}} furniture variations | | {{NH|short}} furniture variations | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 7 fields}} | ! {{Colorshow|4c4c4c|Open to view 7 fields}} | ||
Line 568: | Line 568: | ||
| {{NH|short}} villager homes (some parts used in villager endpoint) | | {{NH|short}} villager homes (some parts used in villager endpoint) | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 15 fields}} | ! {{Colorshow|4c4c4c|Open to view 15 fields}} | ||
Line 596: | Line 596: | ||
| {{NH|short}} wallpaper and flooring | | {{NH|short}} wallpaper and flooring | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 25 fields}} | ! {{Colorshow|4c4c4c|Open to view 25 fields}} | ||
Line 634: | Line 634: | ||
| {{NH|short}} furniture translations | | {{NH|short}} furniture translations | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 15 fields}} | ! {{Colorshow|4c4c4c|Open to view 15 fields}} | ||
Line 662: | Line 662: | ||
| {{NH|short}} KK records | | {{NH|short}} KK records | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 23 fields}} | ! {{Colorshow|4c4c4c|Open to view 23 fields}} | ||
Line 698: | Line 698: | ||
| {{NH|short}} villager photos and posters | | {{NH|short}} villager photos and posters | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 25 fields}} | ! {{Colorshow|4c4c4c|Open to view 25 fields}} | ||
Line 736: | Line 736: | ||
| {{NH|short}} villager photo customization | | {{NH|short}} villager photo customization | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 6 fields}} | ! {{Colorshow|4c4c4c|Open to view 6 fields}} | ||
Line 755: | Line 755: | ||
| {{NH|short}} DIY recipes | | {{NH|short}} DIY recipes | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 30 fields}} | ! {{Colorshow|4c4c4c|Open to view 30 fields}} | ||
Line 798: | Line 798: | ||
| {{NH|short}} sea creatures | | {{NH|short}} sea creatures | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 41 fields}} | ! {{Colorshow|4c4c4c|Open to view 41 fields}} | ||
Line 852: | Line 852: | ||
| {{NH|short}} handheld items | | {{NH|short}} handheld items | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 24 fields}} | ! {{Colorshow|4c4c4c|Open to view 24 fields}} | ||
Line 889: | Line 889: | ||
| {{NH|short}} handheld item variations | | {{NH|short}} handheld item variations | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 6 fields}} | ! {{Colorshow|4c4c4c|Open to view 6 fields}} | ||
Line 908: | Line 908: | ||
| {{NH|short}} villagers (using in villager endpoint) | | {{NH|short}} villagers (using in villager endpoint) | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 25 fields}} | ! {{Colorshow|4c4c4c|Open to view 25 fields}} | ||
Line 946: | Line 946: | ||
| {{NL|short}} art | | {{NL|short}} art | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 19 fields}} | ! {{Colorshow|4c4c4c|Open to view 19 fields}} | ||
Line 978: | Line 978: | ||
| {{NL|short}} bugs | | {{NL|short}} bugs | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 64 fields}} | ! {{Colorshow|4c4c4c|Open to view 64 fields}} | ||
Line 1,055: | Line 1,055: | ||
| {{NL|short}} fish | | {{NL|short}} fish | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 64 fields}} | ! {{Colorshow|4c4c4c|Open to view 64 fields}} | ||
Line 1,132: | Line 1,132: | ||
| {{NL|short}} villager preferences | | {{NL|short}} villager preferences | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 14 fields}} | ! {{Colorshow|4c4c4c|Open to view 14 fields}} | ||
Line 1,159: | Line 1,159: | ||
| {{NL|short}} sea creatures | | {{NL|short}} sea creatures | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 65 fields}} | ! {{Colorshow|4c4c4c|Open to view 65 fields}} | ||
Line 1,237: | Line 1,237: | ||
| {{PC|short}} villager info and rewards | | {{PC|short}} villager info and rewards | ||
| Columns need renaming to match standard | | Columns need renaming to match standard | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 18 fields}} | ! {{Colorshow|4c4c4c|Open to view 18 fields}} | ||
Line 1,268: | Line 1,268: | ||
| {{PG}} fossils | | {{PG}} fossils | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 8 fields}} | ! {{Colorshow|4c4c4c|Open to view 8 fields}} | ||
Line 1,289: | Line 1,289: | ||
| KK Song image, audio and {{SER}} appearances | | KK Song image, audio and {{SER}} appearances | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 18 fields}} | ! {{Colorshow|4c4c4c|Open to view 18 fields}} | ||
Line 1,320: | Line 1,320: | ||
| Special character info and {{SER}} appearances | | Special character info and {{SER}} appearances | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 25 fields}} | ! {{Colorshow|4c4c4c|Open to view 25 fields}} | ||
Line 1,358: | Line 1,358: | ||
| {{SER}} villagers | | {{SER}} villagers | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 37 fields}} | ! {{Colorshow|4c4c4c|Open to view 37 fields}} | ||
Line 1,408: | Line 1,408: | ||
| {{WW|short}} villager picture, quote and preferences | | {{WW|short}} villager picture, quote and preferences | ||
| | | | ||
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed" | + | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" |
|- | |- | ||
! {{Colorshow|4c4c4c|Open to view 6 fields}} | ! {{Colorshow|4c4c4c|Open to view 6 fields}} |
Revision as of 23:06, March 11, 2021
- This section can be edited at Project Database/List of tables.
The following table lists tables, descriptions, and their status. Note that this table is manually updated. Last update: 11:48, February 6, 2021 (EST)
Production: This table's structure is finalized, and has been fully populated with data. It can reliably be used for querying on-wiki or externally. | |
Beta: This table is approaching completion. Structure is near finalized, and/or nearly all data has been populated. | |
Dev: This table is brand new. Columns may be added, removed, or changed, and/or is still missing a lot of data. |
- A full up-to-date list of tables (and their associated declare/attachment templates) is available at Special:CargoTables.
Status | API | Table Name | Description | Structure | Notes | ||
---|---|---|---|---|---|---|---|
amiibo_card | Amiibo cards |
|
- | ||||
cf_art | City Folk art |
|
Missing art textures | ||||
cf_bug | City Folk bugs |
|
- | ||||
cf_fish | City Folk fish |
|
- | ||||
cf_house | City Folk villager homes (some parts used in villager endpoint) |
|
- | ||||
cf_villager | City Folk villagers |
|
- | ||||
e_card | e-Reader cards |
|
- | ||||
nh_art | New Horizons art |
|
- | ||||
nh_bug | New Horizons bugs |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_clothing | New Horizons clothing |
|
- | ||||
nh_clothing_variation | New Horizons clothing variations |
|
- | ||||
nh_fish | New Horizons fish |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_furniture | New Horizons furniture |
|
- | ||||
nh_furniture_variation | New Horizons furniture variations |
|
- | ||||
nh_house | New Horizons villager homes (some parts used in villager endpoint) |
|
- | ||||
nh_interior | New Horizons wallpaper and flooring |
|
- | ||||
nh_language_name | New Horizons furniture translations |
|
- | ||||
nh_music | New Horizons KK records |
|
- | ||||
nh_photo | New Horizons villager photos and posters |
|
- | ||||
nh_photo_variation | New Horizons villager photo customization |
|
- | ||||
nh_recipe | New Horizons DIY recipes |
|
- | ||||
nh_sea_creature | New Horizons sea creatures |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_tool | New Horizons handheld items |
|
- | ||||
nh_tool_variation | New Horizons handheld item variations |
|
- | ||||
nh_villager | New Horizons villagers (using in villager endpoint) |
|
- | ||||
nl_art | New Leaf art |
|
- | ||||
nl_bug | New Leaf bugs |
|
- | ||||
nl_fish | New Leaf fish |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nl_villager | New Leaf villager preferences |
|
- | ||||
nl_sea_creature | New Leaf sea creatures |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
pc_villager | Pocket Camp villager info and rewards | Columns need renaming to match standard
|
- | ||||
pg_fossil | Animal Crossing fossils |
|
- | ||||
song | KK Song image, audio and Animal Crossing series appearances |
|
- | ||||
special_character | Special character info and Animal Crossing series appearances |
|
- | ||||
villager | Animal Crossing series villagers |
|
- | ||||
ww_villager | Wild World villager picture, quote and preferences |
|
- |