[pal-cvs 2773] [525] added fk for whos_online.

svnno****@sourc***** svnno****@sourc*****
2007年 9月 3日 (月) 15:40:28 JST


Revision: 525
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=525
Author:   shinsuke
Date:     2007-09-03 15:40:28 +0900 (Mon, 03 Sep 2007)

Log Message:
-----------
added fk for whos_online. fixed product_id type on some tables.

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-03 06:36:05 UTC (rev 524)
+++ pompei/portlets/pompei-core/trunk/src/main/config/pompei.clay	2007-09-03 06:40:28 UTC (rev 525)
@@ -9,7 +9,7 @@
 <table-list>
 <table alias="" name="ADDRESS_BOOK" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="813" y="16"/>
+<table-figure-bounds height="-1" width="-1" x="962" y="9"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="ADDRESS_BOOK_ID" remarks="">
 <column-description></column-description>
@@ -26,8 +26,8 @@
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="ENTRY_GENDER" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="32" decimal-digits="0" default-value="" mandatory="false" name="ENTRY_COMPANY" remarks="">
@@ -239,36 +239,36 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="NULL" mandatory="false" name="EXPIRES_DATE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="NULL" mandatory="false" name="DATE_SCHEDULED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="NULL" mandatory="false" name="DATE_STATUS_CHANGE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -323,9 +323,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="BANNERS_HISTORY_DATE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -382,18 +382,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -517,18 +517,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -621,8 +621,8 @@
 <column alias="" auto-increment="false" column-size="8" decimal-digits="0" default-value="" mandatory="false" name="STARTDATE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="COUNTER" remarks="">
@@ -646,8 +646,8 @@
 <column alias="" auto-increment="false" column-size="8" decimal-digits="0" default-value="" mandatory="false" name="MONTH" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="COUNTER" remarks="">
@@ -666,7 +666,7 @@
 </table>
 <table alias="" name="COUNTRIES" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="1248" y="67"/>
+<table-figure-bounds height="-1" width="-1" x="1281" y="5"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="COUNTRIES_ID" remarks="">
 <column-description></column-description>
@@ -683,15 +683,15 @@
 <column alias="" auto-increment="false" column-size="2" decimal-digits="0" default-value="" mandatory="true" name="COUNTRIES_ISO_CODE_2" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="" mandatory="true" name="COUNTRIES_ISO_CODE_3" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="ADDRESS_FORMAT_ID" remarks="">
@@ -716,7 +716,7 @@
 </table>
 <table alias="" name="CURRENCIES" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="847" y="648"/>
+<table-figure-bounds height="-1" width="-1" x="1079" y="4015"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CURRENCIES_ID" remarks="">
 <column-description></column-description>
@@ -733,8 +733,8 @@
 <column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="" mandatory="true" name="CODE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="12" decimal-digits="0" default-value="" mandatory="false" name="SYMBOL_LEFT" remarks="">
@@ -752,22 +752,22 @@
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="false" name="DECIMAL_POINT" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="false" name="THOUSANDS_POINT" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="false" name="DECIMAL_PLACES" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="52" decimal-digits="0" default-value="" mandatory="false" name="VALUE" remarks="">
@@ -779,9 +779,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_UPDATED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -801,7 +801,7 @@
 </table>
 <table alias="" name="CUSTOMERS" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="20" y="43"/>
+<table-figure-bounds height="-1" width="-1" x="10" y="31"/>
 <column-list>
 <column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="AUTOINCREMENT: start 1 increment 1" mandatory="true" name="CUSTOMERS_ID" remarks="">
 <column-description></column-description>
@@ -818,8 +818,8 @@
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_GENDER" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="32" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_FIRSTNAME" remarks="">
@@ -837,9 +837,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="'0000-00-00 00:00:00'" mandatory="true" name="CUSTOMERS_DOB" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -876,8 +876,8 @@
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="false" name="CUSTOMERS_NEWSLETTER" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -914,10 +914,10 @@
 <variant type-name-pattern="INTEGER"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="254" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
+<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
+<variant type-name-pattern="INTEGER"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_BASKET_QUANTITY" remarks="">
@@ -929,16 +929,16 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="false" name="FINAL_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="8" decimal-digits="0" default-value="" mandatory="false" name="CUSTOMERS_BASKET_DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -986,10 +986,10 @@
 <variant type-name-pattern="INTEGER"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="32700" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_ID" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
-<variant precision-max="254" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
+<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
+<variant type-name-pattern="INTEGER"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_OPTIONS_ID" remarks="">
@@ -1049,7 +1049,7 @@
 </table>
 <table alias="" name="CUSTOMERS_INFO" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="28" y="3667"/>
+<table-figure-bounds height="-1" width="-1" x="471" y="204"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="CUSTOMERS_INFO_ID" remarks="">
 <column-description></column-description>
@@ -1060,9 +1060,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="CUSTOMERS_INFO_DATE_OF_LAST_LOGON" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1075,18 +1075,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="CUSTOMERS_INFO_DATE_ACCOUNT_CREATED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="CUSTOMERS_INFO_DATE_ACCOUNT_LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1102,7 +1102,15 @@
 <primary-key-column name="CUSTOMERS_INFO_ID"/>
 </primary-key>
 <unique-key-list/>
