Nookipedia:Project Database/List of tables

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	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	Columns need renaming to match standard 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	-