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)


 * A full up-to-date list of tables (and their associated declare/attachment templates) is available at Special:CargoTables.

{| class="wikitable sortable" ! Status ! API ! Table Name ! style="width:15%"|Description ! style="min-width:235px;"| Structure ! Notes
 * cf_villager
 * villagers
 * nh_art
 * art
 * nh_bug
 * bugs
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_clothing
 * clothing
 * nh_clothing_variation
 * clothing variations
 * nh_fish
 * fish
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * bugs
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_clothing
 * clothing
 * nh_clothing_variation
 * clothing variations
 * nh_fish
 * fish
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_clothing_variation
 * clothing variations
 * nh_fish
 * fish
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_furniture_variation
 * furniture variations
 * nh_furniture_variation
 * furniture variations
 * furniture variations


 * nh_house
 * villager homes (some parts used in villager endpoint)
 * nh_interior
 * wallpaper and flooring
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * nh_photo_variation
 * villager photo customization
 * wallpaper and flooring
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * nh_photo_variation
 * villager photo customization
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * nh_photo_variation
 * villager photo customization
 * nh_photo
 * villager photos and posters
 * nh_photo_variation
 * villager photo customization
 * nh_photo
 * villager photos and posters
 * nh_photo_variation
 * villager photo customization
 * nh_photo_variation
 * villager photo customization
 * nh_photo_variation
 * villager photo customization
 * nh_photo_variation
 * villager photo customization


 * nh_recipe
 * DIY recipes
 * nh_sea_creature
 * sea creatures
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_tool
 * handheld items
 * nh_tool_variation
 * handheld item variations
 * nh_villager
 * villagers (using in villager endpoint)
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nh_tool
 * handheld items
 * nh_tool_variation
 * handheld item variations
 * nh_villager
 * villagers (using in villager endpoint)
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nh_tool_variation
 * handheld item variations
 * nh_villager
 * villagers (using in villager endpoint)
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * villagers (using in villager endpoint)
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_fish
 * fish
 * nl_fish
 * fish
 * nl_fish
 * fish


 * Missing rarity data (common name for rarity percentages TBD).
 * nl_villager
 * villager preferences
 * nl_sea_creature
 * sea creatures
 * pc_villager
 * villager info and rewards
 * Columns need renaming to match standard
 * pg_fossil
 * fossils
 * song
 * KK Song image, audio and appearances
 * special_character
 * Special character info and appearances
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * villager info and rewards
 * Columns need renaming to match standard
 * pg_fossil
 * fossils
 * song
 * KK Song image, audio and appearances
 * special_character
 * Special character info and appearances
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * song
 * KK Song image, audio and appearances
 * special_character
 * Special character info and appearances
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * ww_villager
 * villager picture, quote and preferences
 * }
 * villager picture, quote and preferences
 * }
 * }
 * }