Difference between revisions of "Nookipedia:Project Database/List of tables"
From Nookipedia, the Animal Crossing wiki
PanchamBro (talk | contribs) |
PanchamBro (talk | contribs) |
||
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| | + | | {{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 | + | ! {{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> | + | *<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)
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_art | City Folk art |
|
- | ||||
cf_bug | City Folk bugs |
|
- | ||||
cf_fish | City Folk fish |
|
- | ||||
cf_villager | City Folk villagers |
|
- | ||||
nh_art | New Horizons art |
|
- | ||||
nh_bug | New Horizons bugs |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_clothing | New Horizons clothing |
|
- | ||||
nh_clothing_variation | New Horizons clothing variations |
|
- | ||||
nh_fish | New Horizons fish |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_furniture | New Horizons furniture |
|
- | ||||
nh_furniture_variation | New Horizons furniture variations |
|
- | ||||
nh_house | New Horizons villager homes (some parts used in villager endpoint) |
|
- | ||||
nh_interior | New Horizons wallpaper and flooring |
|
- | ||||
nh_language_name | New Horizons furniture translations |
|
- | ||||
nh_music | New Horizons KK records |
|
- | ||||
nh_photo | New Horizons villager photos and posters |
|
- | ||||
nh_photo_variation | New Horizons villager photo customization |
|
- | ||||
nh_recipe | New Horizons DIY recipes |
|
- | ||||
nh_sea_creature | New Horizons sea creatures |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nh_tool | New Horizons handheld items |
|
- | ||||
nh_tool_variation | New Horizons handheld item variations |
|
- | ||||
nh_villager | New Horizons villagers (using in villager endpoint) |
|
- | ||||
nl_art | New Leaf art |
|
- | ||||
nl_bug | New Leaf bugs |
|
- | ||||
nl_fish | New Leaf fish |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
nl_villager | New Leaf villager preferences |
|
- | ||||
nl_sea_creature | New Leaf sea creatures |
|
Missing rarity data (common name for rarity percentages TBD). | ||||
pc_villager | Pocket Camp villager info and rewards | Columns need renaming to match standard
|
- | ||||
pg_fossil | Animal Crossing fossils |
|
- | ||||
song | KK Song image, audio and Animal Crossing series appearances |
|
- | ||||
special_character | Special character info and Animal Crossing series appearances |
|
- | ||||
villager | Animal Crossing series villagers |
|
- | ||||
ww_villager | Wild World villager picture, quote and preferences |
|
- |