Terraria Wiki:Cargo tables

The Terraria Wiki stores some data about Terraria in databases via the MediaWiki extension Cargo. The data is usually stored in single, central locations on the wiki and can be queried on any page, facilitating quick and dynamic updates.

List of tables

All available databases (or tables) are listed at Special:CargoTables. They are described below.

Items

Items

Database	Special:CargoTables/Items
Manual querying	Special:Drilldown/Items

The Items Cargo table contains data about all items in the game, including attributes like damage, max stack, use time, and numerous others.

The data is entered into this table using {{item infobox}}. Virtually all articles about items use one or more {{item infobox}}es to display item information, and in the background that information is stored to the Cargo table. Many of the parameters of {{item infobox}} directly store their value in the respective column of the Cargo table.

For example, consider the following transclusion of {{item infobox}} on the page Dirt Block:

{{item infobox
| name = Dirt Block
| id = 2
| type = Block / Crafting material
| autoswing = yes
| stack = 9999
| research = 100
| rare = {{rare|0}}
| use = 15
| placeable = yes
| width = 1 | height = 1
}}

This transclusion would both:

• display this data in the visible infobox and
• store this data to the Cargo table in the background.

The table row (or database entry) in the Items table for the Dirt Block would then look something like this (not all columns included, for brevity):

Page	itemid	name	type	autoswing	stack	damage	damagetype	knockback	research	rare	buy	sell	use	placeable	placedwidth	placedheight
Dirt Block	2	Dirt Block	block • crafting material	Yes	999				100	0			15	Yes	1	1

This is the essence of the Items table:

Almost all of the Items Cargo table's columns are directly connected to the {{item infobox}} template parameters.

For instance, if you want to list all block items by querying the Items Cargo table for block in the type column, and you notice that the Dirt Block does not show up, then make sure that block is in the | type = parameter of the Dirt Block's {{item infobox}}.

There are more details about the behavior of {{item infobox}} which are explained in the following section, but the principle above still applies.

NPCs

NPCs

Database	Special:CargoTables/NPCs
Manual querying	Special:Drilldown/NPCs

Recipes

Recipes

Database	Special:CargoTables/Recipes
Manual querying	Special:Drilldown/Recipes

Drops

Drops

Database	Special:CargoTables/Drops
Manual querying	Special:Drilldown/Drops

Exclusive

Exclusive

Database	Special:CargoTables/Exclusive
Manual querying	Special:Drilldown/Exclusive