<?xml version="1.0" encoding="UTF-8"?>
<config id="d_and_d_2" name="Monsters of Dungeons and Dragons" db="sqlite:d_and_d.db" language="english" version="1.0.0902" description="Monsters of Dungeons and Dragons">

     <table id="monster" alive="true" lex="monster,monsters,creature,creatures">
        <column id="monster_id" type="int" properties="-project" description="Unique identifier for the monster."/>
        <column id="name" type="text" description="The name of the monster."/>
        <virtual_column id="images" type="text"><![CDATA[
'<a href="https://www.google.com/search?q=' || $VAR.name || ' in dungeons and dragons&udm=2" target ="_blank">' || 'images' || '</a>']]>
        </virtual_column>
        <column id="hp" type="int" description="These are the hit points." lex="hit point,hit points,points"/>
        <column id="ac" type="int" description="Armor Class determines how difficult the monster is to hit." lex="armor class,armor classes,points"/>
        <column id="challenge_rating" type="int" description="Represents the difficulty of the monster in combat." lex="challenge rating,challenge ratings"/>
        <column id="type" type="text" description="Represents monster type."/>
        <column id="size" type="text" description="The size category of the monster." properties="+value-stands-for-table"/>
        <column id="alignment2" type="text" lex="alignment" description="The moral and ethical alignment of the monster."/>
        <column id="strength" type="int" description="Measures the monster’s physical power." lex="strength,strengths,points"/>
        <column id="dexterity" type="int" description="Affects agility, reflexes and balance." lex="dexterity,dexterities,points"/>
        <column id="constitution" type="int" description="Indicates health, stamina and vital force." lex="constitution,constitutions,points"/>
        <column id="intelligence" type="int" description="Reflects mental acuity, memory and reasoning." lex="intelligence,intelligence,points"/>
        <column id="wisdom" type="int" description="Represents perception and insight." lex="wisdom,wisdoms,points"/>
        <column id="charisma" type="int" description="Measures force of personality and leadership." lex="charisma,charismas,points"/>
        <primary_key key="monster_id"/>
        <primary_value key="name"/>
    </table>

    <table id="monster_has_skill" alive="true">
        <column id="cp_row" type="int" properties="-project"/>
        <column id="monster" type="int"/>
        <column id="skill" type="text" properties="+value-stands-for-table"/>
        <primary_key key="cp_row"/>
        <foreign_key from="monster" to="monster"/>
    </table>

    <table id="monster_immune_to_damage" alive="true" lex="record of immunity, records of immunity, immune, immunity">
        <column id="cp_row" type="int" properties="-project"/>
        <column id="monster" type="int"/>
        <column id="damage" type="text"/>
        <primary_key key="cp_row"/>
        <foreign_key from="monster" to="monster"/>
    </table>

    <table id="monster_resistant_to_damage" alive="true" lex="resistance, resistances">
        <column id="cp_row" type="int" properties="-project"/>
        <column id="monster" type="int"/>
        <column id="damage" type="text">
            <value val="fire"/>
        </column>
        <primary_key key="cp_row"/>
        <foreign_key from="monster" to="monster"/>
    </table>

    <table id="monster_susceptile_to_damage" alive="true" lex="vulnerable">
        <column id="cp_row" type="int" properties="-project"/>
        <column id="monster" type="int"/>
        <column id="damage" type="text"/>
        <primary_key key="cp_row"/>
        <foreign_key from="monster" to="monster"/>
    </table>

    <table id="monster_has_trait" alive="true" lex="monster has trait,monsters having trait,monsters have the trait,monsters have trait">
        <column id="monster_has_trait_id" type="int" notnull="true" properties="-project"/>
        <column id="creature" type="int" select="false"/>
        <column id="trait" type="int" select="false"/>
        <primary_key key="monster_has_trait_id"/>
        <foreign_key from="creature" to="monster"/>
        <foreign_key from="trait" to="trait"/>
    </table>

    <table id="trait" alive="true">
        <column id="trait_id" type="int" notnull="true" properties="-project"/>
        <column id="value" type="text"/>
        <column id="description" type="memo"/>
        <primary_key key="trait_id"/>
        <primary_value key="value"/>
    </table>

    <table id="location" writes="full">
        <column id="id" type="int"/>
        <column id="name" type="text"/>
        <column id="description" type="memo"/>
        <primary_key key="id"/>
        <primary_value key="name"/>
    </table>

    <table id="located_in" writes="full">
        <column id="monster" type="int"/>
        <column id="location" type="int"/>
        <foreign_key from="monster" to="monster"/>
        <foreign_key from="location" to="location"/>
    </table>

    <cascade>
        <pre from="above" to="greater than"/>
        <response from="games" to="We do not specifically represent games in this database."/>
    </cascade>
</config>