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

From Nookipedia, the Animal Crossing wiki
Line 22: Line 22:
 
! style="min-width:235px;"| Structure
 
! style="min-width:235px;"| Structure
 
! Notes
 
! Notes
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_art|cf_art]]'''
 +
| {{CF|short}} art
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 11 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>has_fake</code> - Boolean
 +
*<code>buy_price</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability</code> - String
 +
*<code>availability_note</code> - String
 +
*<code>authenticity</code> - String
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_bug|cf_bug]]'''
 +
| {{CF|short}} bugs
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 57 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>size</code> - String
 +
*<code>location</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<code>m1</code> - Boolean
 +
*<code>m2</code> - Boolean
 +
*<code>m3</code> - Boolean
 +
*<code>m4</code> - Boolean
 +
*<code>m5</code> - Boolean
 +
*<code>m6</code> - Boolean
 +
*<code>m7</code> - Boolean
 +
*<code>m8_1</code> - Boolean
 +
*<code>m8_2</code> - Boolean
 +
*<code>m9_1</code> - Boolean
 +
*<code>m9_2</code> - Boolean
 +
*<code>m10</code> - Boolean
 +
*<code>m11</code> - Boolean
 +
*<code>m12</code> - Boolean
 +
*<code>m1_time</code> - String
 +
*<code>m2_time</code> - String
 +
*<code>m3_time</code> - String
 +
*<code>m4_time</code> - String
 +
*<code>m5_time</code> - String
 +
*<code>m6_time</code> - String
 +
*<code>m7_time</code> - String
 +
*<code>m8_1_time</code> - String
 +
*<code>m8_2_time</code> - String
 +
*<code>m9_1_time</code> - String
 +
*<code>m9_2_time</code> - String
 +
*<code>m10_time</code> - String
 +
*<code>m11_time</code> - String
 +
*<code>m12_time</code> - String
 +
*<code>time</code> - String
 +
*<code>time_availability</code> - String
 +
*<code>time2</code> - String
 +
*<code>time2_availability</code> - String
 +
*<code>time3</code> - String
 +
*<code>time3_availability</code> - String
 +
*<code>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime_availability2</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime_availability3</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime_availability4</code> - String
 +
