svnno****@sourc*****
svnno****@sourc*****
2008年 12月 15日 (月) 22:49:10 JST
Revision: 1616
http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1616
Author: shinsuke
Date: 2008-12-15 22:49:10 +0900 (Mon, 15 Dec 2008)
Log Message:
-----------
added files for mysql.
Added Paths:
-----------
todolist/trunk/src/main/config/erd/mysql/
todolist/trunk/src/main/config/erd/mysql/todolist.erd
todolist/trunk/src/main/config/sql/mysql/
todolist/trunk/src/main/config/sql/mysql/todolist.ddl
-------------- next part --------------
Added: todolist/trunk/src/main/config/erd/mysql/todolist.erd
===================================================================
--- todolist/trunk/src/main/config/erd/mysql/todolist.erd (rev 0)
+++ todolist/trunk/src/main/config/erd/mysql/todolist.erd 2008-12-15 13:49:10 UTC (rev 1616)
@@ -0,0 +1,1574 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<net.java.amateras.db.visual.model.RootModel>
+ <children>
+ <net.java.amateras.db.visual.model.TableModel>
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>user_info</tableName>
+ <logicalName>User Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>given_name</columnName>
+ <logicalName>Given Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>family_name</columnName>
+ <logicalName>Family Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>middle_name</columnName>
+ <logicalName>Middle Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>50</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>given_name_desc</columnName>
+ <logicalName>Given Name Descritpion</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>family_name_desc</columnName>
+ <logicalName>Family Name Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>nickname</columnName>
+ <logicalName>Nickname</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>gender</columnName>
+ <logicalName>Gender</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>1</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>birth_date</columnName>
+ <logicalName>Birth Date</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>DATE</name>
+ <logicalName>Date</logicalName>
+ <supportSize>false</supportSize>
+ <type>91</type>
+ </columnType>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>locale</columnName>
+ <logicalName>Locale</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>5</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Default Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Default Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>TIMESTAMP</name>
+ <logicalName>Datetime</logicalName>
+ <supportSize>false</supportSize>
+ <type>93</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>566</x>
+ <y>757</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_user_to_group</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[15]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>group_info</tableName>
+ <logicalName>Group Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>description</columnName>
+ <logicalName>Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[22]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>40</x>
+ <y>1277</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections/>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_group</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>group_id</columnName>
+ <logicalName>Group ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>group_mapping</tableName>
+ <logicalName>Group Mapping</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>44</x>
+ <y>389</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </sourceConnections>
+ <targetConnections/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </source>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_user_to_role</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[14]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>role_info</tableName>
+ <logicalName>Role Information</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>description</columnName>
+ <logicalName>Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>email</columnName>
+ <logicalName>Email</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>telephone</columnName>
+ <logicalName>Telephone</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>40</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[22]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>864</x>
+ <y>1277</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections/>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_role</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>role_id</columnName>
+ <logicalName>Role ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>role_mapping</tableName>
+ <logicalName>Role Mapping</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>872</x>
+ <y>389</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </sourceConnections>
+ <targetConnections/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </source>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </sourceConnections>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>todo_mapping</tableName>
+ <logicalName>ToDo Mapping</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>BIGINT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>true</supportSize>
+ <type>-5</type>
+ </columnType>
+ <size>20</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>status</columnName>
+ <logicalName>Status</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>memo</columnName>
+ <logicalName>Memo</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>todo_id</columnName>
+ <logicalName>ToDo ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>20</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>category_id</columnName>
+ <logicalName>Category ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>20</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>TIMESTAMP</name>
+ <logicalName>Datetime</logicalName>
+ <supportSize>false</supportSize>
+ <type>93</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>580</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_todo</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel/columnType"/>
+ <size>20</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[4]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>todo</tableName>
+ <logicalName>ToDo</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>description</columnName>
+ <logicalName>Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>200</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>priority</columnName>
+ <logicalName>Priority</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[13]/columnType"/>
+ <size>50</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>status</columnName>
+ <logicalName>Status</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[13]/columnType"/>
+ <size>100</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>start_date</columnName>
+ <logicalName>Start Date</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>100</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>end_date</columnName>
+ <logicalName>End Date</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[7]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>versionNo</columnName>
+ <logicalName>Version No.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[22]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>305</x>
+ <y>389</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_todo_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[9]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </sourceConnections>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_mapping_to_category</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>id</columnName>
+ <logicalName>ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>BIGINT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>true</supportSize>
+ <type>-5</type>
+ </columnType>
+ <size>20</size>
+ <notNull>true</notNull>
+ <primaryKey>true</primaryKey>
+ <description></description>
+ <autoIncrement>true</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[6]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel">
+ <error></error>
+ <linkedPath></linkedPath>
+ <tableName>todo_category</tableName>
+ <logicalName>ToDo Category</logicalName>
+ <description></description>
+ <columns>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>100</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>sort_order</columnName>
+ <logicalName>Sort Order</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>INTEGER</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>false</supportSize>
+ <type>4</type>
+ </columnType>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue>1</defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>user_id</columnName>
+ <logicalName>User ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_time</columnName>
+ <logicalName>Created Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>created_by</columnName>
+ <logicalName>Created By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_time</columnName>
+ <logicalName>Updated Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>updated_by</columnName>
+ <logicalName>Updated By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>true</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_time</columnName>
+ <logicalName>Deleted Time</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>10</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>deleted_by</columnName>
+ <logicalName>Deleted By</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>255</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue></defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>583</x>
+ <y>389</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_category_to_user</foreignKeyName>
+ <references>
+ <entry>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
+ <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[4]"/>
+ </entry>
+ </references>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </sourceConnections>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </target>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ </sourceConnections>
+ <targetConnections/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </source>
+ <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.ForeignKeyModel>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../net.java.amateras.db.visual.model.ForeignKeyModel[3]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[3]/target/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ <net.java.amateras.db.visual.model.ForeignKeyModel reference="../net.java.amateras.db.visual.model.ForeignKeyModel[3]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/>
+ </targetConnections>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+ </net.java.amateras.db.visual.model.TableModel>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[3]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[3]/source"/>
+ <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[3]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[3]/target"/>
+ </children>
+ <dommains/>
+ <dialectName>MySQL</dialectName>
+ <logicalMode>false</logicalMode>
+ <jarFile></jarFile>
+ <jdbcDriver>sun.jdbc.odbc.JdbcOdbc</jdbcDriver>
+ <jdbcUrl></jdbcUrl>
+ <jdbcUser></jdbcUser>
+ <jdbcPassword></jdbcPassword>
+ <jdbcSchema></jdbcSchema>
+ <jdbcCatalog></jdbcCatalog>
+ <includeView>false</includeView>
+ <listeners serialization="custom">
+ <java.beans.PropertyChangeSupport>
+ <default>
+ <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion>
+ <source class="net.java.amateras.db.visual.model.RootModel" reference="../../../.."/>
+ </default>
+ <null/>
+ </java.beans.PropertyChangeSupport>
+ </listeners>
+</net.java.amateras.db.visual.model.RootModel>
\ No newline at end of file
Added: todolist/trunk/src/main/config/sql/mysql/todolist.ddl
===================================================================
--- todolist/trunk/src/main/config/sql/mysql/todolist.ddl (rev 0)
+++ todolist/trunk/src/main/config/sql/mysql/todolist.ddl 2008-12-15 13:49:10 UTC (rev 1616)
@@ -0,0 +1,159 @@
+DROP TABLE todo_mapping;
+DROP TABLE todo_category;
+DROP TABLE todo;
+DROP TABLE role_mapping;
+DROP TABLE group_mapping;
+DROP TABLE user_info;
+DROP TABLE role_info;
+DROP TABLE group_info;
+
+/**********************************
+Table Name: Group Information
+**********************************/
+CREATE TABLE group_info(
+ group_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ name VARCHAR(100),
+ description VARCHAR(255),
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL
+);
+
+/**********************************
+Table Name: Role Information
+**********************************/
+CREATE TABLE role_info(
+ role_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ name VARCHAR(100),
+ description VARCHAR(255),
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL
+);
+
+/**********************************
+Table Name: User Information
+**********************************/
+CREATE TABLE user_info(
+ user_id VARCHAR(255) NOT NULL PRIMARY KEY,
+ given_name VARCHAR(100),
+ family_name VARCHAR(100),
+ middle_name VARCHAR(50),
+ given_name_desc VARCHAR(100),
+ family_name_desc VARCHAR(100),
+ nickname VARCHAR(100),
+ gender VARCHAR(1),
+ birth_date DATE,
+ email VARCHAR(255),
+ url VARCHAR(255),
+ telephone VARCHAR(40),
+ locale VARCHAR(5),
+ role_id VARCHAR(255),
+ group_id VARCHAR(255),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (group_id) REFERENCES group_info (group_id),
+ FOREIGN KEY (role_id) REFERENCES role_info (role_id)
+);
+
+/**********************************
+Table Name: Group Mapping
+**********************************/
+CREATE TABLE group_mapping(
+ id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255) NOT NULL,
+ group_id VARCHAR(255) NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (group_id) REFERENCES group_info (group_id)
+);
+
+/**********************************
+Table Name: Role Mapping
+**********************************/
+CREATE TABLE role_mapping(
+ id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255) NOT NULL,
+ role_id VARCHAR(255) NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (role_id) REFERENCES role_info (role_id)
+);
+
+/**********************************
+Table Name: ToDo
+**********************************/
+CREATE TABLE todo(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ description VARCHAR(200),
+ priority INTEGER NOT NULL,
+ status INTEGER NOT NULL,
+ start_date TIMESTAMP,
+ end_date TIMESTAMP,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (created_by) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: ToDo Category
+**********************************/
+CREATE TABLE todo_category(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ name VARCHAR(100) NOT NULL,
+ sort_order INTEGER NOT NULL DEFAULT 1,
+ user_id VARCHAR(255) NOT NULL,
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: ToDo Mapping
+**********************************/
+CREATE TABLE todo_mapping(
+ id BIGINT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ status INT NOT NULL,
+ memo VARCHAR(255),
+ todo_id BIGINT(20) NOT NULL,
+ user_id VARCHAR(255) NOT NULL,
+ category_id BIGINT(20),
+ created_time TIMESTAMP NOT NULL,
+ created_by VARCHAR(255) NOT NULL,
+ updated_time TIMESTAMP NOT NULL,
+ updated_by VARCHAR(255) NOT NULL,
+ deleted_time TIMESTAMP,
+ deleted_by VARCHAR(255),
+ versionNo INTEGER NOT NULL,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id),
+ FOREIGN KEY (todo_id) REFERENCES todo (id),
+ FOREIGN KEY (category_id) REFERENCES todo_category (id)
+);
+