Difference between revisions of "Nookipedia:Project Database/List of tables"
From Nookipedia, the Animal Crossing wiki
SuperHamster (talk | contribs) m (Text replacement - ""collapsible collapsed"" to ""mw-collapsible mw-collapsed"") |
(updating all up to pc (will continue it later)) |
||
Line 275: | Line 275: | ||
|} | |} | ||
| - | | - | ||
+ | |- | ||
+ | | {{Table cell|Yellow}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/furniture_collection|furniture_collection]]''' | ||
+ | | Furniture collection (such as series, sets, and themes) across the series | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 17 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>url</code> - String | ||
+ | *<code>name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>type1</code> - String | ||
+ | *<code>type1_note</code> - String | ||
+ | *<code>type2</code> - String | ||
+ | *<code>type2_note</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>nlwa</code> - Boolean | ||
+ | *<code>nh</code> - Boolean | ||
+ | *<code>hhd</code> - Boolean | ||
+ | *<code>pc</code> - Boolean | ||
+ | |} | ||
+ | | Missing images in some pages. | ||
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
Line 323: | Line 353: | ||
{| 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 73 fields}} |
|- | |- | ||
| | | | ||
Line 331: | Line 361: | ||
*<code>image</code> - String | *<code>image</code> - String | ||
*<code>image_url</code> - String | *<code>image_url</code> - String | ||
+ | *<code>render</code> - String | ||
+ | *<code>render_url</code> - String | ||
*<code>catchphrase</code> - String | *<code>catchphrase</code> - String | ||
*<code>catchphrase2</code> - String | *<code>catchphrase2</code> - String | ||
+ | *<code>location</code> - String | ||
+ | *<code>rarity</code> - String | ||
+ | *<code>total_catch</code> - Integer | ||
+ | *<code>sell_nook</code> - Integer | ||
+ | *<code>sell_flick</code> - Integer | ||
+ | *<code>tank_width</code> - Float | ||
+ | *<code>tank_length</code> - Float | ||
*<code>n_availability</code> - String | *<code>n_availability</code> - String | ||
*<code>n_m1</code> - Boolean | *<code>n_m1</code> - Boolean | ||
Line 346: | Line 385: | ||
*<code>n_m11</code> - Boolean | *<code>n_m11</code> - Boolean | ||
*<code>n_m12</code> - Boolean | *<code>n_m12</code> - Boolean | ||
+ | *<code>n_m1_time</code> - String | ||
+ | *<code>n_m2_time</code> - String | ||
+ | *<code>n_m3_time</code> - String | ||
+ | *<code>n_m4_time</code> - String | ||
+ | *<code>n_m5_time</code> - String | ||
+ | *<code>n_m6_time</code> - String | ||
+ | *<code>n_m7_time</code> - String | ||
+ | *<code>n_m8_time</code> - String | ||
+ | *<code>n_m9_time</code> - String | ||
+ | *<code>n_m10_time</code> - String | ||
+ | *<code>n_m11_time</code> - String | ||
+ | *<code>n_m12_time</code> - String | ||
*<code>s_availability</code> - String | *<code>s_availability</code> - String | ||
*<code>s_m1</code> - Boolean | *<code>s_m1</code> - Boolean | ||
Line 359: | Line 410: | ||
*<code>s_m11</code> - Boolean | *<code>s_m11</code> - Boolean | ||
*<code>s_m12</code> - Boolean | *<code>s_m12</code> - Boolean | ||
+ | *<code>s_m1_time</code> - String | ||
+ | *<code>s_m2_time</code> - String | ||
+ | *<code>s_m3_time</code> - String | ||
+ | *<code>s_m4_time</code> - String | ||
+ | *<code>s_m5_time</code> - String | ||
+ | *<code>s_m6_time</code> - String | ||
+ | *<code>s_m7_time</code> - String | ||
+ | *<code>s_m8_time</code> - String | ||
+ | *<code>s_m9_time</code> - String | ||
+ | *<code>s_m10_time</code> - String | ||
+ | *<code>s_m11_time</code> - String | ||
+ | *<code>s_m12_time</code> - String | ||
+ | *<code>weather</code> - String | ||
*<code>time</code> - String | *<code>time</code> - String | ||
− | *<code> | + | *<code>time_n_availability</code> - String |
− | *<code> | + | *<code>time_s_availability</code> - String |
− | *<code> | + | *<code>time2</code> - String |
− | *<code> | + | *<code>time2_n_availability</code> - String |
− | *<code> | + | *<code>time2_s_availability</code> - String |
− | |||
− | |||
|} | |} | ||
| Missing rarity data (common name for rarity percentages TBD). | | Missing rarity data (common name for rarity percentages TBD). | ||
Line 377: | Line 439: | ||
{| 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 57 fields}} |
|- | |- | ||
| | | | ||
Line 402: | Line 464: | ||
*<code>availability2</code> - String | *<code>availability2</code> - String | ||
*<code>availability2_note</code> - String | *<code>availability2_note</code> - String | ||
+ | *<code>variation_total</code> - Integer | ||
*<code>vill_equip</code> - Boolean | *<code>vill_equip</code> - Boolean | ||
+ | *<code>seasonality</code> - String | ||
+ | *<code>gender</code> - String | ||
+ | *<code>vill_gender</code> - String | ||
+ | *<code>spring</code> - Integer | ||
+ | *<code>summer</code> - Integer | ||
+ | *<code>autumn</code> - Integer | ||
+ | *<code>winter</code> - Integer | ||
+ | *<code>china</code> - Integer | ||
+ | *<code>birthday</code> - Integer | ||
+ | *<code>book</code> - Integer | ||
+ | *<code>sleep</code> - Integer | ||
+ | *<code>bug_catching</code> - Integer | ||
+ | *<code>japanese</code> - Integer | ||
+ | *<code>fishing</code> - Integer | ||
+ | *<code>usually</code> - Integer | ||
+ | *<code>fashion</code> - Integer | ||
+ | *<code>rain</code> - Integer | ||
+ | *<code>birthday_main</code> - Integer | ||
+ | *<code>countdown</code> - Integer | ||
+ | *<code>snow</code> - Integer | ||
+ | *<code>sports</code> - Integer | ||
+ | *<code>yoga</code> - Integer | ||
+ | *<code>sunbathing</code> - Integer | ||
+ | *<code>concert</code> - Integer | ||
+ | *<code>bunny_day</code> - Integer | ||
+ | *<code>fireworks</code> - Integer | ||
+ | *<code>halloween</code> - Integer | ||
+ | *<code>turkey_day_plaza</code> - Integer | ||
+ | *<code>turkey_day_home</code> - Integer | ||
+ | *<code>toy_day</code> - Integer | ||
*<code>version_added</code> - String | *<code>version_added</code> - String | ||
*<code>unlocked</code> - Boolean | *<code>unlocked</code> - Boolean | ||
*<code>notes</code> - String | *<code>notes</code> - String | ||
|} | |} | ||
− | | | + | | Needs populating with the new data. (Integers should be replaced with booleans) |
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
Line 416: | Line 509: | ||
{| 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 10 fields}} |
|- | |- | ||
| | | | ||
Line 422: | Line 515: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>variation</code> - String | *<code>variation</code> - String | ||
+ | *<code>variation_number</code> - Integer | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>image_storage</code> - String | ||
+ | *<code>image_storage_url</code> - String | ||
*<code>color1</code> - String | *<code>color1</code> - String | ||
*<code>color2</code> - String | *<code>color2</code> - String | ||
Line 435: | Line 532: | ||
{| 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 75 fields}} |
|- | |- | ||
| | | | ||
Line 443: | Line 540: | ||
*<code>image</code> - String | *<code>image</code> - String | ||
*<code>image_url</code> - String | *<code>image_url</code> - String | ||
+ | *<code>render</code> - String | ||
+ | *<code>render_url</code> - String | ||
*<code>catchphrase</code> - String | *<code>catchphrase</code> - String | ||
*<code>catchphrase2</code> - String | *<code>catchphrase2</code> - String | ||
*<code>catchphrase3</code> - String | *<code>catchphrase3</code> - String | ||
+ | *<code>location</code> - String | ||
+ | *<code>shadow_size</code> - String | ||
+ | *<code>rarity</code> - String | ||
+ | *<code>total_catch</code> - Integer | ||
+ | *<code>sell_nook</code> - Integer | ||
+ | *<code>sell_cj</code> - Integer | ||
+ | *<code>tank_width</code> - Float | ||
+ | *<code>tank_length</code> - Float | ||
*<code>n_availability</code> - String | *<code>n_availability</code> - String | ||
*<code>n_m1</code> - Boolean | *<code>n_m1</code> - Boolean | ||
Line 459: | Line 566: | ||
*<code>n_m11</code> - Boolean | *<code>n_m11</code> - Boolean | ||
*<code>n_m12</code> - Boolean | *<code>n_m12</code> - Boolean | ||
+ | *<code>n_m1_time</code> - String | ||
+ | *<code>n_m2_time</code> - String | ||
+ | *<code>n_m3_time</code> - String | ||
+ | *<code>n_m4_time</code> - String | ||
+ | *<code>n_m5_time</code> - String | ||
+ | *<code>n_m6_time</code> - String | ||
+ | *<code>n_m7_time</code> - String | ||
+ | *<code>n_m8_time</code> - String | ||
+ | *<code>n_m9_time</code> - String | ||
+ | *<code>n_m10_time</code> - String | ||
+ | *<code>n_m11_time</code> - String | ||
+ | *<code>n_m12_time</code> - String | ||
*<code>s_availability</code> - String | *<code>s_availability</code> - String | ||
*<code>s_m1</code> - Boolean | *<code>s_m1</code> - Boolean | ||
Line 472: | Line 591: | ||
*<code>s_m11</code> - Boolean | *<code>s_m11</code> - Boolean | ||
*<code>s_m12</code> - Boolean | *<code>s_m12</code> - Boolean | ||
+ | *<code>s_m1_time</code> - String | ||
+ | *<code>s_m2_time</code> - String | ||
+ | *<code>s_m3_time</code> - String | ||
+ | *<code>s_m4_time</code> - String | ||
+ | *<code>s_m5_time</code> - String | ||
+ | *<code>s_m6_time</code> - String | ||
+ | *<code>s_m7_time</code> - String | ||
+ | *<code>s_m8_time</code> - String | ||
+ | *<code>s_m9_time</code> - String | ||
+ | *<code>s_m10_time</code> - String | ||
+ | *<code>s_m11_time</code> - String | ||
+ | *<code>s_m12_time</code> - String | ||
*<code>time</code> - String | *<code>time</code> - String | ||
*<code>time_n_availability</code> - String | *<code>time_n_availability</code> - String | ||
Line 478: | Line 609: | ||
*<code>time2_n_availability</code> - String | *<code>time2_n_availability</code> - String | ||
*<code>time2_s_availability</code> - String | *<code>time2_s_availability</code> - String | ||
− | *<code> | + | *<code>description</code> - Text |
− | *<code> | + | |} |
− | *<code> | + | | Missing rarity data (common name for rarity percentages TBD). Needs description filling. |
− | *<code> | + | |- |
− | *<code> | + | | {{Table cell|Green}} |
− | *<code> | + | | {{Table cell|No}} |
− | *<code> | + | | '''[[Special:CargoTables/nh_fossil|nh_fossil]]''' |
− | *<code> | + | | {{NH|short}} fossil |
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 10 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>fossil_group</code> - String | ||
+ | *<code>interactable</code> - Boolean | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>color1</code> - String | ||
+ | *<code>color2</code> - String | ||
+ | *<code>hha_base</code> - Integer | ||
+ | *<code>width</code> - Float | ||
+ | *<code>length</code> - Float | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/nh_fossil_group|nh_fossil_group]]''' | ||
+ | | {{NH|short}} fossil groups | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 3 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>name</code> - String | ||
+ | *<code>room</code> - Integer | ||
+ | *<code>description</code> - Text | ||
|} | |} | ||
− | | | + | | - |
|- | |- | ||
| {{Table cell|Green}} | | {{Table cell|Green}} | ||
Line 496: | Line 659: | ||
{| 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 50 fields}} |
|- | |- | ||
| | | | ||
Line 507: | Line 670: | ||
*<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>tag</code> - String | ||
*<code>hha_base</code> - Integer | *<code>hha_base</code> - Integer | ||
+ | *<code>lucky</code> - Boolean | ||
+ | *<code>lucky_season</code> - String | ||
*<code>function1</code> - String | *<code>function1</code> - String | ||
*<code>function2</code> - String | *<code>function2</code> - String | ||
Line 522: | Line 688: | ||
*<code>availability2</code> - String | *<code>availability2</code> - String | ||
*<code>availability2_note</code> - String | *<code>availability2_note</code> - String | ||
+ | *<code>availability3</code> - String | ||
+ | *<code>availability3_note</code> - String | ||
+ | *<code>variation_total</code> - Integer | ||
+ | *<code>pattern_total</code> - Integer | ||
*<code>customizable</code> - Boolean | *<code>customizable</code> - Boolean | ||
*<code>custom_kits</code> - Integer | *<code>custom_kits</code> - Integer | ||
+ | *<code>custom_kit_type</code> - String | ||
*<code>custom_body_part</code> - String | *<code>custom_body_part</code> - String | ||
*<code>custom_pattern_part</code> - String | *<code>custom_pattern_part</code> - String | ||
Line 537: | Line 708: | ||
*<code>lighting</code> - Boolean | *<code>lighting</code> - Boolean | ||
*<code>door_decor</code> - Boolean | *<code>door_decor</code> - Boolean | ||
+ | *<code>is_material</code> - Boolean | ||
*<code>version_added</code> - String | *<code>version_added</code> - String | ||
*<code>unlocked</code> - Boolean | *<code>unlocked</code> - Boolean | ||
Line 556: | Line 728: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>variation</code> - String | *<code>variation</code> - String | ||
+ | *<code>variation_number</code> - Integer | ||
*<code>pattern</code> - String | *<code>pattern</code> - String | ||
+ | *<code>pattern_number</code> - Integer | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>color1</code> - String | *<code>color1</code> - String | ||
*<code>color2</code> - String | *<code>color2</code> - String | ||
Line 570: | Line 745: | ||
{| 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 18 fields}} |
|- | |- | ||
| | | | ||
*<code>villager</code> - String | *<code>villager</code> - String | ||
+ | *<code>name_sort</code> - String | ||
*<code>interior_image</code> - String | *<code>interior_image</code> - String | ||
*<code>interior_image_url</code> - String | *<code>interior_image_url</code> - String | ||
Line 586: | Line 762: | ||
*<code>music</code> - String | *<code>music</code> - String | ||
*<code>music_note</code> - String | *<code>music_note</code> - String | ||
+ | *<code>music_image</code> - String | ||
+ | *<code>music_image_url</code> - String | ||
*<code>items</code> - Text | *<code>items</code> - Text | ||
*<code>notes</code> - Wikitext string | *<code>notes</code> - Wikitext string | ||
Line 598: | Line 776: | ||
{| 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 29 fields}} |
|- | |- | ||
| | | | ||
Line 604: | Line 782: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>category</code> - String | *<code>category</code> - String | ||
+ | *<code>category_sort</code> - Integer | ||
*<code>item_series</code> - String | *<code>item_series</code> - String | ||
+ | *<code>item_set</code> - String | ||
*<code>theme1</code> - String | *<code>theme1</code> - String | ||
*<code>theme2</code> - String | *<code>theme2</code> - String | ||
Line 623: | Line 804: | ||
*<code>color1</code> - String | *<code>color1</code> - String | ||
*<code>color2</code> - String | *<code>color2</code> - String | ||
+ | *<code>is_material</code> - Boolean | ||
+ | *<code>version_added</code> - String | ||
+ | *<code>unlocked</code> - Boolean | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/nh_item|nh_item]]''' | ||
+ | | {{NH|short}} other items | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 28 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>stack</code> - Integer | ||
+ | *<code>hha_base</code> - Integer | ||
+ | *<code>buy1_price</code> - Integer | ||
+ | *<code>buy1_currency</code> - String | ||
+ | *<code>buy1_wikitext</code> - Wikitext string | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>is_fence</code> - Boolean | ||
+ | *<code>is_material</code> - Boolean | ||
+ | *<code>material_type</code> - String | ||
+ | *<code>material_seasonality</code> - String | ||
+ | *<code>material_sort</code> - Integer | ||
+ | *<code>material_name_sort</code> - Integer | ||
+ | *<code>material_seasonality_sort</code> - Integer | ||
+ | *<code>edible</code> - Boolean | ||
+ | *<code>plant_type</code> - String | ||
+ | *<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>version_added</code> - String | *<code>version_added</code> - String | ||
*<code>unlocked</code> - Boolean | *<code>unlocked</code> - Boolean | ||
Line 700: | Line 923: | ||
{| 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 26 fields}} |
|- | |- | ||
| | | | ||
*<code>identifier</code> - String | *<code>identifier</code> - String | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
+ | *<code>name_sort</code> - String | ||
*<code>category</code> - String | *<code>category</code> - String | ||
*<code>buy1_price</code> - Integer | *<code>buy1_price</code> - Integer | ||
Line 738: | Line 962: | ||
{| 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 8 fields}} |
|- | |- | ||
| | | | ||
Line 744: | Line 968: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>variation</code> - String | *<code>variation</code> - String | ||
+ | *<code>variation_number</code> - Integer | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>color1</code> - String | *<code>color1</code> - String | ||
*<code>color2</code> - String | *<code>color2</code> - String | ||
Line 757: | Line 983: | ||
{| 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 763: | Line 989: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>serial_id</code> - Integer | *<code>serial_id</code> - Integer | ||
+ | *<code>type</code> - String | ||
*<code>buy1_price</code> - Integer | *<code>buy1_price</code> - Integer | ||
*<code>buy1_currency</code> - String | *<code>buy1_currency</code> - String | ||
Line 800: | Line 1,028: | ||
{| 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 72 fields}} |
|- | |- | ||
| | | | ||
Line 808: | Line 1,036: | ||
*<code>image</code> - String | *<code>image</code> - String | ||
*<code>image_url</code> - String | *<code>image_url</code> - String | ||
+ | *<code>render</code> - String | ||
+ | *<code>render_url</code> - String | ||
*<code>catchphrase</code> - String | *<code>catchphrase</code> - String | ||
*<code>catchphrase2</code> - String | *<code>catchphrase2</code> - String | ||
+ | *<code>shadow_size</code> - String | ||
+ | *<code>shadow_movement</code> - String | ||
+ | *<code>rarity</code> - String | ||
+ | *<code>total_catch</code> - Integer | ||
+ | *<code>sell_nook</code> - Integer | ||
+ | *<code>tank_width</code> - Float | ||
+ | *<code>tank_length</code> - Float | ||
*<code>n_availability</code> - String | *<code>n_availability</code> - String | ||
*<code>n_m1</code> - Boolean | *<code>n_m1</code> - Boolean | ||
Line 823: | Line 1,060: | ||
*<code>n_m11</code> - Boolean | *<code>n_m11</code> - Boolean | ||
*<code>n_m12</code> - Boolean | *<code>n_m12</code> - Boolean | ||
+ | *<code>n_m1_time</code> - String | ||
+ | *<code>n_m2_time</code> - String | ||
+ | *<code>n_m3_time</code> - String | ||
+ | *<code>n_m4_time</code> - String | ||
+ | *<code>n_m5_time</code> - String | ||
+ | *<code>n_m6_time</code> - String | ||
+ | *<code>n_m7_time</code> - String | ||
+ | *<code>n_m8_time</code> - String | ||
+ | *<code>n_m9_time</code> - String | ||
+ | *<code>n_m10_time</code> - String | ||
+ | *<code>n_m11_time</code> - String | ||
+ | *<code>n_m12_time</code> - String | ||
*<code>s_availability</code> - String | *<code>s_availability</code> - String | ||
*<code>s_m1</code> - Boolean | *<code>s_m1</code> - Boolean | ||
Line 836: | Line 1,085: | ||
*<code>s_m11</code> - Boolean | *<code>s_m11</code> - Boolean | ||
*<code>s_m12</code> - Boolean | *<code>s_m12</code> - Boolean | ||
+ | *<code>s_m1_time</code> - String | ||
+ | *<code>s_m2_time</code> - String | ||
+ | *<code>s_m3_time</code> - String | ||
+ | *<code>s_m4_time</code> - String | ||
+ | *<code>s_m5_time</code> - String | ||
+ | *<code>s_m6_time</code> - String | ||
+ | *<code>s_m7_time</code> - String | ||
+ | *<code>s_m8_time</code> - String | ||
+ | *<code>s_m9_time</code> - String | ||
+ | *<code>s_m10_time</code> - String | ||
+ | *<code>s_m11_time</code> - String | ||
+ | *<code>s_m12_time</code> - String | ||
*<code>time</code> - String | *<code>time</code> - String | ||
− | *<code> | + | *<code>time_n_availability</code> - String |
− | *<code> | + | *<code>time_s_availability</code> - String |
− | *<code> | + | *<code>time2</code> - String |
− | *<code> | + | *<code>time2_n_availability</code> - String |
− | *<code> | + | *<code>time2_s_availability</code> - String |
− | |||
− | |||
|} | |} | ||
| Missing rarity data (common name for rarity percentages TBD). | | Missing rarity data (common name for rarity percentages TBD). | ||
Line 854: | Line 1,113: | ||
{| 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 29 fields}} |
|- | |- | ||
| | | | ||
Line 861: | Line 1,120: | ||
*<code>item_set</code> - Integer | *<code>item_set</code> - Integer | ||
*<code>uses</code> - String | *<code>uses</code> - String | ||
+ | *<code>inv_icon</code> - String | ||
+ | *<code>inv_icon_url</code> - String | ||
*<code>hha_base</code> - Integer | *<code>hha_base</code> - Integer | ||
*<code>buy1_price</code> - Integer | *<code>buy1_price</code> - Integer | ||
Line 875: | Line 1,136: | ||
*<code>availability3</code> - String | *<code>availability3</code> - String | ||
*<code>availability3_note</code> - String | *<code>availability3_note</code> - String | ||
+ | *<code>availability4</code> - String | ||
+ | *<code>availability4_note</code> - String | ||
*<code>customizable</code> - Boolean | *<code>customizable</code> - Boolean | ||
*<code>custom_kits</code> - Integer | *<code>custom_kits</code> - Integer | ||
*<code>custom_body_part</code> - String | *<code>custom_body_part</code> - String | ||
+ | *<code>is_material</code> - Boolean | ||
*<code>version_added</code> - String | *<code>version_added</code> - String | ||
*<code>unlocked</code> - Boolean | *<code>unlocked</code> - Boolean | ||
Line 891: | Line 1,155: | ||
{| 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 8 fields}} |
|- | |- | ||
| | | | ||
Line 897: | Line 1,161: | ||
*<code>en_name</code> - String | *<code>en_name</code> - String | ||
*<code>variation</code> - String | *<code>variation</code> - String | ||
+ | *<code>variation_number</code> - Integer | ||
*<code>image</code> - String | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
*<code>color1</code> - String | *<code>color1</code> - String | ||
*<code>color2</code> - String | *<code>color2</code> - String | ||
Line 915: | Line 1,181: | ||
*<code>url</code> - String | *<code>url</code> - String | ||
*<code>name</code> - String | *<code>name</code> - String | ||
+ | *<code>name_sort</code> - String | ||
*<code>image</code> - String | *<code>image</code> - String | ||
*<code>image_url</code> - String | *<code>image_url</code> - String | ||
Line 932: | Line 1,199: | ||
*<code>clothing</code> - String | *<code>clothing</code> - String | ||
*<code>clothing_variation</code> - String | *<code>clothing_variation</code> - String | ||
+ | *<code>umbrella</code> - String | ||
*<code>new</code> - Boolean | *<code>new</code> - Boolean | ||
*<code>fav_style1</code> - String | *<code>fav_style1</code> - String | ||
Line 938: | Line 1,206: | ||
*<code>fav_color2</code> - String | *<code>fav_color2</code> - String | ||
*<code>hobby</code> - String | *<code>hobby</code> - String | ||
+ | *<code>life_points</code> - String | ||
+ | *<code>hobby_points</code> - String | ||
+ | *<code>wave_type</code> - String | ||
+ | *<code>bag</code> - String | ||
+ | *<code>popsicle</code> - String | ||
+ | *<code>food</code> - String | ||
+ | *<code>drink</code> - String | ||
+ | *<code>book</code> - String | ||
|} | |} | ||
| - | | - | ||
Line 1,127: | Line 1,403: | ||
| Missing rarity data (common name for rarity percentages TBD). | | Missing rarity data (common name for rarity percentages TBD). | ||
|- | |- | ||
− | | {{Table cell| | + | | {{Table cell|Green}} |
| {{Table cell|No}} | | {{Table cell|No}} | ||
− | | '''[[Special:CargoTables/ | + | | '''[[Special:CargoTables/nl_house|nl_house]]''' |
− | | {{NL|short}} villager | + | | {{NL|short}} villager homes |
| | | | ||
{| 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 16 fields}} |
|- | |- | ||
| | | | ||
− | *<code> | + | *<code>villager</code> - String |
*<code>name_sort</code> - String | *<code>name_sort</code> - String | ||
− | *<code> | + | *<code>interior_image</code> - String |
− | *<code> | + | *<code>interior_image_url</code> - String |
− | *<code> | + | *<code>exterior_image</code> - String |
− | *<code> | + | *<code>exterior_image_url</code> - String |
− | *<code> | + | *<code>wallpaper</code> - String |
− | *<code> | + | *<code>wallpaper_image</code> - String |
− | *<code> | + | *<code>wallpaper_image_url</code> - String |
− | *<code> | + | *<code>flooring</code> - String |
− | *<code> | + | *<code>flooring_image</code> - String |
− | *<code> | + | *<code>flooring_image_url</code> - String |
− | *<code> | + | *<code>music</code> - String |
− | *<code> | + | *<code>music_note</code> - String |
+ | *<code>items</code> - Text | ||
+ | *<code>notes</code> - Wikitext string | ||
|} | |} | ||
| - | | - | ||
Line 1,199: | Line 1,477: | ||
*<code>m1_time</code> - String | *<code>m1_time</code> - String | ||
*<code>m2_time</code> - String | *<code>m2_time</code> - String | ||
− | *<code>m3_time</code> - String | + | *<code>m3_time</code> - String |
*<code>m4_time</code> - String | *<code>m4_time</code> - String | ||
*<code>m5_time</code> - String | *<code>m5_time</code> - String | ||
Line 1,231: | Line 1,509: | ||
|} | |} | ||
| Missing rarity data (common name for rarity percentages TBD). | | Missing rarity data (common name for rarity percentages TBD). | ||
+ | |- | ||
+ | | {{Table cell|Yellow}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/nl_villager|nl_villager]]''' | ||
+ | | {{NL|short}} villagers | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 32 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>name</code> - String | ||
+ | *<code>name_sort</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>image_url</code> - String | ||
+ | *<code>image_nlwa</code> - String | ||
+ | *<code>image_nlwa_url</code> - String | ||
+ | *<code>pic</code> - String | ||
+ | *<code>pic_url</code> - String | ||
+ | *<code>icon</code> - String | ||
+ | *<code>icon_url</code> - String | ||
+ | *<code>birthday</code> - String | ||
+ | *<code>birthday_sort</code> - Integer | ||
+ | *<code>sign</code> - String | ||
+ | *<code>catchphrase</code> - String | ||
+ | *<code>catchphrase_note</code> - String | ||
+ | *<code>catchphrase2</code> - String | ||
+ | *<code>catchphrase2_note</code> - String | ||
+ | *<code>quote</code> - String | ||
+ | *<code>clothing</code> - String | ||
+ | *<code>umbrella</code> - String | ||
+ | *<code>new</code> - Boolean | ||
+ | *<code>nlwa</code> - Boolean | ||
+ | *<code>siblings</code> - String | ||
+ | *<code>favclothing</code> - String | ||
+ | *<code>leastfavclothing</code> - String | ||
+ | *<code>favcolor</code> - String | ||
+ | *<code>skill</code> - String | ||
+ | *<code>goal</code> - String | ||
+ | *<code>fear</code> - String | ||
+ | *<code>coffeetype</code> - String | ||
+ | *<code>milk</code> - String | ||
+ | *<code>sugar</code> - String | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Green}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/nlwa_rv|nlwa_rv]]''' | ||
+ | | {{NLWa|short}} RVs | ||
+ | | | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 16 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>name</code> - String | ||
+ | *<code>description</code> - 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>notes</code> - Wikitext string | ||
+ | |} | ||
+ | | - | ||
+ | |- | ||
+ | | {{Table cell|Gray}} | ||
+ | | {{Table cell|No}} | ||
+ | | '''[[Special:CargoTables/pc_furniture|pc_furniture]]''' | ||
+ | | {{PC|short}} furniture | ||
+ | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="mw-collapsible mw-collapsed" | ||
+ | |- | ||
+ | ! {{Colorshow|4c4c4c|Open to view 20 fields}} | ||
+ | |- | ||
+ | | | ||
+ | *<code>identifier</code> - String | ||
+ | *<code>en_name</code> - String | ||
+ | *<code>image</code> - String | ||
+ | *<code>category</code> - String | ||
+ | *<code>theme</code> - String | ||
+ | *<code>rarity</code> - String | ||
+ | *<code>buy</code> - Integer | ||
+ | *<code>sell</code> - Integer | ||
+ | *<code>unlocked</code> - String | ||
+ | *<code>availability</code> - String | ||
+ | *<code>availability_note</code> - String | ||
+ | *<code>availability_start</code> - String | ||
+ | *<code>availability_end</code> - String | ||
+ | *<code>length</code> - Integer | ||
+ | *<code>width</code> - Integer | ||
+ | *<code>conversation_piece</code> - Boolean | ||
+ | *<code>memory</code> - Boolean | ||
+ | *<code>gulliver_points</code> - Integer | ||
+ | *<code>reaction</code> - String | ||
+ | *<code>gift_group</code> - Integer | ||
+ | *<code>crafting_time</code> - Integer | ||
+ | *<code>crafting_difficulty</code> - String | ||
+ | *<code>crafting_material1</code> - String | ||
+ | *<code>crafting_material1_num</code> - Integer | ||
+ | *<code>crafting_material2</code> - String | ||
+ | *<code>crafting_material2_num</code> - Integer | ||
+ | *<code>crafting_material3</code> - String | ||
+ | *<code>crafting_material3_num</code> - Integer | ||
+ | *<code>crafting_material4</code> - String | ||
+ | *<code>crafting_material4_num</code> - Integer | ||
+ | *<code>crafting_material5</code> - String | ||
+ | *<code>crafting_material5_num</code> - Integer | ||
+ | *<code>crafting_material6</code> - String | ||
+ | *<code>crafting_material6_num</code> - Integer | ||
+ | *<code>crafting_bells</code> - Integer | ||
+ | *<code>reissued</code> - Boolean | ||
+ | *<code>reissue_crafting_time</code> - Integer | ||
+ | *<code>reissue_crafting_material1</code> - String | ||
+ | *<code>reissue_crafting_material1_num</code> - Integer | ||
+ | *<code>reissue_crafting_material2</code> - String | ||
+ | *<code>reissue_crafting_material2_num</code> - Integer | ||
+ | *<code>reissue_crafting_material3</code> - String | ||
+ | *<code>reissue_crafting_material3_num</code> - Integer | ||
+ | *<code>reissue_crafting_material4</code> - String | ||
+ | *<code>reissue_crafting_material4_num</code> - Integer | ||
+ | *<code>reissue_crafting_material5</code> - String | ||
+ | *<code>reissue_crafting_material5_num</code> - Integer | ||
+ | *<code>reissue_crafting_material6</code> - String | ||
+ | *<code>reissue_crafting_material6_num</code> - Integer | ||
+ | *<code>reissue_crafting_bells</code> - Integer | ||
+ | *<code>notes</code> - String | ||
+ | |} | ||
+ | | - | ||
|- | |- | ||
| {{Table cell|Yellow}} | | {{Table cell|Yellow}} | ||
Line 1,239: | Line 1,654: | ||
{| 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 20 fields}} |
|- | |- | ||
| | | | ||
Line 1,260: | Line 1,675: | ||
*<code>friendRewardLvl2</code> - Integer | *<code>friendRewardLvl2</code> - Integer | ||
*<code>friendRewardLvl3</code> - Integer | *<code>friendRewardLvl3</code> - Integer | ||
+ | *<code>version_added</code> - String | ||
+ | *<code>date_unlocked</code> - String | ||
|} | |} | ||
| - | | - |
Revision as of 23:35, April 9, 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 |
|
- | ||||
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_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 fossil |
|
- | ||||
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_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 |
|
- |