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

Revision as of 13:43, 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:42, September 8, 2020 (EDT)

	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 ^{[nb 1]} Table Name Description Structure Notes

cf_villager

City Folk villagers

Open to view 7 fields
`name` - String `name_sort` - String `favclothing` - String `leastfavclothing` - String `favgenre` - String `favseries` - String `favcolor` - String

-

nh_art

New Horizons art

Open to view 16 fields
`name` - String `image` - String `fake` - Boolean `fake_image` - String `art_name` - String `author` - String `year` - String `art_style` - String `description` - Text `buy_price` - Integer `sell_price` - Integer `availability` - String `availability_note` - String `authenticity` - String `width` - Float `length` - Float

-

nh_bug

New Horizons bugs

Open to view 41 fields

url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
location - String
rarity - String
total_catch - Integer
sell_nook - Integer
sell_flick - Integer
tank_width - Float
tank_length - Float

Missing rarity data (common name for rarity percentages TBD).

nh_clothing

New Horizons clothing

Open to view 26 fields

identifier - String
en_name - String
category - String
category_sort - Integer
style1 - String
style2 - String
label1 - String
label2 - String
label3 - String
label4 - String
label5 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
vill_equip - Boolean
version_added - String
unlocked - Boolean
notes - String

-

nh_clothing_variation

New Horizons clothing variations

Open to view 6 fields
`identifier` - String `en_name` - String `variation` - String `image` - String `color1` - String `color2` - String

-

nh_fish

New Horizons fish

Open to view 48 fields

url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
catchphrase3 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
time_n_availability - String
time_s_availability - String
time2 - String
time2_n_availability - String
time2_s_availability - String
location - String
shadow_size - String
rarity - String
total_catch - Integer
sell_nook - Integer
sell_cj - Integer
tank_width - Float
tank_length - Float

Missing rarity data (common name for rarity percentages TBD).

nh_furniture

New Horizons furniture

Open to view 41 fields

identifier - String
en_name - String
category - String
category_sort - Integer
item_series - String
item_set - String
theme1 - String
theme2 - String
tag - String
hha_base - Integer
function1 - String
function2 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
custom_pattern_part - String
grid_size - String
length - Float
width - Float
height - Float
outdoor - Boolean
interactable - Boolean
animated - Boolean
sound - Boolean
music - Boolean
lighting - Boolean
door_decor - Boolean
version_added - String
unlocked - Boolean
notes - String

-

nh_furniture_variation

New Horizons furniture variations

Open to view 7 fields
`identifier` - String `en_name` - String `variation` - String `pattern` - String `image` - String `color1` - String `color2` - String

-

nh_house

New Horizons villager homes (some parts used in villager endpoint)

Open to view 15 fields
`villager` - String `interior_image` - String `interior_image_url` - String `exterior_image` - String `exterior_image_url` - String `wallpaper` - String `wallpaper_image` - String `wallpaper_image_url` - String `flooring` - String `flooring_image` - String `flooring_image_url` - String `music` - String `music_note` - String `items` - Text `notes` - Wikitext string

-

nh_interior

New Horizons wallpaper and flooring

Open to view 25 fields

identifier - String
en_name - String
image - String
category - String
item_series - String
theme1 - String
theme2 - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
grid_size - String
vfx - Boolean
color1 - String
color2 - String
version_added - String
unlocked - Boolean
notes - String

-

nh_language_name

New Horizons furniture translations

Open to view 15 fields
`identifier` - String `en_name` - String `de_name` - String `es_name` - String `esl_name` - String `fr_name` - String `frq_name` - String `it_name` - String `ja_name` - String `ko_name` - String `nl_name` - String `ru_name` - String `zh_name` - String `zht_name` - String `notes` - String

-

nh_music

New Horizons KK records

Open to view 23 fields

identifier - String
en_name - String
image - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
grid_size - String
length - Float
width - Float
height - Float
color1 - String
color2 - String
version_added - String
unlocked - Boolean
notes - String

-

nh_photo

New Horizons villager photos and posters

Open to view 25 fields

identifier - String
en_name - String
category - String
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
grid_size - String
length - Float
width - Float
height - Float
interactable - Boolean
version_added - String
unlocked - Boolean
notes - String

-

nh_photo_variation

New Horizons villager photo customization

