items
Relationships
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
spells_new {
int id
int descnum
int effectdescnum
int effectdescnum2
int typedescnum
varchar teleport_zone
}
books {
int id
}
alternate_currency {
int id
int item_id
}
bot_inventories {
varchar bot_id
varchar item_id
varchar augment_1
varchar augment_2
varchar augment_3
varchar augment_4
varchar augment_5
varchar augment_6
}
bot_pet_inventories {
varchar pets_index
varchar item_id
}
items ||--o{ spells_new : "One-to-One"
items ||--o{ books : "One-to-One"
items ||--o{ spells_new : "One-to-One"
items ||--o{ spells_new : "One-to-One"
items ||--o{ alternate_currency : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_inventories : "Has-Many"
items ||--o{ bot_pet_inventories : "Has-Many"
items ||--o{ spells_new : "One-to-One"
items ||--o{ spells_new : "One-to-One"
items ||--o{ spells_new : "One-to-One"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
character_bandolier {
intunsigned id
intunsigned item_id
}
character_corpse_items {
intunsigned corpse_id
intunsigned item_id
intunsigned aug_1
intunsigned aug_2
intunsigned aug_3
intunsigned aug_4
intunsigned aug_5
int aug_6
}
character_pet_inventory {
int char_id
int item_id
}
character_potionbelt {
intunsigned id
intunsigned icon
intunsigned item_id
}
discovered_items {
varchar char_name
intunsigned item_id
}
items ||--o{ character_bandolier : "Has-Many"
items ||--o{ character_corpse_items : "Has-Many"
items ||--o{ character_pet_inventory : "Has-Many"
items ||--o{ character_potionbelt : "Has-Many"
items ||--o{ discovered_items : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
doors {
varchar content_flags
varchar content_flags_disabled
int dz_switch_id
int keyitem
varchar zone
varchar dest_zone
intunsigned dest_instance
smallint version
}
fishing {
varchar content_flags
varchar content_flags_disabled
int Itemid
int zoneid
int npc_id
}
forage {
varchar content_flags
varchar content_flags_disabled
int Itemid
int zoneid
}
ground_spawns {
varchar content_flags
varchar content_flags_disabled
intunsigned item
smallint version
intunsigned zoneid
}
inventory {
intunsigned charid
intunsigned itemid
mediumintunsigned augslot1
mediumintunsigned augslot2
mediumintunsigned augslot3
mediumintunsigned augslot4
mediumintunsigned augslot5
mediumint augslot6
}
items ||--o{ doors : "Has-Many"
items ||--o{ fishing : "Has-Many"
items ||--o{ forage : "Has-Many"
items ||--o{ ground_spawns : "Has-Many"
items ||--o{ inventory : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
item_tick {
varchar it_itemid
varchar it_qglobal
}
keyring {
int char_id
int item_id
}
lootdrop_entries {
int item_id
intunsigned lootdrop_id
}
merc_inventory {
varchar item_id
varchar merc_subtype_id
}
merchantlist {
varchar content_flags
varchar content_flags_disabled
varchar bucket_name
int item
varchar merchant_id
int merchantid
}
items ||--o{ item_tick : "Has-Many"
items ||--o{ keyring : "Has-Many"
items ||--o{ lootdrop_entries : "Has-Many"
items ||--o{ merc_inventory : "Has-Many"
items ||--o{ merchantlist : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
merchantlist_temp {
intunsigned itemid
intunsigned npcid
}
object {
varchar content_flags
varchar content_flags_disabled
int itemid
int id
smallint version
intunsigned zoneid
}
object_contents {
intunsigned itemid
intunsigned parentid
mediumintunsigned augslot1
mediumintunsigned augslot2
mediumintunsigned augslot3
mediumintunsigned augslot4
mediumintunsigned augslot5
mediumint augslot6
intunsigned zoneid
}
pets_equipmentset_entries {
int item_id
int set_id
}
qs_merchant_transaction_record_entries {
int item_id
int aug_1
int aug_2
int aug_3
int aug_4
int aug_5
}
items ||--o{ merchantlist_temp : "Has-Many"
items ||--o{ object : "Has-Many"
items ||--o{ object_contents : "Has-Many"
items ||--o{ pets_equipmentset_entries : "Has-Many"
items ||--o{ qs_merchant_transaction_record_entries : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
qs_player_delete_record_entries {
int item_id
int aug_1
int aug_2
int aug_3
int aug_4
int aug_5
}
qs_player_handin_record_entries {
int item_id
int aug_1
int aug_2
int aug_3
int aug_4
int aug_5
}
qs_player_move_record_entries {
int item_id
int aug_1
int aug_2
int aug_3
int aug_4
int aug_5
}
qs_player_trade_record_entries {
int from_id
int to_id
int item_id
int aug_1
int aug_2
int aug_3
int aug_4
int aug_5
}
starting_items {
varchar content_flags
varchar content_flags_disabled
varchar itemid
varchar zone_id
varchar zoneid
}
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_delete_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_handin_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_move_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ qs_player_trade_record_entries : "Has-Many"
items ||--o{ starting_items : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
tool_gearup_armor_sets {
int item_id
}
trader {
intunsigned char_id
intunsigned item_id
}
tradeskill_recipe_entries {
int item_id
int recipe_id
}
tribute_levels {
intunsigned item_id
intunsigned tribute_id
}
veteran_reward_templates {
intunsigned claim_id
intunsigned item_id
}
items ||--o{ tool_gearup_armor_sets : "Has-Many"
items ||--o{ trader : "Has-Many"
items ||--o{ tradeskill_recipe_entries : "Has-Many"
items ||--o{ tribute_levels : "Has-Many"
items ||--o{ veteran_reward_templates : "Has-Many"
erDiagram
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
trader_audit {
varchar buyer
varchar seller
varchar itemname
}
character_item_recast {
intunsigned id
intunsigned recast_type
}
items ||--o{ trader_audit : "Has-Many"
items ||--o{ character_item_recast : "Has-Many"
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | bardeffect | spells_new | id |
| One-to-One | book | books | id |
| One-to-One | clickeffect | spells_new | id |
| One-to-One | focuseffect | spells_new | id |
| Has-Many | id | alternate_currency | item_id |
| Has-Many | id | bot_inventories | item_id |
| Has-Many | id | bot_inventories | augment_1 |
| Has-Many | id | bot_inventories | augment_2 |
| Has-Many | id | bot_inventories | augment_3 |
| Has-Many | id | bot_inventories | augment_4 |
| Has-Many | id | bot_inventories | augment_5 |
| Has-Many | id | bot_inventories | augment_6 |
| Has-Many | id | bot_pet_inventories | item_id |
| Has-Many | id | character_bandolier | item_id |
| Has-Many | id | character_corpse_items | item_id |
| Has-Many | id | character_pet_inventory | item_id |
| Has-Many | id | character_potionbelt | item_id |
| Has-Many | id | discovered_items | item_id |
| Has-Many | id | doors | keyitem |
| Has-Many | id | fishing | Itemid |
| Has-Many | id | forage | Itemid |
| Has-Many | id | ground_spawns | item |
| Has-Many | id | inventory | itemid |
| Has-Many | id | item_tick | it_itemid |
| Has-Many | id | keyring | item_id |
| Has-Many | id | lootdrop_entries | item_id |
| Has-Many | id | merc_inventory | item_id |
| Has-Many | id | merchantlist | item |
| Has-Many | id | merchantlist_temp | itemid |
| Has-Many | id | object | itemid |
| Has-Many | id | object_contents | itemid |
| Has-Many | id | pets_equipmentset_entries | item_id |
| Has-Many | id | qs_merchant_transaction_record_entries | item_id |
| Has-Many | id | qs_player_delete_record_entries | item_id |
| Has-Many | id | qs_player_delete_record_entries | aug_1 |
| Has-Many | id | qs_player_delete_record_entries | aug_2 |
| Has-Many | id | qs_player_delete_record_entries | aug_3 |
| Has-Many | id | qs_player_delete_record_entries | aug_4 |
| Has-Many | id | qs_player_delete_record_entries | aug_5 |
| Has-Many | id | qs_player_handin_record_entries | item_id |
| Has-Many | id | qs_player_handin_record_entries | aug_1 |
| Has-Many | id | qs_player_handin_record_entries | aug_2 |
| Has-Many | id | qs_player_handin_record_entries | aug_3 |
| Has-Many | id | qs_player_handin_record_entries | aug_4 |
| Has-Many | id | qs_player_handin_record_entries | aug_5 |
| Has-Many | id | qs_player_move_record_entries | item_id |
| Has-Many | id | qs_player_move_record_entries | aug_1 |
| Has-Many | id | qs_player_move_record_entries | aug_2 |
| Has-Many | id | qs_player_move_record_entries | aug_3 |
| Has-Many | id | qs_player_move_record_entries | aug_4 |
| Has-Many | id | qs_player_move_record_entries | aug_5 |
| Has-Many | id | qs_player_trade_record_entries | item_id |
| Has-Many | id | qs_player_trade_record_entries | aug_1 |
| Has-Many | id | qs_player_trade_record_entries | aug_2 |
| Has-Many | id | qs_player_trade_record_entries | aug_3 |
| Has-Many | id | qs_player_trade_record_entries | aug_4 |
| Has-Many | id | qs_player_trade_record_entries | aug_5 |
| Has-Many | id | starting_items | itemid |
| Has-Many | id | tool_gearup_armor_sets | item_id |
| Has-Many | id | trader | item_id |
| Has-Many | id | tradeskill_recipe_entries | item_id |
| Has-Many | id | tribute_levels | item_id |
| Has-Many | id | veteran_reward_templates | item_id |
| Has-Many | name | trader_audit | itemname |
| One-to-One | proceffect | spells_new | id |
| Has-Many | recasttype | character_item_recast | recast_type |
| One-to-One | scrolleffect | spells_new | id |
| One-to-One | worneffect | spells_new | id |
Schema
| Column | Data Type | Description |
|---|---|---|
| id | int | Unique Item Identifier |
| minstatus | smallint | Minimum Status |
| Name | varchar | Name |
| aagi | int | Agility: -128 to 127 |
| ac | int | Armor Class |
| accuracy | int | Accuracy |
| acha | int | Charisma: -128 to 127 |
| adex | int | Dexterity: -128 to 127 |
| aint | int | Intelligence: -128 to 127 |
| artifactflag | tinyint | Artifact: 0 = False, 1 = True |
| asta | int | Stamina: -128 to 127 |
| astr | int | Strenght: -128 to 127 |
| attack | int | Attack |
| augrestrict | int | Augment Restriction |
| augslot1type | tinyint | Augment Slot 1 Type |
| augslot1visible | tinyint | Augment Slot 1 Visible: 0 = False, 1 = True |
| augslot2type | tinyint | Augment Slot 2 Type |
| augslot2visible | tinyint | Augment Slot 2 Visible: 0 = False, 1 = True |
| augslot3type | tinyint | Augment Slot 3 Type |
| augslot3visible | tinyint | Augment Slot 3 Visible: 0 = False, 1 = True |
| augslot4type | tinyint | Augment Slot 4 Type |
| augslot4visible | tinyint | Augment Slot 4 Visible: 0 = False, 1 = True |
| augslot5type | tinyint | Augment Slot 5 Type |
| augslot5visible | tinyint | Augment Slot 5 Visible: 0 = False, 1 = True |
| augslot6type | tinyint | Augment Slot 6 Type |
| augslot6visible | tinyint | Augment Slot 6 Visible: 0 = False, 1 = True |
| augtype | int | Augment Type |
| avoidance | int | Avoidance |
| awis | int | Wisdom: -128 to 127 |
| bagsize | int | Bag Size |
| bagslots | int | Bag Slots: 1 = Minimum, 10 = Maximum |
| bagtype | int | Bag Type |
| bagwr | int | Bag Weight Reduction: 0 = 0%, 100 = 100% |
| banedmgamt | int | Bane Damage Amount |
| banedmgraceamt | int | Bane Damage Race Amount |
| banedmgbody | int | Bane Damage Body Type |
| banedmgrace | int | Bane Damage Race |
| bardtype | int | Bard Type |
| bardvalue | int | Bard Value |
| book | int | Book |
| casttime | int | Cast Time in Seconds |
| casttime_ | int | Cast Time in Seconds |
| charmfile | varchar | Charm File |
| charmfileid | varchar | Charm File Identifier |
| classes | int | Classes |
| color | int | Color |
| combateffects | varchar | Combat Effects |
| extradmgskill | int | Extra Damage Skill |
| extradmgamt | int | Extra Damage Amount |
| price | int | Price in Copper |
| cr | int | Cold Resistance: -128 to 127 |
| damage | int | Damage |
| damageshield | int | Damage Shield |
| deity | int | Deity |
| delay | int | Delay |
| augdistiller | int | Augment Distiller Item Identifier |
| dotshielding | int | Damage Over Time Shielding |
| dr | int | Disease Resistance: -128 to 127 |
| clicktype | int | Click Type |
| clicklevel2 | int | Click Level 2 |
| elemdmgtype | int | Elemental Damage Type |
| elemdmgamt | int | Elemental Damage Amount |
| endur | int | Endurance |
| factionamt1 | int | Faction Amount 1 |
| factionamt2 | int | Faction Amount 2 |
| factionamt3 | int | Faction Amount 3 |
| factionamt4 | int | Faction Amount 4 |
| factionmod1 | int | Faction Modifier 1 |
| factionmod2 | int | Faction Modifier 2 |
| factionmod3 | int | Faction Modifier 3 |
| factionmod4 | int | Faction Modifier 4 |
| filename | varchar | File Name |
| focuseffect | int | Focus Effect Identifier |
| fr | int | Fire Resistance: -128 to 127 |
| fvnodrop | int | Firiona Vie No Drop: 0 = False, 1 = True |
| haste | int | Haste: 0 = 0%, 255 = 255% |
| clicklevel | int | Click Level |
| hp | int | Health |
| regen | int | Health Regeneration |
| icon | int | Icon |
| idfile | varchar | Item Texture |
| itemclass | int | Item Class |
| itemtype | int | Item Type |
| ldonprice | int | LDoN Price |
| ldontheme | int | LDoN Theme |
| ldonsold | int | LDoN Sold: 0 = False, 1 = True |
| light | int | Light |
| lore | varchar | Lore Description |
| loregroup | int | Lore Group |
| magic | int | Magic: 0 = False, 1 = True |
| mana | int | Mana |
| manaregen | int | Mana Regeneration |
| enduranceregen | int | Endurance Regeneration |
| material | int | Material |
| herosforgemodel | int | Hero's Forge Model |
| maxcharges | int | Maximum Charges |
| mr | int | Magic Resistance: -128 to 127 |
| nodrop | int | No Drop: 0 = True, 1 = False |
| norent | int | No Rent: 0 = True, 1 = False |
| pendingloreflag | tinyint | Pending Lore Flag: 0 = False, 1 = True |
| pr | int | Poison Resistance: -128 to 127 |
| procrate | int | Proc Rate: 0 = 100%, 50 = 150%, 100 = 200% |
| races | int | Races |
| range | int | Range: 0 to 255 |
| reclevel | int | Recommended Level |
| recskill | int | Recommended Skill Level |
| reqlevel | int | Required Level |
| sellrate | float | Sell Rate |
| shielding | int | Shielding: 5 = 5%, 20 = 20%, 50 = 50% |
| size | int | Size |
| skillmodtype | int | Skill Modifier Type |
| skillmodvalue | int | Skill Modifier Value |
| slots | int | Slots |
| clickeffect | int | Click Effect Identifier |
| spellshield | int | Spell Shielding |
| strikethrough | int | Strikethrough |
| stunresist | int | Stun Resist |
| summonedflag | tinyint | Unknown |
| tradeskills | int | Tradeskill Item: 0 = False, 1= True |
| favor | int | Favor |
| weight | int | Weight: 10 = 1.0, 25 = 2.5, 100 = 10.0 |
| UNK012 | int | Unknown |
| UNK013 | int | Unknown |
| benefitflag | int | Unknown |
| UNK054 | int | Unknown |
| UNK059 | int | Unknown |
| booktype | int | Book Language |
| recastdelay | int | Recast Delay in Seconds |
| recasttype | int | Recast Type: -1 = None, >0 = Recast Type used across all items |
| guildfavor | int | Guild Favor |
| UNK123 | int | Unknown |
| UNK124 | int | Unknown |
| attuneable | int | Attuneable: 0 = False, 1 = True |
| nopet | int | No Pet: 0 = False, 1 = True |
| updated | datetime | Updated Datetime |
| comment | varchar | Comment |
| UNK127 | int | Unknown |
| pointtype | int | Unknown |
| potionbelt | int | Potion Belt: 0 = False, 1 = True |
| potionbeltslots | int | Potion Belt Slots |
| stacksize | int | Stack Size |
| notransfer | int | No Transfer: 0 = False, 1 = True |
| stackable | int | Stackable: 0 = False, 1 = True |
| UNK134 | varchar | Unknown |
| UNK137 | int | Unknown |
| proceffect | int | Proc Effect Identifier |
| proctype | int | Proc Type: 0 |
| proclevel2 | int | Proc Level 2 |
| proclevel | int | Proc Level |
| UNK142 | int | Unknown |
| worneffect | int | Worn Effect Identifier |
| worntype | int | Worn Type: 2 = Worn |
| wornlevel2 | int | Worn Level 2 |
| wornlevel | int | Worn Level |
| UNK147 | int | Unknown |
| focustype | int | Focus Type: 6 = Focus |
| focuslevel2 | int | Focus Level 2 |
| focuslevel | int | Focus Level |
| UNK152 | int | Unknown |
| scrolleffect | int | Scroll Effect Identifier |
| scrolltype | int | Scroll Type: 7 = Scroll |
| scrolllevel2 | int | Scroll Level 2 |
| scrolllevel | int | Scroll Level |
| UNK157 | int | Unknown |
| serialized | datetime | Serialized Datetime |
| verified | datetime | Verified Datetime |
| serialization | text | Serialization |
| source | varchar | Source |
| UNK033 | int | Unknown |
| lorefile | varchar | Lore File |
| UNK014 | int | Unknown |
| svcorruption | int | Corruption Resistance: -128 to 127 |
| skillmodmax | int | Skill Modifier Max |
| UNK060 | int | Unknown |
| augslot1unk2 | int | Unknown |
| augslot2unk2 | int | Unknown |
| augslot3unk2 | int | Unknown |
| augslot4unk2 | int | Unknown |
| augslot5unk2 | int | Unknown |
| augslot6unk2 | int | Unknown |
| UNK120 | int | Unknown |
| UNK121 | int | Unknown |
| questitemflag | int | Quest Item: 0 = False, 1 = True |
| UNK132 | text | Unknown |
| clickunk5 | int | Unknown |
| clickunk6 | varchar | Unknown |
| clickunk7 | int | Unknown |
| procunk1 | int | Unknown |
| procunk2 | int | Unknown |
| procunk3 | int | Unknown |
| procunk4 | int | Unknown |
| procunk6 | varchar | Unknown |
| procunk7 | int | Unknown |
| wornunk1 | int | Unknown |
| wornunk2 | int | Unknown |
| wornunk3 | int | Unknown |
| wornunk4 | int | Unknown |
| wornunk5 | int | Unknown |
| wornunk6 | varchar | Unknown |
| wornunk7 | int | Unknown |
| focusunk1 | int | Unknown |
| focusunk2 | int | Unknown |
| focusunk3 | int | Unknown |
| focusunk4 | int | Unknown |
| focusunk5 | int | Unknown |
| focusunk6 | varchar | Unknown |
| focusunk7 | int | Unknown |
| scrollunk1 | int | Unknown |
| scrollunk2 | int | Unknown |
| scrollunk3 | int | Unknown |
| scrollunk4 | int | Unknown |
| scrollunk5 | int | Unknown |
| scrollunk6 | varchar | Unknown |
| scrollunk7 | int | Unknown |
| UNK193 | int | Unknown |
| purity | int | Purity |
| evoitem | int | Evolving Item: 0 = False, 1 = True |
| evoid | int | Evolving Identifier |
| evolvinglevel | int | Evolving Level |
| evomax | int | Evolving Max |
| clickname | varchar | Click Name |
| procname | varchar | Proc Name |
| wornname | varchar | Worn Name |
| focusname | varchar | Focus Name |
| scrollname | varchar | Scroll Name |
| dsmitigation | smallint | Damage Shield Mitigation |
| heroic_str | smallint | Heroic Strength |
| heroic_int | smallint | Heroic Intelligence |
| heroic_wis | smallint | Heroic Wisdom |
| heroic_agi | smallint | Heroic Agility |
| heroic_dex | smallint | Heroic Dexterity |
| heroic_sta | smallint | Heroic Stamina |
| heroic_cha | smallint | Heroic Charisma |
| heroic_pr | smallint | Heroic Poison Resistance |
| heroic_dr | smallint | Heroic Disease Resistance |
| heroic_fr | smallint | Heroic Fire Resistance |
| heroic_cr | smallint | Heroic Cold Resistance |
| heroic_mr | smallint | Heroic Magic Resistance |
| heroic_svcorrup | smallint | Heroic Corruption Resistance |
| healamt | smallint | Heal Amount: 0 to 32767 |
| spelldmg | smallint | Spell Damage: 0 to 32767 |
| clairvoyance | smallint | Clairvoyance |
| backstabdmg | smallint | Backstab Damage |
| created | varchar | Created |
| elitematerial | smallint | Elite Material |
| ldonsellbackrate | smallint | LDoN Sellback Rate |
| scriptfileid | mediumint | Script File Name |
| expendablearrow | smallint | Expendable Arrow: 0 = False, 1 = True |
| powersourcecapacity | mediumint | Powersource Capacity |
| bardeffect | mediumint | Bard Effect Identifier |
| bardeffecttype | smallint | Bard Effect Type |
| bardlevel2 | smallint | Bard Level 2 |
| bardlevel | smallint | Bard Level |
| bardunk1 | smallint | Unknown |
| bardunk2 | smallint | Unknown |
| bardunk3 | smallint | Unknown |
| bardunk4 | smallint | Unknown |
| bardunk5 | smallint | Unknown |
| bardname | varchar | Bard Name |
| bardunk7 | smallint | Unknown |
| UNK214 | smallint | Unknown |
| subtype | int | Sub Type |
| UNK220 | int | Unknown |
| UNK221 | int | Unknown |
| heirloom | int | Heirloom: 0 = False, 1 = True |
| UNK223 | int | Unknown |
| UNK224 | int | Unknown |
| UNK225 | int | Unknown |
| UNK226 | int | Unknown |
| UNK227 | int | Unknown |
| UNK228 | int | Unknown |
| UNK229 | int | Unknown |
| UNK230 | int | Unknown |
| UNK231 | int | Unknown |
| UNK232 | int | Unknown |
| UNK233 | int | Unknown |
| UNK234 | int | Unknown |
| placeable | int | Placeable: 0 = False, 1 = True |
| UNK236 | int | Unknown |
| UNK237 | int | Unknown |
| UNK238 | int | Unknown |
| UNK239 | int | Unknown |
| UNK240 | int | Unknown |
| UNK241 | int | Unknown |
| epicitem | int | Epic Item: 0 = False, 1 = True |