Difference between revisions of "Nookipedia:Project Database/List of tables"
From Nookipedia, the Animal Crossing wiki
m |
m |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
:''This section can be edited at [[Nookipedia:Project Database/List of tables|Project Database/List of tables]].'' | :''This section can be edited at [[Nookipedia:Project Database/List of tables|Project Database/List of tables]].'' | ||
− | The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' | + | The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 02:53, April 24, 2021 (EST) <!-- Simply use {{subst:LOCALTIME}}, {{subst:LOCALMONTHNAME}} {{subst:LOCALDAY}}, {{subst:LOCALYEAR}} to update the time. --> |
{| | {| | ||
Line 431: | Line 431: | ||
|} | |} | ||
| Missing rarity data (common name for rarity percentages TBD). | | Missing rarity data (common name for rarity percentages TBD). | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|Yes}} | ||
+ | | '''[[Special:CargoTables/nh_calendar|nh_calendar]]''' | ||
+ | | {{NH|short}} event and birthday notices. | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 4 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>date</code> - Date | ||
+ | *<code>event</code> - String | ||
+ | *<code>type</code> - String | ||
+ | *<code>link</code> - Page | ||
+ | |} | ||
+ | | - | ||
|- | |- | ||
| {{Table cell|Yellow}} | | {{Table cell|Yellow}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_clothing|nh_clothing]]''' | | '''[[Special:CargoTables/nh_clothing|nh_clothing]]''' | ||
| {{NH|short}} clothing | | {{NH|short}} clothing | ||
Line 503: | Line 520: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_clothing_variation|nh_clothing_variation]]''' | | '''[[Special:CargoTables/nh_clothing_variation|nh_clothing_variation]]''' | ||
| {{NH|short}} clothing variations | | {{NH|short}} clothing variations | ||
Line 616: | Line 633: | ||
| {{Table cell|No}} | | {{Table cell|No}} | ||
| '''[[Special:CargoTables/nh_fossil|nh_fossil]]''' | | '''[[Special:CargoTables/nh_fossil|nh_fossil]]''' | ||
− | | {{NH|short}} | + | | {{NH|short}} fossils |
| | | | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 11 fields}} |
|- | |- | ||
| | | | ||
*<code>name</code> - String | *<code>name</code> - String | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>fossil_group</code> - String | *<code>fossil_group</code> - String | ||
*<code>interactable</code> - Boolean | *<code>interactable</code> - Boolean | ||
Line 653: | Line 671: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_furniture|nh_furniture]]''' | | '''[[Special:CargoTables/nh_furniture|nh_furniture]]''' | ||
| {{NH|short}} furniture | | {{NH|short}} furniture | ||
Line 716: | Line 734: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_furniture_variation|nh_furniture_variation]]''' | | '''[[Special:CargoTables/nh_furniture_variation|nh_furniture_variation]]''' | ||
| {{NH|short}} furniture variations | | {{NH|short}} furniture variations | ||
Line 770: | Line 788: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_interior|nh_interior]]''' | | '''[[Special:CargoTables/nh_interior|nh_interior]]''' | ||
| {{NH|short}} wallpaper and flooring | | {{NH|short}} wallpaper and flooring | ||
Line 776: | Line 794: | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 32 fields}} |
|- | |- | ||
| | | | ||
Line 789: | Line 807: | ||
*<code>theme1</code> - String | *<code>theme1</code> - String | ||
*<code>theme2</code> - String | *<code>theme2</code> - String | ||
+ | *<code>hha_category</code> - String | ||
+ | *<code>tag</code> - String | ||
+ | *<code>hha_base</code> - Integer | ||
*<code>buy1_price</code> - Integer | *<code>buy1_price</code> - Integer | ||
*<code>buy1_currency</code> - String | *<code>buy1_currency</code> - String | ||
Line 812: | Line 833: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_item|nh_item]]''' | | '''[[Special:CargoTables/nh_item|nh_item]]''' | ||
| {{NH|short}} other items | | {{NH|short}} other items | ||
Line 917: | Line 938: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_photo|nh_photo]]''' | | '''[[Special:CargoTables/nh_photo|nh_photo]]''' | ||
| {{NH|short}} villager photos and posters | | {{NH|short}} villager photos and posters | ||
Line 923: | Line 944: | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 27 fields}} |
|- | |- | ||
| | | | ||
Line 930: | Line 951: | ||
*<code>name_sort</code> - String | *<code>name_sort</code> - String | ||
*<code>category</code> - String | *<code>category</code> - String | ||
+ | *<code>hha_base</code> - Integer | ||
*<code>buy1_price</code> - Integer | *<code>buy1_price</code> - Integer | ||
*<code>buy1_currency</code> - String | *<code>buy1_currency</code> - String | ||
Line 956: | Line 978: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]''' | | '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]''' | ||
| {{NH|short}} villager photo customization | | {{NH|short}} villager photo customization | ||
Line 1,107: | Line 1,129: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_tool|nh_tool]]''' | | '''[[Special:CargoTables/nh_tool|nh_tool]]''' | ||
| {{NH|short}} handheld items | | {{NH|short}} handheld items | ||
Line 1,113: | Line 1,135: | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 28 fields}} |
|- | |- | ||
| | | | ||
*<code>identifier</code> - String | *<code>identifier</code> - String | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
− | |||
*<code>uses</code> - String | *<code>uses</code> - String | ||
*<code>inv_icon</code> - String | *<code>inv_icon</code> - String | ||
Line 1,149: | Line 1,170: | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
| '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]''' | | '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]''' | ||
| {{NH|short}} handheld item variations | | {{NH|short}} handheld item variations | ||
Line 1,683: | Line 1,704: | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
| {{Table cell|No}} | | {{Table cell|No}} | ||
− | | '''[[Special:CargoTables/ | + | | '''[[Special:CargoTables/pg_bug|pg_bug]]''' |
− | | {{PG}} | + | | {{PG}} bugs |
| | | | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 60 fields}} |
|- | |- | ||
| | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
*<code>number</code> - Integer | *<code>number</code> - Integer | ||
− | *<code> | + | *<code>num_dnm</code> - Integer |
+ | *<code>num_plus</code> - Integer | ||
+ | *<code>num_pg</code> - Integer | ||
+ | *<code>num_e_plus</code> - Integer | ||
*<code>image</code> - String | *<code>image</code> - String | ||
− | *<code>fossil_group</code> - String | + | *<code>image_url</code> - String |
− | *<code>sell_price</code> - Integer | + | *<code>catchphrase</code> - String |
− | *<code>hha_base</code> - Integer | + | *<code>location</code> - String |
− | *<code>width</code> - Float | + | *<code>location2</code> - String |
− | *<code>length</code> - Float | + | *<code>rarity</code> - String |
+ | *<code>sell</code> - Integer | ||
+ | *<code>tank_width</code> - Float | ||
+ | *<code>tank_length</code> - Float | ||
+ | *<code>feng_shui</code> - String | ||
+ | *<code>availability</code> - String | ||
+ | *<code>on_animal_island</code> - Boolean | ||
+ | *<code>m1</code> - Boolean | ||
+ | *<code>m2</code> - Boolean | ||
+ | *<code>m3</code> - Boolean | ||
+ | *<code>m4</code> - Boolean | ||
+ | *<code>m5</code> - Boolean | ||
+ | *<code>m6</code> - Boolean | ||
+ | *<code>m7</code> - Boolean | ||
+ | *<code>m8_1</code> - Boolean | ||
+ | *<code>m8_2</code> - Boolean | ||
+ | *<code>m9_1</code> - Boolean | ||
+ | *<code>m9_2</code> - Boolean | ||
+ | *<code>m10</code> - Boolean | ||
+ | *<code>m11</code> - Boolean | ||
+ | *<code>m12</code> - Boolean | ||
+ | *<code>m1_time</code> - String | ||
+ | *<code>m2_time</code> - String | ||
+ | *<code>m3_time</code> - String | ||
+ | *<code>m4_time</code> - String | ||
+ | *<code>m5_time</code> - String | ||
+ | *<code>m6_time</code> - String | ||
+ | *<code>m7_time</code> - String | ||
+ | *<code>m8_1_time</code> - String | ||
+ | *<code>m8_2_time</code> - String | ||
+ | *<code>m9_1_time</code> - String | ||
+ | *<code>m9_2_time</code> - String | ||
+ | *<code>m10_time</code> - String | ||
+ | *<code>m11_time</code> - String | ||
+ | *<code>m12_time</code> - String | ||
+ | *<code>time</code> - String | ||
+ | *<code>time_availability</code> - String | ||
+ | *<code>time2</code> - String | ||
+ | *<code>time2_availability</code> - String | ||
+ | *<code>time3</code> - String | ||
+ | *<code>time3_availability</code> - String | ||
+ | *<code>time4</code> - String | ||
+ | *<code>time4_availability</code> - String | ||
+ | *<code>blathers_quote</code> - String | ||
+ | |} | ||
+ | | Missing rarity data (common name for rarity percentages TBD). | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_clothing|pg_clothing]]''' | ||
+ | | {{PG}} clothing | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 34 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>es_name</code> - String | ||
+ | *<code>de_name</code> - String | ||
+ | *<code>fr_name</code> - String | ||
+ | *<code>it_name</code> - String | ||
+ | *<code>ja_name</code> - String | ||
+ | *<code>zh_name</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>catalog_num_dnm</code> - Integer | ||
+ | *<code>catalog_num_plus</code> - Integer | ||
+ | *<code>catalog_num_pg</code> - Integer | ||
+ | *<code>catalog_num_e_plus</code> - Integer | ||
+ | *<code>image</code> - String | ||
+ | *<code>texture</code> - String | ||
+ | *<code>rarity_group</code> - String | ||
+ | *<code>hra_base</code> - Integer | ||
+ | *<code>buy</code> - Integer | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>availability1</code> - String | ||
+ | *<code>availability1_note</code> - String | ||
+ | *<code>availability2</code> - String | ||
+ | *<code>availability2_note</code> - String | ||
+ | *<code>availability_other</code> - List of String | ||
+ | *<code>availability_other_note</code> - String | ||
+ | *<code>availability_dates</code> - String | ||
+ | *<code>availability_season</code> - String | ||
+ | *<code>style</code> - String | ||
+ | *<code>universal_code</code> - String | ||
+ | *<code>universal_code_plus</code> - String | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_fish|pg_fish]]''' | ||
+ | | {{PG}} fish | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 61 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>number</code> - Integer | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>num_dnm</code> - Integer | ||
+ | *<code>num_plus</code> - Integer | ||
+ | *<code>num_pg</code> - Integer | ||
+ | *<code>num_e_plus</code> - Integer | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>catchphrase</code> - String | ||
+ | *<code>location</code> - String | ||
+ | *<code>location2</code> - String | ||
+ | *<code>shadow_size</code> - String | ||
+ | *<code>rarity</code> - String | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>tank_width</code> - Float | ||
+ | *<code>tank_length</code> - Float | ||
+ | *<code>feng_shui</code> - String | ||
+ | *<code>availability</code> - String | ||
+ | *<code>on_animal_island</code> - Boolean | ||
+ | *<code>m1</code> - Boolean | ||
+ | *<code>m2</code> - Boolean | ||
+ | *<code>m3</code> - Boolean | ||
+ | *<code>m4</code> - Boolean | ||
+ | *<code>m5</code> - Boolean | ||
+ | *<code>m6</code> - Boolean | ||
+ | *<code>m7</code> - Boolean | ||
+ | *<code>m8_1</code> - Boolean | ||
+ | *<code>m8_2</code> - Boolean | ||
+ | *<code>m9_1</code> - Boolean | ||
+ | *<code>m9_2</code> - Boolean | ||
+ | *<code>m10</code> - Boolean | ||
+ | *<code>m11</code> - Boolean | ||
+ | *<code>m12</code> - Boolean | ||
+ | *<code>m1_time</code> - String | ||
+ | *<code>m2_time</code> - String | ||
+ | *<code>m3_time</code> - String | ||
+ | *<code>m4_time</code> - String | ||
+ | *<code>m5_time</code> - String | ||
+ | *<code>m6_time</code> - String | ||
+ | *<code>m7_time</code> - String | ||
+ | *<code>m8_1_time</code> - String | ||
+ | *<code>m8_2_time</code> - String | ||
+ | *<code>m9_1_time</code> - String | ||
+ | *<code>m9_2_time</code> - String | ||
+ | *<code>m10_time</code> - String | ||
+ | *<code>m11_time</code> - String | ||
+ | *<code>m12_time</code> - String | ||
+ | *<code>time</code> - String | ||
+ | *<code>time_availability</code> - String | ||
+ | *<code>time2</code> - String | ||
+ | *<code>time2_availability</code> - String | ||
+ | *<code>time3</code> - String | ||
+ | *<code>time3_availability</code> - String | ||
+ | *<code>time4</code> - String | ||
+ | *<code>time4_availability</code> - String | ||
+ | *<code>blathers_quote</code> - Text | ||
+ | |} | ||
+ | | Missing rarity data (common name for rarity percentages TBD). | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_fossil|pg_fossil]]''' | ||
+ | | {{PG}} fossils | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 8 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>number</code> - Integer | ||
+ | *<code>name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>fossil_group</code> - String | ||
+ | *<code>sell_price</code> - Integer | ||
+ | *<code>hha_base</code> - Integer | ||
+ | *<code>width</code> - Float | ||
+ | *<code>length</code> - Float | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_furniture|pg_furniture]]''' | ||
+ | | {{PG}} furniture | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 47 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>catalog_num_dnm</code> - Integer | ||
+ | *<code>catalog_num_plus</code> - Integer | ||
+ | *<code>catalog_num_pg</code> - Integer | ||
+ | *<code>catalog_num_e_plus</code> - Integer | ||
+ | *<code>image_dnm</code> - String | ||
+ | *<code>image_plus</code> - String | ||
+ | *<code>image_pg</code> - String | ||
+ | *<code>image_e_plus</code> - String | ||
+ | *<code>audio</code> - String | ||
+ | *<code>collection</code> - String | ||
+ | *<code>rarity_group</code> - String | ||
+ | *<code>hra_base</code> - Integer | ||
+ | *<code>color</code> - String | ||
+ | *<code>lucky</code> - Boolean | ||
+ | *<code>function</code> - String | ||
+ | *<code>has_surface</code> - Boolean | ||
+ | *<code>buy</code> - Integer | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>availability1</code> - String | ||
+ | *<code>availability1_note</code> - String | ||
+ | *<code>availability2</code> - String | ||
+ | *<code>availability2_note</code> - String | ||
+ | *<code>availability3</code> - String | ||
+ | *<code>availability3_note</code> - String | ||
+ | *<code>availability_other</code> - List of String | ||
+ | *<code>availability_other_note</code> - String | ||
+ | *<code>plus_availability</code> - String | ||
+ | *<code>plus_availability_note</code> - String | ||
+ | *<code>length</code> - Integer | ||
+ | *<code>width</code> - Integer | ||
+ | *<code>interactable</code> - Boolean | ||
+ | *<code>interactivity</code> - String | ||
+ | *<code>animated</code> - Boolean | ||
+ | *<code>animation_activation</code> - String | ||
+ | *<code>sound</code> - Boolean | ||
+ | *<code>sound_activation</code> - String | ||
+ | *<code>placeable</code> - Boolean | ||
+ | *<code>placeable_surface</code> - Boolean | ||
+ | *<code>walkable</code> - Boolean | ||
+ | *<code>universal_code</code> - String | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_house|pg_house]]''' | ||
+ | | {{PG}} villager homes (some parts used in villager endpoint) | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 18 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>villager</code> - String | ||
+ | *<code>islander</code> - Boolean | ||
+ | *<code>game</code> - List of String | ||
+ | *<code>interior_image</code> - String | ||
+ | *<code>interior_image_url</code> - String | ||
+ | *<code>exterior_image</code> - String | ||
+ | *<code>exterior_image_url</code> - String | ||
+ | *<code>wallpaper</code> - String | ||
+ | *<code>wallpaper_image</code> - String | ||
+ | *<code>wallpaper_image_url</code> - String | ||
+ | *<code>flooring</code> - String | ||
+ | *<code>flooring_image</code> - String | ||
+ | *<code>flooring_image_url</code> - String | ||
+ | *<code>music</code> - String | ||
+ | *<code>music_note</code> - String | ||
+ | *<code>items</code> - Text | ||
+ | *<code>request_items</code> - Text | ||
+ | *<code>notes</code> - Wikitext string | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_interior|pg_interior]]''' | ||
+ | | {{PG}} wallpaper and flooring | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 30 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>catalog_num_dnm</code> - Integer | ||
+ | *<code>catalog_num_plus</code> - Integer | ||
+ | *<code>catalog_num_pg</code> - Integer | ||
+ | *<code>catalog_num_e_plus</code> - Integer | ||
+ | *<code>image</code> - String | ||
+ | *<code>category</code> - String | ||
+ | *<code>category_sort</code> - Integer | ||
+ | *<code>collection</code> - String | ||
+ | *<code>rarity_group</code> - String | ||
+ | *<code>hra_base</code> - Integer | ||
+ | *<code>buy</code> - Integer | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>availability1</code> - String | ||
+ | *<code>availability1_note</code> - String | ||
+ | *<code>availability2</code> - String | ||
+ | *<code>availability2_note</code> - String | ||
+ | *<code>availability3</code> - String | ||
+ | *<code>availability3_note</code> - String | ||
+ | *<code>availability_other</code> - List of String | ||
+ | *<code>availability_other_note</code> - String | ||
+ | *<code>plus_availability</code> - String | ||
+ | *<code>plus_availability_note</code> - String | ||
+ | *<code>universal_code</code> - String | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Yellow}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_item|pg_item]]''' | ||
+ | | {{PG}} other items | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 19 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_plus</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>image</code> - String | ||
+ | *<code>buy</code> - Integer | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>availability1</code> - String | ||
+ | *<code>availability1_note</code> - String | ||
+ | *<code>availability2</code> - String | ||
+ | *<code>availability2_note</code> - String | ||
+ | *<code>availability3</code> - String | ||
+ | *<code>availability3_note</code> - String | ||
+ | *<code>availability_other</code> - List of String | ||
+ | *<code>availability_other_note</code> - String | ||
+ | *<code>universal_code</code> - String | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_language_name|pg_language_name]]''' | ||
+ | | {{PG}} translations | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 8 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>de_name</code> - String | ||
+ | *<code>es_name</code> - String | ||
+ | *<code>fr_name</code> - String | ||
+ | *<code>it_name</code> - String | ||
+ | *<code>ja_name</code> - String | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pg_villager|pg_villager]]''' | ||
+ | | {{PG}} villagers (using in villager endpoint) | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 25 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>romanized_name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>species</code> - String | ||
+ | *<code>gender</code> - String | ||
+ | *<code>personality</code> - String | ||
+ | *<code>sign</code> - String | ||
+ | *<code>catchphrase</code> - String | ||
+ | *<code>clothing</code> - String | ||
+ | *<code>clothing_e_plus</code> - String | ||
+ | *<code>clothing_plus</code> - String | ||
+ | *<code>clothing_dnm</code> - String | ||
+ | *<code>umbrella</code> - String | ||
+ | *<code>in_dnm</code> - Boolean | ||
+ | *<code>in_pg</code> - Boolean | ||
+ | *<code>in_e_plus</code> - Boolean | ||
+ | *<code>islander</code> - Boolean | ||
+ | *<code>fav_fruit</code> - String | ||
+ | *<code>allergic_fruit</code> - String | ||
+ | *<code>fav_clothing</code> - String | ||
+ | *<code>least_fav_clothing</code> - String | ||
+ | *<code>song_gift</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/song|song]]''' | ||
+ | | K.K. Slider song cover, audio, and {{SER}} appearances | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 18 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>name_sort</code> - String | ||
+ | *<code>order_number</code> - Integer | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>aircheck</code> - String | ||
+ | *<code>aircheck_url</code> - String | ||
+ | *<code>live</code> - String | ||
+ | *<code>live_url</code> - String | ||
+ | *<code>mood</code> - String | ||
+ | *<code>dnm</code> - Boolean | ||
+ | *<code>ac</code> - Boolean | ||
+ | *<code>e_plus</code> - Boolean | ||
+ | *<code>ww</code> - Boolean | ||
+ | *<code>cf</code> - Boolean | ||
+ | *<code>nl</code> - Boolean | ||
+ | *<code>nh</code> - Boolean | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Yellow}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/special_character|special_character]]''' | ||
+ | | Special character info and {{SER}} appearances | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 29 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>name_sort</code> - String | ||
+ | *<code>alt_name</code> - String | ||
+ | *<code>ID</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>nh_phone_texture</code> - String | ||
+ | *<code>nh_phone_texture_url</code> - String | ||
+ | *<code>species</code> - String | ||
+ | *<code>gender</code> - String | ||
+ | *<code>gender_japan</code> - String | ||
+ | *<code>birthday</code> - String | ||
+ | *<code>birthday_month</code> - String | ||
+ | *<code>birthday_day</code> - Integer | ||
+ | *<code>birthday_sort</code> - Integer | ||
+ | *<code>sign</code> - String | ||
+ | *<code>speciespage_debut</code> - String | ||
+ | *<code>dnm</code> - Boolean | ||
+ | *<code>ac</code> - Boolean | ||
+ | *<code>e_plus</code> - Boolean | ||
+ | *<code>ww</code> - Boolean | ||
+ | *<code>cf</code> - Boolean | ||
+ | *<code>nl</code> - Boolean | ||
+ | *<code>wa</code> - Boolean | ||
+ | *<code>nh</code> - Boolean | ||
+ | *<code>film</code> - Boolean | ||
+ | *<code>hhd</code> - Boolean | ||
+ | *<code>pc</code> - Boolean | ||
|} | |} | ||
| - | | - | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
− | | {{Table cell| | + | | {{Table cell|Yes}} |
− | | '''[[Special:CargoTables/ | + | | '''[[Special:CargoTables/villager|villager]]''' |
− | | | + | | {{SER}} villagers |
| | | | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 40 fields}} |
|- | |- | ||
| | | | ||
Line 1,715: | Line 2,227: | ||
*<code>name</code> - String | *<code>name</code> - String | ||
*<code>name_sort</code> - String | *<code>name_sort</code> - String | ||
− | *<code> | + | *<code>alt_name</code> - String |
+ | *<code>title_color</code> - String | ||
+ | *<code>text_color</code> - String | ||
+ | *<code>id</code> - String | ||
*<code>image</code> - String | *<code>image</code> - String | ||
*<code>image_url</code> - String | *<code>image_url</code> - String | ||
− | *<code> | + | *<code>species</code> - String |
− | *<code> | + | *<code>personality</code> - String |
− | *<code> | + | *<code>personality_note</code> - String |
− | *<code> | + | *<code>prev_personality</code> - String |
− | *<code> | + | *<code>prev_personality_note</code> - String |
+ | *<code>gender</code> - String | ||
+ | *<code>birthday</code> - String | ||
+ | *<code>birthday_month</code> - String | ||
+ | *<code>birthday_day</code> - Integer | ||
+ | *<code>birthday_sort</code> - Integer | ||
+ | *<code>sign</code> - String | ||
+ | *<code>sign_sort</code> - Integer | ||
+ | *<code>quote</code> - String | ||
+ | *<code>phrase</code> - String | ||
+ | *<code>prev_phrase</code> - String | ||
+ | *<code>prev_phrase2</code> - String | ||
+ | *<code>clothing</code> - String | ||
+ | *<code>clothing_nh_var</code> - String | ||
+ | *<code>islander</code> - Boolean | ||
+ | *<code>debut</code> - String | ||
*<code>dnm</code> - Boolean | *<code>dnm</code> - Boolean | ||
*<code>ac</code> - Boolean | *<code>ac</code> - Boolean | ||
Line 1,729: | Line 2,259: | ||
*<code>cf</code> - Boolean | *<code>cf</code> - Boolean | ||
*<code>nl</code> - Boolean | *<code>nl</code> - Boolean | ||
+ | *<code>wa</code> - Boolean | ||
*<code>nh</code> - Boolean | *<code>nh</code> - Boolean | ||
+ | *<code>film</code> - Boolean | ||
+ | *<code>hhd</code> - Boolean | ||
+ | *<code>pc</code> - Boolean | ||
|} | |} | ||
| - | | - | ||
Line 1,735: | Line 2,269: | ||
| {{Table cell|Yellow}} | | {{Table cell|Yellow}} | ||
| {{Table cell|No}} | | {{Table cell|No}} | ||
− | | '''[[Special:CargoTables/ | + | | '''[[Special:CargoTables/ww_house|ww_house]]''' |
− | | | + | | {{WW|short}} villager homes (some parts used in villager endpoint) |
| | | | ||
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
|- | |- | ||
− | ! {{Colorshow|4c4c4c|Open to view | + | ! {{Colorshow|4c4c4c|Open to view 13 fields}} |
|- | |- | ||
| | | | ||
− | *<code> | + | *<code>villager</code> - String |
− | + | *<code>interior_image</code> - String | |
− | + | *<code>interior_image_url</code> - String | |
− | + | *<code>wallpaper</code> - String | |
− | + | *<code>wallpaper_image</code> - String | |
− | + | *<code>wallpaper_image_url</code> - String | |
− | + | *<code>flooring</code> - String | |
− | + | *<code>flooring_image</code> - String | |
− | + | *<code>flooring_image_url</code> - String | |
− | + | *<code>music</code> - String | |
− | + | *<code>music_note</code> - String | |
− | + | *<code>items</code> - Text | |
− | + | *<code>notes</code> - Wikitext string | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | |||
− | |||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | *<code> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | *<code> | ||
|} | |} | ||
| - | | - | ||
Line 1,834: | Line 2,306: | ||
*<code>name_sort</code> - String | *<code>name_sort</code> - String | ||
*<code>pic</code> - String | *<code>pic</code> - String | ||
− | *<code>quote - String | + | *<code>quote</code> - String |
*<code>favclothing</code> - String | *<code>favclothing</code> - String | ||
*<code>leastfavclothing</code> - String | *<code>leastfavclothing</code> - String |
Latest revision as of 02:53, April 24, 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: 02:53, April 24, 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 |
|
- | ||||
furniture_collection | Furniture collection (such as series, sets, and themes) across the series |
|
Missing images in some pages. | ||||
nh_art | New Horizons art |
|
- | ||||
nh_bug | New Horizons bugs |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_calendar | New Horizons event and birthday notices. |
|
- | ||||
nh_clothing | New Horizons clothing |
|
Needs populating with the new data. (Integers should be replaced with booleans) | ||||
nh_clothing_variation | New Horizons clothing variations |
|
- | ||||
nh_fish | New Horizons fish |
|
Missing rarity data (common name for rarity percentages TBD). Needs description filling. | ||||
nh_fossil | New Horizons fossils |
|
- | ||||
nh_fossil_group | New Horizons fossil groups |
|
- | ||||
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_item | New Horizons other items |
|
- | ||||
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_house | New Leaf villager homes |
|
- | ||||
nl_sea_creature | New Leaf sea creatures |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nl_villager | New Leaf villagers |
|
- | ||||
nlwa_rv | Welcome amiibo RVs |
|
- | ||||
pc_furniture | Pocket Camp furniture |
|
- | ||||
pc_villager | Pocket Camp villager info and rewards | Columns need renaming to match standard
|
- | ||||
pg_bug | Animal Crossing bugs |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
pg_clothing | Animal Crossing clothing |
|
- | ||||
pg_fish | Animal Crossing fish |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
pg_fossil | Animal Crossing fossils |
|
- | ||||
pg_furniture | Animal Crossing furniture |
|
- | ||||
pg_house | Animal Crossing villager homes (some parts used in villager endpoint) |
|
- | ||||
pg_interior | Animal Crossing wallpaper and flooring |
|
- | ||||
pg_item | Animal Crossing other items |
|
- | ||||
pg_language_name | Animal Crossing translations |
|
- | ||||
pg_villager | Animal Crossing villagers (using in villager endpoint) |
|
- | ||||
song | K.K. Slider song cover, audio, and Animal Crossing series appearances |
|
- | ||||
special_character | Special character info and Animal Crossing series appearances |
|
- | ||||
villager | Animal Crossing series villagers |
|
- | ||||
ww_house | Wild World villager homes (some parts used in villager endpoint) |
|
- | ||||
ww_villager | Wild World villager picture, quote and preferences |
|
- |