Open to view 6 fields
`identifier` - String `en_name` - String `variation` - String `image` - String `color1` - String `color2` - String

-

nh_recipe

New Horizons DIY recipes

Open to view 30 fields

identifier - String
en_name - String
image - String
serial_id - Integer
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Int
recipes_to_unlock - Int
diy_availability1 - String
diy_availability1_note - String
diy_availability2 - String
diy_availability2_note - String
materials - String
material1 - String
material1_num - Integer
material2 - String
material2_num - Integer
material3 - String
material3_num - Integer
material4 - String
material4_num - Integer
material5 - String
material5_num - Integer
material6 - String
material6_num - Integer
notes - String

-

nh_sea_creature

New Horizons sea creatures

Open to view 41 fields

url - String
name - String
number - Integer
image - String
image_url - String
catchphrase - String
catchphrase2 - String
n_availability - String
n_m1 - Boolean
n_m2 - Boolean
n_m3 - Boolean
n_m4 - Boolean
n_m5 - Boolean
n_m6 - Boolean
n_m7 - Boolean
n_m8 - Boolean
n_m9 - Boolean
n_m10 - Boolean
n_m11 - Boolean
n_m12 - Boolean
s_availability - String
s_m1 - Boolean
s_m2 - Boolean
s_m3 - Boolean
s_m4 - Boolean
s_m5 - Boolean
s_m6 - Boolean
s_m7 - Boolean
s_m8 - Boolean
s_m9 - Boolean
s_m10 - Boolean
s_m11 - Boolean
s_m12 - Boolean
time - String
shadow_size - String
shadow_movement - String
rarity - String
total_catch - Integer
sell_nook - Integer
tank_width - Float
tank_length - Float

Missing rarity data (common name for rarity percentages TBD).

nh_tool

New Horizons handheld items

Open to view 24 fields

identifier - String
en_name - String
item_set - Integer
uses - String
hha_base - Integer
buy1_price - Integer
buy1_currency - String
buy1_wikitext - Wikitext string
buy2_price - Integer
buy2_currency - String
buy2_wikitext - Wikitext string
sell - Integer
availability1 - String
availability1_note - String
availability2 - String
availability2_note - String
availability3 - String
availability3_note - String
customizable - Boolean
custom_kits - Integer
custom_body_part - String
version_added - String
unlocked - Boolean
notes - String

-

nh_tool_variation

New Horizons handheld item variations

Open to view 6 fields
`identifier` - String `en_name` - String `variation` - String `image` - String `color1` - String `color2` - String

-

nh_villager

New Horizons villagers (using in villager endpoint)

Open to view 25 fields

url - String
name - String
image - String
image_url - String
photo - String
photo_url - String
icon - String
icon_url - String
quote - String
species - String
gender - String
personality - String
sub_personality - String
birthday - String
birthday_sort - Integer
sign - String
catchphrase - String
clothing - String
clothing_variation - String
new - Boolean
fav_style1 - String
fav_style2 - String
fav_color1 - String
fav_color2 - String
hobby - String

-

nl_villager

New Leaf villager preferences

Open to view 14 fields
`name` - String `name_sort` - String `pic` - String `quote` - String `siblings` - String `skill` - String `goal` - String `fear` - String `favclothing` - String `leastfavclothing` - String `favcolor` - String `coffeetype` - String `milk` - String `sugar` - String

-

pc_villager

Pocket Camp villager info and rewards

Open to view 18 fields

name - String
name_sort - String
image - String
theme - String
material - String
description - Text
friendshipLevel - Integer
unlockmode - String
furniture1 - String
furniture2 - String
furniture3 - String
furniture4 - String
furniture5 - String
friendReward1 - String
friendReward3 - String
friendRewardLvl1 - Integer
friendRewardLvl2 - Integer
friendRewardLvl3 - Integer

-

song

KK Song image, audio and Animal Crossing series appearances

Open to view 18 fields
`url` - String `name` - String `name_sort` - String `order_number` - Integer `image` - String `image_url` - String `aircheck` - String `aircheck_url` - String `live` - String `live_url` - String `mood` - String `dnm` - Boolean `ac` - Boolean `e_plus` - Boolean `ww` - Boolean `cf` - Boolean `nl` - Boolean `nh` - Boolean

-

special_character

Special character info and Animal Crossing series appearances

Open to view 25 fields

