Difference between revisions of "Nookipedia:Project Database/List of tables"

From Nookipedia, the Animal Crossing wiki
(Moving list here to reduce clutter on the main page)
 
(Adding sub-page link at top, adding remaining table data. Status/API check needed.)
Line 1: Line 1:
−
The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 00:34, September 7, 2020 (EDT) - ''incomplete''
+
:''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:''' 13:14, September 8, 2020 (EDT)
  
 
{|
 
{|
Line 315: Line 316:
 
*<code>color1</code> - String
 
*<code>color1</code> - String
 
*<code>color2</code> - String
 
*<code>color2</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_house|nh_house]]'''
 +
| {{NH|short}} villager homes
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 15 fields}}
 +
|-
 +
|
 +
*<code>villager</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
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_interior|nh_interior]]'''
 +
| {{NH|short}} wallpaper and flooring
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 25 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>image</code> - String
 +
*<code>category</code> - String
 +
*<code>item_series</code> - String
 +
*<code>theme1</code> - String
 +
*<code>theme2</code> - String
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>buy2_price</code> - Integer
 +
*<code>buy2_currency</code> - String
 +
*<code>buy2_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>grid_size</code> - String
 +
*<code>vfx</code> - Boolean
 +
*<code>color1</code> - String
 +
*<code>color2</code> - String
 +
*<code>version_added</code> - String
 +
*<code>unlocked</code> - Boolean
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_language_name|nh_language_name]]'''
 +
| {{NH|short}} furniture translations
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 15 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>de_name</code> - String
 +
*<code>es_name</code> - String
 +
*<code>esl_name</code> - String
 +
*<code>fr_name</code> - String
 +
*<code>frq_name</code> - String
 +
*<code>it_name</code> - String
 +
*<code>ja_name</code> - String
 +
*<code>ko_name</code> - String
 +
*<code>nl_name</code> - String
 +
*<code>ru_name</code> - String
 +
*<code>zh_name</code> - String
 +
*<code>zht_name</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_music|nh_music]]'''
 +
| {{NH|short}} KK records
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 23 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>image</code> - String
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>buy2_price</code> - Integer
 +
*<code>buy2_currency</code> - String
 +
*<code>buy2_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>grid_size</code> - String
 +
*<code>length</code> - Float
 +
*<code>width</code> - Float
 +
*<code>height</code> - Float
 +
*<code>color1</code> - String
 +
*<code>color2</code> - String
 +
*<code>version_added</code> - String
 +
*<code>version_unlocked</code> - String
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_photo|nh_photo]]'''
 +
| {{NH|short}} villager photos and posters
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 25 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>category</code> - String
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>buy2_price</code> - Integer
 +
*<code>buy2_currency</code> - String
 +
*<code>buy2_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 +
*<code>availability1</code> - String
 +
*<code>availability1_note</code> - String
 +
*<code>availability2</code> - String
 +
*<code>availability2_note</code> - String
 +
*<code>customizable</code> - Boolean
 +
*<code>custom_kits</code> - Integer
 +
*<code>custom_body_part</code> - String
 +
*<code>grid_size</code> - String
 +
*<code>length</code> - Float
 +
*<code>width</code> - Float
 +
*<code>height</code> - Float
 +
*<code>interactable</code> - Boolean
 +
*<code>version_added</code> - String
 +
*<code>unlocked</code> - Boolean
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]'''
 +
| {{NH|short}} villager photo customization
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 6 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>variation</code> - String
 +
*<code>image</code> - String
 +
*<code>color1</code> - String
 +
*<code>color2</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_recipe|nh_recipe]]'''
 +
| {{NH|short}} DIY recipes
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 30 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>image</code> - String
 +
*<code>serial_id</code> - Integer
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>buy2_price</code> - Integer
 +
*<code>buy2_currency</code> - String
 +
*<code>buy2_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Int
 +
*<code>recipes_to_unlock</code> - Int
 +
*<code>diy_availability1</code> - String
 +
*<code>diy_availability1_note</code> - String
 +
*<code>diy_availability2</code> - String
 +
*<code>diy_availability2_note</code> - String
 +
*<code>materials</code> - String
 +
*<code>material1</code> - String
 +
*<code>material1_num</code> - Integer
 +
*<code>material2</code> - String
 +
*<code>material2_num</code> - Integer
 +
*<code>material3</code> - String
 +
*<code>material3_num</code> - Integer
 +
