Miscellany

class Item(models.Model):
	item_class = models.ForeignKey("ItemClass", db_index=True, blank=True, null=True)
	item_sub_class = models.ForeignKey("ItemSubClass", db_index=True, blank=True, null=True)
	name_en = models.CharField(maxlength=255, blank=True, null=True)
	name_kr = models.CharField(maxlength=255, blank=True, null=True)
	name_fr = models.CharField(maxlength=255, blank=True, null=True)
	name_de = models.CharField(maxlength=255, blank=True, null=True)
	name_cn = models.CharField(maxlength=255, blank=True, null=True)
	name_tw = models.CharField(maxlength=255, blank=True, null=True)
	name_07 = models.CharField(maxlength=255, blank=True, null=True)
	name_08 = models.CharField(maxlength=255, blank=True, null=True)
	display = models.ForeignKey("ItemDisplayInfo", db_index=True, blank=True, null=True)
	quality = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	buy_price = models.IntegerField(blank=True, null=True)
	sell_price = models.IntegerField(blank=True, null=True)
	slot = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	required_class = models.IntegerField(blank=True, null=True)
	required_race = models.IntegerField(blank=True, null=True)
	level = models.IntegerField(blank=True, null=True)
	required_level = models.IntegerField(blank=True, null=True)
	required_skill = models.ForeignKey("SkillLine", db_index=True, blank=True, null=True)
	required_skill_level = models.IntegerField(blank=True, null=True)
	required_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	required_rank = models.IntegerField(db_index=True, blank=True, null=True)
	unknown1 = models.IntegerField(blank=True, null=True)
	required_faction = models.ForeignKey("Faction", db_index=True, blank=True, null=True)
	required_faction_level = models.IntegerField(blank=True, null=True)
	stack_unique = models.IntegerField(blank=True, null=True)
	stack_normal = models.IntegerField(blank=True, null=True)
	container_slots = models.IntegerField(blank=True, null=True)
	stat_1 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_1_value = models.IntegerField(blank=True, null=True)
	stat_2 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_2_value = models.IntegerField(blank=True, null=True)
	stat_3 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_3_value = models.IntegerField(blank=True, null=True)
	stat_4 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_4_value = models.IntegerField(blank=True, null=True)
	stat_5 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_5_value = models.IntegerField(blank=True, null=True)
	stat_6 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_6_value = models.IntegerField(blank=True, null=True)
	stat_7 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_7_value = models.IntegerField(blank=True, null=True)
	stat_8 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_8_value = models.IntegerField(blank=True, null=True)
	stat_9 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_9_value = models.IntegerField(blank=True, null=True)
	stat_10 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	stat_10_value = models.IntegerField(blank=True, null=True)
	damage_1_min = models.FloatField()
	damage_1_max = models.FloatField()
	damage_1_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	damage_2_min = models.FloatField()
	damage_2_max = models.FloatField()
	damage_2_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	damage_3_min = models.FloatField()
	damage_3_max = models.FloatField()
	damage_3_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	damage_4_min = models.FloatField()
	damage_4_max = models.FloatField()
	damage_4_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	damage_5_min = models.FloatField()
	damage_5_max = models.FloatField()
	damage_5_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	resist_0 = models.IntegerField(blank=True, null=True)
	resist_1 = models.IntegerField(blank=True, null=True)
	resist_2 = models.IntegerField(blank=True, null=True)
	resist_3 = models.IntegerField(blank=True, null=True)
	resist_4 = models.IntegerField(blank=True, null=True)
	resist_5 = models.IntegerField(blank=True, null=True)
	resist_6 = models.IntegerField(blank=True, null=True)
	weapon_speed = models.IntegerField(blank=True, null=True)
	ammo_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	range_odifier = models.FloatField(max_digits=12, decimal_places=31)
	spell_1 = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_1_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_1_charges = models.IntegerField(blank=True, null=True)
	spell_1_cooldown = models.IntegerField(blank=True, null=True)
	spell_1_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True)
	spell_1_category_cooldown = models.IntegerField(blank=True, null=True)
	spell_2 = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_2_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_2_charges = models.IntegerField(blank=True, null=True)
	spell_2_cooldown = models.IntegerField(blank=True, null=True)
	spell_2_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True)
	spell_2_category_cooldown = models.IntegerField(blank=True, null=True)
	spell_3 = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_3_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_3_charges = models.IntegerField(blank=True, null=True)
	spell_3_cooldown = models.IntegerField(blank=True, null=True)
	spell_3_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True)
	spell_3_category_cooldown = models.IntegerField(blank=True, null=True)
	spell_4 = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_4_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_4_charges = models.IntegerField(blank=True, null=True)
	spell_4_cooldown = models.IntegerField(blank=True, null=True)
	spell_4_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True)
	spell_4_category_cooldown = models.IntegerField(blank=True, null=True)
	spell_5 = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_5_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True)
	spell_5_charges = models.IntegerField(blank=True, null=True)
	spell_5_cooldown = models.IntegerField(blank=True, null=True)
	spell_5_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True)
	spell_5_category_cooldown = models.IntegerField(blank=True, null=True)
	bond = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	description_en = models.CharField(maxlength=255, blank=True, null=True)
	description_kr = models.CharField(maxlength=255, blank=True, null=True)
	description_fr = models.CharField(maxlength=255, blank=True, null=True)
	description_de = models.CharField(maxlength=255, blank=True, null=True)
	description_cn = models.CharField(maxlength=255, blank=True, null=True)
	description_tw = models.CharField(maxlength=255, blank=True, null=True)
	description_07 = models.CharField(maxlength=255, blank=True, null=True)
	description_08 = models.CharField(maxlength=255, blank=True, null=True)
	book_text = models.ForeignKey("PageText", db_index=True, blank=True, null=True)
	book_pages = models.IntegerField(blank=True, null=True)
	book_stationary = models.IntegerField(blank=True, null=True)
	begin_quest = models.ForeignKey("Quest", db_index=True, blank=True, null=True)
	required_lockpick_level = models.IntegerField(blank=True, null=True)
	material = models.ForeignKey("Material", db_index=True, blank=True, null=True)
	sheath = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True)
	random_property = models.IntegerField(blank=True, null=True)
	block = models.IntegerField(blank=True, null=True)
	itemset = models.ForeignKey("ItemSet", db_index=True, blank=True, null=True)
	durability = models.IntegerField(blank=True, null=True)
	area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True)
	map = models.ForeignKey("Map", db_index=True, blank=True, null=True)
	bag_family = models.ForeignKey("ItemBagFamily", db_index=True, blank=True, null=True)
	version = models.ForeignKey("Version", db_index=True)
	hash = models.CharField(maxlength=32)
	user = models.ForeignKey("User", db_index=True, blank=True, null=True)