class NpcSpell(Table, table_name="npc_spell"):
npc_id = Column(ForeignKey(Integer, "npc", "article_id"), index=True)
spell_id = Column(ForeignKey(Integer, "spell", "article_id"), index=True)
knight = Column(Boolean, nullable=False, default=False)
sorcerer = Column(Boolean, nullable=False, default=False)
paladin = Column(Boolean, nullable=False, default=False)
druid = Column(Boolean, nullable=False, default=False)
class ItemKey(Table, table_name="item_key"):
article_id = Column(Integer, primary_key=True)
title = Column(Text, unique=True)
number = Column(Integer, unique=True)
item_id = Column(ForeignKey(Integer, "item", "article_id"), index=True)
name = Column(Text)
material = Column(Text)
location = Column(Text)
origin = Column(Text)
notes = Column(Text)
version = Column(Text, index=True)
timestamp = Column(Integer)
class CreatureSound(Table, table_name="creature_sound"):
creature_id = Column(ForeignKey(Integer, table="creature", column="article_id"), index=True)
content = Column(Text)
class QuestReward(Table, table_name="quest_reward"):
quest_id = Column(ForeignKey(Integer, "quest", "article_id"), index=True)
item_id = Column(ForeignKey(Integer, "item", "article_id"), nullable=False, index=True)
class QuestDanger(Table, table_name="quest_danger"):
quest_id = Column(ForeignKey(Integer, "quest", "article_id"), index=True)
creature_id = Column(ForeignKey(Integer, "creature", "article_id"), nullable=False, index=True)
class OutfitQuest(Table, table_name="outfit_quest"):
outfit_id = Column(ForeignKey(Integer, "outfit", "article_id"), index=True, nullable=False)
quest_id = Column(ForeignKey(Integer, "quest", "article_id"), index=True, nullable=False)
type = Column(Text)
class OutfitImage(Table, table_name="outfit_image"):
outfit_id = Column(ForeignKey(Integer, "outfit", "article_id"), index=True)
sex = Column(Text)
addon = Column(Integer)
image = Column(Blob)
class NpcDestination(Table, table_name="npc_destination"):
npc_id = Column(ForeignKey(Integer, "npc", "article_id"), index=True)
name = Column(Text, index=True)
price = Column(Integer)
notes = Column(Text)
class NpcSelling(Table, table_name="npc_offer_sell"):
npc_id = Column(ForeignKey(Integer, "npc", "article_id"), index=True)
item_id = Column(ForeignKey(Integer, "item", "article_id"), nullable=False, index=True)
value = Column(Integer, nullable=False)
currency_id = Column(ForeignKey(Integer, "item", "article_id"), nullable=False)
class ImbuementMaterial(Table, table_name="imbuement_material"):
imbuement_id = Column(ForeignKey(Integer, "imbuement", "article_id"), index=True)
item_id = Column(ForeignKey(Integer, "item", "article_id"), index=True)
amount = Column(Integer)
class ItemAttribute(Table, table_name="item_attribute"):
item_id = Column(ForeignKey(Integer, "item", "article_id"), index=True)
name = Column(Text, index=True)
value = Column(Text)
class CreatureDrop(Table, table_name="creature_drop"):
creature_id = Column(ForeignKey(Integer, table="creature", column="article_id"), index=True)
item_id = Column(ForeignKey(Integer, table="item", column="article_id"), index=True)
chance = Column(Real)
min = Column(Integer)
max = Column(Integer)
class ItemSound(Table, table_name="item_sound"):
item_id = Column(ForeignKey(Integer, table="item", column="article_id"), index=True)
content = Column(Text)