-<foreign-key-list/>
+<foreign-key-list>
+<foreign-key alias="" name="FK_CUSTOMERS_INFO_1" on-delete="" on-update="" referenced-key="SQL070831021755080" referenced-table="CUSTOMERS" referenced-table-schema="APP" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="">
+<foreign-key-description></foreign-key-description>
+<foreign-key-figure>
+<fk-fig-bendpoint-list/>
+</foreign-key-figure>
+<foreign-key-column column-name="CUSTOMERS_INFO_ID" referenced-key-column-name="CUSTOMERS_ID"/>
+</foreign-key>
+</foreign-key-list>
 <index-list>
 <index alias="" name="SQL070831021755220" remarks="" unique="true">
 <index-description></index-description>
@@ -1141,18 +1149,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1235,7 +1243,7 @@
 </table>
 <table alias="" name="GEO_ZONES" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="324" y="461"/>
+<table-figure-bounds height="-1" width="-1" x="320" y="539"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="GEO_ZONE_ID" remarks="">
 <column-description></column-description>
@@ -1258,18 +1266,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1306,8 +1314,8 @@
 <column alias="" auto-increment="false" column-size="2" decimal-digits="0" default-value="" mandatory="true" name="CODE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="64" decimal-digits="0" default-value="" mandatory="false" name="IMAGE" remarks="">
@@ -1367,18 +1375,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1439,9 +1447,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_LAST_CLICK" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1511,18 +1519,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_SENT" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1811,18 +1819,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_PURCHASED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -1835,25 +1843,25 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="ORDERS_DATE_FINISHED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="" mandatory="false" name="CURRENCY" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="14" decimal-digits="6" default-value="" mandatory="false" name="CURRENCY_VALUE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 </column-list>
@@ -1951,25 +1959,25 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="PRODUCTS_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="FINAL_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="7" decimal-digits="4" default-value="" mandatory="true" name="PRODUCTS_TAX" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_QUANTITY" remarks="">
@@ -2052,16 +2060,16 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="OPTIONS_VALUES_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="PRICE_PREFIX" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -2231,9 +2239,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -2306,9 +2314,9 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="VALUE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="32" decimal-digits="0" default-value="" mandatory="true" name="OT_CLASS" remarks="">
@@ -2376,44 +2384,44 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="PRODUCTS_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="PRODUCTS_DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="PRODUCTS_LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="PRODUCTS_DATE_AVAILABLE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="5" decimal-digits="2" default-value="" mandatory="true" name="PRODUCTS_WEIGHT" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="PRODUCTS_STATUS" remarks="">
@@ -2504,16 +2512,16 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="OPTIONS_VALUES_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="PRICE_PREFIX" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
+<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 <variant type-name-pattern="CHAR"/>
-<variant precision-max="2000" precision-min="1" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
 </data-type>
 </column>
 </column-list>
@@ -2686,9 +2694,9 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -2958,18 +2966,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -3109,44 +3117,44 @@
 <column alias="" auto-increment="false" column-size="15" decimal-digits="4" default-value="" mandatory="true" name="SPECIALS_NEW_PRODUCTS_PRICE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="SPECIALS_DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="SPECIALS_LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="EXPIRES_DATE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="DATE_STATUS_CHANGE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -3180,7 +3188,7 @@
 </table>
 <table alias="" name="TAX_CLASS" remarks="">
 <table-description></table-description>
-<table-figure-bounds height="-1" width="-1" x="390" y="331"/>
+<table-figure-bounds height="-1" width="-1" x="262" y="378"/>
 <column-list>
 <column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="TAX_CLASS_ID" remarks="">
 <column-description></column-description>
@@ -3203,18 +3211,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -3263,9 +3271,9 @@
 <column alias="" auto-increment="false" column-size="7" decimal-digits="4" default-value="" mandatory="true" name="TAX_RATE" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="3" name="DECIMAL" selected-variant-pattern="DECIMAL(%p,%s)">
+<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 <variant type-name-pattern="DECIMAL"/>
 <variant precision-max="38" precision-min="1" precision-variable="%p" type-name-pattern="DECIMAL(%p)"/>
-<variant precision-max="38" precision-min="1" precision-variable="%p" scale-max="127" scale-min="-84" scale-variable="%s" type-name-pattern="DECIMAL(%p,%s)"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="true" name="TAX_DESCRIPTION" remarks="">
@@ -3277,18 +3285,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
@@ -3373,12 +3381,6 @@
 </primary-key>
 <unique-key-list/>
 <foreign-key-list>
-<foreign-key alias="" name="FK_WHOS_ONLINE_2" on-delete="" on-update="" referenced-key="PK_WHOS_ONLINE" referenced-table="WHOS_ONLINE" referenced-table-schema="APP" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="">
-<foreign-key-description></foreign-key-description>
-<foreign-key-figure>
-<fk-fig-bendpoint-list/>
-</foreign-key-figure>
-</foreign-key>
 <foreign-key alias="" name="FK_WHOS_ONLINE_1" on-delete="" on-update="" referenced-key="SQL070831021755080" referenced-table="CUSTOMERS" referenced-table-schema="APP" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="">
 <foreign-key-description></foreign-key-description>
 <foreign-key-figure>
@@ -3470,18 +3472,18 @@
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="false" name="LAST_MODIFIED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="26" decimal-digits="6" default-value="" mandatory="true" name="DATE_ADDED" remarks="">
 <column-description></column-description>
 <data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%p)">
+<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant type-name-pattern="TIMESTAMP"/>
 <variant type-name-pattern="TIMESTAMP WITH TIME ZONE"/>
-<variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p)"/>
 <variant precision-max="9" precision-min="1" precision-variable="%p" type-name-pattern="TIMESTAMP(%p) WITH TIME ZONE"/>
 </data-type>
 </column>


pal-cvs メーリングリストの案内