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: 23:35, April 9, 2021 (EST)


 * 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
 * amiibo_card
 * Amiibo cards
 * cf_art
 * art
 * Missing art textures
 * cf_bug
 * bugs
 * cf_fish
 * fish
 * cf_house
 * villager homes (some parts used in villager endpoint)
 * cf_villager
 * 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
 * art
 * nh_bug
 * bugs
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_clothing
 * clothing
 * Needs populating with the new data. (Integers should be replaced with booleans)
 * nh_clothing_variation
 * clothing variations
 * nh_fish
 * fish
 * Missing rarity data (common name for rarity percentages TBD). Needs description filling.
 * nh_fossil
 * fossils
 * nh_fossil_group
 * fossil groups
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_house
 * villager homes (some parts used in villager endpoint)
 * nh_interior
 * wallpaper and flooring
 * nh_item
 * other items
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * 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_bug
 * bugs
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_clothing
 * clothing
 * Needs populating with the new data. (Integers should be replaced with booleans)
 * nh_clothing_variation
 * clothing variations
 * nh_fish
 * fish
 * Missing rarity data (common name for rarity percentages TBD). Needs description filling.
 * nh_fossil
 * fossils
 * nh_fossil_group
 * fossil groups
 * nh_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_house
 * villager homes (some parts used in villager endpoint)
 * nh_interior
 * wallpaper and flooring
 * nh_item
 * other items
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * 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_furniture
 * furniture
 * nh_furniture_variation
 * furniture variations
 * nh_house
 * villager homes (some parts used in villager endpoint)
 * nh_interior
 * wallpaper and flooring
 * nh_item
 * other items
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * 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_item
 * other items
 * nh_language_name
 * furniture translations
 * nh_music
 * KK records
 * nh_photo
 * villager photos and posters
 * 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_music
 * KK records
 * nh_photo
 * villager photos and posters
 * 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
 * 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_sea_creature
 * sea creatures
 * Missing rarity data (common name for rarity percentages TBD).
 * nh_tool
 * handheld items
 * nh_tool_variation
 * handheld item variations
 * nh_tool
 * handheld items
 * nh_tool_variation
 * handheld item variations
 * handheld items
 * nh_tool_variation
 * handheld item variations
 * nh_tool_variation
 * handheld item variations
 * nh_tool_variation
 * handheld item variations
 * handheld item variations


 * nh_villager
 * villagers (using in villager endpoint)
 * nl_art
 * art
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_art
 * art
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_bug
 * bugs
 * nl_fish
 * fish
 * nl_fish
 * fish
 * nl_fish
 * fish
 * fish


 * Missing rarity data (common name for rarity percentages TBD).
 * nl_house
 * villager homes
 * nl_sea_creature
 * sea creatures
 * Missing rarity data (common name for rarity percentages TBD).
 * nl_villager
 * villagers
 * nlwa_rv
 * RVs
 * nl_sea_creature
 * sea creatures
 * Missing rarity data (common name for rarity percentages TBD).
 * nl_villager
 * villagers
 * nlwa_rv
 * RVs
 * nl_villager
 * villagers
 * nlwa_rv
 * RVs
 * nlwa_rv
 * RVs
 * nlwa_rv
 * RVs
 * nlwa_rv
 * RVs


 * pc_furniture
 * furniture
 * pc_villager
 * villager info and rewards
 * Columns need renaming to match standard
 * pg_fossil
 * fossils
 * song
 * K.K. Slider song cover, audio, and appearances
 * special_character
 * Special character info and appearances
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * pg_fossil
 * fossils
 * song
 * K.K. Slider song cover, audio, and appearances
 * special_character
 * Special character info and appearances
 * villager
 * villagers
 * ww_villager
 * villager picture, quote and preferences
 * }
 * 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
 * }
 * }
 * }