|
|
Line 29: |
Line 29: |
| | | |
| ===List of tables=== | | ===List of tables=== |
− | The following table lists tables, descriptions, and their status. Note that this table is manually updated. '''Last update:''' 00:34, September 7, 2020 (EDT) - ''incomplete''
| + | {{Nookipedia:Project Database/List of tables}} |
− | | |
− | {|
| |
− | |-
| |
− | | {{Table cell|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.
| |
− | |-
| |
− | | {{Table cell|Yellow}}
| |
− | | '''Beta''': This table is approaching completion. Structure is near finalized, and/or nearly all data has been populated.
| |
− | |-
| |
− | | {{Table cell|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]]'''.''
| |
− | {| class="wikitable sortable"
| |
− | |-
| |
− | ! Status
| |
− | ! API {{note|A check in the API column indicates that the table is queried via [https://api.nookipedia.com api.nookipedia.com]}}
| |
− | ! Table Name
| |
− | ! style="width:15%"|Description
| |
− | ! style="min-width:235px;"| Structure
| |
− | ! Notes
| |
− | |-
| |
− | | {{Table cell|Gray}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/cf_villager|cf_villager]]'''
| |
− | | {{CF|short}} villagers
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 7 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>name</code> - String
| |
− | *<code>name_sort</code> - String
| |
− | *<code>favclothing</code> - String
| |
− | *<code>leastfavclothing</code> - String
| |
− | *<code>favgenre</code> - String
| |
− | *<code>favseries</code> - String
| |
− | *<code>favcolor</code> - String
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Yellow}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/nh_art|nh_art]]'''
| |
− | | {{NH|short}} art
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 16 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>name</code> - String
| |
− | *<code>image</code> - String
| |
− | *<code>fake</code> - Boolean
| |
− | *<code>fake_image</code> - String
| |
− | *<code>art_name</code> - String
| |
− | *<code>author</code> - String
| |
− | *<code>year</code> - String
| |
− | *<code>art_style</code> - String
| |
− | *<code>description</code> - Text
| |
− | *<code>buy_price</code> - Integer
| |
− | *<code>sell_price</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|Green}}
| |
− | | {{Table cell|Yes}}
| |
− | | '''[[Special:CargoTables/nh_bug|nh_bug]]'''
| |
− | | {{NH|short}} bugs
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 41 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>n_availability</code> - String
| |
− | *<code>n_m1</code> - Boolean
| |
− | *<code>n_m2</code> - Boolean
| |
− | *<code>n_m3</code> - Boolean
| |
− | *<code>n_m4</code> - Boolean
| |
− | *<code>n_m5</code> - Boolean
| |
− | *<code>n_m6</code> - Boolean
| |
− | *<code>n_m7</code> - Boolean
| |
− | *<code>n_m8</code> - Boolean
| |
− | *<code>n_m9</code> - Boolean
| |
− | *<code>n_m10</code> - Boolean
| |
− | *<code>n_m11</code> - Boolean
| |
− | *<code>n_m12</code> - Boolean
| |
− | *<code>s_availability</code> - String
| |
− | *<code>s_m1</code> - Boolean
| |
− | *<code>s_m2</code> - Boolean
| |
− | *<code>s_m3</code> - Boolean
| |
− | *<code>s_m4</code> - Boolean
| |
− | *<code>s_m5</code> - Boolean
| |
− | *<code>s_m6</code> - Boolean
| |
− | *<code>s_m7</code> - Boolean
| |
− | *<code>s_m8</code> - Boolean
| |
− | *<code>s_m9</code> - Boolean
| |
− | *<code>s_m10</code> - Boolean
| |
− | *<code>s_m11</code> - Boolean
| |
− | *<code>s_m12</code> - Boolean
| |
− | *<code>time</code> - String
| |
− | *<code>location</code> - String
| |
− | *<code>rarity</code> - String
| |
− | *<code>total_catch</code> - Integer
| |
− | *<code>sell_nook</code> - Integer
| |
− | *<code>sell_flick</code> - Integer
| |
− | *<code>tank_width</code> - Float
| |
− | *<code>tank_length</code> - Float
| |
− | |}
| |
− | | Missing rarity data (common name for rarity percentages TBD).
| |
− | |-
| |
− | | {{Table cell|Yellow}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/nh_clothing|nh_clothing]]'''
| |
− | | {{NH|short}} clothing
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 26 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>identifier</code> - String
| |
− | *<code>en_name</code> - String
| |
− | *<code>category</code> - String
| |
− | *<code>category_sort</code> - Integer
| |
− | *<code>style1</code> - String
| |
− | *<code>style2</code> - String
| |
− | *<code>label1</code> - String
| |
− | *<code>label2</code> - String
| |
− | *<code>label3</code> - String
| |
− | *<code>label4</code> - String
| |
− | *<code>label5</code> - String
| |
− | *<code>buy1_price</code> - Integer
| |
− | *<code>buy1_currency</code> - String
| |
− | *<code>buy1_wikitext</code> - Wikitext string
| |
− | *<code>buy2_price</code> - Integer
| |
− | *<code>buy2_currency</code> - String
| |
− | *<code>buy2_wikitext</code> - Wikitext string
| |
− | *<code>sell</code> - Integer
| |
− | *<code>availability1</code> - String
| |
− | *<code>availability1_note</code> - String
| |
− | *<code>availability2</code> - String
| |
− | *<code>availability2_note</code> - String
| |
− | *<code>vill_equip</code> - Boolean
| |
− | *<code>version_added</code> - String
| |
− | *<code>version_unlocked</code> - String
| |
− | *<code>notes</code> - String
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/nh_clothing_variation|nh_clothing_variation]]'''
| |
− | | {{NH|short}} clothing variations
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 6 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>identifier</code> - String
| |
− | *<code>en_name</code> - String
| |
− | *<code>variation</code> - String
| |
− | *<code>image</code> - String
| |
− | *<code>color1</code> - String
| |
− | *<code>color2</code> - String
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|Yes}}
| |
− | | '''[[Special:CargoTables/nh_fish|nh_fish]]'''
| |
− | | {{NH|short}} fish
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 48 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>catchphrase3</code> - String
| |
− | *<code>n_availability</code> - String
| |
− | *<code>n_m1</code> - Boolean
| |
− | *<code>n_m2</code> - Boolean
| |
− | *<code>n_m3</code> - Boolean
| |
− | *<code>n_m4</code> - Boolean
| |
− | *<code>n_m5</code> - Boolean
| |
− | *<code>n_m6</code> - Boolean
| |
− | *<code>n_m7</code> - Boolean
| |
− | *<code>n_m8</code> - Boolean
| |
− | *<code>n_m9</code> - Boolean
| |
− | *<code>n_m10</code> - Boolean
| |
− | *<code>n_m11</code> - Boolean
| |
− | *<code>n_m12</code> - Boolean
| |
− | *<code>s_availability</code> - String
| |
− | *<code>s_m1</code> - Boolean
| |
− | *<code>s_m2</code> - Boolean
| |
− | *<code>s_m3</code> - Boolean
| |
− | *<code>s_m4</code> - Boolean
| |
− | *<code>s_m5</code> - Boolean
| |
− | *<code>s_m6</code> - Boolean
| |
− | *<code>s_m7</code> - Boolean
| |
− | *<code>s_m8</code> - Boolean
| |
− | *<code>s_m9</code> - Boolean
| |
− | *<code>s_m10</code> - Boolean
| |
− | *<code>s_m11</code> - Boolean
| |
− | *<code>s_m12</code> - Boolean
| |
− | *<code>time</code> - String
| |
− | *<code>time_n_availability</code> - String
| |
− | *<code>time_s_availability</code> - String
| |
− | *<code>time2</code> - String
| |
− | *<code>time2_n_availability</code> - String
| |
− | *<code>time2_s_availability</code> - String
| |
− | *<code>location</code> - String
| |
− | *<code>shadow_size</code> - String
| |
− | *<code>rarity</code> - String
| |
− | *<code>total_catch</code> - Integer
| |
− | *<code>sell_nook</code> - Integer
| |
− | *<code>sell_cj</code> - Integer
| |
− | *<code>tank_width</code> - Float
| |
− | *<code>tank_length</code> - Float
| |
− | |}
| |
− | | Missing rarity data (common name for rarity percentages TBD).
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/nh_furniture|nh_furniture]]'''
| |
− | | {{NH|short}} furniture
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 41 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>identifier</code> - String
| |
− | *<code>en_name</code> - String
| |
− | *<code>category</code> - String
| |
− | *<code>category_sort</code> - Integer
| |
− | *<code>item_series</code> - String
| |
− | *<code>item_set</code> - String
| |
− | *<code>theme1</code> - String
| |
− | *<code>theme2</code> - String
| |
− | *<code>tag</code> - String
| |
− | *<code>hha_base</code> - Integer
| |
− | *<code>function1</code> - String
| |
− | *<code>function2</code> - String
| |
− | *<code>buy1_price</code> - Integer
| |
− | *<code>buy1_currency</code> - String
| |
− | *<code>buy1_wikitext</code> - Wikitext string
| |
− | *<code>buy2_price</code> - Integer
| |
− | *<code>buy2_currency</code> - String
| |
− | *<code>buy2_wikitext</code> - Wikitext string
| |
− | *<code>sell</code> - Integer
| |
− | *<code>availability1</code> - String
| |
− | *<code>availability1_note</code> - String
| |
− | *<code>availability2</code> - String
| |
− | *<code>availability2_note</code> - String
| |
− | *<code>customizable</code> - Boolean
| |
− | *<code>custom_kits</code> - Integer
| |
− | *<code>custom_body_part</code> - String
| |
− | *<code>custom_pattern_part</code> - String
| |
− | *<code>grid_size</code> - String
| |
− | *<code>length</code> - Float
| |
− | *<code>width</code> - Float
| |
− | *<code>height</code> - Float
| |
− | *<code>outdoor</code> - Boolean
| |
− | *<code>interactable</code> - Boolean
| |
− | *<code>animated</code> - Boolean
| |
− | *<code>sound</code> - Boolean
| |
− | *<code>music</code> - Boolean
| |
− | *<code>lighting</code> - Boolean
| |
− | *<code>door_decor</code> - Boolean
| |
− | *<code>version_added</code> - String
| |
− | *<code>version_unlocked</code> - String
| |
− | *<code>notes</code> - String
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|No}}
| |
− | | '''[[Special:CargoTables/nh_furniture_variation|nh_furniture_variation]]'''
| |
− | | {{NH|short}} furniture variations
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 7 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>identifier</code> - String
| |
− | *<code>en_name</code> - String
| |
− | *<code>variation</code> - String
| |
− | *<code>pattern</code> - String
| |
− | *<code>image</code> - String
| |
− | *<code>color1</code> - String
| |
− | *<code>color2</code> - String
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|Yes}}
| |
− | | '''[[Special:CargoTables/nh_sea_creature|nh_sea_creature]]'''
| |
− | | {{NH|short}} sea creatures
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 41 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>n_availability</code> - String
| |
− | *<code>n_m1</code> - Boolean
| |
− | *<code>n_m2</code> - Boolean
| |
− | *<code>n_m3</code> - Boolean
| |
− | *<code>n_m4</code> - Boolean
| |
− | *<code>n_m5</code> - Boolean
| |
− | *<code>n_m6</code> - Boolean
| |
− | *<code>n_m7</code> - Boolean
| |
− | *<code>n_m8</code> - Boolean
| |
− | *<code>n_m9</code> - Boolean
| |
− | *<code>n_m10</code> - Boolean
| |
− | *<code>n_m11</code> - Boolean
| |
− | *<code>n_m12</code> - Boolean
| |
− | *<code>s_availability</code> - String
| |
− | *<code>s_m1</code> - Boolean
| |
− | *<code>s_m2</code> - Boolean
| |
− | *<code>s_m3</code> - Boolean
| |
− | *<code>s_m4</code> - Boolean
| |
− | *<code>s_m5</code> - Boolean
| |
− | *<code>s_m6</code> - Boolean
| |
− | *<code>s_m7</code> - Boolean
| |
− | *<code>s_m8</code> - Boolean
| |
− | *<code>s_m9</code> - Boolean
| |
− | *<code>s_m10</code> - Boolean
| |
− | *<code>s_m11</code> - Boolean
| |
− | *<code>s_m12</code> - Boolean
| |
− | *<code>time</code> - String
| |
− | *<code>shadow_size</code> - String
| |
− | *<code>shadow_movement</code> - String
| |
− | *<code>rarity</code> - String
| |
− | *<code>total_catch</code> - Integer
| |
− | *<code>sell_nook</code> - Integer
| |
− | *<code>tank_width</code> - Float
| |
− | *<code>tank_length</code> - Float
| |
− | |}
| |
− | | Missing rarity data (common name for rarity percentages TBD).
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|Yes}}
| |
− | | '''[[Special:CargoTables/villager|villager]]'''
| |
− | | {{SER}} villagers
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 37 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>url</code> - String
| |
− | *<code>name</code> - String
| |
− | *<code>name_sort</code> - String
| |
− | *<code>alt_name</code> - String
| |
− | *<code>titlecolor</code> - String
| |
− | *<code>textcolor</code> - String
| |
− | *<code>id</code> - String
| |
− | *<code>image</code> - String
| |
− | *<code>image_url</code> - String
| |
− | *<code>species</code> - String
| |
− | *<code>personality</code> - String
| |
− | *<code>prev_personality</code> - String
| |
− | *<code>gender</code> - String
| |
− | *<code>birthday</code> - String
| |
− | *<code>birthday_month</code> - String
| |
− | *<code>birthday_day</code> - Integer
| |
− | *<code>birthday_sort</code> - Integer
| |
− | *<code>sign</code> - String
| |
− | *<code>quote</code> - String
| |
− | *<code>phrase</code> - String
| |
− | *<code>prev_phrase</code> - String
| |
− | *<code>prev_phrase2</code> - String
| |
− | *<code>clothing</code> - String
| |
− | *<code>clothing_nh_var</code> - String
| |
− | *<code>islander</code> - Boolean
| |
− | *<code>debut</code> - String
| |
− | *<code>dnm</code> - Boolean
| |
− | *<code>ac</code> - Boolean
| |
− | *<code>e_plus</code> - Boolean
| |
− | *<code>ww</code> - Boolean
| |
− | *<code>cf</code> - Boolean
| |
− | *<code>nl</code> - Boolean
| |
− | *<code>wa</code> - Boolean
| |
− | *<code>nh</code> - Boolean
| |
− | *<code>film</code> - Boolean
| |
− | *<code>hhd</code> - Boolean
| |
− | *<code>pc</code> - Boolean
| |
− | |}
| |
− | | -
| |
− | |-
| |
− | | {{Table cell|Green}}
| |
− | | {{Table cell|Yes}}
| |
− | | '''[[Special:CargoTables/nh_villager|nh_villager]]'''
| |
− | | {{NH|short}} villagers (using in villager endpoint)
| |
− | |
| |
− | {| style="border:1px solid #CCC; {{roundy}}; padding:5px; width:100%;" class="collapsible collapsed"
| |
− | |-
| |
− | ! {{Colorshow|4c4c4c|Open to view 25 fields}}
| |
− | |-
| |
− | |
| |
− | *<code>url</code> - String
| |
− | *<code>name</code> - String
| |
− | *<code>image</code> - String
| |
− | *<code>image_url</code> - String
| |
− | *<code>photo</code> - String
| |
− | *<code>photo_url</code> - String
| |
− | *<code>icon</code> - String
| |
− | *<code>icon_url</code> - String
| |
− | *<code>quote</code> - String
| |
− | *<code>species</code> - String
| |
− | *<code>gender</code> - String
| |
− | *<code>personality</code> - String
| |
− | *<code>sub_personality</code> - String
| |
− | *<code>birthday</code> - String
| |
− | *<code>birthday_sort</code> - Integer
| |
− | *<code>sign</code> - String
| |
− | *<code>catchphrase</code> - String
| |
− | *<code>clothing</code> - String
| |
− | *<code>clothing_variation</code> - String
| |
− | *<code>new</code> - Boolean
| |
− | *<code>fav_style1</code> - String
| |
− | *<code>fav_style2</code> - String
| |
− | *<code>fav_color1</code> - String
| |
− | *<code>fav_color2</code> - String
| |
− | *<code>hobby</code> - String
| |
− | |}
| |
− | | -
| |
− | |}
| |
| | | |
| ==Helpful links== | | ==Helpful links== |