Table characters.item_instance
Item System

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
guid int unsigned 10 0
auctionhouse.itemguid Defined in XML R
character_gifts.item_guid Defined in XML R
character_inventory.bag Defined in XML R
character_inventory.item Defined in XML R
guild_bank_item.item_guid Defined in XML R
mail_items.item_guid Defined in XML R
petition.petitionguid Defined in XML R
petition_sign.petitionguid Defined in XML R
owner_guid int unsigned 10 0
characters.guid Defined in XML R
data longtext 2147483647  √  null

Table contained 0 rows at Fri Feb 11 23:13 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
guid Primary key Asc PRIMARY
owner_guid Performance Asc idx_owner_guid

Close relationships  within of separation: