svnno****@sourc*****
svnno****@sourc*****
2008年 12月 15日 (月) 22:44:43 JST
Revision: 1610
http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1610
Author: shinsuke
Date: 2008-12-15 22:44:43 +0900 (Mon, 15 Dec 2008)
Log Message:
-----------
added files for mysql.
Added Paths:
-----------
addresslist/trunk/src/main/config/erd/mysql/
addresslist/trunk/src/main/config/erd/mysql/addresslist.erd
addresslist/trunk/src/main/config/sql/mysql/
addresslist/trunk/src/main/config/sql/mysql/addresslist.ddl
-------------- next part --------------
Added: addresslist/trunk/src/main/config/erd/mysql/addresslist.erd
===================================================================
--- addresslist/trunk/src/main/config/erd/mysql/addresslist.erd (rev 0)
+++ addresslist/trunk/src/main/config/erd/mysql/addresslist.erd 2008-12-15 13:44:43 UTC (rev 1610)
@@ -0,0 +1,1923 @@
+<?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>407</x>
+ <y>1315</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>1835</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>757</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>586</x>
+ <y>1835</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>594</x>
+ <y>757</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_person_user_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>false</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>person</tableName>
+ <logicalName>Person</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>19</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="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>given_name</columnName>
+ <logicalName>Given 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>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 Description</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="../../../../references/entry/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[4]/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="../../../../references/entry/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>name_prefix</columnName>
+ <logicalName>Name Prefix</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>30</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>name_suffix</columnName>
+ <logicalName>Name Suffix</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>30</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" reference="../../../../references/entry/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>job_title</columnName>
+ <logicalName>Job Title</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/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>is_public</columnName>
+ <logicalName>Is Public?</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </columnType>
+ <size>1</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue>'T'</defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>company_id</columnName>
+ <logicalName>company_id</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>BIGINT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>true</supportSize>
+ <type>-5</type>
+ </columnType>
+ <size>19</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">
+ <name>TIMESTAMP</name>
+ <logicalName>Datetime</logicalName>
+ <supportSize>false</supportSize>
+ <type>93</type>
+ </columnType>
+ <size>23</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[16]/columnType"/>
+ <size>23</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>1</defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>432</x>
+ <y>275</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_person_to_company</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[13]/columnType"/>
+ <size>19</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[13]"/>
+ </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>company</tableName>
+ <logicalName>Company</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>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>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>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>name_desc</columnName>
+ <logicalName>Name Description</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>department</columnName>
+ <logicalName>Department</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>building</columnName>
+ <logicalName>Blg.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>street</columnName>
+ <logicalName>Street</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>city</columnName>
+ <logicalName>City</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>state</columnName>
+ <logicalName>State</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>postal_code</columnName>
+ <logicalName>Postal Code</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/columnType"/>
+ <size>30</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>country</columnName>
+ <logicalName>Country</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>telephone1</columnName>
+ <logicalName>Telephone 1</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>telephone2</columnName>
+ <logicalName>Telephone 2</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>fax1</columnName>
+ <logicalName>FAX 1</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>fax2</columnName>
+ <logicalName>FAX 2</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>url</columnName>
+ <logicalName>URL</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[4]/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>is_public</columnName>
+ <logicalName>Is Public?</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/columnType"/>
+ <size>1</size>
+ <notNull>false</notNull>
+ <primaryKey>false</primaryKey>
+ <description></description>
+ <autoIncrement>false</autoIncrement>
+ <defaultValue>'T'</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[14]/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="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>23</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="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[16]/columnType"/>
+ <size>23</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>1</defaultValue>
+ </net.java.amateras.db.visual.model.ColumnModel>
+ </columns>
+ <indices/>
+ <constraint>
+ <x>305</x>
+ <y>757</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_company_user_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>
+ </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 reference="../../.."/>
+ </sourceConnections>
+ <targetConnections>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_custom_to_person</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>person_id</columnName>
+ <logicalName>Person ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>BIGINT</name>
+ <logicalName>Integer</logicalName>
+ <supportSize>true</supportSize>
+ <type>-5</type>
+ </columnType>
+ <size>19</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>custom</tableName>
+ <logicalName>Custom</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" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/>
+ <size>19</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="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>value</columnName>
+ <logicalName>Value</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>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>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>255</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>181</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <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>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_contact_to_person</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>person_id</columnName>
+ <logicalName>Person ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[13]/columnType"/>
+ <size>19</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>contact</tableName>
+ <logicalName>Contact</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" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[13]/columnType"/>
+ <size>19</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="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/>
+ <net.java.amateras.db.visual.model.ColumnModel>
+ <columnName>name</columnName>
+ <logicalName>Name</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType">
+ <name>VARCHAR</name>
+ <logicalName>String</logicalName>
+ <supportSize>true</supportSize>
+ <type>12</type>
+ </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>
+ <columnName>value</columnName>
+ <logicalName>Value</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>449</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <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>
+ <net.java.amateras.db.visual.model.ForeignKeyModel>
+ <foreignKeyName>FK_from_postal_to_person</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>person_id</columnName>
+ <logicalName>Person ID</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[13]/columnType"/>
+ <size>19</size>
+ <notNull>true</notNull>
+ <primaryKey>true</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>postal</tableName>
+ <logicalName>Postal</logicalName>
+ <description></description>
+ <columns>
+ <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>building</columnName>
+ <logicalName>Blg.</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>street</columnName>
+ <logicalName>Street</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>city</columnName>
+ <logicalName>City</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>state</columnName>
+ <logicalName>State</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/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>postal_code</columnName>
+ <logicalName>Postal Code</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/columnType"/>
+ <size>30</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>country</columnName>
+ <logicalName>Country</logicalName>
+ <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[12]/columnType"/>
+ <size>100</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>717</x>
+ <y>40</y>
+ <width>-1</width>
+ <height>-1</height>
+ </constraint>
+ <sourceConnections>
+ <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>
+ </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/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/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel/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/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/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"/>
+ <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/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: addresslist/trunk/src/main/config/sql/mysql/addresslist.ddl
===================================================================
--- addresslist/trunk/src/main/config/sql/mysql/addresslist.ddl (rev 0)
+++ addresslist/trunk/src/main/config/sql/mysql/addresslist.ddl 2008-12-15 13:44:43 UTC (rev 1610)
@@ -0,0 +1,196 @@
+DROP TABLE postal;
+DROP TABLE contact;
+DROP TABLE custom;
+DROP TABLE person;
+DROP TABLE company;
+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: Company
+**********************************/
+CREATE TABLE company(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255),
+ name VARCHAR(200),
+ name_desc VARCHAR(200),
+ department VARCHAR(200),
+ building VARCHAR(200),
+ street VARCHAR(200),
+ city VARCHAR(100),
+ state VARCHAR(100),
+ postal_code VARCHAR(30),
+ country VARCHAR(200),
+ telephone1 VARCHAR(40),
+ telephone2 VARCHAR(40),
+ fax1 VARCHAR(40),
+ fax2 VARCHAR(40),
+ url VARCHAR(255),
+ is_public VARCHAR(1) DEFAULT 'T',
+ 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 DEFAULT 1,
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Person
+**********************************/
+CREATE TABLE person(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ user_id VARCHAR(255),
+ given_name VARCHAR(100),
+ given_name_desc VARCHAR(100),
+ family_name VARCHAR(100),
+ family_name_desc VARCHAR(100),
+ middle_name VARCHAR(50),
+ name_prefix VARCHAR(30),
+ name_suffix VARCHAR(30),
+ nickname VARCHAR(100),
+ job_title VARCHAR(50),
+ is_public VARCHAR(1) DEFAULT 'T',
+ company_id BIGINT(19),
+ 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 DEFAULT 1,
+ FOREIGN KEY (company_id) REFERENCES company (id),
+ FOREIGN KEY (user_id) REFERENCES user_info (user_id)
+);
+
+/**********************************
+Table Name: Custom
+**********************************/
+CREATE TABLE custom(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ person_id BIGINT(19) NOT NULL,
+ value VARCHAR(255),
+ sort_order INTEGER NOT NULL,
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+
+/**********************************
+Table Name: Contact
+**********************************/
+CREATE TABLE contact(
+ id BIGINT(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ person_id BIGINT(19) NOT NULL,
+ name VARCHAR(20) NOT NULL,
+ value VARCHAR(255),
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+
+/**********************************
+Table Name: Postal
+**********************************/
+CREATE TABLE postal(
+ person_id BIGINT(19) NOT NULL PRIMARY KEY,
+ building VARCHAR(200),
+ street VARCHAR(200),
+ city VARCHAR(100),
+ state VARCHAR(100),
+ postal_code VARCHAR(30),
+ country VARCHAR(100),
+ FOREIGN KEY (person_id) REFERENCES person (id)
+);
+