*<code>material4</code> - String
 +
*<code>material4_num</code> - Integer
 +
*<code>material5</code> - String
 +
*<code>material5_num</code> - Integer
 +
*<code>material6</code> - String
 +
*<code>material6_num</code> - Integer
 +
*<code>notes</code> - String
 
|}
 
|}
 
| -
 
| -
Line 371: Line 602:
 
|}
 
|}
 
| Missing rarity data (common name for rarity percentages TBD).
 
| Missing rarity data (common name for rarity percentages TBD).
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_tool|nh_tool]]'''
 +
| {{NH|short}} handheld items
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 24 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>item_set</code> - Integer
 +
*<code>uses</code> - String
 +
*<code>hha_base</code> - Integer
 +
*<code>buy1_price</code> - Integer
 +
*<code>buy1_currency</code> - String
 +
*<code>buy1_wikitext</code> - Wikitext string
 +
*<code>buy2_price</code> - Integer
 +
*<code>buy2_currency</code> - String
 +
*<code>buy2_wikitext</code> - Wikitext string
 +
*<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>customizable</code> - Boolean
 +
*<code>custom_kits</code> - Integer
 +
*<code>custom_body_part</code> - String
 +
*<code>version_added</code> - String
 +
*<code>unlocked</code> - Boolean
 +
*<code>notes</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]'''
 +
| {{NH|short}} handheld item variations
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 6 fields}}
 +
|-
 +
|
 +
*<code>identifier</code> - String
 +
*<code>en_name</code> - String
 +
*<code>variation</code> - String
 +
*<code>image</code> - String
 +
*<code>color1</code> - String
 +
*<code>color2</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|Yes}}
 +
| '''[[Special:CargoTables/nh_villager|nh_villager]]'''
 +
| {{NH|short}} villagers (using in villager endpoint)
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 25 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>photo</code> - String
 +
*<code>photo_url</code> - String
 +
*<code>icon</code> - String
 +
*<code>icon_url</code> - String
 +
*<code>quote</code> - String
 +
*<code>species</code> - String
 +
*<code>gender</code> - String
 +
*<code>personality</code> - String
 +
*<code>sub_personality</code> - String
 +
*<code>birthday</code> - String
 +
*<code>birthday_sort</code> - Integer
 +
*<code>sign</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>clothing</code> - String
 +
*<code>clothing_variation</code> - String
 +
*<code>new</code> - Boolean
 +
*<code>fav_style1</code> - String
 +
*<code>fav_style2</code> - String
 +
*<code>fav_color1</code> - String
 +
*<code>fav_color2</code> - String
 +
*<code>hobby</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/nl_villager|nl_villager]]'''
 +
| {{NL|short}} villager preferences
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 14 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>name_sort</code> - String
 +
*<code>pic</code> - String
 +
*<code>quote</code> - String
 +
*<code>siblings</code> - String
 +
*<code>skill</code> - String
 +
*<code>goal</code> - String
 +
*<code>fear</code> - String
 +
*<code>favclothing</code> - String
 +
*<code>leastfavclothing</code> - String
 +
*<code>favcolor</code> - String
 +
*<code>coffeetype</code> - String
 +
*<code>milk</code> - String
 +
*<code>sugar</code> - String
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/pc_villager|pc_villager]]'''
 +
| {{PC|short}} villager info and rewards
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 18 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>name_sort</code> - String
 +
*<code>image</code> - String
 +
*<code>theme</code> - String
 +
*<code>material</code> - String
 +
*<code>description</code> - Text
 +
*<code>friendshipLevel</code> - Integer
 +
*<code>unlockmode</code> - String
 +
*<code>furniture1</code> - String
 +
*<code>furniture2</code> - String
 +
*<code>furniture3</code> - String
 +
*<code>furniture4</code> - String
 +
*<code>furniture5</code> - String
 +
*<code>friendReward1</code> - String
 +
*<code>friendReward3</code> - String
 +
*<code>friendRewardLvl1</code> - Integer
 +
*<code>friendRewardLvl2</code> - Integer
 +