url - String
name - String
name_sort - String
alt_name - String
ID - String
image - String
image_url - String
species - String
gender - String
gender_japan - String
birthday - String
birthday_sort - Integer
sign - String
speciespage_debut - String
dnm - Boolean
ac - Boolean
e_plus - Boolean
ww - Boolean
cf - Boolean
nl - Boolean
wa - Boolean
nh - Boolean
film - Boolean
hhd - Boolean
pc - Boolean

-

villager

Animal Crossing series villagers

Open to view 37 fields

url - String
name - String
name_sort - String
alt_name - String
titlecolor - String
textcolor - String
id - String
image - String
image_url - String
species - String
personality - String
prev_personality - String
gender - String
birthday - String
birthday_month - String
birthday_day - Integer
birthday_sort - Integer
sign - String
quote - String
phrase - String
prev_phrase - String
prev_phrase2 - String
clothing - String
clothing_nh_var - String
islander - Boolean
debut - String
dnm - Boolean
ac - Boolean
e_plus - Boolean
ww - Boolean
cf - Boolean
nl - Boolean
wa - Boolean
nh - Boolean
film - Boolean
hhd - Boolean
pc - Boolean

-

ww_villager

Wild World villager picture, quote and preferences

Open to view 6 fields
`name` - String `name_sort` - String `pic` - String `quote - String` `favclothing - String leastfavclothing - String`

-

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

[nb 1]

@@ Line 1: / Line 1: @@
 :''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:18, September 8, 2020 (EDT)
+The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 13:42, September 8, 2020 (EDT)
 {|
@@ Line 319: / Line 319: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|Yes}}
 | '''[[Special:CargoTables/nh_house|nh_house]]'''
-| {{NH|short}} villager homes
+| {{NH|short}} villager homes (some parts used in villager endpoint)
 |
 {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
@@ Line 347: / Line 347: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_interior|nh_interior]]'''
 | {{NH|short}} wallpaper and flooring
@@ Line 385: / Line 385: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_language_name|nh_language_name]]'''
 | {{NH|short}} furniture translations
@@ Line 413: / Line 413: @@
 | -
 |-
-| Unknown
+| {{Table cell|Dev}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_music|nh_music]]'''
 | {{NH|short}} KK records
@@ Line 449: / Line 449: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_photo|nh_photo]]'''
 | {{NH|short}} villager photos and posters
@@ Line 487: / Line 487: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_photo_variation|nh_photo_variation]]'''
 | {{NH|short}} villager photo customization
@@ Line 506: / Line 506: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_recipe|nh_recipe]]'''
 | {{NH|short}} DIY recipes
@@ Line 603: / Line 603: @@
 | Missing rarity data (common name for rarity percentages TBD).
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_tool|nh_tool]]'''
 | {{NH|short}} handheld items
@@ Line 640: / Line 640: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nh_tool_variation|nh_tool_variation]]'''
 | {{NH|short}} handheld item variations
@@ Line 697: / Line 697: @@
 | -
 |-
-| Unknown
+| {{Table cell|Dev}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/nl_villager|nl_villager]]'''
 | {{NL|short}} villager preferences
@@ Line 724: / Line 724: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/pc_villager|pc_villager]]'''
 | {{PC|short}} villager info and rewards
@@ Line 755: / Line 755: @@
 | -
 |-
-| Unknown
+| {{Table cell|Green}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/song|song]]'''
 | KK Song image, audio and {{SER}} appearances
@@ Line 786: / Line 786: @@
 | -
 |-
-| Unknown
+| {{Table cell|Yellow}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/special_character|special_character]]'''
 | Special character info and {{SER}} appearances
@@ Line 874: / Line 874: @@
 | -
 |-
-| Unknown
+| {{Table cell|Dev}}
-| Unknown
+| {{Table cell|No}}
 | '''[[Special:CargoTables/ww_villager|ww_villager]]'''
 | {{WW|short}} villager picture, quote and preferences

Anonymous

Search

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

Namespaces

More

Page actions

Revision as of 13:43, September 8, 2020

Navigation

Navigation

New Horizons

Community

Contents

Maintenance

Wiki tools

Wiki tools

Anonymous

Search

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

Revision as of 13:43, September 8, 2020

Navigation

Wiki tools

Page actions

⧼Advertisement⧽

Hidden categories