<?xml version='1.0' encoding='UTF-8'?>
<jiemamy xmlns="http://jiemamy.org/xml/ns/core" version="0.3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jiemamy.org/xml/ns/core http://schema.jiemamy.org/xml/0.3.0/jiemamy-core.xsd">
  <metadata>
    <dialect>org.jiemamy.dialect.mysql.MySqlDialect</dialect>
    <schemaName/>
    <description/>
  </metadata>
  <dbobjects>
    <table id="d353ec45-5b00-4c88-b365-0614949c52a2">
      <name>EMP_TABLE</name>
      <logicalName>社員</logicalName>
      <description/>
      <columns>
        <column id="481a2d55-69ea-4f04-b13a-0a0fcd79b956">
          <name>EMP_NO</name>
          <logicalName>社員番号</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">4</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="69e2b745-da90-40b3-9e09-ac93a7601f35">
          <name>ENAME</name>
          <logicalName>社員名</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>VARCHAR</typeCategory>
              <typeName>VARCHAR</typeName>
            </typeDesc>
            <parameters>
              <parameter key="size">10</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="49041b2a-a3a6-4398-b3c0-ac34db7b356f">
          <name>JOB</name>
          <logicalName>職種</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>VARCHAR</typeCategory>
              <typeName>VARCHAR</typeName>
            </typeDesc>
            <parameters>
              <parameter key="size">9</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="7a9b2545-52cd-4f0f-bdfc-f92b88d40327">
          <name>MGR</name>
          <logicalName> 上司</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">4</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="bc7b76ed-c4ac-448f-acfc-b03360da8e1e">
          <name>HIRE_DATE</name>
          <logicalName>入社日</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>DATE</typeCategory>
              <typeName>DATE</typeName>
            </typeDesc>
          </dataType>
          <defaultValue/>
        </column>
        <column id="fa7dd4d4-838a-48f9-acc1-2e09833e45c1">
          <name>SAL</name>
          <logicalName>給料</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">7</parameter>
              <parameter key="scale">2</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="bdad7a35-322d-4956-ade0-08859daecec9">
          <name>COMM</name>
          <logicalName>歩合給</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">7</parameter>
              <parameter key="scale">2</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="1e4cff84-45c0-47e9-a1e9-b2b0c6b4ebf8">
          <name>DEPT_NO</name>
          <logicalName>部署番号</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">2</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="68595d1d-d89d-47c3-892a-148b9421fbfa">
          <name>TSTAMP</name>
          <logicalName>タイムスタンプ</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>TIMESTAMP</typeCategory>
              <typeName>TIMESTAMP</typeName>
            </typeDesc>
          </dataType>
          <defaultValue/>
        </column>
        <column id="f0c89cf3-c00a-4dee-b85a-a0bdadcedfa3">
          <name>VERSIONNO</name>
          <logicalName>バージョン番号</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">8</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
      </columns>
      <constraints>
        <primaryKey id="00851431-4b60-4392-92b5-cdad4082bbce">
          <keyColumns>
            <columnRef ref="481a2d55-69ea-4f04-b13a-0a0fcd79b956"/>
          </keyColumns>
        </primaryKey>
        <foreignKey id="4e14079d-d0bd-4197-804e-8666940db8bc">
          <name/>
          <keyColumns>
            <columnRef ref="1e4cff84-45c0-47e9-a1e9-b2b0c6b4ebf8"/>
          </keyColumns>
          <referenceColumns>
            <columnRef ref="b7cf2424-e424-4eb2-9885-56c6d81f92a8"/>
          </referenceColumns>
        </foreignKey>
        <notNull id="00e1eb90-848b-41b8-addb-74e9fdb5413c">
          <columnRef ref="f0c89cf3-c00a-4dee-b85a-a0bdadcedfa3"/>
        </notNull>
        <notNull id="485404ae-a12f-4f6e-a2cb-a8d5fce3fc3a">
          <columnRef ref="481a2d55-69ea-4f04-b13a-0a0fcd79b956"/>
        </notNull>
      </constraints>
    </table>
    <table id="2e867e2b-3193-4745-8577-f74c515e1c4b">
      <name>DEPT_TABLE</name>
      <logicalName>部署</logicalName>
      <description/>
      <columns>
        <column id="b7cf2424-e424-4eb2-9885-56c6d81f92a8">
          <name>DEPT_ID</name>
          <logicalName>部署番号</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>INTEGER</typeCategory>
              <typeName>INTEGER</typeName>
            </typeDesc>
            <parameters>
              <parameter key="serial">true</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="82b14de0-b11a-4d04-9d1e-80ff64f408d1">
          <name>DNME</name>
          <logicalName>部署名</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>VARCHAR</typeCategory>
              <typeName>VARCHAR</typeName>
            </typeDesc>
            <parameters>
              <parameter key="size">14</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="5b9093d1-be08-44b1-b5ce-09301d3b6b86">
          <name>LOC</name>
          <logicalName>位置</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>VARCHAR</typeCategory>
              <typeName>VARCHAR</typeName>
            </typeDesc>
            <parameters>
              <parameter key="size">13</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="322172b3-0193-402d-8b12-2ed390af97a2">
          <name>VERSIONNO</name>
          <logicalName>バージョン番号</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">8</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
        <column id="bd79ddda-7da5-4e17-ba20-11f55ae39027">
          <name>ACTIVE</name>
          <logicalName>状態</logicalName>
          <description/>
          <dataType>
            <typeDesc>
              <typeCategory>NUMERIC</typeCategory>
              <typeName>NUMERIC</typeName>
            </typeDesc>
            <parameters>
              <parameter key="precision">1</parameter>
              <parameter key="scale">0</parameter>
            </parameters>
          </dataType>
          <defaultValue/>
        </column>
      </columns>
      <constraints>
        <primaryKey id="cce9c5a5-2c87-414b-862d-3097a9e7352e">
          <keyColumns>
            <columnRef ref="b7cf2424-e424-4eb2-9885-56c6d81f92a8"/>
          </keyColumns>
        </primaryKey>
        <notNull id="46217ce8-7ec2-4ca0-aea6-5ec17a0541cf">
          <columnRef ref="b7cf2424-e424-4eb2-9885-56c6d81f92a8"/>
        </notNull>
      </constraints>
    </table>
  </dbobjects>
  <dataSets/>
  <sql:sqls xmlns:sql="http://jiemamy.org/xml/ns/sql" xsi:schemaLocation="http://jiemamy.org/xml/ns/sql http://schema.jiemamy.org/xml/0.3.0/jiemamy-sql.xsd"/>
  <diagram:diagrams xmlns:diagram="http://jiemamy.org/xml/ns/diagram" xsi:schemaLocation="http://jiemamy.org/xml/ns/diagram http://schema.jiemamy.org/xml/0.3.0/jiemamy-diagram.xsd">
    <diagram:diagram id="4c8bfda6-814d-4b86-9940-185a999788aa">
      <diagram:name>default</diagram:name>
      <diagram:level>ATTRTYPE</diagram:level>
      <diagram:mode>PHYSICAL</diagram:mode>
      <diagram:nodes>
        <diagram:node id="81b58404-d11e-4bad-badb-4883f615a407">
          <diagram:core ref="2e867e2b-3193-4745-8577-f74c515e1c4b"/>
          <diagram:boundary x="439" y="94" width="-1" height="-1"/>
        </diagram:node>
        <diagram:node id="7acc8bbc-55a7-45e9-a33b-a7ded162c5d1">
          <diagram:core ref="d353ec45-5b00-4c88-b365-0614949c52a2"/>
          <diagram:boundary x="80" y="112" width="-1" height="-1"/>
        </diagram:node>
      </diagram:nodes>
      <diagram:connections>
        <diagram:connection id="f41fc758-6c1c-4a0d-888d-822569bd4eca">
          <diagram:core ref="4e14079d-d0bd-4197-804e-8666940db8bc"/>
          <diagram:source ref="7acc8bbc-55a7-45e9-a33b-a7ded162c5d1"/>
          <diagram:target ref="81b58404-d11e-4bad-badb-4883f615a407"/>
          <diagram:bendpoints/>
        </diagram:connection>
      </diagram:connections>
    </diagram:diagram>
  </diagram:diagrams>
</jiemamy>