*<code>friendRewardLvl3</code> - Integer
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/song|song]]'''
 +
| KK Song image, audio and {{SER}} appearances
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible 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
 +
|}
 +
| -
 +
|-
 +
| Unknown
 +
| Unknown
 +
| '''[[Special:CargoTables/special_character|special_character]]'''
 +
| Special character info and {{SER}} appearances
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 25 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>species</code> - String
 +
*<code>gender</code> - String
 +
*<code>gender_japan</code> - String
 +
*<code>birthday</code> - String
 +
*<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}}
Line 422: Line 874:
 
| -
 
| -
 
|-  
 
|-  
−
| {{Table cell|Green}}
+
| Unknown
−
| {{Table cell|Yes}}
+
| Unknown
−
| '''[[Special:CargoTables/nh_villager|nh_villager]]'''
+
| '''[[Special:CargoTables/ww_villager|ww_villager]]'''
−
| {{NH|short}} villagers (using in villager endpoint)
+
| {{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="collapsible collapsed"
 
|-
 
|-
−
! {{Colorshow|4c4c4c|Open to view 25 fields}}
+
! {{Colorshow|4c4c4c|Open to view 6 fields}}
 
|-
 
|-
 
|
 
|
−
*<code>url</code> - String
 
 
*<code>name</code> - String
 
*<code>name</code> - String
−
*<code>image</code> - String
+
*<code>name_sort</code> - String
−
*<code>image_url</code> - String
+
*<code>pic</code> - String
−
*<code>photo</code> - String
+
*<code>quote - String
−
*<code>photo_url</code> - String
+
*<code>favclothing</code> - String
−
*<code>icon</code> - String
+
*<code>leastfavclothing</code> - String
−
*<code>icon_url</code> - String
 
−
*<code>quote</code> - String
 
−
*<code>species</code> - String
 
−
*<code>gender</code> - String
 
−
*<code>personality</code> - String
 
−
*<code>sub_personality</code> - String
 
−
*<code>birthday</code> - String
 
−
*<code>birthday_sort</code> - Integer
 
−
*<code>sign</code> - String
 
−
*<code>catchphrase</code> - String
 
−
*<code>clothing</code> - String
 
−
*<code>clothing_variation</code> - String
 
−
*<code>new</code> - Boolean
 
−
*<code>fav_style1</code> - String
 
−
*<code>fav_style2</code> - String
 
−
*<code>fav_color1</code> - String
 
−
*<code>fav_color2</code> - String
 
−
*<code>hobby</code> - String
 
 
|}
 
|}
 
| -
 
| -
 
|}
 
|}

Revision as of 13:14, September 8, 2020

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: 13:14, September 8, 2020 (EDT)

Green 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.
Yellow Beta: This table is approaching completion. Structure is near finalized, and/or nearly all data has been populated.
Gray 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 [nb 1] Table Name Description Structure Notes
Gray No cf_villager City Folk villagers -
Yellow No nh_art New Horizons art -
Green Yes nh_bug New Horizons bugs Missing rarity data (common name for rarity percentages TBD).
Yellow No nh_clothing New Horizons clothing -
Green No nh_clothing_variation New Horizons clothing variations -
Green Yes nh_fish New Horizons fish Missing rarity data (common name for rarity percentages TBD).
Green No nh_furniture New Horizons furniture -
Green No nh_furniture_variation New Horizons furniture variations -
Unknown Unknown nh_house New Horizons villager homes -
Unknown Unknown nh_interior New Horizons wallpaper and flooring -
Unknown Unknown nh_language_name New Horizons furniture translations -
Unknown Unknown nh_music New Horizons KK records -
Unknown Unknown nh_photo New Horizons villager photos and posters -
Unknown Unknown nh_photo_variation New Horizons villager photo customization -
Unknown Unknown nh_recipe New Horizons DIY recipes -
Green Yes nh_sea_creature New Horizons sea creatures Missing rarity data (common name for rarity percentages TBD).
Unknown Unknown nh_tool New Horizons handheld items -
Unknown Unknown nh_tool_variation New Horizons handheld item variations -
Green Yes nh_villager New Horizons villagers (using in villager endpoint) -
Unknown Unknown nl_villager New Leaf villager preferences -
Unknown Unknown pc_villager Pocket Camp villager info and rewards -
Unknown Unknown song KK Song image, audio and Animal Crossing series appearances -
Unknown Unknown special_character Special character info and Animal Crossing series appearances -
Green Yes villager Animal Crossing series villagers -
Unknown Unknown ww_villager Wild World villager picture, quote and preferences -


Cite error: <ref> tags exist for a group named "nb", but no corresponding <references group="nb"/> tag was found

Retrieved from "https://nookipedia.com/w/index.php?title=Nookipedia:Project_Database/List_of_tables&oldid=386548"