mappings.py

# Defines SQL objects.

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, Float, Text, Boolean, String
from sqlalchemy import ForeignKey, UniqueConstraint
from sqlalchemy.orm import relationship

Base = declarative_base()

class Item(Base):
    __tablename__ = "item"

    id = Column(Integer, primary_key=True)
    category = Column(Text)
    subcategory = Column(Text)
    rarity = Column(Integer)
    buy_price = Column(Integer)
    sell_price = Column(Integer)
    carry_limit = Column(Integer)
    points = Column(Integer)

    icon_name = Column(Text)
    icon_color = Column(Text)

    translations = relationship("ItemText")

class ItemText(Base):
    __tablename__ = "item_text"
    id = Column(Integer, ForeignKey('item.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    description = Column(Text)

class ItemCombination(Base):
    __tablename__ = "item_combination"
    id = Column(Integer, primary_key=True)
    result_id = Column(Integer, ForeignKey('item.id'))
    first_id = Column(Integer, ForeignKey('item.id'))
    second_id = Column(Integer, ForeignKey('item.id'))
    quantity = Column(Integer)

class Language(Base):
    __tablename__ = 'language'
    id = Column(Text, primary_key=True)
    name = Column(Text)
    is_complete = Column(Text)

class Location(Base):
    __tablename__ = 'location_text'
    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class LocationItem(Base):
    __tablename__ = 'location_item'

    # note: it is possible for there to be multiple entries of the same thing.
    # therefore, this join-table has no "real id" and uses a surrogate instead
    id = Column(Integer, primary_key=True, autoincrement=True)

    location_id = Column(Integer, ForeignKey("location_text.id"))
    area = Column(Integer)
    rank = Column(Text)
    item_id = Column(Integer, ForeignKey('item.id'), index=True)
    stack = Column(Integer)
    percentage = Column(Integer)
    nodes = Column(Integer, default=1, nullable=False)

class LocationCamp(Base):
    """Defines a location camp and a name entry. 
    As this has limited data, its the text entry as well"""
    __tablename__ = 'location_camp_text'

    # This join-table has no "real id" and uses a surrogate instead
    id = Column(Integer, primary_key=True, autoincrement=True)

    location_id = Column(Integer, ForeignKey("location_text.id"))
    lang_id = Column(Text, ForeignKey('language.id'))
    name = Column(Text)
    area = Column(Integer)

class Monster(Base):
    __tablename__ = 'monster'

    id = Column(Integer, primary_key=True)
    order_id = Column(Integer, unique=True)
    size = Column(Text)
    icon = Column(Text)

    pitfall_trap = Column(Boolean, default=False)
    shock_trap = Column(Boolean, default=False)
    vine_trap = Column(Boolean, default=False)

    has_weakness = Column(Boolean, default=False)
    has_alt_weakness = Column(Boolean, default=False)
    has_alt_weakness = Column(Boolean, default=False)

    weakness_fire = Column(Integer)
    weakness_water = Column(Integer)
    weakness_ice = Column(Integer)
    weakness_thunder = Column(Integer)
    weakness_dragon = Column(Integer)

    weakness_poison = Column(Integer)
    weakness_sleep = Column(Integer)
    weakness_paralysis = Column(Integer)
    weakness_blast = Column(Integer)
    weakness_stun = Column(Integer)

    alt_weakness_fire = Column(Integer)
    alt_weakness_water = Column(Integer)
    alt_weakness_ice = Column(Integer)
    alt_weakness_thunder = Column(Integer)
    alt_weakness_dragon = Column(Integer)

    alt_weakness_poison = Column(Integer)
    alt_weakness_sleep = Column(Integer)
    alt_weakness_paralysis = Column(Integer)
    alt_weakness_blast = Column(Integer)
    alt_weakness_stun = Column(Integer)

    ailment_roar = Column(Text)
    ailment_wind = Column(Text)
    ailment_tremor = Column(Text)
    ailment_defensedown = Column(Boolean)
    ailment_fireblight = Column(Boolean)
    ailment_waterblight = Column(Boolean)
    ailment_thunderblight = Column(Boolean)
    ailment_iceblight = Column(Boolean)
    ailment_dragonblight = Column(Boolean)
    ailment_blastblight = Column(Boolean)
    ailment_regional = Column(Boolean)
    ailment_poison = Column(Boolean)
    ailment_sleep = Column(Boolean)
    ailment_paralysis = Column(Boolean)
    ailment_bleed = Column(Boolean)
    ailment_stun = Column(Boolean)
    ailment_mud = Column(Boolean)
    ailment_effluvia = Column(Boolean)

    translations = relationship("MonsterText")
    hitzones = relationship("MonsterHitzone")
    breaks = relationship("MonsterBreak")
    rewards = relationship("MonsterReward")
    habitats = relationship("MonsterHabitat")

class MonsterText(Base):
    __tablename__ = 'monster_text'

    id = Column(Integer, ForeignKey('monster.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    ecology = Column(Text)
    description = Column(Text)
    alt_state_description = Column(Text)

class MonsterHabitat(Base):
    __tablename__ = 'monster_habitat'
    __table_args__ = (
        UniqueConstraint('monster_id', 'location_id'),
    )
    
    id = Column(Integer, primary_key=True)
    
    monster_id = Column(Integer, ForeignKey('monster.id'), index=True)
    location_id = Column(Integer, ForeignKey('location_text.id'), index=True)
    
    start_area = Column(Text)
    move_area = Column(Text)
    rest_area = Column(Text)

class MonsterHitzone(Base):
    __tablename__ = 'monster_hitzone'

    id = Column(Integer, primary_key=True)

    monster_id = Column(Integer, ForeignKey('monster.id'), index=True)

    cut = Column(Integer)
    impact = Column(Integer)
    shot = Column(Integer)
    fire = Column(Integer)
    water = Column(Integer)
    ice = Column(Integer)
    thunder = Column(Integer)
    dragon = Column(Integer)
    ko = Column(Integer)
    
    translations = relationship("MonsterHitzoneText")

class MonsterHitzoneText(Base):
    __tablename__ = 'monster_hitzone_text'
    id = Column(Integer, ForeignKey('monster_hitzone.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class MonsterBreak(Base):
    __tablename__ = 'monster_break'

    id = Column(Integer, primary_key=True)

    monster_id = Column(Integer, ForeignKey('monster.id'), index=True)

    flinch = Column(Integer)
    wound = Column(Integer)
    sever = Column(Integer)
    extract = Column(Text)

    translations = relationship("MonsterBreakText")

class MonsterBreakText(Base):
    __tablename__ = 'monster_break_text'
    id = Column(Integer, ForeignKey('monster_break.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    part_name = Column(Text)

class MonsterReward(Base):
    __tablename__ = 'monster_reward'
 
    # note: it is possible for there to be multiple entries of the same thing.
    # therefore, this join-table has no "real id" and uses a surrogate instead
    id = Column(Integer, primary_key=True, autoincrement=True)

    monster_id = Column(Integer, ForeignKey('monster.id'), index=True)
    condition_id = Column(Integer, ForeignKey('monster_reward_condition_text.id'))
    
    rank = Column(Text)
    item_id = Column(Integer, ForeignKey('item.id'), index=True)
    
    stack = Column(Integer)
    percentage = Column(Integer)
    
    condition_translations = relationship("MonsterRewardConditionText", uselist=True)

class MonsterRewardConditionText(Base):
    __tablename__ = 'monster_reward_condition_text'
    id = Column(Integer, primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class SkillTree(Base):
    __tablename__ = 'skilltree'

    id = Column(Integer, primary_key=True)
    max_level = Column(Integer)
    icon_color = Column(Text)
    secret = Column(Integer)
    unlocks_id = Column(Integer, ForeignKey('skilltree.id'))

    translations = relationship("SkillTreeText")
    skills = relationship("Skill")

class SkillTreeText(Base):
    __tablename__ = 'skilltree_text'
    id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    description = Column(Text)

class Skill(Base):
    "Represents a skill in a skill tree. These are tied to a language"
    __tablename__ = 'skill'
    skilltree_id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    level = Column(Integer, primary_key=True)
    description = Column(Text)

class ArmorSet(Base):
    __tablename__ = "armorset"
    id = Column(Integer, primary_key=True)
    rank = Column(Text)
    monster_id = Column(Integer, ForeignKey('monster.id'))
    armorset_bonus_id = Column(Integer)

    translations = relationship("ArmorSetText")
    armor = relationship("Armor")

class ArmorSetText(Base):
    __tablename__ = "armorset_text"
    id = Column(Integer, ForeignKey('armorset.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class ArmorSetBonusText(Base):
    __tablename__ = "armorset_bonus_text"
    id = Column(Integer, primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    description = Column(Text)

class ArmorSetBonusSkill(Base):
    __tablename__ = "armorset_bonus_skill"
    setbonus_id = Column(Integer, primary_key=True)
    skilltree_id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    required = Column(Integer)

class Armor(Base):
    __tablename__ = "armor"

    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    rarity = Column(Integer)
    rank = Column(Text)
    armor_type = Column(Text)
    armorset_id = Column(Integer, ForeignKey("armorset.id"))
    armorset_bonus_id = Column(Integer)
    
    recipe_id = Column(ForeignKey("recipe_item.recipe_id"), nullable=True)

    male = Column(Boolean)
    female = Column(Boolean)
    slot_1 = Column(Integer)
    slot_2 = Column(Integer)
    slot_3 = Column(Integer)
    defense_base = Column(Integer)
    defense_max = Column(Integer)
    defense_augment_max = Column(Integer)
    fire = Column(Integer)
    water = Column(Integer)
    thunder = Column(Integer)
    ice = Column(Integer)
    dragon = Column(Integer)

    translations = relationship("ArmorText")
    skills = relationship("ArmorSkill")
    craft_items = relationship("RecipeItem", uselist=True)

    armorset = relationship("ArmorSet", back_populates="armor")

class ArmorText(Base):
    __tablename__ = "armor_text"
    id = Column(Integer, ForeignKey('armor.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class ArmorSkill(Base):
    __tablename__ = 'armor_skill'
    armor_id = Column(Integer, ForeignKey('armor.id'), primary_key=True)
    skilltree_id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    level = Column(Integer)

class Weapon(Base):
    __tablename__ = "weapon"
    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    weapon_type = Column(Text)
    rarity = Column(Integer)
    category = Column(Text)

    previous_weapon_id = Column(ForeignKey("weapon.id"), nullable=True)
    create_recipe_id = Column(ForeignKey('recipe_item.recipe_id'), nullable=True)
    upgrade_recipe_id = Column(ForeignKey('recipe_item.recipe_id'), nullable=True)
    
    attack = Column(Integer)
    attack_true = Column(Integer)
    affinity = Column(Integer)
    defense = Column(Integer)
    slot_1 = Column(Integer)
    slot_2 = Column(Integer)
    slot_3 = Column(Integer)

    element1 = Column(Text)
    element1_attack = Column(Integer)
    element2 = Column(Text)
    element2_attack = Column(Integer)
    element_hidden = Column(Boolean)
    elderseal = Column(Text)

    sharpness = Column(Text)
    sharpness_maxed = Column(Boolean)

    craftable = Column(Boolean, default=False)
    final = Column(Boolean, default=False)

    kinsect_bonus = Column(Text)
    phial = Column(Text)
    phial_power = Column(Integer)
    shelling = Column(Text)
    shelling_level = Column(Integer)
    notes = Column(Text)

    coating_close = Column(Integer)
    coating_power = Column(Integer)
    coating_paralysis = Column(Integer)
    coating_poison = Column(Integer)
    coating_sleep = Column(Integer)
    coating_blast = Column(Integer)

    ammo_id = Column(Integer, ForeignKey('weapon_ammo.id'))
    armorset_bonus_id = Column(Integer)

    translations = relationship("WeaponText")
    ammo = relationship("WeaponAmmo")
    skills = relationship("WeaponSkill")

    # TODO: Find a way to create two relationships: one to craft, one to upgrade.
    # the above will require more sqlalchemy knowledge that unfortunately I don't have.

class WeaponText(Base):
    __tablename__ = "weapon_text"
    id = Column(Integer, ForeignKey('weapon.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class WeaponAmmo(Base):
    __tablename__ = "weapon_ammo"
    id = Column(Integer, primary_key=True)
    deviation = Column(Text)
    special_ammo = Column(Text)
    
    normal1_clip = Column(Integer)
    normal1_rapid = Column(Boolean)
    normal1_recoil = Column(Integer)
    normal1_reload = Column(Text)
    
    normal2_clip = Column(Integer)
    normal2_rapid = Column(Boolean)
    normal2_recoil = Column(Integer)
    normal2_reload = Column(Text)

    normal3_clip = Column(Integer)
    normal3_rapid = Column(Boolean)
    normal3_recoil = Column(Integer)
    normal3_reload = Column(Text)
    
    pierce1_clip = Column(Integer)
    pierce1_rapid = Column(Boolean)
    pierce1_recoil = Column(Integer)
    pierce1_reload = Column(Text)

    pierce2_clip = Column(Integer)
    pierce2_rapid = Column(Boolean)
    pierce2_recoil = Column(Integer)
    pierce2_reload = Column(Text)

    pierce3_clip = Column(Integer)
    pierce3_rapid = Column(Boolean)
    pierce3_recoil = Column(Integer)
    pierce3_reload = Column(Text)
    
    spread1_clip = Column(Integer)
    spread1_rapid = Column(Boolean)
    spread1_recoil = Column(Integer)
    spread1_reload = Column(Text)

    spread2_clip = Column(Integer)
    spread2_rapid = Column(Boolean)
    spread2_recoil = Column(Integer)
    spread2_reload = Column(Text)

    spread3_clip = Column(Integer)
    spread3_rapid = Column(Boolean)
    spread3_recoil = Column(Integer)
    spread3_reload = Column(Text)
    
    sticky1_clip = Column(Integer)
    sticky1_rapid = Column(Boolean)
    sticky1_recoil = Column(Integer)
    sticky1_reload = Column(Text)

    sticky2_clip = Column(Integer)
    sticky2_rapid = Column(Boolean)
    sticky2_recoil = Column(Integer)
    sticky2_reload = Column(Text)

    sticky3_clip = Column(Integer)
    sticky3_rapid = Column(Boolean)
    sticky3_recoil = Column(Integer)
    sticky3_reload = Column(Text)
    
    cluster1_clip = Column(Integer)
    cluster1_rapid = Column(Boolean)
    cluster1_recoil = Column(Integer)
    cluster1_reload = Column(Text)

    cluster2_clip = Column(Integer)
    cluster2_rapid = Column(Boolean)
    cluster2_recoil = Column(Integer)
    cluster2_reload = Column(Text)
    
    cluster3_clip = Column(Integer)
    cluster3_rapid = Column(Boolean)
    cluster3_recoil = Column(Integer)
    cluster3_reload = Column(Text)
    
    recover1_clip = Column(Integer)
    recover1_rapid = Column(Boolean)
    recover1_recoil = Column(Integer)
    recover1_reload = Column(Text)

    recover2_clip = Column(Integer)
    recover2_rapid = Column(Boolean)
    recover2_recoil = Column(Integer)
    recover2_reload = Column(Text)
    
    poison1_clip = Column(Integer)
    poison1_rapid = Column(Boolean)
    poison1_recoil = Column(Integer)
    poison1_reload = Column(Text)

    poison2_clip = Column(Integer)
    poison2_rapid = Column(Boolean)
    poison2_recoil = Column(Integer)
    poison2_reload = Column(Text)
    
    paralysis1_clip = Column(Integer)
    paralysis1_rapid = Column(Boolean)
    paralysis1_recoil = Column(Integer)
    paralysis1_reload = Column(Text)

    paralysis2_clip = Column(Integer)
    paralysis2_rapid = Column(Boolean)
    paralysis2_recoil = Column(Integer)
    paralysis2_reload = Column(Text)
    
    sleep1_clip = Column(Integer)
    sleep1_rapid = Column(Boolean)
    sleep1_recoil = Column(Integer)
    sleep1_reload = Column(Text)

    sleep2_clip = Column(Integer)
    sleep2_rapid = Column(Boolean)
    sleep2_recoil = Column(Integer)
    sleep2_reload = Column(Text)

    exhaust1_clip = Column(Integer)
    exhaust1_rapid = Column(Boolean)
    exhaust1_recoil = Column(Integer)
    exhaust1_reload = Column(Text)

    exhaust2_clip = Column(Integer)
    exhaust2_rapid = Column(Boolean)
    exhaust2_recoil = Column(Integer)
    exhaust2_reload = Column(Text)

    flaming_clip = Column(Integer)
    flaming_rapid = Column(Boolean)
    flaming_recoil = Column(Integer)
    flaming_reload = Column(Text)

    water_clip = Column(Integer)
    water_rapid = Column(Boolean)
    water_recoil = Column(Integer)
    water_reload = Column(Text)
    
    freeze_clip = Column(Integer)
    freeze_rapid = Column(Boolean)
    freeze_recoil = Column(Integer)
    freeze_reload = Column(Text)

    thunder_clip = Column(Integer)
    thunder_rapid = Column(Boolean)
    thunder_recoil = Column(Integer)
    thunder_reload = Column(Text)
    
    dragon_clip = Column(Integer)
    dragon_rapid = Column(Boolean)
    dragon_recoil = Column(Integer)
    dragon_reload = Column(Text)

    slicing_clip = Column(Integer)
    slicing_rapid = Column(Boolean)
    slicing_recoil = Column(Integer)
    slicing_reload = Column(Text)

    wyvern_clip = Column(Integer)
    wyvern_reload = Column(Text)

    demon_clip = Column(Integer)
    demon_recoil = Column(Integer)
    demon_reload = Column(Text)

    armor_clip = Column(Integer)
    armor_recoil = Column(Integer)
    armor_reload = Column(Text)

    tranq_clip = Column(Integer)
    tranq_recoil = Column(Integer)
    tranq_reload = Column(Text)

class WeaponMelody(Base):
    __tablename__ = 'weapon_melody'
    id = Column(Integer, primary_key=True)
    base_duration = Column(Integer)
    base_extension = Column(Integer)
    m1_duration = Column(Integer)
    m1_extension = Column(Integer)
    m2_duration = Column(Integer)
    m2_extension = Column(Integer)
    
    notes = relationship('WeaponMelodyNotes')
    translations = relationship('WeaponMelodyText')

class WeaponMelodyNotes(Base):
    __tablename__ = 'weapon_melody_notes'
    id = Column(Integer, ForeignKey('weapon_melody.id'), primary_key=True)
    notes = Column(Text, primary_key=True)

class WeaponMelodyText(Base):
    __tablename__ = 'weapon_melody_text'
    id = Column(Integer, ForeignKey('weapon_melody.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    effect1 = Column(Text)
    effect2 = Column(Text)

class WeaponSkill(Base):
    __tablename__ = 'weapon_skill'
    weapon_id = Column(Integer, ForeignKey('weapon.id'), primary_key=True)
    skilltree_id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    level = Column(Integer)

class Decoration(Base):
    __tablename__ = 'decoration'

    id = Column(Integer, primary_key=True)
    slot = Column(Integer)
    rarity = Column(Integer)
    icon_color = Column(Text)

    skilltree_id = Column(Integer, ForeignKey("skilltree.id"), nullable=False)
    skilltree_level = Column(Integer, nullable=False)
    skilltree2_id = Column(Integer, ForeignKey("skilltree.id"), nullable=True)
    skilltree2_level = Column(Integer, nullable=True)

    mysterious_feystone_percent = Column(Float)
    glowing_feystone_percent = Column(Float)
    worn_feystone_percent = Column(Float)
    warped_feystone_percent = Column(Float)
    ancient_feystone_percent = Column(Float)
    carved_feystone_percent = Column(Float)
    sealed_feystone_percent = Column(Float)

    translations = relationship("DecorationText")
    
class DecorationText(Base):
    __tablename__ = 'decoration_text'
    id = Column(Integer, ForeignKey('decoration.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class Charm(Base):
    __tablename__ = 'charm'

    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    rarity = Column(Integer)
    
    previous_id = Column(Integer, ForeignKey('charm.id'))
    recipe_id = Column(ForeignKey('recipe_item.recipe_id'), nullable=True)

    skills = relationship('CharmSkill')
    craft_items = relationship('RecipeItem', uselist=True)
    translations = relationship('CharmText')

class CharmSkill(Base):
    __tablename__ = 'charm_skill'
    charm_id = Column(Integer, ForeignKey('charm.id'), primary_key=True)
    skilltree_id = Column(Integer, ForeignKey('skilltree.id'), primary_key=True)
    level = Column(Integer)

class CharmText(Base):
    __tablename__ = 'charm_text'
    id = Column(Integer, ForeignKey('charm.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    description = Column(Text)

class Kinsect(Base):
    __tablename__ = 'kinsect'
    id = Column(Integer, primary_key=True)
    rarity = Column(Integer)
    
    previous_kinsect_id = Column(ForeignKey("kinsect.id"), nullable=True)
    recipe_id = Column(ForeignKey("recipe_item.recipe_id"), nullable=True)

    attack_type = Column(Text)
    dust_effect = Column(Text)
    power = Column(Integer)
    speed = Column(Integer)
    heal = Column(Integer)

    final = Column(Boolean, default=False)

    translations = relationship("KinsectText")
    craft_items = relationship("RecipeItem", uselist=True)

class KinsectText(Base):
    __tablename__ = 'kinsect_text'
    id = Column(Integer, ForeignKey('kinsect.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)

class RecipeItem(Base):
    __tablename__ = 'recipe_item'
    recipe_id = Column(Integer, primary_key=True)
    item_id = Column(Integer, ForeignKey("item.id"), primary_key=True)
    quantity = Column(Integer)

class Quest(Base):
    __tablename__ = 'quest'
    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    category = Column(Text)
    rank = Column(Text)
    stars = Column(Integer)
    stars_raw = Column(Integer)
    quest_type = Column(String)
    location_id = Column(Integer, ForeignKey("location_text.id"))
    zenny = Column(Integer)

    translations = relationship("QuestText")
    monsters = relationship("QuestMonster")
    rewards = relationship("QuestReward")

class QuestText(Base):
    __tablename__ = 'quest_text'
    id = Column(Integer, ForeignKey('quest.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    objective = Column(Text)
    description = Column(Text)

class QuestMonster(Base):
    __tablename__ = 'quest_monster'
    quest_id = Column(Integer, ForeignKey('quest.id'), primary_key=True)
    monster_id = Column(Integer, ForeignKey('monster.id'), primary_key=True)
    quantity = Column(Integer)
    is_objective = Column(Boolean)

class QuestReward(Base):
    __tablename__ = 'quest_reward'
    # note: it is possible for there to be multiple entries of the same thing.
    # therefore, this join-table has no "real id" and uses a surrogate instead
    id = Column(Integer, primary_key=True, autoincrement=True)
    
    quest_id = Column(Integer, ForeignKey('quest.id'), index=True)
    group = Column(String(1))
    item_id = Column(Integer, ForeignKey('item.id'), index=True)
    stack = Column(Integer)
    percentage = Column(Integer)

class Tool(Base):
    __tablename__ = "tool"

    id = Column(Integer, primary_key=True)
    order_id = Column(Integer)
    tool_type = Column(Text)

    duration = Column(Integer)
    duration_upgraded = Column(Integer)
    recharge = Column(Integer)
    
    slot_1 = Column(Integer)
    slot_2 = Column(Integer)
    slot_3 = Column(Integer)

    icon_color = Column(Text)
    translations = relationship("ToolText")

class ToolText(Base):
    __tablename__ = "tool_text"
    id = Column(Integer, ForeignKey('tool.id'), primary_key=True)
    lang_id = Column(Text, ForeignKey('language.id'), primary_key=True)
    name = Column(Text)
    name_base = Column(Text)
    description = Column(Text)