db/schema.dia

2084 lines
73 KiB
XML

<?xml version="1.0" encoding="UTF-8"?>
<dia:diagram xmlns:dia="http://www.lysator.liu.se/~alla/dia/">
<dia:diagramdata>
<dia:attribute name="background">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="pagebreak">
<dia:color val="#000099ff"/>
</dia:attribute>
<dia:attribute name="paper">
<dia:composite type="paper">
<dia:attribute name="name">
<dia:string>#A4#</dia:string>
</dia:attribute>
<dia:attribute name="tmargin">
<dia:real val="2.8222"/>
</dia:attribute>
<dia:attribute name="bmargin">
<dia:real val="2.8222"/>
</dia:attribute>
<dia:attribute name="lmargin">
<dia:real val="2.8222"/>
</dia:attribute>
<dia:attribute name="rmargin">
<dia:real val="2.8222"/>
</dia:attribute>
<dia:attribute name="is_portrait">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="scaling">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="fitto">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="grid">
<dia:composite type="grid">
<dia:attribute name="dynamic">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="width_x">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="width_y">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="visible_x">
<dia:int val="1"/>
</dia:attribute>
<dia:attribute name="visible_y">
<dia:int val="1"/>
</dia:attribute>
<dia:composite type="color"/>
</dia:composite>
</dia:attribute>
<dia:attribute name="color">
<dia:color val="#d8e5e5ff"/>
</dia:attribute>
<dia:attribute name="guides"/>
<dia:attribute name="guide_color">
<dia:color val="#00ff00ff"/>
</dia:attribute>
<dia:attribute name="display">
<dia:composite type="display">
<dia:attribute name="antialiased">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="snap-to-grid">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="snap-to-guides">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="snap-to-object">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="show-grid">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="show-guides">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="show-connection-points">
<dia:boolean val="true"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:diagramdata>
<dia:layer name="Background" visible="true" connectable="false"/>
<dia:layer name="Background" visible="true" connectable="true" active="true">
<dia:object type="Database - Table" version="0" id="O0">
<dia:attribute name="obj_pos">
<dia:point val="28.5,4.4"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="28.5,4.4;38.655,11.1"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="28.5,4.4"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="10.155000000000001"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="6.6999999999999993"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Claimed_Chars#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#discord_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#lodestone_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#server#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#VARCHAR(20)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#name#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#VARCHAR(30)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#patch#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#DOUBLE#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#last_refresh#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#DATE#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#private#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Table" version="0" id="O1">
<dia:attribute name="obj_pos">
<dia:point val="54.1,8.45"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="54.1,8.45;64.64,15.95"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="54.1,8.45"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="10.539999999999999"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="7.5"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Clears#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#lodestone_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#instance_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#INT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_0#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#date#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#DATE#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#type#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#verified#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#proof#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#VARCHAR(100)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Table" version="0" id="O2">
<dia:attribute name="obj_pos">
<dia:point val="41.35,4.95"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="41.35,4.95;51.505,10.05"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="41.35,4.95"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="10.155000000000001"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="5.0999999999999996"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Clear_Types#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>#prefilled with sync and mine#</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>#autoincrement#</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#discord_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#name#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#VARCHAR(40)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#description#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TEXT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#color#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(6)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O3">
<dia:attribute name="obj_pos">
<dia:point val="38.655,6.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="38.605,5.86;54.2118,11.0118"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="38.655,6.6"/>
<dia:point val="39.3,6.6"/>
<dia:point val="39.3,10.65"/>
<dia:point val="54.1,10.65"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O0" connection="15"/>
<dia:connection handle="1" to="O1" connection="14"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O4">
<dia:attribute name="obj_pos">
<dia:point val="51.505,6.35"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="51.455,5.61;54.2118,14.2118"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="51.505,6.35"/>
<dia:point val="52.8,6.35"/>
<dia:point val="52.8,13.85"/>
<dia:point val="54.1,13.85"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O2" connection="13"/>
<dia:connection handle="1" to="O1" connection="22"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Table" version="0" id="O5">
<dia:attribute name="obj_pos">
<dia:point val="40.55,11.2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="40.55,11.2;51.475,16.3"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="40.55,11.2"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="10.925000000000001"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="5.0999999999999996"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Instances#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#instance_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#INT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#expansion_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#INT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#type_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#INT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#patch#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#DOUBLE#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#community_nick#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#VARCHAR(10)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O6">
<dia:attribute name="obj_pos">
<dia:point val="51.475,12.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="51.425,10.71;54.2118,12.65"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="51.475,12.6"/>
<dia:point val="52.1,12.6"/>
<dia:point val="52.1,11.45"/>
<dia:point val="54.1,11.45"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O5" connection="13"/>
<dia:connection handle="1" to="O1" connection="16"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Table" version="0" id="O7">
<dia:attribute name="obj_pos">
<dia:point val="12.8,2.2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="12.8,2.2;26.035,6.5"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="12.8,2.2"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="13.234999999999999"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="4.3000000000000007"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Settings#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#discord_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#lang#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(2)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#hide_locked#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#hide_community_name#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O8">
<dia:attribute name="obj_pos">
<dia:point val="26.035,3.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="25.985,2.86;28.6118,6.1618"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="26.035,3.6"/>
<dia:point val="27.2675,3.6"/>
<dia:point val="27.2675,5.8"/>
<dia:point val="28.5,5.8"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O7" connection="13"/>
<dia:connection handle="1" to="O0" connection="12"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Table" version="0" id="O9">
<dia:attribute name="obj_pos">
<dia:point val="66.3,6.3"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="66.3,6.3;75.3,15.4"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="66.3,6.3"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="9.0999999999999996"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#Verified_Clears#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>#submitter is not included here#</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#clear_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#min_ilvl#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#no_echo#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#TINYINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_1#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_2#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_3#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_4#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_5#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_6#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#job_7#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#CHARACTER(3)#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O10">
<dia:attribute name="obj_pos">
<dia:point val="64.64,9.85"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="64.59,6.96;66.35,9.9"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="64.64,9.85"/>
<dia:point val="65.47,9.85"/>
<dia:point val="65.47,7.7"/>
<dia:point val="66.3,7.7"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O1" connection="13"/>
<dia:connection handle="1" to="O9" connection="12"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O11">
<dia:attribute name="obj_pos">
<dia:point val="26.035,3.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="25.985,2.86;41.4618,7.5118"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="26.035,3.6"/>
<dia:point val="40.25,3.6"/>
<dia:point val="40.25,7.15"/>
<dia:point val="41.35,7.15"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O7" connection="13"/>
<dia:connection handle="1" to="O2" connection="14"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Table" version="0" id="O12">
<dia:attribute name="obj_pos">
<dia:point val="54.15,3"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="54.15,3;62.765,5.7"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="54.15,3"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="8.6150000000000002"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.7000000000000002"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#View_Settings#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="visible_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="underline_primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="tagging_comment">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="bold_primary_keys">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#lodestone_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
<dia:composite type="table_attribute">
<dia:attribute name="name">
<dia:string>#clear_type_id#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#BIGINT#</dia:string>
</dia:attribute>
<dia:attribute name="comment">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="primary_key">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="nullable">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="unique">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="default_value">
<dia:string>##</dia:string>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="name_font">
<dia:font family="sans" style="80" name="Helvetica-Bold"/>
</dia:attribute>
<dia:attribute name="comment_font">
<dia:font family="sans" style="8" name="Helvetica-Oblique"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="name_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="comment_font_height">
<dia:real val="0.69999999999999996"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="fill_colour">
<dia:color val="#ffffffff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O13">
<dia:attribute name="obj_pos">
<dia:point val="38.655,6.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="38.605,3.66;54.2618,6.65"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="38.655,6.6"/>
<dia:point val="39.3,6.6"/>
<dia:point val="39.3,4.4"/>
<dia:point val="54.15,4.4"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O0" connection="15"/>
<dia:connection handle="1" to="O12" connection="12"/>
</dia:connections>
</dia:object>
<dia:object type="Database - Reference" version="0" id="O14">
<dia:attribute name="obj_pos">
<dia:point val="51.505,6.35"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="51.455,4.46;54.2618,6.4"/>
</dia:attribute>
<dia:attribute name="meta">
<dia:composite type="dict"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="51.505,6.35"/>
<dia:point val="52.8,6.35"/>
<dia:point val="52.8,5.2"/>
<dia:point val="54.15,5.2"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="0"/>
<dia:enum val="1"/>
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="orth_autoroute">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="text_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="line_width">
<dia:real val="0.10000000000000001"/>
</dia:attribute>
<dia:attribute name="line_style">
<dia:enum val="0"/>
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="corner_radius">
<dia:real val="0"/>
</dia:attribute>
<dia:attribute name="end_arrow">
<dia:enum val="22"/>
</dia:attribute>
<dia:attribute name="end_arrow_length">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="end_arrow_width">
<dia:real val="0.5"/>
</dia:attribute>
<dia:attribute name="start_point_desc">
<dia:string>#1#</dia:string>
</dia:attribute>
<dia:attribute name="end_point_desc">
<dia:string>#n#</dia:string>
</dia:attribute>
<dia:attribute name="normal_font">
<dia:font family="monospace" style="0" name="Courier"/>
</dia:attribute>
<dia:attribute name="normal_font_height">
<dia:real val="0.59999999999999998"/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O2" connection="13"/>
<dia:connection handle="1" to="O12" connection="14"/>
</dia:connections>
</dia:object>
<dia:object type="Standard - Text" version="1" id="O15">
<dia:attribute name="obj_pos">
<dia:point val="15.4,7.7"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="15.4,7.015;26.1575,8.69"/>
</dia:attribute>
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
<dia:string>#NOTES:
TINYINT is used to store BOOLEANS#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="sans" style="0" name="Helvetica"/>
</dia:attribute>
<dia:attribute name="height">
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="pos">
<dia:point val="15.4,7.7"/>
</dia:attribute>
<dia:attribute name="color">
<dia:color val="#000000ff"/>
</dia:attribute>
<dia:attribute name="alignment">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="valign">
<dia:enum val="3"/>
</dia:attribute>
</dia:object>
</dia:layer>
</dia:diagram>