*<code>description</code> - Text
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Yellow}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/cf_fish|cf_fish]]'''
 +
| {{CF|short}} fish
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 56 fields}}
 +
|-
 +
|
 +
*<code>url</code> - String
 +
*<code>name</code> - String
 +
*<code>number</code> - Integer
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>description</code> - Text
 +
*<code>catchphrase</code> - String
 +
*<code>catchphrase2</code> - String
 +
*<code>location</code> - String
 +
*<code>shadow_size</code> - String
 +
*<code>fish_size</code> - String
 +
*<code>rarity</code> - String
 +
*<code>sell</code> - Integer
 +
*<code>tank_width</code> - Float
 +
*<code>tank_length</code> - Float
 +
*<code>availability</code> - String
 +
*<code>m1</code> - Boolean
 +
*<code>m2</code> - Boolean
 +
*<code>m3</code> - Boolean
 +
*<code>m4</code> - Boolean
 +
*<code>m5</code> - Boolean
 +
*<code>m6</code> - Boolean
 +
*<code>m7</code> - Boolean
 +
*<code>m8_1</code> - Boolean
 +
*<code>m8_2</code> - Boolean
 +
*<code>m9_1</code> - Boolean
 +
*<code>m9_2</code> - Boolean
 +
*<code>m10</code> - Boolean
 +
*<code>m11</code> - Boolean
 +
*<code>m12</code> - Boolean
 +
*<code>m1_time</code> - String
 +
*<code>m2_time</code> - String
 +
*<code>m3_time</code> - String
 +
*<code>m4_time</code> - String
 +
*<code>m5_time</code> - String
 +
*<code>m6_time</code> - String
 +
*<code>m7_time</code> - String
 +
*<code>m8_1_time</code> - String
 +
*<code>m8_2_time</code> - String
 +
*<code>m9_1_time</code> - String
 +
*<code>m9_2_time</code> - String
 +
*<code>m10_time</code> - String
 +
*<code>m11_time</code> - String
 +
*<code>m12_time</code> - String
 +
*<code>time</code> - String
 +
*<code>time_availability</code> - String
 +
*<code>time2</code> - String
 +
*<code>time2_availability</code> - String
 +
*<code>peaktime</code> - String
 +
*<code>peaktime_availability</code> - String
 +
*<code>peaktime2</code> - String
 +
*<code>peaktime_availability2</code> - String
 +
*<code>peaktime3</code> - String
 +
*<code>peaktime_availability3</code> - String
 +
*<code>peaktime4</code> - String
 +
*<code>peaktime_availability4</code> - String
 +
|}
 +
| -
 
|-  
 
|-  
 
| {{Table cell|Gray}}
 
| {{Table cell|Gray}}
Line 43: Line 206:
 
| -
 
| -
 
|-  
 
|-  
−
| {{Table cell|Yellow}}
+
| {{Table cell|Green}}
 
| {{Table cell|Yes}}
 
| {{Table cell|Yes}}
 
| '''[[Special:CargoTables/nh_art|nh_art]]'''
 
| '''[[Special:CargoTables/nh_art|nh_art]]'''
Line 50: Line 213:
 
{| 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 18 fields}}
+
! {{Colorshow|4c4c4c|Open to view 27 fields}}
 
|-
 
|-
 
|
 
|
Line 59: Line 222:
 
*<code>fake_image</code> - String
 
*<code>fake_image</code> - String
 
*<code>fake_image_url</code> - String
 
*<code>fake_image_url</code> - String
 +
*<code>texture</code> - String
 +
*<code>texture_url</code> - String
 +
*<code>fake_texture</code> - String
 +
*<code>fake_texture_url</code> - String
 
*<code>art_name</code> - String
 
*<code>art_name</code> - String
 
*<code>author</code> - String
 
*<code>author</code> - String
 
*<code>year</code> - String
 
*<code>year</code> - String
 
*<code>art_style</code> - String
 
*<code>art_style</code> - String
 +
*<code>art_type</code> - String
 
*<code>description</code> - Text
 
*<code>description</code> - Text
 +
*<code>theme1</code> - String
 +
*<code>theme2</code> - String
 +
*<code>theme_fake</code> - String
 
*<code>buy_price</code> - Integer
 
*<code>buy_price</code> - Integer
−
*<code>sell_price</code> - Integer
+
*<code>buy_wikitext</code> - Wikitext string
 +
*<code>sell</code> - Integer
 
*<code>availability</code> - String
 
*<code>availability</code> - String
 
*<code>availability_note</code> - String
 
*<code>availability_note</code> - String
Line 696: Line 868:
 
*<code>fav_color2</code> - String
 
*<code>fav_color2</code> - String
 
*<code>hobby</code> - String
 
*<code>hobby</code> - String
 +
|}
 +
| -
 +
|-
 +
| {{Table cell|Green}}
 +
| {{Table cell|No}}
 +
| '''[[Special:CargoTables/nl_art|nl_art]]'''
 +
| {{NL|short}} art
 +
|
 +
{| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
 +
|-
 +
! {{Colorshow|4c4c4c|Open to view 19 fields}}
 +
|-
 +
|
 +
*<code>name</code> - String
 +
*<code>image</code> - String
 +
*<code>image_url</code> - String
 +
*<code>has_fake</code> - Boolean
 +
*<code>fake_image</code> - String
 +
*<code>fake_image_url</code> - String
 +
*<code>art_name</code> - String
 +
*<code>author</code> - String
 +
*<code>year</code> - String
 +
*<code>art_style</code> - String
 +
*<code>art_type</code> - String
 +
*<code>description</code> - Text
 +
*<code>buy_price</code> - Integer
 +
*<code>sell</code> - Integer
 +
*<code>availability</code> - String
 +
*<code>availability_note</code> - String
 +
*<code>authenticity</code> - String
 +
*<code>width</code> - Float
 +
*<code>length</code> - Float
 
|}
 
|}
 
| -
 
| -

Revision as of 12:47, February 6, 2021

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)

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 Table Name Description Structure Notes
Yellow No cf_art City Folk art -
Yellow No cf_bug City Folk bugs -
Yellow No cf_fish City Folk fish -
Gray No cf_villager City Folk villagers -
Green Yes 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 -
Green Yes nh_house New Horizons villager homes (some parts used in villager endpoint) -
Green No nh_interior New Horizons wallpaper and flooring -
Green No nh_language_name New Horizons furniture translations -
Gray No nh_music New Horizons KK records -
Green No nh_photo New Horizons villager photos and posters -
Green No nh_photo_variation New Horizons villager photo customization -
Green Yes nh_recipe New Horizons DIY recipes -
Green Yes nh_sea_creature New Horizons sea creatures Missing rarity data (common name for rarity percentages TBD).
Green No nh_tool New Horizons handheld items -
Green No nh_tool_variation New Horizons handheld item variations -
Green Yes nh_villager New Horizons villagers (using in villager endpoint) -
Green No nl_art New Leaf art -
Green No nl_bug New Leaf bugs -
Green No nl_fish New Leaf fish Missing rarity data (common name for rarity percentages TBD).
Gray No nl_villager New Leaf villager preferences -
Green No nl_sea_creature New Leaf sea creatures Missing rarity data (common name for rarity percentages TBD).
Yellow No pc_villager Pocket Camp villager info and rewards Columns need renaming to match standard -
Green No pg_fossil Animal Crossing fossils -
Green No song KK Song image, audio and Animal Crossing series appearances -
Yellow No special_character Special character info and Animal Crossing series appearances -
Green Yes villager Animal Crossing series villagers -
Gray No ww_villager Wild World villager picture, quote and preferences -
Retrieved from "https://nookipedia.com/w/index.php?title=Nookipedia:Project_Database/List_of_tables&oldid=514183"